Courses / Cash Flow / Bridge to Case Study UFCF Upgrade AccountYour current access is limited. To continue watching this lesson, you'll need to purchase a subscription. Sign UpBridge to Case Study UFCFIn this lesson, we'll bridge from Adjusted EBITDA to Unlevered Free Cash Flow in Excel. We've learned how to do it conceptually, but now we'll put concepts into practice.DiscussionLesson MaterialsRestricted AccessYou need to sign up for a Lumovest subscription in order to join discussions. Sign UpRestricted AccessYou need to sign up for a Lumovest subscription in order to to download lesson materials. Sign UpCash Flow 1. What is Cash Flow (4:01) 2. Introduction to Cash Flow Statement (4:04) 3. Cash Flow from Operations (2:57) 4. Cash Flow from Investing (4:44) 5. Cash Flow from Financing (2:09) 6. Relationship Between the 3 Cash Flow Categories (2:56) 7. Treatment of Non-Cash Items (2:25) 8. Changes in Working Capital (2:49) 9. Capital Expenditures (CapEx) (4:33) 10. Growth vs. Maintenance CapEx (2:08) 11. Why Distinguish Growth CapEx from Maintenance CapEx (4:50) 12. Proceeds from Sale of Asset (3:20) 13. Acquisitions, Net of Cash Acquired (3:44) 14. Debt Financing (3:48) 15. Equity Financing (3:48) 16. Effect of Exchange Rate Changes on Cash and Cash Equivalents (2:00) 17. Net Change in Cash (3:12) 18. The Concept of Free Cash Flow (4:54) 19. The Purpose of Free Cash Flow (2:34) 20. Levered Free Cash Flow (LFCF) (6:24) 21. Bridge to Case Study LFCF (5:00) 22. Drivers of Levered Free Cash Flow (4:47) 23. LFCF as Driver of Equity Value (2:30) 24. Unlevered Free Cash Flow (UFCF) (4:23) 25. Marginal Tax Rate (MTR) (2:48) 26. Drivers of Unlevered Free Cash Flow (2:19) 27. Bridge to Case Study UFCF (4:01) 28. Free Cash Flow Conversion (3:18) 29. Free Cash Flow Yield (2:03) 30. Consistency of Free Cash Flow Ratios (1:10) 31. Connecting Dots (2:07) 32. Quiz #1 (5 Q's) 33. Quiz #2 (7 Q's) 34. Quiz #3 (9 Q's) 35. Quiz #4 (6 Q's) 36. Quiz #5 (6 Q's) 37. Quiz #6 (6 Q's)
