|  TC4S:\.@DOWNLOAD\22b - CTV\T\The Complete Financial Analyst Course 2019\12. Modeling in Excel - Let's build a flexible model with multiple scenarios | 
|  Up one directory... | 
|
|  | 
|  1. Calculating historical percentage ratios and use Index and Match for scenarios.mp4 | 50,539 KB | 9/26/2020 6:46 AM | 
|  1. Calculating historical percentage ratios and use Index and Match for scenarios.vtt | 6 KB | 9/26/2020 6:46 AM | 
|  1.1 1.9_before.xlsx.xlsx | 53 KB | 9/26/2020 6:46 AM | 
|  1.2 1.9_after.xlsx.xlsx | 55 KB | 9/26/2020 6:46 AM | 
|  2. Building a flexible model with Choose & Match.mp4 | 16,441 KB | 9/26/2020 6:46 AM | 
|  2. Building a flexible model with Choose & Match.vtt | 2 KB | 9/26/2020 6:46 AM | 
|  2.1 1.10_before.xlsx.xlsx | 54 KB | 9/26/2020 6:46 AM | 
|  2.2 1.10_after.xlsx.xlsx | 55 KB | 9/26/2020 6:46 AM | 
|  3. Building a flexible model with Vlookup & Columns.mp4 | 37,130 KB | 9/26/2020 6:46 AM | 
|  3. Building a flexible model with Vlookup & Columns.vtt | 4 KB | 9/26/2020 6:46 AM | 
|  3.1 1.11_before.xlsx.xlsx | 54 KB | 9/26/2020 6:46 AM | 
|  3.2 1.11_after.xlsx.xlsx | 56 KB | 9/26/2020 6:46 AM | 
|  4. Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %.mp4 | 45,567 KB | 9/26/2020 6:46 AM | 
|  4. Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %.vtt | 6 KB | 9/26/2020 6:46 AM | 
|  4.1 1.12_before.xlsx.xlsx | 54 KB | 9/26/2020 6:46 AM | 
|  4.2 Course notes - Building a financial model.pdf.pdf | 576 KB | 9/26/2020 6:46 AM | 
|  4.3 1.12_after.xlsx.xlsx | 57 KB | 9/26/2020 6:46 AM | 
|  5. Forecasting DSO, DPO, DIO, Other assets and Other liabilities.mp4 | 31,265 KB | 9/26/2020 6:46 AM | 
|  5. Forecasting DSO, DPO, DIO, Other assets and Other liabilities.vtt | 4 KB | 9/26/2020 6:46 AM | 
|  5.1 1.13_after.xlsx.xlsx | 58 KB | 9/26/2020 6:46 AM | 
|  5.2 1.13_before.xlsx.xlsx | 55 KB | 9/26/2020 6:46 AM |