Shipping Vessel Leasing (Charter) Company Financial Model

Description
Shipping Vessel Leasing Company Financial Model for 6 vessels 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.