. Find the retirement calculator at www.moneychimp.com to answer the following q
ID: 2728907 • Letter: #
Question
. Find the retirement calculator at www.moneychimp.com to answer the following questions. Suppose you have $1,500,000 when you retire and want to withdraw an equal amount each year for the next 30 years.
- How much can you withdraw each year if you earn 7%
- What if you can earn 9%?
- What if the market failed and your earnings dropped to -.5%. How long would it take to drain your account if you did nothing about this loss pattern?
This is a classic retirement problem. A friend is celebrating her birthday and wants to start saving for her anticipated retirement. She has the following years to retirement and retirement spending goals:
- Years until retirement: 30
- Amount to withdraw each year: $90,000
- Years to withdraw in retirement: 20
- Interest rate: 8%
Because your friend is planning ahead, the first withdrawal will not take place until one year after she retires. She wants to make equal annual deposits into her account for her retirement fund.
a. If she starts making these deposits in one year and makes her last deposit on the day she retires, what amount must she deposit annually to be able to make the desired withdrawals at retirement?
b. Suppose your friend just inherited a large sum of money. Rather than making equal annual payments, she decided to make one lump-sum deposit today to cover her retirement needs. What amount does she have to deposit today?
c. Suppose your friend's employer will contribute to the account each year as part of the company's profit-sharing plan. In addition, your friend expects a distribution from a family trust several years from now. What amount must she deposit annually now to be able to make the desired withdrawals at retirement?
- Employer's annual contribution: $1,500
- Years until trust fund distribution: 20
- Amount of trust fund distribution: $25,000
Explanation / Answer
Q1. Rate of return is 7%, equal withdrawal for 30 years, amount=$112,971, Lump sum deposit =$1,500,000
Year
Withdrawals
Interest
Balance
$1,500,000
1
$112,971.00
$97,092.03
$1,484,121.03
2
$112,971.00
$95,980.50
$1,467,130.53
3
$112,971.00
$94,791.17
$1,448,950.70
4
$112,971.00
$93,518.58
$1,429,498.28
5
$112,971.00
$92,156.91
$1,408,684.19
6
$112,971.00
$90,699.92
$1,386,413.11
7
$112,971.00
$89,140.95
$1,362,583.06
8
$112,971.00
$87,472.84
$1,337,084.90
9
$112,971.00
$85,687.97
$1,309,801.87
10
$112,971.00
$83,778.16
$1,280,609.03
11
$112,971.00
$81,734.66
$1,249,372.69
12
$112,971.00
$79,548.12
$1,215,949.81
13
$112,971.00
$77,208.52
$1,180,187.33
14
$112,971.00
$74,705.14
$1,141,921.47
15
$112,971.00
$72,026.53
$1,100,977.00
16
$112,971.00
$69,160.42
$1,057,166.42
17
$112,971.00
$66,093.68
$1,010,289.10
18
$112,971.00
$62,812.27
$960,130.37
19
$112,971.00
$59,301.16
$906,460.53
20
$112,971.00
$55,544.27
$849,033.80
21
$112,971.00
$51,524.40
$787,587.20
22
$112,971.00
$47,223.13
$721,839.33
23
$112,971.00
$42,620.78
$651,489.11
24
$112,971.00
$37,696.27
$576,214.38
25
$112,971.00
$32,427.04
$495,670.42
26
$112,971.00
$26,788.96
$409,488.38
27
$112,971.00
$20,756.22
$317,273.60
28
$112,971.00
$14,301.18
$218,603.78
29
$112,971.00
$7,394.29
$113,027.07
30
$112,971.00
$3.92
$59.99
Rate = 9%, A= $133,949
Year
Withdrawals
Interest
Balance
$1,500,000
1
$133,949.00
$122,944.59
$1,488,995.59
2
$133,949.00
$121,954.19
$1,477,000.78
3
$133,949.00
$120,874.66
$1,463,926.44
4
$133,949.00
$119,697.97
$1,449,675.41
5
$133,949.00
$118,415.38
$1,434,141.79
6
$133,949.00
$117,017.35
$1,417,210.14
7
$133,949.00
$115,493.50
$1,398,754.64
8
$133,949.00
$113,832.51
$1,378,638.15
9
$133,949.00
$112,022.02
$1,356,711.17
10
$133,949.00
$110,048.60
$1,332,810.77
11
$133,949.00
$107,897.56
$1,306,759.33
12
$133,949.00
$105,552.93
$1,278,363.26
13
$133,949.00
$102,997.28
$1,247,411.54
14
$133,949.00
$100,211.63
$1,213,674.17
15
$133,949.00
$97,175.27
$1,176,900.44
16
$133,949.00
$93,865.63
$1,136,817.07
17
$133,949.00
$90,258.13
$1,093,126.20
18
$133,949.00
$86,325.95
$1,045,503.15
19
$133,949.00
$82,039.87
$993,594.02
20
$133,949.00
$77,368.05
$937,013.07
21
$133,949.00
$72,275.77
$875,339.84
22
$133,949.00
$66,725.18
$808,116.02
23
$133,949.00
$60,675.03
$734,842.05
24
$133,949.00
$54,080.37
$654,973.42
25
$133,949.00
$46,892.20
$567,916.62
26
$133,949.00
$39,057.09
$473,024.71
27
$133,949.00
$30,516.81
$369,592.52
28
$133,949.00
$21,207.92
$256,851.44
29
$133,949.00
$11,061.22
$133,963.66
30
$133,949.00
$1.32
$15.98
b)
Deposit Lump sum
94838
Rate of interest (8%)
1.08
Years
30
Required total at 30 Years
954322.3
We require a total amount of $954,325 at the end of 30 years, interest rate is 8%. We discount $954,325 to reach at a deposit amount of $94,838
Year
Withdrawals
Interest
Balance
$954,325
1
$90,000.00
$69,146.00
$933,471.00
2
$90,000.00
$67,477.68
$910,948.68
3
$90,000.00
$65,675.89
$886,624.57
4
$90,000.00
$63,729.97
$860,354.54
5
$90,000.00
$61,628.36
$831,982.90
6
$90,000.00
$59,358.63
$801,341.53
7
$90,000.00
$56,907.32
$768,248.85
8
$90,000.00
$54,259.91
$732,508.76
9
$90,000.00
$51,400.70
$693,909.46
10
$90,000.00
$48,312.76
$652,222.22
11
$90,000.00
$44,977.78
$607,200.00
12
$90,000.00
$41,376.00
$558,576.00
13
$90,000.00
$37,486.08
$506,062.08
14
$90,000.00
$33,284.97
$449,347.05
15
$90,000.00
$28,747.76
$388,094.81
16
$90,000.00
$23,847.58
$321,942.39
17
$90,000.00
$18,555.39
$250,497.78
18
$90,000.00
$12,839.82
$173,337.60
19
$90,000.00
$6,667.01
$90,004.61
20
$90,000.00
$0.37
$4.98
A)
N =30 years, r =8%, P=? F.V = $954,325
Using the formula we get, P= $8,424
Year
Withdrawals
Interest
Balance
$954,325
1
$90,000.00
$69,146.00
$933,471.00
2
$90,000.00
$67,477.68
$910,948.68
3
$90,000.00
$65,675.89
$886,624.57
4
$90,000.00
$63,729.97
$860,354.54
5
$90,000.00
$61,628.36
$831,982.90
6
$90,000.00
$59,358.63
$801,341.53
7
$90,000.00
$56,907.32
$768,248.85
8
$90,000.00
$54,259.91
$732,508.76
9
$90,000.00
$51,400.70
$693,909.46
10
$90,000.00
$48,312.76
$652,222.22
11
$90,000.00
$44,977.78
$607,200.00
12
$90,000.00
$41,376.00
$558,576.00
13
$90,000.00
$37,486.08
$506,062.08
14
$90,000.00
$33,284.97
$449,347.05
15
$90,000.00
$28,747.76
$388,094.81
16
$90,000.00
$23,847.58
$321,942.39
17
$90,000.00
$18,555.39
$250,497.78
18
$90,000.00
$12,839.82
$173,337.60
19
$90,000.00
$6,667.01
$90,004.61
20
$90,000.00
$0.37
$4.98
Employer's annual contribution: $1,500
- Years until trust fund distribution: 20
Future value of annuity of $1500 for 20 years =$68,642.95, trusd fund time period not given so it cant be calculated
Year
Withdrawals
Interest
Balance
$1,500,000
1
$112,971.00
$97,092.03
$1,484,121.03
2
$112,971.00
$95,980.50
$1,467,130.53
3
$112,971.00
$94,791.17
$1,448,950.70
4
$112,971.00
$93,518.58
$1,429,498.28
5
$112,971.00
$92,156.91
$1,408,684.19
6
$112,971.00
$90,699.92
$1,386,413.11
7
$112,971.00
$89,140.95
$1,362,583.06
8
$112,971.00
$87,472.84
$1,337,084.90
9
$112,971.00
$85,687.97
$1,309,801.87
10
$112,971.00
$83,778.16
$1,280,609.03
11
$112,971.00
$81,734.66
$1,249,372.69
12
$112,971.00
$79,548.12
$1,215,949.81
13
$112,971.00
$77,208.52
$1,180,187.33
14
$112,971.00
$74,705.14
$1,141,921.47
15
$112,971.00
$72,026.53
$1,100,977.00
16
$112,971.00
$69,160.42
$1,057,166.42
17
$112,971.00
$66,093.68
$1,010,289.10
18
$112,971.00
$62,812.27
$960,130.37
19
$112,971.00
$59,301.16
$906,460.53
20
$112,971.00
$55,544.27
$849,033.80
21
$112,971.00
$51,524.40
$787,587.20
22
$112,971.00
$47,223.13
$721,839.33
23
$112,971.00
$42,620.78
$651,489.11
24
$112,971.00
$37,696.27
$576,214.38
25
$112,971.00
$32,427.04
$495,670.42
26
$112,971.00
$26,788.96
$409,488.38
27
$112,971.00
$20,756.22
$317,273.60
28
$112,971.00
$14,301.18
$218,603.78
29
$112,971.00
$7,394.29
$113,027.07
30
$112,971.00
$3.92
$59.99
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.