Build a revenue forecast in two ways — as price × quantity and from drivers (customers × average order value × frequency) — and enter the matching formula.
The direct and driver-based approaches to forecasting revenue
Price × Volume vs. Customers × Order value × Frequency
The choice of method depends on the business model: the direct approach is simple but hides the growth levers; the driver-based one is more transparent and easier to check.
Lesson notes
Two ways to calculate revenue
The simplest way to calculate revenue is to multiply the price by the number of units sold: Revenue = Price × Quantity. If you sell one product at a fixed price, this formula is enough. But as soon as the business gets more complex, a question arises: what exactly drives the total?
A driver-based model answers that question by breaking revenue into components that can be measured and forecast separately. The classic version: Revenue = Number of customers × Average order value × Purchase frequency. For example, if you have 1,000 customers, each spends $500 on average and comes 3 times a month, monthly revenue = 1,000 × 500 × 3 = $1,500,000.
The main advantage of a driver-based model is control. Each factor is a separate assumption cell in the model. If marketing increases the number of customers by 10%, you immediately see how revenue changes. If you raise the average order value, the result recalculates automatically. This makes the model “live” and verifiable: any reader can find the source data and judge how realistic the assumptions are.
In Excel, the rule is never to hardcode numbers in formulas. Instead of =1000*500*3, write =B2*B3*B4, where B2, B3, and B4 are the assumption cells. Then changing one number instantly recalculates the whole model.