Free 3-statement model template and guide

How to build a 3-statement model

Finance builds the three statements in a specific order because pieces of data on one statement carry over to lines in the other two. Here’s how it works:

1. Input historical data into a spreadsheet

   The process begins by gathering historical financial data–including revenue, expenses, assets, liabilities, and cash flow from past periods–organizing it and entering it into a spreadsheet. This step forms the model's foundation and provides a baseline for identifying trends and building realistic projections.Best practices include:
   • Use data sources that cover all accounts to prevent gaps.
   • Structure data chronologically to align with reporting intervals.
   • Maintain consistent formatting for units, labels, and values.
   • Verify that historical net income matches retained earnings on the prior balance sheet and that cash balances align with past and current cash flow statements.
   • Cross-check key accounts like payables, receivables, and inventory for consistency.
   Approaching this step with precision and attention to detail can help minimize errors that could cascade through the model. Starting with clean, consistent data will help prevent errors as the model takes shape.

2. Set the assumptions for forecasting

   Assumptions are the foundation of any financial model. They’re the key drivers like revenue growth rates, profit margins, and planned capital expenditures that let finance teams project future performance and test different scenarios. These inputs are important because they shape every calculation across the income statement, balance sheet, and cash flow statement.Best practices include:
   • Determine which metrics are most relevant.
   • Create a dedicated assumptions section in the spreadsheet to keep inputs centralized and easy to update.
   • Label each assumption clearly with corresponding units.
   • Base assumptions on historical trends, market research, and internal goals.
   • Link assumptions to other parts of the model using formulas to see the immediate impact on forecasts when assumptions are adjusted.
   Thoughtfully defined assumptions make it easier to answer questions like, “What happens to cash flow if expenses grow faster than revenue?” or “How much investment is needed to achieve the company’s goals?” Creating a flexible and actionable model that adapts to changing assumptions will be key for forecasting and decision-making.

3. Forecast the income statement

   The income statement is the starting point for every 3-statement model and lays the groundwork for linking all three financial statements. Based on the assumptions set earlier, calculate projected revenue, gross profit, operating income, and net income.Here’s how to forecast the income statement:
   • Revenue: Apply growth rates from the assumptions section to historical revenue figures to calculate projected revenue.
   • Gross profit: Subtract projected COGS from revenue. Use historical data or benchmarks to estimate COGS as a percentage of revenue.
   • Operating income: Subtract operating expenses, including salaries, rent, and marketing, from gross profit to calculate operating income.
   • Taxes and interest: Apply the tax rate and include interest expenses to arrive at net income.
   Remember, each figure builds on the last and connects to the other statements. Specifically, net income flows into retained earnings on the balance sheet and serves as the starting point for operating cash flow on the cash flow statement. Accurate forecasting at this stage is especially important for consistency.

4. Forecast capital expenditures and assets

   Next comes forecasting capital expenditures (CapEx). These expenditures represent long-term investments in assets like property, equipment, or technology upgrades and must be integrated into the 3-statement model to reflect their impact on cash flow, depreciation, and financial position.Best practices include:
   • Estimate CapEx needs based on historical trends, planned projects, and growth goals.
   • Calculate depreciation schedules by assigning rates based on asset type and lifespan.
   • Adjust the balance sheet by adding CapEx to property, plant, and equipment (PP&E) under assets and reducing it annually by the calculated depreciation amount. Depreciation also reduces net income, flowing into retained earnings.
   • Update the cash flow statement by recording CapEx as a cash outflow in the investing activities section.
   Projecting CapEx and assets accurately can help cultivate a better understanding of the long-term impact of investments on cash flow and financial health. Make sure to regularly review forecasts to account for new projects or changes in strategy.

5. Forecast financing activities

   Accounting for financing activities like taking out loans, repaying debt, or issuing equity is the next step. Every financing decision impacts all three financial statements in unique ways, so planning for changes in financial structure is essential.Best practices include:
   • Determine the amount, timing, and terms of new loans or debt repayments.
   • For new loans, add the amount to liabilities on the balance sheet. Deduct repayment amounts from liabilities.
   • Record interest expenses on the income statement under financing costs.
   • Reflect cash inflows from new loans and outflows for repayments in the financing section of the cash flow statement.
   • If issuing new shares or repurchasing equity, update the equity section of the balance sheet to reflect these transactions and include any cash inflows from share issuances or outflows for buybacks in the financing section of the cash flow statement.
   Keep in mind that financing activities typically incur costs like interest or dividends:
   • Interest payments reduce net income on the income statement and flow into operating cash flow adjustments.
   • Dividend payments reduce retained earnings on the balance sheet and appear as outflows in the financing section of the cash flow statement.

6. Finish the income statement

   Once all revenue, expense, and financing details are entered, the focus shifts from forecasting to finalizing the income statement. Using actual data to complete gross profit, operating income, and net income helps ensure the income statement is calculated accurately and connected to the balance sheet and cash flow statement.Here’s how to calculate the final income statement:
   • Gross profit: Using actual revenue and COGS projections, compute gross profit by subtracting direct costs from revenue.
   • Operating income: Use finalized gross profit and subtract operating expenses such as salaries, utilities, and other indirect costs.
   • Net income: Apply finalized tax rates and interest expenses to the pre-tax income figure.
   Here, net income is the ultimate measure of profitability for the period and connects to the other statements:
   • Balance sheet: Net income flows directly into retained earnings, adjusting the company’s equity.
   • Cash flow statement: Net income is also the starting point for operating activities. Non-cash items (like depreciation and amortization) are added back during this process to reflect the cash flow.

7. Finish the balance sheet

   With the income statement finalized, it’s time to update the balance sheet to complete the second piece of the 3-statement model. That means consolidating the results from prior calculations to reflect changes in assets, liabilities, and equity for the reporting period.Best practices include:
   • Use net income from the income statement to adjust retained earnings–the portion of net income not distributed as dividends, which increases the equity section of the balance sheet.
   • Account for CapEx added during the period and subtract depreciation from the PP&E balance and total assets to reflect asset value over time.
   • Reconcile current assets and liabilities by updating accounts receivable, accounts payable, and inventory figures.
   • Verify that the cash balance on the balance sheet matches the closing balance on the cash flow statement.
   The balance sheet must “balance”—total assets should equal liabilities plus equity. If it doesn’t, you’ll need to track down errors. Double-check that changes in PP&E, retained earnings, and working capital align with figures on the income statement and cash flow statement.

8. Finish the cash flow statement

   The cash flow statement is the final piece of the 3-statement model, connecting data from the income statement. Here, using actual results from the reporting period (rather than projections) to complete the calculations helps show how cash actually moves through the business.Best practices include:
   • Pull net income from the income statement as the starting point for the operating cash flow statement. It represents profitability before non-cash adjustments and changes in working capital.
   • Add back non-cash expenses (like depreciation and amortization), which reduce net income but don’t impact cash flow.
   • Account for changes in working capital using data from the balance sheet to reflect increases or decreases in accounts receivable, inventory, and accounts payable.
   • Reflect cash inflows and outflows related to CapEx or other investments.
   • Add data from the financing section of the balance sheet, including loan repayments, new borrowings, or equity transactions.
   • Calculate the net change in cash for the period by adding cash flows from operating, investing, and financing activities.
   • Calculate the closing cash balance by adding the net change to the opening cash balance from the prior period’s balance sheet.
   Make sure the closing cash balance reconciles with the ending cash line on the balance sheet to avoid errors.

9. Link the three statements

   Linking the income statement, balance sheet, and cash flow statement is the final step in building a 3-statement model. Creating these connections ensures that changes in one statement dynamically impact the others for a clearer and more accurate picture of financial performance.Key connections to keep in mind:
   • Net income links the income statement to the balance sheet and cash flow statement.
   • Depreciation connects the income statement, balance sheet, and cash flow statement.
   • Working capital changes connect the balance sheet and cash flow statement.
   • CapEx links the balance sheet and cash flow statement.
   • Financing activities link the cash flow statement and balance sheet.
   • Closing cash balance ties the cash flow statement to the balance sheet.
   Creating these links in a spreadsheet will require attention to detail and a solid understanding of financial relationships. Formulas can help automate connections—for example, by referencing net income from the income statement directly on the balance sheet. Make sure figures match across statements to avoid errors and test formulas and links regularly to confirm that changes in one statement update the others correctly.

10. Model and review

    Once all three financial statements are linked and the 3-statement model is complete, shift focus to reviewing and refining the model to make sure it’s accurate, dynamic, and useful for decision-making.Best practices include:
    • Adjust key assumptions to test their impact on the model and analyze how changes cascade across each statement.
    • Validate key relationships to confirm that net income, depreciation, working capital changes, and CapEx entries are consistently represented across statements.
    • Audit key formulas to make sure they reference the correct cells and produce logical results.
    • Check for formula errors to identify broken links, circular references, or incomplete formulas.
    • Confirm the model can adapt to changing inputs without breaking.
    A solid review process produces a clear, accurate view of the model’s performance and adaptability. Testing scenarios and double-checking links between statements help identify inconsistencies, refine assumptions, and make adjustments. With the 3-statement model as a reliable decision-making tool, organizations can get actionable insights into multiple financial scenarios for better planning and risk management.