DIY Wash N' Fix

Start your own business plan »

Auto Repair and Car Wash Business Plan

Appendix

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 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010
Direct Cost of Sales $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821
Gross Margin $69,189 $69,189 $69,189 $69,189 $69,189 $69,189 $69,189 $69,189 $69,189 $69,189 $69,189 $69,189
Gross Margin % 93.49% 93.49% 93.49% 93.49% 93.49% 93.49% 93.49% 93.49% 93.49% 93.49% 93.49% 93.49%
Expenses
Payroll $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852
Sales and Marketing and Other Expenses $19,003 $19,003 $19,003 $19,003 $19,003 $19,003 $19,003 $19,003 $19,003 $19,003 $19,003 $19,003
Depreciation $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Insurance $1,507 $1,507 $1,507 $1,507 $1,507 $1,507 $1,507 $1,507 $1,507 $1,507 $1,507 $1,507
Payroll Taxes 15% $2,828 $2,828 $2,828 $2,828 $2,828 $2,828 $2,828 $2,828 $2,828 $2,828 $2,828 $2,828
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $42,289 $42,289 $42,289 $42,289 $42,289 $42,289 $42,289 $42,289 $42,289 $42,289 $42,289 $42,289
Profit Before Interest and Taxes $26,900 $26,900 $26,900 $26,900 $26,900 $26,900 $26,900 $26,900 $26,900 $26,900 $26,900 $26,900
EBITDA $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000
Interest Expense $3,465 $3,460 $3,456 $3,452 $3,447 $3,443 $3,438 $3,434 $3,429 $3,425 $3,421 $3,416
Taxes Incurred $7,030 $9,376 $9,377 $9,379 $9,381 $9,383 $9,385 $9,386 $9,388 $9,390 $9,392 $9,393
Net Profit $16,404 $14,064 $14,066 $14,069 $14,072 $14,074 $14,077 $14,079 $14,082 $14,085 $14,087 $14,090
Net Profit/Sales 22.17% 19.00% 19.01% 19.01% 19.01% 19.02% 19.02% 19.02% 19.03% 19.03% 19.03% 19.04%
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 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010
Subtotal Cash from Operations $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010
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 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010
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 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852
Bill Payments $1,465 $43,858 $40,994 $40,992 $40,989 $40,986 $40,984 $40,981 $40,978 $40,976 $40,973 $40,970
Subtotal Spent on Operations $20,317 $62,710 $59,846 $59,844 $59,841 $59,838 $59,836 $59,833 $59,830 $59,828 $59,825 $59,822
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 $663 $663 $663 $663 $663 $663 $663 $663 $663 $663 $663 $663
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $21,106 $63,498 $60,635 $60,632 $60,629 $60,627 $60,624 $60,621 $60,619 $60,616 $60,613 $60,611
Net Cash Flow $52,904 $10,512 $13,375 $13,378 $13,381 $13,383 $13,386 $13,389 $13,391 $13,394 $13,397 $13,399
Cash Balance $230,266 $240,778 $254,153 $267,531 $280,912 $294,295 $307,681 $321,070 $334,461 $347,855 $361,252 $374,651
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 $177,362 $230,266 $240,778 $254,153 $267,531 $280,912 $294,295 $307,681 $321,070 $334,461 $347,855 $361,252 $374,651
Inventory $0 $5,303 $5,303 $5,303 $5,303 $5,303 $5,303 $5,303 $5,303 $5,303 $5,303 $5,303 $5,303
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $177,362 $235,569 $246,081 $259,457 $272,835 $286,215 $299,598 $312,984 $326,373 $339,764 $353,158 $366,555 $379,954
Long-term Assets
Long-term Assets $578,200 $578,325 $578,450 $578,575 $578,700 $578,825 $578,950 $579,075 $579,200 $579,325 $579,450 $579,575 $579,700
Accumulated Depreciation $0 $100 $200 $300 $400 $500 $600 $700 $800 $900 $1,000 $1,100 $1,200
Total Long-term Assets $578,200 $578,225 $578,250 $578,275 $578,300 $578,325 $578,350 $578,375 $578,400 $578,425 $578,450 $578,475 $578,500
Total Assets $755,562 $813,794 $824,331 $837,732 $851,135 $864,540 $877,948 $891,359 $904,773 $918,189 $931,608 $945,030 $958,454
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 $42,491 $39,628 $39,625 $39,623 $39,620 $39,618 $39,615 $39,613 $39,610 $39,607 $39,605 $39,602
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 $0 $42,491 $39,628 $39,625 $39,623 $39,620 $39,618 $39,615 $39,613 $39,610 $39,607 $39,605 $39,602
Long-term Liabilities $520,380 $519,717 $519,053 $518,390 $517,727 $517,063 $516,400 $515,737 $515,073 $514,410 $513,747 $513,083 $512,420
Total Liabilities $520,380 $562,208 $558,681 $558,015 $557,349 $556,684 $556,018 $555,352 $554,686 $554,020 $553,354 $552,688 $552,022
Paid-in Capital $236,182 $236,182 $236,182 $236,182 $236,182 $236,182 $236,182 $236,182 $236,182 $236,182 $236,182 $236,182 $236,182
Retained Earnings ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000)
Earnings $0 $16,404 $30,468 $44,534 $58,603 $72,675 $86,749 $100,826 $114,905 $128,987 $143,072 $157,160 $171,250
Total Capital $235,182 $251,586 $265,650 $279,716 $293,785 $307,857 $321,931 $336,008 $350,087 $364,169 $378,254 $392,342 $406,432
Total Liabilities and Capital $755,562 $813,794 $824,331 $837,732 $851,135 $864,540 $877,948 $891,359 $904,773 $918,189 $931,608 $945,030 $958,454
Net Worth $235,182 $251,586 $265,650 $279,716 $293,785 $307,857 $321,931 $336,008 $350,087 $364,169 $378,254 $392,342 $406,432
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
Car Wash 0% 1,260 1,260 1,260 1,260 1,260 1,260 1,260 1,260 1,260 1,260 1,260 1,260
Vacuum Cleaning 0% 1,260 1,260 1,260 1,260 1,260 1,260 1,260 1,260 1,260 1,260 1,260 1,260
Car Paint 0% 630 630 630 630 630 630 630 630 630 630 630 630
Oil Change 0% 630 630 630 630 630 630 630 630 630 630 630 630
Other Repair 0% 630 630 630 630 630 630 630 630 630 630 630 630
Vending Machines, etc. 0% 120 120 120 120 120 120 120 120 120 120 120 120
Total Unit Sales 4,530 4,530 4,530 4,530 4,530 4,530 4,530 4,530 4,530 4,530 4,530 4,530
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
Car Wash $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00
Vacuum Cleaning $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00
Car Paint $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00
Oil Change $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00
Other Repair $40.00 $40.00 $40.00 $40.00 $40.00 $40.00 $40.00 $40.00 $40.00 $40.00 $40.00 $40.00
Vending Machines, etc. $2.50 $2.50 $2.50 $2.50 $2.50 $2.50 $2.50 $2.50 $2.50 $2.50 $2.50 $2.50
Sales
Car Wash $6,300 $6,300 $6,300 $6,300 $6,300 $6,300 $6,300 $6,300 $6,300 $6,300 $6,300 $6,300
Vacuum Cleaning $1,260 $1,260 $1,260 $1,260 $1,260 $1,260 $1,260 $1,260 $1,260 $1,260 $1,260 $1,260
Car Paint $31,500 $31,500 $31,500 $31,500 $31,500 $31,500 $31,500 $31,500 $31,500 $31,500 $31,500 $31,500
Oil Change $9,450 $9,450 $9,450 $9,450 $9,450 $9,450 $9,450 $9,450 $9,450 $9,450 $9,450 $9,450
Other Repair $25,200 $25,200 $25,200 $25,200 $25,200 $25,200 $25,200 $25,200 $25,200 $25,200 $25,200 $25,200
Vending Machines, etc. $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Total Sales $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010 $74,010
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
Car Wash 0.00% $2.13 $2.13 $2.13 $2.13 $2.13 $2.13 $2.13 $2.13 $2.13 $2.13 $2.13 $2.13
Vacuum Cleaning 0.00% $0.43 $0.43 $0.43 $0.43 $0.43 $0.43 $0.43 $0.43 $0.43 $0.43 $0.43 $0.43
Car Paint 0.00% $1.13 $1.13 $1.13 $1.13 $1.13 $1.13 $1.13 $1.13 $1.13 $1.13 $1.13 $1.13
Oil Change 0.00% $0.38 $0.38 $0.38 $0.38 $0.38 $0.38 $0.38 $0.38 $0.38 $0.38 $0.38 $0.38
Other Repair 0.00% $0.85 $0.85 $0.85 $0.85 $0.85 $0.85 $0.85 $0.85 $0.85 $0.85 $0.85 $0.85
Vending Machines, etc. 0.00% $1.06 $1.06 $1.06 $1.06 $1.06 $1.06 $1.06 $1.06 $1.06 $1.06 $1.06 $1.06
Direct Cost of Sales
Car Wash $2,678 $2,678 $2,678 $2,678 $2,678 $2,678 $2,678 $2,678 $2,678 $2,678 $2,678 $2,678
Vacuum Cleaning $536 $536 $536 $536 $536 $536 $536 $536 $536 $536 $536 $536
Car Paint $709 $709 $709 $709 $709 $709 $709 $709 $709 $709 $709 $709
Oil Change $236 $236 $236 $236 $236 $236 $236 $236 $236 $236 $236 $236
Other Repair $536 $536 $536 $536 $536 $536 $536 $536 $536 $536 $536 $536
Vending Machines, etc. $128 $128 $128 $128 $128 $128 $128 $128 $128 $128 $128 $128
Subtotal Direct Cost of Sales $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821 $4,821
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
General Manager 0% $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333
Mechanics 0% $12,124 $12,124 $12,124 $12,124 $12,124 $12,124 $12,124 $12,124 $12,124 $12,124 $12,124 $12,124
Administrative 0% $3,395 $3,395 $3,395 $3,395 $3,395 $3,395 $3,395 $3,395 $3,395 $3,395 $3,395 $3,395
Total People 7 7 7 7 7 7 7 7 7 7 7 7
Total Payroll $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852 $18,852
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 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00%
Long-term Interest Rate 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00%
Tax Rate 30.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0