Quick and Dirty Auto Repair

Start your own business plan »

Auto Repair Service Business Plan

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
Unit Sales
Auto Repair Jobs 0% 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400
Auto Parts 0% 6,250 6,250 6,250 6,250 6,250 6,250 6,250 6,250 6,250 6,250 6,250 6,250
Other 0% 0 0 0 0 0 0 0 0 0 0 0 0
Total Unit Sales 7,650 7,650 7,650 7,650 7,650 7,650 7,650 7,650 7,650 7,650 7,650 7,650
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Auto Repair Jobs $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00
Auto Parts $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Other $0.00 $0.00 $0.00 $0.00 $0.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00
Sales
Auto Repair Jobs $420,000 $420,000 $420,000 $420,000 $420,000 $420,000 $420,000 $420,000 $420,000 $420,000 $420,000 $420,000
Auto Parts $375,000 $375,000 $375,000 $375,000 $375,000 $375,000 $375,000 $375,000 $375,000 $375,000 $375,000 $375,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Auto Repair Jobs 0.00% $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00
Auto Parts 0.00% $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.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Direct Cost of Sales
Auto Repair Jobs $140,000 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000
Auto Parts $187,500 $187,500 $187,500 $187,500 $187,500 $187,500 $187,500 $187,500 $187,500 $187,500 $187,500 $187,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500
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
Owners 0% $26,667 $26,667 $26,667 $26,667 $26,667 $26,667 $26,667 $26,667 $26,667 $26,667 $26,667 $26,667
Managers 0% $11,250 $11,250 $11,250 $11,250 $11,250 $11,250 $11,250 $11,250 $11,250 $11,250 $11,250 $11,250
Mechanics 0% $262,500 $262,500 $262,500 $262,500 $262,500 $262,500 $262,500 $262,500 $262,500 $262,500 $262,500 $262,500
Customer Service Associates 0% $22,500 $22,500 $22,500 $22,500 $22,500 $22,500 $22,500 $22,500 $22,500 $22,500 $22,500 $22,500
Sales & Administrative 0% $36,667 $36,667 $36,667 $36,667 $36,667 $36,667 $36,667 $36,667 $36,667 $36,667 $36,667 $36,667
Total People 120 120 120 120 120 120 120 120 120 120 120 120
Total Payroll $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583
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 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000
Direct Cost of Sales $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500 $327,500
Gross Margin $467,500 $467,500 $467,500 $467,500 $467,500 $467,500 $467,500 $467,500 $467,500 $467,500 $467,500 $467,500
Gross Margin % 58.81% 58.81% 58.81% 58.81% 58.81% 58.81% 58.81% 58.81% 58.81% 58.81% 58.81% 58.81%
Expenses
Payroll $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583
Sales and Marketing and Other Expenses $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250
Depreciation 15% $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Utilities 5% $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Payroll Taxes 15% $53,938 $53,938 $53,938 $53,938 $53,938 $53,938 $53,938 $53,938 $53,938 $53,938 $53,938 $53,938
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $425,871 $425,871 $425,871 $425,871 $425,871 $425,871 $425,871 $425,871 $425,871 $425,871 $425,871 $425,871
Profit Before Interest and Taxes $41,629 $41,629 $41,629 $41,629 $41,629 $41,629 $41,629 $41,629 $41,629 $41,629 $41,629 $41,629
EBITDA $51,629 $51,629 $51,629 $51,629 $51,629 $51,629 $51,629 $51,629 $51,629 $51,629 $51,629 $51,629
Interest Expense $2,495 $2,448 $2,401 $2,353 $2,305 $2,256 $2,207 $2,157 $2,108 $2,057 $2,007 $1,956
Taxes Incurred $11,740 $9,795 $9,807 $9,819 $9,831 $9,843 $9,856 $9,868 $9,880 $9,893 $9,906 $9,918
Net Profit $27,394 $29,386 $29,421 $29,457 $29,493 $29,530 $29,567 $29,604 $29,641 $29,679 $29,717 $29,755
Net Profit/Sales 3.45% 3.70% 3.70% 3.71% 3.71% 3.71% 3.72% 3.72% 3.73% 3.73% 3.74% 3.74%
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 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000
Subtotal Cash from Operations $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,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 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000 $795,000
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 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583 $359,583
Bill Payments $23,609 $697,865 $396,030 $395,994 $395,958 $395,922 $395,885 $395,849 $395,812 $395,774 $395,737 $395,699
Subtotal Spent on Operations $383,192 $1,057,448 $755,613 $755,577 $755,541 $755,505 $755,469 $755,432 $755,395 $755,358 $755,320 $755,282
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 $4,377 $4,414 $4,450 $4,487 $4,525 $4,562 $4,601 $4,639 $4,677 $4,716 $4,756 $4,796
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $1,220 $1,231 $1,241 $1,251 $1,262 $1,272 $1,283 $1,293 $1,304 $1,315 $1,326 $1,337
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $433,789 $1,108,093 $806,304 $806,315 $806,328 $806,339 $806,353 $806,364 $806,376 $806,389 $806,402 $806,415
Net Cash Flow $361,211 ($313,093) ($11,304) ($11,315) ($11,328) ($11,339) ($11,353) ($11,364) ($11,376) ($11,389) ($11,402) ($11,415)
Cash Balance $461,211 $148,118 $136,814 $125,498 $114,170 $102,830 $91,478 $80,114 $68,738 $57,349 $45,947 $34,532
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 $100,000 $461,211 $148,118 $136,814 $125,498 $114,170 $102,830 $91,478 $80,114 $68,738 $57,349 $45,947 $34,532
Inventory $50,000 $360,250 $360,250 $360,250 $360,250 $360,250 $360,250 $360,250 $360,250 $360,250 $360,250 $360,250 $360,250
Other Current Assets $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000
Total Current Assets $200,000 $871,461 $558,368 $547,064 $535,748 $524,420 $513,080 $501,728 $490,364 $478,988 $467,599 $456,197 $444,782
Long-term Assets
Long-term Assets $350,000 $395,000 $440,000 $485,000 $530,000 $575,000 $620,000 $665,000 $710,000 $755,000 $800,000 $845,000 $890,000
Accumulated Depreciation $0 $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000 $90,000 $100,000 $110,000 $120,000
Total Long-term Assets $350,000 $385,000 $420,000 $455,000 $490,000 $525,000 $560,000 $595,000 $630,000 $665,000 $700,000 $735,000 $770,000
Total Assets $550,000 $1,256,461 $978,368 $1,002,064 $1,025,748 $1,049,420 $1,073,080 $1,096,728 $1,120,364 $1,143,988 $1,167,599 $1,191,197 $1,214,782
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 $684,664 $382,830 $382,795 $382,761 $382,726 $382,690 $382,655 $382,619 $382,583 $382,547 $382,510 $382,473
Current Borrowing $55,000 $50,623 $46,209 $41,759 $37,272 $32,747 $28,185 $23,584 $18,945 $14,268 $9,552 $4,796 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $55,000 $735,287 $429,039 $424,554 $420,033 $415,473 $410,875 $406,239 $401,564 $396,851 $392,099 $387,306 $382,473
Long-term Liabilities $250,000 $248,780 $247,549 $246,308 $245,057 $243,795 $242,523 $241,240 $239,947 $238,643 $237,328 $236,002 $234,665
Total Liabilities $305,000 $984,067 $676,588 $670,862 $665,090 $659,268 $653,398 $647,479 $641,511 $635,494 $629,427 $623,308 $617,138
Paid-in Capital $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000
Retained Earnings ($5,000) ($5,000) ($5,000) ($5,000) ($5,000) ($5,000) ($5,000) ($5,000) ($5,000) ($5,000) ($5,000) ($5,000) ($5,000)
Earnings $0 $27,394 $56,780 $86,201 $115,659 $145,152 $174,682 $204,249 $233,853 $263,494 $293,173 $322,889 $352,645
Total Capital $245,000 $272,394 $301,780 $331,201 $360,659 $390,152 $419,682 $449,249 $478,853 $508,494 $538,173 $567,889 $597,645
Total Liabilities and Capital $550,000 $1,256,461 $978,368 $1,002,064 $1,025,748 $1,049,420 $1,073,080 $1,096,728 $1,120,364 $1,143,988 $1,167,599 $1,191,197 $1,214,782
Net Worth $245,000 $272,394 $301,780 $331,201 $360,659 $390,152 $419,682 $449,249 $478,853 $508,494 $538,173 $567,889 $597,645