Suppose you have just won a lottery. You will receive a total of 27 annual payment, and each payment is $3,371. You will receive the first payment today. If you can earn 6% annual rate of return each year, how much is this lottery worth to you today? (round to the nearest dollar. )
PLEASE INCLUDE EXCEL FORMULA
- Annual periodic payment starting from today is $3371 for 27 years
Calculating the Present Value of periodic annual payments using excel "PV" function:-
So, lottery worth to you today is $47,205
If you need any clarification, you can ask in comments.
If you like my answer, then please up-vote as it will be motivating
Get Answers For Free
Most questions answered within 1 hours.