Mahogany Western Wear

Start your own business plan »

Clothing Retail 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
Clothing 0% 325 350 350 400 400 475 500 475 500 500 450 450
Belts & Hats 0% 15 15 15 20 20 30 30 35 35 30 20 20
Jewelry & Gifts 0% 40 40 40 40 40 65 65 50 50 50 40 40
Total Unit Sales 380 405 405 460 460 570 595 560 585 580 510 510
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
Clothing $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00
Belts & Hats $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00
Jewelry & Gifts $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00
Sales
Clothing $16,250 $17,500 $17,500 $20,000 $20,000 $23,750 $25,000 $23,750 $25,000 $25,000 $22,500 $22,500
Belts & Hats $750 $750 $750 $1,000 $1,000 $1,500 $1,500 $1,750 $1,750 $1,500 $1,000 $1,000
Jewelry & Gifts $800 $800 $800 $800 $800 $1,300 $1,300 $1,000 $1,000 $1,000 $800 $800
Total Sales $17,800 $19,050 $19,050 $21,800 $21,800 $26,550 $27,800 $26,500 $27,750 $27,500 $24,300 $24,300
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
Clothing 0.00% $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00
Belts & Hats 0.00% $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00
Jewelry & Gifts 0.00% $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00
Direct Cost of Sales
Clothing $8,125 $8,750 $8,750 $10,000 $10,000 $11,875 $12,500 $11,875 $12,500 $12,500 $11,250 $11,250
Belts & Hats $375 $375 $375 $500 $500 $750 $750 $875 $875 $750 $500 $500
Jewelry & Gifts $400 $400 $400 $400 $400 $650 $650 $500 $500 $500 $400 $400
Subtotal Direct Cost of Sales $8,900 $9,525 $9,525 $10,900 $10,900 $13,275 $13,900 $13,250 $13,875 $13,750 $12,150 $12,150
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
Owner 0% $900 $900 $900 $1,125 $900 $900 $1,125 $900 $900 $1,125 $900 $900
Full-time postion 0% $1,600 $1,600 $1,600 $2,000 $1,600 $1,600 $2,000 $1,600 $1,600 $2,000 $1,600 $1,600
Part-time position 0% $960 $960 $960 $1,200 $960 $960 $1,200 $960 $960 $1,200 $960 $960
Total People 3 3 3 3 3 3 3 3 3 3 3 3
Total Payroll $3,460 $3,460 $3,460 $4,325 $3,460 $3,460 $4,325 $3,460 $3,460 $4,325 $3,460 $3,460
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 $17,800 $19,050 $19,050 $21,800 $21,800 $26,550 $27,800 $26,500 $27,750 $27,500 $24,300 $24,300
Direct Cost of Sales $8,900 $9,525 $9,525 $10,900 $10,900 $13,275 $13,900 $13,250 $13,875 $13,750 $12,150 $12,150
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $8,900 $9,525 $9,525 $10,900 $10,900 $13,275 $13,900 $13,250 $13,875 $13,750 $12,150 $12,150
Gross Margin $8,900 $9,525 $9,525 $10,900 $10,900 $13,275 $13,900 $13,250 $13,875 $13,750 $12,150 $12,150
Gross Margin % 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00%
Expenses
Payroll $3,460 $3,460 $3,460 $4,325 $3,460 $3,460 $4,325 $3,460 $3,460 $4,325 $3,460 $3,460
Sales and Marketing and Other Expenses $1,229 $1,229 $1,579 $1,229 $1,229 $1,229 $1,229 $1,579 $1,229 $1,229 $1,229 $1,229
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Telephone / Pagers/ Cell $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Utilities $375 $375 $375 $375 $375 $375 $375 $375 $375 $375 $375 $375
Payroll Taxes 10% $346 $346 $346 $433 $346 $346 $433 $346 $346 $433 $346 $346
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $5,560 $5,560 $5,910 $6,512 $5,560 $5,560 $6,512 $5,910 $5,560 $6,512 $5,560 $5,560
Profit Before Interest and Taxes $3,340 $3,965 $3,615 $4,389 $5,340 $7,715 $7,389 $7,340 $8,315 $7,239 $6,590 $6,590
EBITDA $3,340 $3,965 $3,615 $4,389 $5,340 $7,715 $7,389 $7,340 $8,315 $7,239 $6,590 $6,590
Interest Expense $137 $135 $132 $130 $128 $125 $123 $121 $119 $116 $114 $112
Taxes Incurred $961 $1,149 $1,045 $1,278 $1,564 $2,277 $2,180 $2,166 $2,459 $2,137 $1,943 $1,943
Net Profit $2,242 $2,681 $2,438 $2,981 $3,649 $5,313 $5,086 $5,053 $5,738 $4,986 $4,533 $4,535
Net Profit/Sales 12.60% 14.08% 12.80% 13.67% 16.74% 20.01% 18.29% 19.07% 20.68% 18.13% 18.66% 18.66%
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,800 $19,050 $19,050 $21,800 $21,800 $26,550 $27,800 $26,500 $27,750 $27,500 $24,300 $24,300
Subtotal Cash from Operations $17,800 $19,050 $19,050 $21,800 $21,800 $26,550 $27,800 $26,500 $27,750 $27,500 $24,300 $24,300
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,800 $19,050 $19,050 $21,800 $21,800 $26,550 $27,800 $26,500 $27,750 $27,500 $24,300 $24,300
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 $3,460 $3,460 $3,460 $4,325 $3,460 $3,460 $4,325 $3,460 $3,460 $4,325 $3,460 $3,460
Bill Payments $263 $8,078 $13,581 $13,247 $15,963 $14,881 $20,346 $19,017 $17,337 $19,200 $17,935 $14,605
Subtotal Spent on Operations $3,723 $11,538 $17,041 $17,572 $19,423 $18,341 $24,671 $22,477 $20,797 $23,525 $21,395 $18,065
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 $275 $275 $275 $275 $275 $275 $275 $275 $275 $275 $275 $275
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 $3,998 $11,813 $17,316 $17,847 $19,698 $18,616 $24,946 $22,752 $21,072 $23,800 $21,670 $18,340
Net Cash Flow $13,802 $7,237 $1,734 $3,953 $2,102 $7,934 $2,854 $3,748 $6,678 $3,700 $2,630 $5,960
Cash Balance $14,186 $21,423 $23,157 $27,109 $29,212 $37,145 $39,999 $43,748 $50,425 $54,125 $56,755 $62,715
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 $384 $14,186 $21,423 $23,157 $27,109 $29,212 $37,145 $39,999 $43,748 $50,425 $54,125 $56,755 $62,715
Inventory $14,000 $9,790 $10,478 $10,478 $11,990 $11,990 $14,603 $15,290 $14,575 $15,263 $15,125 $13,365 $13,365
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $14,384 $23,976 $31,900 $33,634 $39,099 $41,202 $51,748 $55,289 $58,323 $65,688 $69,250 $70,120 $76,080
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $14,384 $23,976 $31,900 $33,634 $39,099 $41,202 $51,748 $55,289 $58,323 $65,688 $69,250 $70,120 $76,080
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 $7,625 $13,143 $12,714 $15,473 $14,202 $19,710 $18,441 $16,696 $18,599 $17,450 $14,062 $15,762
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $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
Subtotal Current Liabilities $2,000 $9,625 $15,143 $14,714 $17,473 $16,202 $21,710 $20,441 $18,696 $20,599 $19,450 $16,062 $17,762
Long-term Liabilities $16,700 $16,425 $16,150 $15,875 $15,600 $15,325 $15,050 $14,775 $14,500 $14,225 $13,950 $13,675 $13,400
Total Liabilities $18,700 $26,050 $31,293 $30,589 $33,073 $31,527 $36,760 $35,216 $33,196 $34,824 $33,400 $29,737 $31,162
Paid-in Capital $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100
Retained Earnings ($9,416) ($9,416) ($9,416) ($9,416) ($9,416) ($9,416) ($9,416) ($9,416) ($9,416) ($9,416) ($9,416) ($9,416) ($9,416)
Earnings $0 $2,242 $4,923 $7,361 $10,342 $13,991 $19,304 $24,389 $29,443 $35,180 $40,166 $44,699 $49,234
Total Capital ($4,316) ($2,074) $607 $3,045 $6,026 $9,675 $14,988 $20,073 $25,127 $30,864 $35,850 $40,383 $44,918
Total Liabilities and Capital $14,384 $23,976 $31,900 $33,634 $39,099 $41,202 $51,748 $55,289 $58,323 $65,688 $69,250 $70,120 $76,080
Net Worth ($4,316) ($2,074) $607 $3,045 $6,026 $9,675 $14,988 $20,073 $25,127 $30,864 $35,850 $40,383 $44,918