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

Please help fill chart out Please help fill chart out Use formulas to find your answer by

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!