Build the amortization schedule
loan_scheduleBuild one loan's schedule: opening balance, payment, interest, principal and closing per period, with total interest. The last period absorbs rounding, landing exactly on the balloon or zero. loans_report totals it.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| loan | Yes | The loan id, e.g. LOAN-2026-0001, or its exact name | |
| year | No | Only the periods falling in this calendar year, YYYY | |
| limit | No | Maximum rows, default and ceiling 600 | |
| from_period | No | First period to return. Default 1 |