Three-Statement Financial Model: Build It Step by Step

What does it actually take to make a capital-intensive project investor-ready – and why do so many technically sound projects still fail to close?

The answer, more often than not, begins with the model.

The pattern we see again and again is that sponsors arrive at investor meetings with a pitch deck but cannot answer a basic stress-test question on their own numbers without returning to their spreadsheet. That gap surfaces consistently in due diligence reviews across infrastructure and project finance transactions – and it is not a presentation problem. It is a modeling problem. The distinction matters enormously when the capital being sought runs into the tens or hundreds of millions of dollars. The three-statement financial model is the foundation that prevents that failure: not a reporting exercise, not a document produced after the real decisions have been made, but the decision tool itself.

The three statements – the income statement (profit and loss), the balance sheet, and the cash flow statement – are not three separate spreadsheets that happen to live in the same workbook. They are one integrated system, with defined linkages that force internal consistency across every assumption a sponsor makes. Get those linkages right and the model becomes a genuine capital-structure test: it tells the sponsor whether the project can support the proposed debt load, what equity returns look like under realistic assumptions, and where the project is most vulnerable to external pressure. Get them wrong and the model produces numbers that look plausible on screen but collapse the moment an experienced lender or infrastructure fund manager starts pulling the threads.

This guide walks through how to build that integrated system from first principles – income statement first, then balance sheet, then cash flow statement, then the debt and equity schedule that closes the model for a capital raise. It addresses the misconceptions endemic among self-taught practitioners, explains the structural checks that separate a model built for internal comfort from one that can survive lender due diligence, and connects the technical construction directly to what the model is actually used for in practice: the information memorandum, the term sheet negotiation, and the investor roadshow. Put simply, the model is the single point of truth. Everything else is derived from it.

What Is a Three-Statement Financial Model and Why It Matters for Capital Raises

The three-statement model is an integrated financial system in which the income statement, the balance sheet, and the cash flow statement are connected by formulas so that a change in one assumption flows automatically through all three outputs. Net income from the bottom of the P&L flows to retained earnings on the equity side of the balance sheet. Depreciation charged on the P&L reduces net income and simultaneously accumulates as a contra-asset against fixed assets on the balance sheet. The cash flow statement starts from that same net income figure, adds back depreciation and other non-cash charges, adjusts for working capital movements, and reconciles to the cash balance shown on the balance sheet. These three linkages – net income to retained earnings, depreciation across P&L and balance sheet, cash flow statement to balance sheet cash – are what makes the system integrated rather than merely adjacent.

It is important to remember that most sponsors arriving at a project finance conversation treat the model as a reporting tool. They build it after the business case has been decided, populate it with assumptions that support conclusions already reached, and use it to produce the summary tables that appear in the pitch deck. Investors and lenders do not use the model that way. They use it as a decision tool – a machine for stress-testing the capital structure to see whether the project generates enough cash to service its debt under adverse conditions, and whether the equity story holds if commodity prices, construction costs, or offtake volumes move against the sponsor. Working with experienced capital raising consulting professionals early in the process is precisely what prevents sponsors from sequencing the model as an afterthought.

For capital-intensive projects – energy, mining, infrastructure, hydrogen, waste-to-energy – the model IS the business case. The decision about how to capitalise a project, what debt-to-equity ratio is supportable, and what terms to accept from a lender or equity investor cannot be made responsibly without a working integrated model. Treating the model as a documentation exercise that follows the real decisions is the most expensive sequencing error a sponsor can make. The correct order is model first, then information memorandum, then pitch deck, then roadshow. Capital and structure must align from the beginning – not be reconciled at the end.

Why the Three Statements Must Be Integrated, Not Separate

A model can balance on paper without being logically correct. This is worth dwelling on because it trips up a large number of otherwise capable operators. Assets equaling liabilities plus equity is a necessary condition, not a sufficient one. A retained earnings line that does not roll forward from the prior period, or a cash balance on the balance sheet that has been manually entered rather than derived from the cash flow statement, can produce a model that balances through offsetting errors while concealing structural problems that will surface under any serious due diligence review.

The three specific linkages that make integration genuine are:

• Net income to retained earnings. The retained earnings line on the balance sheet must be a formula: prior year retained earnings, plus current year net income from the P&L, minus any dividends paid. If this formula is hardcoded or broken, the balance sheet will still balance – but the equity section is no longer connected to profitability.
• Depreciation across P&L and balance sheet. Depreciation is charged as a non-cash expense on the income statement, reducing net income and taxable income. On the balance sheet, accumulated depreciation increases by the same amount each period, reducing the net book value of fixed assets. If these two entries are not derived from the same depreciation schedule, the model has a disconnected asset base.
• Cash flow statement reconciling to balance sheet cash. The ending cash balance on the cash flow statement must equal the cash and cash equivalents line on the balance sheet. If these figures do not match, there is a structural error somewhere – usually a working capital movement counted twice or a financing item placed in the wrong section.

Proper integration enables something technically modest but commercially powerful: sensitivity analysis that flows through all three statements simultaneously. When a lender asks what happens to debt service capacity if offtake volume drops in a given year, the answer should come from changing one cell in an assumption input sheet and reading the DSCR output directly. A disconnected model cannot provide that answer quickly or reliably – and that signals to any experienced counterparty that the sponsor does not have genuine command of their own numbers. In practice, that signal is very difficult to walk back once it has been given.

Step 1: Building the Income Statement and Setting Your Assumptions

Build the income statement first. This is the correct sequencing because the P&L produces two outputs – net income and depreciation – that flow directly into the balance sheet and cash flow statement. Building the balance sheet before the P&L is complete creates circular references and makes the model unnecessarily difficult to audit.

Revenue assumptions are the starting input and the single most scrutinised area of any investor-facing model. For capital-intensive projects, revenue is driven by volume, price, and contract structure. Generic or rounded revenue figures with no supporting workings signal immediately that the sponsor does not have command of their cost base or market position. Investors will stress-test every revenue assumption, so the model must make those assumptions explicit: the offtake agreement volume in tonnes or megawatt hours, the contracted price versus market price, the escalation mechanism, and the take-or-pay structure if one exists. A PPA (power purchase agreement) for a renewable energy project, for instance, defines revenue with a precision that a market-price assumption never can – and lenders treat those two scenarios very differently when assessing financeable quantum. Understanding how a structured business model supports investor confidence when seeking capital is a useful complement to building revenue assumptions with that same rigour.

Separate the cost structure below revenue into its components with equal discipline:

• Direct costs (cost of goods sold): raw materials, direct labour, contractor payments, consumables
• Operating expenses: site overhead, insurance, maintenance, general and administration
• Depreciation: a non-cash charge derived from the depreciation schedule, not entered manually
• Interest expense: derived from the debt schedule, not entered manually
• Tax: applied at the appropriate statutory rate to earnings before tax, with any deferred tax treatment noted

EBITDA – earnings before interest, tax, depreciation and amortisation – is the key interim output of the P&L because it represents the cash-generation capacity of the project before financing and tax drag. For project finance specifically, lenders focus on EBITDA as the starting point for assessing whether the project can support the proposed debt quantum. Build the model so EBITDA surfaces clearly as a labelled line, not buried in the middle of a long calculation column.

For greenfield and brownfield projects, the P&L should explicitly distinguish between the construction phase – when capital is being deployed, no revenue is being generated, and debt is being drawn but not yet serviced – and the operations phase when the revenue story begins. This construction-to-operations transition is one of the first areas a lender examines. The capitalisation of interest during construction, treated as part of the asset cost rather than expensed immediately, is a specific technical point that must be handled correctly – or the P&L will overstate losses in early periods and understate asset values on the balance sheet.

Step 2: Constructing the Balance Sheet and the Critical Linkages to the P&L

The balance sheet records the project’s financial position at a point in time: what the project owns (assets), what it owes (liabilities), and what remains for equity holders (equity). For a capital-intensive project, the asset side is dominated by fixed assets – the physical infrastructure that has been built or acquired – and the liability side reflects the capital structure: the mix of debt and equity used to fund those assets.

The fixed asset calculation follows a simple but frequently broken roll-forward:

Opening balance + Capex in the period – Depreciation in the period = Closing balance

Capex comes from the model’s capital expenditure assumptions, usually a construction schedule by period. Depreciation comes from the P&L depreciation charge. If either is hardcoded rather than formula-driven, the asset base loses its connection to the model’s other assumptions – and an independent assessment of the model will find the break quickly.

Retained earnings on the equity side follow an equally important roll-forward:

Prior year retained earnings + Current year net income – Dividends paid = Current year retained earnings

This single formula is the most commonly broken linkage in self-built models. When it is broken – when retained earnings has been manually adjusted or improperly referenced – the equity section of the balance sheet is no longer connected to the profitability of the project. The model will fail even a basic internal consistency check.

Working capital accounts require specific attention in capital-intensive projects. Trade receivables grow with revenue (typically expressed as a days-sales-outstanding assumption). Inventory grows with production (days-inventory-outstanding). Trade payables grow with procurement and contractor spending (days-payables-outstanding). These are not cosmetic entries – for a large mining or energy project, working capital movements can represent material cash swings in a single period, and they flow directly into the operating section of the cash flow statement. In our experience advising sponsors on capital-intensive projects, the magnitude of those movements has repeatedly shaped the terms of the financing conversation that followed.

Current liabilities and long-term liabilities must be clearly separated. Short-term debt, current portions of long-term debt, and trade payables affect the liquidity picture that lenders assess when reviewing minimum cash balance covenants. Long-term debt, deferred tax liabilities, and contingent obligations affect the leverage picture. A model that lumps these together makes covenant compliance assessment effectively impossible. The team of capital raising consultants who review a sponsor’s model at this stage will identify that separation – or its absence – within minutes.

Step 3: Deriving the Cash Flow Statement Using the Indirect Method

The cash flow statement answers the question that matters most to investors and lenders in capital-intensive projects: how much actual cash did the project generate, hold, and move in this period? This is not the same question as the P&L’s question, which is how profitable was the project on an accounting basis. A project can be profitable on the income statement and cash-negative in the same period due to working capital build, capex deployment, or debt service obligations. Investors know this. The cash flow statement is where the real cash story of a project lives.

The indirect method builds the operating section by starting from net income and working backward to cash:

1. Start with net income from the bottom of the P&L
2. Add back depreciation and amortisation – these are non-cash charges that reduced net income but did not consume cash
3. Add back any other non-cash items (provisions, unrealised losses)
4. Adjust for changes in working capital: an increase in trade receivables reduces operating cash flow (cash has not yet been collected); an increase in trade payables adds cash (obligations have been incurred but not yet paid)
5. The result is cash flow from operating activities

Below operating activities, the cash flow statement separates into two further sections. Investing activities captures capex – the cash spent acquiring or building assets – asset disposals, and any other long-term investment movements. Financing activities captures debt drawdowns, debt repayments, equity injections, and dividends paid. Sponsors who want a precise account of whether a financial model serves a different strategic purpose than a budget will find the answer sits squarely in how the cash flow statement is constructed and what it is asked to demonstrate.

The closing cash balance – the sum of opening cash plus operating cash flow, plus investing cash flow, plus financing cash flow – must equal the cash line on the balance sheet. This reconciliation is the single most important structural check in the model. If it does not reconcile, there is a structural error somewhere, and the source of that error must be found and corrected before the model is used for any investor-facing purpose. No exceptions.

Building the Debt and Equity Schedule: Closing the Model for Capital Raises

A three-statement model without a financing schedule is incomplete for any capital raise purpose. The debt and equity schedule is the mechanism that connects the capital structure to the three statements: it shows how debt is drawn, when it is serviced, and how it is repaid; it shows equity injections by period; and it produces the interest expense figure that feeds the P&L and the debt balance that appears on the balance sheet.

For project finance – greenfield or brownfield – the debt schedule must explicitly model two distinct phases. During construction, debt is drawn according to the construction funding schedule, and interest is typically capitalised (added to the outstanding loan balance rather than expensed) until operations commence. This capitalised interest becomes part of the fixed asset cost, which affects depreciation going forward. The operations phase then activates the debt service obligations: principal amortisation follows the agreed repayment profile – sculpted to cash flows, annuity, or bullet, depending on the facility structure – and interest is charged on the outstanding balance each period.

Debt service coverage ratio – DSCR, calculated as operating cash flow divided by total debt service (principal plus interest) in a given period – is not a metric to be added at the end of the model as a separate table. It is worth noting that a DSCR of 1.0x means cash flow exactly equals debt service, with nothing left over – making it the floor below which no lender will proceed. DSCR should surface as a live output that updates automatically when any assumption changes, allowing the sponsor to see in real time whether a proposed capital structure is supportable under the base case, and to demonstrate the same view under stress to long-term strategic investors who will want exactly that evidence before they commit. Lenders will ask for minimum DSCR in the worst year of the project and what assumptions would cause a covenant breach. The model must be able to answer that question immediately.

Equity returns – expressed as IRR (internal rate of return) or cash-on-cash multiple, depending on the investor audience – are derived from the model’s equity cash flows: equity invested during construction, minus dividends and cash distributions received during operations, minus the residual equity value at exit or project end. These figures are not inputs. They are outputs. If a sponsor enters the IRR they want and works backward to make the model produce it, that is a fundamental misuse of the tool – and experienced project finance advisors will identify the circular logic quickly. It is the kind of thing that ends a due diligence process before it properly begins.

How to Check That Your Model Balances and Troubleshoot When It Does Not

The balance check – assets equal liabilities plus equity – is the minimum standard, not the final one. A model can satisfy the balance check while containing errors that will surface the moment someone stress-tests an assumption. Three specific checks should be run before any model is shared with an investor or lender.

A model that passes all three checks is structurally sound. A model that passes only the balance check may be structurally broken in ways not immediately visible. The distinction matters enormously: in a due diligence setting, a lender’s financial model review team will find structural errors quickly, and a model that fails that review damages the sponsor’s credibility in ways that are genuinely difficult to recover from. It is important to remember that investor confidence, once lost at the model review stage, rarely returns in the same engagement.

Sensitivity Analysis and Running Stress Tests From Your Integrated Model

The three-statement model becomes a genuine investment-readiness tool when it is built to support sensitivity analysis – the ability to change one assumption and watch the effect flow automatically through all three statements and all derived outputs (DSCR, IRR, NPV, minimum cash balance). This is what differentiates a model built for internal comfort from a model built for a capital raise. The discipline required is not sophisticated. It is structural.

That structure is called assumption architecture: all assumptions live in a dedicated input sheet, all calculations happen in separate working sheets, and outputs – the three statements, returns analysis, sensitivity tables – are displayed in presentation-ready sheets. Every revenue assumption, cost estimate, capital expenditure figure, debt term, and tax rate is entered once in the input sheet and referenced from there throughout the model. No assumption is hardcoded in a calculation cell. This sounds simple and is not always easy to enforce in practice, but it is the difference between a model that can be stress-tested in a meeting and one that requires an hour of spreadsheet archaeology before anyone can answer a basic question. Sponsors who demonstrate this discipline consistently move through lender credit committees more smoothly than those who do not. Understanding the role a financial model plays across different stages of the capital raising process helps explain why assumption architecture is not merely a formatting preference but a structural requirement.

For capital-intensive projects, the key sensitivity dimensions are:

• Commodity price or offtake volume (for energy: power price or generation volume; for mining: ore grade and metal price; for infrastructure: throughput and tariff)
• Construction cost overrun (percentage above base case capex)
• Construction delay (months added to the commissioning timeline)
• Discount rate and cost of capital
• Debt terms (margin, tenor, sculpting profile)

Presenting a sensitivity table showing how project DSCR, IRR, and NPV respond to simultaneous movements in the two or three most material assumptions is standard practice in an investment memorandum for any project finance transaction. What is equally important to understand is that the sponsor who can run these scenarios in real time during an investor conversation – who can say "let me show you what a significant construction cost overrun does to our minimum DSCR" and deliver that answer in 30 seconds – has demonstrated a level of financial discipline that builds genuine investor confidence. That confidence is not manufactured by the pitch deck. It is earned through the model. It is, in that sense, a form of earned trust made visible. Teams of capital raising advisors who support sponsors through roadshows consistently find that this live scenario capability is one of the most effective tools for sustaining investor momentum through the final stages of a transaction.

Frequently Asked Questions

What is the difference between a three-statement model and a simple cash flow forecast?

A cash flow forecast projects cash inflows and outflows over time, but it does not link to accounting profitability or balance sheet changes. A three-statement model integrates the income statement, balance sheet, and cash flow statement so that net income flows to retained earnings, depreciation appears across the P&L and balance sheet, and the cash flow statement reconciles to the balance sheet cash line. The model is a system; a forecast is a projection. For capital raises and project finance applications, investors require the integrated model because it forces the sponsor to demonstrate how accounting profit relates to actual cash – and where those two figures diverge.

Which statement do you build first in a three-statement financial model?

Build the income statement first. Revenue and cost assumptions are the foundation of everything that follows. Once the P&L is complete and producing net income and depreciation as outputs, those figures flow to the balance sheet (retained earnings and accumulated depreciation) and the cash flow statement (starting net income for the indirect method). Building the balance sheet before the P&L is complete creates circular reference problems and makes the model’s logic difficult for any third party – including a lender’s model review team – to follow.

How do you link the income statement to the balance sheet in Excel?

Net income from the bottom of the P&L flows to retained earnings on the equity side of the balance sheet via a formula: prior year retained earnings plus current year net income minus dividends. Depreciation from the P&L flows to accumulated depreciation on the asset side: the depreciation schedule drives both the P&L charge and the balance sheet contra-asset entry simultaneously. Capex from the capital expenditure schedule increases fixed assets on the balance sheet; it does not appear on the P&L. These formula connections mean that changing a revenue or cost assumption on the P&L flows through to the balance sheet automatically.

Why does my balance sheet not balance after I connect the three statements?

The most common cause is a retained earnings formula that is not properly linked to net income or does not roll forward the prior year balance correctly. The second most common cause is that cash on the balance sheet does not match the ending cash position on the cash flow statement – often because a financing or working capital item has been placed in the wrong section. A third cause is capex entered twice: once as an operating expense on the P&L and again in the investing section of the cash flow statement and on the balance sheet. Capex belongs in investing activities and on the asset side only.

Do I need a three-statement model to raise project finance, or is a cash flow model enough?

For project finance, lenders require a three-statement model. A cash flow model alone does not show the balance sheet position, the linkage between accounting profit and cash, or the equity section against which lender security may be assessed. The integrated model allows lenders to stress-test assumptions across all three statements, review DSCR under adverse scenarios, and assess whether the capital structure is supportable across the full project life. A standalone cash flow model will be treated as an incomplete submission at most project finance credit committees.

How do I handle depreciation in a three-statement model for a capital-intensive project?

Depreciation is a non-cash charge. On the P&L, it reduces net income and taxable income. On the balance sheet, it accumulates as a contra-asset against fixed assets each period. On the cash flow statement, it is added back to net income in the operating section because it did not represent a cash outflow – the cash was spent when the asset was purchased, which appears in the investing section as capex. Proper treatment of depreciation creates one of the three core reconciliation points in the integrated model. Misclassifying it – or treating it as a cash cost – produces errors that compound across all three statements simultaneously.

What does an investor or lender look at first when reviewing a three-statement model?

In lender due diligence, the first check is structural: does the balance sheet balance, does retained earnings roll forward correctly, and does the cash flow statement reconcile to balance sheet cash? A model that fails these checks does not survive long enough for the assumptions to be interrogated. Once structural integrity is confirmed, the focus shifts to the assumption sheet: are revenue assumptions supported by a contract or market evidence? Are cost assumptions specific or generic? Then stress-testing: minimum DSCR in the worst year, IRR sensitivity to an adverse movement in the key value driver. The three statements themselves are the output of that scrutiny – not the starting point.

How detailed does a three-statement model need to be for an information memorandum?

The model must be detailed enough to support every specific claim in the IM. If the IM states that the project generates a particular operating cash flow in Year 3, that figure must trace directly to the cash flow statement in the model. Revenue by offtake segment, cost breakdown by category, working capital assumptions by counterparty type – all of these must be present in the model if the IM discusses them. The model is not a black box that produces a summary output for the IM to reference. It is the single point of truth from which every number in the IM is derived – and any investor who asks to see the model behind the IM should find that the two documents are perfectly consistent.

Strong projects do not fail because of weak fundamentals. They fail because capital and structure do not meet at the right time – and more often than not, the reason they do not meet is that the model was not built with enough rigour to give either party the confidence to proceed. An integrated three-statement model, properly constructed with disciplined assumption architecture and a live debt schedule, is what closes that gap. It is the difference between a sponsor who talks about their project and one who can demonstrate exactly how it performs under pressure. In the end, the model is not the paperwork that follows the decision. It is the decision.