Miami Beach Film Society
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 | |||||||||||||
Ticket Sales | 0% | $0 | $3,000 | $3,000 | $3,500 | $3,500 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 |
Memberships | 0% | $1,000 | $800 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $200 | $100 | $200 |
Concession Sales | 0% | $0 | $1,000 | $1,000 | $2,000 | $2,300 | $2,300 | $2,400 | $2,400 | $2,500 | $2,500 | $2,500 | $2,500 |
Bookstore Sales | 0% | $0 | $500 | $500 | $800 | $800 | $800 | $800 | $800 | $800 | $700 | $800 | $700 |
Internet/LD Telephone Service Sales | 0% | $0 | $300 | $300 | $400 | $400 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
Gallery Sales | 0% | $0 | $500 | $500 | $600 | $600 | $800 | $800 | $800 | $800 | $700 | $600 | $600 |
Online Store Sales | 0% | $0 | $0 | $0 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
Meeting Space Sales | 0% | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Other Fundraising | 0% | $0 | $0 | $0 | $0 | $0 | $5,000 | $0 | $0 | $0 | $0 | $2,000 | $0 |
Miami Beach Grants | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Miami-Dade Grants | 0% | $0 | $0 | $0 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
State of Florida Grants | 0% | $0 | $0 | $0 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
Merchandise Sales | 0% | $0 | $300 | $400 | $400 | $400 | $400 | $400 | $400 | $500 | $400 | $300 | $500 |
Sponsorships | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,000 | $0 |
On-screen Advertising | 0% | $0 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
MB Newsreels Product Placement | 0% | $0 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
Donated Items (Books, etc.) | 0% | $0 | $0 | $200 | $0 | $0 | $100 | $100 | $0 | $110 | $100 | $0 | $100 |
Total Funding | $1,000 | $9,400 | $9,300 | $12,600 | $12,900 | $18,800 | $13,900 | $13,800 | $14,110 | $13,600 | $16,300 | $13,600 | |
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 | |
Ticket Sales | $0 | $1,500 | $1,500 | $1,750 | $1,750 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Memberships | $10 | $10 | $10 | $10 | $10 | $10 | $10 | $10 | $10 | $10 | $10 | $10 | |
Concession Sales | $0 | $500 | $500 | $1,000 | $1,150 | $1,150 | $1,200 | $1,200 | $1,250 | $1,250 | $1,250 | $1,250 | |
Bookstore Sales | $0 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Internet/LD Telephone Service Sales | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Gallery Sales | $0 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Online Store Sales | $0 | $100 | $100 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Meeting Space Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Fundraising | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Miami Beach Grants | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
Miami-Dade Grants | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
State of Florida Grants | $0 | $0 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
Merchandise Sales | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Sponsorships | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
On-screen Advertising | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
MB Newsreels Product Placement | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Donated Items (Books, etc.) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cost of Funding | $510 | $2,960 | $3,010 | $3,860 | $4,010 | $4,260 | $4,310 | $4,310 | $4,360 | $4,360 | $4,360 | $4,360 |
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 | ||
Payroll | 0% | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,500 | $1,500 | $1,500 | $2,000 | $2,000 | $2,000 | $2,000 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
Total Payroll | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,500 | $1,500 | $1,500 | $2,000 | $2,000 | $2,000 | $2,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 | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.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 | 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 | $1,000 | $9,400 | $9,300 | $12,600 | $12,900 | $18,800 | $13,900 | $13,800 | $14,110 | $13,600 | $16,300 | $13,600 | |
Direct Cost | $510 | $2,960 | $3,010 | $3,860 | $4,010 | $4,260 | $4,310 | $4,310 | $4,360 | $4,360 | $4,360 | $4,360 | |
Other Ticket Sales > Accompaniment | $0 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | |
Other Ticket Sales > Shipment | $0 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Other Ticket Sales > Ticket Printing | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
Other Production Expenses | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Total Direct Cost | $660 | $3,960 | $4,010 | $4,860 | $5,010 | $5,260 | $5,310 | $5,310 | $5,360 | $5,360 | $5,360 | $5,360 | |
Gross Surplus | $340 | $5,440 | $5,290 | $7,740 | $7,890 | $13,540 | $8,590 | $8,490 | $8,750 | $8,240 | $10,940 | $8,240 | |
Gross Surplus % | 34.00% | 57.87% | 56.88% | 61.43% | 61.16% | 72.02% | 61.80% | 61.52% | 62.01% | 60.59% | 67.12% | 60.59% | |
Expenses | |||||||||||||
Payroll | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,500 | $1,500 | $1,500 | $2,000 | $2,000 | $2,000 | $2,000 | |
Sales and Marketing and Other Expenses | $1,675 | $1,375 | $1,575 | $1,575 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Operations Expenses 1 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Operations Expenses 2 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
Operations Expenses 3 | $100 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $150 | $150 | $150 | $150 | |
Flood/Wind Insurance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $25 | $25 | $25 | $25 | |
Fire/Theft Alarm | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Liability/Theft/Fire Insurance | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Rent | $0 | $2,742 | $2,742 | $2,742 | $2,742 | $2,742 | $2,742 | $2,742 | $2,742 | $2,742 | $2,742 | $2,742 | |
Payroll Taxes | 15% | $0 | $150 | $150 | $150 | $150 | $225 | $225 | $225 | $300 | $300 | $300 | $300 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $2,175 | $5,792 | $5,992 | $5,992 | $6,017 | $6,592 | $6,592 | $6,592 | $7,217 | $7,217 | $7,217 | $7,217 | |
Surplus Before Interest and Taxes | ($1,835) | ($352) | ($702) | $1,748 | $1,873 | $6,948 | $1,998 | $1,898 | $1,533 | $1,023 | $3,723 | $1,023 | |
EBITDA | ($1,835) | ($352) | ($702) | $1,748 | $1,873 | $6,948 | $1,998 | $1,898 | $1,533 | $1,023 | $3,723 | $1,023 | |
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 | ($1,835) | ($352) | ($702) | $1,748 | $1,873 | $6,948 | $1,998 | $1,898 | $1,533 | $1,023 | $3,723 | $1,023 | |
Net Surplus/Funding | -183.50% | -3.74% | -7.54% | 13.88% | 14.52% | 36.96% | 14.38% | 13.75% | 10.86% | 7.52% | 22.84% | 7.52% |
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 | $920 | $8,648 | $8,556 | $11,592 | $11,868 | $17,296 | $12,788 | $12,696 | $12,981 | $12,512 | $14,996 | $12,512 | |
Cash from Receivables | $0 | $3 | $102 | $752 | $753 | $1,009 | $1,048 | $1,491 | $1,112 | $1,105 | $1,127 | $1,095 | |
Subtotal Cash from Operations | $920 | $8,651 | $8,658 | $12,344 | $12,621 | $18,305 | $13,836 | $14,187 | $14,093 | $13,617 | $16,123 | $13,607 | |
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 | $920 | $8,651 | $8,658 | $12,344 | $12,621 | $18,305 | $13,836 | $14,187 | $14,093 | $13,617 | $16,123 | $13,607 | |
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 | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,500 | $1,500 | $1,500 | $2,000 | $2,000 | $2,000 | $2,000 | |
Bill Payments | $113 | $3,664 | $11,367 | $9,114 | $10,767 | $10,206 | $10,621 | $10,455 | $10,410 | $10,630 | $10,577 | $10,577 | |
Subtotal Spent on Operations | $113 | $4,664 | $12,367 | $10,114 | $11,767 | $11,706 | $12,121 | $11,955 | $12,410 | $12,630 | $12,577 | $12,577 | |
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 | $113 | $4,664 | $12,367 | $10,114 | $11,767 | $11,706 | $12,121 | $11,955 | $12,410 | $12,630 | $12,577 | $12,577 | |
Net Cash Flow | $807 | $3,986 | ($3,709) | $2,229 | $854 | $6,599 | $1,715 | $2,232 | $1,683 | $987 | $3,546 | $1,030 | |
Cash Balance | $17,498 | $21,485 | $17,776 | $20,006 | $20,860 | $27,458 | $29,173 | $31,405 | $33,088 | $34,075 | $37,621 | $38,652 |
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 | $16,692 | $17,498 | $21,485 | $17,776 | $20,006 | $20,860 | $27,458 | $29,173 | $31,405 | $33,088 | $34,075 | $37,621 | $38,652 |
Accounts Receivable | $0 | $80 | $829 | $1,471 | $1,727 | $2,006 | $2,502 | $2,566 | $2,179 | $2,196 | $2,179 | $2,356 | $2,349 |
Inventory | $0 | $561 | $3,256 | $3,311 | $4,246 | $4,411 | $4,686 | $4,741 | $4,741 | $4,796 | $4,796 | $4,796 | $4,796 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $16,692 | $18,139 | $25,570 | $22,558 | $25,979 | $27,277 | $34,646 | $36,480 | $38,325 | $40,080 | $41,050 | $44,773 | $45,796 |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total 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 |
Total Assets | $26,692 | $28,139 | $35,570 | $32,558 | $35,979 | $37,277 | $44,646 | $46,480 | $48,325 | $50,080 | $51,050 | $54,773 | $55,796 |
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,283 | $11,065 | $8,755 | $10,427 | $9,852 | $10,272 | $10,108 | $10,055 | $10,278 | $10,224 | $10,224 | $10,224 |
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,283 | $11,065 | $8,755 | $10,427 | $9,852 | $10,272 | $10,108 | $10,055 | $10,278 | $10,224 | $10,224 | $10,224 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $3,283 | $11,065 | $8,755 | $10,427 | $9,852 | $10,272 | $10,108 | $10,055 | $10,278 | $10,224 | $10,224 | $10,224 |
Paid-in Capital | $44,000 | $44,000 | $44,000 | $44,000 | $44,000 | $44,000 | $44,000 | $44,000 | $44,000 | $44,000 | $44,000 | $44,000 | $44,000 |
Accumulated Surplus/Deficit | ($17,308) | ($17,308) | ($17,308) | ($17,308) | ($17,308) | ($17,308) | ($17,308) | ($17,308) | ($17,308) | ($17,308) | ($17,308) | ($17,308) | ($17,308) |
Surplus/Deficit | $0 | ($1,835) | ($2,187) | ($2,888) | ($1,140) | $733 | $7,682 | $9,680 | $11,578 | $13,111 | $14,134 | $17,857 | $18,880 |
Total Capital | $26,692 | $24,857 | $24,505 | $23,803 | $25,552 | $27,425 | $34,373 | $36,372 | $38,270 | $39,803 | $40,826 | $44,549 | $45,572 |
Total Liabilities and Capital | $26,692 | $28,139 | $35,570 | $32,558 | $35,979 | $37,277 | $44,646 | $46,480 | $48,325 | $50,080 | $51,050 | $54,773 | $55,796 |
Net Worth | $26,692 | $24,857 | $24,505 | $23,803 | $25,552 | $27,425 | $34,373 | $36,372 | $38,270 | $39,803 | $40,826 | $44,549 | $45,572 |