Amortization Schedule
The amortization schedule shows how your lease liability and ROU Asset change over the lease term.
Column Definitions
Understanding each column:
| Column | Description |
|---|---|
| Period | Sequential number starting at Period 1 (lease commencement). A Period 0 row appears only when a payment is due on the commencement date: it discloses the FRS 102.20.46 step from gross to net initial liability and accrues no interest. |
| Payment | Cash paid to lessor |
| Opening Liability | Balance at start of period |
| Interest Expense | Opening × periodic rate |
| Principal Reduction | Payment - Interest |
| Closing Liability | Opening + Interest - Payment |
| Depreciation | Monthly asset depreciation |
Sample Schedule
First 3 periods:
Amortization Extract
Very long leases and the schedule length cap
Lease terms up to about 1,010 years are supported. For long leases the per-period schedule is capped at the first 1,200 monthly periods (about 100 years). This cap applies to the on-screen schedule and to the CSV and Excel exports alike, so exporting does not return rows beyond 1,200. Beyond that point the schedule is truncated at the materiality horizon (FRS 102.2.18) with an on-screen banner, because the present value of payments that far out is immaterial at the lease discount rate. The truncation is display only: the lease liability and all balance sheet and disclosure figures are still calculated over the full contractual term, so the reported numbers remain correct. Example: a 165-year monthly lease has 1,980 periods; the schedule and export list the first 1,200 while the figures reflect all 1,980.
Generate your amortization schedule
See a complete month-by-month breakdown of your lease.