(800) 234-1111


FINPACK C & I Business Analysis

by | Dec 19, 2018

How to use FINPACK Loan CalculatorAnalyzing a commercial business can be tricky. Commercial businesses can be very different from each other even if they sell the same product. In addition, if you are unfamiliar with the particular industry, how do you measure management’s performance? The latest release of FINPACK has an overhauled C & I Analysis that helps you better analyze your commercial credits, as well as management’s ability.

Customer Information Needed

The FINPACK C & I Analysis uses the income statement or tax forms received from a customer to analyze the business. Once the information is entered, simply select the bookend balance sheets for the income statement or tax form to be analyzed.

C & I Business Analysis Report

Let’s talk about the output.  The analysis output starts with an Executive Summary trend report.  This provides an overview of the report.  On the lower half of this page, you will find industry ratios, as well as the cash cycle analysis.  The cash cycle analysis evaluates how quickly cash moves through the business. Within the income statement (for both common sized and percent change), the expense detail is provided.  This will help you work with your customer to identify particular expenses that may be fluctuating or need to be reined in.

At FINPACK, we have had several lender requests to include ratio calculation details in output, just as we do with other FINPACK output.  Therefore, we have added a detailed ratio report that walks you through the ratio calculations, including the cash cycle days, for example.

Cash Drivers Report

The biggest – enhancement to the FINPACK C & I Analysis is the addition of a Cash Drivers report. This report is using the main cash drivers of a commercial business – sales, operating expenses, cost of goods sold, accounts receivable, accounts payable and inventory.  This report shows the trend of the cash drivers and their impact on cash from either growth or management.  This report aims to measure the unmeasurable: management’s ability to manage the business!

Let’s take a look at a scenario to explain.  We all know as a business grows it requires more cash. So, to feed more sales, the business will need to buy or make more finished inventory to sell. In that process, management might be able to capture some discounts in purchasing inventory and because of that, more cash is kept in the business. This report measures both how cash drivers respond to changes in sales and management’s response to this operating environment.

The help guide in FINPACK has much more detailed information about how these numbers are calculated, but we encourage you to take a look at the new output and be on the lookout for a more detailed FINPACK News post about this exciting report!

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...