Spreadsheet: 879017d1726452835-loan-amortisation-table-with-variable-interest-rate-and-fixed-escalated-repayments-loan-schedule-draft-francois23-
Sheet: Year 1

Loan Amount | 1500000 |  |  |  |  |  |  | Initial Payment | 9259.708986623813
Interest rate | 0.07 |  |  |  |  |  |  | Escalation | 0.03
Months | 240
Payment per month (if fixed)
 |  |  |  |  |  |  |  | Final payments, escalating at:
Period | Beginning Balance | Payment | Principal | Interest | Cumalative Principal | Cumulative interest | Ending Balance | 1.03 | Principal component of final payment | Interest component of final payment
2019-03-01 00:00:00 |  |  |  |  |  |  |  | 8656 | ? | ?
2019-04-01 00:00:00 |  |  |  |  |  |  |  | 8656
2019-05-01 00:00:00 |  |  |  |  |  |  |  | 8656
2019-06-01 00:00:00 |  |  |  |  |  |  |  | 8656
2019-07-01 00:00:00 |  |  |  |  |  |  |  | 8656
2019-08-01 00:00:00 |  |  |  |  |  |  |  | 8656
2019-09-01 00:00:00 |  |  |  |  |  |  |  | 8656
2019-10-01 00:00:00 |  |  |  |  |  |  |  | 8656
2019-11-01 00:00:00 |  |  |  |  |  |  |  | 8656
2019-12-01 00:00:00 |  |  |  |  |  |  |  | 8656
2020-01-01 00:00:00 |  |  |  |  |  |  |  | 8656
2020-02-01 00:00:00 |  |  |  |  |  |  |  | 8656
2020-03-01 00:00:00 |  |  |  |  |  |  |  | 8915.68
2020-04-01 00:00:00 |  |  |  |  |  |  |  | 8915.68
2020-05-01 00:00:00 |  |  |  |  |  |  |  | 8915.68
2020-06-01 00:00:00 |  |  |  |  |  |  |  | 8915.68
2020-07-01 00:00:00 |  |  |  |  |  |  |  | 8915.68
2020-08-01 00:00:00 |  |  |  |  |  |  |  | 8915.68
2020-09-01 00:00:00 |  |  |  |  |  |  |  | 8915.68
2020-10-01 00:00:00 |  |  |  |  |  |  |  | 8915.68
2020-11-01 00:00:00 |  |  |  |  |  |  |  | 8915.68
2020-12-01 00:00:00 |  |  |  |  |  |  |  | 8915.68
2021-01-01 00:00:00 |  |  |  |  |  |  |  | 8915.68
2021-02-01 00:00:00 |  |  |  |  |  |  |  | 8915.68
2021-03-01 00:00:00 |  |  |  |  |  |  |  | 9183.1504
2021-04-01 00:00:00 |  |  |  |  |  |  |  | 9183.1504
2021-05-01 00:00:00 |  |  |  |  |  |  |  | 9183.1504
2021-06-01 00:00:00 |  |  |  |  |  |  |  | 9183.1504
2021-07-01 00:00:00 |  |  |  |  |  |  |  | 9183.1504
2021-08-01 00:00:00 |  |  |  |  |  |  |  | 9183.1504
2021-09-01 00:00:00 |  |  |  |  |  |  |  | 9183.1504
2021-10-01 00:00:00 |  |  |  |  |  |  |  | 9183.1504
2021-11-01 00:00:00 |  |  |  |  |  |  |  | 9183.1504
2021-12-01 00:00:00 |  |  |  |  |  |  |  | 9183.1504
2022-01-01 00:00:00 |  |  |  |  |  |  |  | 9183.1504
2022-02-01 00:00:00 |  |  |  |  |  |  |  | 9183.1504
2022-03-01 00:00:00 |  |  |  |  |  |  |  | 9458.644912000002
2022-04-01 00:00:00 |  |  |  |  |  |  |  | 9458.644912000002
2022-05-01 00:00:00 |  |  |  |  |  |  |  | 9458.644912000002
2022-06-01 00:00:00 |  |  |  |  |  |  |  | 9458.644912000002
2022-07-01 00:00:00 |  |  |  |  |  |  |  | 9458.644912000002
2022-08-01 00:00:00 |  |  |  |  |  |  |  | 9458.644912000002
2022-09-01 00:00:00 |  |  |  |  |  |  |  | 9458.644912000002
2022-10-01 00:00:00 |  |  |  |  |  |  |  | 9458.644912000002
2022-11-01 00:00:00 |  |  |  |  |  |  |  | 9458.644912000002
2022-12-01 00:00:00 |  |  |  |  |  |  |  | 9458.644912000002
2023-01-01 00:00:00 |  |  |  |  |  |  |  | 9458.644912000002
2023-02-01 00:00:00 |  |  |  |  |  |  |  | 9458.644912000002
2023-03-01 00:00:00 |  |  |  |  |  |  |  | 9742.404259360002
2023-04-01 00:00:00 |  |  |  |  |  |  |  | 9742.404259360002
2023-05-01 00:00:00 |  |  |  |  |  |  |  | 9742.404259360002
2023-06-01 00:00:00 |  |  |  |  |  |  |  | 9742.404259360002
2023-07-01 00:00:00 |  |  |  |  |  |  |  | 9742.404259360002
2023-08-01 00:00:00 |  |  |  |  |  |  |  | 9742.404259360002
2023-09-01 00:00:00 |  |  |  |  |  |  |  | 9742.404259360002
2023-10-01 00:00:00 |  |  |  |  |  |  |  | 9742.404259360002
2023-11-01 00:00:00 |  |  |  |  |  |  |  | 9742.404259360002
2023-12-01 00:00:00 |  |  |  |  |  |  |  | 9742.404259360002
2024-01-01 00:00:00 |  |  |  |  |  |  |  | 9742.404259360002
2024-02-01 00:00:00 |  |  |  |  |  |  |  | 9742.404259360002
2024-03-01 00:00:00 |  |  |  |  |  |  |  | 10034.6763871408
2024-04-01 00:00:00 |  |  |  |  |  |  |  | 10034.6763871408
2024-05-01 00:00:00 |  |  |  |  |  |  |  | 10034.6763871408
2024-06-01 00:00:00 |  |  |  |  |  |  |  | 10034.6763871408
2024-07-01 00:00:00 |  |  |  |  |  |  |  | 10034.6763871408
2024-08-01 00:00:00 |  |  |  |  |  |  |  | 10034.6763871408
2024-09-01 00:00:00 |  |  |  |  |  |  |  | 10034.6763871408
2024-10-01 00:00:00 |  |  |  |  |  |  |  | 10034.6763871408
2024-11-01 00:00:00 |  |  |  |  |  |  |  | 10034.6763871408
2024-12-01 00:00:00 |  |  |  |  |  |  |  | 10034.6763871408
2025-01-01 00:00:00 |  |  |  |  |  |  |  | 10034.6763871408
2025-02-01 00:00:00 |  |  |  |  |  |  |  | 10034.6763871408
2025-03-01 00:00:00 |  |  |  |  |  |  |  | 10335.71667875503
2025-04-01 00:00:00 |  |  |  |  |  |  |  | 10335.71667875503
2025-05-01 00:00:00 |  |  |  |  |  |  |  | 10335.71667875503
2025-06-01 00:00:00 |  |  |  |  |  |  |  | 10335.71667875503
2025-07-01 00:00:00 |  |  |  |  |  |  |  | 10335.71667875503
2025-08-01 00:00:00 |  |  |  |  |  |  |  | 10335.71667875503
2025-09-01 00:00:00 |  |  |  |  |  |  |  | 10335.71667875503
2025-10-01 00:00:00 |  |  |  |  |  |  |  | 10335.71667875503
2025-11-01 00:00:00 |  |  |  |  |  |  |  | 10335.71667875503
2025-12-01 00:00:00 |  |  |  |  |  |  |  | 10335.71667875503
2026-01-01 00:00:00 |  |  |  |  |  |  |  | 10335.71667875503
2026-02-01 00:00:00 |  |  |  |  |  |  |  | 10335.71667875503
2026-03-01 00:00:00 |  |  |  |  |  |  |  | 10645.78817911768
2026-04-01 00:00:00 |  |  |  |  |  |  |  | 10645.78817911768
2026-05-01 00:00:00 |  |  |  |  |  |  |  | 10645.78817911768
2026-06-01 00:00:00 |  |  |  |  |  |  |  | 10645.78817911768
2026-07-01 00:00:00 |  |  |  |  |  |  |  | 10645.78817911768
2026-08-01 00:00:00 |  |  |  |  |  |  |  | 10645.78817911768
2026-09-01 00:00:00 |  |  |  |  |  |  |  | 10645.78817911768
2026-10-01 00:00:00 |  |  |  |  |  |  |  | 10645.78817911768
2026-11-01 00:00:00 |  |  |  |  |  |  |  | 10645.78817911768
2026-12-01 00:00:00 |  |  |  |  |  |  |  | 10645.78817911768
2027-01-01 00:00:00 |  |  |  |  |  |  |  | 10645.78817911768
2027-02-01 00:00:00 |  |  |  |  |  |  |  | 10645.78817911768
2027-03-01 00:00:00 |  |  |  |  |  |  |  | 10965.16182449121
2027-04-01 00:00:00 |  |  |  |  |  |  |  | 10965.16182449121
2027-05-01 00:00:00 |  |  |  |  |  |  |  | 10965.16182449121
2027-06-01 00:00:00 |  |  |  |  |  |  |  | 10965.16182449121
2027-07-01 00:00:00 |  |  |  |  |  |  |  | 10965.16182449121
2027-08-01 00:00:00 |  |  |  |  |  |  |  | 10965.16182449121
2027-09-01 00:00:00 |  |  |  |  |  |  |  | 10965.16182449121
2027-10-01 00:00:00 |  |  |  |  |  |  |  | 10965.16182449121
2027-11-01 00:00:00 |  |  |  |  |  |  |  | 10965.16182449121
2027-12-01 00:00:00 |  |  |  |  |  |  |  | 10965.16182449121
2028-01-01 00:00:00 |  |  |  |  |  |  |  | 10965.16182449121
2028-02-01 00:00:00 |  |  |  |  |  |  |  | 10965.16182449121
2028-03-01 00:00:00 |  |  |  |  |  |  |  | 11294.11667922595
2028-04-01 00:00:00 |  |  |  |  |  |  |  | 11294.11667922595
2028-05-01 00:00:00 |  |  |  |  |  |  |  | 11294.11667922595
2028-06-01 00:00:00 |  |  |  |  |  |  |  | 11294.11667922595
2028-07-01 00:00:00 |  |  |  |  |  |  |  | 11294.11667922595
2028-08-01 00:00:00 |  |  |  |  |  |  |  | 11294.11667922595
2028-09-01 00:00:00 |  |  |  |  |  |  |  | 11294.11667922595
2028-10-01 00:00:00 |  |  |  |  |  |  |  | 11294.11667922595
2028-11-01 00:00:00 |  |  |  |  |  |  |  | 11294.11667922595
2028-12-01 00:00:00 |  |  |  |  |  |  |  | 11294.11667922595
2029-01-01 00:00:00 |  |  |  |  |  |  |  | 11294.11667922595
2029-02-01 00:00:00 |  |  |  |  |  |  |  | 11294.11667922595
2029-03-01 00:00:00 |  |  |  |  |  |  |  | 11632.94017960273
2029-04-01 00:00:00 |  |  |  |  |  |  |  | 11632.94017960273
2029-05-01 00:00:00 |  |  |  |  |  |  |  | 11632.94017960273
2029-06-01 00:00:00 |  |  |  |  |  |  |  | 11632.94017960273
2029-07-01 00:00:00 |  |  |  |  |  |  |  | 11632.94017960273
2029-08-01 00:00:00 |  |  |  |  |  |  |  | 11632.94017960273
2029-09-01 00:00:00 |  |  |  |  |  |  |  | 11632.94017960273
2029-10-01 00:00:00 |  |  |  |  |  |  |  | 11632.94017960273
2029-11-01 00:00:00 |  |  |  |  |  |  |  | 11632.94017960273
2029-12-01 00:00:00 |  |  |  |  |  |  |  | 11632.94017960273
2030-01-01 00:00:00 |  |  |  |  |  |  |  | 11632.94017960273
2030-02-01 00:00:00 |  |  |  |  |  |  |  | 11632.94017960273
2030-03-01 00:00:00 |  |  |  |  |  |  |  | 11981.92838499081
2030-04-01 00:00:00 |  |  |  |  |  |  |  | 11981.92838499081
2030-05-01 00:00:00 |  |  |  |  |  |  |  | 11981.92838499081
2030-06-01 00:00:00 |  |  |  |  |  |  |  | 11981.92838499081
2030-07-01 00:00:00 |  |  |  |  |  |  |  | 11981.92838499081
2030-08-01 00:00:00 |  |  |  |  |  |  |  | 11981.92838499081
2030-09-01 00:00:00 |  |  |  |  |  |  |  | 11981.92838499081
2030-10-01 00:00:00 |  |  |  |  |  |  |  | 11981.92838499081
2030-11-01 00:00:00 |  |  |  |  |  |  |  | 11981.92838499081
2030-12-01 00:00:00 |  |  |  |  |  |  |  | 11981.92838499081
2031-01-01 00:00:00 |  |  |  |  |  |  |  | 11981.92838499081
2031-02-01 00:00:00 |  |  |  |  |  |  |  | 11981.92838499081
2031-03-01 00:00:00 |  |  |  |  |  |  |  | 12341.38623654053
2031-04-01 00:00:00 |  |  |  |  |  |  |  | 12341.38623654053
2031-05-01 00:00:00 |  |  |  |  |  |  |  | 12341.38623654053
2031-06-01 00:00:00 |  |  |  |  |  |  |  | 12341.38623654053
2031-07-01 00:00:00 |  |  |  |  |  |  |  | 12341.38623654053
2031-08-01 00:00:00 |  |  |  |  |  |  |  | 12341.38623654053
2031-09-01 00:00:00 |  |  |  |  |  |  |  | 12341.38623654053
2031-10-01 00:00:00 |  |  |  |  |  |  |  | 12341.38623654053
2031-11-01 00:00:00 |  |  |  |  |  |  |  | 12341.38623654053
2031-12-01 00:00:00 |  |  |  |  |  |  |  | 12341.38623654053
2032-01-01 00:00:00 |  |  |  |  |  |  |  | 12341.38623654053
2032-02-01 00:00:00 |  |  |  |  |  |  |  | 12341.38623654053
2032-03-01 00:00:00 |  |  |  |  |  |  |  | 12711.62782363675
2032-04-01 00:00:00 |  |  |  |  |  |  |  | 12711.62782363675
2032-05-01 00:00:00 |  |  |  |  |  |  |  | 12711.62782363675
2032-06-01 00:00:00 |  |  |  |  |  |  |  | 12711.62782363675
2032-07-01 00:00:00 |  |  |  |  |  |  |  | 12711.62782363675
2032-08-01 00:00:00 |  |  |  |  |  |  |  | 12711.62782363675
2032-09-01 00:00:00 |  |  |  |  |  |  |  | 12711.62782363675
2032-10-01 00:00:00 |  |  |  |  |  |  |  | 12711.62782363675
2032-11-01 00:00:00 |  |  |  |  |  |  |  | 12711.62782363675
2032-12-01 00:00:00 |  |  |  |  |  |  |  | 12711.62782363675
2033-01-01 00:00:00 |  |  |  |  |  |  |  | 12711.62782363675
2033-02-01 00:00:00 |  |  |  |  |  |  |  | 12711.62782363675
2033-03-01 00:00:00 |  |  |  |  |  |  |  | 13092.97665834585
2033-04-01 00:00:00 |  |  |  |  |  |  |  | 13092.97665834585
2033-05-01 00:00:00 |  |  |  |  |  |  |  | 13092.97665834585
2033-06-01 00:00:00 |  |  |  |  |  |  |  | 13092.97665834585
2033-07-01 00:00:00 |  |  |  |  |  |  |  | 13092.97665834585
2033-08-01 00:00:00 |  |  |  |  |  |  |  | 13092.97665834585
2033-09-01 00:00:00 |  |  |  |  |  |  |  | 13092.97665834585
2033-10-01 00:00:00 |  |  |  |  |  |  |  | 13092.97665834585
2033-11-01 00:00:00 |  |  |  |  |  |  |  | 13092.97665834585
2033-12-01 00:00:00 |  |  |  |  |  |  |  | 13092.97665834585
2034-01-01 00:00:00 |  |  |  |  |  |  |  | 13092.97665834585
2034-02-01 00:00:00 |  |  |  |  |  |  |  | 13092.97665834585
2034-03-01 00:00:00 |  |  |  |  |  |  |  | 13485.76595809623
2034-04-01 00:00:00 |  |  |  |  |  |  |  | 13485.76595809623
2034-05-01 00:00:00 |  |  |  |  |  |  |  | 13485.76595809623
2034-06-01 00:00:00 |  |  |  |  |  |  |  | 13485.76595809623
2034-07-01 00:00:00 |  |  |  |  |  |  |  | 13485.76595809623
2034-08-01 00:00:00 |  |  |  |  |  |  |  | 13485.76595809623
2034-09-01 00:00:00 |  |  |  |  |  |  |  | 13485.76595809623
2034-10-01 00:00:00 |  |  |  |  |  |  |  | 13485.76595809623
2034-11-01 00:00:00 |  |  |  |  |  |  |  | 13485.76595809623
2034-12-01 00:00:00 |  |  |  |  |  |  |  | 13485.76595809623
2035-01-01 00:00:00 |  |  |  |  |  |  |  | 13485.76595809623
2035-02-01 00:00:00 |  |  |  |  |  |  |  | 13485.76595809623
2035-03-01 00:00:00 |  |  |  |  |  |  |  | 13890.33893683911
2035-04-01 00:00:00 |  |  |  |  |  |  |  | 13890.33893683911
2035-05-01 00:00:00 |  |  |  |  |  |  |  | 13890.33893683911
2035-06-01 00:00:00 |  |  |  |  |  |  |  | 13890.33893683911
2035-07-01 00:00:00 |  |  |  |  |  |  |  | 13890.33893683911
2035-08-01 00:00:00 |  |  |  |  |  |  |  | 13890.33893683911
2035-09-01 00:00:00 |  |  |  |  |  |  |  | 13890.33893683911
2035-10-01 00:00:00 |  |  |  |  |  |  |  | 13890.33893683911
2035-11-01 00:00:00 |  |  |  |  |  |  |  | 13890.33893683911
2035-12-01 00:00:00 |  |  |  |  |  |  |  | 13890.33893683911
2036-01-01 00:00:00 |  |  |  |  |  |  |  | 13890.33893683911
2036-02-01 00:00:00 |  |  |  |  |  |  |  | 13890.33893683911
2036-03-01 00:00:00 |  |  |  |  |  |  |  | 14307.04910494429
2036-04-01 00:00:00 |  |  |  |  |  |  |  | 14307.04910494429
2036-05-01 00:00:00 |  |  |  |  |  |  |  | 14307.04910494429
2036-06-01 00:00:00 |  |  |  |  |  |  |  | 14307.04910494429
2036-07-01 00:00:00 |  |  |  |  |  |  |  | 14307.04910494429
2036-08-01 00:00:00 |  |  |  |  |  |  |  | 14307.04910494429
2036-09-01 00:00:00 |  |  |  |  |  |  |  | 14307.04910494429
2036-10-01 00:00:00 |  |  |  |  |  |  |  | 14307.04910494429
2036-11-01 00:00:00 |  |  |  |  |  |  |  | 14307.04910494429
2036-12-01 00:00:00 |  |  |  |  |  |  |  | 14307.04910494429
2037-01-01 00:00:00 |  |  |  |  |  |  |  | 14307.04910494429
2037-02-01 00:00:00 |  |  |  |  |  |  |  | 14307.04910494429
2037-03-01 00:00:00 |  |  |  |  |  |  |  | 14736.26057809262
2037-04-01 00:00:00 |  |  |  |  |  |  |  | 14736.26057809262
2037-05-01 00:00:00 |  |  |  |  |  |  |  | 14736.26057809262
2037-06-01 00:00:00 |  |  |  |  |  |  |  | 14736.26057809262
2037-07-01 00:00:00 |  |  |  |  |  |  |  | 14736.26057809262
2037-08-01 00:00:00 |  |  |  |  |  |  |  | 14736.26057809262
2037-09-01 00:00:00 |  |  |  |  |  |  |  | 14736.26057809262
2037-10-01 00:00:00 |  |  |  |  |  |  |  | 14736.26057809262
2037-11-01 00:00:00 |  |  |  |  |  |  |  | 14736.26057809262
2037-12-01 00:00:00 |  |  |  |  |  |  |  | 14736.26057809262
2038-01-01 00:00:00 |  |  |  |  |  |  |  | 14736.26057809262
2038-02-01 00:00:00 |  |  |  |  |  |  |  | 14736.26057809262
2038-03-01 00:00:00 |  |  |  |  |  |  |  | 15178.34839543539
2038-04-01 00:00:00 |  |  |  |  |  |  |  | 15178.34839543539
2038-05-01 00:00:00 |  |  |  |  |  |  |  | 15178.34839543539
2038-06-01 00:00:00 |  |  |  |  |  |  |  | 15178.34839543539
2038-07-01 00:00:00 |  |  |  |  |  |  |  | 15178.34839543539
2038-08-01 00:00:00 |  |  |  |  |  |  |  | 15178.34839543539
2038-09-01 00:00:00 |  |  |  |  |  |  |  | 15178.34839543539
2038-10-01 00:00:00 |  |  |  |  |  |  |  | 15178.34839543539
2038-11-01 00:00:00 |  |  |  |  |  |  |  | 15178.34839543539
2038-12-01 00:00:00 |  |  |  |  |  |  |  | 15178.34839543539
2039-01-01 00:00:00 |  |  |  |  |  |  |  | 15178.34839543539
2039-02-01 00:00:00 |  |  |  |  |  |  |  | 15178.34839543539