What financial model does an investor need

An investor reviews dozens of projects every month. Each comes with a pitch deck, a business plan, and a financial model. Most models are dismissed within the first five minutes. Not because the projects are bad, but because the model doesn't answer the questions an investor asks. It answers the questions the entrepreneur asks themselves: "How much will I earn?" The investor asks differently: "How much will I get back, when will I get it back, and what can go wrong?"

In this article, I'll break down exactly what an investor looks for in a financial model, which mistakes make a model look unprofessional, and how a model for an investor differs from one built for a bank or internal use.

What an investor wants to see in the model

An investor is someone who gives money now hoping to receive more later. They care about four things:

1. How much needs to be invested and when. Not just the total investment amount, but the schedule: when exactly the money is needed, by which milestones, with what level of detail. This determines how to structure the deal and how much capital needs to be reserved.
2. When and how much they'll get back. Return of investment, dividends, exit — specific amounts in specific periods. Not abstract company profit, but cash flow to the investor.
3. What the return is compared to alternatives. An investor always compares your project with other opportunities: other projects, deposits, bonds, public equities. Your project's IRR must be significantly higher than the risk-free rate — otherwise, why take the risk.
4. What can go wrong. The investor wants to understand risks and know what happens to the project in a downside scenario. Do they lose everything? Break even? Receive less than planned?

The model must provide clear answers to all four questions. If even one goes unanswered, the model is incomplete.

Why a profit forecast alone isn't enough

The most common mistake entrepreneurs make is building the model around profit. Here's the revenue, here are the expenses, here's profit growing every year. It looks nice, but for an investor it's nearly useless.

Profit is an accounting metric. It doesn't equal cash. A company can be profitable and still experience a cash deficit. This happens for several reasons:

• Accounts receivable. You sold $125,000 worth of goods, but clients haven't paid yet. Profit exists; cash doesn't.
• Inventory. Growing sales requires building up inventory. Cash is locked up in stock.
• Capital expenditures. Equipment purchases don't appear on the P&L as an expense (only depreciation does), but the cash leaves immediately and in full.
• Debt service. Repaying loan principal isn't a P&L expense, but it's a real cash outflow.

Investors know this. That's why they look not at profit but at Free Cash Flow — the money that actually remains after all expenses, investments, and debt service. It's from free cash flow that dividends are paid and investments are returned.

Profit is an opinion; cash flow is a fact. An investor always looks at cash flow, because cash is what they put in and cash is what they want back.

How to present the funding requirement

The investor needs to understand not just the total amount, but the funding structure: how much the entrepreneur is putting in, how much comes from the investor, whether there's debt financing, and on what terms.

The model should contain:

Investment budget — a detailed breakdown of all capital expenditures by category: construction, equipment, licenses, working capital, launch costs. Not a single line reading "investment — $625K," but with enough detail to verify each item.

Funding drawdown schedule — a month-by-month plan showing when exactly the money is needed. This matters to the investor: they may invest in stages, tying each tranche to specific milestones.

Funding structure — the ratio of equity to external capital. The investor evaluates how much the entrepreneur is risking with their own money. If the entrepreneur isn't willing to invest anything, that's a red flag: they're not risking anything and can walk away easily.

Use of investment proceeds — what exactly the investor's money will be spent on. This isn't just about oversight, but about efficiency: the investor wants their capital working toward growth, not covering operating losses.

How return on investment is calculated

The mechanism for returning the investment depends on the deal structure, and the model must reflect it.

Dividend model. The investor receives an equity stake and earns income through dividends from net profit. The model must show: when the company will generate sufficient profit for dividend payouts, what annual dividend volume looks like, and how many years until the investor recoups the initial investment.

Exit through share sale. The investor plans to sell their stake after a defined period — to another investor, a strategic buyer, or back to the entrepreneur. The model must estimate the company's value at the time of exit (typically via multiples: EV/EBITDA, P/E) and calculate the investor's return.

Principal repayment + interest. A structure similar to a loan: the investor receives a fixed interest rate and repayment of principal on a schedule. The model calculates the payment schedule and shows whether cash flow is sufficient to support it.

Key metrics for the investor:

• IRR (Internal Rate of Return) — annualized investment return accounting for the time value of money. For venture projects, expected IRR is 30–50%+. For more mature ones — 20–30%. For lower-risk projects — 15–20%.
• Cash-on-cash multiple — how many times the investor multiplies their money. Invested $125K, received $375K — that's a 3x multiple.
• Payback period — how many years until the investor recoups the investment. For most projects, an acceptable period is 3–5 years.

Why cash flow matters

Cash flow is the foundation of investment analysis. Without an accurate cash flow statement, it's impossible to calculate NPV, IRR, or payback period.

An investor-focused model must contain a detailed cash flow statement with three sections:

Operating cash flow — cash generated by core operations. This is revenue minus operating expenses, adjusted for changes in working capital. This metric reflects the business's ability to generate cash.

Investing cash flow — expenditures on acquiring assets (capital investments, equipment) and proceeds from their sale. At the project's outset, this section is negative — cash is going into building the business.

Financing cash flow — inflows from investors and lenders, dividend payments, loan repayments. Here the investor sees both their contributions and their returns.

Monthly cash flow detail in the first 1–2 years is critically important. This is the level at which cash gaps become visible — periods when expenses exceed income and the business needs additional funding. The investor must understand that the peak funding requirement is not just the initial investment but can be significantly larger due to operating losses during the ramp-up period.

A model that shows only annual figures hides intra-year dynamics. The investor may not see that in March the account balance goes negative, even though the year-end total is positive. Monthly detail is a mandatory requirement for a serious investment model.

What scenarios the investor needs to see

A model with a single scenario is not a model — it's a forecast. An investor wants to see a range of possible outcomes.

Minimum set of scenarios:

Base case — a realistic forecast based on well-supported assumptions. Not optimistic, not pessimistic, but the most probable. Key assumptions must be substantiated: by market data, comparable companies, or expert assessments.

Pessimistic case — what happens if key parameters come in worse: sales 20–30% lower, launch delayed 3–6 months, costs 15–20% higher. The investor asks: does the project remain viable? What's the return in this scenario? How many years to payback?

Optimistic case — the upper bound of what's possible. Helps assess the project's upside potential. But the investor understands that the optimistic case is more of a ceiling than a plan.

Advanced models include sensitivity analysis: a table showing how NPV or IRR changes when key parameters shift. For example:

• How does IRR change if the average transaction value moves +/-10%, +/-20%?
• How does the payback period shift if launch is delayed by 3, 6, or 12 months?
• At what sales level does the project break even?

Sensitivity analysis shows the investor which factors are critical and what to monitor once the project is underway.

How to present risks without "killing" the project

Many entrepreneurs are afraid to show risks in the model — they worry it will scare off the investor. The reality is the opposite: the absence of risk analysis scares an experienced investor far more. If you don't see risks, it means you don't understand your project.

The right approach to risks:

Identify the key risks. You don't need to list every possible problem in the world. Highlight 5–7 risks that could realistically impact your project: market risks (demand below expectations), operational risks (construction delays), financial risks (rising interest rates), regulatory risks (changes in legislation).

Show each risk's impact on the outcome. Not just "risk of lower demand," but "a 25% decline in demand extends the payback period from 3 to 5 years and reduces IRR from 35% to 18%." Concrete numbers instead of abstract descriptions.

Show how you manage risks. For each risk — what you plan to do: channel diversification, fixed-price contracts, reserve fund, ability to cut costs. The investor wants to see that you've thought about problems in advance.

Show the margin of safety. Even in the pessimistic scenario, the project should remain manageable. Maybe it won't deliver the expected return, but the investor won't lose all their money. If the pessimistic scenario means bankruptcy, be honest about it and explain why you believe the probability of that scenario is low.

An investor evaluates not just the project but the entrepreneur. An honest conversation about risks demonstrates maturity and professionalism. A model where everything always works out raises suspicion — because that's not how things work.

Mistakes that make a model look unprofessional

Over the years, I've seen hundreds of models prepared for investors. Here are the mistakes that most often undermine credibility:

Hockey stick with no justification. Revenue creeps along for the first two years, then suddenly skyrockets. Why? What changes? Without an explanation, it looks like reverse-engineering from a desired result.

Round numbers. Revenue of exactly $1 million, growth of exactly 20%, margin of exactly 30%. Real businesses don't generate round numbers. Round figures are a sign that numbers were invented, not calculated.

No working capital. The model shows revenue growth but doesn't account for the cash needed to fund inventory, receivables, and prepayments. As a result, the cash flow is disconnected from reality.

Unrealistic margins. 40% net margin in retail or 60% in manufacturing. If your metrics diverge significantly from industry averages, an explanation is needed. Otherwise, the investor will conclude you don't know your industry.

Ignoring competition. The model is built as if the company operates in a vacuum: prices never drop, customers never leave, competitors never appear. The investor knows that's not the case.

Disconnected statements. The P&L shows one thing, cash flow shows another, the balance sheet shows a third, and they don't reconcile. This is a fundamental error that immediately reveals the model's quality.

No separation of inputs and calculations. Everything is mixed together, and it's unclear which figures are assumptions and which are computed results. The investor can't verify the logic and can't change parameters.

Typos and sloppy formatting. This doesn't affect the calculations, but it affects perception. If the model looks careless, the investor wonders whether the calculations were done with equal carelessness.

How an investor model differs from a bank model

A model for an investor and a model for a bank serve different purposes, and the structure reflects that.

A bank model answers the question: can the borrower service the loan? Key elements:

• DSCR (Debt Service Coverage Ratio) — the debt coverage ratio. The bank wants to see that cash flow covers loan payments with a buffer (typically DSCR > 1.2–1.3).
• Collateral value of assets — the bank assesses what it will recover if the borrower defaults.
• Cash flow stability — the bank values predictability over maximum return.
• Bank format compliance — many banks have their own templates or structural requirements for the model.

An investor model answers the question: what return will I get, and what are the risks? Key differences:

• Focus on returns — IRR, NPV, investment return multiple.
• Exit mechanism — how and when the investor will get their money back with a profit.
• Company valuation — via multiples or DCF.
• Sensitivity and scenario analysis — more developed than for a bank model.
• Unit economics — especially for digital and technology projects: CAC, LTV, conversion rates, churn.

There's also a practical difference: banks tend to be more conservative and formal. They evaluate the model against a checklist. An investor is more flexible but more demanding when it comes to the quality of assumptions. A bank may accept a model with 15% IRR as long as DSCR checks out. An investor will reject a project with 15% IRR if they can get 25% elsewhere.

If you're raising both debt and equity simultaneously (which happens often), you need a model that works for both audiences. This is more complex because it must account for payment priority: debt service comes first, and whatever remains is distributed between the investor and the entrepreneur.

Conclusion

A financial model for an investor is not a spreadsheet with numbers — it's an argument in a negotiation. It must convince a professional who sees dozens of projects that yours deserves their capital and attention.

A good investor model:

• Shows a specific investment return mechanism with IRR and multiple calculations
• Builds revenue bottom-up from substantiated drivers, not top-down from a desired result
• Contains detailed monthly cash flow, not just annual totals
• Includes scenario analysis and sensitivity analysis
• Honestly presents risks and mitigation strategies
• Is professionally formatted, with clear separation of inputs and calculations

The cost of developing such a model is typically 1–3% of the capital being raised. Given that an unprofessional model can cost you the investment itself, it's a worthwhile expenditure. An investor makes decisions based on the numbers — make sure your numbers withstand professional scrutiny.