Premier Airport Transportation Service airport taxi business plan appendix. Premier Airport Transporation is an upscale livery service between businesses, residences and airport.

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
Premier Airport Transportation Service airport taxi business plan appendix. Premier Airport Transporation is an upscale livery service between businesses, residences and airport.