PPP Project Financial Modeling With Excel

Start: Jun 10, 2024
End: Jun 21, 2024
Venue: ESAMI Headquarters - Arusha - Tanzania
Duration: 2 weeks
Start: Jun 14, 2021
End: Jun 25, 2021
Venue: ESAMI Headquarters - Arusha - Tanzania
Duration: 2 weeks
Statement of Need

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 programme, 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 Attends

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 programme, participants will be able to:

  • Analyze the key input variables to an infrastructure financing model;
  • Describe 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.

US$ 1500 to cover tuition and training materials only.