How Three Financial Statements are Linked: Free Tutorial and Video (2024)

The 3 financial statements are all linked and dependent on each other. Infinancial modeling, your first job is to link all three statements together in Excel, so it’s critical to understand how they’re connected.

Net Income & Retained Earnings

Net incomefrom the bottom of the income statement links to the balance sheet and cash flow statement. On the balance sheet, it feeds intoretained earningsand on the cash flow statement, it is the starting point for the cash from operations section.

PP&E, Depreciation, and Capex

Depreciationand other capitalized expenses on the income statement need to be added back to net income to calculate the cash flow from operations. Depreciation flows out of the balance sheet fromProperty Plant and Equipment(PP&E) onto the income statement as an expense, and then gets added back in the cash flow statement.

For this section of linking the 3 financial statements, it’s important to build a separatedepreciation schedule.

Capital expenditures add to the PP&E account on the balance sheet and flow through cash from investing on the cash flow statement.

Working Capital

Modelingnet working capitalcan sometimes be confusing. Changes in current assets and current liabilities on the balance sheet are related to revenues and expenses on the income statement but need to be adjusted on the cash flow statement to reflect the actual amount of cash received or spent by the business. In order to do this, we create a separate section that calculates the changes in net working capital.

Financing

This can be a tricky part of linking the three statements and requires some additional schedules. Financing events such as issuing debt affect all three statements in the following way: the interest expense appears on the income statement, the principal amount of debt owed sits on the balance sheet, and the change in the principal amount owed is reflected on the cash from financing section of the cash flow statement.

In this section, it’s often necessary to model adebt scheduleto build in the necessary detail that’s required.

Cash Balance

This is the final step in linking the 3 financial statements. Once all of the above items are linked up properly, the sum of cash from operations, cash from investing, and cash from financing are added to the prior period closing cash balance, and the result becomes the current period closing cash balance on the balance sheet.

This is the moment of truth when you discover whether your balance sheet balances!

How Three Financial Statements are Linked: Free Tutorial and Video (2024)

FAQs

What are the 3 financial statements and how do they link? ›

The income statement, balance sheet, and cash flow all connect to create the three-statement model. How? Changes in current assets and liabilities on the balance sheet are reflected in the revenues and expenses that you see on the income statement.

What are the three most important financial statements according to this resource link? ›

The three main types of financial statements are the balance sheet, the income statement, and the cash flow statement. These three statements together show the assets and liabilities of a business, its revenues, and costs, as well as its cash flows from operating, investing, and financing activities.

Why do you need all 3 financial statements? ›

The balance sheet, income statement, and cash flow statement each offer unique details with information that is all interconnected. Together the three statements give a comprehensive portrayal of the company's operating activities.

How are these 3 core statements used in financial modeling? ›

A three-statement model combines the three core financial statements (the income statement, the balance sheet, and the cash flow statement) into one fully dynamic model to forecast future results. The model is built by first entering and analyzing historical results.

What is the 3 statement model? ›

What is a 3-Statement Model? The 3-Statement Model is an integrated model used to forecast the income statement, balance sheet, and cash flow statement of a company for purposes of projecting its forward-looking financial performance.

How are the balance sheet and income statement connected? ›

The balance sheet shows the cumulative effect of the income statement over time. It is just like your bank balance. Your bank balance is the sum of all the deposits and withdrawals you have made. When the company earns money and keeps it, it gets added to the balance sheet.

What are the three financial statements for dummies? ›

The income statement illustrates the profitability of a company under accrual accounting rules. The balance sheet shows a company's assets, liabilities, and shareholders' equity at a particular point in time. The cash flow statement shows cash movements from operating, investing, and financing activities.

What are the 3 financial statements Excel model? ›

What is a 3-Statement Model? In financial modeling, the “3 statements” refer to the Income Statement, Balance Sheet, and Cash Flow Statement. Collectively, these show you a company's revenue, expenses, cash, debt, equity, and cash flow over time, and you can use them to determine why these items have changed.

What are the golden rules of accounting? ›

Every economic entity must present accurate financial information. To achieve this, the entity must follow three Golden Rules of Accounting: Debit all expenses/Credit all income; Debit receiver/Credit giver; and Debit what comes in/Credit what goes out.

Which financial statement must always be prepared first why? ›

The income statement should always be prepared before other statements because it provides an overview of the company's revenue and expenses during a specific period. This information is used in preparing other reports such as balance sheets and cash flow statements.

What is the relationship between P&L and balance sheet? ›

The profit and loss (P&L) account summarises a business' trading transactions - income, sales and expenditure - and the resulting profit or loss for a given period. The balance sheet, by comparison, provides a financial snapshot at a given moment.

Which financial statement is prepared first? ›

An income statement is typically the first financial statement prepared. This statement lays the groundwork for both the balance sheet and the cash flow statement, showcasing the net income from revenues and expenses, which impacts assets, liabilities, and equity.

What order do you complete financial statements? ›

Financial statements are prepared in the following order:
  • Income Statement.
  • Statement of Retained Earnings - also called Statement of Owners' Equity.
  • The Balance Sheet.
  • The Statement of Cash Flows.

How to prepare financial statements? ›

Follow these steps:
  1. Close the revenue accounts. Prepare one journal entry that debits all the revenue accounts. ...
  2. Close the expense accounts. Prepare one journal entry that credits all the expense accounts. ...
  3. Transfer the income summary balance to a capital account. ...
  4. Close the drawing account.

What is the relationship between balance sheet and profit and loss account? ›

The profit and loss (P&L) account summarises a business' trading transactions - income, sales and expenditure - and the resulting profit or loss for a given period. The balance sheet, by comparison, provides a financial snapshot at a given moment.

What is the use of different financial documents? ›

Financial documents, also known as financial statements, are used for reporting financial information about a business, in a standardized format. They include a balance sheet, an income statement, and a cash flow statement. A balance sheet is a snapshot in time of the financial condition of your business.

Is income statement and profit and loss the same? ›

A business profit and loss statement shows you how much money your business earned and lost within a period of time. There is no difference between income statement and profit and loss. An income statement is often referred to as a P&L.

What is the purpose of a profit and loss statement? ›

A P&L statement is a document that compares the total income of a business against its debt and expenses. A P&L statement is an indicator of the financial health of your company based on its ability to generate income through sales, manage expenses and sustain a healthy profit margin.

Top Articles
Latest Posts
Article information

Author: Rev. Porsche Oberbrunner

Last Updated:

Views: 6313

Rating: 4.2 / 5 (53 voted)

Reviews: 92% of readers found this page helpful

Author information

Name: Rev. Porsche Oberbrunner

Birthday: 1994-06-25

Address: Suite 153 582 Lubowitz Walks, Port Alfredoborough, IN 72879-2838

Phone: +128413562823324

Job: IT Strategist

Hobby: Video gaming, Basketball, Web surfing, Book restoration, Jogging, Shooting, Fishing

Introduction: My name is Rev. Porsche Oberbrunner, I am a zany, graceful, talented, witty, determined, shiny, enchanting person who loves writing and wants to share my knowledge and understanding with you.