Lease Modeling Excel Template

A lease agreement is a contract between two parties, the lessor and the lessee. The lessor is the legal owner of the asset, the lessee obtains the right to use the asset in return for rental payments. This template provides basic modeling of lease including right of use assets and lease liability in financial forecast.

Lease Modeling Excel Template
, ,
, , , , , , , , ,

IAS 17 states that there are two types of lease, a finance lease and an operating lease. The definitions of these leases are vital and could be required when preparing an answer for the exam.

Finance lease

A finance lease is a lease that transfers substantially all the risks and rewards incidental to ownership of an asset to the lessee.

Operating lease

An operating lease is defined as any lease other than a finance lease.

Classification of a lease

In order to gain classification of the type of lease you are dealing with, you must first look at the information provided within the scenario and determine if the risks and rewards associated with owning the asset are with the lessee or the lessor. If the risks and rewards lie with the lessee then it is said to be a finance lease, if the lessee does not take on the risks and rewards, then the lease is said to be an operating lease.

Finance lease indicators

There are many risks and rewards outlined within the standard, but for the purpose of the Paper F7 exam there are several important areas. The main reward is where the lessee has the right to use the asset for most of, or all of, its useful economic life.

The primary risks are where the lessee pays to insure, maintain and repair the asset. When the risks and rewards remain with the lessee, the substance is such that even though the lessee is not the legal owner of the asset, the commercial reality is that they have acquired an asset with finance from the leasing company and, therefore, an asset and liability should be recognized.

You must log in to submit a review.