family budget project - Financial ToolBoxes(Gray-shaded boxes are the outputs based on the given inputs above them Do not type in the shaded boxes APR

family budget project - Financial ToolBoxes(Gray-shaded...

This preview shows page 1 - 4 out of 16 pages.

Financial ToolBoxes(Gray-shaded boxes are the outputs based on the given inputs above them. Do not type in the shaded boxes.)APR5.00%APR18.00%APR10.00%Compounds12Compounds12Compounds12Present Value0.00Present Value1200.00Payment-25Payment75.00Payment-24Present Value-250.00Years30Future Value0Years45Future Value:($62,419.40)Years:7.8 Investment Interest:$270,401.09 APR18.00%APR8.25%APR9.00%Compounds12Compounds12Compounds12Present Value1200Future Value0.00Original # of Payments360Future Value0Payment-300.00Present Value60000.00Years2Years10Years30Payment:($59.91)Present Value:$24,459.32 Debt Interest:($113,798.49)APR3.25%APY5.57%Compounds4Compounds12Effective Yield (APY):3.29%Nominal Yield (APR):5.43%So that you can see all of the formulas of the gray boxes at once, they are listed here for your convenience:Future Value:Years:Savings Interest:Payment:Present Value:=PV(F13/F14,F17*F14,F16,F15)Debt Interest:Effective Yield:=(1+C21/C22)^C22-1Nominal Yield:Why the Negative? (Rules of Thumb):1. Notice that present value and future value are always opposite in sign.2. Use the "Inflow-Outflow" way of thinking: Inflow is money "coming in the door" and outflow is money "going out".3. If all else fails, try changing the sign of any of the inputs to see how it affects the result and act accordingly.4. Don't get "burned" by the negative or lack of a negative. In other words, always keep it in the back of your mind.Note: The formulas in the gray boxes above are cell-protected. The word 'byui' is the password if you wish to turn off the protection. Also, understanding the role that the negative plays is crucial. You may want to scroll several rows down below to read more about it.=FV(C5/C6,C6*C9,C8,C7)=(NPER(F5/F6,F8,F7,F9))/12=FV(I13/I14,I17*I14,I15,I16)+I15*I14*I17+I16=PMT(C13/C14,C17*C14,C15,C16)=CUMIPMT(I13/I14,I15,I16,1,I17*I14,0)=F22*((1+F21)^(1/F22)-1)
Background image
My Personal Annuity WorksheetGiven:PrincipalCompoundsAPRPaymentMonthsPrincipalInterestPaymentTotalMonth #9(Iteration Method)Month #9(Formula Method)Month #9(Excel Function Method)
Background image
Career Scenarios:Investment Scenarios:Number of Years Planning to Work45Present Value at the Start of Career0Age During First Year of Career35Number of Payments Made Each Year24Beginning Salary Year2018Projected Investment APR7.00%Ending Salary Year2064Average Inflation Rate Over Career1.00%Starting Salary45,000 Initial Employee Contributions2.00%Annual Salary Increase2.50%Initial Employer Contributions2.00%($)(%)(%)(%)(%)($)(%)($)($)($)($)CurrentCareerCalendarAnnualSalaryEmployeeEmployerTotalAnnualProjectedPrincipalInterestInvestmentBuyingAgeYearYearSalaryIncreaseContributionContributionContributionContributionAPRBalanceBalanceBalancePower00003512018n/a2.00%2.00%4.0%7.00%3622.00%2.00%7.00%3732.00%2.00%7.00%3842.00%2.00%7.00%3952.00%2.00%7.00%4062.00%2.00%7.00%4172.00%2.00%7.00%4282.00%2.00%7.00%4392.00%2.00%7.00%44102.00%2.00%7.00%45112.00%2.00%7.00%46122.00%2.00%7.00%47132.00%2.00%7.00%48142.00%2.00%7.00%49152.00%2.00%7.00%50162.00%2.00%7.00%51172.00%2.00%7.00%52182.00%2.00%7.00%53192.00%2.00%7.00%54202.00%2.00%7.00%55212.00%2.00%7.00%56222.00%2.00%7.00%57232.00%2.00%7.00%58242.00%2.00%7.00%59252.00%2.00%7.00%60262.00%2.00%7.00%61272.00%2.00%7.00%62282.00%2.00%7.00%63292.00%2.00%7.00%64302.00%2.00%7.00%65312.00%2.00%7.00%66322.00%2.00%7.00%67332.00%2.00%7.00%68342.00%2.00%7.00%69352.00%2.00%7.00%70362.00%2.00%7.00%71372.00%2.00%7.00%72382.00%2.00%7.00%73392.00%2.00%7.00%74402.00%2.00%7.00%75412.00%2.00%7.00%76422.00%2.00%7.00%77432.00%2.00%7.00%78442.00%2.00%7.00%79452.00%2.00%7.00%80462.00%2.00%7.00%81472.00%2.00%7.00%82482.00%2.00%7.00%83492.00%2.00%7.00%
Background image
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture