| name | wayland-build-financial-model |
| description | Build a 3-statement financial model (P&L, Cash Flow, Balance Sheet) with explicit assumption blocks and sensitivity analysis. The agent infers the core assumptions that drive the model, builds a forward P&L month by month, ties in cash flow and balance sheet, then runs bear/base/bull sensitivity on the key variables.
Use when the user wants a structured multi-step process to produce a complete, assumption-driven 3-statement model with sensitivity analysis.
Do NOT use for a single number lookup, a one-line projection, or a question one atomic finance skill can answer. |
| license | Apache-2.0 |
| type | workflow |
| skills | pitch-fin-model finance-pl finance-cashflow finance-balance-sheet |
| metadata | {"author":"wayland","version":"1.0.0","tags":"finance modeling fundraising projections sensitivity step-by-step planning","category":"finance","depends":"pitch-fin-model finance-pl finance-cashflow finance-balance-sheet"} |
Build a Financial Model
Estimated time: 60-90 minutes
This workflow builds a 3-statement financial model with explicit assumptions and
sensitivity analysis. The arc is: gather the brief, infer the assumption blocks
that drive everything, build a forward P&L, tie in cash flow and balance sheet,
then run sensitivity (bear/base/bull) on the key assumptions. Review checkpoints
let the user refine the P&L assumptions, the tied statements, and the
sensitivity before shipping.
Generative steps are driven by pitch-fin-model (assumptions, sensitivity) and
the finance statement skills finance-pl, finance-cashflow, and
finance-balance-sheet.
Steps
Step 1: Kickoff and Brief (uses: pitch-fin-model)
Open the workflow and gather the brief. Ask the user for: business stage,
current revenue and burn, planning horizon (12 / 24 / 36 months), and any known
constraints or commitments. Explain that you will build a P&L, cash flow, and
balance sheet with assumption blocks and sensitivity. Do not proceed until you
have the stage, the numbers, and the horizon.
- Input: user-provided stage, current revenue/burn, planning horizon, constraints
- Output: a captured brief block
- Key focus: get the horizon and current run-rate numbers nailed down first
Step 2: Infer Assumption Blocks (uses: pitch-fin-model)
From the brief, infer the core assumption blocks: the variables that drive the
whole model (growth rate, CAC, churn, margins, hiring plan, etc.). Present the
inferred assumptions with reasoning and invite the user to override with what
they actually want to vary.
- Input: the brief from Step 1
- Output: the core assumption blocks, confirmed or overridden by the user
- Key focus: surface the few variables everything else depends on
Step 3: Build Forward P&L (uses: finance-pl)
Run finance-pl in forward-P&L mode using the brief and the confirmed
assumptions. Produce a month-by-month forward P&L with each assumption cited
inline so the user can trace any number back to its driver. Show the P&L.
- Input: the brief from Step 1, the assumption blocks from Step 2
- Output: a month-by-month forward P&L with inline assumption citations
- Key focus: every line traceable to an assumption; no unsourced numbers
Step 4: Review and Refine P&L (uses: finance-pl)
Present the forward P&L and ask the user to refine the assumptions or proceed to
cash flow and balance sheet. If they refine, re-run the P&L step with the prior
P&L plus feedback and the assumptions, then present again. Allow up to three
refinement passes.
- Input: the forward P&L from Step 3, user feedback, the assumption blocks
- Output: approved (possibly revised) forward P&L
- Key focus: lock the P&L assumptions before deriving the other statements
Step 5: Build Cash Flow (uses: finance-cashflow)
Run finance-cashflow in forward-cash-flow mode, deriving the cash flow
statement from the approved P&L and the assumptions. Account for timing
differences between revenue/expense recognition and cash movement.
- Input: the approved forward P&L from Step 4, the assumption blocks
- Output: a forward cash flow statement tied to the P&L
- Key focus: cash timing, not just accrual; reconcile to the P&L
Step 6: Build Balance Sheet (uses: finance-balance-sheet)
Run finance-balance-sheet to build the balance sheet from the P&L, the cash
flow, and the assumptions, so all three statements tie together (cash flows to
the cash line, retained earnings reflects cumulative net income, etc.). Show the
cash flow and balance sheet together.
- Input: the forward P&L, the cash flow from Step 5, the assumption blocks
- Output: a balance sheet that ties the three statements together
- Key focus: the three statements must reconcile, not just coexist
Step 7: Review and Refine Statements (uses: finance-balance-sheet)
Present the tied cash flow and balance sheet and ask the user to refine or
proceed to sensitivity. If they refine, re-run the balance-sheet step with the
prior balance sheet plus feedback, the P&L, and the cash flow, then present
again. Allow up to two refinement passes.
- Input: the balance sheet from Step 6, user feedback, the P&L, the cash flow
- Output: approved (possibly revised) tied statements
- Key focus: confirm the statements reconcile before stress-testing them
Step 8: Run Sensitivity Analysis (uses: pitch-fin-model)
Run pitch-fin-model in sensitivity-analysis mode over the three statements and
the assumptions. Produce bear / base / bull scenarios on the key assumptions,
showing how each scenario moves runway, revenue, and the bottom line. Show the
analysis.
- Input: the P&L, cash flow, balance sheet, and assumption blocks
- Output: bear / base / bull sensitivity on the key assumptions
- Key focus: vary the few assumptions that matter; show the impact on runway
Step 9: Final Review and Ship (uses: pitch-fin-model)
Present the sensitivity analysis and ask the user to ship the model or refine
the sensitivity. If they refine, re-run the sensitivity step with the prior
analysis plus feedback and the assumptions, then present again (up to two
passes). On ship, assemble the final model (assumptions, forward P&L, cash flow,
balance sheet, sensitivity) and output it.
- Input: the sensitivity analysis from Step 8, user decision
- Output: the assembled financial model
- Key focus: deliver a complete, reconciled, stress-tested model
Expected Outcome
A complete 3-statement financial model: explicit assumption blocks, a
month-by-month forward P&L, a reconciled cash flow and balance sheet, and a
bear/base/bull sensitivity analysis, assembled into one model package.
