General Savings Plan - Financial ToolBoxes(Gray-shaded boxes are the outputs based on the given inputs above them Do not type in the shaded boxes APR

General Savings Plan - Financial ToolBoxes(Gray-shaded...

• Homework Help
• 77
• 100% (2) 2 out of 2 people found this document helpful

This preview shows page 1 - 7 out of 77 pages.

Financial ToolBoxes (Gray-shaded boxes are the outputs based on the given inputs above them. Do not type in the shaded boxes.) APR 4.00% APR 18.00% APR 8.00% Compounding Periods 12 Compounding Periods 12 Compounding Periods 4 Present Value 150000.00 Present Value 1200.00 Payment -25 Payment -716.12 Payment -24 Present Value -250.00 Years 15 Future Value 0 Years 45 Future Value: (\$96,814.92) Years: 7.8 Investment Interest: \$46,981.25 APR 4.00% APR 4.00% APR 9.00% Compounding Periods 12 Compounding Periods 12 Compounding Periods 12 Present Value 250000 Future Value 0.00 Original # of Payments 360 Future Value 0 Payment -1000.00 Present Value 60000.00 Years 30 Years 30 Years 30 Payment: (\$1,193.54) Present Value: \$209,461.24 Debt Interest: (\$113,798.49) APR 3.25% APY 3.29% Compounding Periods 4 Compounding Periods 4 Effective Yield (APY): 3.29% Nominal Yield (APR): 3.25% 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-1 Nominal 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))/F6 =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)
My Personal Annuity Worksheet Given: Principal 1000.00 Compounds 12 APR 7.00% Payment 50.00 Months Principal Interest Payment Total 1 1000.00 5.83 50.00 1055.83 2 1055.83 6.16 50.00 1111.99 3 1111.99 6.49 50.00 1168.48 4 1168.48 6.82 50.00 1225.30 5 1225.30 7.15 50.00 1282.44 6 1282.44 7.48 50.00 1339.92 7 1339.92 7.82 50.00 1397.74 8 1397.74 8.15 50.00 1455.89 9 1455.89 8.49 50.00 1514.39 10 1514.39 8.83 50.00 1573.22 11 1573.22 9.18 50.00 1632.40 12 1632.40 9.52 50.00 1691.92 13 1691.92 9.87 50.00 1751.79 14 1751.79 10.22 50.00 1812.01 15 1812.01 10.57 50.00 1872.58 16 1872.58 10.92 50.00 1933.50 17 1933.50 11.28 50.00 1994.78 18 1994.78 11.64 50.00 2056.42 19 2056.42 12.00 50.00 2118.41 20 2118.41 12.36 50.00 2180.77 21 2180.77 12.72 50.00 2243.49 22 2243.49 13.09 50.00 2306.58 23 2306.58 13.46 50.00 2370.03 24 2370.03 13.83 50.00 2433.86 25 2433.86 14.20 50.00 2498.06 26 2498.06 14.57 50.00 2562.63 27 2562.63 14.95 50.00 2627.58 28 2627.58 15.33 50.00 2692.90 29 2692.90 15.71 50.00 2758.61 30 2758.61 16.09 50.00 2824.70 31 2824.70 16.48 50.00 2891.18 32 2891.18 16.87 50.00 2958.05
33 2958.05 17.26 50.00 3025.30 34 3025.30 17.65 50.00 3092.95 35 3092.95 18.04 50.00 3160.99 36 3160.99 18.44 50.00 3229.43 \$ 429.43 Month #9 1514.39 (Formula Method) Month #9 \$1,514.39 (Excel Function Method)
Month #9 (Iteration Method) Reflection Paragraph : ( Briefly summarize insights gained from the three methods to calculate the fu for young investors to know. ) I really enjoyed getting to see the different ways of calc calculations much easier to come up with. I had fun see these formulas later in life. I want to start my own buisn would be very beneficial. Interest is can be a very good pay. It was cool to watch money accumulate based on  much money they have at all times, and to know how in interest then they can maximize their total. I think it wou because it will help them to make better investements a and an how and why it is increasing or declining.