|
Sch 13 TVAL.xlsx
<br />Page 1 of 2
<br />AMORTIZATION SCHEDULE - Normal Amortization
<br />Date
<br />Payment
<br />Interest
<br />Principal
<br />Balance
<br />Loan
<br />11/1/2016
<br />156,029.30
<br />1
<br />11/30/2016
<br />3,348.47
<br />605.97
<br />2,742.50
<br />153,286.80
<br />2
<br />12/31/2016
<br />3,348.47
<br />624.40
<br />2,724.07
<br />150,562.73
<br />3
<br />1/31/2017
<br />3,348.47
<br />613.31
<br />2,735.16
<br />147,827.57
<br />4
<br />2/28/2017
<br />3,348.47
<br />602.17
<br />2,746.30
<br />145,081.27
<br />5
<br />3/31/2017
<br />3,348.47
<br />590.98
<br />2,757.49
<br />142,323.78
<br />6
<br />4/30/2017
<br />3,348.47
<br />579.75
<br />2,768.72
<br />139,555.06
<br />7
<br />5/31/2017
<br />3,348.47
<br />568.47
<br />2,780.00
<br />136,775.06
<br />8
<br />6/30/2017
<br />3,348.47
<br />557.14
<br />2,791.33
<br />133,983.73
<br />9
<br />7/31/2017
<br />3,348.47
<br />545.77
<br />2,802.70
<br />131,181.03
<br />10
<br />8/31/2017
<br />3,348.47
<br />534.36
<br />2,814.11
<br />128,366.92
<br />11
<br />9/30/2017
<br />3,348.47
<br />522.89
<br />2,825.58
<br />125,541.34
<br />12
<br />10/31/2017
<br />3,348.47
<br />511.38
<br />2,837.09
<br />122,704.25
<br />1311/30/2017
<br />3,348.47
<br />499.83
<br />2,848.64
<br />119,855.61
<br />1412/31/2017
<br />3,348.47
<br />488.22
<br />2,860.25
<br />116,995.36
<br />15
<br />1/31/2018
<br />3,348.47
<br />476.57
<br />2,871.90
<br />114,123.46
<br />16
<br />2/28/2018
<br />3,348.47
<br />464.87
<br />2,883.60
<br />111,239.86
<br />17
<br />3/31/2018
<br />3,348.47
<br />453.13
<br />2,895.34
<br />108,344.52
<br />18
<br />4/30/2018
<br />3,348.47
<br />441.33
<br />2,907.14
<br />105,437.38
<br />19
<br />5/31/2018
<br />3,348.47
<br />429.49
<br />2,918.98
<br />102,518.40
<br />20
<br />6/30/2018
<br />3,348.47
<br />417.60
<br />2,930.87
<br />99,587.53
<br />21
<br />7/31/2018
<br />3,348.47
<br />405.66
<br />2,942.81
<br />96,644.72
<br />22
<br />8/31/2018
<br />3,348.47
<br />393.68
<br />2,954.79
<br />93,689.93
<br />23
<br />9/30/2018
<br />3,348.47
<br />381.64
<br />2,966.83
<br />90,723.10
<br />2410/31/2018
<br />3,348.47
<br />369.55
<br />2,978.92
<br />87,744.18
<br />25
<br />11/30/2018
<br />3,348.47
<br />357.42
<br />2,991.05
<br />84,753.13
<br />2612/31/2018
<br />3,348.47
<br />345.24
<br />3,003.23
<br />81,749.90
<br />27
<br />1/31/2019
<br />3,348.47
<br />333.00
<br />3,015.47
<br />78,734.43
<br />28
<br />2/28/2019
<br />3,348.47
<br />320.72
<br />3,027.75
<br />75,706.68
<br />29
<br />3/31/2019
<br />3,348.47
<br />308.39
<br />3,040.08
<br />72,666.60
<br />30
<br />4/30/2019
<br />3,348.47
<br />296.00
<br />3,052.47
<br />69,614.13
<br />31
<br />5/31/2019
<br />3,348.47
<br />283.57
<br />3,064.90
<br />66,549.23
<br />32
<br />6/30/2019
<br />3,348.47
<br />271.08
<br />3,077.39
<br />63,471.84
<br />33
<br />7/31/2019
<br />3,348.47
<br />258.55
<br />3,089.92
<br />60,381.92
<br />34
<br />8/31/2019
<br />3,348.47
<br />245.96
<br />3,102.51
<br />57,279.41
<br />35
<br />9/30/2019
<br />3,348.47
<br />233.32
<br />3,115.15
<br />54,164.26
<br />3610/31/2019
<br />3,348.47
<br />220.63
<br />3,127.84
<br />51,036.42
<br />3711/30/2019
<br />3,348.47
<br />207.89
<br />3,140.58
<br />47,895.84
<br />38
<br />12/31/2019
<br />3,348.47
<br />195.10
<br />3,153.37
<br />44,742.47
<br />39
<br />1/31/2020
<br />3,348.47
<br />182.26
<br />3,166.21
<br />41,576.26
<br />40
<br />2/29/2020
<br />3,348.47
<br />169.36
<br />3,179.11
<br />38,397.15
<br />41
<br />3/31/2020
<br />3,348.47
<br />156.41
<br />3,192.06
<br />35,205.09
<br />https://usl-excel.officeappslive.com/x/ layouts/xlprintview.aspx?&NoAuth=1&sessionld=... 3/2/2017
<br />
|