Excel retirement problem:

You just got your first job and plan to start saving for retirement by investing with each monthly paycheck.

You plan to retire in 45 years.

In 50 years, you want to give your daughter a gift of $1,000,000. You will receive an inheritance from a rich great-uncle of $250,000 in 20 years.

You think you will want $150,000 every year when you retire, starting the day you retire. You plan to need 30 payments, so the last one will be paid at the end of the 29th year (beginning of the 30th year). You do not want to leave any money in your account at the end.

You expect to earn 8% APR during your investing years and 5% APR during your retirement years. How much do you need to save each month to meet your retirement goal?

Find-

Retirement withdrawals:

Inheritance:

Gift:

APR (investing):

m for investing years:

APR (retirement)

m for retirement years:

Inflation rate:

Real rate:

Solve for-

a) PV at time 45:

b) PV Today:

c) Monthly payments to fund value: