Herr Haar
Appendix
Sales Forecast | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales | |||||||||||||
Hair and Skin Services | 0% | $8,000 | $8,400 | $8,820 | $9,261 | $9,724 | $10,210 | $10,721 | $11,257 | $11,820 | $12,411 | $13,031 | $13,683 |
Massage | 0% | $3,000 | $3,060 | $3,120 | $3,120 | $3,120 | $3,150 | $3,180 | $3,210 | $3,270 | $3,270 | $3,320 | $3,330 |
Booth Rent | 0% | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 |
Products | 0% | $3,000 | $3,150 | $3,308 | $3,473 | $3,647 | $3,829 | $4,020 | $4,221 | $4,432 | $4,654 | $4,887 | $5,131 |
Total Sales | $16,600 | $17,210 | $17,848 | $18,454 | $19,091 | $19,789 | $20,521 | $21,288 | $22,122 | $22,935 | $23,838 | $24,744 | |
Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Hair Services | $2,000 | $2,100 | $2,205 | $2,315 | $2,431 | $2,553 | $2,680 | $2,814 | $2,955 | $3,103 | $3,258 | $3,421 | |
Massage | $60 | $61 | $62 | $62 | $62 | $63 | $64 | $64 | $65 | $65 | $66 | $67 | |
Products | $1,500 | $1,575 | $1,654 | $1,736 | $1,823 | $1,914 | $2,010 | $2,111 | $2,216 | $2,327 | $2,443 | $2,566 | |
Subtotal Direct Cost of Sales | $3,560 | $3,736 | $3,921 | $4,114 | $4,317 | $4,530 | $4,754 | $4,989 | $5,236 | $5,495 | $5,768 | $6,053 |
Personnel Plan | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Receptionist | 0% | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 | $1,280 |
Massage Therapists | 0% | $1,800 | $1,830 | $1,860 | $1,860 | $1,860 | $1,875 | $1,890 | $1,905 | $1,935 | $1,935 | $1,960 | $1,965 |
Cosmetologist (Phyllis) | 0% | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 |
Cosmetologist (Phoebe) | 0% | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 |
Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
Total Payroll | $8,840 | $8,870 | $8,900 | $8,900 | $8,900 | $8,915 | $8,930 | $8,945 | $8,975 | $8,975 | $9,000 | $9,005 |
Pro Forma Profit and Loss | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales | $16,600 | $17,210 | $17,848 | $18,454 | $19,091 | $19,789 | $20,521 | $21,288 | $22,122 | $22,935 | $23,838 | $24,744 | |
Direct Cost of Sales | $3,560 | $3,736 | $3,921 | $4,114 | $4,317 | $4,530 | $4,754 | $4,989 | $5,236 | $5,495 | $5,768 | $6,053 | |
Other Costs of Goods | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $3,560 | $3,736 | $3,921 | $4,114 | $4,317 | $4,530 | $4,754 | $4,989 | $5,236 | $5,495 | $5,768 | $6,053 | |
Gross Margin | $13,040 | $13,474 | $13,926 | $14,340 | $14,774 | $15,259 | $15,767 | $16,299 | $16,886 | $17,440 | $18,070 | $18,691 | |
Gross Margin % | 78.55% | 78.29% | 78.03% | 77.71% | 77.39% | 77.11% | 76.83% | 76.56% | 76.33% | 76.04% | 75.81% | 75.54% | |
Expenses | |||||||||||||
Payroll | $8,840 | $8,870 | $8,900 | $8,900 | $8,900 | $8,915 | $8,930 | $8,945 | $8,975 | $8,975 | $9,000 | $9,005 | |
Marketing/Promotion | $0 | $900 | $0 | $900 | $0 | $900 | $0 | $900 | $0 | $900 | $0 | $900 | |
Depreciation | $17 | $17 | $17 | $17 | $17 | $17 | $17 | $17 | $17 | $17 | $17 | $17 | |
Rent | $1,750 | $1,750 | $1,750 | $1,750 | $1,750 | $1,750 | $1,750 | $1,750 | $1,750 | $1,750 | $1,750 | $1,750 | |
Utilities | $374 | $374 | $374 | $374 | $374 | $374 | $374 | $374 | $374 | $374 | $374 | $374 | |
Insurance | $83 | $83 | $83 | $83 | $83 | $83 | $83 | $83 | $83 | $83 | $83 | $83 | |
Payroll Taxes | 15% | $1,326 | $1,331 | $1,335 | $1,335 | $1,335 | $1,337 | $1,340 | $1,342 | $1,346 | $1,346 | $1,350 | $1,351 |
Merchant Account Fees | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Moving Expenses | 15% | $2,300 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Redecorating New Location | $3,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $17,840 | $13,475 | $12,609 | $13,509 | $12,609 | $13,526 | $12,644 | $13,561 | $12,695 | $13,595 | $12,724 | $13,630 | |
Profit Before Interest and Taxes | ($4,800) | ($1) | $1,317 | $831 | $2,165 | $1,733 | $3,124 | $2,738 | $4,190 | $3,844 | $5,346 | $5,061 | |
EBITDA | ($4,783) | $16 | $1,334 | $848 | $2,182 | $1,750 | $3,141 | $2,755 | $4,207 | $3,861 | $5,363 | $5,078 | |
Interest Expense | $23 | $23 | $20 | $18 | $15 | $12 | $9 | $6 | $3 | $0 | $0 | $0 | |
Taxes Incurred | ($1,447) | ($7) | $389 | $244 | $645 | $516 | $934 | $820 | $1,256 | $1,153 | $1,604 | $1,518 | |
Net Profit | ($3,376) | ($17) | $908 | $569 | $1,505 | $1,205 | $2,180 | $1,913 | $2,931 | $2,691 | $3,742 | $3,543 | |
Net Profit/Sales | -20.34% | -0.10% | 5.09% | 3.08% | 7.88% | 6.09% | 10.63% | 8.98% | 13.25% | 11.73% | 15.70% | 14.32% |
Pro Forma Cash Flow | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $16,600 | $17,210 | $17,848 | $18,454 | $19,091 | $19,789 | $20,521 | $21,288 | $22,122 | $22,935 | $23,838 | $24,744 | |
Subtotal Cash from Operations | $16,600 | $17,210 | $17,848 | $18,454 | $19,091 | $19,789 | $20,521 | $21,288 | $22,122 | $22,935 | $23,838 | $24,744 | |
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 | $4,000 | $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 | $20,600 | $17,210 | $17,848 | $18,454 | $19,091 | $19,789 | $20,521 | $21,288 | $22,122 | $22,935 | $23,838 | $24,744 | |
Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Expenditures from Operations | |||||||||||||
Cash Spending | $8,840 | $8,870 | $8,900 | $8,900 | $8,900 | $8,915 | $8,930 | $8,945 | $8,975 | $8,975 | $9,000 | $9,005 | |
Bill Payments | $3,939 | $13,006 | $8,506 | $8,239 | $9,151 | $8,904 | $9,857 | $9,652 | $10,642 | $10,482 | $11,505 | $11,388 | |
Subtotal Spent on Operations | $12,779 | $21,876 | $17,406 | $17,139 | $18,051 | $17,819 | $18,787 | $18,597 | $19,617 | $19,457 | $20,505 | $20,393 | |
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 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $0 | $0 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $100 | $100 | $100 | $100 | $100 | $100 | |
Long-term Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Purchase Other Current Assets | $1,400 | $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 | $14,179 | $21,876 | $17,906 | $17,639 | $18,551 | $18,319 | $19,387 | $19,197 | $20,217 | $20,057 | $20,605 | $20,493 | |
Net Cash Flow | $6,421 | ($4,666) | ($58) | $815 | $540 | $1,470 | $1,134 | $2,091 | $1,905 | $2,878 | $3,233 | $4,251 | |
Cash Balance | $7,452 | $2,787 | $2,729 | $3,543 | $4,083 | $5,553 | $6,687 | $8,778 | $10,683 | $13,561 | $16,794 | $21,044 |
Pro Forma Balance Sheet | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $1,031 | $7,452 | $2,787 | $2,729 | $3,543 | $4,083 | $5,553 | $6,687 | $8,778 | $10,683 | $13,561 | $16,794 | $21,044 |
Inventory | $1,519 | $3,560 | $3,736 | $3,921 | $4,114 | $4,317 | $4,530 | $4,754 | $4,989 | $5,236 | $5,495 | $5,768 | $6,053 |
Other Current Assets | $1,675 | $3,075 | $3,075 | $3,075 | $3,075 | $3,075 | $3,075 | $3,075 | $3,075 | $3,075 | $3,075 | $3,075 | $3,075 |
Total Current Assets | $4,225 | $14,087 | $9,598 | $9,725 | $10,732 | $11,474 | $13,158 | $14,515 | $16,842 | $18,994 | $22,131 | $25,636 | $30,172 |
Long-term Assets | |||||||||||||
Long-term Assets | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 |
Accumulated Depreciation | $126 | $143 | $160 | $177 | $194 | $211 | $228 | $245 | $262 | $279 | $296 | $313 | $330 |
Total Long-term Assets | $1,674 | $1,657 | $1,640 | $1,623 | $1,606 | $1,589 | $1,572 | $1,555 | $1,538 | $1,521 | $1,504 | $1,487 | $1,470 |
Total Assets | $5,899 | $15,744 | $11,238 | $11,348 | $12,338 | $13,063 | $14,730 | $16,070 | $18,380 | $20,515 | $23,635 | $27,123 | $31,642 |
Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Current Liabilities | |||||||||||||
Accounts Payable | $3,500 | $12,722 | $8,232 | $7,934 | $8,855 | $8,575 | $9,537 | $9,297 | $10,294 | $10,098 | $11,126 | $10,973 | $12,049 |
Current Borrowing | $0 | $4,000 | $4,000 | $3,500 | $3,000 | $2,500 | $2,000 | $1,500 | $1,000 | $500 | $0 | $0 | $0 |
Other Current Liabilities | $1,135 | $1,135 | $1,135 | $1,135 | $1,135 | $1,135 | $1,135 | $1,035 | $935 | $835 | $735 | $635 | $535 |
Subtotal Current Liabilities | $4,635 | $17,857 | $13,367 | $12,569 | $12,990 | $12,210 | $12,672 | $11,832 | $12,229 | $11,433 | $11,861 | $11,608 | $12,584 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $4,635 | $17,857 | $13,367 | $12,569 | $12,990 | $12,210 | $12,672 | $11,832 | $12,229 | $11,433 | $11,861 | $11,608 | $12,584 |
Paid-in Capital | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Retained Earnings | ($2,049) | $1,264 | $1,264 | $1,264 | $1,264 | $1,264 | $1,264 | $1,264 | $1,264 | $1,264 | $1,264 | $1,264 | $1,264 |
Earnings | $3,313 | ($3,376) | ($3,393) | ($2,485) | ($1,916) | ($411) | $794 | $2,974 | $4,887 | $7,818 | $10,509 | $14,252 | $17,795 |
Total Capital | $1,264 | ($2,112) | ($2,129) | ($1,221) | ($652) | $853 | $2,058 | $4,238 | $6,151 | $9,082 | $11,773 | $15,516 | $19,059 |
Total Liabilities and Capital | $5,899 | $15,744 | $11,238 | $11,348 | $12,338 | $13,063 | $14,730 | $16,070 | $18,380 | $20,515 | $23,635 | $27,123 | $31,642 |
Net Worth | $1,264 | ($2,112) | ($2,129) | ($1,221) | ($652) | $853 | $2,058 | $4,238 | $6,151 | $9,082 | $11,773 | $15,516 | $19,059 |