Ansel and Harriet were a young, highly educated professional couple both employe
ID: 2765990 • Letter: A
Question
Ansel and Harriet were a young, highly educated professional couple both employed by one of the leading resort hotels in the area. They were planning on saving for a new house, which they expected to purchase in seven years. In addition to that financial requirement, they felt that Harriet would quit working at that time to care for their expected family, and that the loss of her income would make them unable to keep up payments on the house without additional cash inflows to supplement Ansel’s income. The couple felt that they needed $1,500 a year in supplemental income beginning in seven years to assist with the house payments, and that they needed this cash inflow for each of the next 30 years. They also wanted to have $50,000 with which to make the down payment on a house in seven years when they planned to buy. As both were working, they had plenty of funds for savings and were wondering how much they should put away at the end of each of the next seven years to be able to make the $50,000 down payment AND have the $1,500 a year cash inflow (annuity). An 11% interest rate applied to their situation.
a. How much must Ansel and Harriet set aside each year for the next 7 years so they will have $50,000 down payment in seven years? Provide all assumptions and calculations.
b. How much must Ansel and Harriet set aside each year for the next 7 years so they will have $1,500 per year additional income for 30 years? Provide all assumptions and calculations. (Hint: There are two parts to this. First determine the PV of $1,500 for 30 years and then determine how much they must set aside for the next seven years so they will have this PV amount).
c. Given the results from “a” and “b” above, how much will Ansel and Harriet need to set aside in total each year for the next 7 years? Provide all assumptions and calculations. This step is easy, don’t make it hard.
Explanation / Answer
Ans: $4,605 per year
Year
Amount to be set aside
Cumulative amount
Total amount
Interest
Total cumulative Future amount
1
4,605.00
-
-
1.11
5,111.55
2
4,605.00
5,111.55
9,716.55
1.11
10,785.37
3
4,605.00
10,785.37
15,390.37
1.11
17,083.31
4
4,605.00
17,083.31
21,688.31
1.11
24,074.03
5
4,605.00
24,074.03
28,679.03
1.11
31,833.72
6
4,605.00
31,833.72
36,438.72
1.11
40,446.98
7
4,605.00
40,446.98
45,051.98
1.11
50,007.69
Ans: $1,201 per year
Year
Amount to be set aside
Cumulative amount
Total amount
Interest
Total cumulative Future amount
1
1,201.00
-
-
1.11
1,333.11
2
1,201.00
1,333.11
2,534.11
1.11
2,812.86
3
1,201.00
2,812.86
4,013.86
1.11
4,455.39
4
1,201.00
4,455.39
5,656.39
1.11
6,278.59
5
1,201.00
6,278.59
7,479.59
1.11
8,302.34
6
1,201.00
8,302.34
9,503.34
1.11
10,548.71
7
1,201.00
10,548.71
11,749.71
1.11
13,042.18
Year
opening balance
Interest at 11%
Monthly receipt
Balance amount
1
13,042.18
1,434.64
1500
12,976.82
2
12,976.82
1,427.45
1500
12,904.27
3
12,904.27
1,419.47
1500
12,823.74
4
12,823.74
1,410.61
1500
12,734.35
5
12,734.35
1,400.78
1500
12,635.13
6
12,635.13
1,389.86
1500
12,524.99
7
12,524.99
1,377.75
1500
12,402.74
8
12,402.74
1,364.30
1500
12,267.05
9
12,267.05
1,349.38
1500
12,116.42
10
12,116.42
1,332.81
1500
11,949.23
11
11,949.23
1,314.42
1500
11,763.64
12
11,763.64
1,294.00
1500
11,557.64
13
11,557.64
1,271.34
1500
11,328.98
14
11,328.98
1,246.19
1500
11,075.17
15
11,075.17
1,218.27
1500
10,793.44
16
10,793.44
1,187.28
1500
10,480.72
17
10,480.72
1,152.88
1500
10,133.60
18
10,133.60
1,114.70
1500
9,748.30
19
9,748.30
1,072.31
1500
9,320.61
20
9,320.61
1,025.27
1500
8,845.87
21
8,845.87
973.05
1500
8,318.92
22
8,318.92
915.08
1500
7,734.00
23
7,734.00
850.74
1500
7,084.74
24
7,084.74
779.32
1500
6,364.06
25
6,364.06
700.05
1500
5,564.11
26
5,564.11
612.05
1500
4,676.16
27
4,676.16
514.38
1500
3,690.54
28
3,690.54
405.96
1500
2,596.50
29
2,596.50
285.62
1500
1,382.12
30
1,382.12
152.03
1500
34.15
Total Amount need to set aside = $4,605 + $1,201 = $5,806 per year
Year
Amount to be set aside
Cumulative amount
Total amount
Interest
Total cumulative Future amount
1
4,605.00
-
-
1.11
5,111.55
2
4,605.00
5,111.55
9,716.55
1.11
10,785.37
3
4,605.00
10,785.37
15,390.37
1.11
17,083.31
4
4,605.00
17,083.31
21,688.31
1.11
24,074.03
5
4,605.00
24,074.03
28,679.03
1.11
31,833.72
6
4,605.00
31,833.72
36,438.72
1.11
40,446.98
7
4,605.00
40,446.98
45,051.98
1.11
50,007.69
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.