Financial Modelling for Utility Tariff Setting 2023

Financial Modelling for Utility Tariff Setting 2023

Course curriculum

1. Welcome to the Course
1. Programme Team
1. Dr Peter Twesigye
2. Dr Martin Rodriguez Pardina
3. Haydn Palliser
4. Hasha Tlhotlhalemaje
1. Pre Course Basics and Test run
2. Pre Course Live Overview
3. ZOOM SESSION VIDEO | 15 May 2023
4. ZOOM SESSION VIDEO | 17 May 2023
5. ZOOM SESSION VIDEO | 18 May 2023
1. Pre-Video 01 | Intro to debt and equity
2. Pre-Video 02 | Benefits of leverage
3. Pre-Video 03 | Present Value Math
4. Pre-Video 04 | NPV Function
5. Pre-Video 05 | IRR
6. Pre-Video 06 | Excel functions - Anchoring
7. Pre-Video 07 | Excel functions - IF Function
8. Pre-Video 08 | Excel functions - IF(OR) and IF(AND) statement
9. Pre-Video 09 | Excel functions - SUMIF Function
10. Pre-Video 10 | Excel functions - LOOKUP Function
11. Pre-Video 11 | Best Practice - Principles
12. Pre-Video 12 | Best Practice - Flags and Conditional Formats
13. Pre-Video 13 | Best Practice - Styles
14. Pre-Video 14 | Best Practice - Control Accounts
15. EXERCISE | Excel Shortcuts download
1. DAY 1_15 May | Pre-course Reading 01 | Demise of the standard reform model
2. DAY 1_15 May | Pre-course Reading 02 | Making power affordable in Africa and viable for its Utilities
3. DAY 1_15 May | Pre-course Reading 03 | ECA - Two approaches to tariff design in the electricity sector – how different are they?
4. DAY 2_16 May | Pre-course Reading 04 | 8a RAB Depreciation Notes
5. DAY 2_16 May | Pre-course Reading 05 | Cost Recovery and Financial Viability of the Power Sector in Developing Countries
6. DAY 2_16 May | Pre-course Reading 06 | Financial viability of Power Utilities in Africa_October 2016
7. DAY 3_17 May | Pre-course Reading 07 | Accounting for Infrastructure Regulation
8. DAY 3_17 May | Pre-course Reading 08 | Taking Stock of Economic Regulation of Power Utilities in the Developing World
9. DAY 4_18 May | Pre-course Reading 09 | Resetting Price Controls for Privatized Utilities
10. DAY 5_19 May | Pre-course Reading 10 | References - Reading Material
11. DAY 5_19 May | Pre-course Reading 11 | Revisiting Power Sector Reforms in Africa
1. Pre-Course Quiz | 15 May
1. DAY 1 | Time-Table
2. DAY 1 | Overview
3. VIDEOS
4. LECTURE PRESENTATIONS
5. ZOOM ONLINE | Day 1
6. DAY 1 | Quiz
1. Video 01_Lesson 00 | Utility overview and definition of case study
2. Video 02_Lesson 00 | Overview of final model and process
3. Video 03_Lesson 00 | Excel shortcuts and Introduction
4. Video 04_Lesson 00 | Part 1 | Overview of economic and regulatory methodologies
5. Video 05_Lesson 00 | Part 2 | Overview of economic and regulatory methodologies
6. Video 06_Lesson 00 | Introduction to Economic and Financial Regulatory Models
7. Video 07_Lesson 00 | Regulatory Asset Base
8. Video 08_Lesson 00 | Rolling forward the regulatory asset base
9. Video 09_Lesson 00 | Economic sustainability and revenue requirements
10. Video 10_Lesson 00 | Financial sustainability
11. Video 11_Lesson 00 | RAB building blocks - accounting approach, single year (Part A)
12. Video 12_Lesson 00 | RAB building blocks : Return caps
13. Video 13_Lesson 00 | RAB building blocks : Accounting Approach , Single Year (Part B)
14. Video 14_Lesson 00 | RAB building blocks : Accounting Approach, Multi Year
15. Video 15_Lesson 00 | RAB building blocks : Cash Approach, Single Year (Part A)
16. Video 16_Lesson 00 | RAB building blocks : Cash Approach, Multi Year (Part B)
17. Video 17_Lesson 00 | RAB building blocks : Proof of cash approach
18. Video 18_Lesson 00 | RAB building blocks : Accounting vs Cash Approach
19. Video 19_Lesson 00 | Sensitivities and Scenarios (recap)
20. Video 20_Lesson 00 | Data Tables (recap)
1. DAY 1: May 22 - Excel Model
2. FULL MODEL _FMUTS 2023
1. DAY 1 | Class Recording_Part 1
2. DAY 1 | Class Recording_Part 2
1. DAY 2 | Time-Table
2. Day 2 | Overview
3. VIDEOS
4. READINGS
5. ZOOM ONLINE
6. DAY 2 | Quiz
7. LECTURE PRESENTATIONS
1. Video 21_Lesson 00 | Objectives of economic regulation
2. Video 22_Lesson 00 | Regulatory Instruments
3. Video 23_Lesson 00 | Depreciation
4. Video 24_Lesson 00 | Regulatory treatment of depreciation
5. Video 25_Lesson 00 | Regulatory treatment of investments
6. Video 26_Lesson 00 | Investment types (replacement, expansion, quality)
7. Video 27_Lesson 00 | Part 1 | Demand projections
8. Video 28_Lesson 00 | Part 2 | Demand projections
1. DAY 2 : FMUTS Day 1 Modeling (23 May)
2. DAY 2 : FMUTS Day 2 Modelling
1. Day 2 | Class Recording
1. DAY 3 | Time-table
2. DAY 3 | Overview
3. VIDEOS
4. LECTURE PRESENTATIONS
5. ZOOM ONLINE
6. DAY 3 | Quiz
1. Video 29_Lesson 00 | Weighted average cost of capital (WACC)
2. Video 30_Lesson 00 | WACC Introduction
3. Video 31_Lesson 00 | WACC extended _Cost of Debt
4. Video 32_Lesson 00 | WACC extended_Cost of Equity
5. Video 33_Lesson 00 | WACC extended_Summary
6. Video 34_Lesson 00 | Risk versus Returns
7. Video 35_Lesson 00 | Part 1 | Country risk premium
8. Video 36_Lesson 00 | Part 2 | Country risk premium (credit ratings approach)
9. Video 37_Lesson 00 | Role of Parties and Contractual Cashflow
10. Video 38_Lesson 00 | Allocation of Risk
11. Video 39_Lesson 00 | Opex - Benchmarking
12. Video 40_Lesson 00 | Efficiency factors
13. Video 41_Lesson 00 | Regulatory treatment of losses
14. Video 42_Lesson 00 | Adding expansion debt to model
15. Video 43_Lesson 00 | Introduction to 3-way statements
16. Video 44_Lesson 00 | Building a balance sheet and income statement
1. DAY 3 | FMUTS Day 2 Modelling (24 May)
2. DAY 3 | FMUTS Day 3 Modelling (1)
1. Day 3 | Class Recording
1. DAY 4 | Time-table
2. DAY 4 | Overview
3. VIDEOS
4. EXERCISES
5. LECTURE PRESENTATION
6. ZOOM ONLINE
7. DAY 4 | Quiz
1. Video 45_Lesson 00 | Retained Earnings
2. Video 46_Lesson 00 | Working Capital
3. Video 47_Lesson 00 | Adding working capital to balance sheet
4. Video 48_Lesson 00 | Part 1 | Designing the tariff structure
5. Video 49_Lesson 00 | Part 2 | Designing the tariff structure
6. Video 50_Lesson 00 | Why do capacity payments exist?
7. Video 51_Lesson 00 | Introduction to graphing
8. NOT A VIDEO | Demo Excel_Lesson 00 | Example Excel file used in 3-way statement videos
1. DAY 4 | FMUTS Day 4 Case Study Modelling
2. UPDATED_FMUTSDay3Modelling1-230524-065036 (1).xlsx
3. DAY 4 | FMUTS full model 2023 Demo Model Day 4
1. Day 4 | Class Recording
1. DAY 5 | Time-table
2. DAY 5 | Overview
3. VIDEOS
4. LECTURE PRESENTATION
5. ZOOM ONLINE
6. DAY 5 | Overall Course Quiz
1. Optional Video 01_Lesson 00 | NERSA's cost of supply methodology
2. Optional Video 02_Lesson 00 | Multi-year tariff framework in South Africa
3. Optional Video 03_Lesson 00 | Wheeling tariff formulation methodologies
4. Optional Video 04_Lesson 00 | Tariffs for SSEG
5. Optional Video 05_Lesson 00 | SSEG Compensation Schemes
6. Optional Video 06_Lesson 00 | Municipal SSEG success stories
7. Optional Video 07_Lesson 00 | Case study model overview
1. DAY 5 | FMUTS Day 4 Case Study Modelling
1. COURSE FEEDBACK SURVEY
2. LECTURER EVALUATION
3. LECTURER EVALUATION | Peter Twesigye
4. LECTURER EVALUATION | Martin Pardina
5. LECTURER EVALUATION | Haydn Palliser
6. LECTURER EVALUATION | Hasha Tlhotlhalemaje
1. Day 5 | Class Recording

About this course

Free
151 lessons
51.5 hours of video content