Loan amortization schedule
calc_amortization_schedulePeriod-by-period schedule of a fixed-rate loan, monthly or quarterly: an optional interest-only period, then level payments on an amortization term that can run past maturity (balloon), with 30/360, actual/360, or actual/365 interest (the payment on a 30/360 basis). Rows are in cents that foot: interest is rounded each period, the final payment repays the whole balance, and the totals are the row sums. Deterministic: use this instead of doing the math yourself; cite formula calc.amortization_schedule@1 and the returned steps, and surface any warnings.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"principal": "<principal>",
"rate_annual": "<rate_annual>",
"term_months": "<term_months>",
"amortization_months": "<amortization_months>"
},
"name": "calc_amortization_schedule"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| day_count | No | Interest day count: "30/360" (each period is 30 days a month: interest = balance × rate ÷ periods a year), "actual/360" or "actual/365" (balance × rate × actual days in the period ÷ 360 or 365; needs start_date). Under actual day counts the level payment is still computed on a 30/360 basis, as US commercial loans usually are, so the balloon absorbs the difference. | 30/360 |
| principal | Yes | Loan amount funded, USD. | |
| start_date | No | Funding date, YYYY-MM-DD. Payment k falls k periods later on the same day of the month (clamped to month end); the first period runs from this date to the first payment date. Required for actual/360 and actual/365; optional for 30/360, where it only dates the rows. | |
| rate_annual | Yes | Fixed nominal annual interest rate as a decimal, e.g. 0.065 for 6.5%. | |
| term_months | Yes | Months from funding to maturity, when any remaining balance (the balloon) is repaid. | |
| payment_frequency | No | Payment period: monthly (12 a year) or quarterly (4 a year). Term, amortization, and interest-only months must be whole periods. | monthly |
| amortization_months | Yes | Amortization period in months that sets the level payment after any interest-only period, e.g. 360 for a 30-year schedule; 0 means interest-only to maturity. Must be at least term_months − interest_only_months (a shorter schedule would repay the loan before maturity). | |
| interest_only_months | No | Months of interest-only payments at the start of the loan; amortization over amortization_months begins after them. At most term_months. |