What a financial model is actually for (and what it is not)

I see this pattern often with searchers building their first financial model: they spend weeks in a spreadsheet, adjusting revenue growth rates and margin assumptions until the investor returns look attractive, and then feel like the deal should work because the numbers say so. Deals do not get done in an Excel spreadsheet. A financial model is a thinking tool. Its real job is to force you to answer the questions you might otherwise avoid: 1. Can this business cover its debt under your proposed capital structure? Most lenders underwrite between 1.15x and 1.55x DSCR, and that debt coverage in historical years is often the real driver of valuation in self-funded search deals. If the historical cash flow cannot support your proposed annual debt payments, the model is telling you something important about your price. 2. Are you comfortable with your pro forma ownership after the equity raise? This is a personal question that no model can answer for you, but the model makes you face it. And it is worth facing early, before you are deep into diligence. 3. Do the investor returns justify the risk? Investors generally want to see a base case of 30%+ IRR with conservative assumptions. If you had to stretch the revenue growth rate or margin projections to get there, that is a signal. Revenue and margin assumptions are not a lever to manipulate to justify a deal. They should reflect your diligence findings, your strengths as an operator, and the nature of the industry. The key word is "conservative." A model should not be overly complicated, but it does require you to think honestly about the transaction. And for most self-funded searchers, this may be the largest financial commitment of your career. The model is the place where you pressure-test whether the deal actually works before you commit. That is the real value. Not the spreadsheet itself. The thinking it forces you to do.