Markam Driving School

Start your own business plan »

Driving School Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Adult drivers 0% $14,000 $14,000 $14,000 $14,000 $14,000 $20,000 $20,000 $20,000 $24,000 $25,000 $21,000 $23,000
Beginner drivers 0% $18,000 $18,000 $18,000 $18,000 $18,000 $24,000 $24,000 $24,000 $28,000 $26,000 $33,000 $36,000
Drivers under court order 0% $11,500 $11,500 $11,500 $11,500 $11,500 $14,000 $14,000 $14,000 $17,000 $18,000 $18,888 $18,000
High schools 0% $20,850 $20,850 $20,850 $20,850 $20,850 $25,000 $25,000 $25,000 $41,700 $41,700 $31,000 $31,000
Commercial drivers 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $64,350 $64,350 $64,350 $64,350 $64,350 $83,000 $83,000 $83,000 $110,700 $110,700 $103,888 $108,000
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Adult drivers $5,600 $5,600 $5,600 $5,600 $5,600 $8,000 $8,000 $8,000 $9,600 $10,000 $8,400 $9,200
Beginner drivers $7,200 $7,200 $7,200 $7,200 $7,200 $9,600 $9,600 $9,600 $11,200 $10,400 $13,200 $14,400
Drivers under court order $4,600 $4,600 $4,600 $4,600 $4,600 $5,600 $5,600 $5,600 $6,800 $7,200 $7,555 $7,200
High schools $8,340 $8,340 $8,340 $8,340 $8,340 $10,000 $10,000 $10,000 $16,680 $16,680 $12,400 $12,400
Commercial drivers $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $25,740 $25,740 $25,740 $25,740 $25,740 $33,200 $33,200 $33,200 $44,280 $44,280 $41,555 $43,200
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
President and General Manager 0% $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Controller 0% $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Education Planner 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
Education Coordinator 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
Facilities Mangers 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Office Manager 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Marketing Executive (Contract work) 0% $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250
Educators 0% $7,500 $7,500 $7,500 $7,500 $7,500 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000
Total People 11 11 11 11 11 15 15 15 15 15 15 15
Total Payroll $24,750 $24,750 $24,750 $24,750 $24,750 $30,250 $30,250 $30,250 $30,250 $30,250 $30,250 $30,250
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% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.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 $64,350 $64,350 $64,350 $64,350 $64,350 $83,000 $83,000 $83,000 $110,700 $110,700 $103,888 $108,000
Direct Cost of Sales $25,740 $25,740 $25,740 $25,740 $25,740 $33,200 $33,200 $33,200 $44,280 $44,280 $41,555 $43,200
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $25,740 $25,740 $25,740 $25,740 $25,740 $33,200 $33,200 $33,200 $44,280 $44,280 $41,555 $43,200
Gross Margin $38,610 $38,610 $38,610 $38,610 $38,610 $49,800 $49,800 $49,800 $66,420 $66,420 $62,333 $64,800
Gross Margin % 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00%
Expenses
Payroll $24,750 $24,750 $24,750 $24,750 $24,750 $30,250 $30,250 $30,250 $30,250 $30,250 $30,250 $30,250
Sales and Marketing and Other Expenses $2,900 $2,900 $2,900 $2,900 $2,900 $4,500 $4,500 $4,500 $6,000 $6,000 $6,000 $6,000
Depreciation $200 $200 $200 $200 $200 $200 $200 $200 $400 $400 $400 $400
Leased Equipment $0 $0 $0 $0 $0 $2,000 $2,000 $2,000 $4,000 $4,000 $4,000 $4,000
Utilities $200 $200 $200 $200 $200 $400 $400 $400 $600 $600 $600 $600
Insurance $600 $600 $600 $600 $600 $1,200 $1,200 $1,200 $1,800 $1,800 $1,800 $1,800
Rent $2,000 $2,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $6,000 $6,000 $6,000 $6,000
Payroll Taxes 15% $3,713 $3,713 $3,713 $3,713 $3,713 $4,538 $4,538 $4,538 $4,538 $4,538 $4,538 $4,538
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $34,363 $34,363 $36,363 $36,363 $36,363 $47,088 $47,088 $47,088 $53,588 $53,588 $53,588 $53,588
Profit Before Interest and Taxes $4,248 $4,248 $2,248 $2,248 $2,248 $2,713 $2,713 $2,713 $12,833 $12,833 $8,745 $11,213
EBITDA $4,448 $4,448 $2,448 $2,448 $2,448 $2,913 $2,913 $2,913 $13,233 $13,233 $9,145 $11,613
Interest Expense $188 $183 $179 $175 $171 $167 $163 $158 $154 $150 $146 $142
Taxes Incurred $1,218 $1,219 $621 $622 $623 $764 $765 $766 $3,804 $3,805 $2,580 $3,321
Net Profit $2,842 $2,845 $1,448 $1,451 $1,454 $1,782 $1,785 $1,788 $8,875 $8,878 $6,020 $7,750
Net Profit/Sales 4.42% 4.42% 2.25% 2.25% 2.26% 2.15% 2.15% 2.15% 8.02% 8.02% 5.79% 7.18%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $64,350 $64,350 $64,350 $64,350 $64,350 $83,000 $83,000 $83,000 $110,700 $110,700 $103,888 $108,000
Subtotal Cash from Operations $64,350 $64,350 $64,350 $64,350 $64,350 $83,000 $83,000 $83,000 $110,700 $110,700 $103,888 $108,000
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 $64,350 $64,350 $64,350 $64,350 $64,350 $83,000 $83,000 $83,000 $110,700 $110,700 $103,888 $108,000
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $24,750 $24,750 $24,750 $24,750 $24,750 $30,250 $30,250 $30,250 $30,250 $30,250 $30,250 $30,250
Bill Payments $4,935 $36,558 $36,602 $37,952 $37,949 $38,374 $50,768 $50,765 $51,443 $71,175 $71,040 $67,298
Subtotal Spent on Operations $29,685 $61,308 $61,352 $62,702 $62,699 $68,624 $81,018 $81,015 $81,693 $101,425 $101,290 $97,548
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 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
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 $30,185 $61,808 $61,852 $63,202 $63,199 $69,124 $81,518 $81,515 $82,193 $101,925 $101,790 $98,048
Net Cash Flow $34,165 $2,542 $2,498 $1,148 $1,151 $13,876 $1,482 $1,485 $28,507 $8,775 $2,098 $9,952
Cash Balance $47,103 $49,645 $52,144 $53,292 $54,443 $68,319 $69,801 $71,286 $99,794 $108,569 $110,666 $120,618
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $12,938 $47,103 $49,645 $52,144 $53,292 $54,443 $68,319 $69,801 $71,286 $99,794 $108,569 $110,666 $120,618
Other Current Assets $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Total Current Assets $14,938 $49,103 $51,645 $54,144 $55,292 $56,443 $70,319 $71,801 $73,286 $101,794 $110,569 $112,666 $122,618
Long-term Assets
Long-term Assets $74,000 $74,000 $74,000 $74,000 $74,000 $74,000 $74,000 $74,000 $74,000 $74,000 $74,000 $74,000 $74,000
Accumulated Depreciation $12,000 $12,200 $12,400 $12,600 $12,800 $13,000 $13,200 $13,400 $13,600 $14,000 $14,400 $14,800 $15,200
Total Long-term Assets $62,000 $61,800 $61,600 $61,400 $61,200 $61,000 $60,800 $60,600 $60,400 $60,000 $59,600 $59,200 $58,800
Total Assets $76,938 $110,903 $113,245 $115,544 $116,492 $117,443 $131,119 $132,401 $133,686 $161,794 $170,169 $171,866 $181,418
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $3,716 $35,339 $35,337 $36,687 $36,684 $36,681 $49,076 $49,073 $49,070 $68,803 $68,800 $64,978 $67,280
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 $3,716 $35,339 $35,337 $36,687 $36,684 $36,681 $49,076 $49,073 $49,070 $68,803 $68,800 $64,978 $67,280
Long-term Liabilities $23,000 $22,500 $22,000 $21,500 $21,000 $20,500 $20,000 $19,500 $19,000 $18,500 $18,000 $17,500 $17,000
Total Liabilities $26,716 $57,839 $57,337 $58,187 $57,684 $57,181 $69,076 $68,573 $68,070 $87,303 $86,800 $82,478 $84,280
Paid-in Capital $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000
Retained Earnings $20,222 $20,222 $20,222 $20,222 $20,222 $20,222 $20,222 $20,222 $20,222 $20,222 $20,222 $20,222 $20,222
Earnings $0 $2,842 $5,687 $7,135 $8,586 $10,039 $11,821 $13,606 $15,394 $24,269 $33,147 $39,166 $46,916
Total Capital $50,222 $53,064 $55,909 $57,357 $58,808 $60,261 $62,043 $63,828 $65,616 $74,491 $83,369 $89,388 $97,138
Total Liabilities and Capital $76,938 $110,903 $113,245 $115,544 $116,492 $117,443 $131,119 $132,401 $133,686 $161,794 $170,169 $171,866 $181,418
Net Worth $50,222 $53,064 $55,909 $57,357 $58,808 $60,261 $62,043 $63,828 $65,616 $74,491 $83,369 $89,388 $97,138