.
A state lotto has a prize that pays $1,700 each week for 40 years.
(a) Find the total value of the prize: $
Correct
(b) If the state can earn 3% interest on investments, how much money will they need
to put into an account now to cover the weekly prize payments?
~~~~~~~~~~~~~~~~~~~~~~~~
Calculations in the post by @CPhill are incorrect and inaccurate,
as practically always in all his Finance calculations.
In this my post, I present my calculation, which gives different answer.
This problem is about the starting amount of a sinking fund, which pays out $1700
each week during 40 years, compounding weekly at 3% annual interest.
The year is 365/7, or about 52 weeks, so I will use 52 weeks per year.
Use the formula for the monthly payment of a sinking fund
IV = ,
where IV stands for the initial value, PMT is the annual outpayment value,
r is the annual rate, n is the number of payment/compounding (52 times the number of years, in this problem).
With the given data, the formula for calculations is
IV = = 2,058,841 dollars.
At this point, I copy-paste this formula into an Excel spreadsheet
without making intermadiate calculations.
Excel spreadsheet is a powerfull calculator. It keeps enough decimal places
to provide the necessary precision. The value, which I got this way is
PV = 2,058,840.57.
ANSWER. The initial/starting value of the fund is about $2,058,841.
This amount is deposited initially, and it provides
no-failure payments of $1,700 at the end of each week during 40 years,
under given conditions.
This initial/starting value of the fund is the "present" value of the prize,
which is won in the lottery.
Notice that the total outpayment in 40 years, under the given condition,
is 40*52*1700 = 3,536,000.
The difference $3,536,000 - $2,058,841 = $1,477,159 is the interest, which the fund earned in 40 years.
Solved.
----------------------------------
The lesson to learn from this my post is two-fold
(1) In such Finance calculations, use powerful enough calculator to provide the necessary precision.
(2) Do not make intermediate rounding ( ! ) Round only the final value ( ! )