3 Statement Model

What is the 3 Statement Model?

A 3 statement model is a type of financial modeling which connects three key financial statements like the income statement, balance sheet and cash flow statement and prepares a dynamically connected one single financial model which is used as the base of complex financial models like leverage buyout, discounted cash flow, merger models and other financial models.


3 Statement Model

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: 3 Statement Model (wallstreetmojo.com)

A 3 statement model is a complex financial model which combines the three critical financial statementFinancial StatementFinancial statements are written reports prepared by a company's management to present the company's financial affairs over a given period (quarter, six monthly or yearly). These statements, which include the Balance Sheet, Income Statement, Cash Flows, and Shareholders Equity Statement, must be prepared in accordance with prescribed and standardized accounting standards to ensure uniformity in reporting at all levels.read more like income statementIncome StatementThe income statement is one of the company's financial reports that summarizes all of the company's revenues and expenses over time in order to determine the company's profit or loss and measure its business activity over time based on user requirements.read more, balance sheetBalance SheetA balance sheet is one of the financial statements of a company that presents the shareholders' equity, liabilities, and assets of the company at a specific point in time. It is based on the accounting equation that states that the sum of the total liabilities and the owner's capital equals the total assets of the company.read more, and cash flow statementCash Flow StatementA Statement of Cash Flow is an accounting document that tracks the incoming and outgoing cash and cash equivalents from a business.read more and integrates all the three into a single financial model. This model acts as the base for further critical models like DCF valuationDCF ValuationDiscounted cash flow analysis is a method of analyzing the present value of a company, investment, or cash flow by adjusting future cash flows to the time value of money. This analysis assesses the present fair value of assets, projects, or companies by taking into account many factors such as inflation, risk, and cost of capital, as well as analyzing the company's future performance.read more, merger and acquisition models, etc. It is also used for scenario and sensitivity analysisSensitivity AnalysisSensitivity analysis is a type of analysis that is based on what-if analysis, which examines how independent factors influence the dependent aspect and predicts the outcome when an analysis is performed under certain conditions.read more. The leading utility of these models is that in a single excel file, we can capture the fundamentals of three statements simultaneously. There is less risk of wrong linkages of formulas. It looks more organized when the entire thing is presented in a single excel file and rather than using three different models. It also provides an enhanced scope of consolidation of multi-business organizations.

You can learn the step by step 3 statement of Colgate from this link – Financial Modeling in ExcelFinancial Modeling In ExcelFinancial modeling in Excel refers to a tool used for preparing the expected financial statements predicting the company's financial performance in a future period using the assumptions and historical performance information.read more.

How to Create a 3 Statement Model?

A 3 statement model requires several steps to finally integrate all the three financial statements into a single model. The steps required are as follows:

How to Create a 3 Statement Model

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: 3 Statement Model (wallstreetmojo.com)

Step 1: Gathering or Collating Historical Information from Financial Statement in Single Excel File

In this step, financial information is obtained from the company website or their press release, and these are considered historical information. These data are either downloaded to a single excel file or copy-pasted into it. After doing this, the excel file needs to be formatted a bit to make the data readable and understandable.

Step 2: Chalking Out Assumptions which will Determine Forecasting

Now once we have the historical data in our excel file, we can implement some formulas to calculate or evaluate the historical performance of the company. Metrics such as margins, growth of revenues, capital expendituresCapital ExpendituresCapex or Capital Expenditure is the expense of the company's total purchases of assets during a given period determined by adding the net increase in factory, property, equipment, and depreciation expense during a fiscal year.read more, and working capital calculation can be considered as the following.

Step 3: Income Statement Forecasting

After all the assumptions taken into consideration, it is now the stage to forecast the income statement. It all begins from the revenue and drills now further to the calculation of the EBITDACalculation Of The EBITDAEBITDA is Earnings before interest, tax, depreciation, and amortization. Its formula calculates the company’s profitability derived by adding back interest expense, taxes, depreciation & amortization expense to net income. EBITDA = net income + interest expense + taxes + depreciation & amortization expenseread more. In this stage, we also require support scheduling methods for financing activity processes and capital assets.

Step 4: Capital Asset Forecasting

Here forecast is made on aspects like plant and machinery, property, and only after this, one can end the income statement part of the model. Here the closing balance of the last period is considered, and then the capital expenditure is added, or depreciationDepreciationDepreciation is a systematic allocation method used to account for the costs of any physical or tangible asset throughout its useful life. Its value indicates how much of an asset’s worth has been utilized. Depreciation enables companies to generate revenue from their assets while only charging a fraction of the cost of the asset in use each year. read more deducted to arrive at the final closing balance.

Step 5: Financing Activity Forecasting

Here we need to set up a schedule of debt plan to arrive at the interest expense on the income statementIncome StatementThe income statement is one of the company's financial reports that summarizes all of the company's revenues and expenses over time in order to determine the company's profit or loss and measure its business activity over time based on user requirements.read more. Here too, we consider the last period’s closing balance and then add to this any increase or decrease in the value of the principal to conclude the closing balance.

Step 6: Balance Sheet Forecasting

Here we consider the balance sheet information and working capitalWorking CapitalWorking capital is the amount available to a company for day-to-day expenses. It's a measure of a company's liquidity, efficiency, and financial health, and it's calculated using a simple formula: "current assets (accounts receivables, cash, inventories of unfinished goods and raw materials) MINUS current liabilities (accounts payable, debt due in one year)"read more elements are forecasted here, taking into consideration assumptions like average payable days, average receivables, inventory turns, etc. Capital assets come here from the schedule we mentioned above. Here the cash balance is not forecasted or completed, which is the last step of the 3 statement model.

Step 7: Cash Flow Statement Completion

The last stage of three-statement modeling is the completion of the cash flow statement. This statement requires a simple linking of the earlier items, calculated to arrive at the cash balance. There are three main sections: cash from operationsCash From OperationsCash flow from Operations is the first of the three parts of the cash flow statement that shows the cash inflows and outflows from core operating business in an accounting year. Operating Activities includes cash received from Sales, cash expenses paid for direct costs as well as payment is done for funding working capital.read more, cash from investing activityCash From Investing ActivityCash flow from investing activities refer to the money acquired or spent on the purchase or disposal of the fixed assets (both tangible and intangible) for the business purpose. For instance, the purchase of land and joint venture investment is cash outflow, while equipment sale is a cash inflow.read more, and cash from financing activityCash From Financing ActivityCash flow from financing activities refers to inflow and the outflow of cash from the financing activities like change in capital from securities like equity or preference shares, issuing debt, debentures or repayment of a debt, payment of dividend or interest on securities.read more. Thus, by linking these three to the other statements, we arrive at the final cash in hand/bank balance.


A template related to the 3 statement model based on excel is now attached. Here we have included historical data till 2020 and forecasted based on the same till 2025. Three key financial statements have been used: profit and loss statement, balance sheet, and cash flow statement. In the end, we have also attached a plan of schedule, and at the beginning of the template, there are the assumptions that have been considered.

3 Statement Model Example 1
You can download this Three Statement Model Excel Template here – Three Statement Model Excel Template


There are five steps to build a 3 statement model, and we rely on our base on historical. Assumptions are essential because we need to assume many factors like growth rate, interest rate, etc.

  1. Thus the first and foremost important approach is our assumptions, which means how the business will drive itself in the forecasted period.
  2. Next comes the income statement, which is a summary of profit and loss, and thus, based on the historical data, the future is predicted.
  3. After this, we have the balance sheet, which explains the position of the company at a particular point in time. Same as profit and loss statement here too based on historical data, we forecast the future period.
  4. After this, from data points in the above two statements, we build our cash flow statement, which is the ultimate goal of our 3 statement modeling. Here few data gets populated from profit and loss statement and balance sheet. Thus, we find all three statements are linked to one another. It shows the different levels of cash from operations, investing activity, and financing activity and finally arrives as closing cash balance or net cash balance.
  5. The last part of the three-statement model is the supporting schedules, which help calculate the depreciation or interest and other such factors.


The 3 statement model is very dynamic modeling to integrate all the key financial statements into a single excel file. This makes the job more organized and more comfortable and reduces the chances of human error. It is a very crucial model used for forecasting modules. It is also very user friendly, and because one uses excel to build it, this is easily understandable by all.

Recommended Articles

This has been a guide to the 3 Statement Model and its Meaning. Here we discuss how to create these models along with examples and approaches. You can learn more about from the following articles –