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. Download the Excel template: https://corporatefinanceinstitute.com...

Chapters:
00:00 - Introduction
00:44 - Corporate Finance Institute
00:59 - Objectives
01:49 - Prerequisites
02:34 - Why do we link the 3 financial statements?
03:42 - Model Layouts
05:21 - The Approach
06:42 - The 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
28:18 - Adjusting Investing Cash Flow
31:38 - Review
33:08 - Questions & Answers (Q&A)

FREE COURSES & CERTIFICATES

Enroll in our FREE online courses and earn industry-recognized certificates to advance your career:

► Introduction to Corporate Finance: https://loom.ly/us5oJEw
► Excel Fundamentals: https://loom.ly/4KnYciU
► Accounting Fundamentals: https://loom.ly/xHJgJO4
► Reading Financial Statements: https://loom.ly/2wrcPw8
► Fixed Income Fundamentals: https://loom.ly/DZdjDA0

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.corporatefinanceinsti...

Join us on social media!
LinkedIn:   / corporate-finance-institute-cfi  
Facebook:   / corporatefinanceinstitute.cfi  
Instagram:   / corporatefinanceinstitute  

#FinancialStatements #Excel #FinancialModeling #FinancialModelling