Model Bucket

Financial Model for Toll Road Infrastructure Project

Excel based model to check the financial viablity of toll road infrastructure development project(expressway,sea link bridge,underground tunnel...) and financial return for all stake holders.

It takes basic input like length of Toll Road,development cost per km,operation cost per km,vehicle growth,leaverage for project,etc.

It projects the financial statements (P&L,Balance Sheet & Cash Flow) for concession period and construction period,cash flow to equity holders,IRR,NPV,etc.

It also convers sensitivity analysis on various parameters like development cost,interest rate,vehicle growth,toll price,etc.

Table of Content :

Modelling Variables,Project Returns,Sensitivity Analysis
Projected Profit and Loss statement
Projected Cash Flow statement,Project IRR,Project NPV
Projected Balance Sheet statement
Loan Schedule with details of all types of loan/bond including zero coupon bonds,subordinated debt
Equity Schedule with details related to equity sponsors cash flows,IRR,NPV..
Depreciation Schedule
Revenue Details
Expenditure Details
Assumptions of Modelling
Limitations

  • Screenshot
  • Screenshot
  • Screenshot
  • Screenshot
  • Screenshot
  • Screenshot
  • Screenshot

About the author

dzire2excel

1 models
-----
dzire2excel avatar Ask author a question

Reviews

This model has no reviews yet

Be the first to purchase this model and leave a review. Add this to your cart

Need some help?

This modeller has offered to support this model, you can commission them to support your model and customise it through Model Factory.

Get Support

Can't find what you need? No problem.

Start a Model Factory job for FREE and engage a professional to build your model for you.

Start Job