Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
  • Project Finance Model – Toll Road – 30 Year Concession
Originally published: 30/04/2018 14:26
Last version published: 10/07/2018 13:16
Publication number: ELQ-24180-5
View all versions & Certificate
certified

Project Finance Model – Toll Road – 30 Year Concession

A project finance model for the construction of a toll road with a 30-year concession.

business modeldashboardfeasibilityfinancial modelirrmodanonpvproject analysisproject financetoll road

Description
The excel model is an effective tool to assess the economic feasibility of a long-term infrastructure project. The model is designed to assist users in the structuring of a project finance deal by determining the maximum amount of debt used to finance the project and measure the risk through the cash flow waterfall analysis.

Time Series:
Construction Period - Monthly
Operational Period - Annual

The Model features:
• Table of Contents
• Navigation
• Key (model legend)
• Error check and Alerts
• Assumptions:
- Revenue & Expenses
Open System Transaction: calculation based on daily tariff and daily traffic
Closed System Transaction: calculation based on distance of toll road, daily tariff, and daily traffic
RAMP: calculation based on daily tariff and daily traffic
- Initial Investment
Initial Investment for the project and it includes optional government subsidy
- Financing
Debt: Equal repayments with an optional grace period and two interest calculation (IDO & IDC)
Equity: controlled debt-to-equity ratio with dividend payout ratio
- Capital Expenditure
Straight-line depreciation during operations
- Others
• Outputs:
- Dashboard
Graph: Graph is interchangeable between Construction and Operation Period for detailed analysis
Ratios: Summary of key project ratios
Project Detail Summary
Sensitivity Analysis
- Income Statement
- Cash Flow Statement
- Cash Flow Waterfall
- Project Finance Ratios (NPV, IRR, Payback Period, DSCR, DER, etc)

The model was developed using financial modelling best practice standards. This particular model was built using the Modano Software under the Best Practice Modelling Standard (BPMS). I used a specialist financial modelling software to incorporate flexibility into the time series.

Should you have any questions on the model you're welcome to Private Message us via our Eloquens Channel or use the discussion feed below.

Your review and rating of the model is always appreciated.

Visit out website at www.numarus.com

This business tool includes
1 Excel File

Acquire business license for $160.00

Add to cart

Add to bookmarks

Discuss

Further information

The excel model is an effective tool to assess the economic feasibility of a long-term infrastructure project.

A project finance model for the construction of a toll road with a 30-year concession.

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Project Finance Model – Toll Road – 30 Year Concession

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

  • Carlos Andrey Jiménez
    Hello there. Looking at the model´s features, it seems that is a very hepful tool. However, I am wondering if the model is structured in a way that I can not modify a thing and apply the concepts and formulas to my specific project. I mean, will I be able so see every formula in the excel? Does it have any VBA hidden code? Can I add or remove parts of the model? I need to have this model as a reference for creating my own model (a government concession of a toll road-25 five year- in Costa Rica), but to do that I need to see every detail and aspect of the creation of this model. I appreciate your help clarifying my doubts. Thank you!
    arrow_drop_uparrow_drop_downReply reply
    please wait...