Uptiq's Underwriting Superagent builds the entity map from the documents in the credit file, spreads every entity and guarantor return, applies your elimination rules, and produces a global cash flow where each dollar is counted exactly once.
36% reduction in spreading and extraction time. Every figure — and every elimination — cited back to the return it came from.
Entity map is built from the returns, K-1s and statements supplied in the credit file.
Reduction in spreading and extraction time
Extraction accuracy, certified by former underwriters
Reduction in underwriting cycle time
More deals per underwriter
Closely held borrowers rarely arrive as one entity. There is an operating company, a real estate entity holding the building it occupies, a second operating company at a partial interest, and an owner whose personal return carries all of it. Global cash flow is where that structure has to be reconciled — and it is where the underwriting week goes.
Each analyst builds a one-off workbook: tabs per entity, hand-keyed returns, manual eliminations. It works once, for one deal, and cannot be reviewed by anyone who did not build it.
Ops persona: portfolio reporting done in Excel, rebuilt every cycle
Count owner distributions and entity income both and coverage is overstated. Eliminate too conservatively and a sound credit fails the test. The answer changes with whoever built the model.
Same relationship, two analysts, two global DSCRs
A K-1 references an entity nobody collected returns for. It is found mid-underwriting, the document request reopens, and the deal loses a cycle to a structure that was always there.
“minimal touch points” — Head of Lending
The Underwriting Superagent reads the whole credit file rather than one entity at a time. It assembles the ownership structure from the returns and K-1s in front of it, spreads each entity, brings the guarantor's personal position in, and applies your elimination rules consistently — showing the working, not just the answer.
36% off spreading and extraction time, on the analysis that usually holds a closely held deal the longest.
The same elimination rules on every relationship, so global DSCR is comparable deal to deal and analyst to analyst.
Each elimination appears as its own line with a citation, so review and examination can follow the logic rather than trust the model.
Entities referenced in the returns but missing from the file are flagged early, instead of reopening the document request mid-underwriting.
Global cash flow is a counting discipline before it is a calculation. Below is the treatment most institutions apply — and the treatment the agent applies is whichever one your credit policy specifies.
| Line | Source | Treatment |
|---|---|---|
| Tier 1 — Borrowing entity | ||
| Operating cash flow / EBITDA | Business return, interim statements | Counted in full |
| Existing debt service | Entity debt schedule | Counted in full |
| Proposed facility debt service | Term sheet | Counted in full |
| Tier 2 — Affiliated and related entities | ||
| Real estate entity net operating income | Partnership return, rent roll, leases | At ownership % |
| Affiliate operating cash flow | Affiliate return and K-1 | At ownership % |
| Rent paid by operating co. to related entity | Both entities' returns | Eliminated |
| Management fees between affiliates | Both entities' returns | Eliminated |
| Intercompany loans and advances | Balance sheets, debt schedules | Eliminated |
| Affiliate debt service | Affiliate debt schedules | At ownership % |
| Tier 3 — Guarantor personal | ||
| Wages and salary | Form 1040, W-2 | Counted in full |
| Pass-through income allocated on K-1 | K-1 schedules | To distributions only |
| Distributions from the borrowing entity | Entity return, K-1 | Eliminated |
| Schedule E rental income | Form 1040 Schedule E | Net of Tier 2 |
| Personal debt service | Personal financial statement, credit report | Counted in full |
| Living expenses and personal tax burden | Policy estimate or documented | Deducted |
| Tier 4 — Contingent | ||
| Guarantees on other entities' debt | Personal financial statement, agreements | Disclosed & stressed |
Illustrative treatment. Combination basis, elimination rules, living expense assumptions, contingent liability stress levels and your minimum global coverage threshold are all configured to your credit policy.
Assembles the ownership structure and percentages from the returns, K-1s and statements supplied, and flags entities referenced but not yet collected.
Spreads business returns, partnership returns, interim statements and personal returns into one comparable structure at 95%+ extraction accuracy.
Rent, management fees, distributions and intercompany advances handled under your methodology, not a vendor default.
Affiliates consolidated at ownership percentage or in full, per entity, according to how your policy treats control and support.
Allocated income, distributed cash and recognised amount shown as separate lines so the difference is explicit rather than assumed.
Wages, Schedule E positions, personal debt service and living expense treatment folded into the global position under your assumptions.
Every input and every elimination traces to the return, schedule and page it came from, with timestamps retained for review.
Guarantees on other obligations are surfaced from the personal financial statement and stressed at the level your policy sets.
100+ native integrations across cores, loan origination systems and document repositories. Private-cloud deployment available.
Five steps, run the same way on every closely held relationship.
The agent reads the returns, K-1s, personal financial statement and entity documents in the file, identifies each entity and its ownership percentage, and flags any entity referenced in those documents that has not been collected.
Business, partnership and personal returns are spread into one comparable structure, with each line tied to the schedule and page it came from.
Affiliates are combined in full or at ownership percentage per your policy, and intercompany rent, management fees, distributions and advances are eliminated so each dollar is counted once.
Global cash flow and global DSCR are produced against all obligations the group carries, with contingent guarantees disclosed and stressed at your policy level.
The global cash flow section drops into the credit memo in your house structure, with the entity map, the eliminations and the citations attached for review.
Global cash flow analysis combines the cash flow of the borrowing entity, its affiliated and related entities, and the personal cash flow of the guarantors into a single consolidated view of debt service capacity for the whole relationship. It is used when a business is closely held and the owner's personal finances, other operating companies and real estate holding entities are financially intertwined with the borrower, so that entity-level coverage alone would misstate the true capacity to repay.
Entity-level DSCR measures the borrowing entity's cash flow against its own debt service. Global DSCR measures the combined cash flow of the borrower, the related entities and the guarantors against all of the debt service that group is responsible for, including guarantor personal debt and obligations at affiliated entities. Because both the income and the debt sides expand, global DSCR can be materially higher or lower than entity-level coverage depending on whether the affiliates and the owner are net contributors or net consumers of cash.
Cash that moves between entities inside the relationship is eliminated so each dollar is counted once. The common eliminations are owner distributions from the operating company, which already appear in that entity's cash flow before they reach the guarantor's return; rent paid by the operating company to a related real estate holding entity, which is an expense in one entity and income in the other; management fees between affiliates; and intercompany loans and advances. Uptiq applies your institution's elimination methodology and shows each elimination as a line item rather than netting it silently.
A complete global cash flow typically requires business tax returns for the borrower and each related entity, the K-1 schedules that identify ownership and pass-through income, interim financial statements, a debt schedule for every entity, the guarantors' personal tax returns including Schedule E, a personal financial statement listing assets, liabilities and contingent obligations, and supporting documents such as rent rolls, leases and appraisals where real estate is involved.
K-1 income is an allocation of taxable income to an owner, not evidence that cash was received. A pass-through entity can allocate substantial income while distributing little or nothing, leaving the owner with a tax liability and no cash. Most institutions therefore recognise pass-through income only to the extent of actual distributions evidenced on the return or in the entity's records. Uptiq applies whichever treatment your credit policy specifies and shows the allocated amount, the distributed amount and the amount recognised as separate lines.
Yes. Consolidation rules are configured to your credit policy: whether affiliates are combined in full or at ownership percentage, how distributions and intercompany rent are eliminated, how living expenses and personal tax burden are estimated, which contingent liabilities are stressed and at what level, and what your minimum global coverage threshold is. The agent produces the analysis under your methodology rather than a vendor default, and every rule applied is visible in the output.
Send a redacted file for a closely held borrower — multiple entities, a real estate affiliate, a guarantor with Schedule E positions. We will run the global cash flow and show you the entity map, the eliminations and the citations behind the number.
Tell us how your team handles related-entity consolidation today and where the global cash flow takes the longest. We will show you the agent running that structure.
Typical first agent: live in production in as little as five business days.
