Spreadsheet: 136025d1326377761-loan-interest-calculation-in-excel-interest-calculation
Sheet: Sheet1

$ [NAME] | 298987.57
Rate | 0.0975
Term | 48
Standard |  |  |  |  |  |  | Lender's Calculation
Payment Date | Beginning Balance | Payment Amount | Interest | Principal | Ending Balance |  | Payment Date | Beginning Balance | Payment Amount | Interest | Principal | Ending Balance |  |  | # of Days | 0.0975
2011-06-12 00:00:00 | 298987.57 | 15220 | 84 | 15136.22 |  |  | 2011-06-01 00:00:00 | 298987.57 | 15220.22 | 84
2011-07-12 00:00:00 |  | 0 | 2520.84 | 0 |  |  | 2011-07-01 00:00:00 |  | 0 | 2520.84 | 0
2011-08-12 00:00:00 |  | 0 | 2543.22 | 0 |  |  | 2011-08-01 00:00:00 |  | 0 | 2543.22 | 0
2011-09-12 00:00:00 |  |  |  |  |  |  | 2011-09-01 00:00:00 |  | 7610.11 | 2498.23
2011-10-12 00:00:00 |  |  |  |  |  |  | 2011-10-01 00:00:00 |  | 7610.11 | 2452.83
2011-11-12 00:00:00 |  |  |  |  |  |  | 2011-11-01 00:00:00 |  | 7610.11 | 2407.03
2011-12-12 00:00:00 |  |  |  |  |  |  | 2011-12-01 00:00:00 |  | 7610.11 | 1802.68
2012-01-12 00:00:00 |  |  |  |  |  |  | 2012-01-01 00:00:00 |  | 6424.16 | 1766.29
2012-02-12 00:00:00 |  |  |  |  |  |  | 2012-02-01 00:00:00 |  | 6424.16 | 1729.62
2012-03-12 00:00:00 |  |  |  |  |  |  | 2012-03-01 00:00:00 |  | 6424.16 | 1692.67
2012-04-12 00:00:00 |  |  |  |  |  |  | 2012-04-01 00:00:00 |  | 6424.16 | 1655.42
2012-05-12 00:00:00 |  |  |  |  |  |  | 2012-05-01 00:00:00 |  | 6424.16 | 1617.88
2012-06-12 00:00:00 |  |  |  |  |  |  | 2012-06-01 00:00:00 |  | 6424.16 | 1580.04
2012-07-12 00:00:00 |  |  |  |  |  |  | 2012-07-01 00:00:00 |  | 6424.16 | 1541.9
2012-08-12 00:00:00 |  |  |  |  |  |  | 2012-08-01 00:00:00 |  | 6424.16 | 1503.47
2012-09-12 00:00:00 |  |  |  |  |  |  | 2012-09-01 00:00:00 |  | 6424.16 | 1464.73
2012-10-12 00:00:00 |  |  |  |  |  |  | 2012-10-01 00:00:00 |  | 6424.16 | 1425.69
2012-11-12 00:00:00 |  |  |  |  |  |  | 2012-11-01 00:00:00 |  | 6424.16 | 1386.34
2012-12-12 00:00:00 |  |  |  |  |  |  | 2012-12-01 00:00:00 |  | 6424.16 | 1346.68
2013-01-12 00:00:00 |  |  |  |  |  |  | 2013-01-01 00:00:00 |  | 6424.16 | 1306.7
2013-02-12 00:00:00 |  |  |  |  |  |  | 2013-02-01 00:00:00 |  | 6424.16 | 1266.42
2013-03-12 00:00:00 |  |  |  |  |  |  | 2013-03-01 00:00:00 |  | 6424.16 | 1225.81
2013-04-12 00:00:00 |  |  |  |  |  |  | 2013-04-01 00:00:00 |  | 6424.16 | 1184.89
2013-05-12 00:00:00 |  |  |  |  |  |  | 2013-05-01 00:00:00 |  | 6424.16 | 1143.64
2013-06-12 00:00:00 |  |  |  |  |  |  | 2013-06-01 00:00:00 |  | 6424.16 | 1102.07
2013-07-12 00:00:00 |  |  |  |  |  |  | 2013-07-01 00:00:00 |  | 6424.16 | 1060.17
2013-08-12 00:00:00 |  |  |  |  |  |  | 2013-08-01 00:00:00 |  | 6424.16 | 1017.94
2013-09-12 00:00:00 |  |  |  |  |  |  | 2013-09-01 00:00:00 |  | 6424.16 | 975.38
2013-10-12 00:00:00 |  |  |  |  |  |  | 2013-10-01 00:00:00 |  | 6424.16 | 932.49
2013-11-12 00:00:00 |  |  |  |  |  |  | 2013-11-01 00:00:00 |  | 6424.16 | 889.25
2013-12-12 00:00:00 |  |  |  |  |  |  | 2013-12-01 00:00:00 |  | 6424.16 | 845.68
2014-01-12 00:00:00 |  |  |  |  |  |  | 2014-01-01 00:00:00 |  | 6424.16 | 801.76
2014-02-12 00:00:00 |  |  |  |  |  |  | 2014-02-01 00:00:00 |  | 6424.16 | 757.5
2014-03-12 00:00:00 |  |  |  |  |  |  | 2014-03-01 00:00:00 |  | 6424.16 | 712.89
2014-04-12 00:00:00 |  |  |  |  |  |  | 2014-04-01 00:00:00 |  | 6424.16 | 667.93
2014-05-12 00:00:00 |  |  |  |  |  |  | 2014-05-01 00:00:00 |  | 6424.16 | 622.61
2014-06-12 00:00:00 |  |  |  |  |  |  | 2014-06-01 00:00:00 |  | 6424.16 | 576.94
2014-07-12 00:00:00 |  |  |  |  |  |  | 2014-07-01 00:00:00 |  | 6424.16 | 530.91
2014-08-12 00:00:00 |  |  |  |  |  |  | 2014-08-01 00:00:00 |  | 6424.16 | 484.51
2014-09-12 00:00:00 |  |  |  |  |  |  | 2014-09-01 00:00:00 |  | 6424.16 | 437.75
2014-10-12 00:00:00 |  |  |  |  |  |  | 2014-10-01 00:00:00 |  | 6424.16 | 390.63
2014-11-12 00:00:00 |  |  |  |  |  |  | 2014-11-01 00:00:00 |  | 6424.16 | 343.13
2014-12-12 00:00:00 |  |  |  |  |  |  | 2014-12-01 00:00:00 |  | 6424.16 | 295.25
2015-01-12 00:00:00 |  |  |  |  |  |  | 2015-01-01 00:00:00 |  | 6424.16 | 247
2015-02-12 00:00:00 |  |  |  |  |  |  | 2015-02-01 00:00:00 |  | 6424.16 | 198.37
2015-03-12 00:00:00 |  |  |  |  |  |  | 2015-03-01 00:00:00 |  | 6424.16 | 149.36
2015-04-12 00:00:00 |  |  |  |  |  |  | 2015-04-01 00:00:00 |  | 6424.16 | 99.96
2015-05-12 00:00:00 |  |  |  |  |  |  | 2015-05-01 00:00:00 |  | 6424.16 | 50.18
2015-06-12 00:00:00 |  |  |  |  |  |  | 2015-06-01 00:00:00 |  | 6424.16 | 0.32
2015-07-12 00:00:00 |  |  |  |  |  |  | 2015-07-01 00:00:00
2015-08-12 00:00:00 |  |  |  |  |  |  | 2015-08-01 00:00:00
2015-09-12 00:00:00
 |  |  | -66297.71 |  |  |  |  |  |  | -66297.71 |  |  |  |  |  | -66297.71