YuVerse at Global Fintech Fest 2026View event
Talk to us
BlogBankingHow To GuideYusight

Global Cash Flow Analysis: How US Lenders Combine Business and Guarantor Cash Flow

Build global cash flow the way a US commercial lender does: entity map, K-1 and 1040 mechanics, the distribution double-count trap, and a full worked example.

YT

YuVerse Team

Published September 3, 2026 · Updated September 3, 2026 · 20 min read

Global Cash Flow Analysis: How US Lenders Combine Business and Guarantor Cash Flow

Global cash flow analysis combines the operating company, every affiliate the borrower controls, and each guarantor's household into one statement of cash available for debt service. You build an entity map, spread each entity once, net each entity's own debt inside its own line, and divide the total by the debt service that is left. YuSight's sample CAM carries 142 citations and takes 28 minutes to draft, which is what makes a five-entity build reconstructable a year later.


Key facts

  • 59% of small employer firms that carried debt used a personal guarantee to secure it, against 51% who pledged business assets (Federal Reserve Banks, *2026 Report on Employer Firms*, 3 March 2026). In this segment the guarantor is not a courtesy signature; it is a repayment source you are obliged to analyse.
  • The OCC ties guarantor credit to two tests, not one. The Rating Credit Risk booklet states: "If a guarantee is to enhance a credit's risk rating, the guarantor must display the capacity and willingness to support" (OCC, Comptroller's Handbook, *Rating Credit Risk*, April 2001, updated 2017 and 2025).
  • The interagency workout policy statement is explicit about the data set. Institutions "that have sufficient information on the guarantor's global financial condition, income, liquidity, cash flow, contingent liabilities, and other relevant factors ... are better able to determine the guarantor's financial ability to fulfill its obligation" (SR 23-5, *Policy Statement on Prudent Commercial Real Estate Loan Accommodations and Workouts*, 30 June 2023).
  • A 28-minute CAM with 142 citations is YuSight's sample output — every global cash flow line traced to the return, schedule and page it came from, so a reviewer can test the build instead of re-doing it.
  • The convention drives the answer more than the borrower does. In the worked example below, the same borrower produces a global DSCR of 0.96x, 1.15x or 1.50x depending on term and on which guarantor you include.

What is global cash flow analysis, and why do US banks require it?

A commercial borrower is rarely one legal entity. It is an operating company, a real-estate entity that owns the building and charges the operating company rent, sometimes a second trade under the same ownership, and two or three individuals who guarantee everything and also own rental property, carry mortgages and pay income tax on income they never see in cash.

Business-only DSCR measures one box in that picture. Global cash flow measures the picture. It exists because of a specific failure mode: the operating company covers 1.40x, the loan is approved, and eighteen months later it is on the watch list because the owners have been pulling distributions to cover personal debt service the bank never modelled.

If you want the method stated generically across markets, that is covered in global cash flow analysis in commercial lending. If you want the SBA-programme version with living-expense conventions and the 1.1:1 floor, that is how global DSCR is calculated for SBA 7(a) loans. This page is the US bank practitioner build: which form, which line, which trap.

How do you build the entity map before you spread anything?

Do this first. Every double-count in a global cash flow starts with an entity map that was drawn after the spreading rather than before it.

The map for our worked borrower, described in text:

  • Calloway Precision LLC — the operating company, taxed as an S corporation, files Form 1120-S. Owned 60% by Marcus Calloway, 40% by Diane Okafor. This is the borrower.
  • Calloway Holdings LP — owns the plant and leases it to the operating company. Files Form 1065. Owned 50/50 by Marcus and Diane. Related by common control; its rent income is the operating company's rent expense. Guarantor entity.
  • Northline Coatings LLC — a second trade, single-member, disregarded for tax, so it appears as Schedule C on Marcus's personal return. 100% Marcus. Affiliate.
  • Harbor Table LLC — a restaurant in which Diane holds a passive 25%. She does not control it and it does not guarantee. Reported on Schedule E, Part II of her 1040.
  • Marcus and Elena Calloway — joint Form 1040. Guarantors.
  • Diane Okafor — single Form 1040. Guarantor.

Three questions settle every entity's treatment:

Question

If yes

If no

Does the group control it?

Spread it as an affiliate; its cash flow and its debt both enter the global build

Treat only the cash the guarantor actually receives from it

Does it guarantee the facility?

Its debt service belongs in global debt service

Its debt stays out of the denominator unless it is a contingent liability you are stressing

Does it transact with the borrower?

Identify and eliminate the intercompany flow before adding

Add it independently

Harbor Table fails all three from a control perspective. It contributes only the cash Diane actually draws — which in FY2025 was nil. Getting each document to the entity it belongs to before it is spread is a discipline in itself; see multi-entity document mapping.

Which tax form lines actually feed the build?

The recurring error is analysts reading personal returns as if they were income statements. A 1040 is a tax document. Several of its largest numbers are not cash, and several real cash movements never appear on it at all.

Source

Line or schedule

Treatment in global cash flow

Form 1120-S

Line 21, ordinary business income

Starting point for the operating company

Form 1120-S

Line 7, officer compensation

Add back at the entity, then deduct market-rate replacement compensation

Form 4562

Depreciation, amortisation, §179

Add back at the entity, then deduct maintenance capex separately

Schedule K-1 (1120-S)

Box 1, ordinary income

Do not add to guarantor income if you already counted the entity — see below

Schedule K-1 (1120-S)

Box 16, code D, distributions

Cash actually received; the double-count trap lives here

Schedule E, Part I

Rents and royalties, line 26

Net rental income after depreciation; add back line 18 depreciation

Schedule E, Part II

Partnership and S-corp income

Zero it out for any entity you spread separately

Schedule C

Line 31 net profit, line 13 depreciation

Affiliate trade reported on a personal return

Schedule B

Interest and ordinary dividends

Count if recurring and from a source that still exists

Form 1040

Total tax, plus state return

A real, non-optional household outflow

Form 4506-C

IVES transcript request

Verification, not a source of numbers (IRS, Income Verification Express Service)

Two notes on the schedules that cause the most argument. Schedule E (Form 1040), *Supplemental Income and Loss reports "income or loss from rental real estate, royalties, partnerships, S corporations, estates, trusts, and residual interests in REMICs" ([IRS, About Schedule E](https://www.irs.gov/forms-pubs/about-schedule-e-form-1040)). Part I is rental property; Part II is pass-through entities. They need opposite handling. Schedule K-1 (Form 1120-S) reports "your share of the corporation's income, deductions, credits, etc." ([IRS, About Schedule K-1 (Form 1120-S)](https://www.irs.gov/forms-pubs/about-schedule-k-1-form-1120-s)) — a share of taxable* income, not a share of cash. The distinction is the whole of the next section.

What is the distribution double-count trap?

An S-corp shareholder is taxed on their share of the company's income whether or not the company distributes anything. Most closely held companies therefore distribute enough cash for the owners to pay that tax, plus whatever else the owners take.

Now watch what an analyst does under time pressure. They spread the 1120-S and get business cash flow. Then they open the 1040, see K-1 income of $625,200 on Schedule E Part II, and add it to guarantor income. The same dollars are now in the build twice — once as company cash flow, once as owner income.

The rule that prevents it: each dollar enters exactly once, at the entity where it is earned. If you spread the entity, zero the guarantor's K-1 line for that entity. If you do not spread the entity — a minority, non-controlled holding like Harbor Table — count only the distributions the guarantor actually received, evidenced on K-1 box 16 code D and traced to a personal bank statement.

Quantified on the worked example below: adding back the $760,000 the operating company distributed in FY2025 and counting it again as household income would put global cash flow at $1,766,428 and global DSCR at:

1,766,428 ÷ 1,050,780 = 1.68x

The correct figure is 0.96x. Same file, same forms, a 0.72x error in the direction of approval.

The mirror-image trap is on the outflow side: if you deduct the guarantor's personal income tax at the household, you must not also deduct the tax distribution at the company, and vice versa. Pick one. Say which in the memo.

How do you handle rental and passive income?

Rental income is the second-largest source of overstatement after distributions.

  • Add back depreciation, then look at the property. Schedule E line 18 depreciation is non-cash and belongs back in. But a rental producing a taxable loss of $4,200 with $38,600 of depreciation is not producing $34,400 of usable cash if the roof is twenty years old and the mortgage amortises.
  • Net the mortgage inside the line. If you add rental income at the household, the rental mortgage P&I must come out at the household too — otherwise the property arrives as pure income.
  • Test recurrence, not existence. One year of rent on Schedule E is not a repayment source. Two years plus a lease is.
  • Passive K-1 losses are usually not cash. Diane's $18,000 Harbor Table loss is largely her share of the restaurant's depreciation. Deducting it as a household outflow understates her; counting it as income overstates her. Add back the non-cash component and stop.
  • Cash-out refinances distort the trend. A property that produced $22,000 of net cash in FY2023 and $3,000 in FY2025 after a refinance is not a deteriorating asset; it is a re-levered one. Say so.

A full worked global cash flow

The request. Calloway Precision LLC seeks a $4,200,000 conventional term loan, 7 years, 7.75% fixed, to fund a press line and retire two equipment notes. Existing $2,500,000 revolver, average outstanding $1,800,000 at 7.25%. Guarantors: Marcus Calloway, Elena Calloway, Diane Okafor, Calloway Holdings LP.

Step 1 — Operating company (FY2025 Form 1120-S)

Ordinary business income (line 21) 1,042,000 + Depreciation, amortisation and §179 (Form 4562) 412,000 + Interest expense (line 13) 196,000 + Officer compensation (line 7): Marcus 285,000, Diane 240,000 525,000 + One-off litigation settlement paid 90,000 − Gain on equipment sale (non-recurring) (62,000) = EBITDA before owner compensation 2,203,000 − Market-rate replacement management compensation (420,000) − Maintenance capex (3-year average, not book depreciation) (310,000) = OpCo cash flow available for debt service 1,473,000

Two judgements are already embedded. Adding back all $525,000 of officer compensation and deducting $420,000 to hire two managers who could run the plant is defensible; adding back $525,000 and deducting nothing is not. And depreciation is added back but capex is deducted at the three-year average, because a machine shop that adds back $412,000 and spends nothing is liquidating its own asset base.

Step 2 — Real-estate affiliate (Calloway Holdings LP, Form 1065)

Rent received from the operating company 540,000 − Property tax, insurance, repairs, maintenance (128,000) = Net operating income 412,000 − Plant mortgage P&I ($3.1m, 20 years, 6.85%) monthly $23,756 × 12 (285,072) = RealCo net cash flow 126,928

The $540,000 rent was already deducted as an expense inside the operating company's line 21, so no elimination entry is needed. What the group actually gains from owning its building is $126,928 — and a question about whether the rent is at market, which belongs in the memo either way.

Step 3 — Affiliate trade (Northline Coatings, Schedule C on Marcus's 1040)

Net profit (Schedule C line 31) 118,000 + Depreciation (line 13) 41,000 + Business use of home, non-cash 6,000 = Cash flow before debt service 165,000 − Equipment note P&I (58,400) = Northline net cash flow 106,600

Step 4a — Guarantor household: Marcus and Elena (joint Form 1040)

Marcus W-2 from OpCo — excluded, added back at Step 1 0 Elena W-2, regional hospital system 96,000 Schedule B interest and ordinary dividends 11,400 Schedule E Part II, Calloway Holdings K-1 — counted at Step 2 0 Schedule C, Northline — counted at Step 3 0 Schedule E Part I, net rental on two condos (4,200) + Depreciation on the condos (line 18) 38,600 = Household income available 141,800 Federal and state income tax paid (268,000) Household living expenses (policy convention, $11,000/month) (132,000) Primary residence mortgage P&I (61,200) Rental condo mortgages P&I (49,800) Auto and personal notes (21,600) = Household outflows (532,600) Net household contribution (390,800)

The $268,000 tax line is the price of the structure. Marcus is taxed on 60% of $1,042,000 of pass-through income plus his W-2 plus Northline. Because that pass-through income is counted at Step 1, the tax on it must be counted here.

Step 4b — Guarantor household: Diane (single Form 1040)

Diane W-2 from OpCo — excluded, added back at Step 1 0 Schedule E Part II, Calloway Holdings K-1 — counted at Step 2 0 Schedule E Part II, Harbor Table LLC (25%, passive) (18,000) + Non-cash depreciation share added back 22,000 Schedule B interest 3,900 = Household income available 7,900 Federal and state income tax paid (172,000) Household living expenses (policy convention, $7,000/month) (84,000) Residence mortgage P&I (42,000) Student loan and auto (19,200) = Household outflows (317,200) Net household contribution (309,300)

Step 5 — Global cash flow

OpCo cash flow available for debt service 1,473,000 + RealCo net cash flow 126,928 + Northline net cash flow 106,600 + Marcus and Elena, net (390,800) + Diane, net (309,300) = Global cash flow available for debt service 1,006,428

Step 6 — Global debt service

Proposed term loan $4,200,000, 84 months, 7.75% monthly P&I $64,940 × 12 779,280 Existing OpCo equipment notes P&I (per debt schedule) 141,000 Revolver interest: $1,800,000 average × 7.25% 130,500 Plant mortgage — netted at Step 2 0 Northline equipment note — netted at Step 3 0 Household debt service — netted at Step 4 0 = Global debt service 1,050,780

Step 7 — The ratios

OpCo-only DSCR = 1,473,000 ÷ 1,050,780 = 1.40x Global DSCR = 1,006,428 ÷ 1,050,780 = 0.96x

The operating company covers 1.40x. The group covers 0.96x. The guarantors are a net drag of $700,100 — and no business-only spread would ever have shown it.

What the analysis then has to do. A 0.96x global does not automatically mean decline. It means the structure as requested does not work. Test the levers.

Lever one — term. Extend the term loan from 7 years to 10:

$4,200,000, 120 months, 7.75% → monthly P&I $50,405 × 12 = 604,860 Revised global debt service = 604,860 + 141,000 + 130,500 = 876,360 Revised global DSCR = 1,006,428 ÷ 876,360 = 1.15x

Lever two — the policy floor. At a 1.20x global floor:

Global cash flow required = 1.20 × 876,360 = 1,051,632 Available = 1,006,428 Shortfall = 45,204 Shortfall as % of requirement = 45,204 ÷ 1,051,632 = 4.3%

Ten years clears 1.15x and fails 1.20x by 4.3%. That is a sentence a committee can act on.

Lever three — whose household counts. Diane guarantees, but she owns 40%. Some policies weight a guarantor's household by ownership; some include only guarantors with an unlimited guaranty; some exclude households that are net negative. Exclude Diane entirely and:

Global cash flow = 1,006,428 + 309,300 = 1,315,728 Global DSCR = 1,315,728 ÷ 876,360 = 1.50x

0.96x, 1.15x, 1.50x — same borrower, same returns, three defensible conventions. Which is why the convention has to be written into credit policy rather than chosen file by file. The same problem in covenant definitions is worked through in covenant testing for DSCR and leverage, and the full family of DSCR variants in the DSCR formula and when each variant applies.

How much weight should guarantor support actually carry?

This is a credit-policy question, and the guidance gives you a frame rather than a number.

The OCC test is capacity and willingness. SR 23-5 adds that "an important consideration is whether any previous performance under its guarantee(s) was voluntary or the result of legal or other actions by the lender to enforce the guarantee(s)," and directs attention to "the total number and amount of guarantees currently extended by the guarantor."

A workable policy grid, and note that these weights are market conventions rather than requirements:

Guarantor profile

Typical weight on positive household cash flow

Note

Unlimited guaranty, majority owner, liquid, prior voluntary support

100%

Both OCC tests met

Unlimited guaranty, majority owner, illiquid, no support history

50-75%

Capacity untested

Limited guaranty capped at a dollar amount

Capped at the guaranty

Cannot contribute more than they owe

Minority owner, unlimited guaranty

100% or by ownership share

State which; do not switch between files

Guarantor whose household is net negative

100%, as a deduction

Asymmetry is the flaw to avoid

That last row is the one most policies get wrong. A policy that credits positive guarantor cash flow at 100% and excludes negative guarantor cash flow is not a policy; it is a bias. If Diane's household is excluded when it is negative, ask what you would have done had it been positive.

Two further disciplines worth writing down:

  1. Contingent liabilities are not optional. A guarantor supporting three other credits at other banks has committed the same net worth three times. Pull the personal financial statement, the credit report and the schedule of other guarantees, and reconcile them.
  2. Liquidity is a separate test from cash flow. A guarantor with negative annual household cash flow and $2.1m of unencumbered marketable securities is a different risk from one with neither. Global DSCR does not capture it; a global liquidity ratio and a covenant do.

What does this look like as a repeatable process?

  1. Draw the entity map and get it signed off before any spreading starts.
  2. Order 4506-C transcripts at intake and reconcile them to the returns you were handed.
  3. Spread each entity once, at the entity, and mark which lines are consequently zeroed on the personal returns.
  4. Identify and eliminate every intercompany flow — rent, management fees, intercompany notes.
  5. Net each entity's own debt service inside its own line, and record that you used the net convention.
  6. Build the household schedules from the 1040 and the personal financial statement, taxes and living expenses included.
  7. Compute business-only DSCR and global DSCR, then run at least two sensitivities and put the binding one in the memo.

For how this sits inside the wider file, see commercial loan underwriting in US banks; for the mechanics of the spreading step itself, what financial spreading is. Where the borrower is an SBA applicant, the programme layers additional documentation on top of all of this — set out in what SBA SOP 50 10 8 changes in the underwriting file.

A build like the one above touches five returns and roughly forty schedules. Done by hand it is a day, and the reason it is a day is not the arithmetic — it is finding the number and proving where it came from. YuSight's Financial Spreading module extracts each entity's financials with every figure traced to its source document and page, keeps the analyst's edits in version history, and carries the citations through into the CAM: the sample memo has 142 of them and drafts in 28 minutes.

FAQ

What is global cash flow analysis in commercial lending?

It is one combined statement of cash available for debt service across the operating company, its affiliates and its guarantors' households. You spread each entity once, eliminate intercompany flows, net each entity's own debt inside its own line, and divide the total by whatever debt service remains.

How do you treat guarantor personal income in global cash flow?

Only count what the guarantor actually receives in cash. Wages the business paid them are already in the business line if you added officer compensation back, so zero them at the household. K-1 income from an entity you spread separately gets zeroed too. What stays is outside wages, real distributions, recurring interest and dividends, and net rental after depreciation is added back and mortgage payments taken out.

What global DSCR do lenders require?

Most US bank credit policies set the floor somewhere between 1.15x and 1.25x, with 1.20x common for conventional term debt. There is no regulatory number for conventional lending. The SBA writes a floor of 1.1:1 for 7(a) Small Loans, which is a programme minimum rather than a prudent target.

Should the guarantor's income tax payment be deducted?

Yes, if you counted the income it was assessed on. Tax on pass-through income is a real cash cost of a closely held structure. What you must not do is deduct it twice — once as a distribution at the company and again as a tax payment at the household.

Do you include affiliate businesses the borrower does not guarantee?

Include them if the group controls them, because control means the cash and the debt both move. If the borrower holds a passive minority stake with no control, count only the distributions actually received and evidenced on a bank statement, and leave that entity's debt out of the denominator.

What living-expense figure should we use for a guarantor household?

Most banks apply a policy convention rather than reconstructing the household budget — a monthly floor per adult, or a percentage of gross income, whichever is higher. The number matters less than applying it consistently, because a convention that moves between files cannot be defended to an examiner or a credit committee.

How do you avoid double-counting owner distributions?

Decide where the dollar is earned and count it there only. If you spread the S corporation, the distribution is already inside that line — so zero the K-1 on Schedule E Part II. If you did not spread the entity, count the distribution at the household and nothing else.

Is global cash flow the same as global DSCR?

Global cash flow is the numerator; global DSCR is the ratio. Two lenders can compute identical global cash flow and report different global DSCRs because one nets entity-level debt service inside the numerator and the other puts all debt service in the denominator. State which convention you used.

How many years of returns do you need?

Three years of business returns and two of personal is the common standard, plus a current interim and a personal financial statement no older than about twelve months. Three years matters because it is the minimum that shows a trend rather than a snapshot.

Can global cash flow be automated?

The extraction and the arithmetic can be. The entity map, the add-back judgements and the guarantor weighting are credit decisions and should stay with the analyst. The useful test of any tool is whether a reviewer can click a number in the memo and land on the line of the return it came from.

Key takeaways

  • Draw the entity map first. Every double-count traces back to a map drawn after the spread.
  • Each dollar enters once, at the entity where it is earned. Zero the corresponding K-1 line on the personal return.
  • Deduct guarantor income tax and living expenses. A household that pays $268,000 in tax is not a neutral participant.
  • Add depreciation back and take maintenance capex out. Doing only the first is the most common overstatement in the file.
  • Weight guarantor support symmetrically. If negative households are excluded, positive ones cannot be credited at 100%.
  • Write the convention into policy and name it in the memo. The convention swung this file from 0.96x to 1.50x.

Watch YuSight spread a real balance sheet — bring a five-entity file with two 1040s and see the global cash flow built line by line, every figure traced to its page.

Stay Updated

Get the latest AI insights delivered to your inbox.

Product Brochure

A complete overview of YuVerse products, use cases, and capabilities.

Topics

global cash flow analysisglobal cash flow analysis softwareguarantor cash flowglobal DSCRpersonal cash flow analysis lendingK-1 cash flow analysis