Dollar Store

Start your own business plan »

Retail Discount 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
Perishable Items 0% $6,000 $6,500 $7,000 $7,500 $8,500 $9,000 $9,000 $9,000 $10,000 $12,000 $12,000 $17,000
Non-Perishible Items 0% $12,000 $13,000 $14,000 $15,000 $17,000 $18,000 $18,000 $18,000 $19,000 $21,000 $21,000 $26,000
Total Sales $18,000 $19,500 $21,000 $22,500 $25,500 $27,000 $27,000 $27,000 $29,000 $33,000 $33,000 $43,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
Perishable Items $3,000 $3,250 $3,500 $3,750 $4,250 $4,500 $4,500 $4,500 $5,000 $6,000 $6,000 $8,500
Non-Perishable Items $6,000 $6,500 $7,000 $7,500 $8,500 $9,000 $9,000 $9,000 $9,500 $10,500 $10,500 $13,000
Subtotal Direct Cost of Sales $9,000 $9,750 $10,500 $11,250 $12,750 $13,500 $13,500 $13,500 $14,500 $16,500 $16,500 $21,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
Owner 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Owner/Manager 0% $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Full Time 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
Full Time 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
Full Time 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
Full Time 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
Part Time 0% $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Part Time 0% $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Part Time 0% $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Part Time 0% $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Total People 10 10 10 10 10 10 10 10 10 10 10 10
Total Payroll $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100
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 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00%
Long-term Interest Rate 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.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 $18,000 $19,500 $21,000 $22,500 $25,500 $27,000 $27,000 $27,000 $29,000 $33,000 $33,000 $43,000
Direct Cost of Sales $9,000 $9,750 $10,500 $11,250 $12,750 $13,500 $13,500 $13,500 $14,500 $16,500 $16,500 $21,500
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $9,000 $9,750 $10,500 $11,250 $12,750 $13,500 $13,500 $13,500 $14,500 $16,500 $16,500 $21,500
Gross Margin $9,000 $9,750 $10,500 $11,250 $12,750 $13,500 $13,500 $13,500 $14,500 $16,500 $16,500 $21,500
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 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100
Sales and Marketing and Other Expenses $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Depreciation $95 $95 $95 $95 $95 $95 $95 $95 $95 $95 $95 $95
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
Utilities $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $0
Insurance $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Payroll Taxes 15% $1,815 $1,815 $1,815 $1,815 $1,815 $1,815 $1,815 $1,815 $1,815 $1,815 $1,815 $1,815
Other $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Total Operating Expenses $18,810 $18,810 $18,810 $18,810 $18,810 $18,810 $18,810 $18,810 $18,810 $18,810 $18,810 $18,510
Profit Before Interest and Taxes ($9,810) ($9,060) ($8,310) ($7,560) ($6,060) ($5,310) ($5,310) ($5,310) ($4,310) ($2,310) ($2,310) $2,990
EBITDA ($9,715) ($8,965) ($8,215) ($7,465) ($5,965) ($5,215) ($5,215) ($5,215) ($4,215) ($2,215) ($2,215) $3,085
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $18 $17
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($9,810) ($9,060) ($8,310) ($7,560) ($6,060) ($5,310) ($5,310) ($5,310) ($4,310) ($2,310) ($2,328) $2,973
Net Profit/Sales -54.50% -46.46% -39.57% -33.60% -23.77% -19.67% -19.67% -19.67% -14.86% -7.00% -7.05% 6.91%
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 $18,000 $19,500 $21,000 $22,500 $25,500 $27,000 $27,000 $27,000 $29,000 $33,000 $33,000 $43,000
Subtotal Cash from Operations $18,000 $19,500 $21,000 $22,500 $25,500 $27,000 $27,000 $27,000 $29,000 $33,000 $33,000 $43,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 $3,000 $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 $2,000 $0
Subtotal Cash Received $18,000 $19,500 $21,000 $22,500 $25,500 $27,000 $27,000 $27,000 $29,000 $33,000 $38,000 $43,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 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100
Bill Payments $6,221 $6,931 $16,152 $17,965 $18,768 $21,013 $20,913 $20,115 $20,185 $22,318 $25,242 $23,472
Subtotal Spent on Operations $18,321 $19,031 $28,252 $30,065 $30,868 $33,113 $33,013 $32,215 $32,285 $34,418 $37,342 $35,572
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 $100
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 $18,321 $19,031 $28,252 $30,065 $30,868 $33,113 $33,013 $32,215 $32,285 $34,418 $37,342 $35,672
Net Cash Flow ($321) $469 ($7,252) ($7,565) ($5,368) ($6,113) ($6,013) ($5,215) ($3,285) ($1,418) $658 $7,328
Cash Balance $42,180 $42,649 $35,397 $27,832 $22,465 $16,352 $10,340 $5,125 $1,840 $421 $1,079 $8,406
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 $42,500 $42,180 $42,649 $35,397 $27,832 $22,465 $16,352 $10,340 $5,125 $1,840 $421 $1,079 $8,406
Inventory $20,000 $11,000 $10,725 $11,550 $12,375 $14,025 $14,850 $14,850 $14,850 $15,950 $18,150 $18,150 $23,650
Other Current Assets $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
Total Current Assets $63,500 $54,180 $54,374 $47,947 $41,207 $37,490 $32,202 $26,190 $20,975 $18,790 $19,571 $20,229 $33,056
Long-term Assets
Long-term Assets $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Accumulated Depreciation $0 $95 $190 $286 $381 $476 $571 $667 $762 $857 $952 $1,048 $1,143
Total Long-term Assets $10,000 $9,905 $9,810 $9,714 $9,619 $9,524 $9,429 $9,333 $9,238 $9,143 $9,048 $8,952 $8,857
Total Assets $73,500 $64,084 $64,183 $57,661 $50,826 $47,013 $41,631 $35,523 $30,213 $27,932 $28,619 $29,181 $41,914
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 $6,000 $6,395 $15,554 $17,342 $18,067 $20,315 $20,242 $19,445 $19,445 $21,475 $24,471 $22,361 $32,221
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,000 $2,900
Other Current Liabilities $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Subtotal Current Liabilities $6,500 $6,895 $16,054 $17,842 $18,567 $20,815 $20,742 $19,945 $19,945 $21,975 $24,971 $25,861 $35,621
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $6,500 $6,895 $16,054 $17,842 $18,567 $20,815 $20,742 $19,945 $19,945 $21,975 $24,971 $25,861 $35,621
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 $82,000 $82,000
Retained Earnings ($13,000) ($13,000) ($13,000) ($13,000) ($13,000) ($13,000) ($13,000) ($13,000) ($13,000) ($13,000) ($13,000) ($13,000) ($13,000)
Earnings $0 ($9,810) ($18,870) ($27,181) ($34,741) ($40,801) ($46,111) ($51,422) ($56,732) ($61,042) ($63,352) ($65,680) ($62,707)
Total Capital $67,000 $57,190 $48,130 $39,819 $32,259 $26,199 $20,889 $15,578 $10,268 $5,958 $3,648 $3,320 $6,293
Total Liabilities and Capital $73,500 $64,084 $64,183 $57,661 $50,826 $47,013 $41,631 $35,523 $30,213 $27,932 $28,619 $29,181 $41,914
Net Worth $67,000 $57,190 $48,130 $39,819 $32,259 $26,199 $20,889 $15,578 $10,268 $5,958 $3,648 $3,320 $6,293