An integrated financial model is a tool that projects a company’s three main financial statements in a connected manner: the income statement, the balance sheet and the cash flow statement. This type of model is commonly known as a three-statement model.

Its purpose is to analyse how operating, investment and financing decisions affect the business’s profitability, financial position and liquidity. To do so, it uses shared assumptions and accounting relationships that maintain consistency across the three statements in each forecast period.

1. What Makes Up an Integrated Financial Model

The three financial statements serve different but complementary purposes:

• Income Statement: Projects revenue, expenses and profit for the period, including operating costs, depreciation and amortisation, financial income and expenses, and taxes. The model also typically includes metrics such as EBITDA and EBIT.
• Balance Sheet: Records assets, liabilities and equity at the end of each period. It must satisfy the accounting equation: assets equal liabilities plus equity.
• Cash Flow Statement: Explains cash inflows and outflows from operating, investing and financing activities, and reconciles opening and closing cash balances.

Integration takes shape through the links between these statements. For example, an investment in fixed assets produces a cash outflow, increases assets and gives rise to depreciation charges that affect earnings in subsequent periods. In turn, net profit increases retained earnings within equity, while dividends paid reduce them.

These links are usually developed through supporting schedules for working capital, fixed assets, debt, taxes and equity.

2. Main Uses

Integrated financial models are used for:

• Planning and budgeting: Assessing the economic and financial impact of business plans and anticipating resource requirements.
• Business valuation: Providing a basis for projecting cash flows used in methods such as discounted cash flow (DCF) valuation.
• Sensitivity and scenario analysis: Examining how changes in sales, margins, investments, or collection and payment periods affect earnings, liquidity and debt levels.
• Financing analysis and negotiations: Estimating funding needs, debt-servicing capacity and compliance with financial covenants.

Their main benefit is that they reveal combined effects that may go unnoticed when analysed separately. For example, sales growth may improve profit while simultaneously increasing financing needs if it requires higher inventory levels or longer customer payment terms.

3. General Principles of Model Construction

Model construction starts with consistent historical information and explicit assumptions. The following components are then developed:

1. Assumptions and key variables, or drivers. The factors that explain the business’s performance are defined: volumes, prices, margins, collection and payment periods, investments and financing terms.
2. Operating and working capital forecasts. Revenue, operating expenses and activity-related balances, such as trade receivables, inventories and trade payables, are estimated.
3. Investment, financing and other items. Fixed assets and their depreciation and amortisation, debt drawdowns and repayments, interest, taxes and changes in equity are projected.
4. Integration of statements and cash balancing. Calculations are linked to produce earnings, cash flows and closing balance sheet balances. If liquidity shortfalls arise, the financing policy defined in the model is applied.

The balance sheet should balance as a consequence of these connections. Checking this is a consistency control, although it does not, by itself, guarantee that all assumptions and formulas are correct.

The quality of an integrated financial model depends on the consistency of its assumptions, the correct links between financial statements and the existence of controls to detect errors. A well-built model makes it possible to understand how business decisions jointly affect earnings, financial position and the company’s liquidity.

Conclusions

• An integrated financial model links the income statement, balance sheet and cash flow statement to project the business’s development consistently.
• It enables profitability, financial position and liquidity to be analysed together: an increase in profit does not always mean more cash is available.
• It is a useful tool for planning, valuing companies and anticipating financing needs.
• Its reliability depends on well-supported assumptions, correct links between statements and consistency checks. A balanced balance sheet is necessary, but does not in itself guarantee that the model is correct.

At MKD Advisors, we develop and review financial models for planning, investment analysis and corporate transactions. We help turn business assumptions into clear, adaptable tools that enable alternatives to be assessed and decisions to be supported. Discover our financial modelling services.