ESAMI Offices

Short Courses

Governance and Public Sector Management
Sorry,the application deadline for this course has expired.

Course Title: Public Private Partnership Projects Financial Modelling With Excel

Venue: ESAMI Headquarters, Arusha, TANZANIA  
Learning Duration:  2 Weeks 
Starting: 18 Jun 2018  Ending: 29 Jun 2018
Fees: 1500 USD
Payment Details: To cover tuition and training materials only


Business modelling 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 modelling frameworks on capital budgeting, risk measurement, regression analysis and Monte Carlo Simulation among others.



At the end of the course, participants will be able to:

  • Analyse the key input variables to an infrastructure financing model

  • Explain 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 modelling

  • Perform key sensitivity and scenario analyses to determine how robust the project is

  • Develop a funding worksheet that helps determine the debt capacity of a project



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 Ministries of Finance will find the course particularly useful.



  • Overview to project finance and infrastructure investment analysis

  • Financial modelling principles

  • Building the financial models

  • Identifying and structuring the input variables to a financial model

  • Advanced MS-Excel techniques

  • Modelling financial reports

  • Estimating demand and revenue projections

  • Generating and analysing forecasts

  • Determining the NPV, IRR and DCF, DCR

  • Annuity financing modelling

  • Tariff setting and tariff change impacts

  • scenario analyses and sensitivity analysis

  • Integrating risk into the model

  • Analysis of the overall debt structure

Course No:  2018-06-18-3-11-2048



2 Jul 2018
  BUSINESS SCHOOL CALENDAR FOR 2018   ESAMI Business School is inviting applications for its degree programmes scheduled to commence as below.     DBA COMMENC...
View More

Short Courses Calendar





facebook   twitter