Prompt to build a Standard Financial Model
A full operating model, built in four checked stages: revenue engine, hiring plan, statements, metrics. Paste the prompt into Claude, ChatGPT or Gemini, answer its questions, and it builds the workbook with the same structure as my Standard Financial Model.
Or get the finished model

Standard Financial Model
Built and tested, for Excel and Google Sheets. $199 suggested, pay what you want.
How to use it
You need an AI that hands back a real spreadsheet file, not a description of one. Here’s where that lives in each:
- Claude creates .xlsx files on every plan, free included, and it’s on by default. If it only describes the workbook, open Settings, then Capabilities, and turn on “Code execution and file creation” (called “Create and edit files” in newer versions). On a Team or Enterprise plan your admin controls it.
- ChatGPT has no switch to find. Ask for the workbook as an .xlsx file and it gives you a download link. A paid plan copes better with a model this size.
- Gemini builds working spreadsheets inside Google Sheets: open a blank sheet, click the Gemini icon in the side panel and paste the prompt there. That needs a Google AI Pro or Ultra plan or a Workspace plan with Gemini.
The prompt opens with a few questions about your business. Answer them, or tell it to use the defaults and see the model working before you put your own numbers in.
When it’s done, open the workbook and read the model checks before you trust a number. An AI that builds a model from a prompt still makes mistakes, and the checks are there to catch them. If you want a second pair of eyes on it, that’s what a working session is for.
The prompt
You are an experienced startup CFO and financial modeler. Build me a complete monthly operating model for my company in a spreadsheet: a revenue engine, a hiring plan, driver-based expenses, three linked financial statements, and the metrics and reports an investor will ask for. This is a large model, so build it in four stages. At the end of each stage, stop, show me the stage's checks and headline numbers, and wait for me to say "continue" before starting the next.
## Before you build
Ask me these questions first, in one message, and wait for my answers. If I say "use the defaults", use the defaults below.
1. What's the business model: recurring subscriptions, ecommerce, a marketplace, advertising, financial services, or a top-down market share forecast?
2. How do customers find you (organic and viral, paid acquisition, an outbound sales team), and what does it take to convert one into a paying customer?
3. Do you sell to more than one segment with different pricing or churn?
4. Who's on the team today and who do you plan to hire, when, at what salary?
5. How much cash do you have, and what are you raising?
6. Do you have historical actuals you want to enter alongside the forecast?
## Workbook structure
Get Started, Revenues, Hiring Plan, Forecast, Statements, Summary, Key Metrics, Unit Economics, Budget, Key Reports. Every sheet with a timeline uses the same monthly columns.
## Stage 1: Get Started and the revenue engine
**Get Started** holds every global input:
| Section | Input | Default |
| --- | --- | --- |
| Setup | Company name, currency symbol | Company, $ |
| | Months in the model | 72 |
| | First month, fiscal year end month | Jan of next year, December |
| Revenue | Growth metric name, revenue metric name | Growth Units, Revenue Units |
| | Revenue model (dropdown: recurring, ecommerce, marketplace, advertising, financial services, top down) | recurring |
| | New growth units in month 1, growth start month | 100, month 1 |
| | Initial monthly growth rate, and monthly change in that rate | 10%, −5% |
| | Viral coefficient (new units each unit brings in) | 1.2 |
| | Cost per paid growth unit, % acquired through paid | $0, 0% |
| | Use an outbound sales team (yes or no) | no |
| | Conversion rate from growth unit to revenue unit, and conversion lag in months | 10%, 0 |
| Segments (two columns) | Segment name | Segment 1, Segment 2 |
| | % of new revenue units to each segment | 50%, 50% |
| | Churn per churn period, churn period in months | 10%, 1 |
| | Starting revenue units | 0 |
| | Average revenue per unit | $10 |
| | Billing period in months, % billed upfront | 1, 100% |
| Seasonality | % change for each calendar month (sums to 0) | 0% each |
**Revenues** builds, per segment:
- Growth units: new units each month from the growth rate (which changes by its own percent each month), plus viral units, plus paid units, plus units from ramped outbound sales staff if switched on (new sales hires per month, ramp months, units per ramped person). Include a manual adjustment row I can type into.
- Conversion: revenue units converted from growth units after the lag, split across segments.
- A retention cohort grid: one row per monthly cohort, tracking how many revenue units remain after churn at each churn period.
- Revenue for the selected model type. Recurring: active units × revenue per unit, with billings on the billing period. Ecommerce: orders × order value. Marketplace: GMV × take rate. Advertising: impressions × CPM. Financial services: balances × yield. Top down: market size × share. Only the selected type's rows feed the Forecast.
- MRR build for recurring models: new, expansion, churned and ending MRR.
Stage 1 checks: units never go negative, segment shares sum to 100%, seasonality sums to 0%, and the cohort grid totals equal active units.
## Stage 2: Hiring Plan and Forecast
**Hiring Plan**: one row per role with name or title, category (R&D, Sales, G&A, Other SG&A), segment, start month, end month (optional), annual salary, annual raise %, and benefits and payroll tax as % of salary. Monthly salary cost from start to end month. Outbound sales staff come from the Revenues sheet. Start with a CEO row and 30 empty rows.
**Forecast**: every other line as a driver row. Columns: label, notes, category, segment, then drivers (initial value; starts in month; repeats every N months; changing based on: none, % change, # change, % of another row, # per another row; changes every N months; change amount; driver row label looked up with INDEX/MATCH; maximum months; maximum value; use seasonality), then the monthly columns, all one copied formula.
Sections: operating metrics pulled from Revenues and the Hiring Plan; fundraising (three equity or SAFE rows); revenue and billings from Revenues plus one manual revenue row; salaries and benefits by category from the Hiring Plan; acquisition and retention costs from Revenues; cost of sales and operating expenses as driver rows.
Then, all formulas:
- Forecast by category (SUMIFS on the category column).
- Actuals by category: a block of the same shape where I can type historical actuals.
- Actuals plus forecast: actuals where a month has them, forecast otherwise. This block feeds the statements.
- Schedules: revenue recognition and deferred revenue, accounts receivable, depreciation and amortization, debt (annual rate, term, interest-only months), corporate tax and VAT, inventory if used.
Stage 2 checks: every driver row has a category; category totals equal the sum of the rows; no month has both an actual and a forecast counted.
## Stage 3: Statements
**Statements**, stacked on one sheet: income statement (revenue and growth, cost of sales, gross margin, SG&A by category, EBITDA, depreciation, amortization, interest income and expense, other, EBT, taxes, net income), balance sheet (cash, receivables, inventory, prepaid, PP&E net, other assets; payables, accrued, deferred revenue, taxes and VAT payable, working capital line; SAFEs and notes, debt, accrued interest; equity investment, SAFE investment, retained earnings, net income) and cash flow statement (operations with working capital changes, investing, financing, net cash flow, cash at the end).
Stage 3 checks: the balance sheet balances every month; cash at the end on the cash flow equals cash on the balance sheet; cash stays above zero (report the first month it doesn't).
## Stage 4: Metrics and reports
- **Summary**: the statements by fiscal year with SUMIFS, year-end balances for the balance sheet, Y/Y growth and % of revenue.
- **Key Metrics** by year: ARR build (beginning, new, expansion, churn, ending), net new ARR, ARR per employee, magic number, rule of 40, CAC (paid and blended), CAC payback, LTV and LTV ÷ CAC, burn multiple, months of runway.
- **Unit Economics**: per-unit LTV, CAC and payback from the Get Started inputs, with a monthly per-unit cash flow that builds the LTV.
- **Budget**: budget versus actuals for a month range I choose, with variance in dollars and percent.
- **Valuation**: a DCF on free cash flow (discount rate 8%, long-term growth 4%) and a multiple of revenue or EBITDA, blended by a weight input.
- **Key Reports**: charts only, for revenue and growth, burn and cash, headcount, ARR, and gross margin.
Stage 4 checks: annual totals equal the sum of their months; the valuation inputs produce a positive terminal value (discount rate above growth).
## How the workbook should look and behave
These are my house rules for spreadsheets. Follow all of them.
- Use Arial 12 everywhere, including the workbook's default style. Never Calibri.
- Inputs are blue text (#0000FF) on a light grey fill (#F2F2F2), so they read like form fields. Calculations are black text with no fill. Never use grey text anywhere.
- Every sheet leaves column A blank and narrow. The model starts in column B.
- Column B holds row labels. Column C is a narrow Notes column, about half the width of the label column, holding a short note on what the row is or where it comes from. Let notes clip rather than wrap. Values, or the first period of a timeline, start after the notes column.
- No cell comments. Notes go in the notes column.
- Turn gridlines off on every sheet. Freeze panes on the header rows only, never on columns.
- No borders at all, not even header underlines or subtotal rules. Blank rows and bold text carry the structure.
- Every calculated number is a live formula that traces back to an input. Never type a number into a calculation cell, and never mix typed values and formulas in the same row.
- Keep the number of sheets low. Sheets that share a timeline use the same columns, so a given column is the same month on every sheet.
- Format currency with thousands separators and no decimals, percentages with one decimal place, and dates as "mmm yyyy".
- Name rows in plain words a founder or investor would use, with units in the label where it helps ("Churn per contract cycle, %").
## When you're done
- Recalculate and confirm there are no errors (#REF!, #DIV/0!, #VALUE!, #N/A) and no circular references unless I asked for one.
- Show me the results of the model checks and the headline outputs.
- List every assumption you made that I didn't give you, and the three inputs I should change first.
- If you can't produce an .xlsx file, give me each sheet as a table with the exact label, input value or formula in every cell, so I can rebuild it in Excel or Google Sheets without guessing.