City Taxi

Start your own business plan »

Taxi Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
All services 0% $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
All services $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Taxi Cabs & Administrative 0% $9,058 $9,058 $9,058 $9,058 $9,058 $9,058 $9,058 $9,058 $9,058 $9,058 $9,058 $9,058
Maintenance & Repair 0% $9,057 $9,058 $9,058 $9,058 $9,058 $9,058 $9,058 $9,058 $9,058 $9,058 $9,058 $9,058
Total People 8 8 8 8 8 8 8 8 8 8 8 8
Total Payroll $18,115 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116
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 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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667
Direct Cost of Sales $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417 $5,417
Other $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417
Total Cost of Sales $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833
Gross Margin $10,833 $10,833 $10,833 $10,833 $10,833 $10,833 $10,833 $10,833 $10,833 $10,833 $10,833 $10,833
Gross Margin % 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00%
Expenses
Payroll $18,115 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116
Sales and Marketing and Other Expenses $5,333 $5,333 $5,333 $5,333 $5,333 $5,333 $5,333 $5,333 $5,333 $5,333 $5,333 $5,333
Depreciation $625 $625 $625 $1,458 $1,458 $1,458 $1,458 $1,458 $1,458 $1,458 $1,458 $1,458
Research & Development $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250
Utilities $167 $167 $167 $167 $167 $167 $167 $167 $167 $167 $167 $167
Insurance $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417
Payroll Taxes 15% $2,717 $2,717 $2,717 $2,717 $2,717 $2,717 $2,717 $2,717 $2,717 $2,717 $2,717 $2,717
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $28,624 $28,625 $28,625 $29,458 $29,458 $29,458 $29,458 $29,458 $29,458 $29,458 $29,458 $29,458
Profit Before Interest and Taxes ($17,791) ($17,792) ($17,792) ($18,625) ($18,625) ($18,625) ($18,625) ($18,625) ($18,625) ($18,625) ($18,625) ($18,625)
EBITDA ($17,166) ($17,167) ($17,167) ($17,167) ($17,167) ($17,167) ($17,167) ($17,167) ($17,167) ($17,167) ($17,167) ($17,167)
Interest Expense $290 $288 $285 $283 $281 $279 $277 $275 $273 $271 $269 $267
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($18,080) ($18,079) ($18,077) ($18,908) ($18,906) ($18,904) ($18,902) ($18,900) ($18,898) ($18,896) ($18,893) ($18,891)
Net Profit/Sales -108.48% -108.48% -108.46% -113.45% -113.44% -113.42% -113.41% -113.40% -113.39% -113.37% -113.36% -113.35%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667
Subtotal Cash from Operations $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667
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 $2,500,000 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $16,667 $16,667 $2,516,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667 $16,667
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $18,115 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116 $18,116
Bill Payments $24,134 $16,007 $16,005 $16,003 $16,001 $15,999 $15,996 $15,994 $15,992 $15,990 $15,988 $15,986
Subtotal Spent on Operations $42,249 $34,123 $34,121 $34,119 $34,117 $34,115 $34,112 $34,110 $34,108 $34,106 $34,104 $34,102
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 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
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 $500,000 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $1,700,000 $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 $42,499 $34,373 $2,234,371 $34,369 $34,367 $34,365 $34,362 $34,360 $34,358 $34,356 $34,354 $34,352
Net Cash Flow ($25,832) ($17,706) $282,296 ($17,702) ($17,700) ($17,698) ($17,696) ($17,694) ($17,692) ($17,690) ($17,687) ($17,685)
Cash Balance $19,168 $1,462 $283,758 $266,056 $248,356 $230,658 $212,962 $195,268 $177,577 $159,887 $142,200 $124,514
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $45,000 $19,168 $1,462 $283,758 $266,056 $248,356 $230,658 $212,962 $195,268 $177,577 $159,887 $142,200 $124,514
Other Current Assets $13,400 $13,400 $13,400 $513,400 $513,400 $513,400 $513,400 $513,400 $513,400 $513,400 $513,400 $513,400 $513,400
Total Current Assets $58,400 $32,568 $14,862 $797,158 $779,456 $761,756 $744,058 $726,362 $708,668 $690,977 $673,287 $655,600 $637,914
Long-term Assets
Long-term Assets $75,000 $75,000 $75,000 $1,775,000 $1,775,000 $1,775,000 $1,775,000 $1,775,000 $1,775,000 $1,775,000 $1,775,000 $1,775,000 $1,775,000
Accumulated Depreciation $10,000 $10,625 $11,250 $11,875 $13,333 $14,791 $16,249 $17,707 $19,165 $20,623 $22,081 $23,539 $24,997
Total Long-term Assets $65,000 $64,375 $63,750 $1,763,125 $1,761,667 $1,760,209 $1,758,751 $1,757,293 $1,755,835 $1,754,377 $1,752,919 $1,751,461 $1,750,003
Total Assets $123,400 $96,943 $78,612 $2,560,283 $2,541,123 $2,521,965 $2,502,809 $2,483,655 $2,464,503 $2,445,354 $2,426,206 $2,407,061 $2,387,917
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $23,600 $15,473 $15,471 $15,469 $15,467 $15,465 $15,463 $15,461 $15,459 $15,457 $15,455 $15,453 $15,451
Current Borrowing $10,000 $9,750 $9,500 $9,250 $9,000 $8,750 $8,500 $8,250 $8,000 $7,750 $7,500 $7,250 $7,000
Other Current Liabilities $25,400 $25,400 $25,400 $25,400 $25,400 $25,400 $25,400 $25,400 $25,400 $25,400 $25,400 $25,400 $25,400
Subtotal Current Liabilities $59,000 $50,623 $50,371 $50,119 $49,867 $49,615 $49,363 $49,111 $48,859 $48,607 $48,355 $48,103 $47,851
Long-term Liabilities $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
Total Liabilities $84,000 $75,623 $75,371 $75,119 $74,867 $74,615 $74,363 $74,111 $73,859 $73,607 $73,355 $73,103 $72,851
Paid-in Capital $37,000 $37,000 $37,000 $2,537,000 $2,537,000 $2,537,000 $2,537,000 $2,537,000 $2,537,000 $2,537,000 $2,537,000 $2,537,000 $2,537,000
Retained Earnings $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400
Earnings $0 ($18,080) ($36,159) ($54,237) ($73,145) ($92,051) ($110,954) ($129,856) ($148,756) ($167,654) ($186,549) ($205,443) ($224,334)
Total Capital $39,400 $21,320 $3,241 $2,485,163 $2,466,255 $2,447,349 $2,428,446 $2,409,544 $2,390,644 $2,371,746 $2,352,851 $2,333,957 $2,315,066
Total Liabilities and Capital $123,400 $96,943 $78,612 $2,560,283 $2,541,123 $2,521,965 $2,502,809 $2,483,655 $2,464,503 $2,445,354 $2,426,206 $2,407,061 $2,387,917
Net Worth $39,400 $21,320 $3,241 $2,485,163 $2,466,255 $2,447,349 $2,428,446 $2,409,544 $2,390,644 $2,371,746 $2,352,851 $2,333,957 $2,315,066