FreeTutorials Us UDEMY Financial Modeling Build a Complete DCF Valuation Model FTU

1. 1. Introduction to Company Valuation/1. Why value a company.mp48.44MB
2. 1. Introduction to Company Valuation/3. The investor's perspective.mp415.47MB
3. 1. Introduction to Company Valuation/4. What drives a firm's value.mp48.62MB
4. 10. Additional analyses accompanying the Financial Model/1. Excel Tools in Practice - Sensitivity Analysis for WACC and Perpetuity Growth.mp440.48MB
5. 10. Additional analyses accompanying the Financial Model/2. Excel tools in Practice - An Application of Goal Seek.mp415.62MB
6. 10. Additional analyses accompanying the Financial Model/3. Recap of the Financial Model with Charts and Hypothesis Testing.mp432.89MB
7. 10. Additional analyses accompanying the Financial Model/4. Congratulations! You Made It!.mp49.75MB
8. 11. Valuation of Tesla/1. Organizing external inputs in a 'Drivers' sheet.mp431MB
9. 11. Valuation of Tesla/10. Forecasting 'energy' and 'services' revenue.mp425.3MB
10. 11. Valuation of Tesla/11. Calculating 'energy' and 'services' gross profit and cost of sales.mp426.81MB
11. 11. Valuation of Tesla/12. Forecasting operating expenses.mp434.44MB
12. 11. Valuation of Tesla/13. Building a fixed asset roll forward estimating Capex.mp456.6MB
13. 11. Valuation of Tesla/14. Building a fixed asset roll forward D&A schedule.mp454.22MB
14. 11. Valuation of Tesla/15. Peer comparison D&A as a percentage of revenues.mp413.63MB
15. 11. Valuation of Tesla/16. Calculating DSO, DIO, DPO.mp417.47MB
16. 11. Valuation of Tesla/17. Producing a clean P&L output sheet.mp48.42MB
17. 11. Valuation of Tesla/18. Fill in the P&L output sheet.mp418.37MB
18. 11. Valuation of Tesla/19. Calculating investments in working capital.mp419.02MB
19. 11. Valuation of Tesla/2. The input data we will work with.mp415.82MB
20. 11. Valuation of Tesla/20. Forecasting Unlevered free cash flow.mp455.96MB
21. 11. Valuation of Tesla/21. Forecasting other assets.mp445.24MB
22. 11. Valuation of Tesla/22. Forecasting other liabilities.mp421.99MB
23. 11. Valuation of Tesla/23. Completing Unlevered free cash flow.mp440.89MB
24. 11. Valuation of Tesla/24. Modeling Tesla's financing needs in the forecast period.mp442.37MB
25. 11. Valuation of Tesla/25. Calculating Net income.mp414.79MB
26. 11. Valuation of Tesla/26. Bridging Unlevered free cash flow to Net cash flow.mp450.57MB
27. 11. Valuation of Tesla/27. Balancing the Balance sheet.mp413.27MB
28. 11. Valuation of Tesla/28. Estimating Weighted average cost of capital (WACC).mp444.3MB
29. 11. Valuation of Tesla/29. Performing discounted cash flow valuation (DCF).mp434.94MB
30. 11. Valuation of Tesla/3. Forecasting Tesla's expected deliveries.mp4114.98MB
31. 11. Valuation of Tesla/30. Calculating enterprise value, equity value, and price per share.mp433.96MB
32. 11. Valuation of Tesla/31. Final comments.mp465.66MB
33. 11. Valuation of Tesla/4. Comparing delivery figures with the ones of industry peers.mp420.95MB
34. 11. Valuation of Tesla/5. Estimating an average selling price of Tesla vehicles.mp441.92MB
35. 11. Valuation of Tesla/6. Calculating automotive revenue.mp446.55MB
36. 11. Valuation of Tesla/7. Peer comparison Gross profit %.mp417.17MB
37. 11. Valuation of Tesla/8. Calculating automotive gross profit.mp427.8MB
38. 11. Valuation of Tesla/9. Calculating automotive cost of sales.mp417.5MB
39. 2. The technical tools you need when valuing a company/1. Calculating Unlevered free cash flows.mp421.89MB
40. 2. The technical tools you need when valuing a company/2. Using an appropriate discount factor.mp47.34MB
41. 2. The technical tools you need when valuing a company/3. Estimating cost of debt.mp44.29MB
42. 2. The technical tools you need when valuing a company/4. Estimating cost of equity.mp411.07MB
43. 2. The technical tools you need when valuing a company/5. Forecasting future cash flows.mp44.48MB
44. 2. The technical tools you need when valuing a company/6. Caclulating Terminal value.mp44.25MB
45. 2. The technical tools you need when valuing a company/7. Discounting future cash flows.mp43.62MB
46. 2. The technical tools you need when valuing a company/8. Calculating Enterprise and Equity value of the firm.mp45.89MB
47. 3. Learn how to build a Discounted Cash Flow model in Excel - Introduction/1. Learning by Doing - Learn How to Value a Company - Introduction to Case Study 2.mp46.57MB
48. 3. Learn how to build a Discounted Cash Flow model in Excel - Introduction/2. A Quick Summary of The Various Stages of a Complete DCF Valuation.mp449.24MB
49. 3. Learn how to build a Discounted Cash Flow model in Excel - Introduction/3. Let's Go Through The Structure of the DCF Model That We Will Create in Excel.mp418.54MB
50. 3. Learn how to build a Discounted Cash Flow model in Excel - Introduction/4. A Glimpse At the Company We Are Valuing - Cheeseco.mp415.7MB
51. 4. Forecasting of key P&L items/1. Modeling the Top Line of the Financial Model.mp426.29MB
52. 4. Forecasting of key P&L items/2. This Is How You Can Build Flexible Financial Models in Excel.mp417.82MB
53. 4. Forecasting of key P&L items/3. Modeling Other Items Other Revenues and Cogs.mp444.55MB
54. 4. Forecasting of key P&L items/4. Modeling Other Items Operating Expenses and D&A.mp426.35MB
55. 4. Forecasting of key P&L items/5. Modeling Other Items Interest Expenses, Extraordinary Items and Taxes.mp429.98MB
56. 5. Forecasting of key Balance Sheet items/1. How to Forecast Balance Sheet Items - The Practical and Easy to Understand Way.mp44.66MB
57. 5. Forecasting of key Balance Sheet items/2. A Key Concept for Finance Practitioners - the Days Methodology.mp410.08MB
58. 5. Forecasting of key Balance Sheet items/3. Learn How to Calculate Days.mp412.16MB
59. 5. Forecasting of key Balance Sheet items/4. How to Use Days in Order to Project the Future Development of Some BS Items.mp420.83MB
60. 5. Forecasting of key Balance Sheet items/5. Forecasting Property Plant & Equipment, Other assets and Other liabilities.mp422.61MB
61. 6. Creating clean output sheets/1. Excel Best Practices! Create a Good-looking and Clean Output Sheet in Your Model.mp418.79MB
62. 6. Creating clean output sheets/2. Applying What We Learned in Practice - Populating the P&L Sheet.mp425.56MB
63. 6. Creating clean output sheets/3. This is How you Can Create a Clean Output Balance Sheet in Your Financial Model.mp416.93MB
64. 6. Creating clean output sheets/4. Completing the Output BS Sheet For the Historical Period.mp438.01MB
65. 7. Learn how to calculate Unlevered Free Cash Flows and Net Cash Flows/1. Learn How to Calculate Unlevered Free Cash Flows.mp422.78MB
66. 7. Learn how to calculate Unlevered Free Cash Flows and Net Cash Flows/2. Important! Reconcile UFCF to Net Cash Flow.mp414.56MB
67. 7. Learn how to calculate Unlevered Free Cash Flows and Net Cash Flows/3. A Very Useful Lesson! Learn How To Calculate Cash Flows.mp459.7MB
68. 7. Learn how to calculate Unlevered Free Cash Flows and Net Cash Flows/4. Arriving to Actual Net Cash Flow Figures and Performing a Check with Cash.mp437.9MB
69. 7. Learn how to calculate Unlevered Free Cash Flows and Net Cash Flows/5. The Fast and Effective Way to Modify Multiple Cell References in Excel.mp446.76MB
70. 8. Calculating Present Value of Cash Flows within the forecast period/1. Introducing Weighted Average Cost of Capital and Perpetuity Growth Rate.mp413.2MB
71. 8. Calculating Present Value of Cash Flows within the forecast period/2. Learn How to Find The Present Value of Future Cash Flows in Financial Models.mp420.21MB
72. 9. Calculating Continuing Value,Enterprise Value and Equity Value of the business/1. Calculating Continuing Value and Enterprise Value of the Business.mp423.32MB
73. 9. Calculating Continuing Value,Enterprise Value and Equity Value of the business/2. Final Steps! Calculate Equity Value of the Business Under Consideration.mp412.17MB