| 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 | |||||||||||||
| Distributors | 0% | $0 | $0 | $0 | $0 | $9,500 | $14,500 | $18,500 | $21,000 | $23,500 | $28,000 | $30,050 | $31,050 |
| Health Clubs | 0% | $0 | $0 | $0 | $0 | $7,030 | $10,730 | $13,690 | $15,540 | $17,390 | $20,720 | $22,237 | $22,977 |
| Vertical Markets | 0% | $0 | $0 | $0 | $0 | $6,840 | $10,440 | $13,320 | $15,120 | $16,920 | $20,160 | $21,636 | $22,356 |
| Total Sales | $0 | $0 | $0 | $0 | $23,370 | $35,670 | $45,510 | $51,660 | $57,810 | $68,880 | $73,923 | $76,383 | |
| 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 | |
| Distributors | $0 | $0 | $0 | $0 | $6,080 | $9,280 | $11,840 | $13,440 | $15,040 | $17,920 | $19,232 | $19,872 | |
| Health Clubs | $0 | $0 | $0 | $0 | $4,780 | $7,296 | $9,309 | $10,567 | $11,825 | $14,090 | $15,121 | $15,624 | |
| Vertical Markets | $0 | $0 | $0 | $0 | $4,651 | $7,099 | $9,058 | $10,282 | $11,506 | $13,709 | $14,712 | $15,202 | |
| Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $15,512 | $23,676 | $30,207 | $34,289 | $38,371 | $45,718 | $49,066 | $50,698 | |
| 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 | ||
| Max | 0% | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
| Support | 0% | $0 | $0 | $0 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 |
| Support | 0% | $0 | $0 | $0 | $0 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 |
| Repair | 0% | $0 | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
| Sales | 0% | $0 | $0 | $0 | $0 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
| Sales | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
| Total People | 0 | 0 | 1 | 2 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | $0 | $0 | $2,000 | $3,800 | $10,100 | $10,100 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | |
| 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 | $0 | $0 | $0 | $23,370 | $35,670 | $45,510 | $51,660 | $57,810 | $68,880 | $73,923 | $76,383 | |
| Direct Cost of Sales | $0 | $0 | $0 | $0 | $15,512 | $23,676 | $30,207 | $34,289 | $38,371 | $45,718 | $49,066 | $50,698 | |
| Other Costs of Goods | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $0 | $0 | $0 | $0 | $15,512 | $23,676 | $30,207 | $34,289 | $38,371 | $45,718 | $49,066 | $50,698 | |
| Gross Margin | $0 | $0 | $0 | $0 | $7,858 | $11,994 | $15,303 | $17,371 | $19,439 | $23,162 | $24,857 | $25,685 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 33.63% | 33.63% | 33.63% | 33.63% | 33.63% | 33.63% | 33.63% | 33.63% | |
| Expenses | |||||||||||||
| Payroll | $0 | $0 | $2,000 | $3,800 | $10,100 | $10,100 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | |
| Sales and Marketing and Other Expenses | $0 | $0 | $0 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | |
| Depreciation | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
| Rent | $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 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
| Insurance | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
| Payroll Taxes | 15% | $0 | $0 | $300 | $570 | $1,515 | $1,515 | $1,890 | $1,890 | $1,890 | $1,890 | $1,890 | $1,890 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $1,650 | $1,650 | $3,950 | $9,520 | $16,765 | $16,765 | $19,640 | $19,640 | $19,640 | $19,640 | $19,640 | $19,640 | |
| Profit Before Interest and Taxes | ($1,650) | ($1,650) | ($3,950) | ($9,520) | ($8,907) | ($4,771) | ($4,337) | ($2,269) | ($201) | $3,522 | $5,217 | $6,045 | |
| EBITDA | ($1,400) | ($1,400) | ($3,700) | ($9,270) | ($8,657) | ($4,521) | ($4,087) | ($2,019) | $49 | $3,772 | $5,467 | $6,295 | |
| Interest Expense | $699 | $690 | $681 | $671 | $662 | $652 | $643 | $633 | $623 | $613 | $603 | $593 | |
| Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Net Profit | ($2,349) | ($2,340) | ($4,631) | ($10,191) | ($9,568) | ($5,423) | ($4,979) | ($2,902) | ($824) | $2,908 | $4,614 | $5,451 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | -40.94% | -15.20% | -10.94% | -5.62% | -1.43% | 4.22% | 6.24% | 7.14% | |
| 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 | $0 | $0 | $11,685 | $17,835 | $22,755 | $25,830 | $28,905 | $34,440 | $36,962 | $38,192 | |
| Cash from Receivables | $0 | $0 | $0 | $0 | $0 | $390 | $11,890 | $17,999 | $22,858 | $25,933 | $29,090 | $34,524 | |
| Subtotal Cash from Operations | $0 | $0 | $0 | $0 | $11,685 | $18,225 | $34,645 | $43,829 | $51,763 | $60,373 | $66,051 | $72,716 | |
| 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 | $0 | $0 | $11,685 | $18,225 | $34,645 | $43,829 | $51,763 | $60,373 | $66,051 | $72,716 | |
| 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 | $0 | $0 | $2,000 | $3,800 | $10,100 | $10,100 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | $12,600 | |
| Bill Payments | $70 | $2,099 | $2,100 | $2,506 | $6,948 | $30,494 | $35,028 | $41,000 | $43,889 | $48,124 | $56,840 | $58,158 | |
| Subtotal Spent on Operations | $70 | $2,099 | $4,100 | $6,306 | $17,048 | $40,594 | $47,628 | $53,600 | $56,489 | $60,724 | $69,440 | $70,758 | |
| 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 | $1,098 | $1,107 | $1,116 | $1,125 | $1,135 | $1,144 | $1,154 | $1,163 | $1,173 | $1,183 | $1,193 | $1,203 | |
| 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 | $1,168 | $3,206 | $5,216 | $7,431 | $18,183 | $41,738 | $48,781 | $54,763 | $57,662 | $61,907 | $70,633 | $71,961 | |
| Net Cash Flow | ($1,168) | ($3,206) | ($5,216) | ($7,431) | ($6,498) | ($23,513) | ($14,136) | ($10,934) | ($5,899) | ($1,534) | ($4,582) | $755 | |
| Cash Balance | $165,932 | $162,727 | $157,511 | $150,080 | $143,582 | $120,069 | $105,932 | $94,998 | $89,099 | $87,565 | $82,983 | $83,738 | |
| 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 | $167,100 | $165,932 | $162,727 | $157,511 | $150,080 | $143,582 | $120,069 | $105,932 | $94,998 | $89,099 | $87,565 | $82,983 | $83,738 |
| Accounts Receivable | $0 | $0 | $0 | $0 | $0 | $11,685 | $29,131 | $39,996 | $47,827 | $53,874 | $62,382 | $70,254 | $73,921 |
| Inventory | $0 | $0 | $0 | $0 | $0 | $7,756 | $11,838 | $15,103 | $17,144 | $19,185 | $22,859 | $24,533 | $25,349 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $167,100 | $165,932 | $162,727 | $157,511 | $150,080 | $163,023 | $161,037 | $161,031 | $159,969 | $162,158 | $172,805 | $177,769 | $183,008 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 |
| Accumulated Depreciation | $0 | $250 | $500 | $750 | $1,000 | $1,250 | $1,500 | $1,750 | $2,000 | $2,250 | $2,500 | $2,750 | $3,000 |
| Total Long-term Assets | $15,000 | $14,750 | $14,500 | $14,250 | $14,000 | $13,750 | $13,500 | $13,250 | $13,000 | $12,750 | $12,500 | $12,250 | $12,000 |
| Total Assets | $182,100 | $180,682 | $177,227 | $171,761 | $164,080 | $176,773 | $174,537 | $174,281 | $172,969 | $174,908 | $185,305 | $190,019 | $195,008 |
| 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,029 | $2,020 | $2,301 | $5,937 | $29,333 | $33,664 | $39,542 | $42,294 | $46,231 | $54,902 | $56,195 | $56,935 |
| 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,029 | $2,020 | $2,301 | $5,937 | $29,333 | $33,664 | $39,542 | $42,294 | $46,231 | $54,902 | $56,195 | $56,935 |
| Long-term Liabilities | $85,000 | $83,902 | $82,796 | $81,679 | $80,554 | $79,419 | $78,275 | $77,122 | $75,958 | $74,785 | $73,602 | $72,410 | $71,207 |
| Total Liabilities | $85,000 | $85,932 | $84,816 | $83,981 | $86,491 | $108,752 | $111,939 | $116,663 | $118,253 | $121,016 | $128,505 | $128,605 | $128,142 |
| Paid-in Capital | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 |
| Retained Earnings | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) |
| Earnings | $0 | ($2,349) | ($4,689) | ($9,320) | ($19,511) | ($29,080) | ($34,502) | ($39,482) | ($42,384) | ($43,208) | ($40,299) | ($35,686) | ($30,234) |
| Total Capital | $97,100 | $94,751 | $92,411 | $87,780 | $77,589 | $68,020 | $62,598 | $57,618 | $54,716 | $53,892 | $56,801 | $61,414 | $66,866 |
| Total Liabilities and Capital | $182,100 | $180,682 | $177,227 | $171,761 | $164,080 | $176,773 | $174,537 | $174,281 | $172,969 | $174,908 | $185,305 | $190,019 | $195,008 |
| Net Worth | $97,100 | $94,751 | $92,411 | $87,780 | $77,589 | $68,020 | $62,598 | $57,618 | $54,716 | $53,892 | $56,801 | $61,414 | $66,866 |