Financial Modeling for M&A and Investment Analysis

A financial model is the analyst’s core instrument for testing an investment thesis. The spreadsheets can look arcane, the terminology is dense, and the pressure to get it right — especially when a committee is reviewing it — is real. But a model is not about predicting the future with precision. It is about isolating the levers that drive a target’s value and stress-testing what happens when they move.

Start With Unit Economics

Before building a full model, you need to understand four numbers cold:

• Customer Acquisition Cost (CAC): How much you spend to acquire one customer, including all marketing and sales costs.
• Lifetime Value (LTV): The total revenue you expect from a customer over their relationship with you.
• Payback Period: How long it takes to recoup the cost of acquiring a customer.
• Gross Margin: Revenue minus the direct costs of delivering your product.

If LTV is at least three times CAC and your payback period is under 18 months, you have the foundation of a viable business. If not, focus on fixing these ratios before worrying about projections.

Build Bottom-Up, Not Top-Down

The most common modeling mistake is starting with a market size and applying a capture rate. “If the target captures just 1% of a $10B market…” is the fastest way to lose credibility with a committee. Instead, build from the ground up:

1. How many customers can the target realistically acquire per period given its current channels?
2. What is the average revenue per customer?
3. What is the expected churn rate?
4. How do these numbers change as the company reinvests in growth?

This approach produces smaller but defensible numbers, which is exactly what a rigorous review demands.

The Three-Statement Model

A complete financial model connects three statements:

• Income Statement: Revenue minus expenses equals profit or loss. Start here.
• Cash Flow Statement: When money actually moves. A profitable company can still run out of cash if customers pay slowly.
• Balance Sheet: What you own versus what you owe. Less critical at early stages but important for understanding runway.

For early-stage targets, focus first on the income statement and cash flow; for mature businesses and leveraged structures, the balance sheet carries the analysis.

Key Assumptions to Document

Every model is built on assumptions. The quality of your model is determined not by the output numbers but by how clearly you state and defend your assumptions:

• Revenue growth rate and what drives it
• Headcount plan and average compensation
• Marketing spend as a percentage of revenue
• Infrastructure and tool costs at scale

Scenario Planning

Build three scenarios: base case, optimistic, and conservative. This is not about hedging — it shows the committee that the analysis accounts for what happens when things do not go as planned. The base case should be defensible rather than promotional. The conservative case should show whether the position survives a downturn.

The goal is not a perfect spreadsheet. It is a thinking tool that sharpens the investment decision and a communication tool that lets a committee follow the logic from fundamentals to conclusion.