(800) 234-1111

FINPACK News

Recent FINPACK Update Features

by | Jul 15, 2019

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.

Import/export balance sheet detail

A more streamlined method of entering and editing detailed balance sheet information in FINPACK is now available. FINPACK now includes the ability to import and export data from CSV files. The process works with Intermediate, Long Term, and Personal Assets of an Agricultural balance sheet and Noncurrent and Personal Assets of a Commercial balance sheet. The import/export feature is also available for consolidated balance sheets. Specific steps related to the process are found in this help guide. Key to the import process is proper column headings in the CSV file. A detailed list of column headings needed for each asset type is included in the help guide referenced above.

New FINPACK icons

New icons are now found in the detailed entry dialog box with this update for capital asset categories in detailed balance sheets. These relate to the import/export addition. A brief overview of each includes:

Import from a CSV file – when in a detail dialog box of Intermediate Assets/Long-Term Assets/Personal Assets (Agriculture balance sheet) or Noncurrent Assets/Personal Assets (Commercial balance sheet), a user is able to import that data from a CSV file.
Export to a CSV file -when in a detail dialog box of Intermediate Assets/Long-Term Assets/ Personal Assets (Agriculture balance sheet) or Noncurrent Assets/Personal Assets (Commercial balance sheet), a user is able to export that data to a CSV file.  

Note – all FINPACK icons are explained here, including a reference guide.

Financial Scorecard

A Financial Scorecard has been added to the output of cash flow projections (FINFLO). An additional page of output is generated with cash flow projections, plotting the farm financial ratios from the plan on the included scorecard. Ratios related to the farm’s liquidity, solvency, profitability, repayment capacity, and efficiency position are included. The value of each ratio is scored per the Farm Finance Scorecard. This feature helps to quickly evaluate the farm’s financial position from strong to vulnerable. The user has the option to include or exclude this section in the cash flow output and when printing.

Farm Finance Scorecard addition to a cash flow projection (FINFLO).

Input worksheets for cash flow projections

Back by popular demand with this FINPACK update are input worksheets for all cash flow projection (FINFLO) types. The input worksheet is found in the Print dialog box. This feature allows a user to organize the details of a new cash flow projection, using the information from the historical projection selected. This is especially useful when creating a projection for the new year, with many of the same assumptions as the previous plan. For example, this aids customer preparation for lender renewal visits.

Cash flow projection input worksheets are accessed from the print dialog box.

Summary

Give these new balance sheet and cash flow projection (FINFLO) features a try. We, the FINPACK Team, think these are great enhancements to the program. As always, if you have questions related to the update process, the new FINPACK features, or other questions don’t hesitate to contact FINPACK Tech Support.

Latest News
2022 FINPACK Lenders Conference

2022 FINPACK Lenders Conference

The 2022 FINPACK Lenders Conference will be held in-person in 2022. Conference Information Date: December 13-14, 2022Location: Radisson Blu Mall of America - Bloomington, MN Dr. David Kohl returns to the FINPACK Lenders Conference + a full lineup of speakers. We will...

FINPACK Digest – June 2022

FINPACK Digest – June 2022

Credit scorecards, the FINPACK advanced training survey, register now for Lender training, and The FINPACK digest is published every month and links to all the FINPACK News post published in the previous four weeks. Want notifications on FINPACK news posts sooner?...

Training & Events Update

Training & Events Update

October training for Lenders, Training for Educators and Professionals, and save the date for the 2022 FINPACK Lender's Conference FINPACK Training for Lenders in October Registration is open for the next FINPACK Lender training on October 11th and 12th on the...

How to Design and Use Credit Decision Scorecards

How to Design and Use Credit Decision Scorecards

Using Credit Decision Scorecards in your credit decisioning represents a convenient way to 'filter' loan applications. By applying some basic criteria, you can quickly decide if a credit request is straightforward and can be approved or denied as is, or if it needs...