Clara's Hardware Store

Start your own business plan »

Retail Hardware 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
Hardware 0% $50,000 $60,000 $70,000 $75,000 $85,000 $90,000 $100,000 $85,000 $90,000 $85,000 $79,000 $95,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $50,000 $60,000 $70,000 $75,000 $85,000 $90,000 $100,000 $85,000 $90,000 $85,000 $79,000 $95,000
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
Hardware $25,000 $30,000 $35,000 $37,000 $42,000 $45,000 $50,000 $42,000 $45,000 $42,000 $39,000 $42,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $25,000 $30,000 $35,000 $37,000 $42,000 $45,000 $50,000 $42,000 $45,000 $42,000 $39,000 $42,000
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
Manager 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
Assistant Manager 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
Office Manager/Bookkeeper 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
Checkers 0% $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700
Customer Assistants 0% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Stockers 0% $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 9 9 9 9 9 9 9 9 9 9 9 9
Total Payroll $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
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% 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
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 $50,000 $60,000 $70,000 $75,000 $85,000 $90,000 $100,000 $85,000 $90,000 $85,000 $79,000 $95,000
Direct Cost of Sales $25,000 $30,000 $35,000 $37,000 $42,000 $45,000 $50,000 $42,000 $45,000 $42,000 $39,000 $42,000
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $25,000 $30,000 $35,000 $37,000 $42,000 $45,000 $50,000 $42,000 $45,000 $42,000 $39,000 $42,000
Gross Margin $25,000 $30,000 $35,000 $38,000 $43,000 $45,000 $50,000 $43,000 $45,000 $43,000 $40,000 $53,000
Gross Margin % 50.00% 50.00% 50.00% 50.67% 50.59% 50.00% 50.00% 50.59% 50.00% 50.59% 50.63% 55.79%
Expenses
Payroll $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Sales and Marketing and Other Expenses $20,000 $25,000 $5,000 $0 $5,000 $5,000 $0 $5,000 $0 $0 $5,000 $5,000
Depreciation $357 $357 $357 $357 $357 $357 $357 $357 $357 $357 $357 $357
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Insurance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Payroll Taxes 15% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $46,857 $51,857 $31,857 $26,857 $31,857 $31,857 $26,857 $31,857 $26,857 $26,857 $31,857 $31,857
Profit Before Interest and Taxes ($21,857) ($21,857) $3,143 $11,143 $11,143 $13,143 $23,143 $11,143 $18,143 $16,143 $8,143 $21,143
EBITDA ($21,500) ($21,500) $3,500 $11,500 $11,500 $13,500 $23,500 $11,500 $18,500 $16,500 $8,500 $21,500
Interest Expense $1,229 $1,208 $1,188 $1,167 $1,146 $1,125 $1,104 $1,083 $1,063 $1,042 $1,021 $1,000
Taxes Incurred ($6,926) ($6,920) $587 $2,993 $2,999 $3,605 $6,612 $3,018 $5,124 $4,530 $2,137 $6,043
Net Profit ($16,160) ($16,146) $1,369 $6,983 $6,998 $8,413 $15,427 $7,042 $11,956 $10,571 $4,986 $14,100
Net Profit/Sales -32.32% -26.91% 1.96% 9.31% 8.23% 9.35% 15.43% 8.28% 13.28% 12.44% 6.31% 14.84%
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 $50,000 $60,000 $70,000 $75,000 $85,000 $90,000 $100,000 $85,000 $90,000 $85,000 $79,000 $95,000
Subtotal Cash from Operations $50,000 $60,000 $70,000 $75,000 $85,000 $90,000 $100,000 $85,000 $90,000 $85,000 $79,000 $95,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 $50,000 $60,000 $70,000 $75,000 $85,000 $90,000 $100,000 $85,000 $90,000 $85,000 $79,000 $95,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 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Bill Payments $2,443 $72,903 $61,038 $53,644 $50,302 $63,191 $64,703 $69,019 $49,207 $60,646 $50,758 $50,807
Subtotal Spent on Operations $22,443 $92,903 $81,038 $73,644 $70,302 $83,191 $84,703 $89,019 $69,207 $80,646 $70,758 $70,807
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 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,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 $24,943 $95,403 $83,538 $76,144 $72,802 $85,691 $87,203 $91,519 $71,707 $83,146 $73,258 $73,307
Net Cash Flow $25,057 ($35,403) ($13,538) ($1,144) $12,198 $4,309 $12,797 ($6,519) $18,293 $1,854 $5,742 $21,693
Cash Balance $146,057 $110,654 $97,115 $95,972 $108,169 $112,478 $125,275 $118,756 $137,049 $138,903 $144,645 $166,338
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 $121,000 $146,057 $110,654 $97,115 $95,972 $108,169 $112,478 $125,275 $118,756 $137,049 $138,903 $144,645 $166,338
Inventory $0 $27,500 $33,000 $38,500 $40,700 $46,200 $49,500 $55,000 $46,200 $49,500 $46,200 $42,900 $46,200
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $121,000 $173,557 $143,654 $135,615 $136,672 $154,369 $161,978 $180,275 $164,956 $186,549 $185,103 $187,545 $212,538
Long-term Assets
Long-term Assets $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
Accumulated Depreciation $0 $357 $714 $1,071 $1,428 $1,785 $2,142 $2,499 $2,856 $3,213 $3,570 $3,927 $4,284
Total Long-term Assets $30,000 $29,643 $29,286 $28,929 $28,572 $28,215 $27,858 $27,501 $27,144 $26,787 $26,430 $26,073 $25,716
Total Assets $151,000 $203,200 $172,940 $164,544 $165,244 $182,584 $189,836 $207,776 $192,100 $213,336 $211,533 $213,618 $238,254
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 $70,860 $59,246 $51,982 $48,198 $61,040 $62,379 $67,392 $47,175 $58,954 $49,080 $48,679 $61,715
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 $70,860 $59,246 $51,982 $48,198 $61,040 $62,379 $67,392 $47,175 $58,954 $49,080 $48,679 $61,715
Long-term Liabilities $150,000 $147,500 $145,000 $142,500 $140,000 $137,500 $135,000 $132,500 $130,000 $127,500 $125,000 $122,500 $120,000
Total Liabilities $150,000 $218,360 $204,246 $194,482 $188,198 $198,540 $197,379 $199,892 $177,175 $186,454 $174,080 $171,179 $181,715
Paid-in Capital $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000
Retained Earnings ($79,000) ($79,000) ($79,000) ($79,000) ($79,000) ($79,000) ($79,000) ($79,000) ($79,000) ($79,000) ($79,000) ($79,000) ($79,000)
Earnings $0 ($16,160) ($32,306) ($30,937) ($23,954) ($16,956) ($8,543) $6,884 $13,926 $25,882 $36,453 $41,439 $55,539
Total Capital $1,000 ($15,160) ($31,306) ($29,937) ($22,954) ($15,956) ($7,543) $7,884 $14,926 $26,882 $37,453 $42,439 $56,539
Total Liabilities and Capital $151,000 $203,200 $172,940 $164,544 $165,244 $182,584 $189,836 $207,776 $192,100 $213,336 $211,533 $213,618 $238,254
Net Worth $1,000 ($15,160) ($31,306) ($29,937) ($22,954) ($15,956) ($7,543) $7,884 $14,926 $26,882 $37,453 $42,439 $56,539