PRfect Greens
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 | |||||||||||||
| Crisis management | 0% | $0 | $0 | $0 | $0 | $0 | $3,000 | $1,500 | $1,000 | $3,300 | $3,500 | $2,900 | $3,500 |
| Image management | 0% | $0 | $1,100 | $1,898 | $2,878 | $3,345 | $3,878 | $4,223 | $4,501 | $5,112 | $5,500 | $6,334 | $7,300 |
| Event management | 0% | $0 | $715 | $1,234 | $1,871 | $2,174 | $2,521 | $2,745 | $2,926 | $3,323 | $3,575 | $4,117 | $4,745 |
| Total Sales | $0 | $1,815 | $3,132 | $4,749 | $5,519 | $9,399 | $8,468 | $8,427 | $11,735 | $12,575 | $13,351 | $15,545 | |
| 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 | |
| Crisis management | $0 | $0 | $0 | $0 | $0 | $150 | $75 | $50 | $165 | $175 | $145 | $175 | |
| Image management | $0 | $55 | $95 | $144 | $167 | $194 | $211 | $225 | $256 | $275 | $317 | $365 | |
| Event management | $0 | $36 | $62 | $94 | $109 | $126 | $137 | $146 | $166 | $179 | $206 | $237 | |
| Subtotal Direct Cost of Sales | $0 | $91 | $157 | $237 | $276 | $470 | $423 | $421 | $587 | $629 | $668 | $777 | |
| 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 | ||
| Arbor | 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 |
| Birk | 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 |
| Administrative assistant | 0% | $0 | $0 | $0 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 |
| Total People | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | $8,000 | $8,000 | $8,000 | $8,960 | $8,960 | $8,960 | $8,960 | $8,960 | $8,960 | $8,960 | $8,960 | $8,960 | |
| 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% | 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 | |||||||||||||
| 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 | $1,815 | $3,132 | $4,749 | $5,519 | $9,399 | $8,468 | $8,427 | $11,735 | $12,575 | $13,351 | $15,545 | |
| Direct Cost of Sales | $0 | $91 | $157 | $237 | $276 | $470 | $423 | $421 | $587 | $629 | $668 | $777 | |
| Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $0 | $91 | $157 | $237 | $276 | $470 | $423 | $421 | $587 | $629 | $668 | $777 | |
| Gross Margin | $0 | $1,724 | $2,975 | $4,511 | $5,243 | $8,929 | $8,045 | $8,005 | $11,148 | $11,946 | $12,684 | $14,768 | |
| Gross Margin % | 0.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | |
| Expenses | |||||||||||||
| Payroll | $8,000 | $8,000 | $8,000 | $8,960 | $8,960 | $8,960 | $8,960 | $8,960 | $8,960 | $8,960 | $8,960 | $8,960 | |
| Sales and Marketing and Other Expenses | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
| Depreciation | $61 | $61 | $61 | $61 | $61 | $61 | $61 | $61 | $61 | $61 | $61 | $61 | |
| Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Utilities | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Insurance | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Rent | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
| Payroll Taxes | 15% | $1,200 | $1,200 | $1,200 | $1,344 | $1,344 | $1,344 | $1,344 | $1,344 | $1,344 | $1,344 | $1,344 | $1,344 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $10,311 | $10,311 | $10,311 | $11,415 | $11,415 | $11,415 | $11,415 | $11,415 | $11,415 | $11,415 | $11,415 | $11,415 | |
| Profit Before Interest and Taxes | ($10,311) | ($8,587) | ($7,336) | ($6,904) | ($6,172) | ($2,486) | ($3,370) | ($3,410) | ($267) | $531 | $1,269 | $3,353 | |
| EBITDA | ($10,250) | ($8,526) | ($7,275) | ($6,843) | ($6,111) | ($2,425) | ($3,309) | ($3,349) | ($206) | $592 | $1,330 | $3,414 | |
| 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 | ($10,311) | ($8,587) | ($7,336) | ($6,904) | ($6,172) | ($2,486) | ($3,370) | ($3,410) | ($267) | $531 | $1,269 | $3,353 | |
| Net Profit/Sales | 0.00% | -473.10% | -234.25% | -145.38% | -111.82% | -26.45% | -39.80% | -40.46% | -2.27% | 4.22% | 9.50% | 21.57% | |
| 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 | $635 | $1,096 | $1,662 | $1,932 | $3,290 | $2,964 | $2,949 | $4,107 | $4,401 | $4,673 | $5,441 | |
| Cash from Receivables | $0 | $0 | $39 | $1,208 | $2,071 | $3,103 | $3,672 | $6,089 | $5,503 | $5,549 | $7,646 | $8,191 | |
| Subtotal Cash from Operations | $0 | $635 | $1,135 | $2,870 | $4,002 | $6,393 | $6,635 | $9,038 | $9,610 | $9,950 | $12,319 | $13,631 | |
| 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 | $635 | $1,135 | $2,870 | $4,002 | $6,393 | $6,635 | $9,038 | $9,610 | $9,950 | $12,319 | $13,631 | |
| 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 | $8,000 | $8,000 | $8,000 | $8,960 | $8,960 | $8,960 | $8,960 | $8,960 | $8,960 | $8,960 | $8,960 | $8,960 | |
| Bill Payments | $75 | $2,253 | $2,343 | $2,414 | $2,633 | $2,676 | $2,862 | $2,817 | $2,821 | $2,982 | $3,024 | $3,065 | |
| Subtotal Spent on Operations | $8,075 | $10,253 | $10,343 | $11,374 | $11,593 | $11,636 | $11,822 | $11,777 | $11,781 | $11,942 | $11,984 | $12,025 | |
| 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 | $8,075 | $10,253 | $10,343 | $11,374 | $11,593 | $11,636 | $11,822 | $11,777 | $11,781 | $11,942 | $11,984 | $12,025 | |
| Net Cash Flow | ($8,075) | ($9,618) | ($9,208) | ($8,504) | ($7,590) | ($5,244) | ($5,187) | ($2,739) | ($2,170) | ($1,992) | $335 | $1,606 | |
| Cash Balance | $51,775 | $42,157 | $32,950 | $24,446 | $16,856 | $11,612 | $6,425 | $3,686 | $1,516 | ($476) | ($142) | $1,465 | |
| 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 | $59,850 | $51,775 | $42,157 | $32,950 | $24,446 | $16,856 | $11,612 | $6,425 | $3,686 | $1,516 | ($476) | ($142) | $1,465 |
| Accounts Receivable | $0 | $0 | $1,180 | $3,176 | $5,054 | $6,571 | $9,577 | $11,410 | $10,798 | $12,922 | $15,547 | $16,580 | $18,493 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $59,850 | $51,775 | $43,337 | $36,126 | $29,500 | $23,427 | $21,189 | $17,835 | $14,484 | $14,438 | $15,071 | $16,438 | $19,958 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 |
| Accumulated Depreciation | $0 | $61 | $122 | $183 | $244 | $305 | $366 | $427 | $488 | $549 | $610 | $671 | $732 |
| Total Long-term Assets | $3,700 | $3,639 | $3,578 | $3,517 | $3,456 | $3,395 | $3,334 | $3,273 | $3,212 | $3,151 | $3,090 | $3,029 | $2,968 |
| Total Assets | $63,550 | $55,414 | $46,915 | $39,643 | $32,956 | $26,822 | $24,523 | $21,108 | $17,696 | $17,589 | $18,161 | $19,467 | $22,926 |
| 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 | $2,175 | $2,263 | $2,326 | $2,544 | $2,581 | $2,768 | $2,723 | $2,721 | $2,881 | $2,922 | $2,960 | $3,066 |
| 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 | $2,175 | $2,263 | $2,326 | $2,544 | $2,581 | $2,768 | $2,723 | $2,721 | $2,881 | $2,922 | $2,960 | $3,066 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $0 | $2,175 | $2,263 | $2,326 | $2,544 | $2,581 | $2,768 | $2,723 | $2,721 | $2,881 | $2,922 | $2,960 | $3,066 |
| Paid-in Capital | $66,000 | $66,000 | $66,000 | $66,000 | $66,000 | $66,000 | $66,000 | $66,000 | $66,000 | $66,000 | $66,000 | $66,000 | $66,000 |
| Retained Earnings | ($2,450) | ($2,450) | ($2,450) | ($2,450) | ($2,450) | ($2,450) | ($2,450) | ($2,450) | ($2,450) | ($2,450) | ($2,450) | ($2,450) | ($2,450) |
| Earnings | $0 | ($10,311) | ($18,898) | ($26,234) | ($33,137) | ($39,309) | ($41,795) | ($45,166) | ($48,575) | ($48,842) | ($48,311) | ($47,043) | ($43,690) |
| Total Capital | $63,550 | $53,239 | $44,652 | $37,316 | $30,413 | $24,241 | $21,755 | $18,384 | $14,975 | $14,708 | $15,239 | $16,507 | $19,860 |
| Total Liabilities and Capital | $63,550 | $55,414 | $46,915 | $39,643 | $32,956 | $26,822 | $24,523 | $21,108 | $17,696 | $17,589 | $18,161 | $19,467 | $22,926 |
| Net Worth | $63,550 | $53,239 | $44,652 | $37,316 | $30,413 | $24,241 | $21,755 | $18,384 | $14,975 | $14,708 | $15,239 | $16,507 | $19,860 |
By 
