Toll Road Project Financial Model
Originally published: 27/08/2021 08:19
Last version published: 01/09/2021 07:55
Publication number: ELQ-66512-2
View all versions & Certificate

Toll Road Project Financial Model

Toll Road Financial Model for evaluating the project feasibility, created using

This is an excel model created for a toll road, and was created using financial automation tool. Using this anyone can very easily create models for themselves in 20 minutes. The model has the following features

1. The calculations are neatly built and based on FAST modelling standard, UK
2. The whole model is highly structured and is easy to understand and make further changes
3. The model is completely independent of the tool through which it was build. So in other words, just like a normal excel model, and anyone can make changes in it.
4. The model has pre-built "Dashboard" that has neatly arranged metrics driven by sheet "Dash Prep"
5. There is a "Check" sheet to track any mismatches in the model
6. And a "Track" sheet which can be used to save and compare key outputs across different version of the model
7. The Model has Actuals & Inputs Sheet for putting in historical and forecast assumptions
8. Circularity Solve Macro, Save Track Macro, ToC update macro are built in the model

This bid model has been developed for a toll project for 25 years having toll rates classified as "Through Traffic", "Daily Pass", "Monthly Pass", "Local Pass". The arrangement being BOT (Build-Operate-Transfer). IRR and NPV has been calculated along with Coverage Ratios like DSCR and LLCR.

This Best Practice includes
1 Excel File

Acquire business license for $99.00

Add to cart

Add to bookmarks


Further information

Recommended excel version should be 2016 or beyond
Macros should be enabled

5.0 / 5 (1 votes)

please wait...