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) |