Global Cash Flow Analysis in Commercial Lending: What It Is and How to Build It

Global cash flow analysis combines the operating business, its owners' households and any related entities into a single consolidated statement of cash in and cash out, then tests that total against every debt the group is obliged to service. It exists because a personal guarantee is only worth the guarantor's spare cash, and the business's own statements do not show it.

It is a method, not a form. This page builds one from the source documents line by line, names the seven double-count traps, and shows what each one does to the ratio. YuSight assembles the entity and personal returns into one global worksheet with 100% of figures cited back to the document and page they came from, so a reviewer can click any line and see the return it sits on.

Key facts

• The guarantee is nearly universal, so the guarantor's cash flow is nearly always material. In the FDIC's Small Business Lending Survey, banks evaluate "willingness to offer personal guarantee for loan" on 95% of small loans ($25K), 94% of medium loans ($250K) and 94% of large loans ($1M or $3M) (FDIC, Section 3: Loan Underwriting and Approval).
• The regulator defines the building block but not the worksheet. The OCC's Rating Credit Risk booklet defines business cash flow as "the operating revenue derived from ordinary business activities less operating costs paid (not simply incurred), plus noncash expenses such as depreciation" (Comptroller's Handbook). No agency prescribes a global cash flow template.
• Guarantor cash flow is named in the CRE underwriting standards examiners look for. The Commercial Real Estate Lending booklet, Version 2.0, March 2022, lists "borrower and guarantor cash flow, and debt-service coverage ratio (DSCR)" among the minimum standards an effective CRE lending policy sets (OCC).
• In the worked example below, five common double-counts would have turned a 1.20x global DSCR into 1.87x — a difference of 0.67x produced entirely by counting the same dollars twice.
• Every global DSCR floor quoted here is lender policy. Policy minimums commonly sit at 1.10x–1.25x, and programme-specific requirements are separate.

When does a lender need a global cash flow?

Not on every file. It earns its cost when the business's own statements cannot answer the repayment question on their own:

• The owner takes cash out of the business in ways the P&L does not fully show — distributions, guaranteed payments, above-market or below-market compensation, personal expenses run through the entity.
• A guarantor is being relied on as a mitigant, rather than being taken as a matter of routine documentation.
• A related entity sits between the business and its premises — the classic operating-company / property-company split, where rent is set by the same person on both sides.
• The guarantor has other business interests whose cash flow, or losses, land on the same household.
• The business-only coverage is thin, and the credit is being made on the strength of the wider group.

If none of those apply — a widely held company with institutional owners, no guarantee and no affiliates — a global cash flow adds paperwork and no information. Say so in the memo rather than producing an empty schedule.

The method here is deliberately programme-neutral. Where the loan is an SBA 7(a), the affiliate definitions, coverage floors and SOP requirements are specific and are set out in how global DSCR is calculated for SBA 7(a) loans. The ratio family this feeds into is in every DSCR formula lenders use, and what a given coverage level actually protects against is in what DSCR is, explained for commercial lenders.

What are the five blocks of a global cash flow?

The discipline that holds the whole thing together is one sentence: every dollar and every obligation appears exactly once, on the same basis. Almost every error in a global cash flow is a violation of that sentence in one direction or the other.

Block 1: business cash flow, from the return rather than the ratio

Start from the entity return, because it is signed, filed and comparable across years. Which return depends on the structure:

• Form 1120-S — an S corporation. The IRS description: "Use Form 1120-S to report the income, gains, losses, deductions, credits, etc., of a domestic corporation or other entity for any tax year covered by an election to be an S corporation" (IRS).
• Form 1065 — a partnership or multi-member LLC.
• Form 1120 — a C corporation, where owner compensation is a genuine expense and distributions are dividends.
• Schedule C (Form 1040) — a sole proprietorship. The IRS: "Use Schedule C (Form 1040) to report income or loss from a business you operated or a profession you practiced as a sole proprietor" (IRS). Note that this income is already inside the guarantor's 1040, so it belongs in block 1 or block 3, never both.

Then work the adjustments:

Add back: depreciation and amortisation (from Form 4562, which the IRS describes as the form used to "claim your deduction for depreciation and amortization" and to "make the election under section 179 to expense certain property" — IRS); Section 179 expense, which is a capital item expensed in one year; interest expense, because it goes into the denominator; documented non-recurring expenses; and owner compensation or guaranteed payments only if you then exclude them from the household.

Deduct: unfinanced replacement capital expenditure, because a business that stops replacing its equipment is borrowing from its own future; non-recurring income; and any income the entity recognised but did not collect.

The Section 179 add-back deserves a note. It is the largest single reconciling item between a tax return and economic cash flow on an equipment-heavy borrower, and analysts who add back "depreciation" from the face of the return without opening Form 4562 routinely miss it.

Block 3: reading the Form 1040 for cash, not for income

The single most useful discipline in personal cash flow analysis: the 1040 reports taxable income; you need cash received. Those differ, sometimes by six figures.

The Schedule E Part II line is where global cash flows most often go wrong. Schedule K-1 (Form 1120-S) is filed so the corporation can "report your share of the corporation's income, deductions, credits, etc." (IRS). A guarantor with a 25% interest in a profitable LLC shows a share of ordinary income on the K-1 whether or not a single dollar reached their bank account. What is available to service debt is the distribution, which appears separately on the K-1, and which you cross-check against the personal bank statements. The technique for reading actual receipts out of raw transactions is in bank statement analysis for lenders.

Block 4: what the personal financial statement adds — and what it does not

A PFS is a balance sheet. It shows assets, liabilities and net worth at a date. It does not show cash flow, and reading income off it is a category error. What it does contribute:

• The personal debt schedule — the payments that go into block 4, cross-checked against the guarantor's credit report, because a PFS is self-prepared and the credit report is not.
• Contingent liabilities — guarantees the guarantor has already given elsewhere. These do not enter the arithmetic but they do enter the recommendation. A guarantor already contingently liable for several million dollars of a third party's debt is a different mitigant from one who is not.
• Unencumbered liquidity — the cushion that carries a shortfall year. A global DSCR of 1.05x with two years of debt service in unencumbered liquid assets is a different credit from 1.05x with none.
• Two dated PFSs let you solve for living expenses. More on that next.

Living expenses are the least evidenced line in the whole worksheet. Most lenders use a policy convention — a fixed household amount, a percentage of gross income, or a figure reconstructed from twelve months of personal bank statements. There is a fourth method that costs nothing extra because you already hold the documents:

Implied living expenses = Total cash income received − Income taxes paid − Personal debt service − Increase in liquid assets between two PFS dates

Run it alongside the policy figure. If the implied number is far below the policy convention, the household is either spending less than the table assumes or funding itself from somewhere the file has not identified. Both are worth a question.

What are the double-count traps?

Seven, in descending order of how often they appear and how much damage they do.

1. Owner compensation or guaranteed payments counted twice — added back in block 1 and counted as household income in block 3. Inflates coverage by the full amount of the compensation.
2. Related-entity rent counted twice — the operating company deducts rent as an expense, and the same rent is counted again as the guarantor's Schedule E rental income. The rent is one flow inside the consolidation, not two.
3. K-1 income used instead of distributions — counts profits the guarantor's household never received.
4. Living expenses omitted — a household with no expenses is not a household. This is more common than it should be on files where the guarantor's income is large.
5. Affiliate debt service both netted and included — the affiliate's mortgage deducted inside its own cash flow line and added to the global denominator. Or, equally wrong, omitted from both.
6. Depreciation added back twice — once inside the entity's return and again on the guarantor's Schedule E for the same property.
7. A non-guarantor spouse's income counted in full — legitimate as a source of household support in many policies, but it is not pledged, and the memo should say which convention was used and test the ratio without it.

The full worked global cash flow

Harborline Logistics LLC, a regional freight and warehousing business taxed as a partnership. Members: Ana Castellanos 60%, Peter Nwosu 40%. Both guarantee. Related entity: 400 Weld Street LLC, which owns the terminal and leases it to Harborline. Ana separately holds a 25% interest in Northbay Storage LLC, an unrelated business. Request: $2,600,000 term loan, 10 years, 9.25%. Existing equipment notes and a $1,500,000 revolver.

Step 1 — Business cash flow (FY2025 Form 1065)

Ordinary business income (Form 1065, Line 22) 412,600 + Depreciation (Form 4562) 268,400 + Section 179 expense (Form 4562) 75,000 + Amortisation 9,200 + Interest expense (Form 1065, Line 15) 143,800 + Guaranteed payments to partners (Form 1065, Line 10) 240,000 − Non-recurring insurance recovery (46,000) − Unfinanced replacement capex (policy) (120,000) = Business cash flow available 983,000

The guaranteed payments are added back here, which means they must be excluded from both households in step 3. That choice is made once and applied consistently.

Step 2 — Related entity (400 Weld Street LLC)

Rent received from Harborline Logistics 216,000 − Property tax, insurance, repairs, management (58,400) − Building mortgage principal and interest (141,600) = Net cash flow of the property entity 16,000

The $216,000 of rent was already deducted as an expense inside Harborline's ordinary business income, so it is not being double-counted. It must not also appear on either member's Schedule E. What the group actually gains from owning its building is $16,000.

Step 3 — Ana Castellanos household (Form 1040)

Guaranteed payments — excluded here, added back at Step 1 0 Spouse W-2 income (Line 1) 92,000 Schedule B interest and ordinary dividends 6,400 Schedule E Part II — Northbay Storage LLC (25%): share of ordinary income $58,000 — not cash, excluded 0 cash distributions actually received 22,000 Schedule E Part I — 400 Weld Street: excluded, counted at Step 2 0 = Personal cash income 120,400 Federal and state income taxes paid (96,300) Household living expenses (policy convention) (108,000) Residence mortgage principal and interest (52,800) Auto, student loan and card payments (21,600) = Personal outflows (278,700) Net household contribution (158,300)

Step 4 — Peter Nwosu household (Form 1040)

Guaranteed payments — excluded here, added back at Step 1 0 Spouse Schedule C net profit (Line 31) 64,000 + Schedule C depreciation (Form 4562) 7,500 Schedule B interest 1,900 Pension and IRA distributions actually received 12,000 = Personal cash income 85,400 Federal and state income taxes paid (41,200) Household living expenses (policy convention) (84,000) Residence mortgage principal and interest (33,600) Consumer debt service (14,400) = Personal outflows (173,200) Net household contribution (87,800)

Both households are net negative, which is what happens when the guaranteed payments funding them are credited to the business. The arithmetic is consistent; the presentation just needs explaining in the memo.

Step 5 — Global cash flow

Business cash flow available 983,000 + Related property entity net cash flow 16,000 + Ana Castellanos household, net (158,300) + Peter Nwosu household, net (87,800) = Global cash flow available for debt service 752,900

Step 6 — Global debt service

Proposed term loan: $2,600,000, 120 months, 9.25% monthly P&I $33,288 × 12 399,456 Existing equipment notes, P&I per debt schedule 148,900 Revolver interest: $900,000 average outstanding × 8.50% 76,500 Property entity mortgage — netted at Step 2, excluded 0 Personal debt service — netted at Steps 3 and 4, excluded 0 = Global debt service 624,856

Step 7 — The ratios

Business-only DSCR = 983,000 ÷ 624,856 = 1.57x Global DSCR = 752,900 ÷ 624,856 = 1.20x

The business alone covers 1.57x. Two households and a building take it to 1.20x. That 0.37x is the price of the guarantee structure, and it is the number the committee is actually deciding on.

Proof that the convention does not change the answer

A frequent objection: why add guaranteed payments back to the business and take them out of the household? Do it the other way and the total is identical.

Business cash flow, guaranteed payments left as an expense = 983,000 − 240,000 743,000 + Property entity 16,000 + Ana household, with her 60% share (144,000) added back = (158,300) + 144,000 (14,300) + Peter household, with his 40% share (96,000) added back = (87,800) + 96,000 8,200 = Global cash flow available for debt service 752,900

Same $752,900. A consistent convention gives the same answer either way; an inconsistent one gives a different answer every time. That is the whole argument for writing the convention into credit policy.

While the alternative convention is on the page, use it to solve for Ana's living expenses:

Cash income received 144,000 + 92,000 + 6,400 + 22,000 264,400 − Income taxes paid (96,300) − Personal debt service 52,800 + 21,600 (74,400) − Increase in liquid assets between two PFS dates (8,000) = Implied living expenses 85,700

The policy table said $108,000. The documents imply $85,700. The conservative figure was used above; the gap is worth a question at the site visit.

What the errors would have printed

Each trap applied to this same file, in isolation and then together:

1.20x correct, 1.87x with the errors, 0.98x with one error in the opposite direction. None of those is a modelling opinion. They are all arithmetic, and all of them pass a superficial review because every individual figure ties to a document.

Two sensitivities belong beside the correct number in the memo. Peter's spouse's Schedule C business contributes $71,500 of the numerator:

Global cash flow without it = 752,900 − 71,500 = 681,400 Global DSCR = 681,400 ÷ 624,856 = 1.09x

And Ana's Northbay distributions are discretionary — the other members decide:

Global cash flow without them = 752,900 − 22,000 = 730,900 Global DSCR = 730,900 ÷ 624,856 = 1.17x

How to present it, and where it breaks

The global cash flow belongs in the memo as a worksheet, not a conclusion. Show the five blocks, the source document for every line, the convention used for guaranteed payments and living expenses, and the two or three sensitivities that move the ratio most. Then state the residual risks the arithmetic cannot capture: contingent liabilities on the PFS, the enforceability and priority of the guarantees, and whether the household could genuinely reduce spending if asked.

The practical constraint is document handling. A global cash flow on this borrower needs a 1065, a 1120-S or 1065 for the property entity, two 1040s with all schedules, two K-1s, two PFSs, two credit reports, a business debt schedule and personal bank statements — and every one of them has to be assigned to the right entity before a single figure is spread. That mapping problem is the subject of multi-entity document mapping, and the wider process it sits inside is in commercial loan underwriting in US banks. Getting from the filed returns to a standardised, citable spread is covered in what financial spreading is, and where the finished worksheet lands is set out in what a credit assessment memo must contain.

FAQ

What is global cash flow analysis in commercial lending?

It combines the operating business, the guarantors' households and any related entities into one consolidated view of cash in and cash out, then tests that total against all the group's debt service. Lenders use it because a personal guarantee is only worth whatever cash the guarantor has left over after their own obligations.

How is global cash flow calculated the SBA way?

The method is the same — business, affiliates, guarantor households, one denominator — but SBA lending adds programme-specific rules on which entities count as affiliates and what coverage the loan must show. Those specifics change with each SOP revision and are set out separately in our SBA 7(a) page.

How do you avoid double-counting in global cash flow?

Make one rule and apply it everywhere: every dollar of cash and every obligation appears exactly once. In practice that means choosing whether owner compensation sits in the business or the household, netting affiliate debt service in one place only, and never counting rent that one group entity pays another as new income.

Which tax return schedules do you need for a global cash flow?

The entity return with Form 4562, and each guarantor's Form 1040 with Schedules B, C and E and every K-1. Schedule D and Form 4797 come out as non-recurring. Without Form 4562 you will miss the Section 179 add-back, which on an equipment-heavy borrower is often the largest single adjustment.

Do you use K-1 income or K-1 distributions?

Distributions. A share of an entity's ordinary income is a tax allocation, not money in the household's account, and a minority holder cannot compel a distribution. Take the distribution figure from the K-1 and confirm it landed by looking at the personal bank statements.

Should a non-guarantor spouse's income be included?

Many policies allow it as household support, and it is usually the income keeping the household solvent. But it is not pledged and it can stop, so state the convention you used and show the ratio with and without it. In our worked file that one line was the difference between 1.20x and 1.09x.

What living expense figure should you use?

Whichever your policy specifies — a fixed household amount, a percentage of gross income, or a figure reconstructed from bank statements. Then sanity-check it by solving for implied living expenses from the tax return, the debt schedule and the change in liquid assets between two personal financial statements.

Does a personal financial statement show cash flow?

No. It is a balance sheet at a point in time. It gives you the personal debt schedule, the contingent liabilities and the liquidity cushion, and two of them dated a year apart let you infer spending, but income has to come from the tax return.

How do you treat a loss-making affiliate?

As a cash drain, at the amount of cash it actually consumes, not at its book loss. If the guarantor is funding it out of the household, that funding is an outflow in the household block, and the memo should say whether the group can stop funding it and what happens if it does.

When is a global cash flow not required?

When there is no guarantee being relied on, no affiliates, no owner-controlled related entity and no meaningful cash extraction — typically a widely held company with institutional ownership. Write that reasoning into the memo rather than producing an empty schedule for the file.

Key takeaways

• A global cash flow is a consolidation, not a form. Five blocks: business, affiliates, guarantor income, guarantor outflows, and one denominator.
• The governing rule is that every dollar and every obligation appears exactly once, on the same basis, in every file.
• Read the 1040 for cash received, not taxable income. Distributions, not K-1 income; exclude Schedule D and Form 4797.
• Open Form 4562. The Section 179 add-back is routinely the largest reconciling item on an equipment-heavy borrower.
• A personal financial statement is a balance sheet. Use it for the debt schedule, contingent liabilities and liquidity — never for income.
• Five ordinary double-counts took our worked borrower from 1.20x to 1.87x, and one error in the other direction took it to 0.98x. Every individual figure still tied to a document.
• Show the sensitivities. The spouse's business was worth 0.11x of coverage on its own.

Watch YuSight spread a real balance sheet — bring one owner-managed borrower's entity returns, 1040s and personal financial statements and see the global cash flow assembled block by block, every figure cited to its source document and page.

Next: how global DSCR is calculated for SBA 7(a) loans, what DSCR is and what a given level protects against, and every DSCR formula lenders use.