Full Amortization Schedule Generator
generate_amortization_scheduleGenerates the complete period-by-period amortization schedule for a commercial equipment lease or finance agreement: payment date, payment amount, interest portion, principal portion, and remaining balance for every period, plus totals. Supports all payment structures (level, balloon, step, skip/seasonal, interest-only) and both 30/360 and Actual/365 day counts. Use when the user needs the full payment schedule, a payoff balance at a specific period, or interest/principal splits for accounting.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| steps | No | For Step/Custom structures: ordered payment segments | |
| taxRate | No | Sales tax rate percentage, e.g. 7 | |
| leaseTerm | Yes | Lease term in months, e.g. 60 | |
| taxMethod | No | Sales tax treatment: 'Exempt' (default), 'Monthly' on top of payment, or 'Upfront' capitalized | |
| skipMonths | No | For Skip: calendar months (1=Jan..12=Dec) skipped every year of the term, e.g. [12,1,2] for a seasonal business closed in winter | |
| downPayment | No | Down payment in dollars | |
| fundingDate | No | Funding date YYYY-MM-DD; a gap before leaseStartDate produces interim rent | |
| interestRate | Yes | Annual interest rate as a percentage, e.g. 7.5 for 7.5% | |
| equipmentCost | Yes | Total equipment cost in dollars, e.g. 150000 | |
| paymentTiming | No | 'Arrears' = end of period (default), 'Advance' = beginning of period | |
| residualValue | No | End-of-term residual in dollars (default 0 = full payout). Alternative: residualPercent | |
| leaseStartDate | No | First payment date YYYY-MM-DD (defaults to today) | |
| residualPercent | No | Residual as a percent of equipment cost, e.g. 10 for 10% FMV | |
| upfrontPayments | No | Number of payments collected in advance at signing | |
| interestOnlyTerm | No | For InterestOnly: number of interest-only months before amortization begins | |
| paymentFrequency | No | Payment frequency (default 'Monthly') | |
| paymentStructure | No | Payment structure (default 'Level') | |
| balloonPercentage | No | For Balloon: final payment as percent of equipment cost, e.g. 20 | |
| skipPaymentAmount | No | Amount paid during skipped months (often 0) | |
| additionalClosingFees | No | Documentation/closing fees in dollars |