Dates: May 14-25, 2018
Location: Washington, DC
Without systematic and comprehensive financial planning, review, and analysis, project developers and owners cannot assess the bankability and viability of a project. The Introduction to Building and Analyzing Financial Models course focuses exclusively on the techniques of building, interpreting, and analyzing a financial model using Microsoft Excel® software.
The class structure is unlike any other that the Institute for Public-Private Partnerships, A Tetra Tech Company (IP3), offers, as the focus each day is on learning certain financing and accounting techniques, and practicing those techniques in an ongoing project case study. The IP3 financial modeling instructor will teach the fundamentals of the spreadsheet software. The instructor then will build further elements into the financial model so that, by the end of the course, participants will understand key accounting and financial terms and concepts and will have applied them to a simulated public-private partnership (PPP) model.
- Identify the key accounting and finance terms and concepts used in financial models
- Apply best practices and shortcuts for spreadsheet modeling
- Determine the key input variables to an infrastructure financing spreadsheet
- Integrate and link key financial statements including the profit and loss, balance sheet, and cash flow waterfall into a financial model
- Build a capital expenditure worksheet that details the timing and amounts of capex including interest capitalized during construction
- Develop a funding worksheet that helps determine the debt capacity of a project
- Develop and interpret key output worksheets which summarize the profitability measures (NPV and IRR) and various debt service cover ratios (DCSR)
- Perform key sensitivity and scenario analyses to determine how robust the project is under a range of downside assumptions
- Create a comprehensive financial model and present the financing viability to experts and peers