# Mortgage: What is the payoff on a 30 year, 6% original mortgage of $170,215 with a payment of... ## Question: Mortgage: What is the payoff on a 30 year, 6% original mortgage of$170,215 with a payment of 960.57 with 7 years remaining?

(PROVIDE EXCEL FORMULA)

## Mortgage Payoff:

A mortgage is a loan applied for the purchase of a house. The terms of the mortgage include the time period, mortgage amount and interest rate. The buyer of the house is expected to pay periodically some amount that is apportioned to settle the accrued interest and to partially reduce the mortgage amount. A buyer may decide to pay off the mortgage earlier than the defined time period and this will call for the applicable payoff to be calculated

Information Provided

Mortgage = $170,215 n = 30 years * 12 = 360 months APR = 6%; r = 0.06/12 = 0.005 Payment =$960.57

Based on this information the estimated loan amount is

• {eq}Loan = Payment * \dfrac{(1 - (1 + r )^{-n}) }{ r} {/eq}
• {eq}Loan = 960.57* \dfrac{(1 - (1 + 0.005 )^{-360}) }{ 0.005} {/eq}
• {eq}Loan = 960.57* 166.7916144 {/eq}
• {eq}Loan = 160,215.02 {/eq}

From the above calculations ;

Mortgage = $170,215 Loan = 160,215.02 Down payment =$10,000

The mortgage payoff will consist of the loan balance plus interest charged on the loan balance.

• {eq}Loan \ balance = Payment * \dfrac{(1 - (1 + r )^{-(n-t)}) }{ r} {/eq}

n -t = (30-23)*12 =84

• {eq}Loan \ balance = 960.57 * \dfrac{(1 - (1 + 0.005 )^{-(84)}) }{ 0.005} {/eq}
• {eq}Loan \ balance = 960.57 *68.45304244 {/eq}
• {eq}Loan \ balance = $65,753.94 {/eq} To calculate the payoff • Payoff = Loan Balance + Interest Paid • Payoff = 65,753.94 + (0.005*65,753.94) • Payoff =$66,082.71

Amortization SChedule

1. Interest = Interest rate * Beginning loan balance

2. Principal paid = Monthly payments - interest paid

3. Ending balance = Beginning loan balance - Principal paid

Period Beginning Balance Total Payment Interest Paid Principal Paid Ending Balance
1 160,215.02 960.57 801.08 159.49 160,055.53
2 160,055.53 960.57 800.28 160.29 159,895.23
3 159,895.23 960.57 799.48 161.09 159,734.14
4 159,734.14 960.57 798.67 161.90 159,572.24
5 159,572.24 960.57 797.86 162.71 159,409.53
6 159,409.53 960.57 797.05 163.52 159,246.01
7 159,246.01 960.57 796.23 164.34 159,081.67
8 159,081.67 960.57 795.41 165.16 158,916.51
9 158,916.51 960.57 794.58 165.99 158,750.52
10 158,750.52 960.57 793.75 166.82 158,583.70
11 158,583.70 960.57 792.92 167.65 158,416.05
12 158,416.05 960.57 792.08 168.49 158,247.56
13 158,247.56 960.57 791.24 169.33 158,078.23
14 158,078.23 960.57 790.39 170.18 157,908.05
15 157,908.05 960.57 789.54 171.03 157,737.02
16 157,737.02 960.57 788.69 171.88 157,565.14
17 157,565.14 960.57 787.83 172.74 157,392.39
18 157,392.39 960.57 786.96 173.61 157,218.78
19 157,218.78 960.57 786.09 174.48 157,044.31
20 157,044.31 960.57 785.22 175.35 156,868.96
21 156,868.96 960.57 784.34 176.23 156,692.73
22 156,692.73 960.57 783.46 177.11 156,515.63
23 156,515.63 960.57 782.58 177.99 156,337.63
24 156,337.63 960.57 781.69 178.88 156,158.75
25 156,158.75 960.57 780.79 179.78 155,978.98
26 155,978.98 960.57 779.89 180.68 155,798.30
27 155,798.30 960.57 778.99 181.58 155,616.72
28 155,616.72 960.57 778.08 182.49 155,434.24
29 155,434.24 960.57 777.17 183.40 155,250.84
30 155,250.84 960.57 776.25 184.32 155,066.52
31 155,066.52 960.57 775.33 185.24 154,881.28
32 154,881.28 960.57 774.41 186.16 154,695.12
33 154,695.12 960.57 773.48 187.09 154,508.03
34 154,508.03 960.57 772.54 188.03 154,320.00
35 154,320.00 960.57 771.60 188.97 154,131.03
36 154,131.03 960.57 770.66 189.91 153,941.11
37 153,941.11 960.57 769.71 190.86 153,750.25
38 153,750.25 960.57 768.75 191.82 153,558.43
39 153,558.43 960.57 767.79 192.78 153,365.65
40 153,365.65 960.57 766.83 193.74 153,171.91
41 153,171.91 960.57 765.86 194.71 152,977.20
42 152,977.20 960.57 764.89 195.68 152,781.51
43 152,781.51 960.57 763.91 196.66 152,584.85
44 152,584.85 960.57 762.92 197.65 152,387.21
45 152,387.21 960.57 761.94 198.63 152,188.57
46 152,188.57 960.57 760.94 199.63 151,988.95
47 151,988.95 960.57 759.94 200.63 151,788.32
48 151,788.32 960.57 758.94 201.63 151,586.69
49 151,586.69 960.57 757.93 202.64 151,384.06
50 151,384.06 960.57 756.92 203.65 151,180.41
51 151,180.41 960.57 755.90 204.67 150,975.74
52 150,975.74 960.57 754.88 205.69 150,770.05
53 150,770.05 960.57 753.85 206.72 150,563.33
54 150,563.33 960.57 752.82 207.75 150,355.57
55 150,355.57 960.57 751.78 208.79 150,146.78
56 150,146.78 960.57 750.73 209.84 149,936.94
57 149,936.94 960.57 749.68 210.89 149,726.06
58 149,726.06 960.57 748.63 211.94 149,514.12
59 149,514.12 960.57 747.57 213.00 149,301.12
60 149,301.12 960.57 746.51 214.06 149,087.06
61 149,087.06 960.57 745.44 215.13 148,871.92
62 148,871.92 960.57 744.36 216.21 148,655.71
63 148,655.71 960.57 743.28 217.29 148,438.42
64 148,438.42 960.57 742.19 218.38 148,220.04
65 148,220.04 960.57 741.10 219.47 148,000.57
66 148,000.57 960.57 740.00 220.57 147,780.00
67 147,780.00 960.57 738.90 221.67 147,558.33
68 147,558.33 960.57 737.79 222.78 147,335.56
69 147,335.56 960.57 736.68 223.89 147,111.66
70 147,111.66 960.57 735.56 225.01 146,886.65
71 146,886.65 960.57 734.43 226.14 146,660.52
72 146,660.52 960.57 733.30 227.27 146,433.25
73 146,433.25 960.57 732.17 228.40 146,204.84
74 146,204.84 960.57 731.02 229.55 145,975.30
75 145,975.30 960.57 729.88 230.69 145,744.61
76 145,744.61 960.57 728.72 231.85 145,512.76
77 145,512.76 960.57 727.56 233.01 145,279.75
78 145,279.75 960.57 726.40 234.17 145,045.58
79 145,045.58 960.57 725.23 235.34 144,810.24
80 144,810.24 960.57 724.05 236.52 144,573.72
81 144,573.72 960.57 722.87 237.70 144,336.02
82 144,336.02 960.57 721.68 238.89 144,097.13
83 144,097.13 960.57 720.49 240.08 143,857.04
84 143,857.04 960.57 719.29 241.28 143,615.76
85 143,615.76 960.57 718.08 242.49 143,373.27
86 143,373.27 960.57 716.87 243.70 143,129.56
87 143,129.56 960.57 715.65 244.92 142,884.64
88 142,884.64 960.57 714.42 246.15 142,638.50
89 142,638.50 960.57 713.19 247.38 142,391.12
90 142,391.12 960.57 711.96 248.61 142,142.50
91 142,142.50 960.57 710.71 249.86 141,892.65
92 141,892.65 960.57 709.46 251.11 141,641.54
93 141,641.54 960.57 708.21 252.36 141,389.18
94 141,389.18 960.57 706.95 253.62 141,135.55
95 141,135.55 960.57 705.68 254.89 140,880.66
96 140,880.66 960.57 704.40 256.17 140,624.49
97 140,624.49 960.57 703.12 257.45 140,367.05
98 140,367.05 960.57 701.84 258.73 140,108.31
99 140,108.31 960.57 700.54 260.03 139,848.28
100 139,848.28 960.57 699.24 261.33 139,586.95
101 139,586.95 960.57 697.93 262.64 139,324.32
102 139,324.32 960.57 696.62 263.95 139,060.37
103 139,060.37 960.57 695.30 265.27 138,795.10
104 138,795.10 960.57 693.98 266.59 138,528.51
105 138,528.51 960.57 692.64 267.93 138,260.58
106 138,260.58 960.57 691.30 269.27 137,991.31
107 137,991.31 960.57 689.96 270.61 137,720.70
108 137,720.70 960.57 688.60 271.97 137,448.73
109 137,448.73 960.57 687.24 273.33 137,175.41
110 137,175.41 960.57 685.88 274.69 136,900.71
111 136,900.71 960.57 684.50 276.07 136,624.65
112 136,624.65 960.57 683.12 277.45 136,347.20
113 136,347.20 960.57 681.74 278.83 136,068.37
114 136,068.37 960.57 680.34 280.23 135,788.14
115 135,788.14 960.57 678.94 281.63 135,506.51
116 135,506.51 960.57 677.53 283.04 135,223.47
117 135,223.47 960.57 676.12 284.45 134,939.02
118 134,939.02 960.57 674.70 285.87 134,653.15
119 134,653.15 960.57 673.27 287.30 134,365.84
120 134,365.84 960.57 671.83 288.74 134,077.10
121 134,077.10 960.57 670.39 290.18 133,786.92
122 133,786.92 960.57 668.93 291.64 133,495.28
123 133,495.28 960.57 667.48 293.09 133,202.19
124 133,202.19 960.57 666.01 294.56 132,907.63
125 132,907.63 960.57 664.54 296.03 132,611.60
126 132,611.60 960.57 663.06 297.51 132,314.08
127 132,314.08 960.57 661.57 299.00 132,015.08
128 132,015.08 960.57 660.08 300.49 131,714.59
129 131,714.59 960.57 658.57 302.00 131,412.59
130 131,412.59 960.57 657.06 303.51 131,109.09
131 131,109.09 960.57 655.55 305.02 130,804.06
132 130,804.06 960.57 654.02 306.55 130,497.51
133 130,497.51 960.57 652.49 308.08 130,189.43
134 130,189.43 960.57 650.95 309.62 129,879.81
135 129,879.81 960.57 649.40 311.17 129,568.63
136 129,568.63 960.57 647.84 312.73 129,255.91
137 129,255.91 960.57 646.28 314.29 128,941.62
138 128,941.62 960.57 644.71 315.86 128,625.76
139 128,625.76 960.57 643.13 317.44 128,308.31
140 128,308.31 960.57 641.54 319.03 127,989.29
141 127,989.29 960.57 639.95 320.62 127,668.66
142 127,668.66 960.57 638.34 322.23 127,346.44
143 127,346.44 960.57 636.73 323.84 127,022.60
144 127,022.60 960.57 635.11 325.46 126,697.14
145 126,697.14 960.57 633.49 327.08 126,370.06
146 126,370.06 960.57 631.85 328.72 126,041.34
147 126,041.34 960.57 630.21 330.36 125,710.97
148 125,710.97 960.57 628.55 332.02 125,378.96
149 125,378.96 960.57 626.89 333.68 125,045.28
150 125,045.28 960.57 625.23 335.34 124,709.94
151 124,709.94 960.57 623.55 337.02 124,372.92
152 124,372.92 960.57 621.86 338.71 124,034.21
153 124,034.21 960.57 620.17 340.40 123,693.81
154 123,693.81 960.57 618.47 342.10 123,351.71
155 123,351.71 960.57 616.76 343.81 123,007.90
156 123,007.90 960.57 615.04 345.53 122,662.37
157 122,662.37 960.57 613.31 347.26 122,315.11
158 122,315.11 960.57 611.58 348.99 121,966.12
159 121,966.12 960.57 609.83 350.74 121,615.38
160 121,615.38 960.57 608.08 352.49 121,262.89
161 121,262.89 960.57 606.31 354.26 120,908.63
162 120,908.63 960.57 604.54 356.03 120,552.60
163 120,552.60 960.57 602.76 357.81 120,194.80
164 120,194.80 960.57 600.97 359.60 119,835.20
165 119,835.20 960.57 599.18 361.39 119,473.81
166 119,473.81 960.57 597.37 363.20 119,110.61
167 119,110.61 960.57 595.55 365.02 118,745.59
168 118,745.59 960.57 593.73 366.84 118,378.75
169 118,378.75 960.57 591.89 368.68 118,010.07
170 118,010.07 960.57 590.05 370.52 117,639.55
171 117,639.55 960.57 588.20 372.37 117,267.18
172 117,267.18 960.57 586.34 374.23 116,892.95
173 116,892.95 960.57 584.46 376.11 116,516.84
174 116,516.84 960.57 582.58 377.99 116,138.85
175 116,138.85 960.57 580.69 379.88 115,758.98
176 115,758.98 960.57 578.79 381.78 115,377.20
177 115,377.20 960.57 576.89 383.68 114,993.52
178 114,993.52 960.57 574.97 385.60 114,607.92
179 114,607.92 960.57 573.04 387.53 114,220.39
180 114,220.39 960.57 571.10 389.47 113,830.92
181 113,830.92 960.57 569.15 391.42 113,439.50
182 113,439.50 960.57 567.20 393.37 113,046.13
183 113,046.13 960.57 565.23 395.34 112,650.79
184 112,650.79 960.57 563.25 397.32 112,253.48
185 112,253.48 960.57 561.27 399.30 111,854.17
186 111,854.17 960.57 559.27 401.30 111,452.87
187 111,452.87 960.57 557.26 403.31 111,049.57
188 111,049.57 960.57 555.25 405.32 110,644.25
189 110,644.25 960.57 553.22 407.35 110,236.90
190 110,236.90 960.57 551.18 409.39 109,827.51
191 109,827.51 960.57 549.14 411.43 109,416.08
192 109,416.08 960.57 547.08 413.49 109,002.59
193 109,002.59 960.57 545.01 415.56 108,587.03
194 108,587.03 960.57 542.94 417.63 108,169.40
195 108,169.40 960.57 540.85 419.72 107,749.67
196 107,749.67 960.57 538.75 421.82 107,327.85
197 107,327.85 960.57 536.64 423.93 106,903.92
198 106,903.92 960.57 534.52 426.05 106,477.87
199 106,477.87 960.57 532.39 428.18 106,049.69
200 106,049.69 960.57 530.25 430.32 105,619.37
201 105,619.37 960.57 528.10 432.47 105,186.90
202 105,186.90 960.57 525.93 434.64 104,752.26
203 104,752.26 960.57 523.76 436.81 104,315.45
204 104,315.45 960.57 521.58 438.99 103,876.46
205 103,876.46 960.57 519.38 441.19 103,435.27
206 103,435.27 960.57 517.18 443.39 102,991.88
207 102,991.88 960.57 514.96 445.61 102,546.27
208 102,546.27 960.57 512.73 447.84 102,098.43
209 102,098.43 960.57 510.49 450.08 101,648.35
210 101,648.35 960.57 508.24 452.33 101,196.02
211 101,196.02 960.57 505.98 454.59 100,741.43
212 100,741.43 960.57 503.71 456.86 100,284.57
213 100,284.57 960.57 501.42 459.15 99,825.42
214 99,825.42 960.57 499.13 461.44 99,363.98
215 99,363.98 960.57 496.82 463.75 98,900.23
216 98,900.23 960.57 494.50 466.07 98,434.16
217 98,434.16 960.57 492.17 468.40 97,965.76
218 97,965.76 960.57 489.83 470.74 97,495.02
219 97,495.02 960.57 487.48 473.09 97,021.93
220 97,021.93 960.57 485.11 475.46 96,546.47
221 96,546.47 960.57 482.73 477.84 96,068.63
222 96,068.63 960.57 480.34 480.23 95,588.40
223 95,588.40 960.57 477.94 482.63 95,105.77
224 95,105.77 960.57 475.53 485.04 94,620.73
225 94,620.73 960.57 473.10 487.47 94,133.27
226 94,133.27 960.57 470.67 489.90 93,643.36
227 93,643.36 960.57 468.22 492.35 93,151.01
228 93,151.01 960.57 465.76 494.81 92,656.19
229 92,656.19 960.57 463.28 497.29 92,158.90
230 92,158.90 960.57 460.79 499.78 91,659.13
231 91,659.13 960.57 458.30 502.27 91,156.85
232 91,156.85 960.57 455.78 504.79 90,652.07
233 90,652.07 960.57 453.26 507.31 90,144.76
234 90,144.76 960.57 450.72 509.85 89,634.91
235 89,634.91 960.57 448.17 512.40 89,122.52
236 89,122.52 960.57 445.61 514.96 88,607.56
237 88,607.56 960.57 443.04 517.53 88,090.03
238 88,090.03 960.57 440.45 520.12 87,569.91
239 87,569.91 960.57 437.85 522.72 87,047.19
240 87,047.19 960.57 435.24 525.33 86,521.85
241 86,521.85 960.57 432.61 527.96 85,993.89
242 85,993.89 960.57 429.97 530.60 85,463.29
243 85,463.29 960.57 427.32 533.25 84,930.04
244 84,930.04 960.57 424.65 535.92 84,394.12
245 84,394.12 960.57 421.97 538.60 83,855.52
246 83,855.52 960.57 419.28 541.29 83,314.23
247 83,314.23 960.57 416.57 544.00 82,770.23
248 82,770.23 960.57 413.85 546.72 82,223.51
249 82,223.51 960.57 411.12 549.45 81,674.06
250 81,674.06 960.57 408.37 552.20 81,121.86
251 81,121.86 960.57 405.61 554.96 80,566.90
252 80,566.90 960.57 402.83 557.74 80,009.16
253 80,009.16 960.57 400.05 560.52 79,448.64
254 79,448.64 960.57 397.24 563.33 78,885.31
255 78,885.31 960.57 394.43 566.14 78,319.17
256 78,319.17 960.57 391.60 568.97 77,750.19
257 77,750.19 960.57 388.75 571.82 77,178.37
258 77,178.37 960.57 385.89 574.68 76,603.70
259 76,603.70 960.57 383.02 577.55 76,026.14
260 76,026.14 960.57 380.13 580.44 75,445.70
261 75,445.70 960.57 377.23 583.34 74,862.36
262 74,862.36 960.57 374.31 586.26 74,276.10
263 74,276.10 960.57 371.38 589.19 73,686.92
264 73,686.92 960.57 368.43 592.14 73,094.78
265 73,094.78 960.57 365.47 595.10 72,499.68
266 72,499.68 960.57 362.50 598.07 71,901.61
267 71,901.61 960.57 359.51 601.06 71,300.55
268 71,300.55 960.57 356.50 604.07 70,696.48
269 70,696.48 960.57 353.48 607.09 70,089.40
270 70,089.40 960.57 350.45 610.12 69,479.27
271 69,479.27 960.57 347.40 613.17 68,866.10
272 68,866.10 960.57 344.33 616.24 68,249.86
273 68,249.86 960.57 341.25 619.32 67,630.54
274 67,630.54 960.57 338.15 622.42 67,008.12
275 67,008.12 960.57 335.04 625.53 66,382.59
276 66,382.59 960.57 331.91 628.66 65,753.93
277 65,753.93 960.57 328.77 631.80 65,122.13
278 65,122.13 960.57 325.61 634.96 64,487.18
279 64,487.18 960.57 322.44 638.13 63,849.04
280 63,849.04 960.57 319.25 641.32 63,207.72
281 63,207.72 960.57 316.04 644.53 62,563.18
282 62,563.18 960.57 312.82 647.75 61,915.43
283 61,915.43 960.57 309.58 650.99 61,264.44
284 61,264.44 960.57 306.32 654.25 60,610.19
285 60,610.19 960.57 303.05 657.52 59,952.67
286 59,952.67 960.57 299.76 660.81 59,291.86
287 59,291.86 960.57 296.46 664.11 58,627.75
288 58,627.75 960.57 293.14 667.43 57,960.32
289 57,960.32 960.57 289.80 670.77 57,289.55
290 57,289.55 960.57 286.45 674.12 56,615.43
291 56,615.43 960.57 283.08 677.49 55,937.94
292 55,937.94 960.57 279.69 680.88 55,257.06
293 55,257.06 960.57 276.29 684.28 54,572.77
294 54,572.77 960.57 272.86 687.71 53,885.07
295 53,885.07 960.57 269.43 691.14 53,193.92
296 53,193.92 960.57 265.97 694.60 52,499.32
297 52,499.32 960.57 262.50 698.07 51,801.25
298 51,801.25 960.57 259.01 701.56 51,099.69
299 51,099.69 960.57 255.50 705.07 50,394.61
300 50,394.61 960.57 251.97 708.60 49,686.02
301 49,686.02 960.57 248.43 712.14 48,973.88
302 48,973.88 960.57 244.87 715.70 48,258.18
303 48,258.18 960.57 241.29 719.28 47,538.90
304 47,538.90 960.57 237.69 722.88 46,816.02
305 46,816.02 960.57 234.08 726.49 46,089.53
306 46,089.53 960.57 230.45 730.12 45,359.41
307 45,359.41 960.57 226.80 733.77 44,625.64
308 44,625.64 960.57 223.13 737.44 43,888.20
309 43,888.20 960.57 219.44 741.13 43,147.07
310 43,147.07 960.57 215.74 744.83 42,402.23
311 42,402.23 960.57 212.01 748.56 41,653.67
312 41,653.67 960.57 208.27 752.30 40,901.37
313 40,901.37 960.57 204.51 756.06 40,145.31
314 40,145.31 960.57 200.73 759.84 39,385.46
315 39,385.46 960.57 196.93 763.64 38,621.82
316 38,621.82 960.57 193.11 767.46 37,854.36
317 37,854.36 960.57 189.27 771.30 37,083.06
318 37,083.06 960.57 185.42 775.15 36,307.91
319 36,307.91 960.57 181.54 779.03 35,528.88
320 35,528.88 960.57 177.64 782.93 34,745.95
321 34,745.95 960.57 173.73 786.84 33,959.11
322 33,959.11 960.57 169.80 790.77 33,168.34
323 33,168.34 960.57 165.84 794.73 32,373.61
324 32,373.61 960.57 161.87 798.70 31,574.91
325 31,574.91 960.57 157.87 802.70 30,772.21
326 30,772.21 960.57 153.86 806.71 29,965.50
327 29,965.50 960.57 149.83 810.74 29,154.76
328 29,154.76 960.57 145.77 814.80 28,339.96
329 28,339.96 960.57 141.70 818.87 27,521.09
330 27,521.09 960.57 137.61 822.96 26,698.13
331 26,698.13 960.57 133.49 827.08 25,871.05
332 25,871.05 960.57 129.36 831.21 25,039.83
333 25,039.83 960.57 125.20 835.37 24,204.46
334 24,204.46 960.57 121.02 839.55 23,364.92
335 23,364.92 960.57 116.82 843.75 22,521.17
336 22,521.17 960.57 112.61 847.96 21,673.21
337 21,673.21 960.57 108.37 852.20 20,821.00
338 20,821.00 960.57 104.11 856.46 19,964.54
339 19,964.54 960.57 99.82 860.75 19,103.79
340 19,103.79 960.57 95.52 865.05 18,238.74
341 18,238.74 960.57 91.19 869.38 17,369.36
342 17,369.36 960.57 86.85 873.72 16,495.64
343 16,495.64 960.57 82.48 878.09 15,617.55
344 15,617.55 960.57 78.09 882.48 14,735.07
345 14,735.07 960.57 73.68 886.89 13,848.17
346 13,848.17 960.57 69.24 891.33 12,956.84
347 12,956.84 960.57 64.78 895.79 12,061.06
348 12,061.06 960.57 60.31 900.26 11,160.79
349 11,160.79 960.57 55.80 904.77 10,256.03
350 10,256.03 960.57 51.28 909.29 9,346.74
351 9,346.74 960.57 46.73 913.84 8,432.90
352 8,432.90 960.57 42.16 918.41 7,514.49
353 7,514.49 960.57 37.57 923.00 6,591.50
354 6,591.50 960.57 32.96 927.61 5,663.88
355 5,663.88 960.57 28.32 932.25 4,731.63
356 4,731.63 960.57 23.66 936.91 3,794.72
357 3,794.72 960.57 18.97 941.60 2,853.13
358 2,853.13 960.57 14.27 946.30 1,906.82
359 1,906.82 960.57 9.53 951.04 955.78
360 955.78 960.57 4.78 955.79 (0.01)
Total 345,805.20 185,590.17 160,215.03