Using the UCA Cash Flow for Commercial Analysis

UCA Cash FlowAnalyzing a commercial credit can be challenging. Figuring out how a business is doing when you don’t have a good comparison or even figuring out if the core of the business is providing for the other pieces can make it difficult for you to understand how to analyze the business or structure the loan. Fortunately, FINPACK includes a report in the C & I Business Analysis tool that can be used to help you identify where the cash is being used in the business.

The Uniform Credit Analysis, or UCA Cash Flow, is designed to help you identify where the business’s cash is going and how it is being used. Is it being used to purchase additional inventory or is it being used to purchase equipment? [Read more…]

Report Preview Options

FINPACK Report Preview OptionsDid you realize there are options that can be selected when previewing output from FINPACK tools?  The drop-down arrow on the right side of the Preview Output icon allows the user to select the output options to be viewed when previewing.   Clicking the drop-down arrow brings up a dialogue box where the preview options are selected. [Read more…]

Which Commercial Analysis Tool is Right?

Which Commercial Analysis Tool is Right?When analyzing a commercial customer in FINPACK there are several tools available.  Deciding which tool best fits the analysis needed is important to get the optimal information, in order to reduce risk in the customer credit decision.  The type of business and customer information available will drive the commercial analysis tool used. [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…]

FINPACK Shortcuts

FINPACK Keyboard Shortcuts and Icons ChartFINPACK has a number of useful shortcuts that can aid users with data entry and general program utility.  Use the following chart full of helpful icons and keyboard shortcuts to increase your speed and efficiency while using FINPACK. [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…]

Longevity of Legacy Cash Flow Plans

Longevity of Legacy Cash Flow PlansThe option to create an annual plan or monthly cash flow plan using the Legacy Projection tools in FINPACK will remain for the next year (or two).  No official sunset date has been set at this time.  If you are a seasoned user that is very comfortable with the Legacy Projection tools, feel free to continue using them for this renewal season.    [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…]

You Need a Marketing Plan!

The FINPACK team at the U of MN is fortunate to have a broad range of ag expertise. Ed Usset, our Grain Marketing Economist, developed a time-tested approach to establishing commodity marketing plans which have hit home with a lot of producers. Commodity marketing is a big, and often emotional, issue for producers.  We also recognize its importance to your work with farmers.

Margins are tight—Ed’s message of “finding the dime(s)” is imperative.  Planting season will arrive soon. Do your customers have a pre-harvest marketing plan for their 2018 crop? Let Ed show you his plan and suggest a few ways it can be adapted by your farming customers.   [Read more…]