100%(1)1 out of 1 people found this document helpful
This preview shows page 1 - 5 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.)APR4.00%APR18.00%APR8.00%Compounding Periods12Compounding Periods12Compounding Periods4Present Value150000.00Present Value1200.00Payment-25Payment-716.12Payment-24Present Value-250.00Years15Future Value0Years45Future Value:($96,814.92)Years:7.8 Investment Interest:$46,981.25 APR4.00%APR4.00%APR9.00%Compounding Periods12Compounding Periods12Compounding Periods12Present Value250000Future Value0.00Original # of Payments360Future Value0Payment-1000.00Present Value60000.00Years30Years30Years30Payment:($1,193.54)Present Value:$209,461.24 Debt Interest:($113,798.49)APR3.25%APY3.29%Compounding Periods4Compounding Periods4Effective 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-1Nominal Yield:Why the Negative? (Rules of Thumb):=F22*((1+F21)^(1/F22)-1)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)
My Personal Annuity Worksheet]Given:Principal1000Compounds12APR7%Payment50MonthsPrincipalInterestPaymentTotal11000.005.8350.001055.8321055.836.1650.001111.9931111.996.4950.001168.4841168.486.8250.001225.3051225.307.1550.001282.4461282.447.4850.001339.9271339.927.8250.001397.7481397.748.1550.001455.8991455.898.4950.001514.39101514.398.8350.001573.22111573.229.1850.001632.40121632.409.5250.001691.92131691.929.8750.001751.79141751.7910.2250.001812.01151812.0110.5750.001872.58161872.5810.9250.001933.50171933.5011.2850.001994.78181994.7811.6450.002056.42192056.4212.0050.002118.41202118.4112.3650.002180.77212180.7712.7250.002243.49222243.4913.0950.002306.58232306.5813.4650.002370.03242370.0313.8350.002433.86252433.8614.2050.002498.06262498.0614.5750.002562.63272562.6314.9550.002627.58282627.5815.3350.002692.90292692.9015.7150.002758.61302758.6116.0950.002824.70312824.7016.4850.002891.18322891.1816.8750.002958.05332958.0517.2650.003025.30