(800) 234-1111

FINPACK News

How to use Global Cash Flow Analysis

by | Apr 20, 2022

Global Cash Flow Analysis is a widely used financial analysis tool to evaluate more complex borrowers. The Global Cash Flow Analysis tool included in both the Ag and Commercial versions of FINPACK calculates a global debt coverage ratio when commingling the primary business, any secondary businesses, and personal funds occurring within a closely held business. The performance of each business and individual is first analyzed individually for debt repayment capacity by using the income statement or tax form. Then, the overall (or global) debt repayment is calculated based on the overall sources and uses of cash for all businesses and individuals included in the global analysis. As lenders, you can easily identify the borrowers in your lending portfolio that would be best analyzed using global cash flow analysis, and then it’s just a question of choosing what data sources are needed to complete the analysis.

Step 1: Data Sources

As with all FINPACK analyses, we start with data sources. First, we identify the primary business — in the example below, it’s a farm, so we use the Schedule F — then add any other business(es) they might have. In this case, they have a trucking company, so we add the Schedule C; some rental property, so we add the Schedule E; and then lastly, we add any individual or guarantor tax return information. The input always includes a ‘blank’ field, so you can add as many entities or individuals as you need.

Choose the tax forms or income statements for the primary business and any other related businesses or personal returns

Step 2: Proposed New Income/Debt

We can also add proposed new income or loans to consider the impact this ‘scenario’ would have on the analysis. This ‘scenario’ could conversely include a reduction/refinance of debt or a decrease in income. Including this type of analysis adjusts the global debt coverage calculation for the prior three years to assess the impact of the proposed business decision, like an investment. Then when we go to the output, there will be an additional page showing Proposed New Income & Debt.

Step 3: Analysis Output

FINPACK generates cash available for debt service, factors in debt payments, and provides a Debt Service Coverage Ratio and Debt Repayment Margin for each entity. This is followed by a Global Debt Coverage, showing net global cash available for debt service, total debt payments, and a Total Debt Coverage Ratio.

FINPACK produces a Debt Service Coverage Ratio and Debt Repayment Margin for each entity,
Global Debt Coverage, showing net global cash available for debt service, total debt payments, and a Total Debt Coverage Ratio.

How to use Global Cash Flow Analysis: Summary

Use FINPACK’s Global Cash Flow Analysis tool to assess the Debt Repayment Capacity and get to the end goal of your analysis – your customer’s Debt Coverage. Locate the weak links in your global borrower and assess how these impact the stronger elements. The Global Cash Flow Analysis tool comes with both the Ag and Commerical versions of FINPACK. Contact us today to learn more!

Latest News
FINPACK Digest – May 2022

FINPACK Digest – May 2022

1. Cover Crop Financial Data Profitability The Environmental Defense Fund (EDF) collaborated with the Center for Farm Financial Management (CFFM) to integrate a new data gathering process into FINBIN — the largest publicly-available farm financial database...

How To Use Tasks To Speed Up Credit Decisions

How To Use Tasks To Speed Up Credit Decisions

Speeding up the credit decision process is vital. While striving to be as methodical and rigorous as possible in their evaluation of every loan request received, lenders need to get to a decision in as timely a fashion as possible. Using a coherent 'tickler' or task...

Using Core Data in FINPACK+

Using Core Data in FINPACK+

https://vimeo.com/705769854/86a95ea1be Wynn Richardson gives an overview of how the FINPACK+ API can connect your core system with FINPACK+. Learn how to import customer, account and loan data from your core system into FINPACK+ to use in a FINPACK credit analysis....

How to Use Portfolio Risk Analyst (PRA)

How to Use Portfolio Risk Analyst (PRA)

Each borrower, be they Ag or Commercial, has their own unique business risks. You also need to know how your entire loan portfolio is positioned to face the volatility of today's business environment. PRA (Portfolio Risk Analyst) creates a database of your Ag or...

FINPACK Digest: April 2022

FINPACK Digest: April 2022

From April: FINPACK Credit Analysis Tools for commercial customers, an overview of Global Cash Flow Analysis, celebrating ICBA Community Bank Month, and training workshops update. 1. FINPACK Credit Analysis Tools for Commercial Customers FINPACK offers credit analysis...