Question: Please help show how to use Excel formulas for these: a. What is the present value of your windfall? b. What is the future value
Please help show how to use Excel formulas for these:
| a. | What is the present value of your windfall? | ||||||
| b. | What is the future value of your windfall in three years (on the date of the last payment)? | ||||||
| D | E | F | |||||
| Interest rate | 3.50% | ||||||
| Year | 1 | 2 | 3 | ||||
| 11 | Cash flow | $10,000 | $20,000 | $30,000 | |||
| a. | What is the present value of your windfall? | ||||||
| Present value | |||||||
| b. | What is the future value of your windfall in three years (on the date of the last payment)? | ||||||
| Future value | |||||||
| Requirements | |||||||
| 1. | Start Excel completed. | ||||||
| 2. | In cellD15, by using cell references and the functionNPV, calculate the present value of the stream of cash flows(1 pt.). | ||||||
| 3. | In cellD19, by using cell reference and the functionFV, calculate the future value of the present value(1 pt.). | ||||||
| Note: The future value should be entered as a positive value. Use cell reference to thepresent value of withdrawalfrom Step 2 in your calculations. |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
