Financial Modeling Tutorials by CFI - 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 https://www.facebook.com/corporatefinanceinstitute.cfi https://www.instagram.com/corporatefinanceinstitute #FinancialStatements #FinancialModeling