Real workflows
Pull these up when you have a real deal or portfolio task in front of you. These aren’t before/after snippets — they’re full sequences. You drive; the AI absorbs everything around the work so that when you write, every piece of context is at your fingertips. The example deals are fake; the structure is exactly what you’d run tomorrow.
Use AI as a reasoning partner, not a ghostwriter. It does the slow synthesis. You keep the judgment — and the judgment is what your job is.
From CIM to IC memo
A teaser lands. Then a CIM, a model, management calls, notes, and finally a draft memo. It used to take a week of grinding — 25 to 30 hours. With AI as your reasoning partner it takes about four hours of focused work across two days, and the result is better, not worse. Written for Copilot with Notebooks (where most firms live); Claude/ChatGPT notes where it matters.
The setup 15 min · once per deal
Build the workspace before you write a single prompt. Create a Copilot Notebook named for the deal — Project Aurora — and add every document you have: teaser, CIM, preliminary model, management deck, sector research, your call notes. Add a context page with your About-me block plus three deal-specific lines:
- My role on this deal: [originator / lead / supporting analyst].
- My PM is [name] and cares most about [the two or three things they consistently flag].
- Our hold size would be ~[$X]M in [unitranche / first lien / second lien].
Run the Overview and read it. It’s not your work product — it’s a first pass at what the materials collectively say. Note anything that surprises you; that’s where the interesting questions live. (No Notebooks? Open one chat and keep it open across the steps — it’s just less powerful.)
Step 1 — The 20-minute read 20 min
Come out knowing what the deal is, in your own words, before spending real time.
1.1 · Plain English
1.2 · The thesis, de-spun
1.3 · Five curiosities
Save the output as 01 — The Deal in Plain English. You’ll return to it when writing the memo.
Step 2 — Quantitative hunt 30 min
Make Copilot do the slow, boring part: pulling every number that matters into tables you can compare.
2.1 · Market claims
2.2 · Customer data
2.3 · EBITDA bridge
Go back to the CIM and confirm three of the figures against the page reference — not because Copilot is unreliable, but because you need to be the one who’s touched the numbers when your IC asks.
Step 3 — Walk through the model 45 min Excel Copilot
Open the sponsor’s preliminary model and click the Copilot button.
3.1–3.3 · Structure, drivers, margins
3.4 · Stress test
3.5 · One structural flaw
No Excel Copilot? Identify the key assumptions manually, then describe them in Claude/ChatGPT and run the stress logic in text. Slower; same thinking.
Step 4 — The risk inventory 45 min
Now the work that justifies your role. The AI generates the inventory; you decide what matters.
4.1 · Ten risks, ranked
4.2 · The skeptical PM
4.3 · What’s missing
Pick the three risks you’ll lead with. Criteria: materiality if it goes wrong, how hard it is to mitigate, how clearly your IC will care. Write the three down with one sentence each on why it made the cut. Save as 04 — Risk Lead.
Step 5 — Management meeting question set 20 min
5.1 · Question set on the lead risks
Save as 05 — Management Q Set. One of the highest-leverage uses of AI in the whole workflow.
Step 6 — After the management call 30 min
You ran the call and took notes (Teams Copilot transcribed them — even better). Now process what you heard.
6.1–6.4 · Summarize, grade, update, follow up
Save as 06 — Post-Mgmt Read.
Step 7 — First draft of the memo 45 min
By now you’ve done four hours of structured work and the notebook is rich with context. This is why the draft is dramatically better than a cold prompt.
7.1 · Draft the memo
7.2–7.3 · Self-critique & rewrite
Step 8 — Your edit 60 min
The AI got you 60% there. The remaining 40% is the part that makes the memo yours and demonstrates why you have the job.
- Read it out loud. Any sentence that could have been written by anyone — rewrite it.
- Check every number against source. Trust no figure you haven’t personally verified at least once.
- Add the one or two things only you know — a texture from the call, a read on the sponsor, the thing your PM mentioned offhand. This is your value-add.
- Cut the hedging. Kill “potentially,” “may,” “could be,” “we believe.” Be willing to be wrong on the record.
- One final adversarial pass. “You are the most skeptical PM at my firm. Read this and tell me the three questions you’d ask first.” Add the answers if they’re not already there.
A memo presentable to your IC tomorrow, that you can defend line by line, produced in roughly four hours instead of a week. First time it feels slow and weird. Second time, obvious. Third time, it’s the way you were always supposed to work.
Quarterly portfolio monitoring
Different shape, same mindset. Every quarter, each name in your book throws off a compliance certificate, financials, maybe a borrower deck and a management call. Multiply by a dozen companies and monitoring quietly eats your month. This is exactly the repetitive, context-heavy synthesis AI is built for — done well, a name goes from a pile of PDFs to a PM-ready read in about 45 minutes. Written for Copilot; the logic ports to Claude/ChatGPT for anonymized practice.
The setup 10 min · once per company
Keep one Copilot Notebook (or OneNote section) per portfolio company — your standing file. In it: the original investment thesis and base-case numbers, the covenant definitions and levels, last quarter’s summary, and the current watch-list status. You build it once; every quarter you just add the new materials and the context is already there.
Step 1 — Assemble the quarter 5 min
Drop this quarter’s materials into the notebook: the compliance certificate, the quarterly financials (P&L, balance sheet, cash flow), any borrower or sponsor update deck, your call notes, and any relevant news. Then orient yourself.
1.1 · The quarter in five bullets
Step 2 — Numbers vs. last quarter and vs. thesis 10 min
2.1 · Trend table
2.2 · Vs. the original thesis
Step 3 — Covenant compliance & headroom 10 min
3.1 · Recompute the covenants
Recompute at least the leverage covenant by hand. The compliance certificate is the borrower’s arithmetic — your job is to confirm it, especially how add-backs feed the EBITDA definition.
Step 4 — Liquidity & early warnings 5 min
4.1 · Runway and red flags
Step 5 — The watch-list call 5 min
5.1 · Rating and rationale
The rating call is yours. The AI gives you both sides; you decide, because you’re the one who’ll defend it. Write the call and one sentence of why.
Step 6 — Draft the PM update 5 min
6.1 · Two paragraphs, one thing that matters
Step 7 — Your edit & escalation 5 min
- Verify the covenant math and the liquidity figure against source. These are the numbers your PM will react to.
- Add what only you know — tone from the management call, a sponsor signal, something a peer mentioned about the sector.
- Make the escalation call. If anything here would change how the firm thinks about this name — a covenant trending toward breach, a liquidity squeeze — say so plainly and recommend the action. Don’t bury it.
A defensible, numbers-checked quarterly read and a PM-ready update in under an hour — for work that used to swallow an afternoon per name. Run it the same way across the book and you’re the analyst whose portfolio reviews are never the bottleneck.
Don’t run a whole workflow cold. Pick the next real task on your desk — a CIM that just landed, or a portfolio name due for review — and run just the first two or three steps. Build the workspace, get the plain-English read, do the quant hunt. You’ll feel the difference before you’re halfway through.