Question

Anna wants to plan for retirement. She stimates that she would need $24,000 when she retires...

Anna wants to plan for retirement. She stimates that she would need $24,000 when she retires at age 67 to live the first year after retirement (year 68). She estimates that the amount that she will need for living will have to grow by 3.5% every year to keep up with inflation. Her retirement account earns 4.5% every year. How much should she start saving on her 36th birthday to comfortably live till she is 85 years old, if she is ready to increase the amount that she saves every year with the rate of inflation?

Please show work and explain how and which Excel functions were used

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Vera wants to buy an antique car for $75,000 on her 36th birthday. She would like...
Vera wants to buy an antique car for $75,000 on her 36th birthday. She would like to begin with a yearly amount deposited in her money market account earning 6.5% on her 26th birthday, and increase the amount each year by the inflation rate of 4.5%. What amount should she plan on depositing on her 26th birthday? $2,346 $3,521 $3,986 $5,456
Doreen is celebrating her 35th birthday and decides she needs to start saving for retirement beginning...
Doreen is celebrating her 35th birthday and decides she needs to start saving for retirement beginning at age 65. She wants to be able to withdraw 90,000 annually for 15 years starting on her 66th birthday. She intends to invest at 8% over the life of the account. Her employer will contribute 1500 per year until she retires. Additionally, she expects a 25,000 distribution from a family trust on her 55th birthday which will be deposited into the retirement account....
Your second cousin has just turned 30 years old, has just received her master’s degree in...
Your second cousin has just turned 30 years old, has just received her master’s degree in neurofinance and has accepted her first job. Now she must decide how much money to put into her retirement plan. The plan works as follows: Every dollar in the plan is expected to earn 8% per annum. She cannot make withdrawals until she retires on her sixty-fifth birthday. After that point, she can make withdrawals as she sees fit. She plans on living to...
You are saving for retirement. To live comfortably, you decide you will need to save $2...
You are saving for retirement. To live comfortably, you decide you will need to save $2 million by the time you are 65. Today is your 30th birthday, and you decide, starting today and continuing on every birthday up to and including your 65th birthday, that you will put the same amount into a savings account. If the interest rate is 5%, how much must you set aside each year to make sure that you will have $2 million in...
you are saving for retirement. To live​ comfortably, you decide you will need to save $2,000,000...
you are saving for retirement. To live​ comfortably, you decide you will need to save $2,000,000 by the time you are 65. Today is your 33rd ​birthday, and you​ decide, starting today and continuing on every birthday up to and including your 65th ​birthday, that you will put the same amount into a savings account. If the interest rate is 6%​, how much must you set aside each year to make sure that you will have $2,000,000 in the account...
You are saving for retirement. To live comfortably, you decide you will need to save $2...
You are saving for retirement. To live comfortably, you decide you will need to save $2 million by the time you are 65. Today is your 30th birthday, and you decide, starting today and continuing on every birthday up to and including your 65th birthday, that you will put the same amount into a savings account. If the interest rate is 8 %, how much must you set aside each year to make sure that you will have $2 million...
You are saving for retirement. To live​ comfortably, you decide you will need to save $...
You are saving for retirement. To live​ comfortably, you decide you will need to save $ 4 million by the time you are 65. Today is your 33 rd ​birthday, and you​ decide, starting today and continuing on every birthday up to and including your 65 th ​birthday, that you will put the same amount into a savings account. If the interest rate is 9 %​, how much must you set aside each year to make sure that you will...
You are saving for retirement. To live​ comfortably, you decide you will need to save $3...
You are saving for retirement. To live​ comfortably, you decide you will need to save $3 million by the time you are 65 . Today is your 30 th ​birthday, and you​ decide, starting today and continuing on every birthday up to and including your 65 th ​birthday, that you will put the same amount into a savings account. If the interest rate is 8 % ​, how much must you set aside each year to make sure that you...
Your friend is celebrating her 35th birthday today wants to start saving for her anticipated retirement...
Your friend is celebrating her 35th birthday today wants to start saving for her anticipated retirement at age 65. She wants to be able to withdraw $105,000 from her savings account on each birthday for 20 years following her retirement; the first withdrawal will be on her 66th birthday. Your friend intends to invest her money in the local credit union, which offer 7 percent interest per year. She wants to make equal annual payments on each birthday into the...
Your client is 21 years old. She wants to begin saving for retirement, with the first...
Your client is 21 years old. She wants to begin saving for retirement, with the first payment to come one year from now. She can save $8,000 per year, and you advise her to invest it in the stock market, which you expect to provide an average return of 11% in the future. a. If she follows your advice, how much money will she have at 65? Round your answer to the nearest cent. $   b. How much will she...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT