Rolling forecast · Apr 2026 Forecast · v3
The 12-month outlook from May 2026
Fenwick & Hale Mercantile — the forward P&L, built by the engine from your books. Trailing closes anchor the forecast columns.
Revenue — actuals and the calculated outlook
How this forecast is built
Anchored on 14 monthly closes ingested from your books — trend and seasonality come from your own history.
Collections follow your observed pattern: cash lands 1 weeks after invoicing, measured from your paid invoices.
The 12 forward months are computed by the engine from these inputs. No hand-typed numbers; edit assumptions in Drivers or model changes in Scenarios.
Your revenue forecasts have run 7% optimistic over the last 6 months.
Rolling P&L — actuals and forecast
Actual through Apr 2026 Forecast from May 2026
| Line | Nov 25 | Dec 25 | Jan 26 | Feb 26 | Mar 26 | Apr 26 | May 26 | Jun 26 | Jul 26 | Aug 26 | Sep 26 | Oct 26 | Nov 26 | Dec 26 | Jan 27 | Feb 27 | Mar 27 | Apr 27 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | $1,019,910 | $1,140,884 | $883,502 | $887,565 | $972,225 | $1,040,000 | $1,040,000 | $1,040,000 | $1,040,000 | $1,040,000 | $1,040,000 | $1,040,000 | $1,040,000 | $1,040,000 | $1,040,000 | $1,040,000 | $1,040,000 | $1,040,000 |
| Cost of revenue | $571,150 | $638,895 | $494,761 | $497,036 | $544,446 | $582,400 | $582,400 | $582,400 | $582,400 | $582,400 | $582,400 | $582,400 | $582,400 | $582,400 | $582,400 | $582,400 | $582,400 | $582,400 |
| Gross profit | $448,760 | $501,989 | $388,741 | $390,528 | $427,779 | $457,600 | $457,600 | $457,600 | $457,600 | $457,600 | $457,600 | $457,600 | $457,600 | $457,600 | $457,600 | $457,600 | $457,600 | $457,600 |
| Operating expense | $363,016 | $366,274 | $369,561 | $372,877 | $376,224 | $379,600 | $379,600 | $379,600 | $379,600 | $379,600 | $379,600 | $379,600 | $379,600 | $379,600 | $379,600 | $379,600 | $379,600 | $379,600 |
| Operating profit/(loss) | $85,745 | $135,715 | $19,180 | $17,651 | $51,555 | $78,000 | $78,000 | $78,000 | $78,000 | $78,000 | $78,000 | $78,000 | $78,000 | $78,000 | $78,000 | $78,000 | $78,000 | $78,000 |
| Ending cash | $474,769 | $515,484 | $521,238 | $526,533 | $542,000 | $620,000 | $698,000 | $776,000 | $854,000 | $932,000 | $1,010,000 | $1,088,000 | $1,166,000 | $1,244,000 | $1,322,000 | $1,400,000 | $1,478,000 | $1,556,000 |
Every forward line is computed by the driver engine from your closes and assumptions — never typed by hand.
Ready when you are
Build this from your numbers
You just watched it work on sample data. Point it at your books and the same briefing rebuilds in under a minute — read-only, nothing written back.
What you get
A monthly refreshed forecast with a reviewable draft, a 13-week cash view, a working decision queue, an investor-ready management report, Excel & Google Sheets sync, and a Slack digest.
No ledger writes · Read-only connections · Cancel anytime
✦ Ask the analyst
Available on every tab in your workspace — answers come with sources, the period, the calculation, and a confidence level.
Answers run on your connected books after signup. The sample keeps every number deterministic — it never improvises a reply.