Spreadsheet: 25133d1216260877-loan-amortisation-excel-debt-schedule
Sheet: Debt Schedule

 |  | 41759 |  |  |  | Interest Rate: |  | 0.052 | Fixed |  | Interest Rate: |  | 0.052 | Fixed
 |  |  |  |  |  | Loan margin: |  | 0.016 |  |  | Loan margin: |  | 0.027
 |  |  |  |  |  | UP front fees: |  | 0.01 |  |  | UP front fees: |  | 0.01
 |  |  |  |  |  | Monthly payment: |  | -270486.580143351 | 71 |  | Monthly payment: |  | 0
 |  |  |  |  |  |  |  | 58.32040594916338
 |  |  |  |  |  |  |  | -13725112.84223885 | 71 |  |  |  |  |  |  | BOS COMBINED LOANS
 |  | Period | Days | Date |  | Advance | Interest | Principal | Closing Balance |  | Advance | Interest | Principal | Closing Balance |  | Advance | Interest | Principal | Closing Balance
 |  |  |  | 2008-05-01 00:00:00 |  | 29500000 |  |  | 29500000 |  | 0 |  |  | 0 |  | 29500000
 |  | 1 | 30 | 2008-06-01 00:00:00 |  |  | -167166.6666666667 | -103319.9134766843 | 29396680.08652332 | 1 |  | 0 | 0 | 0 | 1 | 0 | -167166.6666666667 | -103319.9134766843 | 29396680.08652332 |  | 172738.8888888889
 |  | 2 | 31 | 2008-07-01 00:00:00 |  |  | -172133.893395531 | -98352.68674782 | 29298327.3997755 | 2 |  | 0 | 0 | 0 | 2 | 0 | -172133.893395531 | -98352.68674782 | 29298327.3997755
 |  | 3 | 31 | 2008-08-01 00:00:00 |  |  | -171557.983774241 | -98928.59636911002 | 29199398.80340639 | 3 |  | 0 | 0 | 0 | 3 | 0 | -171557.983774241 | -98928.59636911002 | 29199398.80340639
 |  | 4 | 30 | 2008-09-01 00:00:00 |  |  | -165463.2598859695 | -105023.3202573815 | 29094375.48314901 | 4 |  | 0 | 0 | 0 | 4 | 0 | -165463.2598859695 | -105023.3202573815 | 29094375.48314901
 |  | 5 | 31 | 2008-10-01 00:00:00 |  |  | -170363.7319957725 | -100122.8481475785 | 28994252.63500143 | 5 |  | 0 | 0 | 0 | 5 | 0 | -170363.7319957725 | -100122.8481475785 | 28994252.63500143
 |  | 6 | 30 | 2008-11-01 00:00:00 |  |  | -164300.7649316748 | -106185.8152116762 | 28888066.81978975 | 6 |  | 0 | 0 | 0 | 6 | 0 | -164300.7649316748 | -106185.8152116762 | 28888066.81978975
 |  | 7 | 31 | 2008-12-01 00:00:00 |  |  | -169155.68015588 | -101330.899987471 | 28786735.91980228 | 7 |  | 0 | 0 | 0 | 7 | 0 | -169155.68015588 | -101330.899987471 | 28786735.91980228
 |  | 8 | 31 | 2009-01-01 00:00:00 |  |  | -168562.3314415089 | -101924.2487018421 | 28684811.67110044 | 8 |  | 0 | 0 | 0 | 8 | 0 | -168562.3314415089 | -101924.2487018421 | 28684811.67110044
 |  | 9 | 28 | 2009-02-01 00:00:00 |  |  | -151710.7817271535 | -118775.7984161975 | 28566035.87268424 | 9 |  | 0 | 0 | 0 | 9 | 0 | -151710.7817271535 | -118775.7984161975 | 28566035.87268424
 |  | 10 | 31 | 2009-03-01 00:00:00 |  |  | -167270.0100544955 | -103216.5700888555 | 28462819.30259539 | 10 |  | 0 | 0 | 0 | 10 | 0 | -167270.0100544955 | -103216.5700888555 | 28462819.30259539
 |  | 11 | 30 | 2009-04-01 00:00:00 |  |  | -161289.3093813739 | -109197.2707619771 | 28353622.03183341 | 11 |  | 0 | 0 | 0 | 11 | 0 | -161289.3093813739 | -109197.2707619771 | 28353622.03183341
 |  | 12 | 31 | 2009-05-01 00:00:00 |  |  | -166026.2090086245 | -104460.3711347264 | 28249161.66069868 | 12 |  | 0 | 0 | 0 | 12 | 0 | -166026.2090086245 | -104460.3711347264 | 28249161.66069868
 |  | 13 | 30 | 2009-06-01 00:00:00 |  |  | -160078.5827439592 | -110407.9973993918 | 28138753.66329929 | 13 |  | 0 | 0 | 0 | 13 | 0 | -160078.5827439592 | -110407.9973993918 | 28138753.66329929
 |  | 14 | 31 | 2009-07-01 00:00:00 |  |  | -164768.0353395414 | -105718.5448038096 | 28033035.11849548 | 14 |  | 0 | 0 | 0 | 14 | 0 | -164768.0353395414 | -105718.5448038096 | 28033035.11849548
 |  | 15 | 31 | 2009-08-01 00:00:00 |  |  | -164148.9945271902 | -106337.5856161608 | 27926697.53287932 | 15 |  | 0 | 0 | 0 | 15 | 0 | -164148.9945271902 | -106337.5856161608 | 27926697.53287932
 |  | 16 | 30 | 2009-09-01 00:00:00 |  |  | -158251.2860196495 | -112235.2941237015 | 27814462.23875562 | 16 |  | 0 | 0 | 0 | 16 | 0 | -158251.2860196495 | -112235.2941237015 | 27814462.23875562
 |  | 17 | 31 | 2009-10-01 00:00:00 |  |  | -162869.1288869357 | -107617.4512564153 | 27706844.7874992 | 17 |  | 0 | 0 | 0 | 17 | 0 | -162869.1288869357 | -107617.4512564153 | 27706844.7874992
 |  | 18 | 30 | 2009-11-01 00:00:00 |  |  | -157005.4537958288 | -113481.1263475222 | 27593363.66115168 | 18 |  | 0 | 0 | 0 | 18 | 0 | -157005.4537958288 | -113481.1263475222 | 27593363.66115168
 |  | 19 | 31 | 2009-12-01 00:00:00 |  |  | -161574.4738825215 | -108912.1062608295 | 27484451.55489085 | 19 |  | 0 | 0 | 0 | 19 | 0 | -161574.4738825215 | -108912.1062608295 | 27484451.55489085
 |  | 20 | 31 | 2010-01-01 00:00:00 |  |  | -160936.7329936387 | -109549.8471497123 | 27374901.70774114 | 20 |  | 0 | 0 | 0 | 20 | 0 | -160936.7329936387 | -109549.8471497123 | 27374901.70774114
 |  | 21 | 28 | 2010-02-01 00:00:00 |  |  | -144782.8134764976 | -125703.7666668534 | 27249197.94107429 | 21 |  | 0 | 0 | 0 | 21 | 0 | -144782.8134764976 | -125703.7666668534 | 27249197.94107429
 |  | 22 | 31 | 2010-03-01 00:00:00 |  |  | -159559.1923882905 | -110927.3877550605 | 27138270.55331923 | 22 |  | 0 | 0 | 0 | 22 | 0 | -159559.1923882905 | -110927.3877550605 | 27138270.55331923
 |  | 23 | 30 | 2010-04-01 00:00:00 |  |  | -153783.5331354756 | -116703.0470078754 | 27021567.50631135 | 23 |  | 0 | 0 | 0 | 23 | 0 | -153783.5331354756 | -116703.0470078754 | 27021567.50631135
 |  | 24 | 31 | 2010-05-01 00:00:00 |  |  | -158226.2897314009 | -112260.2904119501 | 26909307.2158994 | 24 |  | 0 | 0 | 0 | 24 | 0 | -158226.2897314009 | -112260.2904119501 | 26909307.2158994
 |  | 25 | 30 | 2010-06-01 00:00:00 |  |  | -152486.07422343 | -118000.505919921 | 26791306.70997948 | 25 |  | 0 | 0 | 0 | 25 | 0 | -152486.07422343 | -118000.505919921 | 26791306.70997948
 |  | 26 | 31 | 2010-07-01 00:00:00 |  |  | -156877.9848462132 | -113608.5952971378 | 26677698.11468234 | 26 |  | 0 | 0 | 0 | 26 | 0 | -156877.9848462132 | -113608.5952971378 | 26677698.11468234
 |  | 27 | 31 | 2010-08-01 00:00:00 |  |  | -156212.7434048622 | -114273.8367384888 | 26563424.27794385 | 27 |  | 0 | 0 | 0 | 27 | 0 | -156212.7434048622 | -114273.8367384888 | 26563424.27794385
 |  | 28 | 30 | 2010-09-01 00:00:00 |  |  | -150526.0709083485 | -119960.5092350025 | 26443463.76870885 | 28 |  | 0 | 0 | 0 | 28 | 0 | -150526.0709083485 | -119960.5092350025 | 26443463.76870885
 |  | 29 | 31 | 2010-10-01 00:00:00 |  |  | -154841.1711789952 | -115645.4089643558 | 26327818.3597445 | 29 |  | 0 | 0 | 0 | 29 | 0 | -154841.1711789952 | -115645.4089643558 | 26327818.3597445
 |  | 30 | 30 | 2010-11-01 00:00:00 |  |  | -149190.9707052188 | -121295.6094381322 | 26206522.75030636 | 30 |  | 0 | 0 | 0 | 30 | 0 | -149190.9707052188 | -121295.6094381322 | 26206522.75030636
 |  | 31 | 31 | 2010-12-01 00:00:00 |  |  | -153453.7498823495 | -117032.8302610015 | 26089489.92004536 | 31 |  | 0 | 0 | 0 | 31 | 0 | -153453.7498823495 | -117032.8302610015 | 26089489.92004536
 |  | 32 | 31 | 2011-01-01 00:00:00 |  |  | -152768.4576429323 | -117718.1225004187 | 25971771.79754494 | 32 |  | 0 | 0 | 0 | 32 | 0 | -152768.4576429323 | -117718.1225004187 | 25971771.79754494
 |  | 33 | 28 | 2011-02-01 00:00:00 |  |  | -137361.8152847933 | -133124.7648585577 | 25838647.03268638 | 33 |  | 0 | 0 | 0 | 33 | 0 | -137361.8152847933 | -133124.7648585577 | 25838647.03268638
 |  | 34 | 31 | 2011-03-01 00:00:00 |  |  | -151299.6331802858 | -119186.9469630652 | 25719460.08572332 | 34 |  | 0 | 0 | 0 | 34 | 0 | -151299.6331802858 | -119186.9469630652 | 25719460.08572332
 |  | 35 | 30 | 2011-04-01 00:00:00 |  |  | -145743.6071524321 | -124742.9729909188 | 25594717.1127324 | 35 |  | 0 | 0 | 0 | 35 | 0 | -145743.6071524321 | -124742.9729909188 | 25594717.1127324
 |  | 36 | 31 | 2011-05-01 00:00:00 |  |  | -149871.287982333 | -120615.2921610179 | 25474101.82057138 | 36 |  | 0 | 0 | 0 | 36 | 0 | -149871.287982333 | -120615.2921610179 | 25474101.82057138
 |  | 37 | 30 | 2011-06-01 00:00:00 |  |  | -144353.2436499045 | -126133.3364934465 | 25347968.48407793 | 37 |  | 0 | 0 | 0 | 37 | 0 | -144353.2436499045 | -126133.3364934465 | 25347968.48407793
 |  | 38 | 31 | 2011-07-01 00:00:00 |  |  | -148426.4376789897 | -122060.1424643613 | 25225908.34161357 | 38 |  | 0 | 0 | 0 | 38 | 0 | -148426.4376789897 | -122060.1424643613 | 25225908.34161357
 |  | 39 | 31 | 2011-08-01 00:00:00 |  |  | -147711.7077336706 | -122774.8724096804 | 25103133.46920389 | 39 |  | 0 | 0 | 0 | 39 | 0 | -147711.7077336706 | -122774.8724096804 | 25103133.46920389
 |  | 40 | 30 | 2011-09-01 00:00:00 |  |  | -142251.089658822 | -128235.4904845289 | 24974897.97871936 | 40 |  | 0 | 0 | 0 | 40 | 0 | -142251.089658822 | -128235.4904845289 | 24974897.97871936
 |  | 41 | 31 | 2011-10-01 00:00:00 |  |  | -146241.9026087234 | -124244.6775346276 | 24850653.30118474 | 41 |  | 0 | 0 | 0 | 41 | 0 | -146241.9026087234 | -124244.6775346276 | 24850653.30118474
 |  | 42 | 30 | 2011-11-01 00:00:00 |  |  | -140820.3687067135 | -129666.2114366375 | 24720987.0897481 | 42 |  | 0 | 0 | 0 | 42 | 0 | -140820.3687067135 | -129666.2114366375 | 24720987.0897481
 |  | 43 | 31 | 2011-12-01 00:00:00 |  |  | -144755.1132921916 | -125731.4668511593 | 24595255.62289694 | 43 |  | 0 | 0 | 0 | 43 | 0 | -144755.1132921916 | -125731.4668511593 | 24595255.62289694
 |  | 44 | 31 | 2012-01-01 00:00:00 |  |  | -144018.8857029632 | -126467.6944403878 | 24468787.92845655 | 44 |  | 0 | 0 | 0 | 44 | 0 | -144018.8857029632 | -126467.6944403878 | 24468787.92845655
 |  | 45 | 29 | 2012-02-01 00:00:00 |  |  | -134034.5827636564 | -136451.9973796945 | 24332335.93107686 | 45 |  | 0 | 0 | 0 | 45 | 0 | -134034.5827636564 | -136451.9973796945 | 24332335.93107686
 |  | 46 | 31 | 2012-03-01 00:00:00 |  |  | -142479.3448408612 | -128007.2353024898 | 24204328.69577437 | 46 |  | 0 | 0 | 0 | 46 | 0 | -142479.3448408612 | -128007.2353024898 | 24204328.69577437
 |  | 47 | 30 | 2012-04-01 00:00:00 |  |  | -137157.8626093881 | -133328.7175339629 | 24070999.9782404 | 47 |  | 0 | 0 | 0 | 47 | 0 | -137157.8626093881 | -133328.7175339629 | 24070999.9782404
 |  | 48 | 31 | 2012-05-01 00:00:00 |  |  | -140949.0776503633 | -129537.5024929877 | 23941462.47574742 | 48 |  | 0 | 0 | 0 | 48 | 0 | -140949.0776503633 | -129537.5024929877 | 23941462.47574742
 |  | 49 | 30 | 2012-06-01 00:00:00 |  |  | -135668.2873625687 | -134818.2927807823 | 23806644.18296663 | 49 |  | 0 | 0 | 0 | 49 | 0 | -135668.2873625687 | -134818.2927807823 | 23806644.18296663
 |  | 50 | 31 | 2012-07-01 00:00:00 |  |  | -139401.1276047046 | -131085.4525386464 | 23675558.73042799 | 50 |  | 0 | 0 | 0 | 50 | 0 | -139401.1276047046 | -131085.4525386464 | 23675558.73042799
 |  | 51 | 31 | 2012-08-01 00:00:00 |  |  | -138633.5494548395 | -131853.0306885115 | 23543705.69973947 | 51 |  | 0 | 0 | 0 | 51 | 0 | -138633.5494548395 | -131853.0306885115 | 23543705.69973947
 |  | 52 | 30 | 2012-09-01 00:00:00 |  |  | -133414.3322985237 | -137072.2478448273 | 23406633.45189465 | 52 |  | 0 | 0 | 0 | 52 | 0 | -133414.3322985237 | -137072.2478448273 | 23406633.45189465
 |  | 53 | 31 | 2012-10-01 00:00:00 |  |  | -137058.8425460942 | -133427.7375972568 | 23273205.71429739 | 53 |  | 0 | 0 | 0 | 53 | 0 | -137058.8425460942 | -133427.7375972568 | 23273205.71429739
 |  | 54 | 30 | 2012-11-01 00:00:00 |  |  | -131881.4990476852 | -138605.0810956658 | 23134600.63320173 | 54 |  | 0 | 0 | 0 | 54 | 0 | -131881.4990476852 | -138605.0810956658 | 23134600.63320173
 |  | 55 | 31 | 2012-12-01 00:00:00 |  |  | -135465.9392633034 | -135020.6408800475 | 22999579.99232168 | 55 |  | 0 | 0 | 0 | 55 | 0 | -135465.9392633034 | -135020.6408800475 | 22999579.99232168
 |  | 56 | 31 | 2013-01-01 00:00:00 |  |  | -134675.3183994836 | -135811.2617438674 | 22863768.73057781 | 56 |  | 0 | 0 | 0 | 56 | 0 | -134675.3183994836 | -135811.2617438674 | 22863768.73057781
 |  | 57 | 28 | 2013-02-01 00:00:00 |  |  | -120923.9323972782 | -149562.6477460728 | 22714206.08283174 | 57 |  | 0 | 0 | 0 | 57 | 0 | -120923.9323972782 | -149562.6477460728 | 22714206.08283174
 |  | 58 | 31 | 2013-03-01 00:00:00 |  |  | -133004.2956183592 | -137482.2845249918 | 22576723.79830675 | 58 |  | 0 | 0 | 0 | 58 | 0 | -133004.2956183592 | -137482.2845249918 | 22576723.79830675
 |  | 59 | 30 | 2013-04-01 00:00:00 |  |  | -127934.7681904049 | -142551.8119529461 | 22434171.9863538 | 59 |  | 0 | 0 | 0 | 59 | 0 | -127934.7681904049 | -142551.8119529461 | 22434171.9863538
 |  | 60 | 31 | 2013-05-01 00:00:00 |  |  | -131364.5404089828 | -139122.0397343682 | 22295049.94661944 | 60 |  | 0 | 0 | 0 | 60 | 0 | -131364.5404089828 | -139122.0397343682 | 22295049.94661944
 |  | 61 | 31 | 2013-06-01 00:00:00 |  |  | -130549.903576316 | -139936.676567035 | 22155113.2700524 | 61 |  | 0 | 0 | 0 | 61 | 0 | -130549.903576316 | -139936.676567035 | 22155113.2700524
 |  | 62 | 30 | 2013-07-01 00:00:00 |  |  | -125545.6418636303 | -144940.9382797207 | 22010172.33177268 | 62 |  | 0 | 0 | 0 | 62 | 0 | -125545.6418636303 | -144940.9382797207 | 22010172.33177268
 |  | 63 | 31 | 2013-08-01 00:00:00 |  |  | -128881.7868760467 | -141604.7932673043 | 21868567.53850537 | 63 |  | 0 | 0 | 0 | 63 | 0 | -128881.7868760467 | -141604.7932673043 | 21868567.53850537
 |  | 64 | 31 | 2013-09-01 00:00:00 |  |  | -128052.612142137 | -142433.968001214 | 21726133.57050416 | 64 |  | 0 | 0 | 0 | 64 | 0 | -128052.612142137 | -142433.968001214 | 21726133.57050416
 |  | 65 | 30 | 2013-10-01 00:00:00 |  |  | -123114.7568995236 | -147371.8232438274 | 21578761.74726033 | 65 |  | 0 | 0 | 0 | 65 | 0 | -123114.7568995236 | -147371.8232438274 | 21578761.74726033
 |  | 66 | 31 | 2013-11-01 00:00:00 |  |  | -126355.63823118 | -144130.941912171 | 21434630.80534816 | 66 |  | 0 | 0 | 0 | 66 | 0 | -126355.63823118 | -144130.941912171 | 21434630.80534816
 |  | 67 | 30 | 2013-12-01 00:00:00 |  |  | -121462.9078969729 | -149023.6722463781 | 21285607.13310178 | 67 |  | 0 | 0 | 0 | 67 | 0 | -121462.9078969729 | -149023.6722463781 | 21285607.13310178
 |  | 68 | 31 | 2014-01-01 00:00:00 |  |  | -124639.0551016071 | -145847.5250417439 | 21139759.60806004 | 68 |  | 0 | 0 | 0 | 68 | 0 | -124639.0551016071 | -145847.5250417439 | 21139759.60806004
 |  | 69 | 31 | 2014-02-01 00:00:00 |  |  | -123785.0368160849 | -146701.5433272661 | 20993058.06473278 | 69 |  | 0 | 0 | 0 | 69 | 0 | -123785.0368160849 | -146701.5433272661 | 20993058.06473278
 |  | 70 | 28 | 2014-03-01 00:00:00 |  |  | -111029.9515423645 | -159456.6286009865 | 20833601.43613179 | 70 |  | 0 | 0 | 0 | 70 | 0 | -111029.9515423645 | -159456.6286009865 | 20833601.43613179
 |  | 71 | 31 | 2014-04-01 00:00:00 |  |  | -121992.3106315717 | -20648494.26951178 | 185107.1666200124 | 71 |  | 0 | 0 | 0 | 71 | 0 | -121992.3106315717 | -20648494.26951178 | 185107.1666200124