Question

Stefani German, a 40-year-old woman, plans to retire at age 65, and she wants to accumulate $420,000 over the next 25 years to supplement the retirement programs that are being funded by the federal government and her employer. She expects to earn an average annual return of about 6% by investing in a low-risk portfo containing about 20% short-term securities, 30% common stock, and 50% bonds Ste ani currently has $37.280 hat a an annual rate o return o 6% w growto about $160.000 by her 65th birthday the $160 000 figure is ound using me value o money echniques. Chapter 4 Appendi e an consults a nancial advisor to determine how much money she should save each year o meet her retirement savings objective. The advisor tells Stefani that if she saves about $18.23 each year, she will accumulate $1,000 by age 65. Saving 5 times that amount each year, $91.15, allows Stefani to accumulate roughly $5,000 by age 65 a. How much additional money does Stefani need to accumulate over time to reach her goal of $420,000? b. How much must Stefani save to accumulate the sum calculated in part a over the next 25 years? muiate roughly 15, allowes Stefani to a. To reach her goal of $420,00, Stefani needs to accumulate s (Round to the nearest dollar)

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 Page Layout FormulasData Review View dd-Ins Define Name PUse in Formula Trace Precedents t Trace Dependents Remove Arrows Show Formulas Calculate Now - 曙 ◆ Error Checking Insert Autosum Recently Financial Logical Tet Date & Lookup & Math More Function Watch Calculation Calculate Sheet wndow Name ? Create from Selection Defined Names Used | Evaluate Formula Time Reference ▼ & Tng Functions ▼ Manager options . Function Library Formula Auditing Calculation JU219 JM UN JO JP Ja JR JS JT JU JV JW JX 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 STEFANI GERMAN INVESTMENT IS FOR 25 YEARS PV- 37280 AFTER 25 YEARS, IT WILL BE = 160000 SHE NEEDS 420000 AT THE END OF 25 YEARS PERIOD OUT OF WHICH 160000 WILL BE RECEIVED BY PRESENT INVESTMENT AS GIVEN SO AMOUNT TO BE ACCUMULATED-420000-160000 260000 TO GET 1000, SHE HAS TO INVEST 18.23 EVERY YEAR SO FOR 260000, SHE NEEDS TO INVEST = 260000 X 18.23/1000 = 4739.80 SHE NEEDS TO SAVE EVERY YEAR 4739.80 11 1 トーCALCULATOR ( LOAN OPTIONS | pv, fv, annuity 1 CAP STRU VALUE BOX DILUTION DOLLAR COST AVGMORTGAGE EXPO Sheeti Sheet2 ShelI rences: x261 福 130% 03:49 29-01-2019

Add a comment
Know the answer?
Add Answer to:
Stefani German, a 40-year-old woman, plans to retire at age 65, and she wants to accumulate...
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
  • P1.1 (similar to) Question Help Stefani German, a 40-year-old woman, plans to retire at age 65,...

    P1.1 (similar to) Question Help Stefani German, a 40-year-old woman, plans to retire at age 65, and she wants to accumulate $490,000 over the next 25 years to supplement the retirement programs that are being funded by the federal government and her employer. She expects to earn an average annual return of about 5% by investing in a low-risk portfolio containing about 20% short-term securities, 30% common stock, and 50% bonds Stefani currently has $38,389 that at an annual rate...

  • A 40-year-old person wants to accumulate $593,609 by age 65. HOW much will she need to...

    A 40-year-old person wants to accumulate $593,609 by age 65. HOW much will she need to save each month, starting one month from now, if the interest rate is .5% per month? person wants to accumulate $593.609 by age 65 HOW much will she need to save each month, starting one month from now if the interest rate is 5% per mont ?

  • 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...

  • Sara Woodyard, age forty-four, plans to retire at age sixty-seven. Her life expectancy, accountin...

    Sara Woodyard, age forty-four, plans to retire at age sixty-seven. Her life expectancy, accounting for family medical history, is age ninety-seven. Tara is single and currently earns $56,000 per year as a university librarian. At her normal retirement age, she expects to receive $28,700 in Social Security benefits (today’s dollars). She will also receive a small defined benefit pension in the amount of $13,500 from a local municipality. She has come to you to determine whether she is on track...

  • Janine is 25 and has a good job at a biotechnology company. Janine estimates that she...

    Janine is 25 and has a good job at a biotechnology company. Janine estimates that she will need $875,000 in her total retirement nest egg by the time she is 65 in order to have retirement income of $20,000 a year. (She expects that Social Security will pay her an additional $15,000 a year.) She currently has $5,000 in an IRA, an important part of her retirement nest egg. She believes her IRA will grow at an annual rate of...

  • Ruth, age 31, is thinking about investing for retirement. She plans to retire when she turns...

    Ruth, age 31, is thinking about investing for retirement. She plans to retire when she turns age 65. At that time, she will need $4.05 million in assets. She has calculated that inflation will average 2.20% over her lifetime. If she can earn an average annual 9.85% rate of return, what will be her real rate of return? 7.85% 7.49% 3.80%. O 7.65%

  • 2. Mrs. D who 27 years old plans to retire at the age of 55. Mrs....

    2. Mrs. D who 27 years old plans to retire at the age of 55. Mrs. D would like to be able to withdraw $132,000 per year from her retirement account for 454 years after retirement beginning the year after her retirement. She is also expecting an inheritance of $54,000 to be transferred to her on her 35th birthday. a How much does she need to have in her retirement account by retirement- date if the interest rate is 6%...

  • Ruby is 25 and has a good job at a biotechnology company. She currently has $9,400 in an IRA, an important part of her r...

    Ruby is 25 and has a good job at a biotechnology company. She currently has $9,400 in an IRA, an important part of her retirement nest egg. She believes her IRA will grow at an annual rate of 8 percent, and she plans to leave it untouched until she retires at age 65. Ruby estimates that she will need $875,000 in her total retirement nest egg by the time she is 65 in order to have retirement income of $20,000...

  • You are a financial advisor helping a 35-year-old woman plan for her retirement years. She currently makes $75k/ year at...

    You are a financial advisor helping a 35-year-old woman plan for her retirement years. She currently makes $75k/ year at her job. She estimates that her salary will keep up with inflation - nothing less, nothing more. She intends to retire at age 65. How much would you suggest she invest every month towards her retirement? Assume that she is not familiar with TVM terms, provide a letter to her that explains your recommendation and your reasoning -- in plain...

  • Arnold Atkinson wants to retire in 20 years at age 65. He has determined that he...

    Arnold Atkinson wants to retire in 20 years at age 65. He has determined that he will need a capital sum of $2,784,000 at that time to provide his retirement income. He presently has a retirement plan with a balance of $350,000, to which he will add $25,000 per year. Phil assumes that his preretirement and postretirement rates of return will be 8%, and that inflation will average 3%. He will not consider Social Security benefits in his planning. He...

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