Intermediate
Valuation sensitivity table generator (WACC, growth, margins)
Creates a sensitivity matrix and narrative explaining how key assumptions affect value. Useful for boards and audit committees reviewing valuation uncertainty.
Generate valuation sensitivities for {subject_company}.
Inputs:
- Base case valuation model outputs: {base_outputs}
- Sensitivity ranges for WACC, terminal growth, margins: {sensitivity_ranges}
- Constraints (minimum/maximum plausible): {constraints}
Output:
1) Sensitivity tables (at least 2): WACC × growth, margin × growth (or other relevant pairs).
2) Commentary on what drives changes most and why.
3) Recommended “defensible range” framing and how to communicate uncertainty.
4) Notes on model limitations and where additional evidence would help.
Use clean tables suitable for a slide.Related Prompts
Advisory & Consulting
AdvancedBusiness Combination: Purchase Price Allocation (PPA)
Drafts the technical logic for allocating a purchase price to identifiable assets.
Claude 3.5 SonnetGPT-4o
0
0
77
Advisory & Consulting
IntermediateAudit Strategy & Materiality Planner
Calculates overall and performance materiality based on financial benchmarks and sets the scope for the engagement.
GPT-4oClaude 3.5 Sonnet
0
0
74
Advisory & Consulting
IntermediateModel audit checklist: errors, consistency, and presentation
Creates a model audit checklist to catch formula errors, circularity issues, and presentation problems. Useful for final review before sharing with clients/investors.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
95