How to Link the 3 Financial Statements in Excel

The 3 financial statements are all linked and dependent on each other. In financial modeling, your first job is to link all three statements together in Excel, so it’s critical to understand how they’re connected. This is also a common question for investment banking interviews, FP&A interviews, and equity research interviews.

Chapters:
00:00 – Introducing CFI
00:59 – Objectives & Prerequisites
02:34 – Why do we Link the 3 Financial Statements?
03:42 – Model Layouts
05:21 – The Approach & Layout
07:25 – The Income Statement
10:51 – The Balance Sheet
13:06 – Accounts Payable
24:38 – Retained Earnings
25:25 – Balance Sheet Check
27:08 – Adjusting Working Capital & Investing Cash Flow
31:38 – Review, Questions & Answers

Explore CFI’s hands-on financial modeling courses to start building up your skill set: https://corporatefinanceinstitute.com/topic/financial-modeling

About Corporate Finance Institute: CFI is a leading global provider of online financial modeling and valuation courses for financial analysts. Our programs and certifications have been delivered to thousands of individuals at the world’s top universities, investment banks, accounting firms, and operating companies.

By taking our courses, you can expect to learn industry-leading best practices from professional Wall Street trainers. Our courses are extremely practical, with step-by-step instructions to help you become a first-class financial analyst.

Explore CFI courses: https://courses.corporatefinanceinstitute.com/collections

Join us on social media:
https://www.linkedin.com/company/corporate-finance-institute-cfi
See more
https://www.instagram.com/corporatefinanceinstitute

#FinancialStatements #FinancialModeling

source