Loan Calculation

	A	B	C	D	E	F	G	H
1	Loan Calculation
2
3	Variables
4	Principal	16,261.32		Purchase Date	12/22/2014
5	APR	3.89%		First Payment	2/5/2015
6	# Payments	61	(monthly)	Initial time	45
7	Monthly Payment	299.11
8
9	Payment #	Date	Pre-balance	Days	Interest	Payment	Correction	Post-balance
10	1	2015-02-05	16,261.32	45	77.99	299.11		16,040.20
11	2	2015-03-05	16,040.20	28	47.87	299.11		15,788.96
12	3	2015-04-05	15,788.96	31	52.16	299.11		15,542.01
13	4	2015-05-05	15,542.01	30	49.69	299.11		15,292.59
14	5	2015-06-05	15,292.59	31	50.52	299.11		15,044.00
15	6	2015-07-05	15,044.00	30	48.10	299.11		14,792.99
16	7	2015-08-05	14,792.99	31	48.87	299.11		14,542.75
17	8	2015-09-05	14,542.75	31	48.05	299.11		14,291.69
18	9	2015-10-05	14,291.69	30	45.69	299.11		14,038.27
19	10	2015-11-05	14,038.27	31	46.38	299.11		13,785.54
20	11	2015-12-05	13,785.54	30	44.08	299.11		13,530.51
21	12	2016-01-05	13,530.51	31	44.70	299.11		13,276.10
22	13	2016-02-05	13,276.10	31	43.86	299.11		13,020.85
23	14	2016-03-05	13,020.85	29	40.24	299.11		12,761.98
24	15	2016-04-05	12,761.98	31	42.16	299.11		12,505.03
25	16	2016-05-05	12,505.03	30	39.98	299.11		12,245.90
26	17	2016-06-05	12,245.90	31	40.46	299.11		11,987.25
27	18	2016-07-05	11,987.25	30	38.33	299.11		11,726.47
28	19	2016-08-05	11,726.47	31	38.74	299.11		11,466.10
29	20	2016-09-05	11,466.10	31	37.88	299.11		11,204.87
30	21	2016-10-05	11,204.87	30	35.82	299.11		10,941.58
31	22	2016-11-05	10,941.58	31	36.15	299.11		10,678.62
32	23	2016-12-05	10,678.62	30	34.14	299.11		10,413.65
33	24	2017-01-05	10,413.65	31	34.40	299.11		10,148.94
34	25	2017-02-05	10,148.94	31	33.53	299.11		9,883.36
35	26	2017-03-05	9,883.36	28	29.49	299.11		9,613.74
36	27	2017-04-05	9,613.74	31	31.76	299.11		9,346.39
37	28	2017-05-05	9,346.39	30	29.88	299.11		9,077.16
38	29	2017-06-05	9,077.16	31	29.99	299.11		8,808.04
39	30	2017-07-05	8,808.04	30	28.16	299.11		8,537.09
40	31	2017-08-05	8,537.09	31	28.21	299.11		8,266.19
41	32	2017-09-05	8,266.19	31	27.31	299.11		7,994.39
42	33	2017-10-05	7,994.39	30	25.56	299.11		7,720.84
43	34	2017-11-05	7,720.84	31	25.51	299.11		7,447.24
44	35	2017-12-05	7,447.24	30	23.81	299.11		7,171.94
45	36	2018-01-05	7,171.94	31	23.69	299.11		6,896.52
46	37	2018-02-05	6,896.52	31	22.78	299.11		6,620.19
47	38	2018-03-05	6,620.19	28	19.76	299.11		6,340.84
48	39	2018-04-05	6,340.84	31	20.95	299.11		6,062.68
49	40	2018-05-05	6,062.68	30	19.38	299.11		5,782.95
50	41	2018-06-05	5,782.95	31	19.11	299.11		5,502.95
51	42	2018-07-05	5,502.95	30	17.59	299.11		5,221.43
52	43	2018-08-05	5,221.43	31	17.25	299.11		4,939.57
53	44	2018-09-05	4,939.57	31	16.32	299.11		4,656.78
54	45	2018-10-05	4,656.78	30	14.89	299.11		4,372.56
55	46	2018-11-05	4,372.56	31	14.45	299.11		4,087.90
56	47	2018-12-05	4,087.90	30	13.07	299.11		3,801.86
57	48	2019-01-05	3,801.86	31	12.56	299.11		3,515.31
58	49	2019-02-05	3,515.31	31	11.61	299.11		3,227.81
59	50	2019-03-05	3,227.81	28	9.63	299.11		2,938.33
60	51	2019-04-05	2,938.33	31	9.71	299.11		2,648.93
61	52	2019-05-05	2,648.93	30	8.47	299.11		2,358.29
62	53	2019-06-05	2,358.29	31	7.79	299.11		2,066.97
63	54	2019-07-05	2,066.97	30	6.61	299.11		1,774.47
64	55	2019-08-05	1,774.47	31	5.86	299.11		1,481.22
65	56	2019-09-05	1,481.22	31	4.89	299.11		1,187.00
66	57	2019-10-05	1,187.00	30	3.80	299.11		891.69
67	58	2019-11-05	891.69	31	2.95	299.11		595.53
68	59	2019-12-05	595.53	30	1.90	299.11		298.32
69	60	2020-01-05	298.32	31	0.99	299.11		.20
70	61	2020-02-05	.20	31	0.00	299.11		-298.91
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100