| 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 | |||||||||||||
| Owner | 0% | $3,600 | $3,600 | $3,600 | $3,600 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 |
| Stylist #1 | 0% | $3,600 | $3,600 | $3,600 | $3,600 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 |
| Barber #1 | 0% | $1,200 | $1,200 | $1,200 | $1,200 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 |
| Stylist #2 | 0% | $1,700 | $1,700 | $1,700 | $1,700 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
| Stylist #3 | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Nails and massage | 0% | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 |
| Product sales | 0% | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 |
| Total Sales | $12,400 | $12,400 | $12,400 | $12,400 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | |
| 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 | |
| Product Costs | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | |
| 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 | ||
| Owner (Stylist) | 0% | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
| Receptionist | 0% | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 |
| Shampoo Tech | 0% | $0 | $0 | $0 | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
| Total People | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | $3,200 | $3,200 | $3,200 | $3,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | |
| 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 | $12,400 | $12,400 | $12,400 | $12,400 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | |
| Direct Cost of Sales | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | |
| Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | $360 | |
| Gross Margin | $12,040 | $12,040 | $12,040 | $12,040 | $14,240 | $14,240 | $14,240 | $14,240 | $14,240 | $14,240 | $14,240 | $14,240 | |
| Gross Margin % | 97.10% | 97.10% | 97.10% | 97.10% | 97.53% | 97.53% | 97.53% | 97.53% | 97.53% | 97.53% | 97.53% | 97.53% | |
| Expenses | |||||||||||||
| Payroll | $3,200 | $3,200 | $3,200 | $3,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | |
| Marketing/Promotion | $1,900 | $1,900 | $1,900 | $1,900 | $1,900 | $1,900 | $1,900 | $1,900 | $1,900 | $1,900 | $1,900 | $1,900 | |
| Depreciation | $633 | $683 | $683 | $683 | $683 | $683 | $683 | $683 | $683 | $683 | $683 | $683 | |
| Rent | $1,895 | $1,895 | $1,895 | $1,895 | $1,895 | $1,895 | $1,895 | $1,895 | $1,895 | $1,895 | $1,895 | $1,895 | |
| Utilities | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
| Insurance | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Independently contracted stylists | $2,700 | $2,700 | $2,700 | $2,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | |
| Supplies | 15% | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $11,278 | $11,328 | $11,328 | $11,328 | $13,328 | $13,328 | $13,328 | $13,328 | $13,328 | $13,328 | $13,328 | $13,328 | |
| Profit Before Interest and Taxes | $762 | $712 | $712 | $712 | $912 | $912 | $912 | $912 | $912 | $912 | $912 | $912 | |
| EBITDA | $1,395 | $1,395 | $1,395 | $1,395 | $1,595 | $1,595 | $1,595 | $1,595 | $1,595 | $1,595 | $1,595 | $1,595 | |
| Interest Expense | $508 | $499 | $491 | $483 | $474 | $466 | $458 | $449 | $441 | $433 | $424 | $416 | |
| Taxes Incurred | $76 | $64 | $66 | $69 | $131 | $134 | $136 | $139 | $141 | $144 | $146 | $149 | |
| Net Profit | $178 | $149 | $155 | $161 | $306 | $312 | $318 | $324 | $330 | $336 | $341 | $347 | |
| Net Profit/Sales | 1.44% | 1.20% | 1.25% | 1.29% | 2.10% | 2.14% | 2.18% | 2.22% | 2.26% | 2.30% | 2.34% | 2.38% | |
| 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 | $12,400 | $12,400 | $12,400 | $12,400 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | |
| Subtotal Cash from Operations | $12,400 | $12,400 | $12,400 | $12,400 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | |
| 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 | $12,400 | $12,400 | $12,400 | $12,400 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | $14,600 | |
| 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,200 | $3,200 | $3,200 | $3,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | |
| Bill Payments | $280 | $8,388 | $8,368 | $8,362 | $8,392 | $9,410 | $9,405 | $9,399 | $9,393 | $9,387 | $9,381 | $9,375 | |
| Subtotal Spent on Operations | $3,480 | $11,588 | $11,568 | $11,562 | $12,592 | $13,610 | $13,605 | $13,599 | $13,593 | $13,587 | $13,581 | $13,575 | |
| 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,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
| 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,480 | $12,588 | $12,568 | $12,562 | $13,592 | $14,610 | $14,605 | $14,599 | $14,593 | $14,587 | $14,581 | $14,575 | |
| Net Cash Flow | $7,920 | ($188) | ($168) | ($162) | $1,008 | ($10) | ($5) | $1 | $7 | $13 | $19 | $25 | |
| Cash Balance | $8,420 | $8,232 | $8,064 | $7,902 | $8,911 | $8,900 | $8,896 | $8,897 | $8,904 | $8,917 | $8,935 | $8,960 | |
| 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 | $500 | $8,420 | $8,232 | $8,064 | $7,902 | $8,911 | $8,900 | $8,896 | $8,897 | $8,904 | $8,917 | $8,935 | $8,960 |
| Other Current Assets | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 |
| Total Current Assets | $1,100 | $9,020 | $8,832 | $8,664 | $8,502 | $9,511 | $9,500 | $9,496 | $9,497 | $9,504 | $9,517 | $9,535 | $9,560 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $59,500 | $59,500 | $59,500 | $59,500 | $59,500 | $59,500 | $59,500 | $59,500 | $59,500 | $59,500 | $59,500 | $59,500 | $59,500 |
| Accumulated Depreciation | $0 | $633 | $1,316 | $1,999 | $2,682 | $3,365 | $4,048 | $4,731 | $5,414 | $6,097 | $6,780 | $7,463 | $8,146 |
| Total Long-term Assets | $59,500 | $58,867 | $58,184 | $57,501 | $56,818 | $56,135 | $55,452 | $54,769 | $54,086 | $53,403 | $52,720 | $52,037 | $51,354 |
| Total Assets | $60,600 | $67,887 | $67,016 | $66,165 | $65,320 | $65,646 | $64,952 | $64,265 | $63,583 | $62,907 | $62,237 | $61,572 | $60,914 |
| 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 | $8,109 | $8,089 | $8,084 | $8,078 | $9,097 | $9,091 | $9,086 | $9,080 | $9,074 | $9,069 | $9,063 | $9,057 |
| 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 | $8,109 | $8,089 | $8,084 | $8,078 | $9,097 | $9,091 | $9,086 | $9,080 | $9,074 | $9,069 | $9,063 | $9,057 |
| Long-term Liabilities | $61,917 | $60,917 | $59,917 | $58,917 | $57,917 | $56,917 | $55,917 | $54,917 | $53,917 | $52,917 | $51,917 | $50,917 | $49,917 |
| Total Liabilities | $61,917 | $69,026 | $68,006 | $67,001 | $65,995 | $66,014 | $65,008 | $64,003 | $62,997 | $61,991 | $60,986 | $59,980 | $58,974 |
| Paid-in Capital | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
| Retained Earnings | ($1,817) | ($1,817) | ($1,817) | ($1,817) | ($1,817) | ($1,817) | ($1,817) | ($1,817) | ($1,817) | ($1,817) | ($1,817) | ($1,817) | ($1,817) |
| Earnings | $0 | $178 | $327 | $482 | $642 | $949 | $1,261 | $1,579 | $1,903 | $2,232 | $2,568 | $2,909 | $3,257 |
| Total Capital | ($1,317) | ($1,139) | ($990) | ($835) | ($675) | ($368) | ($56) | $262 | $586 | $915 | $1,251 | $1,592 | $1,940 |
| Total Liabilities and Capital | $60,600 | $67,887 | $67,016 | $66,165 | $65,320 | $65,646 | $64,952 | $64,265 | $63,583 | $62,907 | $62,237 | $61,572 | $60,914 |
| Net Worth | ($1,317) | ($1,139) | ($990) | ($835) | ($675) | ($368) | ($56) | $262 | $586 | $915 | $1,251 | $1,592 | $1,940 |