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

How to answer how are the three financial statements linked? ›

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

What are the three financial statements and how are they interlinked? ›

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.

How are the three financial statements linked in Quizlet? ›

How are the three financial statements linked? The Income Statement is linked to the Balance Sheet and Statement of Cash Flows through Net Income. Net Income flows to the Balance Sheet through the Retained Earnings account within Shareholders' Equity.

How do the three statements link together in an interview question? ›

Net income which is profit before tax less tax expense is connected on all three financial statements. Net income is located at the bottom of the income statement and directly at the top of the cash flow statement followed by cash from operations. On the balance sheet, net income feeds into retained earnings.

What are the three 3 standard financial statements and describe how they relate to one another? ›

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 three financial statements for dummies? ›

The income statement, balance sheet, and statement of cash flows are required financial statements. These three statements are informative tools that traders can use to analyze a company's financial strength and provide a quick picture of a company's financial health and underlying value.

How are the main financial statements connected? ›

In summary, net income from the income statement flows to the top of the cash flow statement, which flows into the bottom of the balance sheet as retained earnings. Net income also impacts cash, which is reported at the bottom of the cash flow statement, which then flows into the top of the balance sheet.

What is the 3 financial statement exercise? ›

In a 3-statement model, you input the historical versions of these statements and then project them over a ~5-year period. In real life, you do this to value companies, model transactions, and determine whether the company's expected growth, margins, and cash flow metrics are plausible.

Which of the three financial statements are most important? ›

Typically considered the most important of the financial statements, an income statement shows how much money a company made and spent over a specific period of time.

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.

What is common in all three financial statements? ›

The concept of retained earnings is the centerpiece that links the three financial statements together. The retained earnings balance in the current period is equal to the prior period's retained earnings balance plus net income minus any dividends issued to shareholders in the current period.

What are the three 3 sections comprising the statement of financial position? ›

A company's balance sheet is comprised of assets, liabilities, and equity.

How are the three statements linked? ›

The major links in the three financial statements are: Net income from the IS links to the BS (retained earnings) and the CFS operating section. Property, plant and equipment in the BS creates depreciation in the IS and the CFS operating section, and also creates capital expenditure in the CFS investing section.

What is a 3 statement linked model? ›

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 part answer to interview questions? ›

You can mimic this formula to answer interview questions by following the pattern of scenario, solution, resolution. Following this three-step formula will not only help you make a positive impression on the hiring manager, but also ensure that you're answering every question with as much detail as possible.

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.

How are balance sheet and cash flow statement related? ›

The balance sheet shows a snapshot of the assets and liabilities for the period, but it does not show the company's activity during the period, such as revenue, expenses, nor the amount of cash spent. The cash activities are instead, recorded on the cash flow statement.

How to link income statement and cash flow? ›

The cash flow statement is linked to the income statement by net profit or net burn, which is the first line item of the cash flow statement. The profit or loss on the income statement is then used to calculate cash flow from operations. This is referred to as the indirect method.

Top Articles
Latest Posts
Article information

Author: Catherine Tremblay

Last Updated:

Views: 5647

Rating: 4.7 / 5 (67 voted)

Reviews: 82% of readers found this page helpful

Author information

Name: Catherine Tremblay

Birthday: 1999-09-23

Address: Suite 461 73643 Sherril Loaf, Dickinsonland, AZ 47941-2379

Phone: +2678139151039

Job: International Administration Supervisor

Hobby: Dowsing, Snowboarding, Rowing, Beekeeping, Calligraphy, Shooting, Air sports

Introduction: My name is Catherine Tremblay, I am a precious, perfect, tasty, enthusiastic, inexpensive, vast, kind person who loves writing and wants to share my knowledge and understanding with you.