Question

Assume you are now 30 years old. You plan to retire when you are 60 years...

Assume you are now 30 years old. You plan to retire when you are 60 years old. You think you will live until you are 85 years old. a. If the rate of return during your working years (a.k.a. the "savings period") is 10% and you plan to save $1,000 per year, how much will you have saved up by retirement age? b. If the rate of return during your retirement is 7%, how much will you receive as an annual income during the 25 years you are retired?

Please show me how I would set this up on excel...What equations would be used to solve each. Thank you!

Homework Answers

Answer #1


Notations:

Nper = N = Years

FV = Future value

PV = Present value

PMT = Payment

Rate = R = Interest rate

Excel function:

a.

Total 30 years of payment as retirement age is 60 and present age is 30.

=FV(Rate,Nper,-PMT)

=FV(10%,30,-1000)

= $164,494.02 (Savings after 30 years)

Formula:

FV = PMT x ((1+R)^N-1)/R

=1000*((1+10%)^30-1)/10%

= $164,494.02

b.

=PMT(7%,25,-164494.02)

= $14,115.32 (Expected payment after retirement)

Formula:

PMT = PV x R /((1-(1+R)^-N)

= 164494.02*7%/((1-(1+7%)^-25))

= $14,115.32

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You are 30 years old today. You want to retire at the age of 60. You...
You are 30 years old today. You want to retire at the age of 60. You expect to live until age 85. You would like to have a monthly income of ​$13,000 per month in retirement. How much do you have to save per month during your working years in order to achieve your retirement​ goal? Assume end of period payments. Assume an annual interest rate of 3.5​% in retirement and 5​% during your working life. How much do you...
A young couple, both 25 years old, are planning to retire in 40 years at the...
A young couple, both 25 years old, are planning to retire in 40 years at the age of 65. After they retire, they expect to live for an additional 20 years, until age 85. They plan to begin saving for retirement today and based on information from their financial planner, they think they will earn 8% on their investment compounded annually. They think they will earn 5% on their retirement savings after they retire. 1. If they begin at age...
Happy​ birthday! You are 30 years old today. You want to retire at age 60. You...
Happy​ birthday! You are 30 years old today. You want to retire at age 60. You want to have ​$1,800,000 at retirement. ​ Realistically, you know that the most that you can save from your 31st birthday until your 50th is ​$5,500 per year​ (you only save on your​ birthdays!). How much do you have to save each year from your 51st to your 60th birthday in order to achieve your retirement goal if you can earn 6​% on your​...
You are 35 years old today and want to plan for retirement at age 65. You...
You are 35 years old today and want to plan for retirement at age 65. You want to set aside an equal amount every year from now to retirement. You expect to live to age 85 and want to withdraw a fixed amount each year during retirement that at age 65 will have the same purchasing power as $83,697 has today. You plan on withdrawing the money starting the day you retire. You have not saved any money for retirement....
Suppose you are 30 years old and want to retire at the age of age 70...
Suppose you are 30 years old and want to retire at the age of age 70 and expect to live another 20 years. On the day you retire, you want to have $1,000,000 in your retirement savings account. i. If you invest monthly starting one month from today and your investment earns 6.0 percent per year, How much money do you need to invest every month until you retire? ii. Now you’re retired with $1,000,000 and you have 20 more...
You are 30 years old and decide to start saving for your retirement. You plan to...
You are 30 years old and decide to start saving for your retirement. You plan to save $ 5000 at the end of each year​ (so the first deposit will be one year from​ now), and will make the last deposit when you retire at age 65 Suppose you earn 11 % per year on your retirement savings. a. How much will you have saved for​ retirement? b. How much will you have saved if you wait until age 39...
You have a couple who are 31 years old, and want to retire at the age...
You have a couple who are 31 years old, and want to retire at the age of 67. Knowing that, the couple has a combined annual income of $95,000 today. 1. If the couple want to procrastinate their retirement savings until they reach 35, and if retirement savings will grow at a rate of 8%, how much would they need to save per year, at the end of every year, in order to achieve the $2 million target by the...
You are 43 years old today and want to plan for retirement at age 65. You...
You are 43 years old today and want to plan for retirement at age 65. You want to set aside an equal amount every year from now to retirement. You expect to live to age 95 and want to withdraw a fixed amount each year during retirement that at age 65 will have the same purchasing power as $98,093 has today. You plan on withdrawing the money starting the day you retire. You have not saved any money for retirement....
You are 44 years old today and want to plan for retirement at age 65. You...
You are 44 years old today and want to plan for retirement at age 65. You want to set aside an equal amount every year from now to retirement. You expect to live to age 96 and want to withdraw a fixed amount each year during retirement that at age 65 will have the same purchasing power as $94,725 has today. You plan on withdrawing the money starting the day you retire. You have not saved any money for retirement....
You are 23 years old and decide to start saving for your retirement. You plan to...
You are 23 years old and decide to start saving for your retirement. You plan to save $ 6,500 at the end of each year​ (so the first deposit will be one year from​ now), and will make the last deposit when you retire at age 69. Suppose you earn 12% per year on your retirement savings. a. How much will you have saved for​ retirement? b. How much will you have saved if you wait until age 40 to...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT