Ian would like to save $1,500,000 by the time he retires in 40 years. If he believes that he can achieve a 7% rate of return, how much does he need to deposit each year to archieve his goal?

Francis wants to start a foundation that will pay its beneficiaries $64,000 per year forever, with the first cash flow occurring one year from today. If the funds will be invested to earn 7% per year, how much must Frank donate today? Enter your answer as a positive number rounded to the nearest penny.

B. He has decided he wants to save $1,000,000 before he retires. If he saves for 30 years, earning 6%, how much must he save each month to retire with a million dollars after 30 years?

Starling wants to retire with $1,950,000 in his retirement account exactly 36 years from today. He will make annual deposits each year at the end of each year to fund his retirement account. If he can earn 9.09 percent per year, how much does he deposit each year?   MUST USE EXCEL FORMULA! NOT ALGEBRAICALLY!

Bobby has heard the importance of saving early for retirement. He wants to retire in 35 years. But he really likes traveling. Right now, he spends, on average, about $600 a month traveling. He is trying to decide if he should start saving his travel money for retirement now, or if he can continue traveling a few more years before beginning to save. Assume that he can find an annuity that pays 4.75% compounded quarterly. What is his future value if: a) He waits 20 years to start saving?  N:     P/Y:  I%:     C/Y:  PMT:                                      End or Begin    $201,091.59 $658,935.54 $823,669.42 $1,000,000.00

Juan plans on saving $8000 each year starting at age 25 each year through age 65 (40 years). If he earns a “gross” 8% on his savings each year, how much money will he have at retirement if his account expense ratio is: 0.50% =$???????????? or 0.05%= $?????????????