Premier Airport Transportation Service
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 |
By 
