NALB Creative Center

Start your own business plan »

Art Supply Store and Gallery 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
Painting Supplies 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
Drawing/Illustration 0% $200 $200 $200 $200 $300 $300 $200 $200 $200 $200 $200 $200
Books/Media 0% $500 $500 $500 $500 $1,000 $1,000 $500 $500 $500 $500 $500 $500
Cutting Tools 0% $100 $100 $100 $100 $200 $200 $100 $100 $100 $100 $100 $100
Adhesives 0% $100 $100 $100 $100 $200 $200 $100 $100 $100 $100 $100 $100
Glass 0% $0 $0 $0 $0 $0 $0 $0 $100 $150 $150 $150 $200
Ceramics 0% $300 $300 $300 $300 $400 $400 $300 $300 $300 $300 $300 $300
Crafts 0% $1,500 $1,500 $1,500 $1,500 $2,000 $2,000 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Gifts/Studio Environment 0% $2,000 $2,000 $2,000 $2,000 $2,500 $2,500 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Print Making 0% $350 $350 $350 $350 $400 $400 $350 $350 $350 $350 $350 $350
Sculpture 0% $250 $250 $250 $250 $300 $300 $250 $250 $250 $250 $250 $250
Portfolios/Transporting 0% $200 $200 $200 $200 $400 $400 $200 $200 $200 $200 $200 $200
Gallery Sales 0% $1,000 $1,000 $1,000 $1,000 $2,000 $2,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Fabrics/Yarn 0% $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Equipment 0% $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Clothing/Accessories 0% $200 $200 $200 $200 $300 $300 $200 $200 $200 $200 $200 $200
Paper/Boards 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
Classes 0% $0 $50 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Canvas/Surfaces 0% $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200
Total Sales $25,700 $25,750 $25,800 $25,800 $29,100 $29,100 $25,800 $25,900 $25,950 $25,950 $25,950 $26,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
Inventory 50% $12,850 $12,875 $12,900 $12,900 $14,550 $14,550 $12,900 $12,950 $12,975 $12,975 $12,975 $13,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $12,850 $12,875 $12,900 $12,900 $14,550 $14,550 $12,900 $12,950 $12,975 $12,975 $12,975 $13,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
Owners 5% $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500
Other 5% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other 5% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 2 2 2 2 4 3 3 3 3 3 3 3
Total Payroll $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500
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 $25,700 $25,750 $25,800 $25,800 $29,100 $29,100 $25,800 $25,900 $25,950 $25,950 $25,950 $26,000
Direct Cost of Sales $12,850 $12,875 $12,900 $12,900 $14,550 $14,550 $12,900 $12,950 $12,975 $12,975 $12,975 $13,000
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $12,850 $12,875 $12,900 $12,900 $14,550 $14,550 $12,900 $12,950 $12,975 $12,975 $12,975 $13,000
Gross Margin $12,850 $12,875 $12,900 $12,900 $14,550 $14,550 $12,900 $12,950 $12,975 $12,975 $12,975 $13,000
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 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500
Marketing/Promotion $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Utilities $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Insurance $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
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 $10,500 $10,500 $10,500 $10,500 $10,500 $10,500 $10,500 $10,500 $10,500 $10,500 $10,500 $10,500
Profit Before Interest and Taxes $2,350 $2,375 $2,400 $2,400 $4,050 $4,050 $2,400 $2,450 $2,475 $2,475 $2,475 $2,500
EBITDA $2,350 $2,375 $2,400 $2,400 $4,050 $4,050 $2,400 $2,450 $2,475 $2,475 $2,475 $2,500
Interest Expense $1,039 $1,028 $1,017 $1,006 $995 $984 $973 $963 $952 $941 $930 $919
Taxes Incurred $393 $404 $415 $418 $916 $920 $428 $446 $457 $460 $464 $474
Net Profit $918 $943 $968 $976 $2,138 $2,146 $999 $1,041 $1,066 $1,074 $1,082 $1,107
Net Profit/Sales 3.57% 3.66% 3.75% 3.78% 7.35% 7.37% 3.87% 4.02% 4.11% 4.14% 4.17% 4.26%
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 $25,700 $25,750 $25,800 $25,800 $29,100 $29,100 $25,800 $25,900 $25,950 $25,950 $25,950 $26,000
Subtotal Cash from Operations $25,700 $25,750 $25,800 $25,800 $29,100 $29,100 $25,800 $25,900 $25,950 $25,950 $25,950 $26,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 $25,700 $25,750 $25,800 $25,800 $29,100 $29,100 $25,800 $25,900 $25,950 $25,950 $25,950 $26,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 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500
Bill Payments $593 $17,842 $19,558 $19,573 $19,946 $37,411 $20,952 $6,730 $16,371 $19,625 $19,376 $19,377
Subtotal Spent on Operations $6,093 $23,342 $25,058 $25,073 $25,446 $42,911 $26,452 $12,230 $21,871 $25,125 $24,876 $24,877
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,188 $2,188 $2,188 $2,188 $2,188 $2,188 $2,188 $2,188 $2,188 $2,188 $2,188 $2,188
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 $8,280 $25,529 $27,246 $27,261 $27,633 $45,099 $28,640 $14,417 $24,059 $27,313 $27,063 $27,065
Net Cash Flow $17,420 $221 ($1,446) ($1,461) $1,467 ($15,999) ($2,840) $11,483 $1,891 ($1,363) ($1,113) ($1,065)
Cash Balance $48,470 $48,691 $47,245 $45,784 $47,251 $31,252 $28,412 $39,895 $41,786 $40,424 $39,310 $38,246
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 $31,050 $48,470 $48,691 $47,245 $45,784 $47,251 $31,252 $28,412 $39,895 $41,786 $40,424 $39,310 $38,246
Inventory $130,000 $128,500 $128,750 $129,000 $129,000 $145,500 $145,500 $132,600 $129,500 $129,750 $129,750 $129,750 $130,000
Other Current Assets $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000 $26,000
Total Current Assets $187,050 $202,970 $203,441 $202,245 $200,784 $218,751 $202,752 $187,012 $195,395 $197,536 $196,174 $195,060 $194,246
Long-term Assets
Long-term Assets $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000
Total Assets $227,050 $242,970 $243,441 $242,245 $240,784 $258,751 $242,752 $227,012 $235,395 $237,536 $236,174 $235,060 $234,246
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 $17,190 $18,905 $18,929 $18,680 $36,696 $20,739 $6,188 $15,717 $18,979 $18,730 $18,723 $18,988
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 $17,190 $18,905 $18,929 $18,680 $36,696 $20,739 $6,188 $15,717 $18,979 $18,730 $18,723 $18,988
Long-term Liabilities $210,000 $207,813 $205,625 $203,438 $201,250 $199,063 $196,875 $194,688 $192,500 $190,313 $188,125 $185,938 $183,750
Total Liabilities $210,000 $225,002 $224,530 $222,367 $219,930 $235,759 $217,614 $200,876 $208,217 $209,292 $206,855 $204,660 $202,738
Paid-in Capital $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000
Retained Earnings ($27,950) ($27,950) ($27,950) ($27,950) ($27,950) ($27,950) ($27,950) ($27,950) ($27,950) ($27,950) ($27,950) ($27,950) ($27,950)
Earnings $0 $918 $1,860 $2,828 $3,804 $5,942 $8,088 $9,087 $10,128 $11,195 $12,269 $13,350 $14,457
Total Capital $17,050 $17,968 $18,910 $19,878 $20,854 $22,992 $25,138 $26,137 $27,178 $28,245 $29,319 $30,400 $31,507
Total Liabilities and Capital $227,050 $242,970 $243,441 $242,245 $240,784 $258,751 $242,752 $227,012 $235,395 $237,536 $236,174 $235,060 $234,246
Net Worth $17,050 $17,968 $18,910 $19,878 $20,854 $22,992 $25,138 $26,137 $27,178 $28,245 $29,319 $30,400 $31,507