Enquiry Form

Infrastructure Model Objective

In this course, you construct a model from scratch building assumptions for a Toll road being floated by the Government under BOT model.In this video, you develop a 3-statement model completely from scratch, inputting historical data and assumptions to project out financial statements using step-by-step instruction on selecting, locating, and developing appropriate projection drivers. You learn how to factor in cost drawdowns for a the toll project, how the tolls are calculated and measured, how the quantum of Debt and equit is decided, how the deferred tax and deferred tax liabilities treated, how to build in the tax holiday period in the model u/s 80 IB and 80 IB of Income tax.

What Candidates Learn

  • Revenue drivers of a Infrastructure project
  • Gestation period from construction to actual revenue earning
  • Benefits of using Net Present Value (NPV) over Internal Rate of Return (IRR) to calculate the financial viability of a project
  • Building Dynamic Business Models from scratch with Multiple Scenarios using XIRR, MIRR.
  • How to build assumptions and the rational of taking them before starting your business model
  • Using different approaches like lowest common denominator and annual equivalency cash flow for determining the value of projects that have different life spans.
  • Calculation of free cash flows to firm and free cash flows to equity and how they are used to determine the profitability of a project
  • How To Take A Decision For A Project Using Different Techniques Like Data Tables, Scenario Manager, Solver Etc.

Got a Question?

We're here to help. Check out our FAQs, send us an email or call us at +91-9953729651