Glass Dreams

Start your own business plan »

Stained Glass Gallery Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Retail 0% $5,000 $6,000 $7,000 $8,000 $9,000 $10,000 $12,000 $12,000 $14,000 $14,000 $14,000 $14,000
Courses 0% $5,000 $5,000 $6,000 $7,000 $8,000 $8,000 $10,000 $10,000 $8,000 $8,000 $8,000 $6,000
Art Pieces 0% $9,000 $8,500 $8,000 $11,000 $13,000 $12,000 $10,000 $12,000 $7,000 $8,000 $10,000 $10,000
Total Sales $19,000 $19,500 $21,000 $26,000 $30,000 $30,000 $32,000 $34,000 $29,000 $30,000 $32,000 $30,000
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Retail $1,300 $1,600 $2,100 $3,000 $4,000 $4,000 $4,500 $4,500 $4,000 $4,200 $4,000 $3,300
Courses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Art Pieces $1,000 $1,500 $2,000 $2,500 $2,500 $2,500 $2,000 $2,500 $1,750 $2,000 $2,500 $2,500
Subtotal Direct Cost of Sales $2,300 $3,100 $4,100 $5,500 $6,500 $6,500 $6,500 $7,000 $5,750 $6,200 $6,500 $5,800
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Jan Primak 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
Retail Store Manager 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
Apprentices/Project Assistants (2) 0% $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Retail Staff (2) 0% $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200
Total People 5 5 5 5 5 5 5 5 5 5 5 5
Total Payroll $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900
General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $19,000 $19,500 $21,000 $26,000 $30,000 $30,000 $32,000 $34,000 $29,000 $30,000 $32,000 $30,000
Direct Cost of Sales $2,300 $3,100 $4,100 $5,500 $6,500 $6,500 $6,500 $7,000 $5,750 $6,200 $6,500 $5,800
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $2,300 $3,100 $4,100 $5,500 $6,500 $6,500 $6,500 $7,000 $5,750 $6,200 $6,500 $5,800
Gross Margin $16,700 $16,400 $16,900 $20,500 $23,500 $23,500 $25,500 $27,000 $23,250 $23,800 $25,500 $24,200
Gross Margin % 87.89% 84.10% 80.48% 78.85% 78.33% 78.33% 79.69% 79.41% 80.17% 79.33% 79.69% 80.67%
Expenses
Payroll $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900
Sales and Marketing and Other Expenses $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
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% $1,935 $1,935 $1,935 $1,935 $1,935 $1,935 $1,935 $1,935 $1,935 $1,935 $1,935 $1,935
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $18,735 $18,735 $18,735 $18,735 $18,735 $18,735 $18,735 $18,735 $18,735 $18,735 $18,735 $18,735
Profit Before Interest and Taxes ($2,035) ($2,335) ($1,835) $1,765 $4,765 $4,765 $6,765 $8,265 $4,515 $5,065 $6,765 $5,465
EBITDA ($2,035) ($2,335) ($1,835) $1,765 $4,765 $4,765 $6,765 $8,265 $4,515 $5,065 $6,765 $5,465
Interest Expense $409 $402 $394 $387 $379 $372 $364 $357 $349 $342 $334 $327
Taxes Incurred ($733) ($821) ($669) $413 $1,316 $1,318 $1,920 $2,373 $1,250 $1,417 $1,929 $1,541
Net Profit ($1,711) ($1,916) ($1,560) $965 $3,070 $3,075 $4,481 $5,536 $2,916 $3,306 $4,502 $3,597
Net Profit/Sales -9.00% -9.82% -7.43% 3.71% 10.23% 10.25% 14.00% 16.28% 10.06% 11.02% 14.07% 11.99%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $19,000 $19,500 $21,000 $26,000 $30,000 $30,000 $32,000 $34,000 $29,000 $30,000 $32,000 $30,000
Subtotal Cash from Operations $19,000 $19,500 $21,000 $26,000 $30,000 $30,000 $32,000 $34,000 $29,000 $30,000 $32,000 $30,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 $19,000 $19,500 $21,000 $26,000 $30,000 $30,000 $32,000 $34,000 $29,000 $30,000 $32,000 $30,000
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900 $12,900
Bill Payments $16,184 $5,508 $5,420 $5,596 $6,665 $7,530 $7,544 $8,134 $8,646 $11,118 $14,310 $14,855
Subtotal Spent on Operations $29,084 $18,408 $18,320 $18,496 $19,565 $20,430 $20,444 $21,034 $21,546 $24,018 $27,210 $27,755
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 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900
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 $29,984 $19,308 $19,220 $19,396 $20,465 $21,330 $21,344 $21,934 $22,446 $24,918 $28,110 $28,655
Net Cash Flow ($10,984) $192 $1,780 $6,604 $9,535 $8,670 $10,656 $12,066 $6,554 $5,082 $3,890 $1,345
Cash Balance $39,016 $39,209 $40,988 $47,592 $57,127 $65,797 $76,453 $88,518 $95,073 $100,154 $104,044 $105,389
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $50,000 $39,016 $39,209 $40,988 $47,592 $57,127 $65,797 $76,453 $88,518 $95,073 $100,154 $104,044 $105,389
Inventory $50,000 $47,700 $44,600 $40,500 $35,000 $28,500 $22,000 $15,500 $8,500 $6,325 $6,820 $7,150 $6,380
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $100,000 $86,716 $83,809 $81,488 $82,592 $85,627 $87,797 $91,953 $97,018 $101,398 $106,974 $111,194 $111,769
Long-term Assets
Long-term Assets $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Accumulated Depreciation $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Total Long-term Assets $17,000 $17,000 $17,000 $17,000 $17,000 $17,000 $17,000 $17,000 $17,000 $17,000 $17,000 $17,000 $17,000
Total Assets $117,000 $103,716 $100,809 $98,488 $99,592 $102,627 $104,797 $108,953 $114,018 $118,398 $123,974 $128,194 $128,769
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $16,000 $5,327 $5,235 $5,375 $6,414 $7,279 $7,274 $7,849 $8,279 $10,642 $13,812 $14,431 $12,309
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 $16,000 $5,327 $5,235 $5,375 $6,414 $7,279 $7,274 $7,849 $8,279 $10,642 $13,812 $14,431 $12,309
Long-term Liabilities $50,000 $49,100 $48,200 $47,300 $46,400 $45,500 $44,600 $43,700 $42,800 $41,900 $41,000 $40,100 $39,200
Total Liabilities $66,000 $54,427 $53,435 $52,675 $52,814 $52,779 $51,874 $51,549 $51,079 $52,542 $54,812 $54,531 $51,509
Paid-in Capital $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Retained Earnings $11,000 $51,000 $51,000 $51,000 $51,000 $51,000 $51,000 $51,000 $51,000 $51,000 $51,000 $51,000 $51,000
Earnings $40,000 ($1,711) ($3,627) ($5,187) ($4,222) ($1,152) $1,923 $6,404 $11,940 $14,856 $18,162 $22,664 $26,260
Total Capital $51,000 $49,289 $47,373 $45,813 $46,778 $49,848 $52,923 $57,404 $62,940 $65,856 $69,162 $73,664 $77,261
Total Liabilities and Capital $117,000 $103,716 $100,809 $98,488 $99,592 $102,627 $104,797 $108,953 $114,018 $118,398 $123,974 $128,194 $128,769
Net Worth $51,000 $49,289 $47,373 $45,813 $46,778 $49,848 $52,923 $57,404 $62,940 $65,856 $69,162 $73,664 $77,260