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 |