Ship Finance Models
Ship Finance and Investment analysis with financial modelling help shipping investors and lenders to get a better understanding of a shipping investment.
Excel with Pacoship 2.0 makes it easier to communucate and document shipping investment projects with cash flows, key figures, sensitivity analysis and charts. From the reports menu in Pacoship you can select the content of the reports you want to generate. You can generate reports as PDF files or Powerpoint presentations. All inputs are saved as XML data files that can be easily shared.
You get better reports, and you save time
From the reports menu in Pacoship you can select the content of the reports you want to generate:
If you have Addobe DC installed, you can export the Pacoship PDF file to a Word document and add text and other items you choose to tailormake your report.
Pacoship can also generate a Powerpoint presentation. It will have the Pacoship charts you want to include in you presentation. You may edit and add your own text and additional slides.
Pacoship 2.0 connects with Outlook so that you can e-mail your PDF report or XML data.
- To run Pacoship, you need to run Excel on a computer with a Windows operating system. To make use of exporting charts generated by Pacoship directly to Powerpoint you must have Powerpoint installed. To send e-mails directly from Pacoship you need to have Outlook installed.
- Select Project Type (Newbuilding or Secondhand Purchase) and update input data for SHIP, EMPLOYMENT, OPEX and FINANCING. Pacoship calculates Project Cash Flow, Cash Flow to Equity and performs sensitivity analysis.
- You can easily select create the reports from a menu. The reports include a project summary and ship investment analysis together with cash flows, charts and sensitivity analysis. The output can be printed on paper or saved as PDF files
- The application generates a Powerpoint presentation with selected charts.
- Pacoship users can share input data by sending XML data files.
The Pacoship application for ship finance and investment modeling has a built-in help menu accessible from the customs Excel ribbon.
On the Pacoship tab on the customs ribbon, you will also find useful links to online help and support.
Pacoship 2.0 is the latest version available. We continue to add new features based on feedback from active users.
Subscribe to our mailing list to get updates when upgrade versions are made available:
A good ship ﬁnance model has the following characteristics:
- Key input parameters are clearly identiﬁed;
- The model uses formulas to adjust automatically for changes in input parameters;
- Has a user-friendly, interactive interface and clearly separates input (assumptions) and output (calculated results);
- The model is dynamic, robust, and covers all periods
- Easily produces all the important ﬁnancial output metrics including NPV and internal rate of return (IRR).
Some financial modelling assumptions are factual input at the time of making the investment decision. Examples are ship prices, charter rates, and available terms and conditions of debt ﬁnancing. Other factors, like the future residual value, are not known. To and get a better understanding of the dynamics of future outcomes we use sensitivity.
Sensitivity analysis shows how the return on the shipping investment varies in response to changes in assumptions. We analyze the effect of changes in ship operating costs, time charter earnings, ship values, and financing costs. When preparing a shipping investment analysis we also take into account expected future demand and supply, as well as historical data.
Microsoft Excel® is most widely used for ﬁnancial modeling. You may employ Excel to build your own ship finance models from scratch. Shipping investment analysts will save time and effort and get a better error free model with the Excel-based ship investment application Pacoship.
Bespoke Financial Models
I offer a vide range of financial modelling services and am happy to create custom models as required. Contact me to to discuss your needs.
Shipping Finance Glossary:
We have now added a Marine Finance Glossary with explanations of shipping finance and ship investment terms to this website. It also has explanations of ship lease structures and terms.
Our Marine Finance Glossary is work in progress. We are inviting industry practitioners to contribute to making the glossary helpful and comprehensive. Please send an e-mail to [email protected] to propose a new entry or suggest improvements to existing glossary wordings.
contains the full range of information collected by Clarksons Research. SIN provides up to date market reports and a database with time-series for all major shipping sectors and ship types.
is an independent maritime research consultancy offering market insights and advisory services.
Current, historical, and forecast values for every vessel in the fleet, updated every day. Company fleets, portfolios, market statistics, and indices.
is a statistical and analytics tool on shipping operating costs and revenues. Moore Stephens provides online data as a benchmarking tool for all major vessels’ operating costs.