Bride’s Entourage
Appendix
| 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 | |||||||||||||
| Mothers’ Attire | 0% | $2,250 | $4,500 | $7,500 | $11,250 | $13,500 | $14,500 | $15,000 | $12,500 | $10,000 | $8,500 | $6,000 | $5,000 |
| Bridesmaids’ Attire | 0% | $2,142 | $3,213 | $5,712 | $10,710 | $10,353 | $11,424 | $14,280 | $11,424 | $9,282 | $9,282 | $7,140 | $6,426 |
| Flower Girl Dresses | 0% | $200 | $300 | $350 | $800 | $900 | $900 | $1,050 | $1,000 | $950 | $850 | $700 | $650 |
| Shoes | 0% | $250 | $400 | $1,000 | $1,500 | $1,900 | $2,000 | $2,250 | $2,100 | $1,500 | $1,500 | $1,000 | $900 |
| Other Accessories | 0% | $425 | $500 | $1,000 | $1,625 | $1,700 | $2,100 | $2,100 | $1,800 | $1,550 | $1,300 | $1,000 | $850 |
| Total Sales | $5,267 | $8,913 | $15,562 | $25,885 | $28,353 | $30,924 | $34,680 | $28,824 | $23,282 | $21,432 | $15,840 | $13,826 | |
| 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 | |
| Clothing | $0 | $0 | $4,226 | $7,538 | $12,673 | $16,687 | $15,617 | $12,248 | $11,178 | $6,843 | $6,314 | $5,773 | |
| Shoes and Other Accessories | $405 | $540 | $1,200 | $1,470 | $1,620 | $1,320 | $1,140 | $720 | $570 | $540 | $480 | $480 | |
| Subtotal Direct Cost of Sales | $405 | $540 | $5,426 | $9,008 | $14,293 | $18,007 | $16,757 | $12,968 | $11,748 | $7,383 | $6,794 | $6,253 | |
| 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 | ||
| Dorina Thaker, Owner | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Part Time Sales Associate 1 | 0% | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 | $1,400 |
| Part Time Sales Associate 2 | 0% | $580 | $580 | $580 | $580 | $580 | $580 | $580 | $580 | $580 | $580 | $580 | $580 |
| Part Time Sales Associate 3 | 0% | $580 | $580 | $580 | $580 | $580 | $580 | $580 | $580 | $580 | $580 | $580 | $580 |
| Total People | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | |
| 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 | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | |
| Long-term Interest Rate | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | |
| 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 | $5,267 | $8,913 | $15,562 | $25,885 | $28,353 | $30,924 | $34,680 | $28,824 | $23,282 | $21,432 | $15,840 | $13,826 | |
| Direct Cost of Sales | $405 | $540 | $5,426 | $9,008 | $14,293 | $18,007 | $16,757 | $12,968 | $11,748 | $7,383 | $6,794 | $6,253 | |
| Credit Card Fees | $76 | $128 | $224 | $373 | $408 | $445 | $499 | $415 | $335 | $309 | $228 | $199 | |
| Total Cost of Sales | $481 | $668 | $5,650 | $9,381 | $14,701 | $18,452 | $17,256 | $13,383 | $12,083 | $7,691 | $7,022 | $6,452 | |
| Gross Margin | $4,786 | $8,245 | $9,912 | $16,504 | $13,652 | $12,472 | $17,424 | $15,441 | $11,199 | $13,741 | $8,818 | $7,374 | |
| Gross Margin % | 90.87% | 92.50% | 63.69% | 63.76% | 48.15% | 40.33% | 50.24% | 53.57% | 48.10% | 64.11% | 55.67% | 53.33% | |
| Expenses | |||||||||||||
| Payroll | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | |
| Sales and Marketing and Other Expenses | $1,500 | $500 | $500 | $2,000 | $700 | $700 | $700 | $700 | $700 | $2,500 | $700 | $700 | |
| Depreciation | $180 | $180 | $180 | $180 | $180 | $180 | $180 | $180 | $180 | $180 | $180 | $180 | |
| Rent including triple nets | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | |
| Utilities | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | |
| Insurance | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
| Payroll Taxes | 15% | $384 | $384 | $384 | $384 | $384 | $384 | $384 | $384 | $384 | $384 | $384 | $384 |
| Supplies | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
| Repairs and Maintenance | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Professional Fees | $100 | $100 | $500 | $500 | $1,000 | $500 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Taxes and Licenses | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $100 | $0 | $1,000 | $0 | $0 |
| New Sample Inventory | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $1,000 | $1,000 | $4,000 | $2,000 | $2,000 | |
| Total Operating Expenses | $10,724 | $9,724 | $12,124 | $13,624 | $12,824 | $12,324 | $11,924 | $11,024 | $10,924 | $16,724 | $11,924 | $11,924 | |
| Profit Before Interest and Taxes | ($5,938) | ($1,479) | ($2,212) | $2,880 | $828 | $148 | $5,500 | $4,417 | $275 | ($2,983) | ($3,106) | ($4,550) | |
| EBITDA | ($5,758) | ($1,299) | ($2,032) | $3,060 | $1,008 | $328 | $5,680 | $4,597 | $455 | ($2,803) | ($2,926) | ($4,370) | |
| Interest Expense | $333 | $327 | $322 | $316 | $310 | $305 | $299 | $293 | $288 | $282 | $276 | $271 | |
| Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Net Profit | ($6,271) | ($1,807) | ($2,534) | $2,564 | $517 | ($156) | $5,201 | $4,124 | ($13) | ($3,265) | ($3,382) | ($4,821) | |
| Net Profit/Sales | -119.06% | -20.27% | -16.28% | 9.91% | 1.82% | -0.51% | 15.00% | 14.31% | -0.06% | -15.23% | -21.35% | -34.87% | |
| 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 | $5,267 | $8,913 | $15,562 | $25,885 | $28,353 | $30,924 | $34,680 | $28,824 | $23,282 | $21,432 | $15,840 | $13,826 | |
| Subtotal Cash from Operations | $5,267 | $8,913 | $15,562 | $25,885 | $28,353 | $30,924 | $34,680 | $28,824 | $23,282 | $21,432 | $15,840 | $13,826 | |
| 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 | $5,267 | $8,913 | $15,562 | $25,885 | $28,353 | $30,924 | $34,680 | $28,824 | $23,282 | $21,432 | $15,840 | $13,826 | |
| 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 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | $2,560 | |
| Bill Payments | $1,280 | $8,361 | $7,523 | $9,984 | $12,115 | $28,000 | $32,190 | $25,112 | $17,839 | $19,145 | $17,111 | $15,817 | |
| Subtotal Spent on Operations | $3,840 | $10,921 | $10,083 | $12,544 | $14,675 | $30,560 | $34,750 | $27,672 | $20,399 | $21,705 | $19,671 | $18,377 | |
| 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,085 | $1,085 | $1,085 | $1,085 | $1,085 | $1,085 | $1,085 | $1,085 | $1,085 | $1,085 | $1,085 | $1,085 | |
| 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,925 | $12,006 | $11,168 | $13,629 | $15,760 | $31,645 | $35,835 | $28,757 | $21,484 | $22,790 | $20,756 | $19,462 | |
| Net Cash Flow | $342 | ($3,093) | $4,394 | $12,256 | $12,593 | ($721) | ($1,155) | $67 | $1,798 | ($1,358) | ($4,916) | ($5,636) | |
| Cash Balance | $22,242 | $19,149 | $23,544 | $35,799 | $48,392 | $47,671 | $46,516 | $46,583 | $48,381 | $47,023 | $42,107 | $36,471 | |
| 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 | $21,900 | $22,242 | $19,149 | $23,544 | $35,799 | $48,392 | $47,671 | $46,516 | $46,583 | $48,381 | $47,023 | $42,107 | $36,471 |
| Inventory | $28,350 | $27,945 | $27,405 | $21,979 | $12,971 | $15,722 | $19,807 | $18,433 | $14,264 | $12,923 | $8,121 | $7,473 | $6,878 |
| Other Current Assets | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
| Total Current Assets | $51,250 | $51,187 | $47,554 | $46,522 | $49,770 | $65,114 | $68,478 | $65,949 | $61,847 | $62,304 | $56,144 | $50,580 | $44,349 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 |
| Accumulated Depreciation | $0 | $180 | $360 | $540 | $720 | $900 | $1,080 | $1,260 | $1,440 | $1,620 | $1,800 | $1,980 | $2,160 |
| Total Long-term Assets | $8,500 | $8,320 | $8,140 | $7,960 | $7,780 | $7,600 | $7,420 | $7,240 | $7,060 | $6,880 | $6,700 | $6,520 | $6,340 |
| Total Assets | $59,750 | $59,507 | $55,694 | $54,482 | $57,550 | $72,714 | $75,898 | $73,189 | $68,907 | $69,184 | $62,844 | $57,100 | $50,689 |
| 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 | $1,000 | $8,113 | $7,192 | $9,599 | $11,187 | $26,919 | $31,344 | $24,519 | $17,198 | $18,573 | $16,583 | $15,306 | $14,802 |
| 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 | $1,000 | $8,113 | $7,192 | $9,599 | $11,187 | $26,919 | $31,344 | $24,519 | $17,198 | $18,573 | $16,583 | $15,306 | $14,802 |
| Long-term Liabilities | $65,000 | $63,915 | $62,830 | $61,745 | $60,660 | $59,575 | $58,490 | $57,405 | $56,320 | $55,235 | $54,150 | $53,065 | $51,980 |
| Total Liabilities | $66,000 | $72,028 | $70,022 | $71,344 | $71,847 | $86,494 | $89,834 | $81,924 | $73,518 | $73,808 | $70,733 | $68,371 | $66,782 |
| Paid-in Capital | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 |
| Retained Earnings | ($36,250) | ($36,250) | ($36,250) | ($36,250) | ($36,250) | ($36,250) | ($36,250) | ($36,250) | ($36,250) | ($36,250) | ($36,250) | ($36,250) | ($36,250) |
| Earnings | $0 | ($6,271) | ($8,077) | ($10,611) | ($8,047) | ($7,530) | ($7,686) | ($2,486) | $1,639 | $1,626 | ($1,640) | ($5,022) | ($9,842) |
| Total Capital | ($6,250) | ($12,521) | ($14,327) | ($16,861) | ($14,297) | ($13,780) | ($13,936) | ($8,736) | ($4,611) | ($4,624) | ($7,890) | ($11,272) | ($16,092) |
| Total Liabilities and Capital | $59,750 | $59,507 | $55,694 | $54,482 | $57,550 | $72,714 | $75,898 | $73,189 | $68,907 | $69,184 | $62,844 | $57,100 | $50,689 |
| Net Worth | ($6,250) | ($12,521) | ($14,327) | ($16,861) | ($14,297) | ($13,780) | ($13,936) | ($8,736) | ($4,611) | ($4,624) | ($7,890) | ($11,272) | ($16,092) |