Corality Financial Group hosts seminar at the Frankfurt School of Finance & Management
A Finance Lease or Capital Lease is often incorrectly disclosed and treated in the financial statements. This tutorial will focus on how to practically incorporate the principles of accounting for finance leases in the financial statement of the lessee.
As covered recently in our ‘Path of Lease Resistance’ post, the International Accounting Standards Board (IASB) and Financial Accounting Standards Board (FASB) of the United States recently published for public comment a proposal to change the way that leases are accounted for. Under the proposal, a ‘right-of-use’ approach will be adopted for lease accounting.
In over 100 countries that govern accounting using International Financial Reporting Standards, the controlling standard is IAS 17 “Leases”. Based on IAS 17, the following principles should be applied in the financial statements of lessees
To see how these changes may impact your project or company, this tutorial will show you how to incorporate the above principles into your financial model. Download our Excel workbook and read this tutorial for a step-by-step approach on this topic.
Most leases will be recognised as assets and liabilities on the balance sheet, which is similar to the present treatment of finance leases or capital leases.
The first step in financial modelling is to build a user-friendly and flexible input section. Refer to Screenshot 1 for the layout of assumptions for the finance lease used in our sample worksheet.
Screenshot 1: Assumptions for Finance Lease
Calculate finance lease payments
As indicated earlier, finance lease payments should be apportioned between the finance charge (interest portion) and the reduction of the outstanding liability (principal portion). The interest portion will be expensed while the principal portion will reduce the lease obligation in the balance sheet over the lease term.
Finance lease payments can be calculated in a similar way to an annuity (credit foncier) repayment of your debt facility. Refer to Screenshot 2 for lease payment calculation in this example.
Screenshot 2: Calculate Finance Lease payments
Calculate the executory expenses
The calculation of these costs is relatively simple and is treated in a similar manner to the operating costs. Refer to Screenshot 3.
Screenshot 3: Calculate the executory expenses
Calculate the depreciation
To calculate depreciation, refer to our previous tutorial ‘Straight line depreciation with reverse ticker’.
Learn how to build a full set of integrated financial statements, and how to balance and check the balance sheet in the Project Finance Modelling B course.
Journal entries
The journal entries for finance lease are depicted below
To record the leased asset and leased liability at the inception of the lease term
Dr Leased Asset
Cr Leased Liability
To record the lease depreciation charge at the end of each period during the life of asset
Dr Depreciation Charge
Cr Accumulated Depreciation
To record the finance lease payments during the lease term
Dr Leased Liability
Dr Interest Expense
Cr Cash
To record the executory expenses during the lease term
Dr Executory Expenses
Cr Cash
Financial statement
How will the financial statements look after incorporating the above journal entries? The screenshots below show extracts of the financial statements, highlighting the journal entries of the finance leases for the Balance Sheet, Profit and Loss and Cashflow Waterfall.
Screenshot 4: Balance Sheet
Screenshot 5: Profit & Loss
Screenshot 6: Cashflow Waterfall
See All Resources Get the latest Project Finance Tutorials and Blog Posts...
You will go into the draw to WIN a FREE training course.
Instantly unsubscribe at any time. We value your privacy.
We provide leading project finance professionals with in-house and public training in Asia, Australia, US, Canada, the Middle East and South Africa.

The new model is easy to navigate, analyse and present, Lynas has received positive feedback on the financial model from potential debt and equity participants. The professional presentation and functionality of the model has made our financing process smoother.Lynas Corporation