Hellow guys, Welcome to my website, and you are watching How to Link the 3 Financial Statements in Excel. and this vIdeo is uploaded by Corporate Finance Institute at 2017-06-28T12:19:15-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | How to Link the 3 Financial Statements in Excel |
| Video Uploader | Video From Corporate Finance Institute |
| Upload Date | This Video Uploaded At 28-06-2017 19:19:15 |
| Video Discription | 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/resources/knowledge/modeling/link-the-3-financial-statements-cfi-webinar/ 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.corporatefinanceinstitute.com/collections Join us on social media! LinkedIn: https://www.linkedin.com/company/corporate-finance-institute-cfi Facebook: https://www.facebook.com/corporatefinanceinstitute.cfi Instagram: https://www.instagram.com/corporatefinanceinstitute #FinancialStatements #Excel #FinancialModeling #FinancialModelling |
| Category | Education |
| Tags | 3 statement financial model | 3 statement model | three statement financial model | financial statements | three statement model | 3 financial statements | 3 statement modeling |
