| 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 | |||||||||||||
| Private | 0% | $12,860 | $10,966 | $11,435 | $12,889 | $13,001 | $15,777 | $15,998 | $24,960 | $26,522 | $20,009 | $19,650 | $22,103 |
| Public | 0% | $3,852 | $7,884 | $7,200 | $8,965 | $8,566 | $7,600 | $9,705 | $11,245 | $11,780 | $11,999 | $12,300 | $12,089 |
| Other | 0% | $800 | $955 | $900 | $1,190 | $2,450 | $2,133 | $2,100 | $4,656 | $4,500 | $4,622 | $4,800 | $4,688 |
| Total Sales | $17,512 | $19,805 | $19,535 | $23,044 | $24,017 | $25,510 | $27,803 | $40,861 | $42,802 | $36,630 | $36,750 | $38,880 | |
| 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 | |
| Private | $1,800 | $1,535 | $1,601 | $1,804 | $1,820 | $2,209 | $2,240 | $3,494 | $3,713 | $2,801 | $2,751 | $3,094 | |
| Public | $385 | $788 | $720 | $897 | $857 | $760 | $971 | $1,125 | $1,178 | $1,200 | $1,230 | $1,209 | |
| Other | $40 | $48 | $45 | $60 | $123 | $107 | $105 | $233 | $225 | $231 | $240 | $234 | |
| Subtotal Direct Cost of Sales | $2,226 | $2,371 | $2,366 | $2,760 | $2,799 | $3,075 | $3,315 | $4,852 | $5,116 | $4,232 | $4,221 | $4,538 | |
| 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 | ||
| Event Specialist | 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 |
| Site Manager | 0% | $735 | $907 | $735 | $735 | $735 | $735 | $1,245 | $1,400 | $1,245 | $875 | $875 | $875 |
| Other | 0% | $586 | $800 | $586 | $586 | $586 | $586 | $844 | $895 | $844 | $844 | $895 | $895 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | $4,321 | $4,707 | $4,321 | $4,321 | $4,321 | $4,321 | $5,089 | $5,295 | $5,089 | $4,719 | $4,770 | $4,770 | |
| 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 | $17,512 | $19,805 | $19,535 | $23,044 | $24,017 | $25,510 | $27,803 | $40,861 | $42,802 | $36,630 | $36,750 | $38,880 | |
| Direct Cost of Sales | $2,226 | $2,371 | $2,366 | $2,760 | $2,799 | $3,075 | $3,315 | $4,852 | $5,116 | $4,232 | $4,221 | $4,538 | |
| Other Costs of Sales | $15 | $13 | $15 | $16 | $16 | $16 | $19 | $22 | $22 | $13 | $15 | $14 | |
| Total Cost of Sales | $2,241 | $2,384 | $2,381 | $2,776 | $2,815 | $3,091 | $3,334 | $4,874 | $5,138 | $4,245 | $4,236 | $4,552 | |
| Gross Margin | $15,271 | $17,421 | $17,154 | $20,268 | $21,202 | $22,419 | $24,469 | $35,987 | $37,664 | $32,385 | $32,514 | $34,328 | |
| Gross Margin % | 87.21% | 87.96% | 87.81% | 87.95% | 88.28% | 87.88% | 88.01% | 88.07% | 88.00% | 88.41% | 88.47% | 88.29% | |
| Expenses | |||||||||||||
| Payroll | $4,321 | $4,707 | $4,321 | $4,321 | $4,321 | $4,321 | $5,089 | $5,295 | $5,089 | $4,719 | $4,770 | $4,770 | |
| Sales & Marketing & Other Expenses | $9,015 | $10,748 | $9,982 | $10,260 | $10,315 | $10,415 | $12,418 | $18,015 | $16,615 | $13,290 | $11,975 | $12,965 | |
| 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 | $43 | $43 | $43 | $43 | $43 | $43 | $43 | $43 | $43 | $43 | $43 | $43 | |
| Insurance | $22 | $22 | $22 | $22 | $22 | $22 | $22 | $22 | $22 | $22 | $22 | $22 | |
| Rent | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | |
| Payroll Taxes | 12% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $13,521 | $15,640 | $14,488 | $14,766 | $14,821 | $14,921 | $17,692 | $23,495 | $21,889 | $18,194 | $16,930 | $17,920 | |
| Profit Before Interest and Taxes | $1,750 | $1,781 | $2,666 | $5,502 | $6,381 | $7,498 | $6,777 | $12,492 | $15,775 | $14,191 | $15,584 | $16,408 | |
| EBITDA | $1,750 | $1,781 | $2,666 | $5,502 | $6,381 | $7,498 | $6,777 | $12,492 | $15,775 | $14,191 | $15,584 | $16,408 | |
| Interest Expense | $17 | $50 | $47 | $44 | $41 | $38 | $35 | $33 | $30 | $27 | $24 | $21 | |
| Taxes Incurred | $416 | $415 | $629 | $1,310 | $1,521 | $1,790 | $1,618 | $2,990 | $3,779 | $3,399 | $3,734 | $3,933 | |
| Net Profit | $1,318 | $1,315 | $1,990 | $4,148 | $4,818 | $5,669 | $5,123 | $9,469 | $11,966 | $10,765 | $11,826 | $12,454 | |
| Net Profit/Sales | 7.52% | 6.64% | 10.19% | 18.00% | 20.06% | 22.22% | 18.43% | 23.17% | 27.96% | 29.39% | 32.18% | 32.03% | |
| 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 | $7,005 | $7,922 | $7,814 | $9,218 | $9,607 | $10,204 | $11,121 | $16,344 | $17,121 | $14,652 | $14,700 | $15,552 | |
| Cash from Receivables | $0 | $5,604 | $11,241 | $11,797 | $12,844 | $14,138 | $14,888 | $16,040 | $20,860 | $25,138 | $23,706 | $22,016 | |
| Subtotal Cash from Operations | $7,005 | $13,526 | $19,055 | $21,014 | $22,451 | $24,342 | $26,009 | $32,384 | $37,981 | $39,790 | $38,406 | $37,568 | |
| 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 | $4,000 | $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 | $7,005 | $17,526 | $19,055 | $21,014 | $22,451 | $24,342 | $26,009 | $32,384 | $37,981 | $39,790 | $38,406 | $37,568 | |
| 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 | $4,321 | $4,707 | $4,321 | $4,321 | $4,321 | $4,321 | $5,089 | $5,295 | $5,089 | $4,719 | $4,770 | $4,770 | |
| Bill Payments | $477 | $14,309 | $13,919 | $13,277 | $15,006 | $14,951 | $15,891 | $18,185 | $27,728 | $25,842 | $20,173 | $20,204 | |
| Subtotal Spent on Operations | $4,798 | $19,016 | $18,240 | $17,598 | $19,327 | $19,272 | $20,980 | $23,480 | $32,817 | $30,561 | $24,943 | $24,974 | |
| 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 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
| 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 | $4,798 | $19,016 | $18,590 | $17,948 | $19,677 | $19,622 | $21,330 | $23,830 | $33,167 | $30,911 | $25,293 | $25,324 | |
| Net Cash Flow | $2,206 | ($1,490) | $465 | $3,066 | $2,773 | $4,720 | $4,679 | $8,554 | $4,814 | $8,879 | $13,113 | $12,245 | |
| Cash Balance | $4,506 | $3,016 | $3,481 | $6,547 | $9,321 | $14,041 | $18,719 | $27,273 | $32,087 | $40,966 | $54,079 | $66,323 | |
| 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 | $2,300 | $4,506 | $3,016 | $3,481 | $6,547 | $9,321 | $14,041 | $18,719 | $27,273 | $32,087 | $40,966 | $54,079 | $66,323 |
| Accounts Receivable | $0 | $10,507 | $16,786 | $17,266 | $19,296 | $20,863 | $22,031 | $23,825 | $32,301 | $37,122 | $33,963 | $32,306 | $33,618 |
| Inventory | $0 | $2,448 | $2,609 | $2,602 | $3,037 | $3,079 | $3,383 | $3,647 | $5,337 | $5,628 | $4,655 | $4,643 | $4,991 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $2,300 | $17,462 | $22,411 | $23,350 | $28,880 | $33,262 | $39,454 | $46,191 | $64,911 | $74,837 | $79,584 | $91,028 | $104,933 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Assets | $2,300 | $17,462 | $22,411 | $23,350 | $28,880 | $33,262 | $39,454 | $46,191 | $64,911 | $74,837 | $79,584 | $91,028 | $104,933 |
| 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 | $13,844 | $13,478 | $12,777 | $14,509 | $14,423 | $15,296 | $17,259 | $26,860 | $25,169 | $19,502 | $19,470 | $21,270 |
| Current Borrowing | $2,000 | $2,000 | $6,000 | $5,650 | $5,300 | $4,950 | $4,600 | $4,250 | $3,900 | $3,550 | $3,200 | $2,850 | $2,500 |
| Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Current Liabilities | $2,000 | $15,844 | $19,478 | $18,427 | $19,809 | $19,373 | $19,896 | $21,509 | $30,760 | $28,719 | $22,702 | $22,320 | $23,770 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $2,000 | $15,844 | $19,478 | $18,427 | $19,809 | $19,373 | $19,896 | $21,509 | $30,760 | $28,719 | $22,702 | $22,320 | $23,770 |
| Paid-in Capital | $3,665 | $3,665 | $3,665 | $3,665 | $3,665 | $3,665 | $3,665 | $3,665 | $3,665 | $3,665 | $3,665 | $3,665 | $3,665 |
| Retained Earnings | ($3,365) | ($3,365) | ($3,365) | ($3,365) | ($3,365) | ($3,365) | ($3,365) | ($3,365) | ($3,365) | ($3,365) | ($3,365) | ($3,365) | ($3,365) |
| Earnings | $0 | $1,318 | $2,633 | $4,623 | $8,771 | $13,589 | $19,258 | $24,381 | $33,851 | $45,817 | $56,582 | $68,408 | $80,862 |
| Total Capital | $300 | $1,618 | $2,933 | $4,923 | $9,071 | $13,889 | $19,558 | $24,681 | $34,151 | $46,117 | $56,882 | $68,708 | $81,162 |
| Total Liabilities and Capital | $2,300 | $17,462 | $22,411 | $23,350 | $28,880 | $33,262 | $39,454 | $46,191 | $64,911 | $74,837 | $79,584 | $91,028 | $104,933 |
| Net Worth | $300 | $1,618 | $2,933 | $4,923 | $9,071 | $13,889 | $19,558 | $24,681 | $34,151 | $46,117 | $56,882 | $68,708 | $81,162 |