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 |