Shipping Vessel Leasing (Charter) Company Financial Model

Description
Financial Model for a Shipping Charter CompanyThis financial model outlines the structure for a Shipping Charter Company engaged in:

• BIMCO Contracting (time charters, voyage charters)
  
• Standard Leasing (bareboat charters, long-term leases)
  
• Vessel Sales (buying/selling ships)
  
• Management Services (crew, technical, commercial management)
  

The model includes:

1. Income Statement (Revenue, Costs, Profitability)
   
2. Cash Flow Statement (Operating, Investing, Financing)
   
3. Balance Sheet (Assets, Liabilities, Equity)
   

20x Income Statements, Cash Flow Statements, Balance Sheets, CAPEX Sheets, OPEX Sheets, Statement Summary Sheets, and Revenue Forecasting Charts with the specified revenue streams, BEA charts, sales summary charts, employee salary tabs and expenses sheets. 
Over 100 spreadsheets covering BIMCO Contracting, Standard Leasing, Vessel Sales, management revenue, and product sales.


Income StatementRevenue Streams

1. Chartering Revenue
   
   • Time Charter (BIMCO Contracts) → Fixed daily rate × operating days
     
   • Voyage Charter → Freight rate per ton × cargo volume
     
   • Bareboat Charter → Monthly lease payments
     
2. Vessel Sales Revenue
   
   • Profit/loss from vessel acquisitions & disposals
     
3. Management Services Revenue
   
   • Fixed management fees (e.g., $X per vessel per day)
     
   • Additional fees for crew, maintenance, insurance
     

Operating Costs

1. Vessel Operating Expenses (OPEX)
   
   • Crew wages, insurance, maintenance, lubricants, stores
     
2. Voyage Expenses
   
   • Bunker (fuel) costs, port fees, canal dues
     
3. Charter Hire Expenses (if leasing-in vessels)
   
4. Management Services Costs
   
   • Salaries for management team, IT systems, overhead
     
5. Depreciation & Amortization
   
   • Straight-line depreciation on owned vessels
     
6. Other Costs
   
   • Broker commissions, legal fees, BIMCO compliance
     

EBITDA & Net Profit

• EBITDA = Revenue – OPEX – Voyage Costs
  
• EBIT = EBITDA – Depreciation
  
• Net Profit = EBIT – Interest – Taxes
  

Cash Flow StatementOperating Cash Flow (OCF)

• Cash from charter hires, management fees
  
• Payments for OPEX, voyage costs, commissions
  

Investing Cash Flow (ICF)

• Vessel Purchases (capital expenditures)
  
• Vessel Sales (proceeds from disposals)
  
• Dry-docking & CAPEX (major repairs/upgrades)
  

Financing Cash Flow (FCF)

• Debt Financing (loan drawdowns, repayments)
  
• Equity Financing (shareholder injections/dividends)
  
• Lease Liabilities (if applicable)
  

Net Cash Flow

• Closing Cash = Opening Cash + OCF + ICF + FCF
  

Balance SheetAssets

1. Current Assets
   
   • Cash & cash equivalents
     
   • Accounts receivable (unpaid hire, freight)
     
   • Prepaid expenses (bunkers, insurance)
     
2. Non-Current Assets
   
   • Vessel Fleet (Owned) – Net book value (cost – accumulated depreciation)
     
   • Vessel Fleet (Leased-in) – Right-of-use assets (IFRS 16)
     
   • Other fixed assets (office equipment, software)
     

Liabilities

1. Current Liabilities
   
   • Accounts payable (bunker suppliers, shipyards)
     
   • Short-term debt (loan repayments due