Need QUestion 2 -7

Anonymous

Question Description

Mr. John & Jane Doe, both age 50. Jane is a home-maker. John’s current salary is $100,000 and his salary is expected to grow 3% a year. He plans to retire at age 67 and both John & Jane receive Social Security benefits at age 67. Both John and Jane are expected to live until age 97 (i.e., 30 years after retirement).

According to John’s Social Security statement, John is projected to receive about $4,000 a month at his age 67 and Jane is expected to receive 50% of John’s PMI at her age 67. John has contributed 6% of his salary with 3% employer matching into a 401 (k) plan that has earned 8% return a year. He has accumulated about $150,000 in his 401 (k) account so far. He plans to contribute the same rate until his retirement (17 annual contributions from age 50 through age 67). John also has accumulated about $75,000 in his Roth IRA account. He plans to contribute $5,000 a year into a Roth IRA that would earn 6% annual return until age 67.

Upon his retirement, he plans to withdraw to buy a 30-year annuity contract at 6% annual interest rate, but annual payments will be decreased by 3% a year. His annuity will make payments at the beginning of each year until his age 97 (a total of 30 payments from age 66). Ignore income taxes.

Compute the income replacement ratio of John and Jane’s first year retirement income (i.e., income at age 66) to John’s pre-retirement income at age 65.

1. (3) Projected salary at age 67:

2. (5) Cash flow from 401 (k) plan at age 67:

3. (5) Cash flow from a Roth IRA:

4. (4) Projected first-year retirement income from an annuity contract:

5. (3) Projected total first-year retirement income including Social Security benefits:

6. (3) If the inflation rate is 2.5% a year, how much would the present value of the first-year retirement income be?

7. (2) Income replacement ratio (= annual retirement income/pre-retirement income) at age 67.

Tutor Answer

andersonnpet
School: UCLA

Attached.

Prepared By:
Institution
Professor
Course
Date
Cash Flow From 401(k) Plan at the Age of 67

Annual Salary
Salary increment
Current Age
Retirement Age
Annual Return from 401(k) plan
Employer Matching
Employee Contribution
Accumulated Amount in 401(k) Account

$ 100,000.00
3%
50
67
8%
3%
6%
$ 150,000.00
Data Complete

Let us assume the employers m
Detailed Answer

401 (k) Contributions
Year

Age
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

Return Rate
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67

8.0%
8.0%
8.0%
8.0%
8.0%
8.0%
8.0%
8.0%
8.0%
8.0%
8.0%
8.0%
8.0%
8.0%
8.0%
8.0%
8.0%

Salary
Employee
Employer
$ 100,000.00
$ 103,000.00 $ 6,180.00 $
$ 106,090.00 $ 6,365.40 $
$ 109,272.70 $ 6,556.36 $
$ 112,550.88 $ 6,753.05 $
$ 115,927.41 $ 6,955.64 $
$ 119,405.23 $ 7,164.31 $
$ 122,987.39 $ 7,379.24 $
$ 126,677.01 $ 7,600.62 $
$ 130,477.32 $ 7,828.64 $
$ 134,391.64 $ 8,063.50 $
$ 138,423.39 $ 8,305.40 $
$ 142,576.09 $ 8,554.57 $
$ 146,853.37 $ 8,811.20 $
$ 151,258.97 $ 9,075.54 $
$...

flag Report DMCA
Review

Anonymous
Solid work, thanks.

Anonymous
The tutor was great. I’m satisfied with the service.

Anonymous
Goes above and beyond expectations !

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors