Forecast Model Builder

Entity: Acme Robotics, consolidated
Source: NetSuite general ledger, read-only
Basis: trailing four-quarter trend

Your last four quarters of actuals show revenue climbing at an average of about 3.0% a quarter. Carrying that same trailing pace forward, the next four quarters project to $19.5M in revenue against $14.0M in operating expense, leaving roughly $5.5M in operating profit. Everything here extends the historical trend, so treat it as an outlook rather than a commitment.

Here is how the four projected quarters sit against the four most recent actuals. The trend line keeps rising because the projection simply extends the recent slope.

The projection carries revenue, operating expense, and the profit that falls out of the two, quarter by quarter.

Three assumptions drive these numbers, and they are worth stating plainly so you can push on them.

• Revenue grows 3.0% a quarter. That is the trailing four-quarter average from your ledger, not a target or a stretch goal. If the recent pace does not hold, neither does the top line.
• Operating expense stays at 72% of revenue. Costs are projected as a flat share of sales, so the model assumes no new hires, no one-time items, and no step-changes in spend.
• No pricing or mix changes. Every figure extends the historical trend line, so a price increase, a new product, or a lost account would move the result.

Sensitivity is straightforward. A slower 1.5% quarterly pace pulls the four-quarter total to about $18.8M, roughly $0.7M below the projection, while a stronger 4.5% pace lifts it to about $20.2M. Hold growth where it is but let opex drift to 74% of sales and operating profit falls about $0.4M. Treat $19.5M as the middle of an $18.8M to $20.2M band rather than a single number.

Nothing here is written back to your accounting system. It is a read of the history and a projection off the trend, so you can pressure-test the assumptions before you commit a quarter to them.