Project Finance – Toll Road – Build and Operate Excel Model

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

, ,
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Concessions, Build-Operate-Transfer (BOT) Project is a type of public-private partnership that are output focused. BOT project typically involves 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 the 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 includes 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 modeling skills
2. Gain an understanding of leading approaches towards financial
modeling, in order to build models that are robust and user-friendly
in nature.
3. Extend their toolkit for modeling more complex areas of a
project finance model in an efficient and flexible manner
4. Understand the very basics of Project Finance

Write a Review