Shipping Port Financial Model

Description
This is an excel model created for a shipping port, 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 model has been developed considering the port authority is looking to construct and open a new terminal along with an existing terminal. IRR and NPV has been calculated along with Coverage Ratios like DSCR and LLCR, considering the new terminal funding requirements.

You can build yourself a custom model like this one on the site emodelfactory.com Try now.
Or connect with me, if you want to personalize this model as per your requirements.