(800) 234-1111

FINPACK News

FINPACK Long Range Planning

by Pauline Van Nurden | Feb 7, 2019

FINPACK Long Range Planning

As you work with agricultural customers this winter, do you find yourself running multiple cash flow scenarios?  Are some farms wanting to compare major changes to their operation with their current situation?  Are farm customers then looking to you for advice and feasibility of these plans?  Instead of running multiple cash flow projections based on different scenarios, use FINPACK’s Long Range Planning tool FINLRB.  The Long Range Planning tool (FINLRB) is available as one of the FINPACK Projection tools for agricultural files. This projection tool allows you to compare multiple alternatives for a farm or ranch operation at one time.

Why Long Range Planning?

Long range planning helps answer the “Where do I want to be?” question for farmers and ranchers.  This tool allows for analysis of the current operation alongside other potential scenarios that are being considered by the farm or ranch.  Each long-range scenario examines a typical year where the alternative is based on normal, average production and prices.  The comparison of all scenarios in the plan will give producers the information needed to assess the best future path for their operation.  Using long-range planning will help the farm or ranch determine which alternative best meets the future goals of their business and family. 

Long Range Planning Tool (FINLRB)

FINPACK’s Long Range Planning tool (FINLRB) will compare the long-range profitability, debt repayment capacity, and potential net worth gain of the alternative scenarios within the plan.  It allows comparing the financial strength of the current farming operation against alternative plans involving new enterprises; new resources; different sizes or combinations of current enterprises; changes in efficiency; or changes in debt structure. Scenarios are compared side by side, to help evaluate the relative strength and weakness of each. Continuing with the current operation is one alternative and is included as the base plan.  This base plan is always the first alternative.  Up to 15 alternative plans, plus the base plan, can be compared in one long range FINLRB plan. 

What data is needed?

Long range planning is based on the typical year, so average production levels and realistic long term prices should be used for each alternative.  Also, use consistent data between the alternatives of the plan.  Don’t bias one alternative with an overly optimistic production level or overly pessimistic prices. Additionally, make sure the alternatives being considered allow for analysis of a single change.  Don’t combine many changes into an alternative, without first considering the merit of each change alone.  And remember, using FINPACK’s long-range planning tool (FINLRB) is a future best guess.  Gather the best data possible, but don’t agonize over individual items.

A Long Range Plan requires a FINPACK Balance Sheet and Crop and Livestock Enterprise Budgets.  Within the budgets, labor hours, livestock death loss, and long-range feed prices are additional data points needed, as compared to a monthly type of cash flow projection using budgets. (The FINPACK Knowledge Base has a Labor Hour Estimate resource if needed.)

Summary

Long Range Planning helps consider the long term profitability, liquidity, repayment capacity, and solvency of different potential alternatives for a farm or ranch operation.   Use this FINPACK tool to evaluate the best path to meeting the operation’s long range goals.

Pauline Van Nurden joined the FINPACK Team as an Economist in 2017.

Prior to joining the FINPACK Team, she worked as a lender. This provides her valuable industry experience and knowledge in her work with FINPACK. Pauline holds a Master’s Degree in Agricultural Education and Bachelor’s Degree in Applied Economics, both from the University of Minnesota.

Latest News
FINPACK News March Digest

FINPACK News March Digest

FINPACK FAQs, Registration for FINPACK Lender Training, Consolidating Data Sources in FINPACK+, How to Import Data into FINPACK+ Credit Analysis Files, Unlocking Business Secrets wtih UCA Cash Flows and more!

Unlocking Business Secrets with UCA Cash Flows

Unlocking Business Secrets with UCA Cash Flows

In the commercial lending world, the uniform credit analysis (UCA) cash flow is a powerful tool allowing lenders to accurately determine sources and uses of cash for a business and determine the ability of a business to repay a loan. In this article, we will discuss UCA cash flows in FINPACK, how to use the UCA cash flow, and how to sleuth for discrepancies in the UCA cash flow.

How To Learn FINPACK

How To Learn FINPACK

FINPACK offers multiple training resources, including in-person, online and customized training options. FINPACK Lender Training Workshops offer two days of intensive, interactive training in-person on the University of Minnesota, St. Paul campus. Covering all the...

How to Import Data into FINPACK+ Credit Analysis Files

How to Import Data into FINPACK+ Credit Analysis Files

New data, from an external FINPACK Credit Analysis file can be imported into your institution’s
FINPACK+ Credit Analysis file for a customer. This feature allows you to add information, like
a balance sheet or cash flow projection, into an existing Credit Analysis file without overwriting the
remaining contents of the file.

Consolidating Data Sources in FINPACK+

Consolidating Data Sources in FINPACK+

FINPACK Credit Analysis allows users to consolidate the balance sheets or tax forms from several different data files into a consolidated file. For example, a farm or business may have multiple entities for tax reasons, but these entities are controlled by the same...