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
How to Import & Export Detail in Balance Sheet

Rather than manually entering detail in a new FINPACK balance sheet, you have the ability to import and export CSV files in certain areas. The process works with Intermediate, Long Term, and Personal Assets of an Agricultural balance sheet and Non-current and Personal...

Stress Testing: Crop Cost and FINPACK’s Long Range Planning Tool

Stress testing is a vital component of agricultural financial planning, allowing producers to evaluate how resilient their operations are under varying economic conditions. To help your customers in this process, we recommend two tools: FINPACK’s Long Range Planning...

Using Global Cash Flow Analysis in FINPACK

Analyzing the riskiness of a borrower becomes more complex when the borrower operates multiple businesses or mixes personal and business finances. To address these complex borrowing situations, FINPACK’s Global Cash Flow Analysis (GCFA) tool provides a structured way...

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