3-Statement Model: 90-Minute Case Study from a Blank Excel Sheet

Learn more: https://breakingintowallstreet.com/co... For all the files and resources, go to: https://mergersandinquisitions.com/3-... Table of Contents: 0:00 Introduction 2:35 What is a 3-Statement Modeling Test? 5:54 Part 1: Inputting the Historical Financial Statements 15:31 Balance Sheet Entry 24:14 Cash Flow Statement Entry 35:11 Part 2: Income Statement Projections 50:12 Part 3: Balance Sheet Projections 57:51 Part 4: Cash Flow Statement Projections 1:07:12 Part 5: Linking the Statements 1:10:59 Part 6: Debt and Stock Repurchases 1:19:16 Part 7: Model Checks, Review, and Final Comments 1:22:35 Recap and Summary