Chapter 245

Financial Modeling Assistance

0 min read

The CFO Co-Pilot

```text "Build a financial model for [business type] with these parameters:

REVENUE MODEL - Pricing: $[X] per [unit/month/user] - Growth rate: [X]% monthly - Churn rate: [X]% - Expansion revenue: [X]%

COST STRUCTURE - COGS: [X]% of revenue - Fixed costs: $[X] monthly - Variable costs: [breakdown] - Customer acquisition cost: $[X]

CREATE: 1. Monthly cash flow projection (24 months) 2. Cohort analysis model 3. Unit economics breakdown 4. Sensitivity analysis (±20% on key variables) 5. Scenario planning (best/expected/worst case)

Include formulas and assumptions for each calculation." ```text

Advanced Financial Analysis

```text "Perform advanced financial analysis:

1. VALUATION ANALYSIS - DCF model with assumptions - Comparable company analysis - Revenue multiple justification - Exit scenario modeling

2. FUNDING STRATEGY - Optimal funding rounds - Dilution analysis - Use of proceeds optimization - Investor ROI projections

3. METRICS DASHBOARD - Key performance indicators - Leading vs lagging indicators - Benchmark comparisons - Alert thresholds

4. RISK MODELING - Monte Carlo simulation approach - Stress test scenarios - Break-even sensitivity - Runway calculations

Present in executive-ready format." ```text