IFRS 16 Lease Calculator for SMEs

Lease schedules are usually rebuilt in a spreadsheet every year: a present value formula, a hand-made amortisation table and a current portion that nobody can reproduce. This app takes each lease once and shows the working, so the figures can be explained to your accountant or auditor.

What is inside

• A leases register: commencement date, term in months, payment per period (monthly, quarterly, every 6 months or yearly), in advance or arrears, yearly increase, rent-free months, your incremental borrowing rate, initial direct costs, prepaid payments, incentives and a restoration provision.
• Your choice of how the rate is quoted: an effective annual rate converted to a monthly rate, or a nominal rate divided by 12.
• The liability as the present value of the payments, the right-of-use asset, and a month-by-month schedule with interest rounded each month and the last month balancing the liability to exactly nil.
• Straight line depreciation of the asset, commencement and month journals that balance, and the split of the liability into current and non-current at the reporting date.
• A portfolio position page for all leases that prints on A4, with the last 12 months of interest, depreciation and cash.
• Short-term and low-value leases flagged and expensed straight line.
• A Checks tab, CSV exports, example data, JSON backup and a README with a worked example.

What is fact and what is a setting The arithmetic is standard present value and effective interest. The lease term, the rate, which payments are included and the exemptions are accounting judgements, not defaults of the app. How corporate tax treats lease payments is a separate question to verify with the FTA or your tax adviser.

What it is NOT It is a working calculator, not an audit tool. It does not decide whether a contract is a lease and does not handle modifications, variable or index-linked payments, foreign currency, sub-leases or sale and leaseback. The restoration provision is not unwound. Verify the treatment with your accountant or auditor.

How it was checked Every figure and every month of the selected schedule were compared with an independent Python calculation at 80 digits over 44 random portfolios (182 leases), with no difference. Typed screens, CSV, exports, reload, print view and phone width were tested in Chromium. Not tested in Safari, Firefox or Edge, or with a real lease contract. Single business use.