FINPACK News + Insights

Which Commercial Analysis Tool is Right?

by | 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
Associate Director at  | 6126254219 | pvannurd@umn.edu | Website |  + posts

Pauline Van Nurden is currently the Associate Director for the FINPACK Team. She has been with the team since 2017 as an Economist.

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
Ratio Review Series: ProSight Financial Association

Financial institutions rely on consistent information, sound risk management practices, and industry benchmarks to make informed financial decisions. Standardization in financial analysis helps ensure that institutions are operating from a common framework. The...

Tax-form Scanning is now Live in FINPACK+!

Tax-form scanning is now live in FINPACK+. Upload returns to the Tax Returns folder in your Documents area and FINPACK will let you scan, verify and upload 1040s, and Schedules C, E or F. Import the data directly into your FINPACK Tax Forms area and automatically...

FINPACK Loan Presentation New Features

The latest FINPACK update has added new features to the Loan Presentation module. As always, you can configure as many presentation templates as you need in the Credit Analysis Setup, then apply those templates to any credit you're working on. Choose your data...

Ratio Review Series: Farm Financial Standards Council

Financial ratios are an important set of metrics that can aid in evaluating the health and performance of an agricultural business. Ratios are most useful when they are calculated identically and interpreted using consistent standards. The importance of...