Master Class In Financial Modelling For Power & Utilities
Introduction
About EDWARD BODMER
He is an experienced financial and economic consultant, trainer, and lecturer. He has conducted many training programs around the world to both large corporations and public programs that have covered project finance, corporate finance, energy analysis, and mergers and acquisitions.
Formerly, Bodmer was the Vice President at the First National Bank of Chicago, where he directed analysis of energy loans and also created financial modeling techniques used in advisory projects.
For further information, please contact :
Pn. Samihah Jaafar | 019 – 286 3155 | samihah.jaafar@tnb.com.my
DOWNLOAD BROCHURE NOW! CLICK HERE
Open To All
Target Participant
Pulse Grande Hotel, Putrajaya
Venue
5 Days
Duration
Objective
- The ability to interpret financial model
- To effectively use Microsoft Excel to build a financial model for managing projects effectively
- To use Merchant Prices within the financial model and be able to download data from the international market for analysis and comparison.
Agenda
Day 1
Tools To Work Efficiently in Excel
- The idea of the initial session is to assure that all participants, I including people who do not routinely work with Excel, become familiar with tools to make the analysis more efficient and to work comfortably on all of the class exercises
Model Structure and Timing
- The second session begins with introductory comments about the skills and general objectives in project finance modeling with an emphasis on the difficulty in measuring and valuing risk. In this part of the course, participants construct a basic project finance model without debt.
Day 2
Completion of Operating Section of Model
- The third section of the course works through issues associated with completing the operating section of a model including timing issues, depreciation, growth and inflation, construction analysis and project IRR measurement.
Comparison of Actual to Forecast
- The fourth section is a new module that demonstrates alternative ways of comparing actual results with results that were initially forecast in a financial model. The theory of performance measurement and practical issues are addressed.
Day 3
Addition of Debt to Forecast
- As project finance is a type of debt, the third module addresses various theoretical and practical issues related to debt financing in general and project debt in particular. Subjects included in module three include setting up a debt schedule, debt sculpting, flexible debt terms, debt capacity, debt structure, and credit measures. The debt analysis is scheduled to take an entire day.
Day 4
Merchant Prices in Financial Models
- The sixth module introduces merchant markets and the incorporation of merchant prices in financial models. This section of the course also introduces tools with respect to reading data from the internet and efficiently working with databases. The theory of long-term marginal cost and short-term marginal cost is explained in the context of merchant price analysis financial modeling.
Credit Enhancements and Cash Flow Waterfall
- Given the merchant model pricing section, the seventh model demonstrates how bankers evaluate the risk of fluctuating cash flow. A cash flow waterfall is added to the model and cash sweeps.
Day 5
Financial Ratios and Financial Statements
- The eighth module completes the project finance model through the inclusion of a profit and loss statement and computation of income taxes. Given the income, a balance sheet is computed to verify calculations in the model. Finally, the LLCR, PLCR and the average debt life are computed.
What people say?
It was a perfect match seeing that i need to work on my confidence.I actually learnt more skills that is needed for me to be able to develop training programs.
Bodil Dahl
Ceo & Founder Crix
The course definitely helped in improving concepts. It would be great if you add more examples of templates for Training evaluation. This would help in creating better sheets in future. Thanks
Sonal Tyagi
Head Of Sales , Intel
Related products
-
UncategorizedProject Management Essentials
-
-
UncategorizedSubstation Operation 11kV (City & Guilds)
Users Today : 225
Views Today : 791
Total views : 970960