================================================================================================
  LOAN AMORTIZATION SCHEDULE
  Didactic Python code · Kardex Tauro · kardex-tauro.muisca.co
================================================================================================
Loan amount: 12,000,000.00
Nominal annual rate: 18.00 %
Monthly rate (annual / 12): 1.50 %
Term: 12 months
Disbursement date: 2026-04-01
Fixed payment (French system): 1,100,159.91
Note: the rate is nominal annual and is divided by 12 to get the monthly rate.

MONTH-BY-MONTH AMORTIZATION SCHEDULE
------------------------------------------------------------------------------------------------
No.  Date        Opening balance         Payment        Interest       Principal Closing balance
------------------------------------------------------------------------------------------------
1    2026-05-01    12,000,000.00    1,100,159.91      180,000.00      920,159.91   11,079,840.09
2    2026-06-01    11,079,840.09    1,100,159.91      166,197.60      933,962.31   10,145,877.78
3    2026-07-01    10,145,877.78    1,100,159.91      152,188.17      947,971.74    9,197,906.04
4    2026-08-01     9,197,906.04    1,100,159.91      137,968.59      962,191.32    8,235,714.72
5    2026-09-01     8,235,714.72    1,100,159.91      123,535.72      976,624.19    7,259,090.53
6    2026-10-01     7,259,090.53    1,100,159.91      108,886.36      991,273.55    6,267,816.98
7    2026-11-01     6,267,816.98    1,100,159.91       94,017.25    1,006,142.66    5,261,674.32
8    2026-12-01     5,261,674.32    1,100,159.91       78,925.11    1,021,234.80    4,240,439.52
9    2027-01-01     4,240,439.52    1,100,159.91       63,606.59    1,036,553.32    3,203,886.20
10   2027-02-01     3,203,886.20    1,100,159.91       48,058.29    1,052,101.62    2,151,784.58
11   2027-03-01     2,151,784.58    1,100,159.91       32,276.77    1,067,883.14    1,083,901.44
12   2027-04-01     1,083,901.44    1,100,159.96       16,258.52    1,083,901.44            0.00
------------------------------------------------------------------------------------------------

================================================================================================
LOAN SUMMARY
================================================================================================
  Total paid     : 13,201,918.97
  Total interest : 1,201,918.97
  Total principal: 12,000,000.00
  Last instalment: 1,100,159.96

  Note: the last payment differs because it absorbs the rounding cents.

  Sum of principal = amount: TIES
  Closing balance = 0.00: TIES

File written: salida/amortizacion.csv
