Question: Is there any way to do the problem below on excel? i cant seem to understand the formula. Answer and formula is in the bottom.

Is there any way to do the problem below on excel? i cant seem to understand the formula. Answer and formula is in the bottom. thanks

Is there any way to do the problem below on excel? i

You have just won the lottery and will receive $1,000,000 in one year. You will receive payments for 30 years and the payments will increase by 3.3 percent per year. If the appropriate discount rate is 73 percent, what is the present value of your winnings? (Do not round Intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Present value S 17.002,500.00 Explanation Note: Intermediate answers are shown below as rounded, but the full answer was used to complete the calculation. We can use the present value of a growing annuity equation to find the value of your winnings today. Doing so, we find: PV = (1/6 - 911 [148-911 * 101 - 9/1-n13 PV = $1.000.000[1/.073 - 033)] [14.073 - 033]] > [11 - 033/61 - 0731730 PV = $17,002,431.01

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!