TUTORS | Financial Modelling for Utility Tariff Setting

TUTORS | Financial Modelling for Utility Tariff Setting

Course curriculum

1. Welcome to the Course
1. Course Overview
1. FMUTS Time-table
1. Programme Team
1. Dr Peter Twesigye
2. Dr Martin Rodriguez Pardina
3. Haydn Palliser
1. Guide Video 01 | Tutor Welcome and Instructions
2. Guide Video 02 | Introduction to Modelling
3. Guide Video 03 | Case Study Briefing
1. Pre-Video 01 | UCT Course Introduction
2. Pre-Video 02 | The Rationale for Regulation
3. Pre-Video 03 | Incentives for Productive Efficiency
4. Pre-Video 05 | Estimating Revenue Requirements | (B) Example
5. Pre-Video 06 | NPV Function
6. Pre-Video 07 | IRR
7. Pre-Video 08 | Excel functions - Anchoring
8. Pre-Video 09 | Excel functions - IF Function
9. Pre-Video 10 | Excel functions - IF(OR) and IF(AND) statement
10. Pre-Video 11 | Excel functions - SUMIF Function
11. Pre-Video 12 | Excel functions - LOOKUP Function
12. Pre-Video 13 | Best Practice - Principles
13. Pre-Video 14 | Best Practice - Flags and Conditional Formats
14. Pre-Video 15 | Best Practice - Styles
15. Pre-Video 16 | Best Practice - Control Accounts
16. Pre-Video 17 | Excel shortcuts and Introduction
17. Pre-Video 18 | Final Model Overview
18. EXERCISE | Excel Shortcuts download
1. Introduction to Excel Shortcuts
2. Simulation Model
3. FMUTS Full Model 2024
1. Case Study 1 | Regulatory treatment of asset base
2. Instructions for Case Study 2
3. Case Study 2 | Regulations
4. FMUTS Full Model
1. Sensitivities & Scenarios Video
1. Zoom Recording | 12 March 2025
2. Zoom Recording | 25 March 2025 | Dry Run

About this course

Free
38 lessons
3.5 hours of video content