Question

1. Christian and Sarah both graduate from OSU and begin working as financial analysts. They will both work for exactly 40 years and then retire. Both plan to save for retirement, however each goes about it differently. Sarah begins saving $500 per month for eight years, beginning at the end of her first year on the job. Christian wants to travel and buy nice furniture for his house and allows those eight years to pass before he begins saving for retirement (note: he begins saving at the end of the 9th year). He saves $500 per month (for 32 years) until he retires. How much will each have upon retirement, 40 years from now, if they invest their savings in a mutual fund that pays 10% annual interest? 2. Suppose you take out a 30 -year mortgage for $250,000 at an interest rate of 6.8 percent. What is your monthly payment? How much is the total interest you pay over the life of the loan ? Construct an amortization table for the loans using Excel or Calculator. You can use the website www.bankrate.com to verify your answer.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Q1

Sarah's Future Value=FV(10%,32,0,FV(10%/12,12*8,500))=$1,543,217.30

Christian's Future Value=FV(10%/12,12*32,500)=$1,392,562.97

Q2

Loan 250000
Rate 6.80%
Years 30
Monthly payment $1,629.81
Month Total Payment Interest Payment Principal Payment Remaining Balance
1 $1,629.81 1416.666667 $213.15 $249,786.85
2 $1,629.81 $1,415.46 $214.35 $249,572.50
3 $1,629.81 $1,414.24 $215.57 $249,356.93
4 $1,629.81 $1,413.02 $216.79 $249,140.14
5 $1,629.81 $1,411.79 $218.02 $248,922.12
6 $1,629.81 $1,410.56 $219.25 $248,702.87
7 $1,629.81 $1,409.32 $220.50 $248,482.37
8 $1,629.81 $1,408.07 $221.75 $248,260.62
9 $1,629.81 $1,406.81 $223.00 $248,037.62
10 $1,629.81 $1,405.55 $224.27 $247,813.36
11 $1,629.81 $1,404.28 $225.54 $247,587.82
12 $1,629.81 $1,403.00 $226.82 $247,361.00
13 $1,629.81 $1,401.71 $228.10 $247,132.90
14 $1,629.81 $1,400.42 $229.39 $246,903.51
15 $1,629.81 $1,399.12 $230.69 $246,672.82
16 $1,629.81 $1,397.81 $232.00 $246,440.82
17 $1,629.81 $1,396.50 $233.32 $246,207.50
18 $1,629.81 $1,395.18 $234.64 $245,972.86
19 $1,629.81 $1,393.85 $235.97 $245,736.90
20 $1,629.81 $1,392.51 $237.30 $245,499.59
21 $1,629.81 $1,391.16 $238.65 $245,260.94
22 $1,629.81 $1,389.81 $240.00 $245,020.94
23 $1,629.81 $1,388.45 $241.36 $244,779.58
24 $1,629.81 $1,387.08 $242.73 $244,536.85
25 $1,629.81 $1,385.71 $244.10 $244,292.75
26 $1,629.81 $1,384.33 $245.49 $244,047.26
27 $1,629.81 $1,382.93 $246.88 $243,800.38
28 $1,629.81 $1,381.54 $248.28 $243,552.11
29 $1,629.81 $1,380.13 $249.68 $243,302.42
30 $1,629.81 $1,378.71 $251.10 $243,051.32
31 $1,629.81 $1,377.29 $252.52 $242,798.80
32 $1,629.81 $1,375.86 $253.95 $242,544.85
33 $1,629.81 $1,374.42 $255.39 $242,289.45
34 $1,629.81 $1,372.97 $256.84 $242,032.62
35 $1,629.81 $1,371.52 $258.29 $241,774.32
36 $1,629.81 $1,370.05 $259.76 $241,514.56
37 $1,629.81 $1,368.58 $261.23 $241,253.33
38 $1,629.81 $1,367.10 $262.71 $240,990.62
39 $1,629.81 $1,365.61 $264.20 $240,726.42
40 $1,629.81 $1,364.12 $265.70 $240,460.72
41 $1,629.81 $1,362.61 $267.20 $240,193.52
42 $1,629.81 $1,361.10 $268.72 $239,924.81
43 $1,629.81 $1,359.57 $270.24 $239,654.57
44 $1,629.81 $1,358.04 $271.77 $239,382.80
45 $1,629.81 $1,356.50 $273.31 $239,109.49
46 $1,629.81 $1,354.95 $274.86 $238,834.63
47 $1,629.81 $1,353.40 $276.42 $238,558.21
48 $1,629.81 $1,351.83 $277.98 $238,280.23
49 $1,629.81 $1,350.25 $279.56 $238,000.67
50 $1,629.81 $1,348.67 $281.14 $237,719.53
51 $1,629.81 $1,347.08 $282.74 $237,436.79
52 $1,629.81 $1,345.48 $284.34 $237,152.45
53 $1,629.81 $1,343.86 $285.95 $236,866.50
54 $1,629.81 $1,342.24 $287.57 $236,578.93
55 $1,629.81 $1,340.61 $289.20 $236,289.74
56 $1,629.81 $1,338.98 $290.84 $235,998.90
57 $1,629.81 $1,337.33 $292.49 $235,706.41
58 $1,629.81 $1,335.67 $294.14 $235,412.27
59 $1,629.81 $1,334.00 $295.81 $235,116.46
60 $1,629.81 $1,332.33 $297.49 $234,818.97
61 $1,629.81 $1,330.64 $299.17 $234,519.80
62 $1,629.81 $1,328.95 $300.87 $234,218.93
63 $1,629.81 $1,327.24 $302.57 $233,916.36
64 $1,629.81 $1,325.53 $304.29 $233,612.07
65 $1,629.81 $1,323.80 $306.01 $233,306.06
66 $1,629.81 $1,322.07 $307.75 $232,998.32
67 $1,629.81 $1,320.32 $309.49 $232,688.83
68 $1,629.81 $1,318.57 $311.24 $232,377.58
69 $1,629.81 $1,316.81 $313.01 $232,064.58
70 $1,629.81 $1,315.03 $314.78 $231,749.80
71 $1,629.81 $1,313.25 $316.56 $231,433.23
72 $1,629.81 $1,311.45 $318.36 $231,114.88
73 $1,629.81 $1,309.65 $320.16 $230,794.71
74 $1,629.81 $1,307.84 $321.98 $230,472.74
75 $1,629.81 $1,306.01 $323.80 $230,148.94
76 $1,629.81 $1,304.18 $325.64 $229,823.30
77 $1,629.81 $1,302.33 $327.48 $229,495.82
78 $1,629.81 $1,300.48 $329.34 $229,166.48
79 $1,629.81 $1,298.61 $331.20 $228,835.28
80 $1,629.81 $1,296.73 $333.08 $228,502.20
81 $1,629.81 $1,294.85 $334.97 $228,167.23
82 $1,629.81 $1,292.95 $336.87 $227,830.37
83 $1,629.81 $1,291.04 $338.77 $227,491.59
84 $1,629.81 $1,289.12 $340.69 $227,150.90
85 $1,629.81 $1,287.19 $342.62 $226,808.28
86 $1,629.81 $1,285.25 $344.57 $226,463.71
87 $1,629.81 $1,283.29 $346.52 $226,117.19
88 $1,629.81 $1,281.33 $348.48 $225,768.71
89 $1,629.81 $1,279.36 $350.46 $225,418.25
90 $1,629.81 $1,277.37 $352.44 $225,065.81
91 $1,629.81 $1,275.37 $354.44 $224,711.37
92 $1,629.81 $1,273.36 $356.45 $224,354.92
93 $1,629.81 $1,271.34 $358.47 $223,996.45
94 $1,629.81 $1,269.31 $360.50 $223,635.95
95 $1,629.81 $1,267.27 $362.54 $223,273.41
96 $1,629.81 $1,265.22 $364.60 $222,908.81
97 $1,629.81 $1,263.15 $366.66 $222,542.15
98 $1,629.81 $1,261.07 $368.74 $222,173.41
99 $1,629.81 $1,258.98 $370.83 $221,802.58
100 $1,629.81 $1,256.88 $372.93 $221,429.65
101 $1,629.81 $1,254.77 $375.04 $221,054.60
102 $1,629.81 $1,252.64 $377.17 $220,677.43
103 $1,629.81 $1,250.51 $379.31 $220,298.12
104 $1,629.81 $1,248.36 $381.46 $219,916.67
105 $1,629.81 $1,246.19 $383.62 $219,533.05
106 $1,629.81 $1,244.02 $385.79 $219,147.26
107 $1,629.81 $1,241.83 $387.98 $218,759.28
108 $1,629.81 $1,239.64 $390.18 $218,369.10
109 $1,629.81 $1,237.42 $392.39 $217,976.71
110 $1,629.81 $1,235.20 $394.61 $217,582.10
111 $1,629.81 $1,232.97 $396.85 $217,185.25
112 $1,629.81 $1,230.72 $399.10 $216,786.16
113 $1,629.81 $1,228.45 $401.36 $216,384.80
114 $1,629.81 $1,226.18 $403.63 $215,981.17
115 $1,629.81 $1,223.89 $405.92 $215,575.25
116 $1,629.81 $1,221.59 $408.22 $215,167.03
117 $1,629.81 $1,219.28 $410.53 $214,756.49
118 $1,629.81 $1,216.95 $412.86 $214,343.63
119 $1,629.81 $1,214.61 $415.20 $213,928.43
120 $1,629.81 $1,212.26 $417.55 $213,510.88
121 $1,629.81 $1,209.90 $419.92 $213,090.96
122 $1,629.81 $1,207.52 $422.30 $212,668.67
123 $1,629.81 $1,205.12 $424.69 $212,243.98
124 $1,629.81 $1,202.72 $427.10 $211,816.88
125 $1,629.81 $1,200.30 $429.52 $211,387.36
126 $1,629.81 $1,197.86 $431.95 $210,955.41
127 $1,629.81 $1,195.41 $434.40 $210,521.01
128 $1,629.81 $1,192.95 $436.86 $210,084.15
129 $1,629.81 $1,190.48 $439.34 $209,644.82
130 $1,629.81 $1,187.99 $441.83 $209,202.99
131 $1,629.81 $1,185.48 $444.33 $208,758.66
132 $1,629.81 $1,182.97 $446.85 $208,311.81
133 $1,629.81 $1,180.43 $449.38 $207,862.43
134 $1,629.81 $1,177.89 $451.93 $207,410.51
135 $1,629.81 $1,175.33 $454.49 $206,956.02
136 $1,629.81 $1,172.75 $457.06 $206,498.96
137 $1,629.81 $1,170.16 $459.65 $206,039.31
138 $1,629.81 $1,167.56 $462.26 $205,577.05
139 $1,629.81 $1,164.94 $464.88 $205,112.17
140 $1,629.81 $1,162.30 $467.51 $204,644.66
141 $1,629.81 $1,159.65 $470.16 $204,174.50
142 $1,629.81 $1,156.99 $472.82 $203,701.68
143 $1,629.81 $1,154.31 $475.50 $203,226.18
144 $1,629.81 $1,151.61 $478.20 $202,747.98
145 $1,629.81 $1,148.91 $480.91 $202,267.07
146 $1,629.81 $1,146.18 $483.63 $201,783.44
147 $1,629.81 $1,143.44 $486.37 $201,297.06
148 $1,629.81 $1,140.68 $489.13 $200,807.93
149 $1,629.81 $1,137.91 $491.90 $200,316.03
150 $1,629.81 $1,135.12 $494.69 $199,821.34
151 $1,629.81 $1,132.32 $497.49 $199,323.85
152 $1,629.81 $1,129.50 $500.31 $198,823.54
153 $1,629.81 $1,126.67 $503.15 $198,320.39
154 $1,629.81 $1,123.82 $506.00 $197,814.40
155 $1,629.81 $1,120.95 $508.86 $197,305.53
156 $1,629.81 $1,118.06 $511.75 $196,793.78
157 $1,629.81 $1,115.16 $514.65 $196,279.14
158 $1,629.81 $1,112.25 $517.56 $195,761.57
159 $1,629.81 $1,109.32 $520.50 $195,241.07
160 $1,629.81 $1,106.37 $523.45 $194,717.63
161 $1,629.81 $1,103.40 $526.41 $194,191.21
162 $1,629.81 $1,100.42 $529.40 $193,661.82
163 $1,629.81 $1,097.42 $532.40 $193,129.42
164 $1,629.81 $1,094.40 $535.41 $192,594.01
165 $1,629.81 $1,091.37 $538.45 $192,055.56
166 $1,629.81 $1,088.31 $541.50 $191,514.06
167 $1,629.81 $1,085.25 $544.57 $190,969.50
168 $1,629.81 $1,082.16 $547.65 $190,421.84
169 $1,629.81 $1,079.06 $550.76 $189,871.09
170 $1,629.81 $1,075.94 $553.88 $189,317.21
171 $1,629.81 $1,072.80 $557.02 $188,760.20
172 $1,629.81 $1,069.64 $560.17 $188,200.02
173 $1,629.81 $1,066.47 $563.35 $187,636.68
174 $1,629.81 $1,063.27 $566.54 $187,070.14
175 $1,629.81 $1,060.06 $569.75 $186,500.39
176 $1,629.81 $1,056.84 $572.98 $185,927.41
177 $1,629.81 $1,053.59 $576.22 $185,351.19
178 $1,629.81 $1,050.32 $579.49 $184,771.70
179 $1,629.81 $1,047.04 $582.77 $184,188.93
180 $1,629.81 $1,043.74 $586.08 $183,602.85
181 $1,629.81 $1,040.42 $589.40 $183,013.45
182 $1,629.81 $1,037.08 $592.74 $182,420.72
183 $1,629.81 $1,033.72 $596.10 $181,824.62
184 $1,629.81 $1,030.34 $599.47 $181,225.15
185 $1,629.81 $1,026.94 $602.87 $180,622.28
186 $1,629.81 $1,023.53 $606.29 $180,015.99
187 $1,629.81 $1,020.09 $609.72 $179,406.27
188 $1,629.81 $1,016.64 $613.18 $178,793.09
189 $1,629.81 $1,013.16 $616.65 $178,176.44
190 $1,629.81 $1,009.67 $620.15 $177,556.29
191 $1,629.81 $1,006.15 $623.66 $176,932.63
192 $1,629.81 $1,002.62 $627.19 $176,305.44
193 $1,629.81 $999.06 $630.75 $175,674.69
194 $1,629.81 $995.49 $634.32 $175,040.36
195 $1,629.81 $991.90 $637.92 $174,402.45
196 $1,629.81 $988.28 $641.53 $173,760.91
197 $1,629.81 $984.65 $645.17 $173,115.75
198 $1,629.81 $980.99 $648.82 $172,466.92
199 $1,629.81 $977.31 $652.50 $171,814.42
200 $1,629.81 $973.62 $656.20 $171,158.22
201 $1,629.81 $969.90 $659.92 $170,498.31
202 $1,629.81 $966.16 $663.66 $169,834.65
203 $1,629.81 $962.40 $667.42 $169,167.24
204 $1,629.81 $958.61 $671.20 $168,496.04
205 $1,629.81 $954.81 $675.00 $167,821.04
206 $1,629.81 $950.99 $678.83 $167,142.21
207 $1,629.81 $947.14 $682.67 $166,459.53
208 $1,629.81 $943.27 $686.54 $165,772.99
209 $1,629.81 $939.38 $690.43 $165,082.56
210 $1,629.81 $935.47 $694.35 $164,388.21
211 $1,629.81 $931.53 $698.28 $163,689.93
212 $1,629.81 $927.58 $702.24 $162,987.70
213 $1,629.81 $923.60 $706.22 $162,281.48
214 $1,629.81 $919.60 $710.22 $161,571.26
215 $1,629.81 $915.57 $714.24 $160,857.02
216 $1,629.81 $911.52 $718.29 $160,138.73
217 $1,629.81 $907.45 $722.36 $159,416.37
218 $1,629.81 $903.36 $726.45 $158,689.92
219 $1,629.81 $899.24 $730.57 $157,959.35
220 $1,629.81 $895.10 $734.71 $157,224.64
221 $1,629.81 $890.94 $738.87 $156,485.76
222 $1,629.81 $886.75 $743.06 $155,742.70
223 $1,629.81 $882.54 $747.27 $154,995.43
224 $1,629.81 $878.31 $751.51 $154,243.93
225 $1,629.81 $874.05 $755.76 $153,488.16
226 $1,629.81 $869.77 $760.05 $152,728.12
227 $1,629.81 $865.46 $764.35 $151,963.76
228 $1,629.81 $861.13 $768.68 $151,195.08
229 $1,629.81 $856.77 $773.04 $150,422.04
230 $1,629.81 $852.39 $777.42 $149,644.62
231 $1,629.81 $847.99 $781.83 $148,862.79
232 $1,629.81 $843.56 $786.26 $148,076.53
233 $1,629.81 $839.10 $790.71 $147,285.82
234 $1,629.81 $834.62 $795.19 $146,490.63
235 $1,629.81 $830.11 $799.70 $145,690.93
236 $1,629.81 $825.58 $804.23 $144,886.70
237 $1,629.81 $821.02 $808.79 $144,077.91
238 $1,629.81 $816.44 $813.37 $143,264.54
239 $1,629.81 $811.83 $817.98 $142,446.56
240 $1,629.81 $807.20 $822.62 $141,623.94
241 $1,629.81 $802.54 $827.28 $140,796.66
242 $1,629.81 $797.85 $831.97 $139,964.70
243 $1,629.81 $793.13 $836.68 $139,128.02
244 $1,629.81 $788.39 $841.42 $138,286.60
245 $1,629.81 $783.62 $846.19 $137,440.41
246 $1,629.81 $778.83 $850.98 $136,589.42
247 $1,629.81 $774.01 $855.81 $135,733.62
248 $1,629.81 $769.16 $860.66 $134,872.96
249 $1,629.81 $764.28 $865.53 $134,007.43
250 $1,629.81 $759.38 $870.44 $133,136.99
251 $1,629.81 $754.44 $875.37 $132,261.62
252 $1,629.81 $749.48 $880.33 $131,381.29
253 $1,629.81 $744.49 $885.32 $130,495.97
254 $1,629.81 $739.48 $890.34 $129,605.64
255 $1,629.81 $734.43 $895.38 $128,710.25
256 $1,629.81 $729.36 $900.45 $127,809.80
257 $1,629.81 $724.26 $905.56 $126,904.24
258 $1,629.81 $719.12 $910.69 $125,993.55
259 $1,629.81 $713.96 $915.85 $125,077.70
260 $1,629.81 $708.77 $921.04 $124,156.66
261 $1,629.81 $703.55 $926.26 $123,230.41
262 $1,629.81 $698.31 $931.51 $122,298.90
263 $1,629.81 $693.03 $936.79 $121,362.11
264 $1,629.81 $687.72 $942.09 $120,420.02
265 $1,629.81 $682.38 $947.43 $119,472.59
266 $1,629.81 $677.01 $952.80 $118,519.78
267 $1,629.81 $671.61 $958.20 $117,561.58
268 $1,629.81 $666.18 $963.63 $116,597.95
269 $1,629.81 $660.72 $969.09 $115,628.86
270 $1,629.81 $655.23 $974.58 $114,654.28
271 $1,629.81 $649.71 $980.11 $113,674.17
272 $1,629.81 $644.15 $985.66 $112,688.51
273 $1,629.81 $638.57 $991.24 $111,697.27
274 $1,629.81 $632.95 $996.86 $110,700.41
275 $1,629.81 $627.30 $1,002.51 $109,697.90
276 $1,629.81 $621.62 $1,008.19 $108,689.70
277 $1,629.81 $615.91 $1,013.90 $107,675.80
278 $1,629.81 $610.16 $1,019.65 $106,656.15
279 $1,629.81 $604.38 $1,025.43 $105,630.72
280 $1,629.81 $598.57 $1,031.24 $104,599.48
281 $1,629.81 $592.73 $1,037.08 $103,562.40
282 $1,629.81 $586.85 $1,042.96 $102,519.44
283 $1,629.81 $580.94 $1,048.87 $101,470.57
284 $1,629.81 $575.00 $1,054.81 $100,415.76
285 $1,629.81 $569.02 $1,060.79 $99,354.97
286 $1,629.81 $563.01 $1,066.80 $98,288.17
287 $1,629.81 $556.97 $1,072.85 $97,215.32
288 $1,629.81 $550.89 $1,078.93 $96,136.39
289 $1,629.81 $544.77 $1,085.04 $95,051.35
290 $1,629.81 $538.62 $1,091.19 $93,960.17
291 $1,629.81 $532.44 $1,097.37 $92,862.79
292 $1,629.81 $526.22 $1,103.59 $91,759.20
293 $1,629.81 $519.97 $1,109.84 $90,649.36
294 $1,629.81 $513.68 $1,116.13 $89,533.23
295 $1,629.81 $507.35 $1,122.46 $88,410.77
296 $1,629.81 $500.99 $1,128.82 $87,281.95
297 $1,629.81 $494.60 $1,135.22 $86,146.73
298 $1,629.81 $488.16 $1,141.65 $85,005.09
299 $1,629.81 $481.70 $1,148.12 $83,856.97
300 $1,629.81 $475.19 $1,154.62 $82,702.34
301 $1,629.81 $468.65 $1,161.17 $81,541.18
302 $1,629.81 $462.07 $1,167.75 $80,373.43
303 $1,629.81 $455.45 $1,174.36 $79,199.07
304 $1,629.81 $448.79 $1,181.02 $78,018.05
305 $1,629.81 $442.10 $1,187.71 $76,830.34
306 $1,629.81 $435.37 $1,194.44 $75,635.90
307 $1,629.81 $428.60 $1,201.21 $74,434.69
308 $1,629.81 $421.80 $1,208.02 $73,226.67
309 $1,629.81 $414.95 $1,214.86 $72,011.81
310 $1,629.81 $408.07 $1,221.75 $70,790.06
311 $1,629.81 $401.14 $1,228.67 $69,561.40
312 $1,629.81 $394.18 $1,235.63 $68,325.76
313 $1,629.81 $387.18 $1,242.63 $67,083.13
314 $1,629.81 $380.14 $1,249.68 $65,833.45
315 $1,629.81 $373.06 $1,256.76 $64,576.70
316 $1,629.81 $365.93 $1,263.88 $63,312.82
317 $1,629.81 $358.77 $1,271.04 $62,041.78
318 $1,629.81 $351.57 $1,278.24 $60,763.54
319 $1,629.81 $344.33 $1,285.49 $59,478.05
320 $1,629.81 $337.04 $1,292.77 $58,185.28
321 $1,629.81 $329.72 $1,300.10 $56,885.18
322 $1,629.81 $322.35 $1,307.46 $55,577.72
323 $1,629.81 $314.94 $1,314.87 $54,262.85
324 $1,629.81 $307.49 $1,322.32 $52,940.52
325 $1,629.81 $300.00 $1,329.82 $51,610.71
326 $1,629.81 $292.46 $1,337.35 $50,273.35
327 $1,629.81 $284.88 $1,344.93 $48,928.42
328 $1,629.81 $277.26 $1,352.55 $47,575.87
329 $1,629.81 $269.60 $1,360.22 $46,215.66
330 $1,629.81 $261.89 $1,367.92 $44,847.73
331 $1,629.81 $254.14 $1,375.68 $43,472.06
332 $1,629.81 $246.34 $1,383.47 $42,088.58
333 $1,629.81 $238.50 $1,391.31 $40,697.27
334 $1,629.81 $230.62 $1,399.20 $39,298.08
335 $1,629.81 $222.69 $1,407.12 $37,890.95
336 $1,629.81 $214.72 $1,415.10 $36,475.86
337 $1,629.81 $206.70 $1,423.12 $35,052.74
338 $1,629.81 $198.63 $1,431.18 $33,621.56
339 $1,629.81 $190.52 $1,439.29 $32,182.27
340 $1,629.81 $182.37 $1,447.45 $30,734.82
341 $1,629.81 $174.16 $1,455.65 $29,279.17
342 $1,629.81 $165.92 $1,463.90 $27,815.28
343 $1,629.81 $157.62 $1,472.19 $26,343.08
344 $1,629.81 $149.28 $1,480.54 $24,862.55
345 $1,629.81 $140.89 $1,488.93 $23,373.62
346 $1,629.81 $132.45 $1,497.36 $21,876.26
347 $1,629.81 $123.97 $1,505.85 $20,370.41
348 $1,629.81 $115.43 $1,514.38 $18,856.03
349 $1,629.81 $106.85 $1,522.96 $17,333.07
350 $1,629.81 $98.22 $1,531.59 $15,801.48
351 $1,629.81 $89.54 $1,540.27 $14,261.21
352 $1,629.81 $80.81 $1,549.00 $12,712.21
353 $1,629.81 $72.04 $1,557.78 $11,154.43
354 $1,629.81 $63.21 $1,566.60 $9,587.82
355 $1,629.81 $54.33 $1,575.48 $8,012.34
356 $1,629.81 $45.40 $1,584.41 $6,427.93
357 $1,629.81 $36.42 $1,593.39 $4,834.54
358 $1,629.81 $27.40 $1,602.42 $3,232.13
359 $1,629.81 $18.32 $1,611.50 $1,620.63
360 $1,629.81 $9.18 $1,620.63 $0.00
Add a comment
Know the answer?
Add Answer to:
1. Christian and Sarah both graduate from OSU and begin working as financial analysts. They will...
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
  • When Joe and Sarah graduate from college, each expects to work a total of 45 years....

    When Joe and Sarah graduate from college, each expects to work a total of 45 years. Joe begins saving for retirement immediately. He plans to deposit $550 at the end of each quarter into an account paying 7.1% interest, compounded quarterly, for 13 years. He will then leave his balance in the account, oaming the same interest rate, but make no further deposits for 32 years. Sarah plans to save nothing during the first 13 years and then begin depositing...

  • This problem has three questions. Make sure to answer all three questions. For the following problem,...

    This problem has three questions. Make sure to answer all three questions. For the following problem, assume that all debts and payments are incurred at the end of the month and that interest is compounded monthly. Assume that retirement savings are invested in the stock market and earn an annual interest rate of 11%, which is compounded monthly. . Big Spender James gets a credit card at the beginning of his freshman year. • He adds $693 of credit card...

  • 1) Immer and Mays are both saving for retirement in 35 years. Immer starts immediately and...

    1) Immer and Mays are both saving for retirement in 35 years. Immer starts immediately and deposits $175.00 per month into a retirement account with an interest rate of 6% which is compounded annually. Mays waits for 15 years before she starts depositing money in her retirement account at 6% compounded annually. How much money will Mays need to deposit into her account each month to end up with the same amount of savings as Immer when they both retire?...

  • Analyze this saving plan and enter your answer in Questions 4-10. If you use Excel functions...

    Analyze this saving plan and enter your answer in Questions 4-10. If you use Excel functions to calculate the answers, submit the completed Excel file as a group and make sure to include the names of your group members who work on the problem. A 30-year old wants to make a saving plan to meet the following three goals: §  First Goal: To save $150,000 in 5 years for the down payment to purchase a house, which is estimated to be...

  • 1.An investment will pay you $500 every year starting 1 year from today and goes on...

    1.An investment will pay you $500 every year starting 1 year from today and goes on forever. If the interest rate is 5% p.a., what is the maximum price that you would pay for this investment? 2.You are given $200 each year starting next year and finishing in 15 years (t=15). If the interest rate is 6% p.a., what is the maximum price that you would pay for these cash flows? 3.You borrow $100,000 today, the annual interest rate is...

  • I really do not understand this... please help with explanations. thank you so much in advance! Paragraph stalled, b...

    I really do not understand this... please help with explanations. thank you so much in advance! Paragraph stalled, but first we need to close some apps. Update now 1. All other things equal, how will the following impact the future value: a) increase in the present value, b) decrease in the interest rate, c) increase in the number of time periods. 3 points 2. All other things equal, how will the following impact the present value: a) increase in the...

  • Lab 3: Saving for Retirement Lab Part 1: The Importance of Starting Early. Because 401(k) accounts...

    Lab 3: Saving for Retirement Lab Part 1: The Importance of Starting Early. Because 401(k) accounts and annuities are an example of the power of compound interest, an amazing amount of growth occurs in the later years of the 401(k) or annuity. This can be calculated with the formula 12M*((1+) "8) – 1) Balance after nt deposits = 1. Lulu started saving $200/month in a 401(k) earning 6% interest compounded monthly when she was 45 years old. How much will...

  • Your best friend Dave just celebrated his 24th birthday and wants to start saving for his...

    Your best friend Dave just celebrated his 24th birthday and wants to start saving for his anticipated retirement. Dave plans to retire in 36 years and believes that he will have 25 good years of retirement and believes that if he can withdraw $125,000 at the end of each year, he can enjoy his retirement. Assume that a reasonable rate of interest for Dave for all scenarios presented below is 6.5% per year. This is an annual rate, review each...

  • Retirement planning Personal Finance Problem Hal Thomas, a 30-year-old college graduate, wishes to retire at age...

    Retirement planning Personal Finance Problem Hal Thomas, a 30-year-old college graduate, wishes to retire at age 60 To supplement other sources of retirement income, he can deposit $2,300 each year into a tax-deferred individual retirement arrangement (IRA) The IRA will earn a return of 15% over the next 30 years a. If Hal makes end-of-year S2,300 deposits into the IRA, how much will he have accumulated in 30 years when he turns 60? b. If Hal decides to wait until...

  • 1. Calculate the accumulated value of an ordinary annuity of $4,200 a year for 6 years...

    1. Calculate the accumulated value of an ordinary annuity of $4,200 a year for 6 years if the money is worth 71 2 %. 2. Find the future value of the cash flow of $600 a month for 5 years at 9% interest compounded monthly. 3. If Gabe makes a $450 deposit into his savings fund at the end of each quarter for 6 years, how much will he be able to collect at the end of the sixth year...

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