Spreadsheet: 58094d1258408011-loan-amortisation-using-a-floating-rate-amort_demo
Sheet: Sheet1

 | Balance |  |  |  | 200000
 | [NAME]) |  |  |  | 6
 | Rate Chg Freq (Mos) |  |  |  | 1
 | Index |  |  |  | L3M
 | [NAME] |  |  |  | 5
 | Margin |  |  |  | 5.4
 | Rate Chg | [NAME] | Index | Rate | Balance | Pmt
0 |  | 0 | 1.425
1 |  |  | 1.432667935311901
2 |  |  | 1.434389108448128
3 |  |  | 1.438318524718453
 |  |  | 1.446079539026619
 |  |  | 1.449163145135622
 |  |  | 1.451692062011531
 |  |  | 1.458760949507437
 |  |  | 1.461655468072429
 |  |  | 1.468191146975251
 |  |  | 1.471680372370963
 |  |  | 1.477178098347202
 |  |  | 1.477794496625653
 |  |  | 1.486278940025882
 |  |  | 1.49403905300985
 |  |  | 1.498117733909382
 |  |  | 1.503289714466153
 |  |  | 1.510524293880469
 |  |  | 1.519428767784983
 |  |  | 1.523210499790847
 |  |  | 1.530634209894395
 |  |  | 1.537910985384839
 |  |  | 1.53943046601331
 |  |  | 1.542392270318561
 |  |  | 1.544754294076677
 |  |  | 1.54942320093491
 |  |  | 1.5505778304452
 |  |  | 1.551201248565211
 |  |  | 1.556424675842474
 |  |  | 1.561510969270453
 |  |  | 1.563983909804912
 |  |  | 1.572931763242291
 |  |  | 1.574488721892583
 |  |  | 1.577276061866833
 |  |  | 1.580224936100745
 |  |  | 1.585548448814052
 |  |  | 1.591806548398593
 |  |  | 1.59181706631035
 |  |  | 1.593154385184879
 |  |  | 1.597705592434506
 |  |  | 1.599247409690809
 |  |  | 1.603830320410862
 |  |  | 1.613469263798043
 |  |  | 1.614760274963884
 |  |  | 1.618802140369775
 |  |  | 1.621704602513878
 |  |  | 1.631198545541314
 |  |  | 1.637296862942234
 |  |  | 1.638639652593639
 |  |  | 1.64193443431165
 |  |  | 1.643802802455828
 |  |  | 1.647090747612621
 |  |  | 1.652309818438658
 |  |  | 1.65559535197775
 |  |  | 1.660955624455085
 |  |  | 1.668464521147765
 |  |  | 1.674931316915366
 |  |  | 1.681568343892662
 |  |  | 1.686369058831136
 |  |  | 1.687060029842663
 |  |  | 1.69377492756808
 |  |  | 1.697195657435276
 |  |  | 1.703871858501979
 |  |  | 1.706748636191203
 |  |  | 1.710877124025572
 |  |  | 1.718947606817434
 |  |  | 1.726798270763634
 |  |  | 1.732227329863336
 |  |  | 1.736783020596989
 |  |  | 1.740296690282331
 |  |  | 1.741781675421075
 |  |  | 1.744095177641192
 |  |  | 1.752033906413589
 |  |  | 1.755466596045956
 |  |  | 1.756908070504447
 |  |  | 1.761556767204028
 |  |  | 1.763442137395533
 |  |  | 1.770565190409093
 |  |  | 1.77156757470156
 |  |  | 1.778563744400511
 |  |  | 1.779239038031956
 |  |  | 1.783803030646717
 |  |  | 1.785834536286917
 |  |  | 1.79323189663209
 |  |  | 1.796134196468673
 |  |  | 1.799520972246245
 |  |  | 1.805086641325693
 |  |  | 1.812034568765219
 |  |  | 1.818910672712302
 |  |  | 1.820328425312174
 |  |  | 1.824629697943261
 |  |  | 1.826111593388659
 |  |  | 1.834522643078975
 |  |  | 1.843911956809252
 |  |  | 1.847755314220424
 |  |  | 1.848542810515268
 |  |  | 1.851605077038121
 |  |  | 1.851951391422145
 |  |  | 1.858569861513881
 |  |  | 1.863916329559317
 |  |  | 1.865542294116244
 |  |  | 1.873856986521909
 |  |  | 1.879942623039956
 |  |  | 1.886517352021498
 |  |  | 1.892564401535476
 |  |  | 1.895875973942496
 |  |  | 1.902676314473451
 |  |  | 1.904754923937575
 |  |  | 1.908490122736504
 |  |  | 1.910709811068951
 |  |  | 1.918676715722998
 |  |  | 1.92157465893755
 |  |  | 1.927467452542702
 |  |  | 1.933897903409815
 |  |  | 1.943153189618648
 |  |  | 1.947820726309362
 |  |  | 1.950436549702526
 |  |  | 1.955277658961709
 |  |  | 1.960618415276293
 |  |  | 1.966396917989898
 |  |  | 1.967595916079702
 |  |  | 1.970568730577985
 |  |  | 1.973751853491497
 |  |  | 1.979011465812713
 |  |  | 1.980275957143814
 |  |  | 1.987606918341944
 |  |  | 1.987724343606367
 |  |  | 1.995835953580251
 |  |  | 2.004417302292246
 |  |  | 2.013318968003839
 |  |  | 2.019737787244495
 |  |  | 2.020862006451495
 |  |  | 2.021962694041996
 |  |  | 2.024955417774693
 |  |  | 2.028838210910373
 |  |  | 2.037694293516148
 |  |  | 2.046608599897447
 |  |  | 2.051207745496301
 |  |  | 2.056728520074751
 |  |  | 2.062215397540221
 |  |  | 2.069397217226722
 |  |  | 2.079074605570306
 |  |  | 2.084981917222987
 |  |  | 2.086168310160512
 |  |  | 2.093439840306019
 |  |  | 2.096737689814983
 |  |  | 2.105011862125296
 |  |  | 2.107135633077859
 |  |  | 2.115709549007781
 |  |  | 2.12152635744821
 |  |  | 2.12989992917587
 |  |  | 2.136050638042821
 |  |  | 2.136334600504824
 |  |  | 2.143570047374129
 |  |  | 2.143784729232783
 |  |  | 2.14683502409257
 |  |  | 2.147233551816472
 |  |  | 2.153809982452023
 |  |  | 2.161500332052951
 |  |  | 2.169156621124272
 |  |  | 2.169864817655507
 |  |  | 2.175207480396327
 |  |  | 2.184066608191758
 |  |  | 2.193326811503788
 |  |  | 2.201583925281032
 |  |  | 2.209637645846528
 |  |  | 2.216648008942851
 |  |  | 2.22164637158032
 |  |  | 2.230898207828013
 |  |  | 2.237211969256883
 |  |  | 2.241752387950127
 |  |  | 2.249418562171657
 |  |  | 2.250407961724651
 |  |  | 2.254465683767027
 |  |  | 2.257085106553299
 |  |  | 2.260862466820949
 |  |  | 2.270356857410143
 |  |  | 2.271200536022927
 |  |  | 2.28005179539567
 |  |  | 2.285633951882227
 |  |  | 2.29004006079285
 |  |  | 2.292509228220812
 |  |  | 2.294809029819891
 |  |  | 2.295180374270446
 |  |  | 2.299375919687406
 |  |  | 2.30367613192999
 |  |  | 2.31330866175853
 |  |  | 2.322170837218134
 |  |  | 2.331763132573113
 |  |  | 2.340055668827413
 |  |  | 2.342455739544173
 |  |  | 2.345112850603634
 |  |  | 2.348981005283689
 |  |  | 2.351102979204257
 |  |  | 2.354916177613073
 |  |  | 2.355946015468422
 |  |  | 2.358605941148987
 |  |  | 2.360876026759311
 |  |  | 2.366853677686586
 |  |  | 2.374406094164928
 |  |  | 2.377972176592058
 |  |  | 2.379057429647621
 |  |  | 2.386392025921732
 |  |  | 2.390258615036904
 |  |  | 2.393282212160666
 |  |  | 2.393958831868872
 |  |  | 2.4024661454564
 |  |  | 2.402604635483365
 |  |  | 2.41095413037676
 |  |  | 2.414656579186153
 |  |  | 2.415191604729804
 |  |  | 2.415249743691143
 |  |  | 2.415564726043464
 |  |  | 2.423251887135367
 |  |  | 2.431591799077696
 |  |  | 2.431738066588164
 |  |  | 2.434962717025657
 |  |  | 2.440135360850141
 |  |  | 2.446131958976902
 |  |  | 2.452680342878518
 |  |  | 2.455684806882734
 |  |  | 2.456437847612228
 |  |  | 2.461404050818477
 |  |  | 2.467540003918642
 |  |  | 2.470275327946312
 |  |  | 2.474923208662252
 |  |  | 2.481943566398011
 |  |  | 2.490978702383492
 |  |  | 2.491682516704269
 |  |  | 2.499928084010082
 |  |  | 2.507814133514187
 |  |  | 2.508052086210152
 |  |  | 2.514195341189757
 |  |  | 2.523002773527569
 |  |  | 2.523327260195319
 |  |  | 2.527657098367685
 |  |  | 2.536982314987375
 |  |  | 2.538232222208838
 |  |  | 2.542042811042299
 |  |  | 2.544759995200768
 |  |  | 2.550295515224381
 |  |  | 2.557850165684837
 |  |  | 2.564340896692499
 |  |  | 2.568630427943177
 |  |  | 2.577018253955537
 |  |  | 2.580961092179284
 |  |  | 2.588501646189777
 |  |  | 2.589727077376005
 |  |  | 2.595675146902614
 |  |  | 2.602073173237717
 |  |  | 2.602197248388824
 |  |  | 2.609771037865558
 |  |  | 2.61810133599253
 |  |  | 2.622506222254542
 |  |  | 2.626547623156512
 |  |  | 2.63456447127509
 |  |  | 2.641352879951538
 |  |  | 2.645177678023912
 |  |  | 2.650130567364147
 |  |  | 2.654537170327359
 |  |  | 2.661080953535487
 |  |  | 2.664511081023353
 |  |  | 2.671506986232746
 |  |  | 2.673139772553986
 |  |  | 2.678963122871288
 |  |  | 2.688552348004977
 |  |  | 2.696664607226261
 |  |  | 2.699229954356442
 |  |  | 2.69964224133882
 |  |  | 2.709510697894281
 |  |  | 2.717453120288069
 |  |  | 2.726688723951299
 |  |  | 2.729126802624423
 |  |  | 2.733113376826499
 |  |  | 2.734688329637991
 |  |  | 2.742535775026775
 |  |  | 2.74366774927657
 |  |  | 2.75120540582741
 |  |  | 2.759139341913297
 |  |  | 2.767908468335057
 |  |  | 2.773036573471658
 |  |  | 2.777556053388567
 |  |  | 2.783920104364367
 |  |  | 2.791892321777571
 |  |  | 2.794836188115053
 |  |  | 2.794889405074166
 |  |  | 2.803081814706564
 |  |  | 2.806102093198505
 |  |  | 2.814711690534179
 |  |  | 2.818651956095769
 |  |  | 2.819289556448439
 |  |  | 2.828025858072793
 |  |  | 2.836160432828433
 |  |  | 2.842810808186072
 |  |  | 2.851331703958073
 |  |  | 2.854943086866339
 |  |  | 2.861466442424592
 |  |  | 2.867847376212195
 |  |  | 2.872971098544217
 |  |  | 2.875204938495941
 |  |  | 2.879041295446845
 |  |  | 2.88531254458353
 |  |  | 2.887065092465202
 |  |  | 2.89238229874002
 |  |  | 2.892554078318087
 |  |  | 2.897620129276032
 |  |  | 2.899851043451852
 |  |  | 2.907335962718849
 |  |  | 2.915651234182088
 |  |  | 2.922036545992517
 |  |  | 2.928990229916683
 |  |  | 2.935211050139998
 |  |  | 2.942162809238876
 |  |  | 2.95106812242777
 |  |  | 2.956686732339255
 |  |  | 2.965877748763909
 |  |  | 2.968134124784757
 |  |  | 2.974027687778138
 |  |  | 2.98356946435386
 |  |  | 2.984134360134957
 |  |  | 2.992403267578365
 |  |  | 2.996566979057182
 |  |  | 3.005810723695961
 |  |  | 3.009166473691967
 |  |  | 3.00988683666755
 |  |  | 3.01136341757216
 |  |  | 3.015571773578317
 |  |  | 3.015644149301957
 |  |  | 3.02358412263946
 |  |  | 3.02714162489064
 |  |  | 3.027315330541692
 |  |  | 3.034058535122622
 |  |  | 3.038806263525869
 |  |  | 3.039757837122316
 |  |  | 3.040976536023054
 |  |  | 3.043602963320774
 |  |  | 3.048551401551126
 |  |  | 3.05605513712046
 |  |  | 3.059263887549536
 |  |  | 3.06408650241404
 |  |  | 3.073421061349378
 |  |  | 3.080273254743422
 |  |  | 3.086119020887924
 |  |  | 3.095693131334927
 |  |  | 3.09575635085116
 |  |  | 3.097674111590265
 |  |  | 3.101045178815451
 |  |  | 3.108896874964619
 |  |  | 3.116901893026863
 |  |  | 3.120398150270562
 |  |  | 3.124892502573536
 |  |  | 3.133797800475301
 |  |  | 3.141287660628691
 |  |  | 3.143229846832604
 |  |  | 3.151014705720791
 |  |  | 3.154226667887526
 |  |  | 3.163174935396051
 |  |  | 3.16544223737838
 |  |  | 3.169812065359643
 |  |  | 3.170298618601846
 |  |  | 3.176880916236534