Question: Please help fill chart out Use formulas to find your answer by completing the FV Table: 1 First we must calculate the FV Interest Factor
Use formulas to find your answer by completing the FV Table: 1 First we must calculate the FV Interest Factor for each cash flow in row d. FVIF =(1+r)m1 In cell E33 cater the formula: =(1+E30)4 and copy to cells G33 and H33 You must change the exponents in cells F33 through I33. 2. Then, we find the FV of each cash flow in row e. In cell E34 cnter the FV formula.CF x FVIF =E32*E33 and copy to cells F34 through I 34 3 Lastly, we sum the FVs to get the FV of the annuity in cell J34. In cell J34 cater the formula: =sam(E34:134) 4 Your answer should be: The FV of the cash flows is $1443.27 Note: You can change any of the inputs and Excel will automatically recompute
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
