Amortization Schedule
Calculates the amortization schedule of a new 30-year fixed-rate mortgage at the US mortgage rate of a date: per monthly payment the part that is interest, the part that repays the loan and the balance left. Early payments are mostly interest, the more so the higher the rate: the first payment of a 400,000 US dollar loan at 7.18% is 2,393.33 of interest and 316.41 of repayment.
The formula is as follows:
\[\operatorname{Interest}(k) = \operatorname{Balance}(k - 1) \cdot r\] \[\operatorname{Principal}(k) = \text{Payment} - \operatorname{Interest}(k)\] \[\operatorname{Balance}(k) = \operatorname{Balance}(k - 1) - \operatorname{Principal}(k),\;\; \text{with Balance} (0) = L\]Where L is the principal, r = Rate / payments per year the rate per payment and Payment the annuity payment of get_loan_payment. US mortgage rates are quoted as a nominal annual rate compounded monthly. The rate is the weekly average 30-year fixed rate of Freddie Mac’s Primary Mortgage Market Survey on the date (the last survey on or before it), from FRED when a FRED API key is set and from Freddie Mac otherwise. For a rate of your own, use loan_model.get_amortization_schedule.
Also known as: amortization table, mortgage schedule, repayment schedule, interest and principal per payment, remaining balance.
Amortization Schedule in Python or via the MCP
Install the Finance Toolkit with:
pip install financetoolkit -U
Then call get_amortization_schedule as shown below.
from financetoolkit import FixedIncome
fixedincome = FixedIncome(start_date='2026-01-01', end_date='2026-11-06')
fixedincome.get_amortization_schedule().iloc[[0, 1, 2, 119, 239, 359]]
Or, after setting up the Finance Toolkit MCP, ask:
How does a 400,000 dollar 30-year US mortgage at the latest mortgage rate split each payment into interest and principal?
Which returns:
| Payment Number | Rate | Payment | Interest | Principal | Balance |
|---|---|---|---|---|---|
| 1 | 0.0718 | 2709.7393 | 2393.3333 | 316.4060 | 399683.5940 |
| 2 | 0.0718 | 2709.7393 | 2391.4402 | 318.2992 | 399365.2948 |
| 3 | 0.0718 | 2709.7393 | 2389.5357 | 320.2036 | 399045.0912 |
| 120 | 0.0718 | 2709.7393 | 2066.2399 | 643.4995 | 344689.0688 |
| 240 | 0.0718 | 2709.7393 | 1393.1739 | 1316.5655 | 231525.8632 |
| 360 | 0.0718 | 2709.7393 | 16.1168 | 2693.6225 | 0.0000 |
Parameters
get_amortization_schedule accepts the following parameters.
| Parameter | Type | Description | Example |
|---|---|---|---|
principal | float | The amount borrowed. Defaults to 400,000. | 400,000 |
years | float | The term of the loan in years. The rate stays the 30-year fixed mortgage rate for another term. Defaults to 30. | 30 |
payments_per_year | int | The number of payments per year. Defaults to 12. | 12 |
date | str | None | The date of the rate (YYYY-MM-DD). Defaults to None, the latest rate up to the end date. | "2025-03-31" |
rounding | int | None | The number of decimals to round the results to. Defaults to None, which uses the rounding of the class. | 2 |
show_columns | str | list[str] | None | The columns to keep, a name or a list of names, matched on every column level, or the rows when no column has those names (such as the line items of a financial statement). Names that do not exist are logged, and when none exist the result is returned in full. Defaults to None, which keeps every column. | None, which keeps every column |