Make the numbers answer a business question
A useful financial model shows how a decision changes the economics of a business. It makes the assumptions visible, distinguishes profit from cash and identifies the conditions under which an investment creates value.
Quick Prep’s Finance Modeling focuses on that practical skill in the management consulting interview context. You learn to build a model from business drivers, explain the calculations and use the result to support a recommendation. The emphasis is on transparent reasoning that works on paper and can be extended into a spreadsheet when the assessment calls for one.
This service area is relevant to candidates preparing for profitability, expansion, pricing, acquisition and capital-investment cases. It also helps experienced professionals translate operational knowledge into a financial argument.
Understand the statements before linking them
The income statement describes financial performance over a period; the balance sheet describes assets, liabilities and equity at a point in time; the cash flow statement explains cash movements. The SEC’s educational guide provides a useful introduction to these relationships. SEC: Beginners’ Guide to Financial Statements
In a case, a business can report profit while consuming cash because it is building inventory, collecting slowly or investing in equipment. Conversely, collecting a customer prepayment does not necessarily mean the entire amount is revenue for that period.
Begin with the decision and the time horizon. A one-month pricing decision needs a different model from a ten-year factory investment. Avoid adding financial complexity that does not help distinguish the options.
Build the model from operational drivers
For revenue, identify the paying unit and the price. That might be units sold, average subscribers, billable hours, completed visits or transaction volume. Separate segments when their economics differ materially.
For costs, distinguish those that change with the decision from those that remain. A fixed cost is fixed over a defined range and period; expansion can require an additional manager, facility or support team. Include such step changes explicitly.
Calculate contribution before allocating shared costs. Then examine the relevant fixed costs and investment. If a cost would exist under both alternatives, it may not affect the incremental decision, although it remains part of the company’s total economics.
A clear model keeps assumptions, calculations and outputs distinct. Label currencies, units and time periods. In a spreadsheet, avoid hiding assumptions inside formulas, and make it easy to trace the recommendation back to the inputs.
Worked exercise: open a new service location?
Illustrative interview exercise with fictional figures in a common currency.
A new location is expected to complete 12,000 appointments a year. Revenue is 80 per appointment, variable cost is 30 and annual fixed operating costs are 400,000.
Annual contribution is 12,000 × (80 − 30) = 600,000. After fixed operating costs, the location produces 200,000 of operating surplus before depreciation, tax and financing.
Operating break-even volume is 400,000 ÷ 50 = 8,000 appointments. This does not recover the initial investment; it only covers the model’s operating costs.
Assume opening requires 600,000 in equipment and fit-out plus 100,000 in working capital. Annual maintenance investment is 50,000. Ignoring tax and financing, and assuming no further working-capital change, annual cash flow after maintenance investment is 150,000.
Simple payback on the 700,000 initial cash outlay is approximately 4.7 years, assuming full performance from the first year. If first-year demand ramps gradually, the actual payback would be longer.
At only 9,000 appointments, operating surplus falls to 50,000 and cash flow after maintenance investment is zero. That downside shows why an apparently comfortable operating break-even point does not establish an attractive investment.
Evaluate investment and valuation assumptions
Simple payback is useful for initial screening but ignores cash flows after payback and the time value of money. Net present value discounts future cash flows and subtracts the initial investment. Use a discount rate and cash flow definition that match; do not apply a rate intended for equity cash flows to a different measure without adjustment.
For interview practice, state when cash flows occur and whether a terminal value or disposal value is included. Keep nominal cash flows consistent with nominal discount rates, and check whether working capital is released at the end.
Valuation multiples can provide a comparison, but the underlying measure and peer set matter. Companies with different growth, risk, margins or capital needs may warrant different values. A multiple is an assumption to explain, not a shortcut around understanding the business.
Stress-test the assumptions that drive the answer
Build a base case and at least one downside. Change demand, realised price, variable cost, capital cost or timing according to the business problem. Explain why those variables are uncertain and whether they move together.
Distinguish sensitivity from scenario analysis. Sensitivity changes one input to understand its effect. A scenario combines a coherent set of conditions, such as lower demand alongside delayed opening.
Check the model in three ways: whether the units are consistent, whether the arithmetic reconciles and whether the business result is plausible. An accurate spreadsheet can still answer the wrong question if it includes total revenue instead of incremental revenue.
Turn the model into a recommendation
A useful output is a short decision statement supported by a few numbers: expected benefit, investment required, break-even threshold and main downside. Explain the operational conditions required for the result.
Use Technical Skills Enhancement to strengthen calculation and data handling, and apply the model to energy, manufacturing or technology cases. Contact Quick Prep to discuss the financial reasoning most relevant to your target interviews. Worked cases that exercise the same reasoning are collected in the resource hub.