Independent Choice Flicks
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 | |||||||||||||
Under 30 | 0% | $0 | $0 | $3,500 | $3,954 | $4,315 | $4,998 | $5,621 | $6,174 | $6,825 | $8,154 | $9,198 | $10,554 |
Over 30 | 0% | $0 | $0 | $3,200 | $3,552 | $3,845 | $4,085 | $4,310 | $4,887 | $5,287 | $6,845 | $7,425 | $7,754 |
Total Sales | $0 | $0 | $6,700 | $7,506 | $8,160 | $9,083 | $9,931 | $11,061 | $12,112 | $14,999 | $16,623 | $18,308 | |
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 | |
Under 30 | $0 | $0 | $1,225 | $1,384 | $1,510 | $1,749 | $1,967 | $2,161 | $2,389 | $2,854 | $3,219 | $3,694 | |
Over 30 | $0 | $0 | $1,120 | $1,243 | $1,346 | $1,430 | $1,509 | $1,710 | $1,850 | $2,396 | $2,599 | $2,714 | |
Subtotal Direct Cost of Sales | $0 | $0 | $2,345 | $2,627 | $2,856 | $3,179 | $3,476 | $3,871 | $4,239 | $5,250 | $5,818 | $6,408 |
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 | ||
Janet | 0% | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Part-time employee | 0% | $0 | $0 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 |
Part-time employee | 0% | $0 | $0 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 |
Part-time employee | 0% | $0 | $0 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 |
Full-time employee | 0% | $0 | $0 | $0 | $0 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 |
Total People | 1 | 1 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
Total Payroll | $2,000 | $2,000 | $4,700 | $4,700 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 |
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% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | $0 | $0 | $6,700 | $7,506 | $8,160 | $9,083 | $9,931 | $11,061 | $12,112 | $14,999 | $16,623 | $18,308 | |
Direct Cost of Sales | $0 | $0 | $2,345 | $2,627 | $2,856 | $3,179 | $3,476 | $3,871 | $4,239 | $5,250 | $5,818 | $6,408 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $2,345 | $2,627 | $2,856 | $3,179 | $3,476 | $3,871 | $4,239 | $5,250 | $5,818 | $6,408 | |
Gross Margin | $0 | $0 | $4,355 | $4,879 | $5,304 | $5,904 | $6,455 | $7,190 | $7,873 | $9,749 | $10,805 | $11,900 | |
Gross Margin % | 0.00% | 0.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | |
Expenses | |||||||||||||
Payroll | $2,000 | $2,000 | $4,700 | $4,700 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | |
Sales and Marketing and Other Expenses | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Depreciation | $256 | $256 | $256 | $256 | $256 | $256 | $256 | $256 | $256 | $256 | $256 | $256 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Insurance | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Rent | $850 | $850 | $850 | $850 | $850 | $850 | $850 | $850 | $850 | $850 | $850 | $850 | |
Payroll Taxes | 15% | $300 | $300 | $705 | $705 | $975 | $975 | $975 | $975 | $975 | $975 | $975 | $975 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $3,906 | $3,906 | $7,011 | $7,011 | $9,081 | $9,081 | $9,081 | $9,081 | $9,081 | $9,081 | $9,081 | $9,081 | |
Profit Before Interest and Taxes | ($3,906) | ($3,906) | ($2,656) | ($2,132) | ($3,777) | ($3,177) | ($2,626) | ($1,891) | ($1,208) | $668 | $1,724 | $2,819 | |
EBITDA | ($3,650) | ($3,650) | ($2,400) | ($1,876) | ($3,521) | ($2,921) | ($2,370) | ($1,635) | ($952) | $924 | $1,980 | $3,075 | |
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 Profit | ($3,906) | ($3,906) | ($2,656) | ($2,132) | ($3,777) | ($3,177) | ($2,626) | ($1,891) | ($1,208) | $668 | $1,724 | $2,819 | |
Net Profit/Sales | 0.00% | 0.00% | -39.64% | -28.41% | -46.29% | -34.98% | -26.44% | -17.10% | -9.98% | 4.46% | 10.37% | 15.40% |
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 | $0 | $0 | $6,700 | $7,506 | $8,160 | $9,083 | $9,931 | $11,061 | $12,112 | $14,999 | $16,623 | $18,308 | |
Subtotal Cash from Operations | $0 | $0 | $6,700 | $7,506 | $8,160 | $9,083 | $9,931 | $11,061 | $12,112 | $14,999 | $16,623 | $18,308 | |
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 | $0 | $0 | $6,700 | $7,506 | $8,160 | $9,083 | $9,931 | $11,061 | $12,112 | $14,999 | $16,623 | $18,308 | |
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 | $2,000 | $2,000 | $4,700 | $4,700 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | |
Bill Payments | $55 | $1,650 | $1,828 | $6,913 | $5,007 | $5,447 | $5,868 | $6,144 | $6,643 | $7,026 | $8,689 | $8,789 | |
Subtotal Spent on Operations | $2,055 | $3,650 | $6,528 | $11,613 | $11,507 | $11,947 | $12,368 | $12,644 | $13,143 | $13,526 | $15,189 | $15,289 | |
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 | $2,055 | $3,650 | $6,528 | $11,613 | $11,507 | $11,947 | $12,368 | $12,644 | $13,143 | $13,526 | $15,189 | $15,289 | |
Net Cash Flow | ($2,055) | ($3,650) | $172 | ($4,107) | ($3,347) | ($2,864) | ($2,437) | ($1,583) | ($1,031) | $1,473 | $1,434 | $3,019 | |
Cash Balance | $26,745 | $23,095 | $23,267 | $19,160 | $15,813 | $12,949 | $10,512 | $8,929 | $7,898 | $9,371 | $10,805 | $13,824 |
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 | $28,800 | $26,745 | $23,095 | $23,267 | $19,160 | $15,813 | $12,949 | $10,512 | $8,929 | $7,898 | $9,371 | $10,805 | $13,824 |
Inventory | $0 | $0 | $0 | $2,580 | $2,890 | $3,142 | $3,497 | $3,823 | $4,258 | $4,663 | $5,775 | $6,400 | $7,049 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $28,800 | $26,745 | $23,095 | $25,847 | $22,050 | $18,955 | $16,446 | $14,335 | $13,187 | $12,561 | $15,145 | $17,205 | $20,873 |
Long-term Assets | |||||||||||||
Long-term Assets | $15,700 | $15,700 | $15,700 | $15,700 | $15,700 | $15,700 | $15,700 | $15,700 | $15,700 | $15,700 | $15,700 | $15,700 | $15,700 |
Accumulated Depreciation | $0 | $256 | $512 | $768 | $1,024 | $1,280 | $1,536 | $1,792 | $2,048 | $2,304 | $2,560 | $2,816 | $3,072 |
Total Long-term Assets | $15,700 | $15,444 | $15,188 | $14,932 | $14,676 | $14,420 | $14,164 | $13,908 | $13,652 | $13,396 | $13,140 | $12,884 | $12,628 |
Total Assets | $44,500 | $42,189 | $38,283 | $40,779 | $36,726 | $33,375 | $30,610 | $28,243 | $26,839 | $25,957 | $28,285 | $30,089 | $33,501 |
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 | $1,595 | $1,595 | $6,747 | $4,826 | $5,252 | $5,664 | $5,923 | $6,410 | $6,737 | $8,397 | $8,476 | $9,069 |
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 | $1,595 | $1,595 | $6,747 | $4,826 | $5,252 | $5,664 | $5,923 | $6,410 | $6,737 | $8,397 | $8,476 | $9,069 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $1,595 | $1,595 | $6,747 | $4,826 | $5,252 | $5,664 | $5,923 | $6,410 | $6,737 | $8,397 | $8,476 | $9,069 |
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 | ($500) | ($500) | ($500) | ($500) | ($500) | ($500) | ($500) | ($500) | ($500) | ($500) | ($500) | ($500) | ($500) |
Earnings | $0 | ($3,906) | ($7,812) | ($10,468) | ($12,600) | ($16,377) | ($19,554) | ($22,180) | ($24,071) | ($25,280) | ($24,611) | ($22,887) | ($20,068) |
Total Capital | $44,500 | $40,594 | $36,688 | $34,032 | $31,900 | $28,123 | $24,946 | $22,320 | $20,429 | $19,220 | $19,889 | $21,613 | $24,432 |
Total Liabilities and Capital | $44,500 | $42,189 | $38,283 | $40,779 | $36,726 | $33,375 | $30,610 | $28,243 | $26,839 | $25,957 | $28,285 | $30,089 | $33,501 |
Net Worth | $44,500 | $40,594 | $36,688 | $34,032 | $31,900 | $28,123 | $24,946 | $22,320 | $20,429 | $19,220 | $19,889 | $21,613 | $24,432 |