Lease Amortization Schedule Calculator
Generate FASB-compliant lease amortization schedules with precise principal, interest, and tax breakdowns. Includes Capitalized Cost Reduction handling and CSV export.
| Month | Depreciation (Prin) | Rent (Int) | Tax | Total Payment | Remaining Bal |
|---|
About
Automotive leases often obscure the true cost of financing under terms like "Money Factor" or "Rent Charge." Financial transparency requires breaking down the monthly remittance into its constituent parts: depreciation (principal), finance charges (interest), and taxes. This utility constructs a full amortization table for the lease term. It handles Capitalized Cost Reduction - down payments or trade-ins - by adjusting the Net Capitalized Cost before the rent charge calculation begins. This distinction is critical for accounting accuracy under standards that require separating the return of capital from the cost of capital.
Formulas
The monthly lease payment calculation relies on two distinct charges: depreciation and rent. The formulas use the Net Capitalized Cost (Cnet) and Residual Value (Vres).
Monthly Depreciation:
Cnet − VresNMonthly Rent Charge:
(Cnet + Vres) × MFUnlike a standard loan where interest is calculated on the declining balance, a standard car lease calculates the rent charge on the sum of the adjusted capitalized cost and the residual value, effectively charging interest on the depreciation and the holdback value simultaneously.
Reference Data
| Term Component | Variable | Standard Definition | Mathematical Role |
|---|---|---|---|
| Net Capitalized Cost | Cnet | Agreed value minus reduction | Principal basis |
| Residual Value | Vres | Value at lease end | Balloon payment |
| Money Factor | MF | APR ÷ 2400 | Interest rate |
| Depreciation | D | Monthly principal loss | Linear reduction |
| Rent Charge | R | Monthly finance fee | Interest cost |