Welcome to the final lesson of our first module on Financial Accounting Fundamentals. Over the past few lessons, we have built a solid understanding of the three core financial statements. We've examined the Income Statement's picture of profitability, the Balance Sheet's snapshot of financial position, and most recently, the Cash Flow Statement's reconciliation of profit to actual cash.
You learned that the Cash Flow Statement is the crucial link between the other two, but the connections run much deeper. The three statements are not independent documents; they are three different views of the same underlying business reality, intricately woven together.
In this lesson, we will explore precisely how these statements are interconnected to form a single, dynamic, and coherent system. Mastering this concept is the bedrock of financial modeling and a non-negotiable skill for any analyst. Our goal is to explain how a change in one part of the system ripples through all three statements, ensuring the entire model remains internally consistent and balanced.
The Blueprint: Understanding the Core Connections
Before we dive into the mechanics of building a linked model, it's essential to understand the conceptual blueprint of how the statements relate to one another. At a high level, the Income Statement and the Balance Sheet provide the inputs, and the Cash Flow Statement acts as the reconciliation engine that connects them and validates the entire system.
The following video from 365 Financial Analyst provides an excellent conceptual overview of these fundamental dependencies.
Financial Statements Explained | Balance Sheet | Income Statement | Cash Flow Statement
This video, titled "Financial Statements Explained," clearly illustrates the key dependencies between the three statements. It breaks down how each section of the Cash Flow Statement draws information from the Income Statement and the Balance Sheet.
Please watch the section from the beginning of the discussion on interrelations. As you watch, focus on the following key relationships: How Cash Flow from Operations (CFO) starts with Net Income (from the Income Statement) and is adjusted by changes in current assets and liabilities (from the Balance Sheet). How Cash Flow from Investing (CFI) is primarily driven by changes in non-current assets (e.g., PP&E on the Balance Sheet). How Cash Flow from Financing (CFF) is driven by changes in non-current liabilities and equity (e.g., Debt and Share Capital on the Balance Sheet). Finally, how the total Net Change in Cash on the Cash Flow Statement must reconcile with the change in the Cash account on the Balance Sheet between two periods.
To summarize and formalize these crucial links:
-
Net Income (IS) → Retained Earnings (BS): Net Income from the Income Statement for a given period increases the Retained Earnings account within Shareholders' Equity on the Balance Sheet. The formula is:
-
Net Income & Depreciation (IS) → CFO (CFS): The Cash Flow Statement (using the indirect method) begins with Net Income from the Income Statement. It then adds back non-cash charges, the most common of which is Depreciation and Amortization, which is also an expense on the Income Statement.
-
Balance Sheet Changes → CFS: The Cash Flow Statement is almost entirely built from the changes in Balance Sheet accounts from one period to the next.
- CFO: Changes in working capital accounts (e.g., Accounts Receivable, Inventory, Accounts Payable) are used to adjust Net Income.
- CFI: Purchases or sales of long-term assets, like Property, Plant & Equipment (PP&E), drive this section.
- CFF: Issuance or repayment of debt, issuance or repurchase of stock, and payment of dividends are all reflected in changes to the liability and equity sections of the Balance Sheet.
-
Ending Cash (CFS) → Cash (BS): This is the final, crucial link. The ending cash balance calculated on the Cash Flow Statement becomes the cash balance on the end-of-period Balance Sheet. This link ensures that the fundamental accounting equation (Assets = Liabilities + Equity) holds true, thereby "balancing" the model.
The Assembly: A Practical Walkthrough of a 3-Statement Model
Understanding the links conceptually is one thing; seeing them work in a live model is another. We will now walk through the key steps of building a linked 3-statement model in Excel. This is the core practical application of the concepts we've just discussed.
The following video from the Corporate Finance Institute (CFI) provides an accelerated but clear demonstration. We will focus on the specific moments where the statements are connected.
Financial Modeling Tutorial | Build a Three-Statement Model in 30 Minutes with CFI CEO Tim Vipond
This tutorial, "Build a Three-Statement Model in 30 Minutes," is led by CFI's CEO. It offers a clear, practical demonstration of how analysts link the financial statements in Excel, starting from a set of assumptions.
We will watch several key segments to see the connections being made in real-time. Follow the logic as the presenter builds the model.
Step 1: Linking Operations from the IS to the BS
The first set of links involves using outputs from the Income Statement (like Revenue and COGS) to drive operational accounts on the Balance Sheet.
Financial Modeling Tutorial | Build a Three-Statement Model in 30 Minutes with CFI CEO Tim Vipond
Watch how the presenter calculates the forecast for Accounts Receivable, Inventory, and Accounts Payable.
In the video, watch the segment from linking the balance sheet. Notice how: Accounts Receivable is calculated as a function of Revenue from the Income Statement. Inventory and Accounts Payable are calculated as a function of Cost of Goods Sold (COGS) from the Income Statement. This shows a direct dependency: the company's operating performance (IS) dictates the state of its working capital (BS).
Step 2: Building Supporting Schedules (The "Corkscrews")
Complex Balance Sheet items like PP&E and Debt cannot be forecasted in a single line. They require "supporting schedules" that track their balances over time. These schedules often use a structure known as a corkscrew, because the closing balance of one period "corkscrews" down to become the opening balance of the next.
The generic formula for a corkscrew schedule is:Opening Balance + Additions - Subtractions = Closing Balance
Financial Modeling Tutorial | Build a Three-Statement Model in 30 Minutes with CFI CEO Tim Vipond
This segment is critical as it shows the construction of the schedules that will provide the inputs for depreciation, capital expenditures, interest, and debt changes.
Watch carefully from the depreciation schedule section. Pay close attention to: The PP&E schedule, where Opening PP&E + Capex - Depreciation = Closing PP&E. The Debt schedule, where Opening Debt + Issuance/Repayments = Closing Debt. How depreciation and interest expense are calculated within these schedules.
These schedules are the engine room of the model. They generate key values that will be plugged back into all three statements.
Step 3: The Grand Finale: Linking and Balancing
Now we arrive at the most important sequence of steps. Here, all the pieces we have built—the Income Statement, the Balance Sheet drivers, and the supporting schedules—come together. The presenter will build the Cash Flow Statement and then make the final, critical link that balances the entire model.
Financial Modeling Tutorial | Build a Three-Statement Model in 30 Minutes with CFI CEO Tim Vipond
This is the climax of the modeling process. You will see values from all over the model being pulled into the Cash Flow Statement, and then see the final balancing connection made.
Watch this final construction segment from linking the supporting schedules. Follow this sequence closely: Linking Schedules to IS/BS: The presenter plugs Depreciation and Interest from the schedules into the Income Statement, and the closing PP&E and Debt balances into the Balance Sheet. Building the CFS: He then constructs the Cash Flow Statement by linking: Net Income from the IS. Depreciation from the IS/PP&E schedule. Changes in Working Capital from the BS/WC schedule. Capital Expenditures (Capex) from the PP&E schedule. Debt & Equity changes from the assumptions/debt schedule. The Final Link: The Ending Cash balance from the CFS is linked to the Cash account at the top of the Balance Sheet. At this moment ("let's add the cash"), the check-sum at the bottom of the Balance Sheet goes to zero, and the model balances. This is a moment of great satisfaction for any financial modeler.
This final link closes the loop. The Balance Sheet is now balanced because the Cash Flow Statement has perfectly explained the change in every account, ensuring that the total change in assets equals the total change in liabilities and equity.
Testing the System: The Power of a Dynamic Model
Why go through all this trouble? Because a fully linked model is a powerful analytical tool. By changing a single assumption, you can see the impact ripple through the entire financial picture of the company.
Financial Modeling Tutorial | Build a Three-Statement Model in 30 Minutes with CFI CEO Tim Vipond
In this final clip, the presenter performs a quick sanity check by changing a key assumption (revenue growth) and analyzing the impact.
Watch from "play around with a model". Observe how changing the revenue growth rate instantly changes not just the Income Statement, but also the working capital on the Balance Sheet and the cash flow generation on the Cash Flow Statement, ultimately affecting the company's cash balance over time. This demonstrates the "dynamic" nature of the model.
Conclusion
In this lesson, we have connected all the dots, moving from the individual components of the financial statements to a holistic, integrated system. You have seen both conceptually and practically how the three statements are not separate reports, but a unified model of a company's financial DNA.
Key Takeaways:
- The three financial statements are intricately linked and cannot be viewed in isolation.
- Net Income from the Income Statement is the starting point for both the Cash Flow Statement (CFO section) and the change in Retained Earnings on the Balance Sheet.
- The Cash Flow Statement is built by analyzing the period-over-period changes in Balance Sheet accounts.
- Supporting schedules (like PP&E and Debt corkscrews) are essential tools for modeling complex accounts and generating key inputs like depreciation and interest.
- The entire system is closed and balanced by linking the Ending Cash from the Cash Flow Statement back to the Cash account on the Balance Sheet.
You have now completed the first module of this course, establishing a strong foundation in financial accounting. In the next module, "Analyzing Financial Performance," we will build directly on this knowledge. You will learn how to use the data from these interconnected statements to calculate and interpret financial ratios, allowing you to assess a company's profitability, liquidity, solvency, and efficiency.