(800) 234-1111

FINPACK News

FINPACK Credit Analysis Tools for Commercial Customers

by David Maguire | Apr 14, 2022

FINPACK offers credit analysis solutions for both Agricultural and Commercial credits. If you’ve been using FINPACK primarily for Ag credits and your Commercial portfolio has been growing, now might be the time to look at FINPACK Commercial Credit Analysis tools.

The Right Tools for evaluating Commercial Credits

From data sources through credit analysis, FINPACK gives you all the tools you need to evaluate Commercial credits. Whether your data sources are coming from detailed or summary Balance Sheets, Tax Forms, or Income Statements, FINPACK will parse and collate your numbers right through the financial analysis tools and projections through to Collateral Analysis, Risk Reports and the Loan Presentation. Once you get into the crux of your financial analysis, of course, the tools you use differ depending on the type of business and financing situation. While both the Ag and Commercial Credit Analysis offers Global Cash Flow Analysis and Earned Net Worth Analysis, the Commercial version of FINPACK specifically adds C&I Business Analysis and Commercial Real Estate (CRE) Analysis.

C&I Business Analysis in FINPACK

The C&I Business Analysis is driven entirely from balance sheets and some form of an income statement, which is often a company tax form.  Once you have inputted the customer data in these data sources, all the work is already done, and your C&I Business Analysis will automatically generate. You have the option to include the RMA database comparison feature, driven by the business’ NAICS code.  The RMA comparison is available for an additional fee.  This feature adds the ability to run industry comparisons throughout your analysis. FINPACK generates an executive summary page, common-sized statements, percent change financial statements, detailed financial measure calculations, UCA cash flow, and cash driver’s report that differentiates the impact sales from management have on the five cash drivers.

Completing the C&I Business Analysis is as easy as selecting the tax year(s) for the business you are evaluating, as well as the related bookend balance sheets.

Commercial Real Estate (CRE) Analysis

Like the C&I Business Analysis tool, the CRE analysis is driven off tax returns. If you are evaluating a new property, with no tax history, you select this from the drop-down list. Just choose the years you would like to examine. You can also include a proforma analysis and include a full rent roll along with the appropriate status. The FINPACK CRE Analysis gives you flexibility in determining the property valuation.  You can either enter in an estimated property value and let FINPACK calculate the cap rate or put in the cap rate and have the software calculate the property value. 

Add in Stress Factors such as different vacancy rate scenarios, changes in rental rates or interest rates, and maximum LTV and minimum debt service coverage to see the impact on supportable loan amounts and income projections.

Add in Stress Factors such as vacancy rates, changes in rental rates or interest rates.  Then, see the impact of these changes in the Stress Report. 

What’s Next?

Watch below to learn more about FINPACK’s Commercial tools, or contact us today.

David Maguire became the FINPACK Relationship Manager in 2021. He helps Ag and Commercial lenders across the country understand the value of using FINPACK for credit analysis and loan management. David has worked in the marketing, training and education fields in Minnesota, Ireland and Germany.

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

How To Learn FINPACK

How To Learn FINPACK

FINPACK offers multiple training resources, including in-person, online and customized training options. FINPACK Lender Training Workshops offer two days of intensive, interactive training in-person on the University of Minnesota, St. Paul campus. Covering all the...

How to Import Data into FINPACK+ Credit Analysis Files

How to Import Data into FINPACK+ Credit Analysis Files

New data, from an external FINPACK Credit Analysis file can be imported into your institution’s
FINPACK+ Credit Analysis file for a customer. This feature allows you to add information, like
a balance sheet or cash flow projection, into an existing Credit Analysis file without overwriting the
remaining contents of the file.

Consolidating Data Sources in FINPACK+

Consolidating Data Sources in FINPACK+

FINPACK Credit Analysis allows users to consolidate the balance sheets or tax forms from several different data files into a consolidated file. For example, a farm or business may have multiple entities for tax reasons, but these entities are controlled by the same...