Question
Using Excel: A lottery pays the winner $1 million in 20 equal payments of $50,000 each. The payments are received at the end of the
Using Excel:
A lottery pays the winner $1 million in 20 equal payments of $50,000 each. The payments are received at the end of the year, and the winners interest rate is 4%. What is the present value of the winnings?
Looking for the excel function (like PMT, PV, FV) etc...
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Financial Economics
Authors: Frank J. Fabozzi, Edwin H. Neave, Guofu Zhou
1st Edition
0470596201, 9780470596203
