(800) 234-1111

FINPACK News

Which Commercial Analysis Tool is Right?

by Pauline Van Nurden | Jun 21, 2018

Which Commercial Analysis Tool is Right?When analyzing a commercial customer in FINPACK there are several tools available.  Deciding which tool best fits the analysis needed is important to get the optimal information, in order to reduce risk in the customer credit decision.  The type of business and customer information available will drive the commercial analysis tool used.

Financial Analysis Tools

  • Commercial & Industrial (C & I) Business Analysis – this tool uses data from the business income statement or tax forms and corresponding balance sheet to analyze the business on a common sized and percent change basis. In addition, RMA comparisons can be used to further analyze the business versus its peers.  This analysis generates common debt coverage, liquidity, leverage, and efficiency ratios and a UCA cash flow as well.
  • Commercial Real Estate (CRE) Analysis – this tool analyzes the key metrics for an income producing, investor-owned (non-owner occupied) real estate property. Historical tax or income information can be spread and compared to projected net operating income, or a new property with no history can be analyzed as well.  This analysis tool also analyzes the supportable loan amounts and vacancy rate thresholds for a property.  The information can also be stressed to fully analyze the impact of vacancy, rental rate, and interest rate scenarios.
  • Global Cash Flow – this tool is used to calculate debt coverage ratios for multiple businesses and borrowers/guarantors personally. An analysis is completed on each business and person in borrowing group.  All information is then combined to analyze the overall use of cash and the impact on global debt service.

Decisions… Decisions…

To help you determine the best tool for analyzing your commercial credit, we’ve developed this chart.
Which Commercial Tool is Right for Me?
Using the right commercial credit analysis tool for each customer situation is the first step in reducing risk in the credit decision process.

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.