Question

Bob and Lisa are both married, working adults. They both plan for retirement and consider the...

  • Bob and Lisa are both married, working adults. They both plan for retirement and consider the $2,000 annual contribution a must.

    First, consider Lisa's savings. She began working at age 20 and began making an annual contribution of $2,000 at the first of the year beginning with her first year. She makes 13 contributions. She worked until she was 32 and then left full time work to have children and be a stay at home mom. She left her IRA invested and plans to begin drawing from her IRA when she is 65.

    Bob started his IRA at age 32. The first 12 years of his working career, he used his discretionary income to buy a home, upgrade the family cars, take vacations, and pursue his golfing hobby. At age 32, he made his first $2,000 contribution to an IRA, and contributed $2,000 every year up until age 65, a total of 33 years / contributions. He plans to retire at age 65 and make withdrawals from his IRA.

    Both IRA accounts grow at a 7% annual rate. Do not consider any tax effect.
  • Write a two to three (2-3) paragraph summary in which you:
    • Create a chart summarizing the details of the investment for both Bob and Lisa.
    • Explain the results in terms of time value of money.
1 0
Add a comment Improve this question Transcribed image text
Answer #1

Calculation of Maturity Value of Lisa's Investment:File Home InsertPage LayoutFormulas DataReview View DeveloperNitro Pro8 5 EX Σ AutoSum. Times New Roman . 14.A. A-=-19- в 1 u . d! 습·ーミ wrap Text General Copy Fill % ,渦鼎Conditional Format- Cell-Insert Delete Format Merge & Center. Sort & Find & 2 Clear Filter Select Editing Formatting as Table Styles Clipboard Font Alignment Number Cells 118 Lisas Investment Year of FVF @ 7% Maturity Value at the age of 65 Years Amount of 20 S 22 S 2,00021.002452 S 2,00019.628460 S 2,00018.344355 S 2,000 17.144257 S 2,00016.022670 S 2,000 14.974458 S 2,00013.994820 |S 2,000 13.079271 S 2,00012.223618 S 2,00011.423942 S 2,00010.676581 S 2,000 2,000 42,004.90 39,256.92 36,688.71 34,288.51 32,045.34 29.948.92 27,989.64 26,158.54 24,447.24 22,847.88 21,353.16 19,956.23 18,650.68 375,636.68 24 S 25 S 26 S 27 S 剉 2 12 29 S 31 S Total Maturity Value 13 15 16 17 9.978114 S 9.325340 S 19 20 21 Sheets sheet4 . Sheets Sheets Sheet7 | Sheet9 ) ーH Ready ! Em 100%

Calculation of Maturity Value of Bob's Investment:

Formula View:File Home Insert Page Layout﹁ Formulas Data Review View Developer Nitro Pro 5 EX Define Name calculate Now | ruse in Formula- E Trace Dependents φ Error Checking Insert Autosum Recently Financial Logical Text Date & Lookup & Math More Used - Time- Reterence - & Trig - FunctionsManager ECreate from SelectionRemove Arrows-Evaluate Formula Windo Options Function Library Defined Names Formula Auditing Calculation 118 Lisas Investment Amount of Contribution 2000 FVF @ 7% p.a. 1 1.07 (65-C4) 1 1.07 (65-C5 11.07 (65-C6) 11.0765-C7) =1 * 1.07(65-CS) 1 1.0765 11.07 (65-C10 1 Maturity Vaue at the age of 65 Years 20 21 E4 D4 E5*D5 -E6 D6 -E7 D7 -ES DS E9 D9 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 23 25 26 27 28 C9) 1.07465-C11) =1+1.07(65-C12) -1 E10 D10 E11 D11 -E12 D12 -E13 D13 12 *1.07465-C13) 11.07(65-C14 11.07 65-C15) 11.07 (65-C16) 13 30 -E14 D14 -E15 D15 E16 D16 16 32 17 Total Maturity Value -SUM(F4:F16) 19 21 Sheet8 Sheet4 Sheets Sheet6 Sheet7 Sheet9 Ready lain 100% (︶File Home Insert Page Layout﹁ Formulas Data Review View Developer Nitro Pro 5 EX Define Name Trace Precedents 떫 Trace Dependents ◆ Error Checking Cakculate Now Use in Formula- Insert Autosum Recently Financial Logical Text Date & Lookup & Math More Used - Time- Reterence - & Trig - FunctionsManager ECreate from SelectionRemove Arrows-Evaluate Formula Windo Options Function Library Defined Names Formula Auditing Calculation M65 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 =1 * 1 .07(65-E142) 11.07 (65-H43 -11.07 (65-H44) =1*1.07/(65-H45) -11.07(65-H46) -11.07 (65-H47 J42 142 J43 143 J44 144 J45 145 -J46 146 J47 147 J48 148 J49 149 J50 150 151 151 152 152 J53 153 J54 154 -J55 135 J56 156 57 157 -J58 158 47 =1*1 07( 65-H48) -11.07 (65-H49 11.07 (65-H50) =1 * 1.07(65-H51) 1107 65-H52 -11.07 (65-H53) 11.07 (65-H54 -1*1.07(65-H55) 1*1.07 (65-H56) -1*1.07 (65-H57) -11.07 (65-H58 52 62 Total Maturity Value SUMK25:K58) 14 ㅔ ト HI SheetB . Sheet4 Sheet5 . Sheeto Sheet7 | Sheet9 Ready !

Summary:

  • Lisa has made investment pattern starting from the year 20 and up to the year 32, which has total 13 contributions of $2000 only. While Bob has made investment pattern starting from year 32 till year 65, which has total 33 contributions of $2000 only. Hence, the maturity value of Bob's Investment is much higher than that of Lisa's Investment.

"If you have any Query, then please put it in the comment box."

Add a comment
Know the answer?
Add Answer to:
Bob and Lisa are both married, working adults. They both plan for retirement and consider the...
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
  • Bob and Lisa are both married, working adults. They both plan for retirement and consider the...

    Bob and Lisa are both married, working adults. They both plan for retirement and consider the $2,000 annual contribution a must. First, consider Lisa's savings. She began working at age 20 and began making an annual contribution of $2,000 at the first of the year beginning with her first year. She makes 13 contributions. She worked until she was 32 and then left full time work to have children and be a stay at home mom. She left her IRA...

  • Larry and Beth are both married, working adults. They both plan for retirement and consider the...

    Larry and Beth are both married, working adults. They both plan for retirement and consider the $6,000 annual contribution a must. First, consider Beth's savings. She began working at age 20 and began making an annual contribution to her IRA of $6,000 each year until age 32 (12 contributions). She then left full time work to have children and be a stay at home mom. She left her IRA invested and plans to begin drawing from her IRA when she...

  • please give answer Socolate this astot Seth are both married, working adults. They both plan for...

    please give answer Socolate this astot Seth are both married, working adults. They both plan for retirement and consider the $6,000 annual contribution a must der Beth's savings. She began working at age 20 and began making an annual contribution to her IRA of $6,000 each year untilage 32 (12 con rk to have chan and be a stay at home mom. She left her IRA invested and plans to begin drawing from her RA when she 65 d contributing...

  • If an individual (or spouse) is an active participant in an employer-sponsored retirement plan, he or...

    If an individual (or spouse) is an active participant in an employer-sponsored retirement plan, he or she cannot make a deductible IRA contribution. True or False If only one spouse is employed, and that spouse is not covered under an employer-sponsored retirement plan, then the non-working spouse can make a deductible contribution to his or her own IRA. True or False With a Roth IRA, contributions are deductible, the account grows tax-free, and distributions are not taxable. True or False...

  • 1. Smart Susie began saving $5,000 a year for her retirement immediately after graduating college at...

    1. Smart Susie began saving $5,000 a year for her retirement immediately after graduating college at age 21. She is now 30 as is Procrastinator Paul. Paul begins saving $5,000 a year at age 30, and continues doing so each year until his retirement at age 65. Smart Susie stops adding to her retirement savings after age 30, and simply lets her first 10 years of accumulated savings compound until she retires, like Paul, at age 65. Assuming each has...

  • 1. Donald, age 65, withdraws $14500 for retirement from his Roth IRA this year. How much...

    1. Donald, age 65, withdraws $14500 for retirement from his Roth IRA this year. How much will he owe in taxes if his current marginal tax rate is 12% and his average tax rate is 9%? a. $1740 b. $0 c. $435 d. $1305 2. Nicole sold shares of Disney Company that were given to her 20 years ago by her grandmother to pay for her down-payment on her new home. She has a 22% marginal tax rate and a...

  • Consider a person who begins contributing to a retirement plan at age 25 and contributes for 40 years until retirem...

    Consider a person who begins contributing to a retirement plan at age 25 and contributes for 40 years until retirement at age 65. For the first ten years, she contributes $3,600 per year. She increases the contribution rate to $5,600 per year in years 11 through 20. This is followed by increases to $10,600 per year in years 21 through 30 and to $15,600 per year for the last ten years. This money earns a return of 9 percent. First...

  • Consider a person who begins contributing to a retirement plan at age 25 and contributes for 40 years until retirem...

    Consider a person who begins contributing to a retirement plan at age 25 and contributes for 40 years until retirement at age 65. For the first ten years, she contributes $3,300 per year. She increases the contribution rate to $5,300 per year in years 11 through 20. This is followed by increases to $10,300 per year in years 21 through 30 and to $15,300 per year for the last ten years. This money earns a return of 9 percent. First...

  • Question 40 of 50. cmma is a sole proprietor with one employee. She maintains a SIMPLE...

    Question 40 of 50. cmma is a sole proprietor with one employee. She maintains a SIMPLE IRA in which she matches salary reduction contributions at the rate of 3% of the employee's compensation. Emma's own salary reduction contribucion Ana ner own employer match are both reported on Form 1040. The matching contribution she makes to her employees SIMPLE IRA is reported on Schedule C. na ner own employer match are both reported on Form 1040. The matching contributions she makes...

  • Problem 5-57 Spreadsheet Problem (LG5-2, LG5-9) Consider a person who begins contributing to a retirement plan...

    Problem 5-57 Spreadsheet Problem (LG5-2, LG5-9) Consider a person who begins contributing to a retirement plan at age 25 and contributes for 40 years until retirement at age 65. For the first ten years, she contributes $3,600 per year. She increases the contribution rate to $5,600 per year in years 11 through 20. This is followed by increases to $10,600 per year in years 21 through 30 and to $15,600 per year for the last ten years. This money earns...

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