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