1.
COVER PAGE
S/N Lessons Done?
1 Cover ✘
2. MODEL STRUCTURE
S/N Lessons Done?
1 Building template sheet ✘
2 Printing settings ✘
3 Cell styles ✘
3. SCENARIO
S/N Lessons Done?
29th & 30th June
1 Scenario structure
2024 2 Pricing scenario
✘
3 Sales volume growth scenario
4 Cost inflation scenario
4. ASSUMPTIONS
S/N Lessons Done?
1 Revenue assumptions
2 Cost (Cost of sales & OpEx) assumptions
3 CapEx & Depreciation assumptions
4 Debt & interest expense assumptions
5 Taxation assumptions
6 Working capital assumptions
7 Equity assumptions
8 Other assumptions
5. FS AND SCHEDULE & CALCULATION SHEETs
S/N Lessons
1 Prepare the FS sheet
2 Link Historical FS
6th, 7th & 13th 3 Revenue schedule
4 Cost of sales schedule
July 2024
✘ 5 CapEx & depreciation schedule
✘ 6 Depreciation schedule: Other methods
✘ 7 Update income statement items
8 Complete tax schedule
9 Working capital schedule
6. FINANCING SCHEDULES
S/N Lessons
1 Equity schedule
14th & 20th July 2 Update FS before debt calc.
3 Debt & interest schedules
2024 4 Excess cash modeling
5 Revolver cash sweep modeling
6 Interest expense calculation
7 Circularity in the model
7. SUMMARY
S/N Lessons
1 Select summary sheet line
21st July 2024 2 Build a linked summary sheet
3 Replicate scenarios
8. FINAL CHECKS
ATION SHEETs
Done?
ULES
Done?
Done?