3-Statement Financial Model
ForecastingSet a few assumptions and project a fully linked income statement, balance sheet, and cash flow three years out, monthly — the balance sheet balances automatically.
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.
5 years, built monthly · viewing annual · the download recomputes in Excel
Year 5 revenue
$2,509,617
Year 5 net income
$440,065
17.5% net margin
Ending cash
$890,499
Low point $123,706
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.
Working capital
Capex & financing
Opening balance sheet
Set the assumptions above and the three statements project forward, linked: net income flows to retained earnings, capex and depreciation roll the fixed assets, working-capital days drive A/R, inventory and A/P, and the cash-flow statement ties ending cash back to the balance sheet. Switch Monthly / Quarterly / Annual any time.
Income statement
| Line | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Revenue | $1,061,502 | $1,316,262 | $1,632,165 | $2,023,885 | $2,509,617 |
| Cost of sales | $424,601 | $526,505 | $652,866 | $809,554 | $1,003,847 |
| Gross profit | $636,901 | $789,757 | $979,299 | $1,214,331 | $1,505,770 |
| Operating expenses | $462,451 | $538,879 | $633,650 | $751,165 | $896,885 |
| EBITDA | $174,451 | $250,879 | $345,650 | $463,165 | $608,885 |
| Depreciation | $19,983 | $24,939 | $31,055 | $38,616 | $47,971 |
| Operating income (EBIT) | $154,467 | $225,939 | $314,594 | $424,550 | $560,914 |
| Interest | $12,510 | $10,350 | $8,190 | $6,030 | $3,870 |
| Pre-tax income | $141,957 | $215,589 | $306,404 | $418,520 | $557,044 |
| Taxes | $29,811 | $45,274 | $64,345 | $87,889 | $116,979 |
| Net income | $112,146 | $170,316 | $242,059 | $330,630 | $440,065 |
Balance sheet
| Line | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Assets | |||||
| Cash | $159,513 | $243,040 | $383,372 | $593,727 | $890,499 |
| Accounts receivable | $146,156 | $181,234 | $224,730 | $278,665 | $345,545 |
| Inventory | $38,975 | $48,329 | $59,928 | $74,311 | $92,145 |
| Net PP&E | $112,477 | $140,188 | $174,419 | $216,759 | $269,173 |
| Total assets | $457,121 | $612,791 | $842,449 | $1,163,462 | $1,597,362 |
| Liabilities & equity | |||||
| Accounts payable | $38,975 | $48,329 | $59,928 | $74,311 | $92,145 |
| Debt | $126,000 | $102,000 | $78,000 | $54,000 | $30,000 |
| Revolver | $0 | $0 | $0 | $0 | $0 |
| Paid-in capital | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 |
| Retained earnings | $192,146 | $362,462 | $604,521 | $935,152 | $1,375,217 |
| Total liab. & equity | $457,121 | $612,791 | $842,449 | $1,163,462 | $1,597,362 |
| Balance check (≈ 0) | $0 | $0 | -$0 | $0 | $0 |
Cash flow
| Line | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Cash from operations | $105,973 | $160,177 | $229,619 | $315,311 | $421,156 |
| Cash from investing | -$42,460 | -$52,650 | -$65,287 | -$80,955 | -$100,385 |
| Debt repayment | -$24,000 | -$24,000 | -$24,000 | -$24,000 | -$24,000 |
| Owner distributions | $0 | $0 | $0 | $0 | $0 |
| Revolver draw / (repay) | $0 | $0 | $0 | $0 | $0 |
| Cash from financing | -$24,000 | -$24,000 | -$24,000 | -$24,000 | -$24,000 |
| Net change in cash | $39,513 | $83,527 | $140,332 | $210,356 | $296,772 |
| Ending cash | $159,513 | $243,040 | $383,372 | $593,727 | $890,499 |
Want this on your real numbers? Wauvel builds it straight from your QuickBooks.
Meet your AI CFO →More free tools
Annual Operating Plan (AOP) Builder
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.
Open the tool →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 →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 →