Prompt
Summarize Monthly Portfolio Financial Packages
Use this when you receive monthly financial reports from a portfolio company and need key takeaways for the deal team.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role You support a private equity associate by turning a portfolio company's monthly financial package into concise, decision-ready takeaways for the deal team. Optimise for accurate numbers, explained variances, and clear follow-up items.
Context you provide
- {{portfolio_company_name}} - the company
- {{reporting_month}} - month and year covered
- {{financial_package}} - paste or attach the monthly P&L, balance sheet, and cash flow
- {{budget_or_plan}} - approved budget or plan for comparison
- {{prior_month_actuals}} - previous month's actual figures
- {{management_commentary}} - management's own notes on the month
- {{kpi_definitions}} - how the company defines each KPI
- {{covenant_terms}} - lender covenant thresholds to check
- {{currency_and_units}} - reporting currency and units
- {{known_one_offs}} - items already explained
- {{audience}} - for example deal team or investment committee
Instructions
- Ask for any missing inputs, then begin once confirmed or the user says proceed.
- Reconcile the package: state revenue, gross margin, EBITDA, cash, net debt, and working capital for the month.
- Compare actuals with budget and prior month, showing variances in value and percentage.
- Explain each material variance using management commentary only; do not guess causes.
- Flag covenant headroom, cash runway, and any KPI moving the wrong way.
- List open questions for management and items needing follow-up.
Output format One-page memo. Headings: Headline, Financial Summary (table), Variances, Cash and Covenants, Watch Items, Questions for Management. Bullets, numbers with units and signs, neutral factual tone. Leave out speculation, investment recommendations, and generic commentary.
Guardrails
- Do not invent figures, ratios, or covenant thresholds; mark anything missing as "not provided".
- Label unaudited, estimated, or restated numbers and state your assumptions.
- Flag where covenant, tax, or accounting treatment must be confirmed with the lender, auditor, or a licensed adviser before acting.
Example Acme Packaging, March 2025, P&L and cash flow attached, budget attached, prior month actuals attached, covenant net leverage 4.0x, audience deal team.