Project Finance - Toll Road - Build and Operate Excel Model with 3 Statements and Valuation
Originally published: 22/04/2019 07:24
Last version published: 05/09/2022 07:51
Publication number: ELQ-63523-8
View all versions & Certificate
certified

Project Finance - Toll Road - Build and Operate Excel Model with 3 Statements and Valuation

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

Description
Fin-wiser’s Toll Road Build and Operate model helps user to assess the financial viability of a toll toad concession, by capturing all the essential inputs related to construction, operation, and financing.The Model includes assumptions related to:1. Development cost, Construction costs and Developer’s Fee2. Toll Road Length, Number of vehicles per day3. Toll Fee and other sources of revenue4. Variable O&M cost per vehicle (divided into 8 sub heads such as staff, electricity, consumables, transport and fuel) and other fixed costs (SPV, insurance, land lease, community payment, management fee & more)5. Flexible Funding Profile – Cash equity, Bridge Loan, Bank Debt, DSRA and Bank overdraft 6. Working Capital Assumptions related to accounts receivables and payables7. Straight Line and Accelerated Depreciation option8. Annuity, Sculpted Debt and Even Principal Repayment options9. Inflation and Indexation10. VAT during construction and operations phase11. Decommissioning cost and reserve, if requiredModel Output includes:1. Project IRR & NPV2. Equity IRR & NPV3. Minimum and Average DSCR4. LLCR and PLCR5. Equity Payback Period6. Cash Waterfall7. Debt Service Profile8. Integrated Financial Statements9. Fully Integrated DashboardModel Package includes:1. Excel based financial model (Excel binary format i.e. xlsb)2. Model Heat Map (FWA Maps) – The file includes heat map of the model with color codes on F: Unique formula

This Best Practice includes
1 Excel file, 1 Word Doc and 2 Supporting Excel files

Acquire business license for $149.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.


5.0 / 5 (2 votes)

please wait...