Rent Collection Spreadsheet

- 02.44

Free Rent Tracker Spreadsheet Templates | Laobingkaisuo for Rent ...
photo src: achla.co

A finance lease (also known as a capital lease) is a type of lease in which a finance company is typically the legal owner of the asset for the duration of the lease, while the lessee not only has operating control over the asset, but also has a substantial share of the economic risks and returns from the change in the valuation of the underlying asset.

More specifically, it is a commercial arrangement where:

  • the lessee (customer or borrower) will select an asset (equipment, vehicle, software);
  • the lessor (finance company) will purchase that asset;
  • the lessee will have use of that asset during the lease;
  • the lessee will pay a series of rentals or installments for the use of that asset;
  • the lessor will recover a large part or all of the cost of the asset plus earn interest from the rentals paid by the lessee;
  • the lessee has the option to acquire ownership of the asset (e.g. paying the last rental, or bargain option purchase price);

A finance lease has similar financial characteristics to hire purchase agreements and closed-end leasing as the usual outcome is that the lessee will become the owner of the asset at the end of the lease, but has different accounting treatments and tax implications. There may be tax benefits for the lessee to lease an asset rather than purchase it and this may be the motivation to obtain a finance lease.


rent collection spreadsheet template | LAOBINGKAISUO.COM
photo src: laobingkaisuo.com


Maps, Directions, and Place Reviews



Impact on accounting

  • Since a finance lease is capitalized, both assets and liabilities in the balance sheet increase. As a consequence, working capital decreases, but the debt/equity ratio increases, creating additional leverage.
  • Finance lease expenses are allocated between interest expense and principal value much like a bond or loan; therefore, in a statement of cash flows, part of the lease payments are reported under operating cash flow but part under financing cash flow. Therefore, operating cash flow increases.
  • Under operating lease conditions, lease obligations are not recognized; therefore, leverage ratios are understated and ratios of return (ROE and ROA) are overstated.

The key IFRS criterion is:

If "substantially all the risks and rewards" of ownership are transferred to the lessee then it is a finance lease. If it is not a finance lease then it is an operating lease. The transfer of risk to the lessee may be shown by lease terms such as an option for the lessee to buy the asset at a low price (typically the residual value) at the end of the lease. The nature of the asset (whether it is likely to be used by anyone other than the lessee), the length of the lease term (whether it covers most of the useful life of the asset), and the present value of lease payments (whether they cover the cost of the asset) may also be factors.

IFRS does not provide a rigid set of rules for classifying leases and there will always be borderline cases. It is also still sometimes possible to use leases to make balance sheets look better, provided that the lessee can justify treating them as operating leases.

The classification of large transactions, such as sale and leasebacks of property, may have a significant effect on the accounts and on measures of financial stability such as gearing. However, it is worth remembering that an improvement in financial gearing may be offset by a worsening of operational gearing and vice versa.


Rent Collection Spreadsheet Video



Accounting treatment by country

International Financial Reporting Standards (IFRS)

In the over 100 countries that govern accounting using International Financial Reporting Standards, the controlling standard is IAS 17, "Leases". However, it is currently being phased out, to be replaced with IFRS 16, "Leases" for reporting periods from 2019. While IAS 17 is similar in many respects to FAS 13 in the U.S., IAS 17 avoids the "bright line" tests (specifying an exact percentage as a limit) on the lease term and present value of the rents. Instead, IAS 17 has the following five tests. If any of these tests are met, the lease is considered a finance lease:

  • ownership of the asset is transferred to the lessee at the end of the lease term;
  • the lease contains a bargain purchase option to buy the equipment at less than fair market value;
  • the lease term is for the major part of the economic life of the asset even if title is not transferred;
  • at the inception of the lease the present value of the minimum lease payments amounts to at least substantially all of the fair value of the leased asset.
  • the leased assets are of a specialised nature such that only the lessee can use them without major modifications being made.

IAS 17 is now transitioning to IFRS 16, as a joint project with the U.S. lease accounting standard. The standard was published in 2016, with companies required to have implemented it by 2019 or earlier. The criteria for being classified as a finance lease are similar to the above, but judgement is required - simply meeting one requirement may not be enough.

Australia

In Australia the accounting standard pertaining to lease is AASB 117 'Leases'. AASB 117 was released in July 2004. AASB 117 'Leases' applies to accounting for leases other than: (a) leases to explore for or use minerals, oil, natural gas and similar non-regenerative resources; and (b) licensing agreements for such items as motion picture films, video recordings, plays, manuscripts, patents and copyrights.

According to AASB 117, paragraph 4, a lease is: an agreement whereby the lessor conveys to the lessee in return for a payment or series of payments the right to use an asset for an agreed period of time.

A lease is classified as a finance lease if it "transfers substantially all the risks and rewards incidental to ownership of an asset." (AASB 117, p8) There are no strict guidelines as to what constitutes a finance lease, however guidelines are provided within the standard.

India

Finance lease is one in which risk and rewards incidental to the ownership of the leased asset are transferred to lessee but not the actual ownership. Thus in case of finance lease we can say that notional ownership is passed to the lessee. The amount paid as interest during lease period is shown in P/l DR side of lessee

Features:

  • it's not cancel-able
  • the lessor may or may not bear the cost of insurance, repair, maintenance etc. Usually the lessee has to bear all cost.
  • the lessor may transfer ownership of the asset to the lessee by the end of the lease term
  • the lessee has an option to purchase the asset at a price which is expected to be sufficiently lower than the value at the end of the lease period

United States

Under US accounting standards, a finance (capital) lease is a lease which meets at least one of the following criteria:

  • ownership of the asset is transferred to the lessee at the end of the lease term;
  • the lease contains a bargain purchase option to buy the equipment at less than fair market value;
  • the lease term equals or exceeds 75% of the asset's estimated useful life;
  • the present value of the lease payments equals or exceeds 90% of the total original cost of the equipment.

Following the GAAP accounting point of view, such a lease is classified as essentially equivalent to a purchase by the lessee and is capitalized on the lessee's balance sheet. See Statement of Financial Accounting Standards No. 13 (FAS 13) for more details of classification and accounting.

Special Case: Finance Leases under UCC Article 2A

The term sometimes means a special case of lease defined by Article 2A of the Uniform Commercial Code (specifically, Sec. 2A-103(1) (g)). Such a finance lease recognizes that some lessors are financial institutions or other business organizations that lease the goods in question purely as a financial accommodation and do not want to have the warranty and other entanglements that are usually associated with leases by companies that are manufacturers or merchants of such goods. Under a UCC 2A finance lease, the lessee pays the payments to the lessor (and indeed must do so, regardless of any defect in the leased goods - this obligation usually being contained in a "hell or high water" clause), but any claims related to defects in the leased goods may be brought only against the actual supplier of the goods. UCC 2A finance leases are usually easy to identify because they commonly contain a clause specifically declaring that the lease is to be considered a finance lease under UCC 2A.


Source of the article : Wikipedia



EmoticonEmoticon

 

Start typing and press Enter to search