Beginner to Pro in Excel Financial Modeling and Valuation

1. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.mp4114.91MB
2. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.mp48.95MB
3. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The approach to take this course.mp47.83MB
4. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/2. Introduction to Excel/1. Introduction to Excel - welcome lecture.mp41.99MB
5. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/2. Introduction to Excel/2. Overview of Excel.mp413.96MB
6. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/2. Introduction to Excel/4. Basic manipulations with rows and columns.mp46.9MB
7. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/2. Introduction to Excel/6. The Excel ribbon.mp48.8MB
8. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/2. Introduction to Excel/7. Data entry in Excel.mp410.39MB
9. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/2. Introduction to Excel/8. Introduction to formatting.mp424.75MB
10. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/2. Introduction to Excel/9. Introduction to Excel formulas.mp45.85MB
11. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/2. Introduction to Excel/11. Introduction to Excel functions.mp412.06MB
12. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/2. Introduction to Excel/12. Cut, copy, & paste.mp47.57MB
13. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/2. Introduction to Excel/14. Paste special.mp46.69MB
14. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/1. Excel best practices - Welcome lecture.mp42.13MB
15. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/2. Initial formatting of an Excel sheet to render it professional.mp43.35MB
16. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/3. Fast scrolling through Excel sheets.mp46.26MB
17. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/5. Introduction to fixing of cell references.mp46.13MB
18. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/7. Using the 'Alt + Enter' combination.mp41.46MB
19. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/8. Learn how to organize your data with Text to Columns.mp43.94MB
20. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/10. Learn how to use the Wrap Text button.mp4908.39KB
21. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/11. Create easily printable documents in Excel by using Set Print Area.mp41.71MB
22. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/12. Find and select special types of cells with Select Special (F5).mp43.04MB
23. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/14. Learn how to assign dynamic names within a financial model.mp42.33MB
24. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/16. Define a named range in Excel.mp42.12MB
25. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/17. Assign custom formats to specific cells within a financial model (e.g Multiples).mp42.14MB
26. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/18. Macros are a great timesaver! Here's why!.mp44.33MB
27. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/20. Create a drop-down list by using Data Validation.mp43.3MB
28. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/21. Using Custom-sort in order to sort multiple columns within a table.mp42.79MB
29. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/22. Create a great Index page at the beginning of your models - Hyperlinks.mp41.9MB
30. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/23. Fix the top row of your table with Freeze Panes.mp45.2MB
31. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/24. Filter by color - an excellent tool.mp49.87MB
32. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/3. Useful tips and tools for your work in Excel/25. Working with conditional formatting.mp415.09MB
33. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/4. Keyboard shortcuts in Excel/1. Keyboard shortcuts Save LOTS of time in Excel.mp430.43MB
34. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/5. Excel's key functions and functionalities made easy/1. Excel's key functions - Welcome lecture.mp42.32MB
35. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/5. Excel's key functions and functionalities made easy/3. Key Excel functions Sum, Sumif and Sumifs.mp46.73MB
36. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/5. Excel's key functions and functionalities made easy/4. Key Excel functions Count, Counta, Countif, Countifs.mp46MB
37. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/5. Excel's key functions and functionalities made easy/5. Key Excel functions Average and Averageif.mp42.77MB
38. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/5. Excel's key functions and functionalities made easy/7. Elaborate text efficiently Left, Right, Mid, Upper, Lower,Proper, Concatenate.mp46.31MB
39. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/5. Excel's key functions and functionalities made easy/9. Find the minimum or maximum value in a range of cells in Excel.mp41.9MB
40. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/5. Excel's key functions and functionalities made easy/10. Include Round in your financial models.mp41.23MB
41. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/5. Excel's key functions and functionalities made easy/11. Learn how to transfer data efficiently in Excel Vlookup and Hlookup.mp412.11MB
42. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/5. Excel's key functions and functionalities made easy/12. Index, Match and their combination - the perfect substitute for Vlookup.mp412.81MB
43. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/5. Excel's key functions and functionalities made easy/13. A great Excel technique Index, Match, Match.mp411.76MB
44. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/5. Excel's key functions and functionalities made easy/15. Using Excel's Iferror function to trap spreadsheet errors.mp42.62MB
45. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/5. Excel's key functions and functionalities made easy/16. Learn how to render your models flexible with Choose.mp43.39MB
46. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/5. Excel's key functions and functionalities made easy/17. Use Goal Seek to find the result that you are looking for.mp43.02MB
47. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/5. Excel's key functions and functionalities made easy/19. Include sensitivity analysis in your models through Data Tables.mp45.43MB
48. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/5. Excel's key functions and functionalities made easy/21. Excel's dynamic and interactive tables Pivot tables.mp45.32MB
49. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/6. Update! 15 December - Exercise/2. Exercise - Excel's Sumifs function - solved & explained.mp412.68MB
50. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/7. Financial functions in Excel/1. Future and present values in Excel.mp414.96MB
51. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/7. Financial functions in Excel/2. Calculating the rate of return of an investment with the IRR function.mp47.58MB
52. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.mp414.82MB
53. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/7. Financial functions in Excel/4. Date functions in Excel.mp411.36MB
54. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/8. Microsoft Excel's Pivot Tables in Depth/1. Introduction to Pivot Tables and the way they are applied.mp46MB
55. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/8. Microsoft Excel's Pivot Tables in Depth/2. Creating Pivot Tables easily!.mp419.37MB
56. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/8. Microsoft Excel's Pivot Tables in Depth/3. Give your Excel Pivot Tables a makeover.mp411.27MB
57. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/8. Microsoft Excel's Pivot Tables in Depth/4. Modifying and pivoting fields to obtain the Pivot Table you need.mp423.01MB
58. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/8. Microsoft Excel's Pivot Tables in Depth/5. Learn more about GetPivotData - A very important Excel function.mp418.06MB
59. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/8. Microsoft Excel's Pivot Tables in Depth/6. An introduction to slicers - The modern-day Pivot Table filters.mp422.16MB
60. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/1. Case study - Build a P&L from scratch - Welcome lecture.mp43.13MB
61. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/2. Introduction to the case study.mp42.42MB
62. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/3. Understand your data source before you start working on it.mp46.78MB
63. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/4. Order the source worksheets.mp45.68MB
64. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/5. Create a code the best way to organize your data and work efficiently with it.mp45.99MB
65. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/6. Learn how to create a database.mp45.45MB
66. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/7. Use Vlookup to fill the Database sheet.mp414.65MB
67. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/8. 50% Completed!.mp44.3MB
68. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/9. Use SUMIF to complete the Database sheet.mp413.29MB
69. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/10. Use Index & Match as a substitute for Vlookup.mp412.66MB
70. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/11. Mapping the rows in the Database sheet.mp49.41MB
71. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/12. Building the structure of the P&L sheet.mp43.91MB
72. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/13. Formatting sets You apart from the competition in Excel - A Practical Example.mp45.71MB
73. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/14. Populate the P&L sheet with Sumif.mp46.43MB
74. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/15. Learn how to find mistakes with Countif.mp47.47MB
75. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/16. Calculating year-on-year percentage variations the proper way.mp46.83MB
76. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/17. Create professional and good-looking charts - Introduction.mp41.19MB
77. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/18. Build a Column Stacked chart with a secondary line axis in Excel.mp411.3MB
78. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/19. Learn how to build effective Doughnut charts in Excel.mp47.48MB
79. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/20. Learn how to build an Area chart in Excel.mp48.02MB
80. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/21. Learn how to create Bridge charts.mp418.77MB
81. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/9. Case study - Building a complete P&L from scratch in Excel/23. Course Challenge - Apply your skills in practice!.mp47.92MB
82. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/10. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.mp412.05MB
83. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/10. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.mp422.6MB
84. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/10. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.mp421.96MB
85. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/10. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.mp411.66MB
86. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/10. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.mp413.51MB
87. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/10. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.mp48.83MB
88. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/10. Case Study - Building an FMCG Model from Scratch/7. Creating a Master Pivot Table The main data source for the FMCG report.mp413.82MB
89. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/10. Case Study - Building an FMCG Model from Scratch/8. GetPivotData is great! Extracting data from the Master Pivot Table.mp431.05MB
90. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/10. Case Study - Building an FMCG Model from Scratch/9. Combining Slicers and GetPivotData The key to our success.mp417.83MB
91. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/10. Case Study - Building an FMCG Model from Scratch/10. Getting fancy with Excel slicers - Good-looking Excel slicers.mp417.12MB
92. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/10. Case Study - Building an FMCG Model from Scratch/11. This is how the report can be used in practice by high-level executives.mp419.81MB
93. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/11. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.mp42.1MB
94. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/11. Financial Modeling Fundamentals/2. What is a financial model.mp44.6MB
95. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/11. Financial Modeling Fundamentals/3. Why use financial models.mp47.69MB
96. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/11. Financial Modeling Fundamentals/4. Financial modeling - worst practices - things you should avoid.mp419.91MB
97. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/11. Financial Modeling Fundamentals/5. Financial modeling - best practices.mp417.22MB
98. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/11. Financial Modeling Fundamentals/6. Financial modeling - The types of models that are built in practice.mp412.5MB
99. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/11. Financial Modeling Fundamentals/8. Financial modeling The right level of detail in a model.mp45.68MB
100. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/11. Financial Modeling Fundamentals/9. Financial modeling Forecasting guidelines.mp46.44MB
101. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/11. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.mp46.44MB
102. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/11. Financial Modeling Fundamentals/12. Modeling the Income statement.mp412.44MB
103. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/11. Financial Modeling Fundamentals/13. Modeling the Balance sheet - Part 1.mp45.22MB
104. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/11. Financial Modeling Fundamentals/14. Modeling the Balance sheet - Part 2.mp49.38MB
105. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/1. Valuation Case study - Welcome lecture.mp41.78MB
106. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/2. Introduction to the DCF exercise.mp44.5MB
107. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/3. The various stages of a complete DCF Valuation.mp48.58MB
108. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/4. Description of the structure of the DCF model.mp44.48MB
109. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/5. A glimpse at the company we are valuing - Cheeseco.mp41.74MB
110. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/6. Modeling the top line.mp45.14MB
111. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/7. Introducing scenarios to the model with Choose.mp43.2MB
112. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/8. Modeling other items Other revenues and Cogs.mp47.42MB
113. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/9. Modeling other items Operating expenses and D&A.mp45.27MB
114. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp45.14MB
115. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/11. Forecasting Balance Sheet items.mp41012.43KB
116. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/12. An introduction to the Days methodology.mp42.28MB
117. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/13. Calculation of DSO, DPO and DOI for the historical period.mp42.69MB
118. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/14. Forecasting DSO, DPO and DOI.mp43.95MB
119. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp44.73MB
120. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/16. Creating an output P&L sheet.mp43.74MB
121. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/17. Populating the output P&L sheet.mp45.36MB
122. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/18. Populating the output BS sheet.mp43.39MB
123. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/19. Completing the output BS sheet for the historical period.mp47.53MB
124. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/20. Creating a structure for the calculation of Unlevered Free Cash Flows.mp44.07MB
125. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/21. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp42.73MB
126. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/22. Calculating Unlevered Free Cash Flow.mp410.79MB
127. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/23. Calculating Net Cash Flow.mp47.1MB
128. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/24. Obtaining the rest of the cash flows through Find and Replace.mp49.74MB
129. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/25. Introducing Weighted Average Cost of Capital and Perpetuity Growth.mp42.71MB
130. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/26. Discounting Unlevered Free Cash Flows to obtain their Present Value.mp43.97MB
131. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/27. Calculating Continuing Value and Enterprise Value of the business.mp43.45MB
132. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/28. Calculating Equity Value.mp42.48MB
133. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/29. Sensitivity analysis for WACC and perpetuity growth.mp48.61MB
134. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/30. A possible application of Goal Seek.mp43.2MB
135. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/31. Using charts to summarize the results of the DCF model.mp48.24MB
136. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/14. Learn how to build a Discounted Cash Flow model in Excel/32. You Made It!.mp47.6MB
137. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.mp431.01MB
138. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/2. The input data we will work with.mp415.81MB
139. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/4. Comparing delivery figures with the ones of industry peers.mp420.93MB
140. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.mp441.92MB
141. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.mp446.57MB
142. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/7. Peer comparison Gross profit %.mp417.17MB
143. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/8. Calculating automotive gross profit.mp427.76MB
144. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/9. Calculating automotive cost of sales.mp417.49MB
145. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/10. Forecasting 'energy' and 'services' revenue.mp425.3MB
146. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/11. Calculating 'energy' and 'services' gross profit and cost of sales.mp426.8MB
147. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.mp434.45MB
148. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.mp456.59MB
149. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.mp454.2MB
150. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.mp413.61MB
151. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/16. Calculating DSO, DIO, DPO.mp417.51MB
152. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/17. Producing a clean P&L output sheet.mp48.43MB
153. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/18. Fill in the P&L output sheet.mp418.34MB
154. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/19. Calculating investments in working capital.mp419.03MB
155. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/20. Forecasting Unlevered Free Cash Flow.mp455.93MB
156. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/21. Forecasting other assets.mp445.24MB
157. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/22. Forecasting other liabilities.mp421.97MB
158. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/23. Completing Unlevered Free Cash Flow.mp440.88MB
159. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/24. Modeling Tesla's financing needs in the forecast period.mp442.36MB
160. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/25. Calculating Net income.mp414.8MB
161. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/26. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp450.73MB
162. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/27. Balancing the Balance sheet.mp413.27MB
163. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/28. Estimating Weighted Average Cost of Capital (WACC).mp444.27MB
164. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/29. Performing Discounted Cash Flow valuation (DCF).mp434.9MB
165. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/30. Calculating enterprise value, equity value, and price per share.mp422.56MB
166. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/15. Tesla valuation - Complete practical exercise/31. Final comments.mp444.88MB
167. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/16. Capital budgeting - The theory/1. Introduction to Capital budgeting.mp45.43MB
168. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/16. Capital budgeting - The theory/2. Why we need Capital budgeting.mp46.88MB
169. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/16. Capital budgeting - The theory/3. The time value of money.mp46.69MB
170. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/16. Capital budgeting - The theory/4. Calculating future and present Value.mp413.09MB
171. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/16. Capital budgeting - The theory/5. Calculating cost of equity.mp419.2MB
172. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/16. Capital budgeting - The theory/6. Coming up with project-specific beta.mp49.01MB
173. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/16. Capital budgeting - The theory/7. Weighted Average Cost of Capital (WACC).mp45.51MB
174. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/16. Capital budgeting - The theory/8. The type of cash flows we will have in a project.mp49.33MB
175. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/16. Capital budgeting - The theory/9. Estimating the project's cash flows.mp418.79MB
176. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/17. Capital Budgeting - A Complete Case Study/1. Introduction to the Capital Budgeting exercise.mp48.63MB
177. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/17. Capital Budgeting - A Complete Case Study/2. Organizing an Inputs sheet.mp411.05MB
178. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/17. Capital Budgeting - A Complete Case Study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp49.21MB
179. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/17. Capital Budgeting - A Complete Case Study/4. Fixed asset rollforward.mp412.16MB
180. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/17. Capital Budgeting - A Complete Case Study/5. The impact of working capital.mp45.36MB
181. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/17. Capital Budgeting - A Complete Case Study/6. Modeling debt financing.mp46.18MB
182. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/17. Capital Budgeting - A Complete Case Study/7. Adding a P&L sheet.mp44.88MB
183. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/17. Capital Budgeting - A Complete Case Study/8. Calculating project cash flows.mp410.14MB
184. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/17. Capital Budgeting - A Complete Case Study/9. Estimating the weighted average cost of capital (WACC).mp45.58MB
185. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/17. Capital Budgeting - A Complete Case Study/10. Finding cost of equity.mp413.92MB
186. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/17. Capital Budgeting - A Complete Case Study/11. Discounting the project's cash flows and residual value.mp422.54MB
187. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/17. Capital Budgeting - A Complete Case Study/12. Performing sensitivity analysis and completing the exercise.mp434.11MB
188. Udemy - Beginner to Pro in Excel Financial Modeling and Valuation/17. Capital Budgeting - A Complete Case Study/14. Congratulations!!.mp42.31MB