Recent FINPACK Update Features

New FINPACK Features 2019

By:  Kevin Hamilton and Taylor Engquist

FINPACK version 5.10.6 was recently released. New features included in the update are the ability to import or export balance sheet details and a financial scorecard addition to cash flow projections (FINFLO). These features have been added at the request of our users and we hope will be useful to all. Let’s take a closer look at these new features.

[Read more…]

Minnesota Farm Income Hits Historic Low

After adjusting for inflation, Minnesota farms earned the lowest median farm income in the past 23 years of data tracked by University of Minnesota Extension and Agricultural Centers of Excellence within Minnesota State.  

In 2018, the reported median net income was $26,055, down 8 percent from the previous year. Farmers in the lowest 20 percent reported losing nearly $72,000. The analysis examined data from 2,209 participants in farm business management programs, as well as 101 members of the Southwest Minnesota Farm Business Management Association.  This is a collaborative project with the FINPACK Team and the Center for Farm Financial Management (CFFM).

[Read more…]

2019 National School for Beginning Ag Bankers

The FINPACK Team wants to alert you to an outstanding educational opportunity – the 2019 National School for Beginning Ag Bankers, being held June 24 – 27 at Black Hills State University in Spearfish, SD. CFFM has had a long relationship with this school, our staff is integral members of the teaching team, along with a talented group of seasoned ag bankers.  This school is an intensive program designed to train in all facets of agricultural lending with an emphasis on credit analysis, credit score, risk rating, problem loans, and group case study.

[Read more…]

Handling Trades on the Balance Sheet – Revisited

Trading machinery and equipment is common for all types of businesses.  FINPACK allows for streamlined data entry of capital purchases, sales, and trades within its different tools.  By entering extra detail on the FINPACK balance sheet, the details of these capital transactions can be brought into other FINPACK analysis tools, like Schedule F Cash to Accrual, Earned Net Worth Analysis, or Financial Analysis (FINAN).

[Read more…]

The Credit Renewal Process

The Credit Renewal Process - FINPACK‘Tis the season for credit renewals.  FINPACK has several tools to assist lenders with this process, from spreading, to financial analysis, projection preparation, and pulling the pieces of the credit analysis together.

In general, within FINPACK, the recommendation is to work down the left side file navigation to complete the credit renewal and analysis process.  Start with data sources, move to financial analysis, complete cash flow projections, and then pull everything together with the credit analysis tools.  With that being said, here is a bit more background on these tools and how they aid the credit renewal process. [Read more…]

FINPACK Annual Update – What’s New?

The annual FINPACK update was released in November and there are several new features to be aware of as you use FINPACK for the upcoming renewal season.

Each year the FINPACK Team takes suggestions and requests from our users to enhance the software. Therefore, feel free to pass along constructive feedback! This year’s update includes:

[Read more…]

Spreadsheets vs. Software

Spreadsheets vs Software in Credit AnalysisAre you still using spreadsheets to complete the annual credit analysis on your customers?  Do your spreadsheets provide you the best information on a customer’s financial position?  Have your spreadsheets left you with questions related to your bank’s true risk?  If so, FINPACK Credit Analysis Solutions software is the tool you’ve been looking for! [Read more…]

How to Use the FINPACK Loan Calculator

How to use FINPACK Loan CalculatorThe FINPACK Loan Calculator is a useful tool as you enter or edit loan payment information into a Balance Sheet, Cash Flow Projection, Long Range Plan, or Financial Analysis in FINPACK.  The loan payment details from the Loan Calculator can be pasted into data entry, or it can also be used as a freestanding tool to brainstorm possible loan payment options.  When using the calculator in freestanding mode, the information cannot be pasted into FINPACK.  Here the only option is to View Payment Schedule and print or export the schedule.

There are two types of repayment options in the FINPACK Loan Calculator – amortized payments or fixed-principal payments.  The type of loan being modeled will dictate the specific calculator chosen.  [Read more…]

Top 5 Cash Discrepancy Culprits

Top 5 Reasons for Cash DiscrepanciesThere are always tricky situations that leave you scratching your head on how to get a customer’s year-end analysis balanced when it comes to cash in and cash out.  Whether you are using the Schedule F Cash to Accrual Analysis or the Financial Analysis (FINAN) there are some common culprits to track down cash discrepancies in these tools.
[Read more…]

Farm Incomes Take Another Dip in 2017

Farm Income Takes a Dip in 2017

Minnesota farmers experienced their fifth consecutive year of low profitability in 2017. The median farm earned $28,551, down slightly from just over $36,000 in 2016.  Declines in farm income were largely driven by low profits and losses for cash crop farms, while livestock farms, in general, had a better year.  With average investment of over $2 million, farms earned a 2.2% return on investment. Across all farm types, almost one-third of farms lost net worth in 2017.

Those are among key findings in the annual farm income analysis conducted by University of Minnesota Extension and Minnesota State in collaboration with the FINPACK Team and the Center for Farm Financial Management (CFFM). The analysis used data from 2,164 participants in the Minnesota State Farm Business Management programs and 104 members of the Southwest Minnesota Farm Business Management Association. Participating producers represent approximately 10 percent of commercial farmers in Minnesota.  CFFM’s work with projects like this provide the benchmarking metrics used in FINPACK.  The full FINBIN report on MN Farm Finances can be accessed here[Read more…]