Financial Modelling Mistakes: The Errors That Fail Candidates

Key takeaways

Over-complex models with 30+ balance sheet line items break more often and take longer to debug. Apply the 10% rule: consolidate anything below 10% of its category.
Revenue growth and margin expansion rarely happen simultaneously. Modelling both without justification is the most common assumption error.
Capex must exceed D&A in a growing business. If D&A exceeds capex, the model implies the company is shrinking its asset base.
The model is a tool for answering a question, not a display of technical complexity. Focus on the 2-3 drivers that actually move the valuation.

Mistake 1: Importing Financial Statements Without Consolidation

The instinct when building a model from a 10-K is to replicate every line item exactly as reported. A company like Otis Worldwide has 15+ line items on each side of the balance sheet. Importing all of them creates a model with 45+ rows on the BS alone, each of which needs a forecast assumption, a CFS link, and a formula that can break.

Most of those line items are immaterial. "Accrued liabilities" at 3% of total liabilities does not move the valuation. "Other long-term assets" at 2% of total assets does not affect the investment thesis. But each one is a potential source of a balance sheet error that takes 20 minutes to debug.

The 10% rule If a line item represents less than 10% of its category (total assets, total liabilities, total equity), consolidate it with the nearest related item. A balance sheet with 5-6 items per side is easier to build, easier to audit, and produces the same valuation outputs as one with 20 items per side. The extra granularity adds no analytical value and significant error risk.

The target structure for a clean model:

Assets (5-6 items)	Liabilities + Equity (5-6 items)
Cash and equivalents	Accounts payable
Accounts receivable	Accrued expenses and other current liabilities
Inventory	Total debt (short + long term combined)
PP&E (net)	Other long-term liabilities
Other assets (everything else)	Total shareholders' equity

Mistake 2: No Systematic Build Process

Analysts who jump between the income statement and balance sheet while building, forecasting whatever feels natural, produce models with inconsistent logic and missing links. The build order matters because each statement feeds the next.

The correct sequence:

1. Historicals: Input 3 years of consolidated historical data. Calculate implied ratios (margins, growth rates, working capital days, capex/revenue).

2. Revenue and expense drivers: Identify 2-3 key drivers beyond a flat growth rate. For a retailer: same-store sales growth + new store openings. For SaaS: existing customer expansion (NRR) + new logo acquisition. This takes 5 extra minutes and makes the assumptions defensible.

3. Income statement forecast: Revenue down to net income. Every line derived from an explicit assumption, not a hardcoded number.

4. Working capital and balance sheet: AR, inventory, AP from days ratios. PP&E from capex and D&A. Retained earnings from net income and dividends.

5. Cash flow statement: Start with net income, adjust for non-cash and working capital, subtract capex, handle financing flows. Ending cash links to BS.

6. Integrity check: Balance sheet balances. Revenue growth declines over time. Margins stabilise. Capex exceeds D&A if the business is growing.

Mistake 3: Indefensible Assumptions

This is the mistake that separates a technically competent model from one that demonstrates investment judgement. The most common offenders:

Revenue growth accelerating while margins expand

Growing faster almost always costs more. Sales and marketing spend increases to acquire new customers. R&D investment rises to support a broader product portfolio. Working capital requirements grow. A model that shows 15% revenue growth AND 300bps of EBITDA margin expansion needs a specific justification: operating leverage from a SaaS business model, scale economies in procurement, or a one-time cost restructuring. Without that justification, the model is assumed to be wrong.

The assumption test For every key assumption, ask: "If a senior banker challenged this in a meeting, could I defend it with evidence from the company's filings or sector benchmarks?" If the answer is no, change the assumption.

Revenue growth staying flat or increasing over 5 years

Revenue growth almost always declines over a forecast period. As the absolute revenue base gets larger, maintaining the same percentage growth requires proportionally more incremental revenue. A company growing at 20% from a £100M base needs £20M of incremental revenue. At £200M, it needs £40M for the same growth rate. The model should reflect this natural deceleration.

Capex below D&A in a growing business

If revenue is growing, the asset base that supports that revenue must also grow. PP&E should increase over time, which means capex must exceed D&A. A model where D&A exceeds capex implies the company is shrinking its productive capacity while somehow growing revenue. This is internally contradictory and will be caught immediately in any review.

Working capital days that shift dramatically

DSO, DIO, and DPO are structural characteristics of a business that change slowly. A retailer with 45 days of inventory is not going to operate at 25 days next year without a fundamental change in its supply chain. Use the 3-year historical average as the base and adjust only if there is a specific reason (new ERP system, supplier renegotiation, shift to just-in-time).

Mistake 4: Unnecessary Complexity

Models that include LTM (Last Twelve Months) calculations, stub periods, and detailed debt maturity waterfalls when none of these are needed for the analysis at hand. Every additional feature is a potential error source and a time cost.

The question to ask before adding any feature: "Does this change the output that matters?" If the model is feeding a DCF valuation, the outputs that matter are free cash flow and terminal value. A detailed debt maturity schedule does not change FCF. A stub period adjustment does not affect the 5-year forecast. Build only what the analysis requires.

The best models are not the most complex ones. They are the ones where every assumption is defensible, every link is clean, and someone who has never seen the model can open it, change the key inputs, and trust the outputs. That requires discipline, not complexity.

Mistake 5: Hardcoded Numbers Inside Formulas

A formula that reads =D15*0.25 instead of =D15*$B$5 where B5 is a labelled tax rate assumption. The first version hides an assumption inside a formula where nobody can find it. The second version makes the assumption visible, changeable, and auditable.

The rule: every number in a formula should reference a cell. If a cell contains a hardcoded assumption, it should be on the assumptions page with a blue font (the universal convention for inputs). If an associate opens the model and cannot find every assumption within 30 seconds, the model has failed the usability test.

The Hierarchy of What Matters

When time is limited, prioritise in this order:

Priority	Item	Why
1	Revenue drivers and assumptions	Revenue drives everything else. Get this wrong and the entire model is wrong regardless of how clean the formatting is.
2	Statement linkages	The balance sheet must balance. Broken linkages mean the model cannot be trusted.
3	Margin and working capital assumptions	These determine cash flow conversion, which is what the DCF actually values.
4	Formatting and presentation	Matters for readability and professionalism, but a well-formatted model with bad assumptions is still a bad model.

Take Your Preparation Further

Download our free Accounting Cheat Sheet for the complete three-statement linkage reference. For a hands-on model with all linkages built, see the 3-Statement Financial Model.

Ready for personalised feedback? Book a 1-on-1 mentoring session with an experienced IB/PE professional.

The Financial Modelling Mistakes That Fail Candidates (And How to Avoid Them)