Toll Road Project Financial Model

Description
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.