House Loan.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOP
1
Christopher B took out a 100,000$ loan from Lawerence B on 04-01-15.
2
Loan info is as follows below0.03737
3
Info provided below will change depending on extra payments made
4
YearsRatePeriods per yearTotal PeriodsPeriod RateTotal Interest to be paidPrincipal to be paidExtra payments madeFinal payment amount
5
100.03737121200.003114166667$10,654.56$100,000.00$27,985.17$110,654.56
6
7
DatepaymentInterestPrincipal PaidBalanceExtra PaymnetSignNotes
8
4/1/2015$100,000.00CBLoan started
9
5/1/20151,000.00311.42688.5899,311.42CBFirst payment + extra
10
6/1/20151,000.00309.275,340.7393,970.694,650.00CBPaid on 05-26-15
11
7/1/20151,000.00292.644,507.3689,463.333,800.00CB
12
8/1/20151,000.00278.605,221.4084,241.944,500.00CBpaid on 6-18
13
9/1/20151,000.00262.342,237.6682,004.281,500.00CBTBP 07-29 (paid)
14
10/1/20151,000.00255.371,144.6280,859.66400.00CB8/13/2015
15
11/1/20151,000.00251.81748.1980,111.47CBPaid on 11/07/15
16
12/1/20151,000.00249.48950.5279,160.95CBPaid on 11/07/15
17
1/1/20161,000.00246.52953.4878,207.47200.00CBpaid on 12/27/15
18
2/1/20161,000.00243.55856.4577,351.02100.00CBpaid on 03/04/16
19
3/1/20161,000.00240.88859.1276,491.91100.00CBpaid on 03/04/16
20
4/1/20161,000.00238.212,861.7973,630.122,100.00CB4/10/2016
21
5/1/20161,000.00229.302,770.7070,859.412,000.00CB4/2016
22
6/1/20161,000.00220.671,579.3369,280.08800.00CB6/5/16
23
7/1/20161,000.00215.75784.2568,495.83CB08/03/16
24
8/1/20161,000.00213.311,386.6967,109.14600.00CB08/03/16
25
9/1/20161,000.00208.99791.0166,318.13CBpaid on 10/10/16
26
10/1/20161,000.00206.53793.4765,524.66CBpaid on 10/10/16
27
11/1/20161,000.00204.055,795.9459,728.715,000.00CBpaid on 10/10/16
28
12/1/20161,000.00186.01813.9958,914.72CBPaid on 01/05/17
29
1/1/20171,000.00183.472,517.5356,397.191,701.00CBPaid on 01/23/17
30
2/1/20171,000.00175.631,324.3755,072.82500.00CBPaid on 02/06/17
31
3/1/20171,000.00171.51828.4954,244.33CBPaid on 04/01/17
32
4/1/20171,000.00168.93865.2453,379.0934.17CBPaid on 04/01/17
33
5/1/20171,000.00166.23833.7752,545.32TBP on 05/01/17
34
6/1/20171,000.00163.63836.3651,708.95
35
7/1/20171,000.00161.03838.9750,869.98
36
8/1/20171,000.00158.42841.5850,028.40
37
9/1/20171,000.00155.80844.2049,184.20
38
10/1/20171,000.00153.17846.8348,337.37
39
11/1/20171,000.00150.53849.4747,487.90
40
12/1/20171,000.00147.89852.1146,635.79
41
1/1/20181,000.00145.23854.7745,781.02
42
2/1/20181,000.00142.57857.4344,923.59
43
3/1/20181,000.00139.90860.1044,063.49
44
4/1/20181,000.00137.22862.7843,200.71
45
5/1/20181,000.00134.53865.4642,335.25
46
6/1/20181,000.00131.84868.1641,467.09
47
7/1/20181,000.00129.14870.8640,596.22
48
8/1/20181,000.00126.42873.5839,722.65
49
9/1/20181,000.00123.70876.3038,846.35
50
10/1/20181,000.00120.97879.0337,967.33
51
11/1/20181,000.00118.24881.7637,085.56
52
12/1/20181,000.00115.49884.5136,201.06
53
1/1/20191,000.00112.74887.2635,313.79
54
2/1/20191,000.00109.97890.0334,423.77
55
3/1/20191,000.00107.20892.8033,530.97
56
4/1/20191,000.00104.42895.5832,635.39
57
5/1/20191,000.00101.63898.3731,737.02
58
6/1/20191,000.0098.83901.1630,835.86
59
7/1/20191,000.0096.03903.9729,931.89
60
8/1/20191,000.0093.21906.7929,025.10
61
9/1/20191,000.0090.39909.6128,115.49
62
10/1/20191,000.0087.56912.4427,203.05
63
11/1/20191,000.0084.71915.2826,287.76
64
12/1/20191,000.0081.86918.1325,369.63
65
1/1/20201,000.0079.01920.9924,448.64
66
2/1/20201,000.0076.14923.8623,524.77
67
3/1/20201,000.0073.26926.7422,598.03
68
4/1/20201,000.0070.37929.6321,668.41
69
5/1/20201,000.0067.48932.5220,735.89
70
6/1/20201,000.0064.58935.4219,800.47
71
7/1/20201,000.0061.66938.3418,862.13
72
8/1/20201,000.0058.74941.2617,920.87
73
9/1/20201,000.0055.81944.1916,976.68
74
10/1/20201,000.0052.87947.1316,029.55
75
11/1/20201,000.0049.92950.0815,079.47
76
12/1/20201,000.0046.96953.0414,126.43
77
1/1/20211,000.0043.99956.0113,170.42
78
2/1/20211,000.0041.01958.9812,211.44
79
3/1/20211,000.0038.03961.9711,249.47
80
4/1/20211,000.0035.03964.9710,284.50
81
5/1/20211,000.0032.03967.979,316.53
82
6/1/20211,000.0029.01970.998,345.54
83
7/1/20211,000.0025.99974.017,371.53
84
8/1/20211,000.0022.96977.046,394.49
85
9/1/20211,000.0019.91980.095,414.40
86
10/1/20211,000.0016.86983.144,431.27
87
11/1/20211,000.0013.80986.203,445.07
88
12/1/20211,000.0010.73989.272,455.80
89
1/1/20221,000.007.65992.351,463.44
90
2/1/20221,000.004.56995.44468.00
91
3/1/2022469.461.46468.00-0.0001/01/17
92
4/1/2022-0.00-0.00-0.00
93
5/1/2022
94
6/1/2022
95
7/1/202210/10/16
96
8/1/2022
97
9/1/2022
98
10/1/2022
99
11/1/2022
100
12/1/2022
Loading...