OF-251 Building and Analyzing Financial Models I - Part A (April 27-May 15, 2020)

Course Offering:

Dates: April 27-May 15, 2020

Location: Online

Tuition: $2,500

Code: 4209-OL

CEUs: 3.0



Without systematic and comprehensive fi nancial planning, review, and analysis, project developers and owners cannot assess the bankability and viability of a project. In this IP3 course titled, Building and Analyzing Financial Models I, we focus exclusively on the techniques of building, interpreting, and analyzing a project financial model using MS Excel®.

The structure of this course is unlike any other that IP3 off ers, as the focus each day is on learning certain financing and accounting techniques, and practicing those techniques in an on-going project case study.

Each day, the IP3 financial modeling facilitator will build additional elements into the financial model. By the end of the course, participants will not only understand all key accounting and financial terms and how to use them, but will have applied them to a simulated PPP project model.


Learning Outcomes:

  • Identify the key accounting and fi nance terms and concepts used in fi nancial models
  • Develop best practices and shortcuts for spreadsheet modeling
  • Determine the key input variables to an infrastructure fi nancing spreadsheet
  • Integrate and link key fi nancial statements including the profi t and loss, balance sheet, and cash fl ow waterfall into a financial model
  • Build a capital expenditure worksheet that details the timing and amounts of capex including interest capitalized during construction