Valley Airporter

Start your own business plan »

Airport Shuttle Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Shuttle Tickets 0% $40,000 $40,000 $45,000 $45,000 $50,000 $50,000 $50,000 $40,000 $50,000 $40,000 $50,000 $50,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $40,000 $40,000 $45,000 $45,000 $50,000 $50,000 $50,000 $40,000 $50,000 $40,000 $50,000 $50,000
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Shuttle Tickets $0 $5,000 $6,000 $6,000 $7,000 $7,000 $7,000 $6,000 $6,000 $5,000 $6,000 $6,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $5,000 $6,000 $6,000 $7,000 $7,000 $7,000 $6,000 $6,000 $5,000 $6,000 $6,000
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Bob Wilson 0% $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Mary Wilson 0% $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Drivers 0% $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000
Office Staff/Sales 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Total People 9 9 9 9 9 9 9 9 9 9 9 9
Total Payroll $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000
General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Long-term Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $40,000 $40,000 $45,000 $45,000 $50,000 $50,000 $50,000 $40,000 $50,000 $40,000 $50,000 $50,000
Direct Cost of Sales $0 $5,000 $6,000 $6,000 $7,000 $7,000 $7,000 $6,000 $6,000 $5,000 $6,000 $6,000
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $5,000 $6,000 $6,000 $7,000 $7,000 $7,000 $6,000 $6,000 $5,000 $6,000 $6,000
Gross Margin $40,000 $35,000 $39,000 $39,000 $43,000 $43,000 $43,000 $34,000 $44,000 $35,000 $44,000 $44,000
Gross Margin % 100.00% 87.50% 86.67% 86.67% 86.00% 86.00% 86.00% 85.00% 88.00% 87.50% 88.00% 88.00%
Expenses
Payroll $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000
Sales and Marketing and Other Expenses $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Depreciation $1,547 $1,547 $1,547 $1,547 $1,547 $1,547 $1,547 $1,547 $1,547 $1,547 $1,547 $1,547
Leased Equipment $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 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Rent $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Payroll Taxes 15% $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $36,147 $36,147 $36,147 $36,147 $36,147 $36,147 $36,147 $36,147 $36,147 $36,147 $36,147 $36,147
Profit Before Interest and Taxes $3,853 ($1,147) $2,853 $2,853 $6,853 $6,853 $6,853 ($2,147) $7,853 ($1,147) $7,853 $7,853
EBITDA $5,400 $400 $4,400 $4,400 $8,400 $8,400 $8,400 ($600) $9,400 $400 $9,400 $9,400
Interest Expense $655 $643 $632 $620 $608 $597 $585 $573 $562 $550 $538 $527
Taxes Incurred $959 ($537) $666 $670 $1,873 $1,877 $1,880 ($816) $2,187 ($509) $2,194 $2,198
Net Profit $2,239 ($1,253) $1,555 $1,563 $4,371 $4,379 $4,388 ($1,904) $5,104 ($1,188) $5,120 $5,128
Net Profit/Sales 5.60% -3.13% 3.46% 3.47% 8.74% 8.76% 8.78% -4.76% 10.21% -2.97% 10.24% 10.26%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $40,000 $40,000 $45,000 $45,000 $50,000 $50,000 $50,000 $40,000 $50,000 $40,000 $50,000 $50,000
Subtotal Cash from Operations $40,000 $40,000 $45,000 $45,000 $50,000 $50,000 $50,000 $40,000 $50,000 $40,000 $50,000 $50,000
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) $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $42,000 $42,000 $47,000 $47,000 $52,000 $52,000 $52,000 $42,000 $52,000 $42,000 $52,000 $52,000
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000
Bill Payments $16,407 $12,331 $15,779 $17,898 $17,963 $20,081 $20,073 $19,942 $16,457 $19,225 $15,764 $19,332
Subtotal Spent on Operations $40,407 $36,331 $39,779 $41,898 $41,963 $44,081 $44,073 $43,942 $40,457 $43,225 $39,764 $43,332
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 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400
Purchase Other Current Assets $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Purchase Long-term Assets $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $45,807 $41,731 $45,179 $47,298 $47,363 $49,481 $49,473 $49,342 $45,857 $48,625 $45,164 $48,732
Net Cash Flow ($3,807) $269 $1,821 ($298) $4,637 $2,519 $2,527 ($7,342) $6,143 ($6,625) $6,836 $3,268
Cash Balance $46,193 $46,462 $48,283 $47,985 $52,622 $55,141 $57,667 $50,325 $56,468 $49,843 $56,679 $59,947
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $50,000 $46,193 $46,462 $48,283 $47,985 $52,622 $55,141 $57,667 $50,325 $56,468 $49,843 $56,679 $59,947
Other Current Assets $0 $2,000 $4,000 $6,000 $8,000 $10,000 $12,000 $14,000 $16,000 $18,000 $20,000 $22,000 $24,000
Total Current Assets $50,000 $48,193 $50,462 $54,283 $55,985 $62,622 $67,141 $71,667 $66,325 $74,468 $69,843 $78,679 $83,947
Long-term Assets
Long-term Assets $130,000 $132,000 $134,000 $136,000 $138,000 $140,000 $142,000 $144,000 $146,000 $148,000 $150,000 $152,000 $154,000
Accumulated Depreciation $24,000 $25,547 $27,094 $28,641 $30,188 $31,735 $33,282 $34,829 $36,376 $37,923 $39,470 $41,017 $42,564
Total Long-term Assets $106,000 $106,453 $106,906 $107,359 $107,812 $108,265 $108,718 $109,171 $109,624 $110,077 $110,530 $110,983 $111,436
Total Assets $156,000 $154,646 $157,368 $161,642 $163,797 $170,887 $175,859 $180,838 $175,949 $184,545 $180,373 $189,662 $195,383
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $16,000 $11,807 $15,183 $17,301 $17,294 $19,412 $19,404 $19,397 $15,812 $18,704 $15,120 $18,688 $18,680
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $2,000 $4,000 $6,000 $8,000 $10,000 $12,000 $14,000 $16,000 $18,000 $20,000 $22,000 $24,000
Subtotal Current Liabilities $16,000 $13,807 $19,183 $23,301 $25,294 $29,412 $31,404 $33,397 $31,812 $36,704 $35,120 $40,688 $42,680
Long-term Liabilities $80,000 $78,600 $77,200 $75,800 $74,400 $73,000 $71,600 $70,200 $68,800 $67,400 $66,000 $64,600 $63,200
Total Liabilities $96,000 $92,407 $96,383 $99,101 $99,694 $102,412 $103,004 $103,597 $100,612 $104,104 $101,120 $105,288 $105,880
Paid-in Capital $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Retained Earnings $45,500 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000
Earnings $14,500 $2,239 $985 $2,540 $4,103 $8,475 $12,854 $17,242 $15,337 $20,441 $19,253 $24,374 $29,502
Total Capital $60,000 $62,239 $60,985 $62,540 $64,103 $68,475 $72,854 $77,242 $75,337 $80,441 $79,254 $84,374 $89,502
Total Liabilities and Capital $156,000 $154,646 $157,368 $161,642 $163,797 $170,887 $175,859 $180,838 $175,949 $184,545 $180,373 $189,662 $195,383
Net Worth $60,000 $62,239 $60,985 $62,540 $64,103 $68,475 $72,854 $77,242 $75,337 $80,441 $79,254 $84,374 $89,502