The Three Financial Statements Explained

The three financial statements are the income statement, the balance sheet, and the cash flow statement. Together they describe performance over a period, position at a point in time, and the movement of cash that connects the two. A working financial model is mostly the job of wiring these three together so that net income, retained earnings, and the cash balance all agree.

What each statement shows

The income statement covers a period of time and reports revenue, expenses, and the resulting Net Income. It answers whether the business was profitable.

The balance sheet is a snapshot at a single date and obeys Assets = Liabilities + Equity. It answers what the business owns and owes right now.

The cash flow statement covers the same period as the income statement and reconciles the opening cash balance to the closing one through operating, investing, and financing activities. It answers where the cash actually went.

How they link in Excel

The statements are not independent. Net income flows from the income statement into both retained earnings on the balance sheet and the top of the cash flow statement. The closing cash from the cash flow statement becomes the cash line on the balance sheet.

1. Reference net income from the income statement, say =IncomeStatement!B20, into the top of the cash flow statement.
2. Add net income to opening retained earnings and subtract dividends to roll retained earnings forward on the balance sheet.
3. Set the balance sheet cash line equal to the cash flow statement closing cash with =CashFlow!B30.
4. Confirm Assets = Liabilities + Equity. If the balance sheet balances, the links are correct.

When closing cash flows into the balance sheet correctly, Assets = Liabilities + Equity holds with no plug.

Why the structure matters

Each statement alone can mislead. A company can report strong net income while running out of cash, or hold large assets funded entirely by debt. Reading all three together exposes those tensions.

Because the three are linked, an error in one usually breaks the balance sheet. That is a feature, not a bug. The balance check is the model's built in alarm.

• Profit without cash signals collection or capex problems.
• A balance sheet that will not balance flags a broken link or a missing item.
• The cash flow statement bridges accrual profit to real cash.

Common mistakes

The most frequent error is a balance sheet that does not balance, almost always caused by a one sided entry. If you add an asset, something on the other side, a liability, equity, or another asset, must move too.

Another trap is hardcoding a cash figure on the balance sheet instead of linking it to the cash flow statement. The number may look right today and silently break the moment an assumption changes. Linked statements update together; pasted values do not.