Air Cargo Hub Financial Model 20 Year 3 Statement Bundle

Airlines, Airports, Construction, Financial Model, Infrastructure, Transport

10-year Financial Projections, Business Plans, Cash Flow Analysis, Excel, Financial Analysis, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Financial Reporting, Financial Statements, Financing, Forecast, Forecasting, Income Statement, Project Management, Revenue Projections

Financial Model Bundle for an Air Cargo Hub

This Air Cargo Hub Financial Model Bundle contains 5 Excel Workbooks.

Financial revenues raised from the running of the Air Cargo Hub.

Plus 4 further financial models for the construction of the Cargo Terminal, Customs and Border Control Facility, A Storage Warehouse, and a Cold Store Warehouse.

The Air Cargo Hub Financial Model contains over 140 tabs and over 100 Spreadsheets. 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.

The 4 construction financial models contain a main overview financial worksheet, plus individual tabs for Civil Works, Building Construction, Electrical Works, Interior Installations, Landscaping, Plant and Tool Hire, and HR Costs.

Income Statement

A. Revenue Examples (All Editable)

• Cargo Handling Revenue: Tons (units) handled × handling fee
• Storage & Warehousing Revenue: M² rented × rent/m²
• Logistics Services Revenue: Value-added services (e.g., customs, packaging)
• Fueling/Refueling Services 
• Landing/Takeoff Fees (if integrated with airport ops)
• Other Income: office rentals, logistics rental fees, licensing fees

B. Cost of Goods Sold (COGS)

• Direct Labor: Ground staff, loaders
• Consumables: Packaging, fuel, security systems
• Equipment Maintenance & Leasing

C. Gross Profit

= Revenue – COGS

D. Operating Expenses (OPEX)

• Salaries & Wages (admin, management)
• Utilities (electricity, water, HVAC)
• Security, insurance, software systems
• Marketing & sales expenses
• General & administrative (G&A)

E. EBITDA

= Gross Profit – OPEX

F. Depreciation & Amortization

Non-cash charges for buildings, machinery, IT systems

G. EBIT (Operating Profit)

= EBITDA – Depreciation & Amortization

H. Interest Expense

Based on outstanding debt and interest rate

I. EBT (Earnings Before Tax)

= EBIT – Interest Expense

J. Income Tax

K. Net Income

= EBT – Income Tax

Cash Flow Statement

A. Operating Activities

• Net Income
• + Non-Cash Adjustments: Depreciation, amortization
• ± Working Capital Changes:
  • Increase in receivables (cash out)
  • Increase in payables (cash in)
  • Inventory changes
• = Net Cash from Operations

B. Investing Activities

• CapEx:
  • Land acquisition
  • Construction of terminals, warehouses
  • Equipment purchase
• Proceeds from Sale of Assets
• = Net Cash Used in Investing Activities

C. Financing Activities

• Equity Injections
• Debt Drawdowns
• Debt Repayments
• Dividends Paid
• = Net Cash from Financing Activities

D. Net Cash Flow

= A + B + C

E. Opening & Ending Cash Balance

Balance Sheet

A. Assets

Current Assets

• Cash and Cash Equivalents
• Accounts Receivable
• Inventory (from Automated Guided Vehicles to Cargo X-ray Scanners)
• Prepaid Expenses

Non-Current Assets

• Property, Plant & Equipment (PP&E):
  • Terminals
  • Warehouses
  • Airside infrastructure
  • Vehicles and equipment
• Intangible Assets (licenses, software, etc.)
• Accumulated Depreciation

B. Liabilities

Current Liabilities

• Accounts Payable
• Accrued Expenses
• Short-Term Loans or Current Portion of Long-Term Debt
• OPEX (Personnel Costs, Transportation and Logistics, Waste Management Costs, etc)

Non-Current Liabilities

• Long-Term Debt
• Deferred Tax Liabilities
• Lease Liabilities

C. Equity

• Paid-in Capital
• Retained Earnings
• Reserves (if applicable)

Assets = Liabilities + Equity

Additional Schedules (Supporting the Core Statements)

1. Revenue Forecast Schedule – cargo volume × fees per service
2. CapEx Schedule 
3. Depreciation Schedule 
4. Debt Amortization Schedule – principal, interest, repayments
5. Working Capital Schedule – receivables, payables, assumptions

MS Project.MPP File timeline scheduling template with over 212 timeline schedules

MS Excel version of the above.

29 MS Word Documents .docx covering the project management of the Air Cargo Terminal development, from Business Case files with reviews, to Quality Registers, Project Initiation Document, and Risk Management Strategies, A How-to .docx