(800) 234-1111

FINPACK News

FINPACK Balance Sheet Worksheet

by Pauline Van Nurden | 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.

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.