Shipping Port Financial Model
Originally published: 23/07/2021 09:51
Last version published: 28/07/2021 09:19
Publication number: ELQ-89433-2
View all versions & Certificate
certified

Shipping Port Financial Model

Shipping Port Financial Model for evaluating New Terminal, created using emodelfactory.com

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.

This Best Practice includes
1 Excel File

Acquire business license for $99.00

Add to cart

Add to bookmarks

Discuss

Further information

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


4.0 / 5 (1 votes)

please wait...