ArtSphere

Start your own business plan »

Art School 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
Portrait Sales (HRN) 0% $650 $650 $650 $650 $650 $650 $650 $650 $650 $650 $650 $650
Artwork Sales (PN) 0% $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
School-aged Classes 0% $3,000 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600
Retired/non-work Classes 0% $0 $0 $0 $0 $0 $3,160 $3,160 $3,160 $3,160 $3,160 $3,160 $6,320
Evening/working Classes 0% $0 $0 $3,584 $3,584 $3,584 $3,584 $3,584 $3,584 $3,584 $3,584 $3,584 $3,584
Sale of Art Supplies 0% $0 $0 $640 $640 $640 $1,240 $1,240 $1,240 $2,140 $2,140 $2,140 $2,740
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $3,950 $4,550 $8,774 $8,774 $8,774 $12,534 $12,534 $12,534 $13,434 $13,434 $13,434 $17,194
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
Portrait Sales (HRN) $98 $98 $98 $98 $98 $98 $98 $98 $98 $98 $98 $98
Artwork Sales (PN) $45 $45 $45 $45 $45 $45 $45 $45 $45 $45 $45 $45
School-aged Classes $270 $270 $270 $270 $270 $270 $270 $270 $0 $0 $0 $0
Retired/non-work Classes $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Evening/working Classes $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sale of Art Supplies $0 $0 $448 $448 $448 $868 $868 $868 $1,498 $1,498 $1,498 $1,918
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $413 $413 $861 $861 $861 $1,281 $1,281 $1,281 $1,641 $1,641 $1,641 $2,061
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
Hannah 0% $0 $0 $500 $500 $1,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Paul 0% $1,000 $1,000 $1,000 $1,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $1,000 $1,000 $1,500 $1,500 $3,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,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% 35.00% 35.00% 35.00% 35.00% 35.00% 35.00% 35.00% 35.00% 35.00% 35.00% 35.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 $3,950 $4,550 $8,774 $8,774 $8,774 $12,534 $12,534 $12,534 $13,434 $13,434 $13,434 $17,194
Direct Cost of Sales $413 $413 $861 $861 $861 $1,281 $1,281 $1,281 $1,641 $1,641 $1,641 $2,061
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $413 $413 $861 $861 $861 $1,281 $1,281 $1,281 $1,641 $1,641 $1,641 $2,061
Gross Margin $3,538 $4,138 $7,914 $7,914 $7,914 $11,254 $11,254 $11,254 $11,794 $11,794 $11,794 $15,134
Gross Margin % 89.56% 90.93% 90.19% 90.19% 90.19% 89.78% 89.78% 89.78% 87.79% 87.79% 87.79% 88.02%
Expenses
Payroll $1,000 $1,000 $1,500 $1,500 $3,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Sales and Marketing and Other Expenses $400 $400 $400 $449 $1,593 $899 $899 $899 $2,043 $899 $899 $1,349
Depreciation $0 $172 $172 $172 $172 $172 $172 $172 $172 $172 $172 $172
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities (Gas & Elec.) $175 $175 $175 $175 $95 $75 $75 $75 $97 $175 $175 $175
Insurance $45 $45 $45 $45 $45 $45 $45 $45 $45 $45 $45 $45
Rent $1,225 $1,225 $1,225 $1,225 $1,225 $1,225 $1,225 $1,225 $1,225 $1,225 $1,225 $1,225
Payroll Taxes 15% $150 $150 $225 $225 $450 $600 $600 $600 $600 $600 $600 $600
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $2,995 $3,167 $3,742 $3,791 $6,580 $7,016 $7,016 $7,016 $8,182 $7,116 $7,116 $7,566
Profit Before Interest and Taxes $543 $971 $4,172 $4,123 $1,334 $4,238 $4,238 $4,238 $3,612 $4,678 $4,678 $7,568
EBITDA $543 $1,143 $4,344 $4,295 $1,506 $4,410 $4,410 $4,410 $3,784 $4,850 $4,850 $7,740
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $163 $340 $1,460 $1,443 $467 $1,483 $1,483 $1,483 $1,264 $1,637 $1,637 $2,649
Net Profit $380 $631 $2,711 $2,680 $867 $2,754 $2,754 $2,754 $2,347 $3,040 $3,040 $4,919
Net Profit/Sales 9.61% 13.86% 30.90% 30.54% 9.88% 21.98% 21.98% 21.98% 17.47% 22.63% 22.63% 28.61%
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 $3,950 $4,550 $8,774 $8,774 $8,774 $12,534 $12,534 $12,534 $13,434 $13,434 $13,434 $17,194
Subtotal Cash from Operations $3,950 $4,550 $8,774 $8,774 $8,774 $12,534 $12,534 $12,534 $13,434 $13,434 $13,434 $17,194
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 $3,950 $4,550 $8,774 $8,774 $8,774 $12,534 $12,534 $12,534 $13,434 $13,434 $13,434 $17,194
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 $1,000 $1,000 $1,500 $1,500 $3,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Bill Payments $105 $3,164 $3,375 $4,531 $4,572 $4,893 $5,429 $5,608 $5,664 $7,274 $6,222 $6,300
Subtotal Spent on Operations $1,105 $4,164 $4,875 $6,031 $7,572 $8,893 $9,429 $9,608 $9,664 $11,274 $10,222 $10,300
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 $1,105 $4,164 $4,875 $6,031 $7,572 $8,893 $9,429 $9,608 $9,664 $11,274 $10,222 $10,300
Net Cash Flow $2,845 $386 $3,899 $2,743 $1,202 $3,641 $3,105 $2,926 $3,770 $2,160 $3,212 $6,894
Cash Balance $2,845 $3,231 $7,131 $9,873 $11,075 $14,716 $17,821 $20,748 $24,517 $26,677 $29,889 $36,784
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 $0 $2,845 $3,231 $7,131 $9,873 $11,075 $14,716 $17,821 $20,748 $24,517 $26,677 $29,889 $36,784
Inventory $0 $588 $1,175 $1,315 $1,454 $1,594 $1,409 $1,409 $1,409 $1,805 $1,805 $1,805 $2,267
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $0 $3,432 $4,406 $8,445 $11,327 $12,669 $16,125 $19,230 $22,156 $26,322 $28,482 $31,694 $39,050
Long-term Assets
Long-term Assets $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200
Accumulated Depreciation $0 $0 $172 $344 $516 $688 $860 $1,032 $1,204 $1,376 $1,548 $1,720 $1,892
Total Long-term Assets $6,200 $6,200 $6,028 $5,856 $5,684 $5,512 $5,340 $5,168 $4,996 $4,824 $4,652 $4,480 $4,308
Total Assets $6,200 $9,632 $10,434 $14,301 $17,011 $18,181 $21,465 $24,398 $27,152 $31,146 $33,134 $36,174 $43,358
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 $3,052 $3,224 $4,379 $4,410 $4,712 $5,242 $5,421 $5,421 $7,067 $6,014 $6,014 $8,280
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 $3,052 $3,224 $4,379 $4,410 $4,712 $5,242 $5,421 $5,421 $7,067 $6,014 $6,014 $8,280
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $3,052 $3,224 $4,379 $4,410 $4,712 $5,242 $5,421 $5,421 $7,067 $6,014 $6,014 $8,280
Paid-in Capital $8,265 $8,265 $8,265 $8,265 $8,265 $8,265 $8,265 $8,265 $8,265 $8,265 $8,265 $8,265 $8,265
Retained Earnings ($2,065) ($2,065) ($2,065) ($2,065) ($2,065) ($2,065) ($2,065) ($2,065) ($2,065) ($2,065) ($2,065) ($2,065) ($2,065)
Earnings $0 $380 $1,011 $3,722 $6,402 $7,268 $10,023 $12,777 $15,532 $17,879 $20,919 $23,960 $28,879
Total Capital $6,200 $6,580 $7,211 $9,922 $12,602 $13,468 $16,223 $18,977 $21,732 $24,079 $27,119 $30,160 $35,079
Total Liabilities and Capital $6,200 $9,632 $10,434 $14,301 $17,011 $18,181 $21,465 $24,398 $27,152 $31,146 $33,134 $36,174 $43,358
Net Worth $6,200 $6,580 $7,211 $9,922 $12,602 $13,468 $16,223 $18,977 $21,732 $24,079 $27,119 $30,160 $35,079