TC4S:\2022_3\The Complete Financial Analyst Course\11. Modeling in Excel - Building a complete 3-statement model |
 Up one directory... |
|
|
 1. Introduction to the Exercise.mp4 | 37,528 KB | 4/21/2019 1:11 PM |
| 1. Introduction to the Exercise.vtt | 4 KB | 4/21/2019 12:52 PM |
| 1.1 Financial Modeling Notes.pdf.pdf | 691 KB | 4/21/2019 12:52 PM |
| 1.2 1.1_after.xlsx.xlsx | 33 KB | 4/21/2019 12:52 PM |
| 1.3 1.1_before.xlsx.xlsx | 19 KB | 4/21/2019 12:52 PM |
| 2. Let's create a mapping of financials.mp4 | 31,470 KB | 4/21/2019 1:11 PM |
| 2. Let's create a mapping of financials.vtt | 3 KB | 4/21/2019 1:00 PM |
| 2.1 1.2_before.xlsx.xlsx | 31 KB | 4/21/2019 1:00 PM |
| 2.2 1.2_after.xlsx.xlsx | 35 KB | 4/21/2019 1:00 PM |
| 3. Building an output P&L sheet.mp4 | 31,283 KB | 4/21/2019 1:13 PM |
| 3. Building an output P&L sheet.vtt | 5 KB | 4/21/2019 1:07 PM |
| 3.1 1.3_before.xlsx.xlsx | 33 KB | 4/21/2019 1:07 PM |
| 3.2 1.3_after.xlsx.xlsx | 42 KB | 4/21/2019 1:07 PM |
| 4. Filling in the output P&L sheet with historical financials.mp4 | 24,484 KB | 4/21/2019 1:09 PM |
| 4. Filling in the output P&L sheet with historical financials.vtt | 3 KB | 4/21/2019 12:49 PM |
| 4.1 1.4_before.xlsx.xlsx | 38 KB | 4/21/2019 12:49 PM |
| 4.2 1.4_after.xlsx.xlsx | 42 KB | 4/21/2019 12:49 PM |
| 5. Calculating percentage variances and applying conditional formatting.mp4 | 27,865 KB | 4/21/2019 1:13 PM |
| 5. Calculating percentage variances and applying conditional formatting.vtt | 4 KB | 4/21/2019 1:03 PM |
| 5.1 1.5_before.xlsx.xlsx | 40 KB | 4/21/2019 1:03 PM |
| 5.2 1.5_after.xlsx.xlsx | 42 KB | 4/21/2019 1:03 PM |
| 6. Building an output Balance sheet.mp4 | 30,201 KB | 4/21/2019 1:11 PM |
| 6. Building an output Balance sheet.vtt | 4 KB | 4/21/2019 12:57 PM |
| 6.1 1.6_after.xlsx.xlsx | 55 KB | 4/21/2019 12:57 PM |
| 6.2 1.6_before.xlsx.xlsx | 48 KB | 4/21/2019 12:57 PM |
| 7. Using Index, Match, Match to fill in the output Balance sheet.mp4 | 44,530 KB | 4/21/2019 1:13 PM |
| 7. Using Index, Match, Match to fill in the output Balance sheet.vtt | 6 KB | 4/21/2019 12:53 PM |
| 7.1 1.7_after.xlsx.xlsx | 58 KB | 4/21/2019 12:53 PM |
| 7.2 1.7_before.xlsx.xlsx | 50 KB | 4/21/2019 12:53 PM |
| 8. Adding the forecast period.mp4 | 32,922 KB | 4/21/2019 1:12 PM |
| 8. Adding the forecast period.vtt | 4 KB | 4/21/2019 1:02 PM |
| 8.1 1.8_before.xlsx.xlsx | 51 KB | 4/21/2019 1:02 PM |
| 8.2 1.8_after.xlsx.xlsx | 55 KB | 4/21/2019 1:02 PM |
