Hands On! Children's Art Museum
Appendix
Funding 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 | ||
Funding | |||||||||||||
Membership | 0% | $1,500 | $2,000 | $2,500 | $2,400 | $2,400 | $2,400 | $2,400 | $2,300 | $2,200 | $2,200 | $2,200 | $2,500 |
Admissions | 0% | $4,080 | $5,280 | $6,000 | $6,600 | $6,600 | $6,600 | $6,600 | $6,000 | $4,200 | $4,200 | $4,200 | $6,000 |
Culture Bugs/Art Colony/Apprentice | 0% | $2,600 | $2,800 | $3,000 | $4,533 | $4,533 | $4,533 | $4,533 | $4,533 | $3,200 | $3,200 | $3,200 | $4,533 |
Family Wkshp/Film & Concert Series | 0% | $205 | $505 | $205 | $505 | $205 | $505 | $205 | $505 | $205 | $505 | $205 | $505 |
Birthday Parties/Rentals | 0% | $0 | $275 | $275 | $275 | $275 | $275 | $275 | $275 | $275 | $275 | $275 | $275 |
Outreach Programs | 0% | $400 | $900 | $1,100 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,100 | $1,100 | $1,100 | $1,200 |
Curiosity Shop | 0% | $700 | $1,500 | $1,800 | $1,400 | $1,600 | $1,700 | $1,700 | $1,700 | $1,500 | $1,500 | $1,500 | $1,600 |
Foundation Grants | 0% | $0 | $0 | $10,000 | $0 | $10,000 | $0 | $0 | $10,000 | $0 | $10,000 | $0 | $10,000 |
Corporate Sponsorship | 0% | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
Annual Family Benefit/Events | 0% | $0 | $5,000 | $0 | $0 | $0 | $35,000 | $0 | $0 | $5,000 | $0 | $0 | $0 |
Affinity Campaigns | 0% | $0 | $300 | $400 | $0 | $500 | $500 | $0 | $500 | $500 | $0 | $500 | $500 |
Total Funding | $10,485 | $19,560 | $26,280 | $17,913 | $28,313 | $53,713 | $17,913 | $28,013 | $19,180 | $23,980 | $14,180 | $28,113 | |
Direct Cost of Funding | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Membership | $60 | $80 | $90 | $100 | $110 | $110 | $110 | $110 | $90 | $90 | $90 | $90 | |
Admissions | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Culture Bugs/Art Colony/Apprentice | $100 | $130 | $140 | $200 | $200 | $200 | $200 | $200 | $150 | $150 | $150 | $200 | |
Family Wkshp/Film & Concert Series | $25 | $275 | $25 | $275 | $25 | $275 | $25 | $275 | $25 | $275 | $25 | $275 | |
Birthday Parties/Rentals | $0 | $63 | $63 | $63 | $63 | $63 | $63 | $63 | $63 | $63 | $63 | $63 | |
Outreach Programs | $20 | $45 | $55 | $65 | $75 | $75 | $75 | $70 | $55 | $55 | $55 | $75 | |
Curiosity Shop | $350 | $750 | $900 | $700 | $800 | $850 | $850 | $850 | $750 | $750 | $750 | $800 | |
Foundation Grants | $15 | $15 | $15 | $15 | $15 | $15 | $15 | $15 | $15 | $15 | $15 | $15 | |
Corporate Sponsorship | $10 | $10 | $10 | $10 | $10 | $10 | $10 | $10 | $10 | $10 | $10 | $10 | |
Annual Family Benefit/Events | $0 | $500 | $0 | $0 | $0 | $2,500 | $0 | $0 | $500 | $0 | $0 | $0 | |
Affinity Campaigns | $0 | $5 | $5 | $0 | $5 | $5 | $0 | $5 | $5 | $0 | $5 | $5 | |
Subtotal Cost of Funding | $580 | $1,873 | $1,303 | $1,428 | $1,303 | $4,103 | $1,348 | $1,598 | $1,663 | $1,408 | $1,163 | $1,533 |
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 | ||
Directors | 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 |
Culture Bugs/Art Colony Coordinator | 0% | $0 | $0 | $0 | $720 | $720 | $720 | $720 | $720 | $720 | $720 | $720 | $720 |
Curator | 0% | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 |
Store Staff | 0% | $1,360 | $1,360 | $1,360 | $1,360 | $1,360 | $1,360 | $1,360 | $1,360 | $1,360 | $1,360 | $1,360 | $1,360 |
Junior Staff | 0% | $0 | $810 | $1,215 | $1,215 | $1,215 | $1,215 | $1,215 | $1,215 | $1,215 | $1,215 | $1,215 | $1,215 |
Senior Staff | 0% | $3,120 | $3,120 | $3,120 | $3,120 | $3,120 | $3,120 | $3,120 | $3,120 | $3,120 | $3,120 | $3,120 | $3,120 |
Total People | 10 | 12 | 13 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | |
Total Payroll | $12,580 | $13,390 | $13,795 | $14,515 | $14,515 | $14,515 | $14,515 | $14,515 | $14,515 | $14,515 | $14,515 | $14,515 |
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 | 6.50% | 6.50% | 6.50% | 6.50% | 6.50% | 6.50% | 6.50% | 6.50% | 6.50% | 6.50% | 6.50% | 6.50% | |
Long-term 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% | |
Tax Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Surplus and Deficit | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Funding | $10,485 | $19,560 | $26,280 | $17,913 | $28,313 | $53,713 | $17,913 | $28,013 | $19,180 | $23,980 | $14,180 | $28,113 | |
Direct Cost | $580 | $1,873 | $1,303 | $1,428 | $1,303 | $4,103 | $1,348 | $1,598 | $1,663 | $1,408 | $1,163 | $1,533 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Direct Cost | $580 | $1,873 | $1,303 | $1,428 | $1,303 | $4,103 | $1,348 | $1,598 | $1,663 | $1,408 | $1,163 | $1,533 | |
Gross Surplus | $9,905 | $17,687 | $24,977 | $16,485 | $27,010 | $49,610 | $16,565 | $26,415 | $17,517 | $22,572 | $13,017 | $26,580 | |
Gross Surplus % | 94.47% | 90.42% | 95.04% | 92.03% | 95.40% | 92.36% | 92.47% | 94.30% | 91.33% | 94.13% | 91.80% | 94.55% | |
Expenses | |||||||||||||
Payroll | $12,580 | $13,390 | $13,795 | $14,515 | $14,515 | $14,515 | $14,515 | $14,515 | $14,515 | $14,515 | $14,515 | $14,515 | |
Sales and Marketing and Other Expenses | $4,075 | $4,600 | $4,400 | $4,600 | $5,000 | $4,500 | $4,500 | $4,650 | $4,500 | $4,500 | $4,500 | $4,500 | |
Depreciation | $167 | $167 | $167 | $167 | $167 | $167 | $167 | $167 | $167 | $167 | $167 | $167 | |
Leased Equipment | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
Utilities | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | |
Insurance | $0 | $0 | $0 | $875 | $0 | $0 | $0 | $875 | $0 | $0 | $0 | $875 | |
Payroll Taxes | 15% | $1,887 | $2,009 | $2,069 | $2,177 | $2,177 | $2,177 | $2,177 | $2,177 | $2,177 | $2,177 | $2,177 | $2,177 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $19,959 | $21,416 | $21,681 | $23,584 | $23,109 | $22,609 | $22,609 | $23,634 | $22,609 | $22,609 | $22,609 | $23,484 | |
Surplus Before Interest and Taxes | ($10,054) | ($3,729) | $3,296 | ($7,099) | $3,901 | $27,001 | ($6,044) | $2,781 | ($5,092) | ($37) | ($9,592) | $3,096 | |
EBITDA | ($9,887) | ($3,562) | $3,463 | ($6,932) | $4,068 | $27,168 | ($5,877) | $2,948 | ($4,925) | $130 | ($9,425) | $3,263 | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Surplus | ($10,054) | ($3,729) | $3,296 | ($7,099) | $3,901 | $27,001 | ($6,044) | $2,781 | ($5,092) | ($37) | ($9,592) | $3,096 | |
Net Surplus/Funding | -95.89% | -19.06% | 12.54% | -39.63% | 13.78% | 50.27% | -33.74% | 9.93% | -26.55% | -0.16% | -67.65% | 11.01% |
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 Funding | $9,646 | $17,995 | $24,178 | $16,480 | $26,048 | $49,416 | $16,480 | $25,772 | $17,646 | $22,062 | $13,046 | $25,864 | |
Cash from Receivables | $0 | $28 | $863 | $1,583 | $2,080 | $1,461 | $2,333 | $4,202 | $1,460 | $2,217 | $1,547 | $1,892 | |
Subtotal Cash from Operations | $9,646 | $18,023 | $25,041 | $18,063 | $28,128 | $50,877 | $18,813 | $29,974 | $19,106 | $24,279 | $14,593 | $27,756 | |
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 | $9,646 | $18,023 | $25,041 | $18,063 | $28,128 | $50,877 | $18,813 | $29,974 | $19,106 | $24,279 | $14,593 | $27,756 | |
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,580 | $13,390 | $13,795 | $14,515 | $14,515 | $14,515 | $14,515 | $14,515 | $14,515 | $14,515 | $14,515 | $14,515 | |
Bill Payments | $240 | $7,334 | $10,800 | $8,767 | $10,125 | $9,777 | $14,871 | $7,995 | $9,918 | $8,929 | $8,978 | $8,984 | |
Subtotal Spent on Operations | $12,820 | $20,724 | $24,595 | $23,282 | $24,640 | $24,292 | $29,386 | $22,510 | $24,433 | $23,444 | $23,493 | $23,499 | |
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 | $12,820 | $20,724 | $24,595 | $23,282 | $24,640 | $24,292 | $29,386 | $22,510 | $24,433 | $23,444 | $23,493 | $23,499 | |
Net Cash Flow | ($3,174) | ($2,701) | $446 | ($5,219) | $3,488 | $26,585 | ($10,573) | $7,464 | ($5,328) | $835 | ($8,900) | $4,257 | |
Cash Balance | $21,826 | $19,125 | $19,571 | $14,351 | $17,839 | $44,424 | $33,851 | $41,315 | $35,987 | $36,822 | $27,922 | $32,179 |
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 | $25,000 | $21,826 | $19,125 | $19,571 | $14,351 | $17,839 | $44,424 | $33,851 | $41,315 | $35,987 | $36,822 | $27,922 | $32,179 |
Accounts Receivable | $0 | $839 | $2,376 | $3,615 | $3,465 | $3,650 | $6,487 | $5,587 | $3,626 | $3,701 | $3,402 | $2,989 | $3,346 |
Inventory | $1,500 | $920 | $2,060 | $1,757 | $1,571 | $1,433 | $4,513 | $3,165 | $2,567 | $1,904 | $1,549 | $1,386 | $1,686 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $26,500 | $23,585 | $23,561 | $24,943 | $19,388 | $22,923 | $55,424 | $42,603 | $47,509 | $41,592 | $41,773 | $32,297 | $37,211 |
Long-term Assets | |||||||||||||
Long-term Assets | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 |
Accumulated Depreciation | $0 | $167 | $334 | $501 | $668 | $835 | $1,002 | $1,169 | $1,336 | $1,503 | $1,670 | $1,837 | $2,004 |
Total Long-term Assets | $8,500 | $8,333 | $8,166 | $7,999 | $7,832 | $7,665 | $7,498 | $7,331 | $7,164 | $6,997 | $6,830 | $6,663 | $6,496 |
Total Assets | $35,000 | $31,918 | $31,727 | $32,942 | $27,220 | $30,588 | $62,922 | $49,934 | $54,673 | $48,589 | $48,603 | $38,960 | $43,707 |
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 | $6,972 | $10,509 | $8,429 | $9,806 | $9,273 | $14,607 | $7,663 | $9,621 | $8,630 | $8,680 | $8,630 | $10,281 |
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 | $6,972 | $10,509 | $8,429 | $9,806 | $9,273 | $14,607 | $7,663 | $9,621 | $8,630 | $8,680 | $8,630 | $10,281 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $6,972 | $10,509 | $8,429 | $9,806 | $9,273 | $14,607 | $7,663 | $9,621 | $8,630 | $8,680 | $8,630 | $10,281 |
Paid-in Capital | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 |
Accumulated Surplus/Deficit | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) |
Surplus/Deficit | $0 | ($10,054) | ($13,783) | ($10,487) | ($17,586) | ($13,685) | $13,316 | $7,271 | $10,052 | $4,960 | $4,923 | ($4,670) | ($1,574) |
Total Capital | $35,000 | $24,946 | $21,218 | $24,513 | $17,414 | $21,315 | $48,316 | $42,271 | $45,052 | $39,960 | $39,923 | $30,330 | $33,426 |
Total Liabilities and Capital | $35,000 | $31,918 | $31,727 | $32,942 | $27,220 | $30,588 | $62,922 | $49,934 | $54,673 | $48,589 | $48,603 | $38,960 | $43,707 |
Net Worth | $35,000 | $24,946 | $21,217 | $24,513 | $17,414 | $21,315 | $48,315 | $42,271 | $45,052 | $39,960 | $39,922 | $30,330 | $33,426 |