San Francisco Limo

Start your own business plan »

Limousine Taxi Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
CATA 0% $5,475 $3,016 $2,434 $3,080 $3,080 $3,080 $3,080 $3,080 $3,080 $3,080 $3,080 $3,080
Corporate Clients 0% $899 $1,351 $947 $1,000 $1,000 $1,000 $1,000 $1,200 $1,200 $1,200 $1,200 $1,200
Transfers (Credit Cards) 0% $1,900 $2,400 $3,344 $3,807 $4,230 $5,076 $5,076 $5,499 $5,922 $5,922 $6,345 $6,345
Hourly Hire 0% $0 $0 $1,617 $0 $1,080 $1,440 $1,800 $2,160 $2,880 $3,240 $3,600 $2,880
Total Sales $8,274 $6,767 $8,342 $7,887 $9,390 $10,596 $10,956 $11,939 $13,082 $13,442 $14,225 $13,505
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
CATA $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Corporate Clients $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Transfers (Credit Cards) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Hourly Hire $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Tim Politano 0% $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $2,000
Peter Battinelli 0% $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $2,000
Brian 0% $900 $900 $900 $900 $900 $900 $900 $900 $1,440 $1,440 $1,440 $1,440
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 3 3 3 3 3 3 3 3 3 3 3 3
Total Payroll $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,840 $3,840 $3,840 $5,440
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 0.90% 0.90% 0.90% 0.90% 0.90% 0.90% 0.90% 0.90% 0.90% 0.90% 0.90% 0.90%
Tax Rate 30.00% 24.50% 24.50% 24.50% 24.50% 24.50% 24.50% 24.50% 24.50% 24.50% 24.50% 24.50%
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 $8,274 $6,767 $8,342 $7,887 $9,390 $10,596 $10,956 $11,939 $13,082 $13,442 $14,225 $13,505
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Margin $8,274 $6,767 $8,342 $7,887 $9,390 $10,596 $10,956 $11,939 $13,082 $13,442 $14,225 $13,505
Gross Margin % 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Expenses
Payroll $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,840 $3,840 $3,840 $5,440
Sales and Marketing and Other Expenses $4,036 $3,966 $4,057 $4,662 $11,610 $3,397 $3,038 $3,480 $3,169 $3,188 $3,618 $2,533
Depreciation $23 $24 $23 $23 $1,324 $1,324 $1,324 $1,324 $1,324 $1,324 $1,324 $1,324
Depreciation $55 $55 $55 $55 $55 $55 $55 $55 $55 $55 $55 $55
Utilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Garage Rental $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Accounting $170 $170 $170 $170 $170 $170 $170 $170 $170 $170 $170 $170
Payroll Taxes 13% $417 $417 $417 $417 $417 $417 $417 $417 $486 $486 $486 $688
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $8,701 $8,632 $8,722 $9,327 $17,576 $9,363 $9,004 $9,446 $9,744 $9,763 $10,193 $10,910
Profit Before Interest and Taxes ($427) ($1,865) ($380) ($1,440) ($8,186) $1,233 $1,952 $2,493 $3,338 $3,679 $4,032 $2,595
EBITDA ($404) ($1,841) ($357) ($1,417) ($6,862) $2,557 $3,276 $3,817 $4,662 $5,003 $5,356 $3,919
Interest Expense $120 $120 $120 $53 $261 $260 $259 $258 $257 $256 $255 $271
Taxes Incurred ($164) ($486) ($123) ($366) ($2,070) $238 $415 $547 $755 $839 $925 $569
Net Profit ($383) ($1,499) ($378) ($1,128) ($6,378) $734 $1,278 $1,687 $2,326 $2,584 $2,851 $1,755
Net Profit/Sales -4.63% -22.15% -4.53% -14.30% -67.92% 6.93% 11.66% 14.13% 17.78% 19.23% 20.05% 12.99%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $7,447 $6,090 $7,508 $7,098 $8,451 $9,536 $9,860 $10,745 $11,774 $12,098 $12,803 $12,155
Cash from Receivables $2,000 $2,028 $822 $682 $833 $794 $943 $1,061 $1,099 $1,198 $1,309 $1,347
Subtotal Cash from Operations $9,447 $8,118 $8,330 $7,780 $9,284 $10,330 $10,803 $11,806 $12,873 $13,296 $14,112 $13,501
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 $21,000 $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 $43,529 $0 $0 $0 $0 $0 $0 $20,570
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 $9,500 $0 $0 $0 $0 $0 $0 $2,500 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $9,447 $8,118 $8,330 $17,280 $73,813 $10,330 $10,803 $11,806 $12,873 $13,296 $16,612 $34,071
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,840 $3,840 $3,840 $5,440
Bill Payments $178 $5,321 $4,957 $5,407 $5,873 $10,947 $5,232 $5,073 $5,627 $5,595 $5,711 $6,169
Subtotal Spent on Operations $3,478 $8,621 $8,257 $8,707 $9,173 $14,247 $8,532 $8,373 $9,467 $9,435 $9,551 $11,609
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 $8,000 $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 $1,194 $1,194 $1,194 $1,194 $1,194 $1,194 $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 $54,410 $0 $0 $0 $0 $0 $0 $27,205
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $3,478 $8,621 $8,257 $16,707 $63,583 $15,441 $9,726 $9,567 $10,661 $10,629 $10,745 $38,814
Net Cash Flow $5,969 ($503) $73 $574 $10,229 ($5,111) $1,078 $2,239 $2,212 $2,666 $5,867 ($4,742)
Cash Balance $7,169 $6,666 $6,739 $7,312 $17,542 $12,431 $13,509 $15,747 $17,959 $20,625 $26,492 $21,750
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $1,200 $7,169 $6,666 $6,739 $7,312 $17,542 $12,431 $13,509 $15,747 $17,959 $20,625 $26,492 $21,750
Accounts Receivable $4,000 $2,827 $1,477 $1,488 $1,595 $1,701 $1,967 $2,120 $2,253 $2,462 $2,609 $2,722 $2,726
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $5,200 $9,996 $8,142 $8,227 $8,907 $19,243 $14,398 $15,629 $18,000 $20,421 $23,234 $29,214 $24,475
Long-term Assets
Long-term Assets $14,000 $14,000 $14,000 $14,000 $4,500 $58,910 $58,910 $58,910 $58,910 $58,910 $58,910 $56,410 $83,615
Accumulated Depreciation $0 $23 $47 $70 $93 $1,417 $2,741 $4,065 $5,389 $6,713 $8,037 $9,361 $10,685
Total Long-term Assets $14,000 $13,977 $13,953 $13,930 $4,407 $57,493 $56,169 $54,845 $53,521 $52,197 $50,873 $47,049 $72,930
Total Assets $19,200 $23,973 $22,095 $22,157 $13,314 $76,736 $70,567 $70,474 $71,521 $72,618 $74,107 $76,263 $97,405
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $0 $5,156 $4,777 $5,217 $5,502 $10,772 $5,063 $4,886 $5,440 $5,405 $5,504 $6,003 $4,820
Current Borrowing $12,000 $12,000 $12,000 $12,000 $4,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
Other Current Liabilities $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Subtotal Current Liabilities $15,500 $20,656 $20,277 $20,717 $13,002 $39,272 $33,563 $33,386 $33,940 $33,905 $34,004 $34,503 $33,320
Long-term Liabilities $26,500 $26,500 $26,500 $26,500 $26,500 $70,029 $68,835 $67,641 $66,447 $65,253 $64,059 $62,865 $83,435
Total Liabilities $42,000 $47,156 $46,777 $47,217 $39,502 $109,301 $102,398 $101,027 $100,387 $99,158 $98,063 $97,368 $116,755
Paid-in Capital $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Retained Earnings ($56,657) ($22,900) ($22,900) ($22,900) ($22,900) ($22,900) ($22,900) ($22,900) ($22,900) ($22,900) ($22,900) ($22,900) ($22,900)
Earnings $33,757 ($383) ($1,882) ($2,260) ($3,388) ($9,765) ($9,031) ($7,753) ($6,066) ($3,740) ($1,156) $1,696 $3,450
Total Capital ($22,800) ($23,183) ($24,682) ($25,060) ($26,188) ($32,565) ($31,831) ($30,553) ($28,866) ($26,540) ($23,956) ($21,104) ($19,350)
Total Liabilities and Capital $19,200 $23,973 $22,095 $22,157 $13,314 $76,736 $70,567 $70,474 $71,521 $72,618 $74,107 $76,263 $97,405
Net Worth ($22,800) ($23,183) ($24,682) ($25,060) ($26,188) ($32,565) ($31,831) ($30,553) ($28,866) ($26,540) ($23,956) ($21,104) ($19,350)