| 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 | |||||||||||||
| Gardner and Miller Customers | 0% | $3,000 | $4,000 | $6,785 | $5,300 | $5,400 | $6,200 | $6,302 | $7,000 | $6,400 | $4,900 | $4,500 | $3,000 |
| New Customers | 0% | $0 | $0 | $0 | $0 | $1,000 | $2,500 | $3,000 | $3,700 | $4,000 | $3,000 | $3,000 | $2,000 |
| Total Sales | $3,000 | $4,000 | $6,785 | $5,300 | $6,400 | $8,700 | $9,302 | $10,700 | $10,400 | $7,900 | $7,500 | $5,000 | |
| 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 | |
| Gardner and Miller Customers | $1,050 | $1,400 | $2,375 | $1,855 | $1,890 | $2,170 | $2,206 | $2,450 | $2,240 | $1,715 | $1,575 | $1,050 | |
| New Customers | $0 | $0 | $0 | $0 | $350 | $875 | $1,050 | $1,295 | $1,400 | $1,050 | $1,050 | $700 | |
| Subtotal Direct Cost of Sales | $1,050 | $1,400 | $2,375 | $1,855 | $2,240 | $3,045 | $3,256 | $3,745 | $3,640 | $2,765 | $2,625 | $1,750 | |
| 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 | ||
| Robin Sullivan | 0% | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 |
| Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,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% | 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 | $3,000 | $4,000 | $6,785 | $5,300 | $6,400 | $8,700 | $9,302 | $10,700 | $10,400 | $7,900 | $7,500 | $5,000 | |
| Direct Cost of Sales | $1,050 | $1,400 | $2,375 | $1,855 | $2,240 | $3,045 | $3,256 | $3,745 | $3,640 | $2,765 | $2,625 | $1,750 | |
| Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $1,050 | $1,400 | $2,375 | $1,855 | $2,240 | $3,045 | $3,256 | $3,745 | $3,640 | $2,765 | $2,625 | $1,750 | |
| Gross Margin | $1,950 | $2,600 | $4,410 | $3,445 | $4,160 | $5,655 | $6,046 | $6,955 | $6,760 | $5,135 | $4,875 | $3,250 | |
| Gross Margin % | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | |
| Expenses | |||||||||||||
| Payroll | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | |
| Sales and Marketing and Other Expenses | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $0 | |
| Depreciation | $229 | $229 | $229 | $229 | $229 | $229 | $229 | $229 | $229 | $229 | $229 | $229 | |
| Leased Equipment | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
| Utilities | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Insurance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Rent | $1,000 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
| Payroll Taxes | 15% | $525 | $525 | $525 | $525 | $525 | $525 | $525 | $525 | $525 | $525 | $525 | $525 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $6,554 | $6,054 | $6,054 | $6,054 | $6,054 | $6,054 | $6,054 | $6,054 | $6,054 | $6,054 | $6,054 | $5,954 | |
| Profit Before Interest and Taxes | ($4,604) | ($3,454) | ($1,644) | ($2,609) | ($1,894) | ($399) | ($8) | $901 | $706 | ($919) | ($1,179) | ($2,704) | |
| EBITDA | ($4,375) | ($3,225) | ($1,415) | ($2,380) | ($1,665) | ($170) | $221 | $1,130 | $935 | ($690) | ($950) | ($2,475) | |
| Interest Expense | $183 | $183 | $183 | $183 | $183 | $183 | $183 | $183 | $183 | $183 | $183 | $183 | |
| Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Net Profit | ($4,787) | ($3,637) | ($1,827) | ($2,792) | ($2,077) | ($582) | ($191) | $718 | $523 | ($1,102) | ($1,362) | ($2,887) | |
| Net Profit/Sales | -159.58% | -90.93% | -26.93% | -52.69% | -32.46% | -6.69% | -2.05% | 6.71% | 5.03% | -13.95% | -18.16% | -57.75% | |
| 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 | $750 | $1,000 | $1,696 | $1,325 | $1,600 | $2,175 | $2,326 | $2,675 | $2,600 | $1,975 | $1,875 | $1,250 | |
| Cash from Receivables | $0 | $75 | $2,275 | $3,070 | $5,052 | $4,003 | $4,858 | $6,540 | $7,011 | $8,018 | $7,738 | $5,915 | |
| Subtotal Cash from Operations | $750 | $1,075 | $3,971 | $4,395 | $6,652 | $6,178 | $7,183 | $9,215 | $9,611 | $9,993 | $9,613 | $7,165 | |
| 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 | $750 | $1,075 | $3,971 | $4,395 | $6,652 | $6,178 | $7,183 | $9,215 | $9,611 | $9,993 | $9,613 | $7,165 | |
| 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 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | |
| Bill Payments | $135 | $4,053 | $3,941 | $4,866 | $4,376 | $4,775 | $5,560 | $5,780 | $6,250 | $6,119 | $5,269 | $5,101 | |
| Subtotal Spent on Operations | $3,635 | $7,553 | $7,441 | $8,366 | $7,876 | $8,275 | $9,060 | $9,280 | $9,750 | $9,619 | $8,769 | $8,601 | |
| 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 | $3,635 | $7,553 | $7,441 | $8,366 | $7,876 | $8,275 | $9,060 | $9,280 | $9,750 | $9,619 | $8,769 | $8,601 | |
| Net Cash Flow | ($2,885) | ($6,478) | ($3,470) | ($3,971) | ($1,225) | ($2,098) | ($1,877) | ($65) | ($138) | $373 | $844 | ($1,436) | |
| Cash Balance | $26,815 | $20,336 | $16,867 | $12,896 | $11,671 | $9,573 | $7,696 | $7,631 | $7,492 | $7,866 | $8,710 | $7,274 | |
| 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 | $29,700 | $26,815 | $20,336 | $16,867 | $12,896 | $11,671 | $9,573 | $7,696 | $7,631 | $7,492 | $7,866 | $8,710 | $7,274 |
| Accounts Receivable | $0 | $2,250 | $5,175 | $7,989 | $8,894 | $8,643 | $11,165 | $13,284 | $14,769 | $15,558 | $13,465 | $11,353 | $9,188 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $29,700 | $29,065 | $25,511 | $24,856 | $21,790 | $20,314 | $20,738 | $20,980 | $22,400 | $23,050 | $21,331 | $20,062 | $16,461 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 |
| Accumulated Depreciation | $0 | $229 | $458 | $687 | $916 | $1,145 | $1,374 | $1,603 | $1,832 | $2,061 | $2,290 | $2,519 | $2,748 |
| Total Long-term Assets | $22,000 | $21,771 | $21,542 | $21,313 | $21,084 | $20,855 | $20,626 | $20,397 | $20,168 | $19,939 | $19,710 | $19,481 | $19,252 |
| Total Assets | $51,700 | $50,836 | $47,053 | $46,169 | $42,874 | $41,169 | $41,364 | $41,377 | $42,568 | $42,989 | $41,041 | $39,543 | $35,713 |
| 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,923 | $3,778 | $4,720 | $4,218 | $4,590 | $5,368 | $5,572 | $6,045 | $5,943 | $5,098 | $4,962 | $4,020 |
| 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,923 | $3,778 | $4,720 | $4,218 | $4,590 | $5,368 | $5,572 | $6,045 | $5,943 | $5,098 | $4,962 | $4,020 |
| Long-term Liabilities | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 |
| Total Liabilities | $22,000 | $25,923 | $25,778 | $26,720 | $26,218 | $26,590 | $27,368 | $27,572 | $28,045 | $27,943 | $27,098 | $26,962 | $26,020 |
| Paid-in Capital | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 |
| Retained Earnings | ($10,300) | ($10,300) | ($10,300) | ($10,300) | ($10,300) | ($10,300) | ($10,300) | ($10,300) | ($10,300) | ($10,300) | ($10,300) | ($10,300) | ($10,300) |
| Earnings | $0 | ($4,787) | ($8,425) | ($10,252) | ($13,044) | ($15,121) | ($15,704) | ($15,895) | ($15,177) | ($14,654) | ($15,757) | ($17,119) | ($20,006) |
| Total Capital | $29,700 | $24,913 | $21,275 | $19,448 | $16,656 | $14,579 | $13,996 | $13,805 | $14,523 | $15,046 | $13,943 | $12,581 | $9,694 |
| Total Liabilities and Capital | $51,700 | $50,836 | $47,053 | $46,169 | $42,874 | $41,169 | $41,364 | $41,377 | $42,568 | $42,989 | $41,041 | $39,543 | $35,713 |
| Net Worth | $29,700 | $24,913 | $21,275 | $19,448 | $16,656 | $14,579 | $13,996 | $13,805 | $14,523 | $15,046 | $13,943 | $12,581 | $9,694 |