A Field Guide to the Many Spreadsheets Your Company Calls ‘The Model’

This is satire, but only because the alternative is opening the file. At every company, there is “the model”: a spreadsheet described in meetings as a single authoritative object, like a constitution or a weather system. In practice, it is usually eleven files, three hidden tabs, one retired analyst’s personal forecasting philosophy, and a link to an operating plan that has been “temporarily” replaced with hard-coded numbers since the previous fiscal year.

1. The Board Model

The Board Model is the workbook senior leadership presents as a clean, decision-ready view of the business. It contains a five-year forecast, a valuation tab no one is permitted to edit, and exactly one graph in a shade of blue that signals stewardship. It is updated shortly before every board meeting by a finance leader who has spent two days reconciling it to the numbers everyone agreed not to discuss in the meeting.

Its defining feature is precision without commitment. Revenue may be forecast to the nearest thousand dollars in month 54, while the operating plan still lists “international expansion” as a line item with no owner, country, or budget. Candidates interviewing for FP&A roles may be asked to “walk us through a model like this.” The correct response is to ask which version. The brave response is to ask whether the driver tabs tie to the reported results. Do not use the brave response until you have met the hiring manager.

2. The Operating Model

The Operating Model is what the company means when it says it has a plan. It is built from business drivers: headcount, sales capacity, customer cohorts, utilization, inventory turns, locations, contracts, or whatever physical law the company has chosen to monetize. It should tell a coherent story about how activity becomes revenue, margin, cash, and staffing needs.

In its natural habitat, however, the Operating Model is often half driver-based and half “Finance Plug.” Finance Plug is not a person, though it is frequently given ownership of six departments. Finance Plug appears when management wants EBITDA to land at a target before the business has invented the steps required to get there. It may be labeled “Other Opex Optimization,” “Productivity,” or, in mature specimens, “Management Action.”

3. The Forecast That Is Definitely Not a Reforecast

This workbook is created when actuals miss plan, conditions change, or someone notices that the plan assumed 98% employee retention during a year in which every team lead has updated their LinkedIn profile. Leadership will insist it is merely a “latest estimate,” because “reforecast” sounds like the prior plan has failed, whereas “latest estimate” sounds like finance has discovered time.

The Forecast That Is Definitely Not a Reforecast generally retains the old annual budget in a frozen top section for comparison. Beneath it sits a revised forecast. Beneath that sits an unofficial version prepared for the CEO. Beneath that sits the cash forecast, which is run separately because cash is apparently too important to be allowed near the income statement.

4. The Hiring Model

The Hiring Model begins as a headcount plan and ends as a cultural document. Its columns include approved roles, planned start dates, fully loaded cost, recruiter status, candidate pipeline, and a field called “business criticality,” where every executive has selected “critical.” A finance candidate evaluating a role should pay close attention to this file, even if no one shows it to them. It explains why the job description requests a senior accountant with systems experience, audit readiness, payroll backup capacity, and the temperament to “build in ambiguity.”

At a smaller company, the Hiring Model may genuinely be the only way leadership sees the cost of adding people. At a larger company, it may be one of several systems whose headcount totals differ by a number known internally as “close enough for workforce planning.” In either case, ask how requisitions are approved, who owns headcount reporting, and whether finance has authority to stop unbudgeted hiring. The answer will tell you whether you are joining a planning function or a witness protection program for expense control.

5. The Acquisition Model

The Acquisition Model is the most confident spreadsheet in the building. It can value a business no one has fully diligenced, identify synergies not yet explained, and calculate an internal rate of return with such conviction that it briefly causes everyone to forget integration exists. Assumptions are grouped in an elegant input tab, except for the most consequential assumption, which is entered directly into a formula by the associate who built the workbook at 2:14 a.m.

For candidates considering corporate development, strategic finance, or private-equity portfolio roles, the interview case often resembles a sanitized Acquisition Model. You will be asked for your assumptions, sensitivities, and recommendation. What they are really testing is whether you can distinguish a useful simplifying assumption from a number placed in a cell because the deal team needed the answer before lunch.

6. The Cash Model

The Cash Model has no interest in your adjusted EBITDA. It knows which customers pay late, which vendors require deposits, when payroll clears, and how quickly optimism becomes a covenant conversation. It is often maintained by treasury, a controller, an FP&A manager, or one person who has been told they are “great with details” and is now the only human barrier between the company and an urgent capital call.

Unlike the Board Model, the Cash Model is usually respected only during moments of danger. Then everyone suddenly wants a thirteen-week forecast, daily reporting, payment approval limits, and a definition of “discretionary.” Finance professionals should treat that shift as useful information about the company’s operating discipline, not as a temporary request to make the spreadsheet “a little more dynamic.”

7. The Real Model

The Real Model is not the file with the best formatting, the most macros, or the most senior owner. It is the file—or connected set of files—that people use to make staffing, spending, pricing, inventory, and financing decisions. It may be well governed. It may also be a workbook called FINAL_final_USE_THIS_v7.xlsx in a folder accessible only to someone currently on parental leave.

When you interview, ask what the role owns, which model drives decisions, how actuals flow into forecasts, who can change assumptions, and what happens when the planning view conflicts with accounting. The answers vary by company size, industry, systems maturity, and leadership habits. But one observation remains true in every environment: a spreadsheet is not a model merely because a meeting has begun calling it one.