(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.

Economist | 612-625-6760 | dnord@umn.edu | + posts

Dale is a major contributor to the design and development of the FINPACK farm software as well as the FINBIN Farm Financial Benchmarking Database.

Latest News
New and Improved: Financial Ratios in FINPACK

New and Improved: Financial Ratios in FINPACK

This post highlights the updated financial ratios in FINPACK. The ratio updates are based on the recent updates to the Farm Financial Standards Council's Financial Guidelines for Agriculture. The 2022 release of the Farm Financial Standards Council's (FFSC) Financial...

FINPACK News – November Digest

FINPACK News – November Digest

The FINPACK Lenders Conference is around the corner, the FINPACK 2022 update is live including new monthly Commercial Cash Flow capabilities, and the FINPACK team at the ABA Ag Bankers conference in Omaha! Register Now for the FINPACK Lenders Conference...

The New Monthly Commercial Cash Flow Capability of FINPACK

The New Monthly Commercial Cash Flow Capability of FINPACK

What's New in the Commercial Cash Flow Tool in FINPACK? The 2022 Fall Release of FINPACK adds the capability to complete annual OR monthly cash flow projections for commercial clients. These projections can be for a few months or multiple years. This replaces the...

What’s New in the 2022 FINPACK Update?

What’s New in the 2022 FINPACK Update?

The 2022 FINPACK update brings changes to Tax Forms, incorporates new Financial Standards Measures, introduces a new Cash Flow Projection into our commercial tools and more! Farm Financial Standards Update The FINAN Financial Analysis and FINFLO Cash Flow Projection...

FINPACK NEWS Digest – October 2022

FINPACK NEWS Digest – October 2022

FINPACK lenders conference registration is open, the updated Farm Financial Scorecard, lender training, and looking forward to the ABA Ag Bankers Conference Register for the FINPACK Lenders Conference The FINPACK Lenders Conference is back in-person! Join us...