Annual Operating Plan (AOP) Builder
ForecastingThe plan you set your year by: revenue, cost of sales, and operating expenses by category across twelve months — with gross profit and operating income falling out.
The plan you set the year by: revenue built up stream by stream, cost of sales, and operating expenses by category — twelve months across, with gross profit and operating income falling out for you.
12 months · totals are live
Annual revenue
$1,196,617
Operating income
$67,618
5.7% operating margin
Gross margin
64.5%
$772,134 gross profit
Build your year month by month. Edit any cell, rename or add lines, or use the fill icon beside a line to copy Jan across the rest. Enter a cost in dollars, or flip it to a % of revenue with the $ / % switch — the dollars fall out automatically. Switch Monthly / Quarterly any time — your numbers carry over. The download recomputes in Excel.
Best built on a bigger screen
This is a wide, multi-period grid — open it on a laptop or desktop to edit it comfortably. You can still download the Excel below and build it there.
| Line | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | FY total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | |||||||||||||
| $901,549 | |||||||||||||
| $295,068 | |||||||||||||
| Total revenue | $82,000 | $84,840 | $87,785 | $90,839 | $94,006 | $97,289 | $100,695 | $104,227 | $107,891 | $111,691 | $115,633 | $119,721 | $1,196,617 |
| Cost of sales | |||||||||||||
| $360,620 | |||||||||||||
| $63,863 | |||||||||||||
| Gross profit | $53,500 | $55,245 | $57,053 | $58,925 | $60,864 | $62,872 | $64,954 | $67,111 | $69,345 | $71,661 | $74,059 | $76,545 | $772,134 |
| Operating expenses | |||||||||||||
| $429,188 | |||||||||||||
| $127,728 | |||||||||||||
| $72,000 | |||||||||||||
| $33,600 | |||||||||||||
| $42,000 | |||||||||||||
| Total operating expenses | $53,300 | $54,210 | $55,141 | $56,094 | $57,068 | $58,064 | $59,083 | $60,127 | $61,194 | $62,286 | $63,403 | $64,546 | $704,516 |
| Operating income | $200 | $1,035 | $1,912 | $2,831 | $3,796 | $4,808 | $5,871 | $6,984 | $8,151 | $9,375 | $10,656 | $11,999 | $67,618 |
Want this on your real numbers? Wauvel builds it straight from your QuickBooks.
Meet your AI CFO →More free tools
Recurring Revenue Model (SaaS / Subscriptions)
Build a subscription revenue forecast the way investors read it: new customers, ARPA, churn, and expansion drive a monthly MRR/ARR build, with the new → expansion → churn bridge tying out automatically. Industry presets for SaaS, memberships, subscription boxes, and retainers.
Open the tool →Capacity & Utilization Revenue Model
Forecast revenue for a capacity business: units × sellable slots × utilization × price, plus ancillary revenue. Industry presets for salons, restaurants, hotels, clinics, trucking/fleet, and professional services — tune capacity, occupancy, and rate and watch revenue (and RevPAR-style yield) build month by month.
Open the tool →Funnel / Transaction Revenue Model
Forecast a paid-acquisition business: spend → sessions → orders → revenue, with returns, repeat purchases, CAC, and contribution. Industry presets for ecommerce/DTC, marketplaces (take rate), and lead generation — see how spend and conversion translate into revenue month by month.
Open the tool →3-Statement Financial Model
Set a handful of assumptions — growth, margins, working-capital days, capex, financing — and project a fully linked income statement, balance sheet, and cash flow three years out, monthly. The balance sheet balances and cash ties, automatically.
Open the tool →13-Week Cash Flow Forecast
The rolling weekly forecast every CFO keeps: beginning balance, money in, money out, and the projected low point that tells you exactly when cash gets tight.
Open the tool →Cash Runway Calculator
How many months of cash you have — counted the way a CFO would. Set your cash on hand, what you collect, and your monthly burn, and it solves runway both ways: the flat-burn number, and the honest one that grows burn and collections forward to the month cash actually hits zero — or shows you're default alive. Then it prices the levers: trim burn, collect faster, and watch the runway move.
Open the tool →Budget vs. Actual (Monthly P&L)
A month's P&L with plan set beside reality and the variance computed for you — so every number turns into feedback instead of weather.
Open the tool →Unit Economics Calculator (by business model)
What one order, subscription, billable hour, or cover actually earns — the profit hiding in a single sale that your P&L nets away and QuickBooks won't break out. Switch between D2C, SaaS, services, and restaurant models and it resolves the three-margin ladder (gross → contribution → net) plus the reads each model lives by: CAC payback, LTV:CAC, break-even utilization, prime cost, and break-even covers. Download a branded Excel where every result is a live formula off your inputs.
Open the tool →CAC & LTV Calculator (Ecommerce Unit Economics)
The number every ecommerce founder needs and the books can't give you: how much you can afford to pay for a customer. Set your order value, margin, and repeat rate against your ad spend, and it solves CAC, a contribution-based LTV, the LTV:CAC ratio, payback period, break-even ROAS, and your maximum profitable CAC — with a sensitivity table showing how the ratio and payback move as CAC changes. Built for DTC and online stores.
Open the tool →Break-Even & Contribution Margin Calculator
The number every owner should know: how much you have to sell to cover your costs. Set price, variable cost, and your fixed costs, and it solves break-even in units and revenue — then shows your margin of safety, the volume to hit a profit target, and how break-even moves when you change price.
Open the tool →Price / Volume / Mix Bridge
Revenue or margin moved — but why? Enter what you sold in two periods, line by line, and it splits the change into the three things that actually cause it: price (you charged more or less), volume (you sold more or fewer units), and mix (you sold a different blend of products). Add unit costs and it does the same for gross profit, isolating a cost effect too. New and dropped lines are handled cleanly, the bridge always ties out to the penny, and the download recomputes every effect as a live Excel formula. The decomposition QuickBooks won't do for you.
Open the tool →Financial Health KPI Tracker
The vital signs on one page — margins, current ratio, days-to-get-paid, the cash conversion cycle, runway — tracked month over month with the formulas already in.
Open the tool →