Shipping Vessel Leasing (Charter) Company Financial Model

Financial Model, Infrastructure, Ports, Shipping, Transport

10-year Financial Projections, Business Valuation, Cap Rate (Capitalization Rate), Cash Flow Projections, CFO, DCF Model, Excel, Financial Analysis, Financial Feasibility, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Financial Ratios, Financial Reporting, Financial Statements, Financing, Forecast, Forecasting, Income Statement, Inventory, Investing Cash Flows, IRR (Internal Rate of Return), KPIs (Key Performance Indicators), Revenue Projections, Startup Financial Models, Terminal Value, Three Statement Model | Three Financial Statements, Uses and Sources of Funds, Valuation, VC Valuation, WACC (Weighted Average Cost of Capital)

Shipping Vessel Leasing Company Financial Model for 6 vessels (This is editable, email me) with the goal of leasing them out to generate revenue.
As you’ll see from the photo’s, the model is currently set up for Cargo Vessels, these parameters are easily changed within the “Vessel Log” where you can enter your vessel types and leasing costs.
The model computes the pertinent metrics (Net Present Value, Internal Rate of Return, debt payback duration, cash on cash multiple, enterprise value, etc.) and produces the three financial statements and cash flows. A typical long-term loan, an overdraft facility, and, of course, investor equity capital are among the project’s financing choices.

INPUTS

Vessel Types: TEU and boat class, leasing costs per day.

Charter fees: The primary source of income for a shipping vessel charter business is the fees charged for renting out vessels for a specific period of time.

Fuel surcharges: Some shipping vessel charter businesses may charge additional fees to cover the cost of fuel for the vessel during the charter period.

Equipment rental fees: Additional income can be generated by renting out equipment such as cranes, containers, or other specialized cargo handling equipment.

Crewing services: Some shipping vessel charter businesses may provide crewing services, including the provision of trained personnel such as captains, engineers, or deckhands for the vessel.

Insurance premiums: Insurance premiums paid by clients for coverage during the charter period can also contribute to the business’s income.

Port fees: Some shipping vessel charter businesses may charge additional fees to cover the costs of using specific ports or harbors during the charter period.

Maintenance and repair services: Income can also be generated through providing maintenance and repair services for vessels, either as a part of the charter agreement or as a separate service.

Commission fees: Some shipping vessel charter businesses may earn income through brokerage fees or commissions for arranging charter agreements between clients and vessel owners.

Selling and general expense

Fuel costs

Crew salaries

Maintenance and repair expenses

Insurance premiums

Port fees and dockage charges

Administration and office expenses

Communication and navigation equipment costs

Provisioning and supplies for the vessel

Safety and training expenses for crew members

Legal and regulatory compliance cost

Depreciation of assets

Marketing and advertising expenses

Contingency and emergency funds

Miscellaneous expenses.

Capital Expenditures

Shipping vessels (cargo ships, container ships, oil tankers, etc.)

Docking equipment and infrastructure (docks, piers, ramps)

Cranes for loading and unloading cargo

GPS and navigation systems

Communication equipment (radios, satellite phones)

Safety equipment (life jackets, lifeboats, fire extinguishers)

Refrigeration units for perishable goods

Fuel tanks and pumps

Maintenance tools and equipment

Computer systems for tracking schedules and cargo inventory.

INVESTMENT PERFORMANCE

EBITDA
(+) Depreciation
EBITA
Income Tax
Unlevered net income
(+) Depreciation
(-) CapEx
(+) WC
Unlevered free cash flow
Discount Factor

Project Performance w/o Terminal Value

DCFF
NPV
IRR

Project Performance with Terminal Value – Perpetuity Method

Terminal Cash Flow
Total Free Cash Flow To Firm
DCFF
NPV
IRR

Project Performance with Terminal Value – EBITDA Multiples Method

Terminal Cash Flow
Total Free Cash Flow To Firm
DCFF
NPV
IRR

This financial model is adaptable, and its metrics should align with your Shipping Vessel company’s strategic goals, whether focused on scaling the user base, maximizing profitability, or securing investment.

You must log in to submit a review.