Puddle Jumpers Airline

Start your own business plan »

Regional Airline Business Plan

Appendix

Sales Forecast
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales
Sales 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Chief Executive Officer 0% $8 $8 $8 $8 $8 $8 $8 $8 $8 $8 $8 $8
Executive Vice President 0% $0 $0 $0 $0 $0 $0 $7 $7 $7 $7 $7 $7
V.P. Operations 0% $0 $0 $0 $0 $0 $0 $6 $6 $6 $6 $6 $6
V.P. Maintenance 0% $0 $0 $0 $0 $0 $0 $6 $6 $6 $6 $6 $6
V.P. Finance 0% $0 $0 $0 $0 $0 $0 $0 $6 $6 $6 $6 $6
Director of Operations 0% $0 $0 $0 $0 $0 $0 $0 $0 $5 $5 $5 $5
Director of Maintenance 0% $0 $0 $0 $0 $0 $0 $0 $0 $5 $5 $5 $5
Chief Pilot 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $6 $6 $6
Director of Sales/Marketing 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5 $5
Director of Quality Assurance 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $4
Director of Reservations 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $4
Director of In-flight Services 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $4
Flight Crews 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Reservations 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Maintenance 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Operations/Training/G&A 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales/Marketing 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Finance/Accounting 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $8 $8 $8 $8 $8 $8 $27 $33 $43 $49 $66 $66
Pro Forma Profit and Loss
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Margin $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Margin % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Expenses
Payroll $8 $8 $8 $8 $8 $8 $27 $33 $43 $49 $66 $66
Marketing/Promotion $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $8 $8 $8 $8 $8 $8 $27 $33 $43 $49 $66 $66
Profit Before Interest and Taxes ($8) ($8) ($8) ($8) ($8) ($8) ($27) ($33) ($43) ($49) ($66) ($66)
EBITDA ($8) ($8) ($8) ($8) ($8) ($8) ($27) ($33) ($43) ($49) ($66) ($66)
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($8) ($8) ($8) ($8) ($8) ($8) ($27) ($33) ($43) ($49) ($66) ($66)
Net Profit/Sales 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash from Operations $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $250 $100 $500 $1,000 $2,000 $0 $0 $0 $10,000 $0 $0 $0
Subtotal Cash Received $250 $100 $500 $1,000 $2,000 $0 $0 $0 $10,000 $0 $0 $0
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending $8 $8 $8 $8 $8 $8 $27 $33 $43 $49 $66 $66
Bill Payments $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Spent on Operations $8 $8 $8 $8 $8 $8 $27 $33 $43 $49 $66 $66
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $8 $8 $8 $8 $8 $8 $27 $33 $43 $49 $66 $66
Net Cash Flow $242 $92 $492 $992 $1,992 ($8) ($27) ($33) $9,957 ($49) ($66) ($66)
Cash Balance $282 $374 $866 $1,858 $3,850 $3,842 $3,815 $3,782 $13,739 $13,690 $13,624 $13,558
Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash $40 $282 $374 $866 $1,858 $3,850 $3,842 $3,815 $3,782 $13,739 $13,690 $13,624 $13,558
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $40 $282 $374 $866 $1,858 $3,850 $3,842 $3,815 $3,782 $13,739 $13,690 $13,624 $13,558
Long-term Assets
Long-term Assets $22 $22 $22 $22 $22 $22 $22 $22 $22 $22 $22 $22 $22
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $22 $22 $22 $22 $22 $22 $22 $22 $22 $22 $22 $22 $22
Total Assets $62 $304 $396 $888 $1,880 $3,872 $3,864 $3,837 $3,804 $13,761 $13,712 $13,646 $13,580
Liabilities and Capital Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Current Liabilities
Accounts Payable $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Paid-in Capital $350 $600 $700 $1,200 $2,200 $4,200 $4,200 $4,200 $4,200 $14,200 $14,200 $14,200 $14,200
Retained Earnings ($288) ($288) ($288) ($288) ($288) ($288) ($288) ($288) ($288) ($288) ($288) ($288) ($288)
Earnings $0 ($8) ($16) ($24) ($32) ($40) ($48) ($75) ($108) ($151) ($200) ($266) ($332)
Total Capital $62 $304 $396 $888 $1,880 $3,872 $3,864 $3,837 $3,804 $13,761 $13,712 $13,646 $13,580
Total Liabilities and Capital $62 $304 $396 $888 $1,880 $3,872 $3,864 $3,837 $3,804 $13,761 $13,712 $13,646 $13,580
Net Worth $62 $304 $396 $888 $1,880 $3,872 $3,864 $3,837 $3,804 $13,761 $13,712 $13,646 $13,580