This guide provides a practical review sequence. It does not validate a particular business, establish market prices, or certify a workbook. The aim is to understand which decisions the model can help you examine and which evidence you still need.
Start with the business the workbook actually represents
Read the stated scope before opening the dashboard. Identify the unit sold, who pays, how service is delivered, and what limits output. Two businesses with the same name can need different revenue calculations. A restaurant selling individual meals, a catering operation selling events, and a client-site cafeteria serving contracted meals do not have interchangeable operating assumptions.
Compare the model with your intended format. List material differences such as delivery, alcohol, a second location, customer deposits, or an unpaid owner. Then ask whether the workbook contains the relevant revenue, cost, timing, and capacity relationships. Replacing a selling price will not add a missing operating mechanism.
The restaurant format comparison is a useful starting point for that distinction. Choose the operating structure before deciding whether its projected margin looks attractive.
Separate evidence, assumptions, and outputs
A number can be accurately copied from a source and still be unsuitable for your plan. A supplier’s listed equipment price may exclude installation. A wage observation may cover a different labor market. A planning assumption is the value you select after considering those limits; a calculated output is what the workbook produces from that selection.
On a narrow screen, scroll within the table to read all columns.
| Kind | What it tells you | What to record |
|---|---|---|
| Source observation | A dated fact, quotation, or published comparison within a stated scope. | Source, observation date, geography, specification, and exclusions. |
| Planning assumption | The selected value used in the case. | Value, unit, timing, reason for selection, and unresolved uncertainty. |
| Calculated output | A formula result conditional on the inputs and model structure. | Formula basis, period, scenario, and the inputs that explain it. |
Keep these labels even when the same number appears in more than one category. A quotation can become the selected assumption, but the record should still explain whether the quantity and installation scope match. An unknown expense belongs on an unresolved-input list; entering zero silently turns uncertainty into a favorable assumption.
Check units and timing together
For each material input, write down its unit and period. Guests per open day are different from guests per calendar day. Paid hours are different from productive service hours. A monthly rent figure cannot be compared directly with an annual sales total without converting the period.
Check when a cost begins, not just how large it is. Hiring before opening creates payroll before guest revenue. A replacement asset can reduce cash years after the initial opening budget. A payment delay can separate recorded revenue from the arrival of money in the bank.
Also check what a price includes. Net sales, sales tax collected, tips, and payment-processing charges may appear in different parts of the workbook. Follow the definitions before adding or removing amounts. The demand and capacity guide demonstrates why the operating unit and the financial unit must stay connected.
Trace one output back to its inputs
Choose a result that matters to the decision, such as monthly revenue or minimum cash. Follow its formula to the preceding calculation, then keep following until you reach the editable assumptions. Record the path in words: served guests multiplied by net spend, for example, or opening cash plus the month’s cash movements.
In supported desktop Excel versions, Trace Precedents shows cells used by a formula, while Trace Dependents shows formulas that refer to a selected cell. Microsoft notes limits, including some references involving closed workbooks and other objects. Use the instructions for your installed version. Microsoft’s formula relationship guide explains the commands and their limitations.
The Show Formulas command switches a worksheet between formulas and their displayed results. It can help expose a calculation’s structure, but it does not establish that the underlying assumptions are reasonable. Microsoft’s formula display instructions describe the supported controls.
If a reference points outside the workbook, confirm that the required source is available before relying on the result. If a formula is protected or its logic remains unclear, record the limitation and consult the workbook’s instructions rather than guessing.
Make one explainable change
Keep an untouched original and use a separate working copy. Follow the workbook’s guidance on editable cells. Before changing an input, predict the direction of the effect and write down what should stay unchanged. Then compare the recalculated result with that expectation.
A demand increase may leave sales unchanged if a capacity limit is already binding. A higher selling price may increase sales-based food costs even when guest counts stay constant. An opening-date change may affect revenue, payroll, and rent differently if their start dates are separate inputs. These are reasons to inspect the relationships, not assume the spreadsheet failed.
Once one change behaves as understood, combine related changes into a named scenario. Keep a record of the baseline and the edited case. Avoid treating a financial multiplier as proof that the kitchen, floor plan, or staffing schedule can deliver a physically larger operation.
Read cash and profit as different outputs
The income statement and cash-flow statement answer different questions. The SEC explains that cash-flow reporting tracks cash movements and separates operating, investing, and financing activities; profit alone does not establish the cash generated. SEC’s guide to financial statements.
For a startup review, locate the lowest monthly cash balance as well as the annual result. Check whether financing is fixed or changes automatically, and whether the balance includes new borrowing. The opening cash reserve guide works through one model’s funding calculation. The break-even and payback guide separates a positive operating month from recovery of startup investment.
Leave a record another person can use
For each material change, record the workbook release, input name and cell, old and new values, unit, effective date, source, and reason. Add the outputs affected and any question still open. A short, complete register is more useful than a long list of unlabeled figures.
Finish by rereading the model’s scope and limitations. Confirm that the scenario still represents the business you intend to operate. Use the methodology definitions to distinguish evidence from assumptions, and consult the full-service restaurant workbook overview for a concrete example of connected operating and financial schedules.
