Spreadsheet: 30725d1226415748-use-if-to-avoid-getting-anything-written-after-loan-cost
Sheet: Kalkyl 13

 | Ränta | 0.09 |  | [NAME] | 900000
 | Lånetid | 2 | år | Amortering (månad) | 37500
 |  |  |  |  |  |  |  |  |  |  |  | E29
 | År | Månad | [NAME] (1:e) | Ränta | Amortering (siste) | Total inbetalning
 | 1 | Januari | 900000 | 6750 | 37500 | 44250 |  |  | 84375
 |  | Februari | 862500 | 6468.75 | 37500 | 43968.75
 |  | Mars | 825000 | 6187.5 | 37500 | 43687.5
 |  | April | 787500 | 5906.25 | 37500 | 43406.25
 |  | Maj | 750000 | 5625 | 37500 | 43125
 |  | Juni | 712500 | 5343.75 | 37500 | 42843.75
 |  | [NAME] | 675000 | 5062.5 | 37500 | 42562.5
 |  | Augusti | 637500 | 4781.25 | 37500 | 42281.25
 |  | September | 600000 | 4500 | 37500 | 42000
 |  | Oktober | 562500 | 4218.75 | 37500 | 41718.75
 |  | November | 525000 | 3937.5 | 37500 | 41437.5
 |  | December | 487500 | 3656.25 | 37500 | 41156.25 | Totalt | Ränta | Amortering | Total inbetalning
 | 2 | Januari | 450000 | 3375 | 37500 | 40875 |  | 62437.5 | 450000 | 512437.5
 |  | Februari | 412500 | 3093.75 | 37500 | 40593.75
 |  | Mars | 375000 | 2812.5 | 37500 | 40312.5
 |  | April | 337500 | 2531.25 | 37500 | 40031.25
 |  | Maj | 300000 | 2250 | 37500 | 39750
 |  | Juni | 262500 | 1968.75 | 37500 | 39468.75
 |  | [NAME] | 225000 | 1687.5 | 37500 | 39187.5
 |  | Augusti | 187500 | 1406.25 | 37500 | 38906.25
 |  | September | 150000 | 1125 | 37500 | 38625
 |  | Oktober | 112500 | 843.75 | 37500 | 38343.75
 |  | November | 75000 | 562.5 | 37500 | 38062.5
 |  | December | 37500 | 281.25 | 37500 | 37781.25 | Totalt | Ränta | Amortering | Total inbetalning
 | 3 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 4 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 5 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 6 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 7 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 8 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 9 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 10 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 11 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 12 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 13 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 14 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 15 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 16 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 17 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 18 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 19 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 20 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 21 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 22 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 23 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 24 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 25 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 26 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 27 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 28 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 29 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 30 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  | Februari | 0 | 0 | 0 | 0
 |  | Mars | 0 | 0 | 0 | 0
 |  | April | 0 | 0 | 0 | 0
 |  | Maj | 0 | 0 | 0 | 0
 |  | Juni | 0 | 0 | 0 | 0
 |  | [NAME] | 0 | 0 | 0 | 0
 |  | Augusti | 0 | 0 | 0 | 0
 |  | September | 0 | 0 | 0 | 0
 |  | Oktober | 0 | 0 | 0 | 0
 |  | November | 0 | 0 | 0 | 0
 |  | December | 0 | 0 | 0 | 0 | Totalt | Ränta | Amortering | Total inbetalning
 | 31 | Januari | 0 | 0 | 0 | 0 |  | 84375 | 900000 | 984375
 |  |  |  | 84375