Spreadsheet: 82556d1282624927-simple-spreadsheet-for-loan-payments-recieved-loan-repayment-calculator
Sheet: Sheet1

Inputs |  |  | Outputs |  |  |  |  |  |  |  |  | Outputs
Loan Amt | 4000 |  | No. Pmts | 2 |  | Annual | 1 |  |  |  |  | No. Pmts | 60
APR | 0.06 |  | Pmt | 100 |  | Monthly | 12 |  |  |  |  | Pmt | 78.45569603787773
Term (yrs) | 5 |  | Tot Interest | 9.438202247191011 |  | Bi-Weekly | 26 |  |  |  |  | Tot Interest | 649.6049140449437
Pmt Frequency | Monthly |  |  |  |  | Weekly | 52
Start Date | 2010-07-01 00:00:00
Ad Hoc Payments |  |  |  |  |  |  |  |  | Scheduled Amortization
Pmt # | [NAME] | Pmt Date | Pmt Amt | Interest | Principle | Balance |  |  | Pmt # | [NAME] | Pmt Date | Pmt Amt | Interest | Principle | Balance
1 | 4000 | 2010-07-15 00:00:00 | 100 | 9.438202247191011 | 90.56179775280899 | 3909.438202247191 |  |  | 1 | 4000 | 2010-08-01 00:00:00 | 78.45569603787773 | 20.89887640449438 | 57.55681963338335 | 3942.44
2 | 3909.438202247191 |  |  |  |  |  |  |  | 2 | 3942.44 | 2010-09-01 00:00:00 | 78.45569603787773 | 20.5981415730337 | 57.85755446484403 | 3884.58
 |  |  |  |  |  |  |  |  | 3 | 3884.58 | 2010-10-01 00:00:00 | 78.45569603787773 | 19.64113483146067 | 58.81456120641705 | 3825.77
 |  |  |  |  |  |  |  |  | 4 | 3825.77 | 2010-11-01 00:00:00 | 78.45569603787773 | 19.98857359550562 | 58.46712244237212 | 3767.3
 |  |  |  |  |  |  |  |  | 5 | 3767.3 | 2010-12-01 00:00:00 | 78.45569603787773 | 19.04814606741573 | 59.407549970462 | 3707.89
 |  |  |  |  |  |  |  |  | 6 | 3707.89 | 2011-01-01 00:00:00 | 78.45569603787773 | 19.37268370786516 | 59.08301233001256 | 3648.81
 |  |  |  |  |  |  |  |  | 7 | 3648.81 | 2011-02-01 00:00:00 | 78.45569603787773 | 19.06400730337078 | 59.39168873450694 | 3589.42
 |  |  |  |  |  |  |  |  | 8 | 3589.42 | 2011-03-01 00:00:00 | 78.45569603787773 | 16.93883595505618 | 61.51686008282155 | 3527.9
 |  |  |  |  |  |  |  |  | 9 | 3527.9 | 2011-04-01 00:00:00 | 78.45569603787773 | 18.43228651685393 | 60.02340952102379 | 3467.88
 |  |  |  |  |  |  |  |  | 10 | 3467.88 | 2011-05-01 00:00:00 | 78.45569603787773 | 17.53422471910112 | 60.92147131877661 | 3406.96
 |  |  |  |  |  |  |  |  | 11 | 3406.96 | 2011-06-01 00:00:00 | 78.45569603787773 | 17.80040898876404 | 60.65528704911368 | 3346.3
 |  |  |  |  |  |  |  |  | 12 | 3346.3 | 2011-07-01 00:00:00 | 78.45569603787773 | 16.91949438202247 | 61.53620165585526 | 3284.76
 |  |  |  |  |  |  |  |  | 13 | 3284.76 | 2011-08-01 00:00:00 | 78.45569603787773 | 17.16194831460674 | 61.29374772327099 | 3223.47
 |  |  |  |  |  |  |  |  | 14 | 3223.47 | 2011-09-01 00:00:00 | 78.45569603787773 | 16.84172528089887 | 61.61397075697886 | 3161.86
 |  |  |  |  |  |  |  |  | 15 | 3161.86 | 2011-10-01 00:00:00 | 78.45569603787773 | 15.98693258426966 | 62.46876345360806 | 3099.39
 |  |  |  |  |  |  |  |  | 16 | 3099.39 | 2011-11-01 00:00:00 | 78.45569603787773 | 16.19344213483146 | 62.26225390304627 | 3037.13
 |  |  |  |  |  |  |  |  | 17 | 3037.13 | 2011-12-01 00:00:00 | 78.45569603787773 | 15.35627528089888 | 63.09942075697885 | 2974.03
 |  |  |  |  |  |  |  |  | 18 | 2974.03 | 2012-01-01 00:00:00 | 78.45569603787773 | 15.53847134831461 | 62.91722468956313 | 2911.11
 |  |  |  |  |  |  |  |  | 19 | 2911.11 | 2012-02-01 00:00:00 | 78.45569603787773 | 15.20973202247191 | 63.24596401540582 | 2847.86
 |  |  |  |  |  |  |  |  | 20 | 2847.86 | 2012-03-01 00:00:00 | 78.45569603787773 | 13.91931573033708 | 64.53638030754065 | 2783.32
 |  |  |  |  |  |  |  |  | 21 | 2783.32 | 2012-04-01 00:00:00 | 78.45569603787773 | 14.54206516853933 | 63.91363086933841 | 2719.41
 |  |  |  |  |  |  |  |  | 22 | 2719.41 | 2012-05-01 00:00:00 | 78.45569603787773 | 13.74982584269663 | 64.7058701951811 | 2654.7
 |  |  |  |  |  |  |  |  | 23 | 2654.7 | 2012-06-01 00:00:00 | 78.45569603787773 | 13.87006179775281 | 64.58563424012492 | 2590.11
 |  |  |  |  |  |  |  |  | 24 | 2590.11 | 2012-07-01 00:00:00 | 78.45569603787773 | 13.09606179775281 | 65.35963424012492 | 2524.75
 |  |  |  |  |  |  |  |  | 25 | 2524.75 | 2012-08-01 00:00:00 | 78.45569603787773 | 13.1911095505618 | 65.26458648731594 | 2459.49
 |  |  |  |  |  |  |  |  | 26 | 2459.49 | 2012-09-01 00:00:00 | 78.45569603787773 | 12.85014438202247 | 65.60555165585527 | 2393.88
 |  |  |  |  |  |  |  |  | 27 | 2393.88 | 2012-10-01 00:00:00 | 78.45569603787773 | 12.10388764044944 | 66.35180839742829 | 2327.53
 |  |  |  |  |  |  |  |  | 28 | 2327.53 | 2012-11-01 00:00:00 | 78.45569603787773 | 12.1606904494382 | 66.29500558843952 | 2261.23
 |  |  |  |  |  |  |  |  | 29 | 2261.23 | 2012-12-01 00:00:00 | 78.45569603787773 | 11.43318539325843 | 67.0225106446193 | 2194.21
 |  |  |  |  |  |  |  |  | 30 | 2194.21 | 2013-01-01 00:00:00 | 78.45569603787773 | 11.4641308988764 | 66.99156513900132 | 2127.22
 |  |  |  |  |  |  |  |  | 31 | 2127.22 | 2013-02-01 00:00:00 | 78.45569603787773 | 11.11412696629213 | 67.3415690715856 | 2059.88
 |  |  |  |  |  |  |  |  | 32 | 2059.88 | 2013-03-01 00:00:00 | 78.45569603787773 | 9.72078202247191 | 68.73491401540582 | 1991.15
 |  |  |  |  |  |  |  |  | 33 | 1991.15 | 2013-04-01 00:00:00 | 78.45569603787773 | 10.40319943820225 | 68.05249659967548 | 1923.1
 |  |  |  |  |  |  |  |  | 34 | 1923.1 | 2013-05-01 00:00:00 | 78.45569603787773 | 9.723539325842696 | 68.73215671203504 | 1854.37
 |  |  |  |  |  |  |  |  | 35 | 1854.37 | 2013-06-01 00:00:00 | 78.45569603787773 | 9.68856235955056 | 68.76713367832717 | 1785.6
 |  |  |  |  |  |  |  |  | 36 | 1785.6 | 2013-07-01 00:00:00 | 78.45569603787773 | 9.028314606741572 | 69.42738143113615 | 1716.17
 |  |  |  |  |  |  |  |  | 37 | 1716.17 | 2013-08-01 00:00:00 | 78.45569603787773 | 8.96650617977528 | 69.48918985810245 | 1646.68
 |  |  |  |  |  |  |  |  | 38 | 1646.68 | 2013-09-01 00:00:00 | 78.45569603787773 | 8.603440449438201 | 69.85225558843953 | 1576.83
 |  |  |  |  |  |  |  |  | 39 | 1576.83 | 2013-10-01 00:00:00 | 78.45569603787773 | 7.972735955056179 | 70.48296008282155 | 1506.35
 |  |  |  |  |  |  |  |  | 40 | 1506.35 | 2013-11-01 00:00:00 | 78.45569603787773 | 7.870255617977526 | 70.58544041990021 | 1435.76
 |  |  |  |  |  |  |  |  | 41 | 1435.76 | 2013-12-01 00:00:00 | 78.45569603787773 | 7.259460674157303 | 71.19623536372043 | 1364.56
 |  |  |  |  |  |  |  |  | 42 | 1364.56 | 2014-01-01 00:00:00 | 78.45569603787773 | 7.129442696629212 | 71.32625334124852 | 1293.23
 |  |  |  |  |  |  |  |  | 43 | 1293.23 | 2014-02-01 00:00:00 | 78.45569603787773 | 6.756763483146067 | 71.69893255473167 | 1221.53
 |  |  |  |  |  |  |  |  | 44 | 1221.53 | 2014-03-01 00:00:00 | 78.45569603787773 | 5.764523595505618 | 72.6911724423721 | 1148.84
 |  |  |  |  |  |  |  |  | 45 | 1148.84 | 2014-04-01 00:00:00 | 78.45569603787773 | 6.00236629213483 | 72.4533297457429 | 1076.39
 |  |  |  |  |  |  |  |  | 46 | 1076.39 | 2014-05-01 00:00:00 | 78.45569603787773 | 5.442421348314607 | 73.01327468956312 | 1003.38
 |  |  |  |  |  |  |  |  | 47 | 1003.38 | 2014-06-01 00:00:00 | 78.45569603787773 | 5.242378651685392 | 73.21331738619233 | 930.17
 |  |  |  |  |  |  |  |  | 48 | 930.17 | 2014-07-01 00:00:00 | 78.45569603787773 | 4.703106741573033 | 73.75258929630469 | 856.42
 |  |  |  |  |  |  |  |  | 49 | 856.42 | 2014-08-01 00:00:00 | 78.45569603787773 | 4.474553932584269 | 73.98114210529346 | 782.44
 |  |  |  |  |  |  |  |  | 50 | 782.44 | 2014-09-01 00:00:00 | 78.45569603787773 | 4.088029213483146 | 74.36766682439459 | 708.07
 |  |  |  |  |  |  |  |  | 51 | 708.07 | 2014-10-01 00:00:00 | 78.45569603787773 | 3.580129213483146 | 74.87556682439458 | 633.19
 |  |  |  |  |  |  |  |  | 52 | 633.19 | 2014-11-01 00:00:00 | 78.45569603787773 | 3.308239887640449 | 75.14745615023728 | 558.04
 |  |  |  |  |  |  |  |  | 53 | 558.04 | 2014-12-01 00:00:00 | 78.45569603787773 | 2.821550561797753 | 75.63414547607998 | 482.41
 |  |  |  |  |  |  |  |  | 54 | 482.41 | 2015-01-01 00:00:00 | 78.45569603787773 | 2.520456741573033 | 75.9352392963047 | 406.47
 |  |  |  |  |  |  |  |  | 55 | 406.47 | 2015-02-01 00:00:00 | 78.45569603787773 | 2.123691573033708 | 76.33200446484402 | 330.14
 |  |  |  |  |  |  |  |  | 56 | 330.14 | 2015-03-01 00:00:00 | 78.45569603787773 | 1.55796404494382 | 76.89773199293391 | 253.24
 |  |  |  |  |  |  |  |  | 57 | 253.24 | 2015-04-01 00:00:00 | 78.45569603787773 | 1.323107865168539 | 77.13258817270919 | 176.11
 |  |  |  |  |  |  |  |  | 58 | 176.11 | 2015-05-01 00:00:00 | 78.45569603787773 | 0.8904438202247191 | 77.56525221765301 | 98.54
 |  |  |  |  |  |  |  |  | 59 | 98.54 | 2015-06-01 00:00:00 | 78.45569603787773 | 0.5148438202247191 | 77.94085221765302 | 20.6
 |  |  |  |  |  |  |  |  | 60 | 20.6 | 2015-07-01 00:00:00 | 20.70415730337079 | 0.1041573033707865 | 20.6 | 0