TC4S:\.@DOWNLOAD\22b - CTV\T\The Complete Financial Analyst Course 2019\42. Tesla practical case study - Building a financial planning model

Up one directory...
NameSizeDate Modified
1. Organizing external inputs in a 'Drivers' sheet.mp431,756 KB9/25/2020 9:46 PM
1. Organizing external inputs in a 'Drivers' sheet.vtt5 KB9/25/2020 9:46 PM
1.1 0a. Drivers_before.xlsx.xlsx1,305 KB9/25/2020 9:46 PM
1.2 0a. Drivers_after.xlsx.xlsx1,305 KB9/25/2020 9:46 PM
10. Forecasting 'energy' and 'services' revenue.mp425,900 KB9/25/2020 9:46 PM
10. Forecasting 'energy' and 'services' revenue.vtt3 KB9/25/2020 9:46 PM
10.1 6. Energy and Other revenue - After.xlsx.xlsx1,377 KB9/25/2020 9:46 PM
10.2 6. Energy and Other revenue - Before.xlsx.xlsx1,377 KB9/25/2020 9:46 PM
11. Calculating 'energy' and 'services' gross profit and cost of sales.mp427,450 KB9/25/2020 9:46 PM
11. Calculating 'energy' and 'services' gross profit and cost of sales.vtt3 KB9/25/2020 9:46 PM
11.1 7. Energy and Other - Gross profit, cost of sales - Before.xlsx.xlsx1,384 KB9/25/2020 9:46 PM
11.2 7. Energy and Other - Gross profit, cost of sales - After.xlsx.xlsx1,385 KB9/25/2020 9:46 PM
12. Forecasting operating expenses.mp435,318 KB9/25/2020 9:46 PM
12. Forecasting operating expenses.vtt6 KB9/25/2020 9:46 PM
12.1 8. Opex - After.xlsx.xlsx1,394 KB9/25/2020 9:46 PM
12.2 8. Opex - Before.xlsx.xlsx1,393 KB9/25/2020 9:46 PM
13. Building a fixed asset roll forward estimating Capex.mp457,867 KB9/25/2020 9:46 PM
13. Building a fixed asset roll forward estimating Capex.vtt7 KB9/25/2020 9:46 PM
13.1 9. PP&E forecasting and comparables_before.xlsx.xlsx1,404 KB9/25/2020 9:46 PM
13.2 9. PP&E forecasting and comparables_after.xlsx.xlsx1,404 KB9/25/2020 9:46 PM
14. Building a fixed asset roll forward D&A schedule.mp455,456 KB9/25/2020 9:46 PM
14. Building a fixed asset roll forward D&A schedule.vtt5 KB9/25/2020 9:46 PM
14.1 10. PP&E schedule_after.xlsx.xlsx1,405 KB9/25/2020 9:46 PM
14.2 10. PP&E schedule_before.xlsx.xlsx1,404 KB9/25/2020 9:46 PM
15. Peer comparison D&A as a percentage of revenues.mp413,945 KB9/25/2020 9:46 PM
15. Peer comparison D&A as a percentage of revenues.vtt2 KB9/25/2020 9:46 PM
15.1 10a. PP&E comparison.xlsx.xlsx1,406 KB9/25/2020 9:46 PM
16. Calculating DSO, DIO, DPO.mp417,930 KB9/25/2020 9:46 PM
16. Calculating DSO, DIO, DPO.vtt3 KB9/25/2020 9:46 PM
16.1 11. Working capital forecasting_after.xlsx.xlsx1,552 KB9/25/2020 9:46 PM
16.2 11. Working capital forecasting_before.xlsx.xlsx1,416 KB9/25/2020 9:46 PM
17. Producing a clean P&L output sheet.mp48,636 KB9/25/2020 9:46 PM
17. Producing a clean P&L output sheet.vtt2 KB9/25/2020 9:46 PM
17.1 12. P&L.xlsx.xlsx1,420 KB9/25/2020 9:46 PM
18. Fill in the P&L output sheet.mp418,794 KB9/25/2020 9:46 PM
18. Fill in the P&L output sheet.vtt2 KB9/25/2020 9:46 PM
18.1 12a. P&L fill in_after.xlsx.xlsx1,424 KB9/25/2020 9:46 PM
18.2 12a. P&L fill in_before.xlsx.xlsx1,421 KB9/25/2020 9:46 PM
19. Calculating investments in working capital.mp419,511 KB9/25/2020 9:46 PM
19. Calculating investments in working capital.vtt3 KB9/25/2020 9:46 PM
19.1 13. Calculating working capital_before.xlsx.xlsx1,430 KB9/25/2020 9:46 PM
19.2 13. Calculating working capital_after.xlsx.xlsx1,431 KB9/25/2020 9:46 PM
2. The input data we will work with.mp416,181 KB9/25/2020 9:46 PM
2. The input data we will work with.vtt2 KB9/25/2020 9:46 PM
2.1 0aa. Inputs_before.xlsx.xlsx1,316 KB9/25/2020 9:46 PM
2.2 0aa. Inputs_after.xlsx.xlsx1,316 KB9/25/2020 9:46 PM
20. Forecasting Unlevered Free Cash Flow.mp457,320 KB9/25/2020 9:46 PM
20. Forecasting Unlevered Free Cash Flow.vtt6 KB9/25/2020 9:46 PM
20.1 14. Cash flow - UFCF_before.xlsx.xlsx1,447 KB9/25/2020 9:46 PM
20.2 14. Cash flow - UFCF_after.xlsx.xlsx1,447 KB9/25/2020 9:46 PM
21. Forecasting other assets.mp446,398 KB9/25/2020 9:46 PM
21. Forecasting other assets.vtt5 KB9/25/2020 9:46 PM
21.1 15. Balance Sheet forecasting assets_after.xlsx.xlsx1,449 KB9/25/2020 9:46 PM
21.2 15. Balance Sheet forecasting assets_before.xlsx.xlsx1,447 KB9/25/2020 9:46 PM
22. Forecasting other liabilities.mp422,578 KB9/25/2020 9:46 PM
22. Forecasting other liabilities.vtt3 KB9/25/2020 9:46 PM
22.1 16. Balance Sheet forecasting liabilities_before.xlsx.xlsx1,449 KB9/25/2020 9:46 PM
22.2 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx1,450 KB9/25/2020 9:46 PM
23. Completing Unlevered Free Cash Flow.mp441,877 KB9/25/2020 9:46 PM
23. Completing Unlevered Free Cash Flow.vtt4 KB9/25/2020 9:46 PM
23.1 16a. Complete UFCF_after.xlsx.xlsx1,451 KB9/25/2020 9:46 PM
23.2 16a. Complete UFCF_before.xlsx.xlsx1,450 KB9/25/2020 9:46 PM
24. Modeling Tesla's financing needs in the forecast period.mp443,395 KB9/25/2020 9:46 PM
24. Modeling Tesla's financing needs in the forecast period.vtt6 KB9/25/2020 9:46 PM
24.1 17. Financing_after.xlsx.xlsx1,468 KB9/25/2020 9:46 PM
24.2 17. Financing_before.xlsx.xlsx1,467 KB9/25/2020 9:46 PM
25. Calculating Net income.mp415,149 KB9/25/2020 9:46 PM
25. Calculating Net income.vtt2 KB9/25/2020 9:46 PM
25.1 18. P&L complete_after.xlsx.xlsx1,468 KB9/25/2020 9:46 PM
25.2 18. P&L complete_before.xlsx.xlsx1,467 KB9/25/2020 9:46 PM
26. Bridging Unlevered Free Cash Flow to Net Cash Flow.mp451,887 KB9/25/2020 9:46 PM
26. Bridging Unlevered Free Cash Flow to Net Cash Flow.vtt5 KB9/25/2020 9:46 PM
26.1 19. Cash flow_complete_after.xlsx.xlsx1,469 KB9/25/2020 9:46 PM
26.2 19. Cash flow_complete_before.xlsx.xlsx1,468 KB9/25/2020 9:46 PM
27. Balancing the Balance sheet.mp413,608 KB9/25/2020 9:46 PM
27. Balancing the Balance sheet.vtt2 KB9/25/2020 9:46 PM
27.1 20. Complete the BS_after.xlsx.xlsx1,469 KB9/25/2020 9:46 PM
27.2 20. Complete the BS_before.xlsx.xlsx1,469 KB9/25/2020 9:46 PM
3. Forecasting Tesla's expected deliveries.mp4117,682 KB9/25/2020 9:46 PM
3. Forecasting Tesla's expected deliveries.vtt15 KB9/25/2020 9:46 PM
3.1 1. Deliveries_after.xlsx.xlsx1,324 KB9/25/2020 9:46 PM
3.2 1. Deliveries_before.xlsx.xlsx1,322 KB9/25/2020 9:46 PM
4. Comparing delivery figures with the ones of industry peers.mp421,481 KB9/25/2020 9:46 PM
4. Comparing delivery figures with the ones of industry peers.vtt4 KB9/25/2020 9:46 PM
4.1 1a. Deliveries development.xlsx.xlsx1,335 KB9/25/2020 9:46 PM
5. Estimating an average selling price of Tesla vehicles.mp442,932 KB9/25/2020 9:46 PM
5. Estimating an average selling price of Tesla vehicles.vtt5 KB9/25/2020 9:46 PM
5.1 2. Average price_after.xlsx.xlsx1,340 KB9/25/2020 9:46 PM
5.2 2. Average price_before.xlsx.xlsx1,340 KB9/25/2020 9:46 PM
6. Calculating automotive revenue.mp447,673 KB9/25/2020 9:46 PM
6. Calculating automotive revenue.vtt5 KB9/25/2020 9:46 PM
6.1 3. Revenue calculation and scenarios - after.xlsx.xlsx1,343 KB9/25/2020 9:46 PM
6.2 3. Revenue calculation and scenarios - before.xlsx.xlsx1,340 KB9/25/2020 9:46 PM
7. Peer comparison Gross profit %.mp417,602 KB9/25/2020 9:46 PM
7. Peer comparison Gross profit %.vtt3 KB9/25/2020 9:46 PM
7.1 4. Gross profit automotive.xlsx.xlsx1,347 KB9/25/2020 9:46 PM
8. Calculating automotive gross profit.mp428,451 KB9/25/2020 9:46 PM
8. Calculating automotive gross profit.vtt3 KB9/25/2020 9:46 PM
8.1 4a. Gross profit automotive - before.xlsx.xlsx1,549 KB9/25/2020 9:46 PM
8.2 4a. Gross profit automotive - after.xlsx.xlsx1,356 KB9/25/2020 9:46 PM
9. Calculating automotive cost of sales.mp417,952 KB9/25/2020 9:46 PM
9. Calculating automotive cost of sales.vtt3 KB9/25/2020 9:46 PM
9.1 5. Cost of sales and chart.xlsx.xlsx1,370 KB9/25/2020 9:46 PM