FreeTutorials Us UDEMY Financial Modeling Build Complete DCF Valuation Model FTU

/0. Websites you may like/

0. (1Hack.Us) Premium Tutorials-Guides-Articles & Community based Forum.url

1. (FreeTutorials.Us) Download Udemy Paid Courses For Free.url

2. (FreeCoursesOnline.Me) Download Udacity, Masterclass, Lynda, PHLearn, Pluralsight Free.url

3. (NulledPremium.com) Download E-Learning, E-Books, Audio-Books, Comics, Articles and more... etc.url

4. (FTUApps.com) Download Cracked Developers Applications For Free.url

How you can help Team-FTU.txt

/1. Introduction to Company Valuation/

1. Why value a company.mp4

1. Why value a company.srt

1. Why value a company.vtt

2. Company Valuation - Theoretical Framework.html

3. The investor's perspective.mp4

3. The investor's perspective.srt

3. The investor's perspective.vtt

4. What drives a firm's value.mp4

4. What drives a firm's value.srt

4. What drives a firm's value.vtt

/10. Additional analyses accompanying the Financial Model/

1. Excel Tools in Practice - Sensitivity Analysis for WACC and Perpetuity Growth.mp4

1. Excel Tools in Practice - Sensitivity Analysis for WACC and Perpetuity Growth.srt

1. Excel Tools in Practice - Sensitivity Analysis for WACC and Perpetuity Growth.vtt

1.1 28. Sensitivity analysis_before.xlsm.xlsm

1.2 28. Sensitivity analysis_after.xlsm.xlsm

2. Excel tools in Practice - An Application of Goal Seek.mp4

2. Excel tools in Practice - An Application of Goal Seek.srt

2. Excel tools in Practice - An Application of Goal Seek.vtt

2.1 29. Goal seek_before.xlsm.xlsm

2.2 29. Goal seek_ater.xlsm.xlsm

3. Recap of the Financial Model with Charts and Hypothesis Testing.mp4

3. Recap of the Financial Model with Charts and Hypothesis Testing.srt

3. Recap of the Financial Model with Charts and Hypothesis Testing.vtt

3.1 30. Charts.xlsm.xlsm

4. Congratulations! You Made It!.mp4

4. Congratulations! You Made It!.srt

4. Congratulations! You Made It!.vtt

5. Introduction to Mergers & Acquisitions.html

/11. Valuation of Tesla/

1. Organizing external inputs in a 'Drivers' sheet.mp4

1. Organizing external inputs in a 'Drivers' sheet.srt

1. Organizing external inputs in a 'Drivers' sheet.vtt

1.1 Tesla 2016.pdf.pdf

1.2 Tesla 2018 Q2.pdf.pdf

1.3 Tesla 2017.pdf.pdf

1.4 Tesla 2015.pdf.pdf

1.5 0a. Drivers_before.xlsx.xlsx

1.6 0a. Drivers_after.xlsx.xlsx

10. Forecasting 'energy' and 'services' revenue.mp4

10. Forecasting 'energy' and 'services' revenue.srt

10. Forecasting 'energy' and 'services' revenue.vtt

10.1 6. Energy and Other revenue - Before.xlsx.xlsx

10.2 6. Energy and Other revenue - After.xlsx.xlsx

11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4

11. Calculating 'energy' and 'services' gross profit and cost of sales.srt

11. Calculating 'energy' and 'services' gross profit and cost of sales.vtt

11.1 7. Energy and Other - Gross profit, cost of sales - Before.xlsx.xlsx

11.2 7. Energy and Other - Gross profit, cost of sales - After.xlsx.xlsx

12. Forecasting operating expenses.mp4

12. Forecasting operating expenses.srt

12. Forecasting operating expenses.vtt

12.1 8. Opex - Before.xlsx.xlsx

12.2 8. Opex - After.xlsx.xlsx

13. Building a fixed asset roll forward estimating Capex.mp4

13. Building a fixed asset roll forward estimating Capex.srt

13. Building a fixed asset roll forward estimating Capex.vtt

13.1 9. PP&E forecasting and comparables_before.xlsx.xlsx

13.2 9. PP&E forecasting and comparables_after.xlsx.xlsx

14. Building a fixed asset roll forward D&A schedule.mp4

14. Building a fixed asset roll forward D&A schedule.srt

14. Building a fixed asset roll forward D&A schedule.vtt

14.1 10. PP&E schedule_before.xlsx.xlsx

14.2 10. PP&E schedule_after.xlsx.xlsx

15. Peer comparison D&A as a percentage of revenues.mp4

15. Peer comparison D&A as a percentage of revenues.srt

15. Peer comparison D&A as a percentage of revenues.vtt

15.1 10a. PP&E comparison.xlsx.xlsx

16. Calculating DSO, DIO, DPO.mp4

16. Calculating DSO, DIO, DPO.srt

16. Calculating DSO, DIO, DPO.vtt

16.1 11. Working capital forecasting_after.xlsx.xlsx

16.2 11. Working capital forecasting_before.xlsx.xlsx

17. Producing a clean P&L output sheet.mp4

17. Producing a clean P&L output sheet.srt

17. Producing a clean P&L output sheet.vtt

17.1 12. P&L.xlsx.xlsx

18. Fill in the P&L output sheet.mp4

18. Fill in the P&L output sheet.srt

18. Fill in the P&L output sheet.vtt

18.1 12a. P&L fill in_before.xlsx.xlsx

18.2 12a. P&L fill in_after.xlsx.xlsx

19. Calculating investments in working capital.mp4

19. Calculating investments in working capital.srt

19. Calculating investments in working capital.vtt

19.1 13. Calculating working capital_before.xlsx.xlsx

19.2 13. Calculating working capital_after.xlsx.xlsx

2. The input data we will work with.mp4

2. The input data we will work with.srt

2. The input data we will work with.vtt

2.1 0aa. Inputs_before.xlsx.xlsx

2.2 0aa. Inputs_after.xlsx.xlsx

20. Forecasting Unlevered free cash flow.mp4

20. Forecasting Unlevered free cash flow.srt

20. Forecasting Unlevered free cash flow.vtt

20.1 14. Cash flow - UFCF_after.xlsx.xlsx

20.2 14. Cash flow - UFCF_before.xlsx.xlsx

21. Forecasting other assets.mp4

21. Forecasting other assets.srt

21. Forecasting other assets.vtt

21.1 15. Balance Sheet forecasting assets_before.xlsx.xlsx

21.2 15. Balance Sheet forecasting assets_after.xlsx.xlsx

22. Forecasting other liabilities.mp4

22. Forecasting other liabilities.srt

22. Forecasting other liabilities.vtt

22.1 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx

22.2 16. Balance Sheet forecasting liabilities_before.xlsx.xlsx

23. Completing Unlevered free cash flow.mp4

23. Completing Unlevered free cash flow.srt

23. Completing Unlevered free cash flow.vtt

23.1 16a. Complete UFCF_before.xlsx.xlsx

23.2 16a. Complete UFCF_after.xlsx.xlsx

24. Modeling Tesla's financing needs in the forecast period.mp4

24. Modeling Tesla's financing needs in the forecast period.srt

24. Modeling Tesla's financing needs in the forecast period.vtt

24.1 17. Financing_after.xlsx.xlsx

24.2 17. Financing_before.xlsx.xlsx

25. Calculating Net income.mp4

25. Calculating Net income.srt

25. Calculating Net income.vtt

25.1 18. P&L complete_before.xlsx.xlsx

25.2 18. P&L complete_after.xlsx.xlsx

26. Bridging Unlevered free cash flow to Net cash flow.mp4

26. Bridging Unlevered free cash flow to Net cash flow.srt

26. Bridging Unlevered free cash flow to Net cash flow.vtt

26.1 19. Cash flow_complete_before.xlsx.xlsx

26.2 19. Cash flow_complete_after.xlsx.xlsx

27. Balancing the Balance sheet.mp4

27. Balancing the Balance sheet.srt

27. Balancing the Balance sheet.vtt

27.1 20. Complete the BS_before.xlsx.xlsx

27.2 20. Complete the BS_after.xlsx.xlsx

28. Estimating Weighted average cost of capital (WACC).mp4

28. Estimating Weighted average cost of capital (WACC).srt

28. Estimating Weighted average cost of capital (WACC).vtt

28.1 21. WACC_before.xlsx.xlsx

28.2 21. WACC_after.xlsx.xlsx

29. Performing discounted cash flow valuation (DCF).mp4

29. Performing discounted cash flow valuation (DCF).srt

29. Performing discounted cash flow valuation (DCF).vtt

29.1 22. DCF_after.xlsx.xlsx

29.2 22. DCF_before.xlsx.xlsx

3. Forecasting Tesla's expected deliveries.mp4

3. Forecasting Tesla's expected deliveries.srt

3. Forecasting Tesla's expected deliveries.vtt

3.1 1. Deliveries_before.xlsx.xlsx

3.2 1. Deliveries_after.xlsx.xlsx

3.3 Tesla vehicle revenue.html

30. Calculating enterprise value, equity value, and price per share.mp4

30. Calculating enterprise value, equity value, and price per share.srt

30. Calculating enterprise value, equity value, and price per share.vtt

30.1 23. EV, Equity value, Price per share_after.xlsx.xlsx

30.2 23. EV, Equity value, Price per share_before.xlsx.xlsx

31. Final comments.mp4

31. Final comments.srt

31. Final comments.vtt

4. Comparing delivery figures with the ones of industry peers.mp4

4. Comparing delivery figures with the ones of industry peers.srt

4. Comparing delivery figures with the ones of industry peers.vtt

4.1 1a. Deliveries development.xlsx.xlsx

5. Estimating an average selling price of Tesla vehicles.mp4

5. Estimating an average selling price of Tesla vehicles.srt

5. Estimating an average selling price of Tesla vehicles.vtt

5.1 2. Average price_after.xlsx.xlsx

5.2 2. Average price_before.xlsx.xlsx

6. Calculating automotive revenue.mp4

6. Calculating automotive revenue.srt

6. Calculating automotive revenue.vtt

6.1 3. Revenue calculation and scenarios - before.xlsx.xlsx

6.2 3. Revenue calculation and scenarios - after.xlsx.xlsx

7. Peer comparison Gross profit %.mp4

7. Peer comparison Gross profit %.srt

7. Peer comparison Gross profit %.vtt

7.1 4. Gross profit automotive.xlsx.xlsx

8. Calculating automotive gross profit.mp4

8. Calculating automotive gross profit.srt

8. Calculating automotive gross profit.vtt

8.1 4a. Gross profit automotive - before.xlsx.xlsx

8.2 4a. Gross profit automotive - after.xlsx.xlsx

9. Calculating automotive cost of sales.mp4

9. Calculating automotive cost of sales.srt

9. Calculating automotive cost of sales.vtt

9.1 5. Cost of sales and chart.xlsx.xlsx

/2. The technical tools you need when valuing a company/

1. Calculating Unlevered free cash flows.mp4

1. Calculating Unlevered free cash flows.srt

1. Calculating Unlevered free cash flows.vtt

1.1 Cash Movements.pdf.pdf

2. Using an appropriate discount factor.mp4

2. Using an appropriate discount factor.srt

2. Using an appropriate discount factor.vtt

3. Estimating cost of debt.mp4

3. Estimating cost of debt.srt

3. Estimating cost of debt.vtt

4. Estimating cost of equity.mp4

4. Estimating cost of equity.srt

4. Estimating cost of equity.vtt

5. Forecasting future cash flows.mp4

5. Forecasting future cash flows.srt

5. Forecasting future cash flows.vtt

5.1 Modeling PL and BS items.pdf.pdf

6. Caclulating Terminal value.mp4

6. Caclulating Terminal value.srt

6. Caclulating Terminal value.vtt

7. Discounting future cash flows.mp4

7. Discounting future cash flows.srt

7. Discounting future cash flows.vtt

8. Calculating Enterprise and Equity value of the firm.mp4

8. Calculating Enterprise and Equity value of the firm.srt

8. Calculating Enterprise and Equity value of the firm.vtt

/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.mp4

1. Learning by Doing - Learn How to Value a Company - Introduction to Case Study 2.srt

1. Learning by Doing - Learn How to Value a Company - Introduction to Case Study 2.vtt

2. A Quick Summary of The Various Stages of a Complete DCF Valuation.mp4

2. A Quick Summary of The Various Stages of a Complete DCF Valuation.srt

2. A Quick Summary of The Various Stages of a Complete DCF Valuation.vtt

2.1 Valuation exercise.pptx.pptx

3. Let's Go Through The Structure of the DCF Model That We Will Create in Excel.mp4

3. Let's Go Through The Structure of the DCF Model That We Will Create in Excel.srt

3. Let's Go Through The Structure of the DCF Model That We Will Create in Excel.vtt

3.1 3. Structure of the DCF model.xlsm.xlsm

4. A Glimpse At the Company We Are Valuing - Cheeseco.mp4

4. A Glimpse At the Company We Are Valuing - Cheeseco.srt

4. A Glimpse At the Company We Are Valuing - Cheeseco.vtt

/4. Forecasting of key P&L items/

1. Modeling the Top Line of the Financial Model.mp4

1. Modeling the Top Line of the Financial Model.srt

1. Modeling the Top Line of the Financial Model.vtt

1.1 5. Modeling revenues_before.xlsm.xlsm

1.2 5. Modeling revenues_after.xlsm.xlsm

2. This Is How You Can Build Flexible Financial Models in Excel.mp4

2. This Is How You Can Build Flexible Financial Models in Excel.srt

2. This Is How You Can Build Flexible Financial Models in Excel.vtt

2.1 6. Choose_before.xlsm.xlsm

2.2 6. Choose_after.xlsm.xlsm

3. Modeling Other Items Other Revenues and Cogs.mp4

3. Modeling Other Items Other Revenues and Cogs.srt

3. Modeling Other Items Other Revenues and Cogs.vtt

3.1 7. Other revenues and Cogs_before.xlsm.xlsm

3.2 7. Other revenues and Cogs_after.xlsm.xlsm

4. Modeling Other Items Operating Expenses and D&A.mp4

4. Modeling Other Items Operating Expenses and D&A.srt

4. Modeling Other Items Operating Expenses and D&A.vtt

4.1 8. Opex and D&A_before.xlsm.xlsm

4.2 8. Opex and D&A_after.xlsm.xlsm

5. Modeling Other Items Interest Expenses, Extraordinary Items and Taxes.mp4

5. Modeling Other Items Interest Expenses, Extraordinary Items and Taxes.srt

5. Modeling Other Items Interest Expenses, Extraordinary Items and Taxes.vtt

5.1 9. Interest expenses, taxes_before.xlsm.xlsm

5.2 9. Interest expenses, taxes_after.xlsm.xlsm

/5. Forecasting of key Balance Sheet items/

1. How to Forecast Balance Sheet Items - The Practical and Easy to Understand Way.mp4

1. How to Forecast Balance Sheet Items - The Practical and Easy to Understand Way.srt

1. How to Forecast Balance Sheet Items - The Practical and Easy to Understand Way.vtt

1.1 Project BS Items.xlsx

2. A Key Concept for Finance Practitioners - the Days Methodology.mp4

2. A Key Concept for Finance Practitioners - the Days Methodology.srt

2. A Key Concept for Finance Practitioners - the Days Methodology.vtt

2.1 Working Capital Days.pptx.pptx

3. Learn How to Calculate Days.mp4

3. Learn How to Calculate Days.srt

3. Learn How to Calculate Days.vtt

3.1 12. Days calculation_after.xlsm.xlsm

3.2 12. Days calculation_before.xlsm.xlsm

4. How to Use Days in Order to Project the Future Development of Some BS Items.mp4

4. How to Use Days in Order to Project the Future Development of Some BS Items.srt

4. How to Use Days in Order to Project the Future Development of Some BS Items.vtt

4.1 13. Forecasting DSO, DPO, DIO_after.xlsm.xlsm

4.2 13. Forecasting DSO, DPO, DIO_before.xlsm.xlsm

5. Forecasting Property Plant & Equipment, Other assets and Other liabilities.mp4

5. Forecasting Property Plant & Equipment, Other assets and Other liabilities.srt

5. Forecasting Property Plant & Equipment, Other assets and Other liabilities.vtt

5.1 14. Forecasting PP&E, Other assets, and Other liabilities_before.xlsm.xlsm

5.2 14. Forecasting PP&E, Other assets, and Other liabilities_after.xlsm.xlsm

/6. Creating clean output sheets/

1. Excel Best Practices! Create a Good-looking and Clean Output Sheet in Your Model.mp4

1. Excel Best Practices! Create a Good-looking and Clean Output Sheet in Your Model.srt

1. Excel Best Practices! Create a Good-looking and Clean Output Sheet in Your Model.vtt

1.1 15. P&L structure_before.xlsm.xlsm

1.2 15. P&L structure_after.xlsm.xlsm

2. Applying What We Learned in Practice - Populating the P&L Sheet.mp4

2. Applying What We Learned in Practice - Populating the P&L Sheet.srt

2. Applying What We Learned in Practice - Populating the P&L Sheet.vtt

2.1 16. Populating the P&L sheet_after.xlsm.xlsm

2.2 16. Populating the P&L sheet_before.xlsm.xlsm

3. This is How you Can Create a Clean Output Balance Sheet in Your Financial Model.mp4

3. This is How you Can Create a Clean Output Balance Sheet in Your Financial Model.srt

3. This is How you Can Create a Clean Output Balance Sheet in Your Financial Model.vtt

3.1 17. Populating BS sheet_before.xlsm.xlsm

3.2 17. Populating BS sheet_after.xlsm.xlsm

4. Completing the Output BS Sheet For the Historical Period.mp4

4. Completing the Output BS Sheet For the Historical Period.srt

4. Completing the Output BS Sheet For the Historical Period.vtt

4.1 18. Completing the Balance Sheet_before.xlsm.xlsm

4.2 18. Completing the Balance Sheet_after.xlsm.xlsm

/7. Learn how to calculate Unlevered Free Cash Flows and Net Cash Flows/

1. Learn How to Calculate Unlevered Free Cash Flows.mp4

1. Learn How to Calculate Unlevered Free Cash Flows.srt

1. Learn How to Calculate Unlevered Free Cash Flows.vtt

1.1 19. Cash flow structure_before.xlsm.xlsm

1.2 19. Cash flow structure_after.xlsm.xlsm

2. Important! Reconcile UFCF to Net Cash Flow.mp4

2. Important! Reconcile UFCF to Net Cash Flow.srt

2. Important! Reconcile UFCF to Net Cash Flow.vtt

2.1 20. Bridge UFCF to Net cash flow_after.xlsm.xlsm

2.2 20. Bridge UFCF to Net cash flow_before.xlsm.xlsm

3. A Very Useful Lesson! Learn How To Calculate Cash Flows.mp4

3. A Very Useful Lesson! Learn How To Calculate Cash Flows.srt

3. A Very Useful Lesson! Learn How To Calculate Cash Flows.vtt

3.1 21. Calculating UFCF_before.xlsm.xlsm

3.2 21. Calculating UFCF_after.xlsm.xlsm

4. Arriving to Actual Net Cash Flow Figures and Performing a Check with Cash.mp4

4. Arriving to Actual Net Cash Flow Figures and Performing a Check with Cash.srt

4. Arriving to Actual Net Cash Flow Figures and Performing a Check with Cash.vtt

4.1 22. Calculating Net Cash Flow_before.xlsm.xlsm

4.2 22. Calculating Net Cash Flow_after.xlsm.xlsm

5. The Fast and Effective Way to Modify Multiple Cell References in Excel.mp4

5. The Fast and Effective Way to Modify Multiple Cell References in Excel.srt

5. The Fast and Effective Way to Modify Multiple Cell References in Excel.vtt

5.1 23. Find and replace_after.xlsm.xlsm

5.2 23. Find and replace_before.xlsm.xlsm

/8. Calculating Present Value of Cash Flows within the forecast period/

1. Introducing Weighted Average Cost of Capital and Perpetuity Growth Rate.mp4

1. Introducing Weighted Average Cost of Capital and Perpetuity Growth Rate.srt

1. Introducing Weighted Average Cost of Capital and Perpetuity Growth Rate.vtt

1.1 24. Introducing WACC and g_after.xlsm.xlsm

1.2 24. Introducing WACC and g_before.xlsm.xlsm

2. Learn How to Find The Present Value of Future Cash Flows in Financial Models.mp4

2. Learn How to Find The Present Value of Future Cash Flows in Financial Models.srt

2. Learn How to Find The Present Value of Future Cash Flows in Financial Models.vtt

2.1 25. Calculating PV of Cash Flows_after.xlsm.xlsm

2.2 25. Calculating PV of Cash Flows_before.xlsm.xlsm

/9. Calculating Continuing Value,Enterprise Value and Equity Value of the business/

1. Calculating Continuing Value and Enterprise Value of the Business.mp4

1. Calculating Continuing Value and Enterprise Value of the Business.srt

1. Calculating Continuing Value and Enterprise Value of the Business.vtt

1.1 26. Calculating CV and EV_after.xlsm.xlsm

1.2 26. Calculating CV and EV_before.xlsm.xlsm

2. Final Steps! Calculate Equity Value of the Business Under Consideration.mp4

2. Final Steps! Calculate Equity Value of the Business Under Consideration.srt

2. Final Steps! Calculate Equity Value of the Business Under Consideration.vtt

2.1 27. Calculating equity value_after.xlsm.xlsm

2.2 27. Calculating equity value_before.xlsm.xlsm

Total files 340