San Francisco Limo limousine taxi business plan appendix. San Francisco Limo, an existing limousine service expands target markets

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)

Get the Bplans newsletter:

Expert business tips and advice delivered weekly.

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
San Francisco Limo limousine taxi business plan appendix. San Francisco Limo, an existing limousine service expands target markets
\n