| 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 | ||
| Unit Sales | |||||||||||||
| Sawdust collection services in hours | 1,120 | 1,120 | 1,120 | 1,120 | 1,120 | 1,120 | 1,120 | 1,120 | 1,120 | 1,120 | 1,120 | 1,120 | |
| Waste acceptance in tons | 200 | 400 | 600 | 800 | 1,080 | 1,080 | 1,080 | 1,080 | 1,080 | 1,080 | 1,080 | 1,080 | |
| Compost sales in tons | 277 | 555 | 833 | 1,111 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | |
| Total Unit Sales | 1,597 | 2,075 | 2,553 | 3,031 | 3,700 | 3,700 | 3,700 | 3,700 | 3,700 | 3,700 | 3,700 | 3,700 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Sawdust collection services in hours | $14.20 | $14.20 | $14.20 | $14.20 | $14.20 | $14.20 | $14.20 | $14.20 | $14.20 | $14.20 | $14.20 | $14.20 | |
| Waste acceptance in tons | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | |
| Compost sales in tons | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | |
| Sales | |||||||||||||
| Sawdust collection services in hours | $15,904 | $15,904 | $15,904 | $15,904 | $15,904 | $15,904 | $15,904 | $15,904 | $15,904 | $15,904 | $15,904 | $15,904 | |
| Waste acceptance in tons | $3,600 | $7,200 | $10,800 | $14,400 | $19,440 | $19,440 | $19,440 | $19,440 | $19,440 | $19,440 | $19,440 | $19,440 | |
| Compost sales in tons | $13,850 | $27,750 | $41,650 | $55,550 | $75,000 | $75,000 | $75,000 | $75,000 | $75,000 | $75,000 | $75,000 | $75,000 | |
| Total Sales | $33,354 | $50,854 | $68,354 | $85,854 | $110,344 | $110,344 | $110,344 | $110,344 | $110,344 | $110,344 | $110,344 | $110,344 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Sawdust collection services in hours | 5.00% | $0.71 | $0.71 | $0.71 | $0.71 | $0.71 | $0.71 | $0.71 | $0.71 | $0.71 | $0.71 | $0.71 | $0.71 |
| Waste acceptance in tons | 5.00% | $0.90 | $0.90 | $0.90 | $0.90 | $0.90 | $0.90 | $0.90 | $0.90 | $0.90 | $0.90 | $0.90 | $0.90 |
| Compost sales in tons | 14.00% | $7.00 | $7.00 | $7.00 | $7.00 | $7.00 | $7.00 | $7.00 | $7.00 | $7.00 | $7.00 | $7.00 | $7.00 |
| Direct Cost of Sales | |||||||||||||
| Sawdust collection services in hours | $795 | $795 | $795 | $795 | $795 | $795 | $795 | $795 | $795 | $795 | $795 | $795 | |
| Waste acceptance in tons | $180 | $360 | $540 | $720 | $972 | $972 | $972 | $972 | $972 | $972 | $972 | $972 | |
| Compost sales in tons | $1,939 | $3,885 | $5,831 | $7,777 | $10,500 | $10,500 | $10,500 | $10,500 | $10,500 | $10,500 | $10,500 | $10,500 | |
| Subtotal Direct Cost of Sales | $2,914 | $5,040 | $7,166 | $9,292 | $12,267 | $12,267 | $12,267 | $12,267 | $12,267 | $12,267 | $12,267 | $12,267 | |
| 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 | ||
| Management/supervisory | 0% | $8,837 | $8,837 | $8,837 | $8,837 | $8,837 | $8,837 | $8,837 | $8,837 | $8,837 | $8,837 | $8,837 | $8,837 |
| Production labor | 0% | $11,168 | $13,401 | $14,900 | $16,380 | $16,380 | $16,380 | $16,380 | $16,380 | $16,380 | $16,380 | $16,380 | $16,380 |
| Sawdust collection team | 0% | $6,760 | $6,760 | $6,760 | $6,760 | $6,760 | $6,760 | $6,760 | $6,760 | $6,760 | $6,760 | $6,760 | $6,760 |
| Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total People | 15 | 18 | 20 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | |
| Total Payroll | $26,765 | $28,998 | $30,497 | $31,977 | $31,977 | $31,977 | $31,977 | $31,977 | $31,977 | $31,977 | $31,977 | $31,977 | |
| 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 | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| 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 | 25.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 | $33,354 | $50,854 | $68,354 | $85,854 | $110,344 | $110,344 | $110,344 | $110,344 | $110,344 | $110,344 | $110,344 | $110,344 | |
| Direct Cost of Sales | $2,914 | $5,040 | $7,166 | $9,292 | $12,267 | $12,267 | $12,267 | $12,267 | $12,267 | $12,267 | $12,267 | $12,267 | |
| Other Costs of Goods | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $2,914 | $5,040 | $7,166 | $9,292 | $12,267 | $12,267 | $12,267 | $12,267 | $12,267 | $12,267 | $12,267 | $12,267 | |
| Gross Margin | $30,440 | $45,814 | $61,188 | $76,562 | $98,077 | $98,077 | $98,077 | $98,077 | $98,077 | $98,077 | $98,077 | $98,077 | |
| Gross Margin % | 91.26% | 90.09% | 89.52% | 89.18% | 88.88% | 88.88% | 88.88% | 88.88% | 88.88% | 88.88% | 88.88% | 88.88% | |
| Expenses | |||||||||||||
| Payroll | $26,765 | $28,998 | $30,497 | $31,977 | $31,977 | $31,977 | $31,977 | $31,977 | $31,977 | $31,977 | $31,977 | $31,977 | |
| Sales and Marketing and Other Expenses | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
| Depreciation | $13,782 | $13,782 | $13,782 | $13,782 | $13,782 | $13,782 | $13,782 | $13,782 | $13,782 | $13,782 | $13,782 | $13,782 | |
| Rent | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Utilities | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
| Insurance | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
| Payroll Taxes | 15% | $4,015 | $4,350 | $4,575 | $4,797 | $4,797 | $4,797 | $4,797 | $4,797 | $4,797 | $4,797 | $4,797 | $4,797 |
| Maintanence and Repair | 15% | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 |
| Other | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
| Total Operating Expenses | $50,962 | $53,530 | $55,254 | $56,956 | $56,956 | $56,956 | $56,956 | $56,956 | $56,956 | $56,956 | $56,956 | $56,956 | |
| Profit Before Interest and Taxes | ($20,522) | ($7,716) | $5,934 | $19,606 | $41,121 | $41,121 | $41,121 | $41,121 | $41,121 | $41,121 | $41,121 | $41,121 | |
| EBITDA | ($6,740) | $6,066 | $19,716 | $33,388 | $54,903 | $54,903 | $54,903 | $54,903 | $54,903 | $54,903 | $54,903 | $54,903 | |
| Interest Expense | $4,930 | $4,901 | $4,872 | $4,843 | $4,813 | $4,784 | $4,754 | $4,724 | $4,694 | $4,664 | $4,634 | $4,603 | |
| Taxes Incurred | ($6,363) | ($3,154) | $266 | $3,691 | $9,077 | $9,084 | $9,092 | $9,099 | $9,107 | $9,114 | $9,122 | $9,129 | |
| Net Profit | ($19,089) | ($9,463) | $797 | $11,073 | $27,231 | $27,253 | $27,275 | $27,298 | $27,320 | $27,343 | $27,366 | $27,388 | |
| Net Profit/Sales | -57.23% | -18.61% | 1.17% | 12.90% | 24.68% | 24.70% | 24.72% | 24.74% | 24.76% | 24.78% | 24.80% | 24.82% | |
| 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 | $13,342 | $20,342 | $27,342 | $34,342 | $44,138 | $44,138 | $44,138 | $44,138 | $44,138 | $44,138 | $44,138 | $44,138 | |
| Cash from Receivables | $0 | $667 | $20,362 | $30,862 | $41,362 | $52,002 | $66,206 | $66,206 | $66,206 | $66,206 | $66,206 | $66,206 | |
| Subtotal Cash from Operations | $13,342 | $21,009 | $47,704 | $65,204 | $85,500 | $96,140 | $110,344 | $110,344 | $110,344 | $110,344 | $110,344 | $110,344 | |
| 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 | $13,342 | $21,009 | $47,704 | $65,204 | $85,500 | $96,140 | $110,344 | $110,344 | $110,344 | $110,344 | $110,344 | $110,344 | |
| 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 | $26,765 | $28,998 | $30,497 | $31,977 | $31,977 | $31,977 | $31,977 | $31,977 | $31,977 | $31,977 | $31,977 | $31,977 | |
| Bill Payments | $503 | $15,260 | $20,067 | $25,808 | $31,670 | $40,517 | $37,331 | $37,309 | $37,287 | $37,264 | $37,241 | $37,219 | |
| Subtotal Spent on Operations | $27,268 | $44,258 | $50,564 | $57,785 | $63,647 | $72,494 | $69,308 | $69,286 | $69,264 | $69,241 | $69,218 | $69,196 | |
| 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 | $4,911 | $4,940 | $4,968 | $4,997 | $5,026 | $5,056 | $5,085 | $5,115 | $5,145 | $5,175 | $5,205 | $5,235 | |
| 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 | $20,000 | |
| Subtotal Cash Spent | $32,179 | $49,198 | $55,532 | $62,783 | $68,673 | $77,550 | $74,394 | $74,401 | $74,408 | $74,416 | $74,423 | $94,431 | |
| Net Cash Flow | ($18,838) | ($28,189) | ($7,828) | $2,421 | $16,827 | $18,590 | $35,950 | $35,943 | $35,936 | $35,928 | $35,921 | $15,913 | |
| Cash Balance | $62,062 | $33,873 | $26,045 | $28,466 | $45,293 | $63,883 | $99,834 | $135,777 | $171,712 | $207,640 | $243,561 | $259,474 | |
| 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 | $80,900 | $62,062 | $33,873 | $26,045 | $28,466 | $45,293 | $63,883 | $99,834 | $135,777 | $171,712 | $207,640 | $243,561 | $259,474 |
| Accounts Receivable | $0 | $20,012 | $49,858 | $70,508 | $91,158 | $116,002 | $130,206 | $130,206 | $130,206 | $130,206 | $130,206 | $130,206 | $130,206 |
| Inventory | $0 | $3,206 | $5,544 | $7,883 | $10,221 | $13,494 | $13,494 | $13,494 | $13,494 | $13,494 | $13,494 | $13,494 | $13,494 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $80,900 | $85,280 | $89,275 | $104,436 | $129,846 | $174,789 | $207,583 | $243,534 | $279,477 | $315,412 | $351,340 | $387,261 | $403,174 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $826,920 | $826,920 | $826,920 | $826,920 | $826,920 | $826,920 | $826,920 | $826,920 | $826,920 | $826,920 | $826,920 | $826,920 | $826,920 |
| Accumulated Depreciation | $0 | $13,782 | $27,564 | $41,346 | $55,128 | $68,910 | $82,692 | $96,474 | $110,256 | $124,038 | $137,820 | $151,602 | $165,384 |
| Total Long-term Assets | $826,920 | $813,138 | $799,356 | $785,574 | $771,792 | $758,010 | $744,228 | $730,446 | $716,664 | $702,882 | $689,100 | $675,318 | $661,536 |
| Total Assets | $907,820 | $898,418 | $888,631 | $890,010 | $901,638 | $932,799 | $951,811 | $973,980 | $996,141 | $1,018,294 | $1,040,440 | $1,062,579 | $1,064,710 |
| 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 | $14,598 | $19,213 | $24,763 | $30,316 | $39,272 | $36,088 | $36,066 | $36,044 | $36,023 | $36,001 | $35,979 | $35,957 |
| 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 | $14,598 | $19,213 | $24,763 | $30,316 | $39,272 | $36,088 | $36,066 | $36,044 | $36,023 | $36,001 | $35,979 | $35,957 |
| Long-term Liabilities | $850,000 | $845,089 | $840,150 | $835,181 | $830,184 | $825,157 | $820,102 | $815,016 | $809,901 | $804,757 | $799,582 | $794,377 | $789,141 |
| Total Liabilities | $850,000 | $859,687 | $859,362 | $859,944 | $860,500 | $864,430 | $856,189 | $851,082 | $845,946 | $840,779 | $835,583 | $830,356 | $825,098 |
| Paid-in Capital | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 |
| Retained Earnings | ($92,180) | ($92,180) | ($92,180) | ($92,180) | ($92,180) | ($92,180) | ($92,180) | ($92,180) | ($92,180) | ($92,180) | ($92,180) | ($92,180) | ($112,180) |
| Earnings | $0 | ($19,089) | ($28,551) | ($27,755) | ($16,682) | $10,549 | $37,802 | $65,077 | $92,375 | $119,695 | $147,038 | $174,403 | $201,792 |
| Total Capital | $57,820 | $38,731 | $29,269 | $30,065 | $41,138 | $68,369 | $95,622 | $122,897 | $150,195 | $177,515 | $204,858 | $232,223 | $239,612 |
| Total Liabilities and Capital | $907,820 | $898,418 | $888,631 | $890,010 | $901,638 | $932,799 | $951,811 | $973,980 | $996,141 | $1,018,294 | $1,040,440 | $1,062,579 | $1,064,710 |
| Net Worth | $57,820 | $38,731 | $29,269 | $30,065 | $41,138 | $68,369 | $95,622 | $122,897 | $150,195 | $177,515 | $204,858 | $232,223 | $239,612 |