Financial Model for Ports with Alternative Scenarios for Shipment Growth and Danger of Surplus Capacity
Originally published: 17/05/2018 13:36
Publication number: ELQ-45204-1
View all versions & Certificate
certified

Financial Model for Ports with Alternative Scenarios for Shipment Growth and Danger of Surplus Capacity

This is an incredibly detailed financial model for your port and shipping projects.

Description
This Excel financial model is a hugely extensive and detailed model for your port and shipping projects. This tool includes over 100 tabs that will help you to conduct a comprehensive analysis and thorough overview of the finances of your project.

These tabs cover a vast number of themes that will have an affect on your project:

- Assumptions
- Expenses
- Corporate Finance
- Project Finance
- Break Bulk
- Dry Bulk
- Liquid Bulk
- Container Information
- Capital Expenditure
- Debt scheduling
- Cash Flows
- Charts

These themes are broken down into numerous, incredibly detailed tabs. For instance, with "dry bulk" alone, you have: Volumes, Share, Market Share, Shares, Capacity and Demand, Capacity and Cap Demand. Thus, you will be able to conduct a really deep and wide ranging financial analysis of your projects.


Furthermore, all of your financial inputs are used to create three incredibly useful tabs. These are:

- Corporate Model Summary
- KPT Financial Ratio Summary
- Project Finance Summary

These summary tabs collate your input data and use it to create summary pages of your project. These summary tabs include numerous helpful graphs. For instance, the Corporate Model Summary tab includes graphs on "Debt and Cash Balance", "Net Cash Flow", "KPT Revenues" and "Nominal Capital Expenditures".

The KPT Financial Ratio Summary includes graphs that map the "Debt to EBITDA", "Debt to Capital Ratio", "Debt Service Coverage Ratio" as well as "Interest Coverage Ratio".

Finally, the Project Finance Summary shows the "Toll Revenues from KHC" as well as showing your Sources and Uses and Capital Expenditure.

This model will allow you the space to conduct a thorough analysis, whilst also providing helpful summary pages to help you quickly monitor the financial progress of your projects.

This Best Practice includes
1 Excel Spreadsheet

Acquire business license for $5.00

Add to cart

Add to bookmarks

Discuss


4.6 / 5 (32 votes)

please wait...