ZuoTi.Pro
Question

You are 31 years​ old, and decide to save $ 5 comma 000 each year​ (with...

You are 31 years​ old, and decide to save $ 5 comma 000 each year​ (with the first deposit one year from​ now), in an account paying 9 % interest per year. You will make your last deposit 34 years from now when you retire at age 65. During​ retirement, you plan to withdraw funds from the account at the end of each year​ (so your first withdrawal is at age​ 66). What constant amount will you be able to withdraw each year if you want the funds to last until you are age 85​?

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

AS NOTHING WAS MENTIONED, SOLVED USING EXCEL. IF YOU NEED WITH FORMULA, WILL DO THAT ALSO. THANK YOU

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy. в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Paste Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard Font Alignment Number Styles Cells Edting MY73 MW MX MY MZ NA NB NC ND NE NF NG NH NI 61 62 63 64 65 SAVINGS PER YEAR YEARS RATE FUTURE VALUE 5000 9% $ 9,84,911.72 EXCEL-FV(996,34,-5000) 67 68 69 70 71 72 73 74 75 76 WITHDRAWAL FOR 20 YEARS PRESENT VALUE RATE $9,84,911.72 9% ANSWER PMT $1,07,893.61 EXCEL-PMT(9%,20-984911.72) 78 79 11 1 トーCALCULATOR ( LOAN OPTIONS | pv, fv, annuity 1 CAP STRU VALUE BOX DILUTIONDOLLAR COST AVG MORTGAGE EXPO SheetiSheet Sh rences: x261 福 130% 02:54 12-01-2019

0 0
Add a comment
Know the answer?
Add Answer to:
You are 31 years​ old, and decide to save $ 5 comma 000 each year​ (with...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Investment A You are 25 years old, having just started working. You are considering a retirement...

    Investment A You are 25 years old, having just started working. You are considering a retirement plan for a retirement at the age of 65. You want to be able to withdraw $79,000 from your savings account on each birthday for 20 years following your retirement at the age of 65. Your first withdrawal will be on your 66th birthday. To achieve your goal, you intend to make equal annual deposits in a pension scheme which offers 7% interest per...

  • You are 25 years old, having just started working. You are considering a retirement plan for...

    You are 25 years old, having just started working. You are considering a retirement plan for a retirement at the age of 65. You want to be able to withdraw $76,000 from your savings account on each birthday for 20 years following your retirement at the age of 65. Your first withdrawal will be on your 66th birthday. To achieve your goal, you intend to make equal annual deposits in a pension scheme which offers 7% interest per year. According...

  • Problem 3 You just turned 30 and decide that you would like to save up enough...

    Problem 3 You just turned 30 and decide that you would like to save up enough money so as to be able to withdraw $75,000 per year for 20 years after you retire at age 65, with the first withdrawal starting on your 66th birthday. How much money will you have to deposit each month into an account earning 8% per year (interest compounded monthly), starting one month from today, to accomplish this goal?

  • You are 25 years old and decide to start saving for your retirement - so smart!...

    You are 25 years old and decide to start saving for your retirement - so smart! You plan to save $5,000 each year (so the first deposit will be one year from now), and you will make your last deposit when you retire at age 65. Suppose you earn 8% compounded annually 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 35 to start...

  • You decide that you want to save 2,796,146 dollars for retirement. Assuming that you are 25...

    You decide that you want to save 2,796,146 dollars for retirement. Assuming that you are 25 years old today, will retire at the age of 65, and can earn a 10 percent annual interest rate on your deposits, how much must you deposit each year to meet your retirement goal? (your first deposit will be one year from now and your last deposit will be 40 years from today, i.e. 40 deposits)

  • You are trying to decide how much to save for retirement. Assume you plan to save...

    You are trying to decide how much to save for retirement. Assume you plan to save $4,000 per year with the first investment made one year from now. You think you can earn 7.0% per year on your investments and you plan to retire in 45 years, immediately after making your last $4,000 investment. a. How much will you have in your retirement account on the day you retire? b. If, instead of investing $4,000 per year, you wanted to...

  • You are trying to decide how much to save for retirement. Assume you plan to save...

    You are trying to decide how much to save for retirement. Assume you plan to save $5,500 per year with the first investment made one year from now. You think you can earn 11.5% per year on your investments and you plan to retire in 34 years, immediately after making your last $5.500 investment. a. How much will you have in your retirement account on the day you retire? b. If, instead of investing $5,500 per year, you wanted to...

  • You decide to open a retirement account at your local bank that pays 10%/year/month (10% per...

    You decide to open a retirement account at your local bank that pays 10%/year/month (10% per year compounded monthly). For the next 20 years, you will deposit $300 per month into the account, with all deposits and withdrawals occurring at month’s end. On the day of the last deposit, you will retire. Your expenses during the first year of retirement will be covered by your company’s retirement plan. As such, your first withdrawal from your retirement account will occur on...

  • You are trying to decide how much to save for retirement. Assume you plan to save...

    You are trying to decide how much to save for retirement. Assume you plan to save $5,000 per year with the first investment made one year from now. You think you can earn 5.0% per year on your investments and you plan to retire in 27 years, immediately after making your last S5,000 investment. a. How much will you have in your retirement account on the day you retire? b. If, instead of investing S5,000 per year, you wanted to...

  • ccepi My courses > 3001 > Homework NU. 4 Intro You just turned 25 years old...

    ccepi My courses > 3001 > Homework NU. 4 Intro You just turned 25 years old and want to retire when you turn 65. You plan to put $4,600 every year into a ROTH IRA, a retirement account from which you can withdraw money after retirement without having to pay any taxes. You expect to earn a return of 6% on your investments every year. Part 1 - Attempt 1/10 for 10 pts. How much money can you expect to...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT