Premier Airport Transportation Service

Start your own business plan »

Airport Taxi 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
Individuals/families 0% $0 $1,578 $1,874 $3,958 $6,645 $7,345 $8,287 $9,258 $9,985 $12,455 $14,822 $17,854
Business travelers 0% $0 $1,114 $1,358 $3,225 $4,754 $5,514 $6,958 $8,125 $9,125 $10,458 $11,587 $12,545
Total Sales $0 $2,692 $3,232 $7,183 $11,399 $12,859 $15,245 $17,383 $19,110 $22,913 $26,409 $30,399
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
Individuals/families $0 $316 $375 $792 $1,329 $1,469 $1,657 $1,852 $1,997 $2,491 $2,964 $3,571
Business travelers $0 $223 $272 $645 $951 $1,103 $1,392 $1,625 $1,825 $2,092 $2,317 $2,509
Subtotal Direct Cost of Sales $0 $538 $646 $1,437 $2,280 $2,572 $3,049 $3,477 $3,822 $4,583 $5,282 $6,080
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
Sam 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
Part-time employee 0% $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Driver 0% $0 $2,200 $2,200 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800
Driver 0% $0 $2,200 $2,200 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800
Driver 0% $0 $0 $0 $0 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800
Driver 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,800 $1,800
Total People 1 4 4 4 5 5 5 5 5 5 6 6
Total Payroll $3,000 $8,900 $8,900 $8,100 $9,900 $9,900 $9,900 $9,900 $9,900 $9,900 $11,700 $11,700
General Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
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% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
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 $2,692 $3,232 $7,183 $11,399 $12,859 $15,245 $17,383 $19,110 $22,913 $26,409 $30,399
Direct Cost of Sales $0 $538 $646 $1,437 $2,280 $2,572 $3,049 $3,477 $3,822 $4,583 $5,282 $6,080
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $538 $646 $1,437 $2,280 $2,572 $3,049 $3,477 $3,822 $4,583 $5,282 $6,080
Gross Margin $0 $2,154 $2,586 $5,746 $9,119 $10,287 $12,196 $13,906 $15,288 $18,330 $21,127 $24,319
Gross Margin % 0.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00%
Expenses
Payroll $3,000 $8,900 $8,900 $8,100 $9,900 $9,900 $9,900 $9,900 $9,900 $9,900 $11,700 $11,700
Sales and Marketing and Other Expenses $150 $175 $200 $225 $250 $300 $300 $300 $300 $300 $300 $300
Depreciation $42 $42 $42 $42 $42 $42 $42 $42 $42 $42 $42 $42
Web site maintenance $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Utilities $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Insurance $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450
Rent $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Payroll Taxes 15% $450 $1,335 $1,335 $1,215 $1,485 $1,485 $1,485 $1,485 $1,485 $1,485 $1,755 $1,755
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $4,742 $11,552 $11,577 $10,682 $12,777 $12,827 $12,827 $12,827 $12,827 $12,827 $14,897 $14,897
Profit Before Interest and Taxes ($4,742) ($9,398) ($8,991) ($4,936) ($3,658) ($2,540) ($631) $1,079 $2,461 $5,503 $6,230 $9,422
EBITDA ($4,700) ($9,356) ($8,949) ($4,894) ($3,616) ($2,498) ($589) $1,121 $2,503 $5,545 $6,272 $9,464
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 ($4,742) ($9,398) ($8,991) ($4,936) ($3,658) ($2,540) ($631) $1,079 $2,461 $5,503 $6,230 $9,422
Net Profit/Sales 0.00% -349.12% -278.20% -68.71% -32.09% -19.75% -4.14% 6.21% 12.88% 24.02% 23.59% 31.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 $2,692 $3,232 $7,183 $11,399 $12,859 $15,245 $17,383 $19,110 $22,913 $26,409 $30,399
Subtotal Cash from Operations $0 $2,692 $3,232 $7,183 $11,399 $12,859 $15,245 $17,383 $19,110 $22,913 $26,409 $30,399
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $0 $2,692 $3,232 $7,183 $11,399 $12,859 $15,245 $17,383 $19,110 $22,913 $26,409 $30,399
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 $3,000 $8,900 $8,900 $8,100 $9,900 $9,900 $9,900 $9,900 $9,900 $9,900 $11,700 $11,700
Bill Payments $57 $1,748 $3,153 $3,305 $4,015 $5,126 $5,473 $5,948 $6,373 $6,732 $7,500 $8,463
Subtotal Spent on Operations $3,057 $10,648 $12,053 $11,405 $13,915 $15,026 $15,373 $15,848 $16,273 $16,632 $19,200 $20,163
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 $3,057 $10,648 $12,053 $11,405 $13,915 $15,026 $15,373 $15,848 $16,273 $16,632 $19,200 $20,163
Net Cash Flow ($3,057) ($7,956) ($8,821) ($4,222) ($2,516) ($2,167) ($128) $1,535 $2,837 $6,281 $7,209 $10,236
Cash Balance $27,918 $19,962 $11,141 $6,920 $4,404 $2,237 $2,109 $3,644 $6,481 $12,761 $19,971 $30,206
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 $30,975 $27,918 $19,962 $11,141 $6,920 $4,404 $2,237 $2,109 $3,644 $6,481 $12,761 $19,971 $30,206
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $30,975 $27,918 $19,962 $11,141 $6,920 $4,404 $2,237 $2,109 $3,644 $6,481 $12,761 $19,971 $30,206
Long-term Assets
Long-term Assets $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Accumulated Depreciation $0 $42 $84 $126 $168 $210 $252 $294 $336 $378 $420 $462 $504
Total Long-term Assets $1,500 $1,458 $1,416 $1,374 $1,332 $1,290 $1,248 $1,206 $1,164 $1,122 $1,080 $1,038 $996
Total Assets $32,475 $29,376 $21,378 $12,515 $8,252 $5,694 $3,485 $3,315 $4,808 $7,603 $13,841 $21,009 $31,202
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 $1,643 $3,043 $3,172 $3,844 $4,944 $5,275 $5,736 $6,150 $6,483 $7,219 $8,156 $8,927
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 $1,643 $3,043 $3,172 $3,844 $4,944 $5,275 $5,736 $6,150 $6,483 $7,219 $8,156 $8,927
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $1,643 $3,043 $3,172 $3,844 $4,944 $5,275 $5,736 $6,150 $6,483 $7,219 $8,156 $8,927
Paid-in Capital $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000
Retained Earnings ($2,525) ($2,525) ($2,525) ($2,525) ($2,525) ($2,525) ($2,525) ($2,525) ($2,525) ($2,525) ($2,525) ($2,525) ($2,525)
Earnings $0 ($4,742) ($14,140) ($23,132) ($28,067) ($31,725) ($34,265) ($34,896) ($33,817) ($31,356) ($25,852) ($19,622) ($10,200)
Total Capital $32,475 $27,733 $18,335 $9,343 $4,408 $750 ($1,790) ($2,421) ($1,342) $1,119 $6,623 $12,853 $22,275
Total Liabilities and Capital $32,475 $29,376 $21,378 $12,515 $8,252 $5,694 $3,485 $3,315 $4,808 $7,603 $13,841 $21,009 $31,202
Net Worth $32,475 $27,733 $18,335 $9,343 $4,408 $750 ($1,790) ($2,421) ($1,342) $1,119 $6,623 $12,853 $22,275