Question

Barry has just become eligible for his​ employer-sponsored retirement plan. Barry is 40 and plans to...

Barry has just become eligible for his​ employer-sponsored retirement plan. Barry is

40

and plans to retire at

65

.

Barry calculates that he can contribute

​$4 comma 400

per year to his plan.​ Barry's employer will match this amount. If Barry can earn a return of

6

​%

on his​ investment, he will have

​$482 comma 808

at retirement. Assuming a return of

6

​%,

how much would Barry have if he could invest an additional

​$900

per year that his employer would match beginning at age

40

​?

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

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum Calibri ー E ゴWrap Text General aCopy в 1 프 .-. a-Δ. : r_一 逻锂函Merge & Center. $, % , 弼鼎 Paste Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard Font Alignment Number Styles Cells GP257 GP GQ GR GS GT GU GV GW GX GY GZ ▲ 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 ANSWER 260 261 1 CALCULATOR , LOAN OPTIONS | BARRYS CONTRIBUTION = 4400 EMPLOYERS CONTRIBUTION = 4400 8800 (4400 + 4400) TOTAL CONTRIBUTION RATE NO OF YEARS AMOUNT ON RETIREMENT- 6% 25 482808 [ EXCEL FORMULA FV(GS248,25,-GS247)] NOW BARRYS CONTRIBUTION 4400+900 5300 EMPLOYERS CONTRIBUTION 4400900 5300 TOTAL CONTRIBUTION- RATE NO OF YEARS AMOUNT ON RETIREMENT 10600 (5300 +5300) 6% 25 581564 [EXCEL FORMULA FV(GS257,25,-GS256)] CAP STRU VALUE LOCK BOXDILUTION DOLLAR COST AVGMORTGAGE EXPO Sheeti Sheet2She 福 130% rences: x261 02:03

Add a comment
Know the answer?
Add Answer to:
Barry has just become eligible for his​ employer-sponsored retirement plan. Barry is 40 and plans to...
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
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