1. Retrieve the file CFM0514P.XLS. 2. Enter the appropriate financial function command in cell B7 that solves...

Fantastic news! We've Found the answer you've been seeking!

Question:

1. Retrieve the file CFM0514P.XLS.

2. Enter the appropriate financial function command in cell B7 that solves Problem 14 in Chapter 5. This is the annual capital recovery payment for a 10-year ordinary annuity.

3. Enter the relevant values in cells B11:B20. Hint: Invoke a copy command, being mindful of the issue of absolute versus relative cell addresses.

4. Create an equation in cell C11 that calculates the remaining value of the account at the end of the first year. Create a modified equation in cell C12 and adapt it to cells C13:C20, being mindful of the issue of absolute versus relative cell addresses.

5. Now assume that there will be 20 years of annuity payments, as indicated in cell D5. Enter the appropriate financial function command in cell D7 that solves for the annual capital recovery payment for a 20-year ordinary annuity.

6. Enter the relevant values in cells D11:D30. Hint: Invoke a copy command, being mindful of the issue of absolute versus relative cell addresses.

7. Create an equation in cell E11 that calculates the remaining value of the account at the end of the first year. Create a modified equation in cell E12 and adapt it to cells E13:E30, being mindful of the issue of absolute versus relative cell addresses.

8. Enter the appropriate financial function command in cell B39 assuming annuity due withdrawals are planned for 10 years and the rate of return is 7%.

9. Enter the appropriate financial function command in cell D39 assuming annuity due withdrawals are planned for 20 years and the rate of return is 7%.

10. Enter the appropriate financial function command in cell B47 assuming annuity due withdrawals are planned for 10 years and the rate of return is 5%. Note that the accumulated value is $100,000, not $80,000.

11. Enter the appropriate financial function command in cell D47 assuming annuity due withdrawals are planned for 20 years and the rate of return is 5%. Note that the accumulated value is $100,000, not $80,000.