Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
  • Project Finance - Toll Road - Build and Operate Excel Model
Originally published: 22/04/2019 07:24
Last version published: 10/09/2019 15:00
Publication number: ELQ-63523-4
View all versions & Certificate
certified

Project Finance - Toll Road - Build and Operate Excel Model

Toll Operations is a project finance model template for Toll Operating Company.

Description
Concessions, Build-Operate-Transfer (BOT) Project is type of public-private partnerships that are output focused. BOT project typically involve significant design and construction as well as long term operations, for new build (Greenfield) or projects involving significant refurbishment and extension (brownfield).

The model includes Project financing, which is the financing of long-term infrastructure and industrial projects based upon a complex financial structure. Both project debt and equity are used to finance the project. Debt is repaid using the cash flow generated by operation of the project, rather than other resources of the project owners.

Toll Operations Model template is built for a proposal to construct and operate a toll road and include assumptions related to:

1. Traffic volume and Toll charged (user can select 5 different vehicle types and toll changed on them)
2. Fixed and variable cost of operations
3. Construction Cost (Divided into 4 major heads)
4. Flexible Funding Profile
5. Working Capital Assumptions
6. Inflation and Indexation

Model Output includes:
1. Project IRR & NPV
2. Equity IRR & NPV
3. Minimum and Average DSCR
4. LLCR and PLCR
5. Equity Payback Period
6. Cash Waterfall
7. Debt Service Profile

This model will help you in understanding and Modeling of:
1. Flexible capital structuring
2. DSCR (Debt Service coverage ratio)
3. PLCR (Project Life coverage ratio)
4. LLCR (Loan Life coverage ratio)
5. Cash waterfall
6. Project and Equity IRR
7. Gearing ratios

the model is ideal for those looking to achieve the following:

1. Refresh their financial modelling skills
2. Gain an understanding of leading approaches towards financial
modelling, in order to build models that are robust and user friendly
in nature.
3. Extend their toolkit for modelling more complex areas of a
project finance model in an efficient and flexible manner
4. Understand the very basics of Project Finance

This Best Practice includes
1 Excel file

Acquire business license for $49.00

Add to cart

Add to bookmarks

Discuss

Further information

The objective of the model is to understand the business viability of Toll Road concessions

User can use this model to:

1. Understand the business viability of Toll Road concessions
2. Understand Revenue and Cost drivers of Toll Road concession
3. Understand Funding calculations and Covenants

The objective of the model is to understand the business viability of Toll Road Concession Business and is not applicable on any other sector.

Reviews

  • Be the first to review this Downloadable Tool

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Fin-Wiser Advisory

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Project Finance - Toll Road - Build And Operate Excel Model?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...