ESAMI Offices
 
 
 

Short Courses

Corporate Intrapreneurship

Course Title: PPP Project Financial Modeling With Excel

Venue: ESAMI Headquarters, Arusha, TANZANIA  
Learning Duration:  2 weeks 
Starting: 14 Jun 2021  Ending: 25 Jun 2021
Fees: 1500 USD
Payment Details: To cover tuition and training materials only

COURSE OVERVIEW
Business modeling requires analysts to produce the quantitative models that top management use to support their decision making, but top management must also understand the strengths and weaknesses of the models if they are to use them effectively to support their decisions, and robustly navigate the strategic negotiation landscape. This is particularly important for PPP projects where long term commitments are made now based on bankability, value for money and risk allocation. During the course, participants will gain knowledge and skills on the frameworks, tools, and methodologies necessary to build quantitative models for financial decision making in order to improve financial viability and bankability of PPP projects. Participants will master modeling frameworks on capital budgeting, risk measurement, regression analysis and Monte Carlo simulation among others.

WHO SHOULD ATTEND?
The course targets ppp unit personnel, ppp project managers, accountants, auditors, finance managers and ppp transaction advisors. Economists that are involved in identifying ppp project candidates will also benefit from the course. The course is also useful for engineers involved in ppp projects and employees working with special purpose vehicles (spvs) or members of the spv consortium. Additionally, those working in public sector investment programmes and in the external resources departments in the ministry of finance will find the course particularly useful.

HOW PARTICIPANTS WILL BENEFIT
At the end of the course, participants will be able to:
• Analyze the key input variables to an infrastructure financing model;
• Understand the basic principles in financial modeling;
• Estimate demand and revenue streams for the PPP projects;
• Simulate the impact of demand fluctuations and tariff changes;
• Assess the viability of PPP projects more effectively;
• Determine key financial ratios using excel worksheets for modeling;
• Perform key sensitivity and scenario analysis to determine how robust the project is;
• Develop a funding worksheet that helps determine the debt capacity of a project.

TOPICS INCLUDE
• Overview to project finance and infrastructure investment analysis;
• Financial modeling principles;
• Identifying and structuring the input variables to a financial model
• Advanced MS-Excel techniques;
• Modeling financial reports;
• Estimating demand and revenue projections;
• Determining the NPV, IRR and DCF, DCR;
• Annuity financing modeling;
• Tariff setting and tariff change impacts;
• Risk analysis;
• Monte Carlo simulation and sensitivity analysis;
• Regression analysis and forecasting.

Course No:  2021-06-14-3-17-2843

Apply Online

PROGRAMME ANNOUNCEMENTS

2021 ESAMI BUSINESS SCHOOL ACTIVITY CALENDAR

26 Jan 2021
    2021 ESAMI BUSINESS SCHOOL ACTIVITY CALENDAR PROGRAMME STARTING DATES S/N VENUE PROGRAMME STARTING DATE INTAKE 44 EVENING ...
View More
 

Short Courses Calendar

bullet

CENTERS

bullet

DOWNLOADS

 
 
 
facebook   twitter