(800) 234-1111

FINPACK News

How To Enter Finance Leases in FINPACK

by | Feb 4, 2022

Hot to enter finance leases in FINPACK

“When should a lease be recorded on the balance sheet?”  

“If a lease is included on the balance sheet,  how do you determine the asset value and loan balance?”

These are frequent questions as the use of leases for machinery, buildings, and other assets becomes more common.  Recent changes in accounting standards suggest that many leases are substitutes for purchasing assets and therefore should be listed on the balance sheet. 

The two types of finance leases

  1. Operating leases, which generally have a shorter life than the asset being leased, and
  2. Finance leases (sometimes called capital leases), which often span a substantial part of the life of the asset. In agriculture, land rental arrangements are the most common type of operating lease. While accounting standards suggest that some operating leases should be listed on the balance sheet, the Farm Financial Standards Council Guidelines recommend that land leases be treated as operating expenses rather than balance sheet assets. 

Our accounting friends give us no such break on finance leases.  A finance lease is often used as a direct substitute for purchasing and financing the asset with borrowed money.  Therefore, finance leases should be included on the Balance Sheet according to current accounting guidelines.  The major criteria for determining if a lease is a finance lease are:

  1. The lease transfers ownership of the property to the lessee at the end of the lease term, or
  2. The lessee has an option to purchase the asset that is reasonably certain to be executed, or
  3. The lease term covers the major part of the remaining economic life of the asset.

Refer to Appendix G of the Financial Guidelines for Agriculture for more information on finance lease criteria.

Once it is decided to place a leased asset[1] on the balance sheet, the question becomes how to value the lease and how to determine the lease liability. The asset value should be the present value of the stream of lease payments. The lease liability is determined by amortizing the lease at the stated interest rate.  If an interest rate is not stated in the contract, it is suggested that the current rate for traditional loans for similar assets types be used. Sounds complicated?  Fortunately, the FINPACK Loan Calculator can make it easy (or at least easier).

Example

This is the same example illustrated in the Farm Financial Standards Guidelines except we have converted it to January 1 payments for simplicity.

  • 5 annual payments of $11,991 with the first payment paid in advance;
  • Interest rate of 10%
  • Lease commences on January 1, 2022

Asset Valuation

Use the loan calculator to find the present value of the 4 remaining payments.

Loan calculator icon in FINPACK.

Payment details:

  • First payment date:       December 31, 2022
  • Payment frequency:      Annual
  • Loan Period:                4 years
  • Scheduled Payment      $11,991
  • Solve for the present value by clicking ‘=’ in the Amount Borrowed data entry.  The present value of the future payments is $38,009. 
FINPACK Loan Calculator Amortization

The final step is to add the initial payment.  The initial balance sheet value of the leased asset is $11,991 plus $38,009 = $50,000. 

FINPACK Balance Sheet Machinery Detail List

The recommendation is to amortize or depreciate this value using a straightline approach over the term of the lease.  The important thing is that the asset value should be zero at the end of the lease.

Lease Liability

The initial lease liability is the present value of the remaining payments, $38,009 from the previous loan calculator example. 

FINPACK Balance Sheet Intermediate Liabilities Data Entry

It may be helpful to print the Payment Schedule from the loan calculator to determine the principal, interest expense, and the principal balance after each lease payment. Alternatively, the loan calculator can be used each year to calculate the present value of the remaining payments.

FINPACK Loan Calculator Payment Schedule

Financial Analysis and Cash Flow

Once entered on the balance sheet, it is important not to double count the lease expense.  For finance leases, depreciation and interest are the only expenses related to the lease.  However, producers are very likely to erroneously include lease payments in operating expenses.  Financial lease payments are not expenses and should not be entered such as when completing a financial analysis (Schedule F Cash to Accrual or FINAN) or a cash flow projection.  Depreciation expense is calculated based on the change in the asset value.  Interest expense needs to be manually added if the producer’s records do not include this amount.  Interest expense can be taken from the repayment schedule or, if not available, the interest portion of the payment can be calculated based on the principal reduction.  For example, for year 1 of this example:

Total lease payment      –         Principal  payment        =          Interest expense

$11,991                        –         ($38,009 – $29,872)      =          $3,854

Note: More information regarding finance leases and other farm financial reporting recommendations can be found in The Financial Guidelines for Agriculture. This resource is maintained and published by the Farm Financial Standards Council and can be accessed at https://ffsc.org/.

This information is also found as a whitepaper in the FINPACK Knowledge Base..


[1] The Financial Guidelines for Agriculture uses the term “Right of Use Asset” for leased assets entered on the balance sheet.

Latest News
2022 FINPACK Lenders Conference

2022 FINPACK Lenders Conference

The 2022 FINPACK Lenders Conference will be held in-person in 2022. Conference Information Date: December 13-14, 2022Location: Radisson Blu Mall of America - Bloomington, MN Dr. David Kohl returns to the FINPACK Lenders Conference + a full lineup of speakers. We will...

FINPACK Digest – June 2022

FINPACK Digest – June 2022

Credit scorecards, the FINPACK advanced training survey, register now for Lender training, and The FINPACK digest is published every month and links to all the FINPACK News post published in the previous four weeks. Want notifications on FINPACK news posts sooner?...

Training & Events Update

Training & Events Update

October training for Lenders, Training for Educators and Professionals, and save the date for the 2022 FINPACK Lender's Conference FINPACK Training for Lenders in October Registration is open for the next FINPACK Lender training on October 11th and 12th on the...

How to Design and Use Credit Decision Scorecards

How to Design and Use Credit Decision Scorecards

Using Credit Decision Scorecards in your credit decisioning represents a convenient way to 'filter' loan applications. By applying some basic criteria, you can quickly decide if a credit request is straightforward and can be approved or denied as is, or if it needs...