Full Financial Planning Chain AI Prompt

Step 1: Business driver identification - identify the 5-8 key drivers that determine financial outcomes for this business. For each driver: current value, historical trend, and forecast assumption with rationale.
Step 2: Revenue model - build a bottom-up revenue model from the key drivers. Disaggregate revenue into its components (new business, existing customer growth, churn). Build three scenarios: base, bull, and bear.
Step 3: Cost model - forecast each major cost category as either a fixed cost, a variable cost tied to a revenue driver, or a headcount-driven cost. Identify operating leverage: at what revenue level does EBITDA turn positive or reach the target margin?
Step 4: Cash flow model - build the FCF model from EBITDA to free cash flow. Include working capital movements, capex, interest, and taxes. Compute cash runway under each scenario.
Step 5: Balance sheet build - project the balance sheet for each period. Verify it balances. Identify any periods where the company needs additional financing.
Step 6: Sensitivity and scenario analysis - build a tornado chart of the top inputs by impact. Create a 5x5 sensitivity table for the two most impactful inputs. Present the three scenarios with narrative.
Step 7: Management presentation - produce a one-page financial summary: revenue, EBITDA, and FCF for each period with actuals and forecast. Include key assumptions, risks, and the single most important financial question the team needs to answer in the next 90 days.