(800) 234-1111

FINPACK News

Cashflow Planning Resources

by Pauline Van Nurden | Aug 14, 2021

A hand drawn chart depicting the components of Cash Flow Planning

Cashflow Planning and creating projections for farm clients can be tedious.

How do I create the best cashflow planning for my farm clients?

What is a reasonable feed expense for dairy operations?

Is the projected cost of production on corn acres in line with peers? 

These are just a couple of the questions lenders and other professionals may ask when creating projections, especially for new customers.

The FINPACK Team and the Center for Farm Financial Management have put together some cash flow planning resources. Here are three aides FINPACK users may find useful in cash flow planning:

Minnesota Price and Cost Summary

FINPACK Livestock Budget Estimates

FINPACK Labor Hour Estimates  

These items and more are found in the FINPACK Knowledge Base.

Minnesota Price and Cost Summary

This document includes prices received last year and over the last three years for major crop and livestock enterprises.  Also included is the cost of production for each commodity last year and over the last three years.  These prices and costs are suggested as guides for planning based on historical costs and returns for Minnesota farms* included in the FINBIN Farm Financial Database.

FINPACK Livestock Budget Estimates

These budgets are intended to provide guidelines for developing FINPACK livestock plans.  They are based on actual costs and returns of Minnesota farm producers* included in the FINBIN Farm Financial database in 2020.  If available, farms are sorted into low/medium/high profit groups to show the range of results.  The revenues included in these budgets are based on actual revenues for 2020.  Be sure to consider any needed adjustments for future prices.

FINPACK Labor Hour Estimates

Labor hours in the budgets are used in FINPACK for long-range planning (FINLRB) and for monthly cash flow projections with budgets (FINFLO).  Labor hours are used in long-range planning (FINLRB) to compare the labor requirements of alternative plans.  Monthly cash flow projections with budgets (FINFLO) use labor hours with the cost of production calculations.  Here, labor hours from the budgets are used as the default for allocating related operating expenses to the particular crop and livestock enterprises in the plan.  This approach streamlines data entry in the FINFLO plan.

Summary

These resources can help with cashflow planning in FINPACK. FINBIN was utilized to prepare these resources and can be used to look at other crop or livestock enterprises as needed for cash flow planning. These and other timely resources are found in the FINPACK Knowledge Base.

* Farms included in both of these tools participate in the MN State Farm Business Management program or the University of Minnesota's Southwest Minnesota Farm Business Management Association.  No attempt was made to predict future costs or prices; these are actual costs and returns reported for 2020 for these farms.

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
How to Determine Schedule F Income in FINPACK

How to Determine Schedule F Income in FINPACK

Today’s post focuses on Schedule F income utilized in the Schedule F Cash to Accrual tool. This FINPACK tool takes cash income from Schedule F, along with beginning and ending balance sheets, to arrive at accrual adjusted income for the year.

Latest FINPACK Update Available Now

Latest FINPACK Update Available Now

The latest FINPACK update is version 6.4.8.219. The update will be applied automatically for FINPACK+ users. For users of FINPACK installed, you’ll need to update via the HELP menu inside FINPACK. Launch FINPACK and select Software Updates under the HELP menu. Click ‘Check for Updates’, then follow the steps to install.

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.