Question

Una Day is planning to retire in 20 years, at which time she hopes to have accumulated enough money to receive an annuity of $12,000 a year for 25 years of retirement. During her pre-retirement period she expects to earn 8 percent annually, while during retirement she expects to earn 10 percent annually on her 39. ey. What annual contributions to this retirement fund are required for Una to achieve her objective and sleep well at night? mon
0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

File Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum Calibri ー E ゴWrap Text General aCopy ,_a. ars-函Merge & Center, $, % , 弼,8 C Paste B 1 u. Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard Font Alignment Number Styles Cells Edting NM46 NM NO NP NQ NR NS NT NU NV NW 31 32 34 35 STEP 1 36 37 38 39 40 STEP 2 41 42 43 ANSWER PMT YEARS POST RETIREMENT RATE PRESENT VALUE OF ANNUITY 12000 25 10% 108924.48 EXCEL PV(NO37,NO36,-NO35) FUTURE VALUE TO BE ACCUMULATED YEARS PRE RETIREMENT RATE ANNUAL DEPOSIT 108924.48 20 3% $2,380.24 EXCEL PMT(NO42,NO41,,-NO40) 45 46 47 48 49 CALCULATOR | LOAN OPTIONS fv. ann CAP STRU VALUE BOX DILUTION DOLLAR COST AVGMORTGAGE EXPO Sheeti Sheet2 Shel 08:22 28-01-2019

Add a comment
Know the answer?
Add Answer to:
Una Day is planning to retire in 20 years, at which time she hopes to have...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • You wish to retire in 40 years, at which time you want to have accumulated enough...

    You wish to retire in 40 years, at which time you want to have accumulated enough money to receive a monthly annuity of $12,000 for 25 years after retirement. During the period before retirement you can earn 9% compounded annually, while after retirement you can earn 10% on your money. What annual contributions to this retirement fund will allow you to receive the $12,000 monthly annuity?

  • Mary's 25th birthday is today, and she hopes to retire on her 65th birthday. She has...

    Mary's 25th birthday is today, and she hopes to retire on her 65th birthday. She has determined that she will need to have $3,000,000 in her retirement savings account in order to live comfortably. Mary currently has no retirement savings, and her investments will earn 5% annually. How much must she deposit into her account at the end of each of the next 40 years to meet her retirement savings goal? Your Answer:

  • You wish to retire in 14 years, at which time you want to have accumulated enough money to receive an annual annuity of $17,000 for 19 years after retirement.

    You wish to retire in 14 years, at which time you want to have accumulated enough money to receive an annual annuity of $17,000 for 19 years after retirement. During the period before retirement you can earn 8 percent annually, while after retirement you can earn 10 percent on your money. What annual contributions to the retirement fund will allow you to receive the $17,000 annuity? Use Appendix C and Appendix D for an approximate answer, but calculate your final answer using the formula and...

  • An individual is currently 30 years old and she is planning her financial needs upon retirement. She will retire at age...

    An individual is currently 30 years old and she is planning her financial needs upon retirement. She will retire at age 65 (exactly 35 years from now) and she plans on funding 20 years of retirement with her investments. Ignore any social security payments and ignore any taxes. She made $106,000 last year and she estimates she will need 75% of her current income in today's dollars to live on when she retires. She believes that inflation will average 3...

  • Question 11 (0.2 points) Mary's 25th birthday is today, and she hopes to retire on her...

    Question 11 (0.2 points) Mary's 25th birthday is today, and she hopes to retire on her 65th birthday. She has determined that she will need to have $3,000,000 in her retirement savings account in order to live comfortably. Mary currently has no retirement savings, and her investments will earn 6% annually. How much must she deposit into her account at the end of each of the next 40 years to meet her retirement savings goal? Your Answer: Answer Hide hint...

  • Problem 9-37 Solving for an annuity (LO9-4] You wish to retire in 12 years, at which...

    Problem 9-37 Solving for an annuity (LO9-4] You wish to retire in 12 years, at which time you want to have accumulated enough money to receive an annual annuity of $22,000 for 17 years after retirement. During the period before retirement you can earn 8 percent annually, while after retirement you can earn 10 percent on your money. points eBook What annual contributions to the retirement fund will allow you to receive the $22,000 annuity? Use Appendix C and Appendix...

  • Robin is planning for her retirement. She is currently 37 years old and plans to retire...

    Robin is planning for her retirement. She is currently 37 years old and plans to retire at age 62 and live until age 97. Robin currently earns $120,000 per year and anticipates needing 80% of her income during retirement. She anticipates Social Security will provide her with $15,000 per year at age 62, leaving her with required savings to provide $81,000 ($120,000 x 0.80 - $15,000) annually during retirement. She is willing to take some investment risk. Her pre-retirement portfolio...

  • Emily Dorsey's current salary is $68,000 per year, and she is planning to retire 20 years...

    Emily Dorsey's current salary is $68,000 per year, and she is planning to retire 20 years from now. She anticipates that her annual salary will increase by $3,000 each year ($68,000 the first year, to $71,000 the second year, $74,000 the third year, and so forth), and she plans to deposit 5% of her yearly salary into a retirement fund that earns 6% interest compounded daily. What will be the amount of interest accumulated at the time of Emily's retirement?...

  • An individual is currently 30 years old and she is planning her financial needs upon retirement....

    An individual is currently 30 years old and she is planning her financial needs upon retirement. She will retire at age 65 (exactly 35 years from now) and she plans on funding 20 years of retirement with her investments. Ignore any social security payments and ignore any taxes. She made $131,000 last year and she estimates she will need 75% of her current income in today's dollars to live on when she retires. She believes that inflation will average 3...

  • A couple will retire in 20 years. Currently, they have $225,000 in savings and invest $2,000...

    A couple will retire in 20 years. Currently, they have $225,000 in savings and invest $2,000 in a mutual fund each month that pays a 9% APR (monthly compounding) on average. (assume end of month contributions) A couple wishes to retire in Florence, Italy. The couple will need to withdraw $12,000 per month (beginning of the month) in retirement to live in a nice pension (apartment) near the Ufezi Museum. Their money will earn 3.6% APR with monthly compounding in...

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
Active Questions
ADVERTISEMENT