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