5-Year Market Forecast Model: Top-Down and Bottom-Up Build – Excel XLSX

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

1. Build a forecast you can defend under questioning. Top down and bottom up, reconciled against a stated tolerance, with the divergence surfaced rather than smoothed. Extrapolating one growth rate is what everyone else hands the board.
2. Run base, upside and downside from a single switch. One calculation engine drives all three, so demand, segments, regions and capacity utilisation move together and stay consistent. No parallel copies to fall out of sync.
3. Hand a reviewer something auditable in one pass. Every assumption in one place, color coded for evidence against judgement, eleven live check cells that fail loudly, and a gate sign off sheet that records who checked what.

MARKET SIZING EXCEL DESCRIPTION

5-Year Market Forecast Model: Top-Down and Bottom-Up Build is an Excel template (XLSX) available for immediate download upon purchase.

A working five year forecast engine, not a formatted blank. Enter a market and it builds the forecast two ways, then makes you reconcile them.

Most forecast templates hand you a growth rate and a row of years. This one builds the market top down from an addressable pool and a penetration path you shape year by year, builds it again bottom up from units and prices by segment, sets the two side by side, and tests the variance against a tolerance you set. Where the two builds disagree by more than you allow, the model reads INVESTIGATE rather than quietly averaging the problem away. You choose which construction the published figure rests on, and the choice is recorded on the face of the model.

Three scenarios run off one calculation engine and one switch. Change the switch and the demand build, the bottom up build, the segment split, the regional allocation and the supply utilisation all move together. There are no parallel copies of the model to keep in sync, which is where scenario workbooks usually break.

Twelve tabs: Cover, README and Legend, Scenario Selector, Assumptions, Demand Build, Market Forecast, Bottom-Up Build, Supply Landscape, Regional Split, Scenario Comparison, Sources, QA Log.

Every input lives on the Assumptions tab and nowhere else. No assumption is buried inside a formula. Inputs are blue, key judgements are yellow, calculated cells are black, cross sheet links are green, so a reviewer can see in a single pass what is evidence and what is your judgement.

The QA Log carries eleven live check cells that recalculate with the model: shares summing to 100 per cent in every year, segment and regional revenue tying to the headline figure, scenarios ordered coherently, capacity covering demand, penetration paths inside bounds. Beneath them sits a nine gate sign off sheet covering sourcing, numerical, reconciliation, scenario, sensitivity, mechanics, confidence, disclosure and register.
Industry agnostic. It ships on a worked example so you can see every formula pulling before you touch it, and the README tells you exactly which cells to replace. The Sources tab holds a URL level register so every assumption you enter points at something a skeptical reader can retrieve.

Built by an independent institutional research firm that ships this discipline on paid forecast work, and holds itself to it.

Source: Best Practices in Market Sizing Excel: 5-Year Market Forecast Model: Top-Down and Bottom-Up Build Excel (XLSX) Spreadsheet, Advanced Analytics