365/360 Interest Type Amortization Table

[bobgilbert]

Long story short, I am trying to back into an amortization table using the following variables:

Original Loan Amount = $575,000
Loan Start Date = 10/24/2011
Payment Date = The 24th day of each month (first payment 11/24/2011)
Interest Type = 365/360
Interest Rate (before adjusting because of 365/360) = 5.5%
Payment for the first 59 months = $4,370.15
Final Payment (60th Month) = $462,357.50

This is all of the information that is shown in my loan document that I thought would need to be given but please let me know what I forgot to provide

Summary: I have my original loan documents showing the information above but my amortization tables I have created do not show a final payment of $462,357.50 and I can't figure out how they got to that number, or what I am doing wrong.

Thanks!

 

[bobgilbert]

Here is my failed attempt. Hopefully I did this so that it is readable (I can't figure out how to format very well in here):

[TABLE="width: 528"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 528"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]Sheet1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Initial loan[/TD]
[TD]$575,000.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Interest rate[/TD]
[TD]5.5%[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Basis[/TD]
[TD]365 / 360[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Term (Years)[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Months Total[/TD]
[TD]60[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]To convert A360 to A365[/TD]
[TD]5.5763889%[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Payment[/TD]
[TD]$4,370.15[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Period[/TD]
[TD]Payment[/TD]
[TD]Interest[/TD]
[TD]Capital[/TD]
[TD]Outstanding[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]-575,000.00[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,672.02[/TD]
[TD="align: right"]$1,698.13[/TD]
[TD="align: right"]($573,301.87)[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,664.13[/TD]
[TD="align: right"]$1,706.02[/TD]
[TD="align: right"]($571,595.85)[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,656.20[/TD]
[TD="align: right"]$1,713.95[/TD]
[TD="align: right"]($569,881.90)[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,648.24[/TD]
[TD="align: right"]$1,721.91[/TD]
[TD="align: right"]($568,159.98)[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,640.23[/TD]
[TD="align: right"]$1,729.92[/TD]
[TD="align: right"]($566,430.07)[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,632.20[/TD]
[TD="align: right"]$1,737.95[/TD]
[TD="align: right"]($564,692.11)[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,624.12[/TD]
[TD="align: right"]$1,746.03[/TD]
[TD="align: right"]($562,946.08)[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,616.01[/TD]
[TD="align: right"]$1,754.14[/TD]
[TD="align: right"]($561,191.94)[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,607.85[/TD]
[TD="align: right"]$1,762.30[/TD]
[TD="align: right"]($559,429.64)[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,599.66[/TD]
[TD="align: right"]$1,770.49[/TD]
[TD="align: right"]($557,659.16)[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,591.44[/TD]
[TD="align: right"]$1,778.71[/TD]
[TD="align: right"]($555,880.44)[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,583.17[/TD]
[TD="align: right"]$1,786.98[/TD]
[TD="align: right"]($554,093.46)[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,574.87[/TD]
[TD="align: right"]$1,795.28[/TD]
[TD="align: right"]($552,298.18)[/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,566.52[/TD]
[TD="align: right"]$1,803.63[/TD]
[TD="align: right"]($550,494.56)[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,558.14[/TD]
[TD="align: right"]$1,812.01[/TD]
[TD="align: right"]($548,682.55)[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,549.72[/TD]
[TD="align: right"]$1,820.43[/TD]
[TD="align: right"]($546,862.12)[/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,541.26[/TD]
[TD="align: right"]$1,828.89[/TD]
[TD="align: right"]($545,033.24)[/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,532.76[/TD]
[TD="align: right"]$1,837.39[/TD]
[TD="align: right"]($543,195.85)[/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,524.23[/TD]
[TD="align: right"]$1,845.92[/TD]
[TD="align: right"]($541,349.93)[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,515.65[/TD]
[TD="align: right"]$1,854.50[/TD]
[TD="align: right"]($539,495.42)[/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,507.03[/TD]
[TD="align: right"]$1,863.12[/TD]
[TD="align: right"]($537,632.30)[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,498.37[/TD]
[TD="align: right"]$1,871.78[/TD]
[TD="align: right"]($535,760.53)[/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,489.67[/TD]
[TD="align: right"]$1,880.48[/TD]
[TD="align: right"]($533,880.05)[/TD]
[/TR]
[TR]
[TD]34[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,480.94[/TD]
[TD="align: right"]$1,889.21[/TD]
[TD="align: right"]($531,990.84)[/TD]
[/TR]
[TR]
[TD]35[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,472.16[/TD]
[TD="align: right"]$1,897.99[/TD]
[TD="align: right"]($530,092.84)[/TD]
[/TR]
[TR]
[TD]36[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,463.34[/TD]
[TD="align: right"]$1,906.81[/TD]
[TD="align: right"]($528,186.03)[/TD]
[/TR]
[TR]
[TD]37[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,454.48[/TD]
[TD="align: right"]$1,915.67[/TD]
[TD="align: right"]($526,270.36)[/TD]
[/TR]
[TR]
[TD]38[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,445.57[/TD]
[TD="align: right"]$1,924.58[/TD]
[TD="align: right"]($524,345.78)[/TD]
[/TR]
[TR]
[TD]39[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,436.63[/TD]
[TD="align: right"]$1,933.52[/TD]
[TD="align: right"]($522,412.26)[/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,427.64[/TD]
[TD="align: right"]$1,942.51[/TD]
[TD="align: right"]($520,469.75)[/TD]
[/TR]
[TR]
[TD]41[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,418.62[/TD]
[TD="align: right"]$1,951.53[/TD]
[TD="align: right"]($518,518.22)[/TD]
[/TR]
[TR]
[TD]42[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,409.55[/TD]
[TD="align: right"]$1,960.60[/TD]
[TD="align: right"]($516,557.62)[/TD]
[/TR]
[TR]
[TD]43[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,400.44[/TD]
[TD="align: right"]$1,969.71[/TD]
[TD="align: right"]($514,587.91)[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,391.29[/TD]
[TD="align: right"]$1,978.86[/TD]
[TD="align: right"]($512,609.04)[/TD]
[/TR]
[TR]
[TD]45[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,382.09[/TD]
[TD="align: right"]$1,988.06[/TD]
[TD="align: right"]($510,620.98)[/TD]
[/TR]
[TR]
[TD]46[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,372.85[/TD]
[TD="align: right"]$1,997.30[/TD]
[TD="align: right"]($508,623.69)[/TD]
[/TR]
[TR]
[TD]47[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,363.57[/TD]
[TD="align: right"]$2,006.58[/TD]
[TD="align: right"]($506,617.10)[/TD]
[/TR]
[TR]
[TD]48[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,354.24[/TD]
[TD="align: right"]$2,015.91[/TD]
[TD="align: right"]($504,601.20)[/TD]
[/TR]
[TR]
[TD]49[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,344.88[/TD]
[TD="align: right"]$2,025.27[/TD]
[TD="align: right"]($502,575.93)[/TD]
[/TR]
[TR]
[TD]50[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,335.47[/TD]
[TD="align: right"]$2,034.68[/TD]
[TD="align: right"]($500,541.24)[/TD]
[/TR]
[TR]
[TD]51[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,326.01[/TD]
[TD="align: right"]$2,044.14[/TD]
[TD="align: right"]($498,497.10)[/TD]
[/TR]
[TR]
[TD]52[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,316.51[/TD]
[TD="align: right"]$2,053.64[/TD]
[TD="align: right"]($496,443.46)[/TD]
[/TR]
[TR]
[TD]53[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,306.97[/TD]
[TD="align: right"]$2,063.18[/TD]
[TD="align: right"]($494,380.28)[/TD]
[/TR]
[TR]
[TD]54[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,297.38[/TD]
[TD="align: right"]$2,072.77[/TD]
[TD="align: right"]($492,307.51)[/TD]
[/TR]
[TR]
[TD]55[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,287.75[/TD]
[TD="align: right"]$2,082.40[/TD]
[TD="align: right"]($490,225.11)[/TD]
[/TR]
[TR]
[TD]56[/TD]
[TD="align: right"]46[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,278.07[/TD]
[TD="align: right"]$2,092.08[/TD]
[TD="align: right"]($488,133.03)[/TD]
[/TR]
[TR]
[TD]57[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,268.35[/TD]
[TD="align: right"]$2,101.80[/TD]
[TD="align: right"]($486,031.23)[/TD]
[/TR]
[TR]
[TD]58[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,258.58[/TD]
[TD="align: right"]$2,111.57[/TD]
[TD="align: right"]($483,919.67)[/TD]
[/TR]
[TR]
[TD]59[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,248.77[/TD]
[TD="align: right"]$2,121.38[/TD]
[TD="align: right"]($481,798.29)[/TD]
[/TR]
[TR]
[TD]60[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,238.91[/TD]
[TD="align: right"]$2,131.24[/TD]
[TD="align: right"]($479,667.05)[/TD]
[/TR]
[TR]
[TD]61[/TD]
[TD="align: right"]51[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,229.01[/TD]
[TD="align: right"]$2,141.14[/TD]
[TD="align: right"]($477,525.91)[/TD]
[/TR]
[TR]
[TD]62[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,219.06[/TD]
[TD="align: right"]$2,151.09[/TD]
[TD="align: right"]($475,374.81)[/TD]
[/TR]
[TR]
[TD]63[/TD]
[TD="align: right"]53[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,209.06[/TD]
[TD="align: right"]$2,161.09[/TD]
[TD="align: right"]($473,213.73)[/TD]
[/TR]
[TR]
[TD]64[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,199.02[/TD]
[TD="align: right"]$2,171.13[/TD]
[TD="align: right"]($471,042.60)[/TD]
[/TR]
[TR]
[TD]65[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,188.93[/TD]
[TD="align: right"]$2,181.22[/TD]
[TD="align: right"]($468,861.38)[/TD]
[/TR]
[TR]
[TD]66[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,178.79[/TD]
[TD="align: right"]$2,191.36[/TD]
[TD="align: right"]($466,670.02)[/TD]
[/TR]
[TR]
[TD]67[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,168.61[/TD]
[TD="align: right"]$2,201.54[/TD]
[TD="align: right"]($464,468.48)[/TD]
[/TR]
[TR]
[TD]68[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,158.38[/TD]
[TD="align: right"]$2,211.77[/TD]
[TD="align: right"]($462,256.71)[/TD]
[/TR]
[TR]
[TD]69[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]($4,370.15)[/TD]
[TD="align: right"]$2,148.10[/TD]
[TD="align: right"]$2,222.05[/TD]
[TD="align: right"]($460,034.67)[/TD]
[/TR]
[TR]
[TD]70[/TD]
[TD="align: right"]60[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]Worksheet Formulas[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Cell[/TD]
[TD]Formula[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]E10[/TD]
[TD]-B1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B6[/TD]
[TD](B2/360*365)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B11[/TD]
[TD]-$B$7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C11[/TD]
[TD]E10*$B$6/12*-1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D11[/TD]
[TD](B11*-1)-C11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]E11[/TD]
[TD]E10+D11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Dave Patton]

The numbers appear to compute.

Daily rate =0.055*365/360/365
Each month considers the number of days

 

[bobgilbert]

The numbers appear to compute.

Daily rate =0.055*365/360/365
Each month considers the number of days

In my spreadsheet above is that what I am doing wrong, not using the amount of days in a month? Sorry, I don't fully understand your reply.

 

[Dave Patton]

Yes. The interest rate is grossed up and the interest is calculated on the number of days for the month.


59 24-09-16 31 4,370.15 2,190.11 2,180.04 460,248.03
60 24-10-16 30 462,357.50 2,109.47 460,248.03 0.00

59th interest =ROUND(0.055/360*G60*C61,2)

 

[bobgilbert]

Yes. The interest rate is grossed up and the interest is calculated on the number of days for the month.


59 24-09-16 31 4,370.15 2,190.11 2,180.04 460,248.03
60 24-10-16 30 462,357.50 2,109.47 460,248.03 0.00

59th interest =ROUND(0.055/360*G60*C61,2)

I will work through your response in my new spreadsheet and let you know how it goes, thanks!

 

[bobgilbert]

I will work through your response in my new spreadsheet and let you know how it goes, thanks!

It looks like you may have worked though all of the months payments and interest and then shared the 59th and 60th? If so, might you be willing to show the first 58 rows too? Doesn't have to be pretty but it would help me to know if I go off track by being able to compare your interest calculation per month to mine.

 

[Dave Patton]

Payment# Days Payment Interest Principal Balance
24-10-11 575,000.00
1 24-11-11 31 4,370.15 2,723.26 1,646.89 573,353.11
2 24-12-11 30 4,370.15 2,627.87 1,742.28 571,610.83
3 24-01-12 31 4,370.15 2,707.21 1,662.94 569,947.89
4 24-02-12 31 4,370.15 2,699.34 1,670.81 568,277.08
5 24-03-12 29 4,370.15 2,517.78 1,852.37 566,424.71
6 24-04-12 31 4,370.15 2,682.65 1,687.50 564,737.21
7 24-05-12 30 4,370.15 2,588.38 1,781.77 562,955.44
8 24-06-12 31 4,370.15 2,666.22 1,703.93 561,251.51
9 24-07-12 30 4,370.15 2,572.40 1,797.75 559,453.76
10 24-08-12 31 4,370.15 2,649.64 1,720.51 557,733.25
11 24-09-12 31 4,370.15 2,641.49 1,728.66 556,004.59
12 24-10-12 30 4,370.15 2,548.35 1,821.80 554,182.79
13 24-11-12 31 4,370.15 2,624.67 1,745.48 552,437.31
14 24-12-12 30 4,370.15 2,532.00 1,838.15 550,599.16
15 24-01-13 31 4,370.15 2,607.70 1,762.45 548,836.71
16 24-02-13 31 4,370.15 2,599.35 1,770.80 547,065.91
17 24-03-13 28 4,370.15 2,340.23 2,029.92 545,035.99
18 24-04-13 31 4,370.15 2,581.35 1,788.80 543,247.19
19 24-05-13 30 4,370.15 2,489.88 1,880.27 541,366.92
20 24-06-13 31 4,370.15 2,563.97 1,806.18 539,560.74
21 24-07-13 30 4,370.15 2,472.99 1,897.16 537,663.58
22 24-08-13 31 4,370.15 2,546.43 1,823.72 535,839.86
23 24-09-13 31 4,370.15 2,537.80 1,832.35 534,007.51
24 24-10-13 30 4,370.15 2,447.53 1,922.62 532,084.89
25 24-11-13 31 4,370.15 2,520.01 1,850.14 530,234.75
26 24-12-13 30 4,370.15 2,430.24 1,939.91 528,294.84
27 24-01-14 31 4,370.15 2,502.06 1,868.09 526,426.75
28 24-02-14 31 4,370.15 2,493.22 1,876.93 524,549.82
29 24-03-14 28 4,370.15 2,243.91 2,126.24 522,423.58
30 24-04-14 31 4,370.15 2,474.26 1,895.89 520,527.69
31 24-05-14 30 4,370.15 2,385.75 1,984.40 518,543.29
32 24-06-14 31 4,370.15 2,455.88 1,914.27 516,629.02
33 24-07-14 30 4,370.15 2,367.88 2,002.27 514,626.75
34 24-08-14 31 4,370.15 2,437.33 1,932.82 512,693.93
35 24-09-14 31 4,370.15 2,428.18 1,941.97 510,751.96
36 24-10-14 30 4,370.15 2,340.95 2,029.20 508,722.76
37 24-11-14 31 4,370.15 2,409.37 1,960.78 506,761.98
38 24-12-14 30 4,370.15 2,322.66 2,047.49 504,714.49
39 24-01-15 31 4,370.15 2,390.38 1,979.77 502,734.72
40 24-02-15 31 4,370.15 2,381.01 1,989.14 500,745.58
41 24-03-15 28 4,370.15 2,142.08 2,228.07 498,517.51
42 24-04-15 31 4,370.15 2,361.03 2,009.12 496,508.39
43 24-05-15 30 4,370.15 2,275.66 2,094.49 494,413.90
44 24-06-15 31 4,370.15 2,341.60 2,028.55 492,385.35
45 24-07-15 30 4,370.15 2,256.77 2,113.38 490,271.97
46 24-08-15 31 4,370.15 2,321.98 2,048.17 488,223.80
47 24-09-15 31 4,370.15 2,312.28 2,057.87 486,165.93
48 24-10-15 30 4,370.15 2,228.26 2,141.89 484,024.04
49 24-11-15 31 4,370.15 2,292.39 2,077.76 481,946.28
50 24-12-15 30 4,370.15 2,208.92 2,161.23 479,785.05
51 24-01-16 31 4,370.15 2,272.32 2,097.83 477,687.22
52 24-02-16 31 4,370.15 2,262.38 2,107.77 475,579.45
53 24-03-16 29 4,370.15 2,107.08 2,263.07 473,316.38
54 24-04-16 31 4,370.15 2,241.68 2,128.47 471,187.91
55 24-05-16 30 4,370.15 2,159.61 2,210.54 468,977.37
56 24-06-16 31 4,370.15 2,221.13 2,149.02 466,828.35
57 24-07-16 30 4,370.15 2,139.63 2,230.52 464,597.83
58 24-08-16 31 4,370.15 2,200.39 2,169.76 462,428.07
59 24-09-16 31 4,370.15 2,190.11 2,180.04 460,248.03
60 24-10-16 30 462,357.50 2,109.47 460,248.03 0.00

I hope that this helps. I do not have the tools on this computer to export
the information clearly.