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 |
1. Christian and Sarah both graduate from OSU and begin working as financial analysts. They will...
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, 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 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 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 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, 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 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 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 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 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...