Southeast Racing

Start your own business plan »

Auto Parts Store 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
Sales
Inventory Sales 0% $16,000 $20,800 $24,960 $22,464 $20,217 $23,250 $26,737 $32,084 $38,501 $46,202 $41,581 $37,423
Internet Marketing 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
Total Sales $17,400 $22,200 $26,360 $23,864 $21,617 $24,650 $28,137 $33,484 $39,901 $47,602 $42,981 $38,823
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Inventory $11,200 $14,560 $17,472 $15,725 $14,152 $16,275 $18,716 $22,459 $26,951 $32,341 $29,107 $26,196
Internet Marketing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $11,200 $14,560 $17,472 $15,725 $14,152 $16,275 $18,716 $22,459 $26,951 $32,341 $29,107 $26,196
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
Tim Jones 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
Molly Jones 0% $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Salesperson (PT) 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Salesperson (FT) 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 2 2 2 2 2 2 2 2 2 2 2 2
Total Payroll $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200
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 $17,400 $22,200 $26,360 $23,864 $21,617 $24,650 $28,137 $33,484 $39,901 $47,602 $42,981 $38,823
Direct Cost of Sales $11,200 $14,560 $17,472 $15,725 $14,152 $16,275 $18,716 $22,459 $26,951 $32,341 $29,107 $26,196
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $11,200 $14,560 $17,472 $15,725 $14,152 $16,275 $18,716 $22,459 $26,951 $32,341 $29,107 $26,196
Gross Margin $6,200 $7,640 $8,888 $8,139 $7,465 $8,375 $9,421 $11,025 $12,950 $15,261 $13,874 $12,627
Gross Margin % 35.63% 34.41% 33.72% 34.11% 34.53% 33.98% 33.48% 32.93% 32.46% 32.06% 32.28% 32.52%
Expenses
Payroll $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200
Marketing/Promotion $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Depreciation $345 $345 $345 $345 $345 $345 $345 $345 $345 $345 $345 $345
Vehicle Expense $150 $150 $150 $125 $125 $125 $125 $150 $150 $150 $150 $150
Credit Card Surcharge $160 $208 $249 $224 $202 $232 $267 $320 $385 $462 $415 $374
Inbound Freight Charges $224 $350 $350 $314 $284 $326 $374 $450 $540 $646 $582 $524
Office Supplies $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Security/alarm $30 $30 $30 $30 $30 $30 $30 $30 $30 $30 $30 $30
Telephone $150 $156 $187 $168 $150 $174 $200 $240 $288 $346 $311 $280
Accounting Costs $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125
Rent $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600
Utilities $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Insurance $70 $70 $70 $70 $70 $70 $70 $70 $70 $70 $70 $70
Payroll Taxes 15% $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 Operating Expenses $5,454 $5,634 $5,706 $5,601 $5,531 $5,627 $5,736 $5,930 $6,133 $6,374 $6,228 $6,098
Profit Before Interest and Taxes $746 $2,006 $3,182 $2,538 $1,934 $2,748 $3,685 $5,095 $6,817 $8,887 $7,646 $6,529
EBITDA $1,091 $2,351 $3,527 $2,883 $2,279 $3,093 $4,030 $5,440 $7,162 $9,232 $7,991 $6,874
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $224 $602 $955 $761 $580 $824 $1,106 $1,529 $2,045 $2,666 $2,294 $1,959
Net Profit $522 $1,404 $2,227 $1,777 $1,354 $1,924 $2,580 $3,567 $4,772 $6,221 $5,352 $4,570
Net Profit/Sales 3.00% 6.33% 8.45% 7.44% 6.26% 7.80% 9.17% 10.65% 11.96% 13.07% 12.45% 11.77%
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 $17,400 $22,200 $26,360 $23,864 $21,617 $24,650 $28,137 $33,484 $39,901 $47,602 $42,981 $38,823
Subtotal Cash from Operations $17,400 $22,200 $26,360 $23,864 $21,617 $24,650 $28,137 $33,484 $39,901 $47,602 $42,981 $38,823
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 $17,400 $22,200 $26,360 $23,864 $21,617 $24,650 $28,137 $33,484 $39,901 $47,602 $42,981 $38,823
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 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200
Bill Payments $2,104 $3,151 $4,120 $16,602 $17,566 $16,206 $22,623 $25,891 $31,691 $37,767 $44,324 $31,426
Subtotal Spent on Operations $4,304 $5,351 $6,320 $18,802 $19,766 $18,406 $24,823 $28,091 $33,891 $39,967 $46,524 $33,626
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $4,304 $5,351 $6,320 $18,802 $19,766 $18,406 $24,823 $28,091 $33,891 $39,967 $46,524 $33,626
Net Cash Flow $13,096 $16,849 $20,040 $5,062 $1,851 $6,244 $3,314 $5,393 $6,010 $7,635 ($3,543) $5,197
Cash Balance $14,096 $30,944 $50,984 $56,046 $57,897 $64,141 $67,456 $72,849 $78,859 $86,494 $82,952 $88,149
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 $1,000 $14,096 $30,944 $50,984 $56,046 $57,897 $64,141 $67,456 $72,849 $78,859 $86,494 $82,952 $88,149
Inventory $50,000 $38,800 $24,240 $19,219 $17,298 $15,567 $17,903 $20,588 $24,705 $29,646 $35,575 $32,018 $28,816
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $51,000 $52,896 $55,184 $70,203 $73,344 $73,464 $82,044 $88,043 $97,554 $108,505 $122,070 $114,969 $116,965
Long-term Assets
Long-term Assets $29,000 $29,000 $29,000 $29,000 $29,000 $29,000 $29,000 $29,000 $29,000 $29,000 $29,000 $29,000 $29,000
Accumulated Depreciation $0 $345 $690 $1,035 $1,380 $1,725 $2,070 $2,415 $2,760 $3,105 $3,450 $3,795 $4,140
Total Long-term Assets $29,000 $28,655 $28,310 $27,965 $27,620 $27,275 $26,930 $26,585 $26,240 $25,895 $25,550 $25,205 $24,860
Total Assets $80,000 $81,551 $83,494 $98,168 $100,964 $100,739 $108,974 $114,628 $123,794 $134,400 $147,620 $140,174 $141,825
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 $2,000 $3,028 $3,568 $16,015 $17,033 $15,455 $21,766 $24,841 $30,440 $36,274 $43,273 $30,476 $27,555
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 $2,000 $3,028 $3,568 $16,015 $17,033 $15,455 $21,766 $24,841 $30,440 $36,274 $43,273 $30,476 $27,555
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $2,000 $3,028 $3,568 $16,015 $17,033 $15,455 $21,766 $24,841 $30,440 $36,274 $43,273 $30,476 $27,555
Paid-in Capital $80,625 $80,625 $80,625 $80,625 $80,625 $80,625 $80,625 $80,625 $80,625 $80,625 $80,625 $80,625 $80,625
Retained Earnings ($2,625) ($2,625) ($2,625) ($2,625) ($2,625) ($2,625) ($2,625) ($2,625) ($2,625) ($2,625) ($2,625) ($2,625) ($2,625)
Earnings $0 $522 $1,926 $4,154 $5,930 $7,284 $9,208 $11,787 $15,354 $20,126 $26,347 $31,699 $36,269
Total Capital $78,000 $78,522 $79,926 $82,154 $83,930 $85,284 $87,208 $89,787 $93,354 $98,126 $104,347 $109,699 $114,269
Total Liabilities and Capital $80,000 $81,551 $83,494 $98,168 $100,964 $100,739 $108,974 $114,628 $123,794 $134,400 $147,620 $140,174 $141,825
Net Worth $78,000 $78,522 $79,926 $82,154 $83,930 $85,284 $87,208 $89,787 $93,354 $98,126 $104,347 $109,699 $114,269