(800) 234-1111

FINPACK News

Treatment of Breeding Livestock in FINPACK’s Earned Net Worth Analysis

by | Jul 26, 2021

The purpose of Earned Net Worth Analysis is to back out Change in Market Valuation from total market value net worth change to arrive at the amount of net worth change resulting from earnings. The FINPACK approach is to estimate economic depreciation on each asset category. Any change greater or less than the amount explained by depreciation is Change in Market Valuation. Once Earned Net Worth Change is calculated, it is used to evaluate repayment capacity based on the Term Debt Coverage Ratio.

Below is the detail input form FINPACK uses to estimate Change in Market Valuation. For example, after depreciation, the ending value of Machinery and Equipment should be $677,920. However, machinery was valued at $709,966 on the ending balance sheet. The difference of $32,046 is Change in Market Valuation and will be backed out to arrive at Earned Net Worth Change.

Change in Market Valuation

Breeding Livestock Issues

This approach works well for depreciable assets like machinery and buildings. Breeding livestock, however, are another animal (pun intended). Often breeding livestock are raised and are therefore not depreciable. More importantly, a change in the value of breeding livestock may be due to a change in the number of head rather than a valuation change. For this reason, FINPACK treats any change in breeding livestock value (as well as other intermediate and other long term assets) as Inventory Change rather than Change in Market Valuation. Even though this example shows Change in Market Valuation for breeding livestock on the detail input form, that amount is not included in the amount backed out to calculate Earned Net Worth Change (see main input form below). In other words, any change in the value of these assets is treated as Earned Net Worth Change rather than Change in Market Valuation.

Inventory change

Summary

Breeding livestock pose specific challenges when analyzing agricultural credits. FINPACK’s Earned Net Worth Analysis treats changes in breeding livestock value as Inventory Change, which is included in the earned net worth change for the farm. See the FINPACK Knowledge Base for more helpful guides related to FINPACK Credit Analysis tools.

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