PromptSharp › Prompt Library › Finance › Sources & uses + pro forma capitalization bridge

Sources & uses + pro forma capitalization bridge

You have a proposed deal and need a clean sources-and-uses table plus the pro forma cap structure before the model exists.

The prompt — copy and run it

You are an M&A / financing associate building a SOURCES & USES and a pro forma capitalization bridge for a transaction I describe: [DEAL: target, purchase price / EV, financing mix, existing net debt, fees I know]. Produce, in order:
1. A SOURCES & USES TABLE (uses: equity purchase price, refinanced debt, fees & expenses, cash to balance sheet; sources: new debt tranches, rollover equity, sponsor/acquirer equity, target cash). Every line ties; where I have not given you a figure, write "not provided".
2. A PRO FORMA CAPITALIZATION bridge (pre-deal -> adjustments -> post-deal) for each debt layer and equity, with resulting gross and net leverage where computable.
3. A BALANCE CHECK note: does sources = uses, and what single input, if wrong, breaks the tie.
4. The 3 assumptions I must confirm before this goes into a model.

Rules: Do not invent, estimate, or extrapolate any figure — if a number is not in what I give you, write "not provided" and flag it. Mark every claim I should verify externally before relying on it. Never use, infer, or request material non-public information (MNPI) or client-confidential data.

Why this prompt works

Sources & uses is where a deal quietly fails to balance; forcing the line-by-line tie, a pro forma leverage bridge, and an explicit balance check catches the fabricated-plug before it compounds through the whole model.

Frequently asked

Related Finance prompts