Solve using Excel:

You want to receive $$5000$ per month for $20$ years in real dollars in an account when

you retire in $35$ years. The first monthly payment to be received $1$ month after you

retire. The nominal return on your investment is $9\mathrm{.}94$ percent and the inflation rate is

$3\mathrm{.}2$ percent. What is the real amount you must deposit each year for $35$ years to

achieve your goal?

You will receive $$5,000$ one year from now, $6000$ three years from now, and $7000$

five years from now in real terms. Each payment will be received at the end of the

period with the first payment occurring one year from today. The relevant nominal

discount rate is $9\mathrm{.}625$ percent and the inflation rate is $2\mathrm{.}3$ percent. What are your

winnings worth today in real dollars?