Question
The state of Florida sold a total of $36.1 million worth of lottery tickets at $1 each during the first week of January 2007. As
The state of Florida sold a total of $36.1 million worth of lottery tickets at $1 each during the first week of January 2007. As prize money, a total of $41 million will be distributed over the next 21 years ($1,952,381 at the beginning of each year). The distribution of the first-year prize money occurs now, and the remaining lottery proceeds are put into the states educational reserve funds, which earn interest at the rate of 6% compounded annually.
After the last prize distribution has been made (at the beginning of year 21), how much will be left over the reserve account? (please solve using excel with steps )
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