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.

ParameterTypeDescriptionExample
principalfloatThe amount borrowed. Defaults to 400,000.400,000
yearsfloatThe term of the loan in years. The rate stays the 30-year fixed mortgage rate for another term. Defaults to 30.30
payments_per_yearintThe number of payments per year. Defaults to 12.12
datestr | NoneThe date of the rate (YYYY-MM-DD). Defaults to None, the latest rate up to the end date."2025-03-31"
roundingint | NoneThe number of decimals to round the results to. Defaults to None, which uses the rounding of the class.2
show_columnsstr | list[str] | NoneThe 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
Share