(800) 234-1111

FINPACK News

FINPACK Balance Sheet Worksheet

by | Jan 24, 2019

FINPACK Balance Sheet WorksheetGathering customer data for year-end analysis and credit renewal can be difficult.  FINPACK tries to assist with the process by providing a Balance Sheet Input Worksheet with the customer’s most recent balance sheet data for updating.  This tool is provided to the customer as a means to get current, updated balance sheet information for the current year.  This worksheet is one FINPACK tool to assist with customer renewals.

What is the balance sheet input worksheet?

The FINPACK balance sheet input worksheet creates the selected customer balance sheet as a worksheet.  This form displays details from the selected balance sheet and provides areas for the customer to update the information with current values and/or add additional information as appropriate.  This worksheet can be given to customers in preparation for their year-end analysis or credit renewal visit.   

Sample input worksheet

How to create the balance sheet input worksheet.

Creating and printing the balance sheet input worksheet is easy when you know where to do so.  The option to create an input worksheet is found in the Print dialogue box.  In the bottom half of the box, Input Worksheet Options is a tab option.  Selecting this tab will allow printing or previewing the selected balance sheet as a worksheet.  As always, the worksheet can be printed to a printer or as a PDF or Text file.

Print dialogue box

Working with new customers.

If beginning to work with a new customer, FINPACK has an input form available to assist with gathering the new customer’s information. A balance sheet input form and instructions are found in the FINPACK Knowledge Base for use with both agricultural and commercial customers.  In addition, there are a number of other FINPACK input forms to assist with gathering customer data for use in FINPACK tools.  The Sch. F Analysis – Additional Information form would be an example. Also remember, FINPACK Lite is another way to have customers provide balance sheet data.  This is a free tool, available for customer use.

Latest News
Loan refinance in a FINPACK Projection

Loan refinance in a FINPACK Projection

Refinancing loans is a frequent option to help business owners in need when profits are down, and cash flows are tight. Following the correct loan steps in a FINPACK Projection ensures the Term Debt Coverage Ratio and other repayment capacity measures are correct...

Changing interest rates in FINPACK Projections

Changing interest rates in FINPACK Projections

Interest rates charged on loans can change during the year for any number of reasons; the rate is variable, the rate was renegotiated at renewal, or the customer’s risk profile changed to name a few. Because of this, interest rate changes on operating or term loans...

2019 FINBIN Report on MN Farm Finances

2019 FINBIN Report on MN Farm Finances

In our previous post, we discussed some of the financial highlights for Minnesota farms in 2019.  In this post, we want to highlight our more detailed report. The 2019 FINBIN Report on MN Farm Finances graphically shows how Minnesota farms performed in...

Minnesota farm incomes inch higher

Minnesota farm incomes inch higher

Minnesota farmers continued to struggle with low profitability in 2019.  Median net farm income was up slightly from the previous year at $36,211, but was still historically low.  Each of the past five years has fallen in the bottom third of historical...

COVID-19 Response

COVID-19 Response

Greetings, You’ve probably had a few of these emails hit your inbox recently.  All CFFM staff have moved off-campus to work from home and are trying to balance work and home life like many of you.  We wanted to give you a quick update from the FINPACK...