TLC Wedding Consultants
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 | |||||||||||||
| Brides & Grooms | 0% | $2,900 | $3,100 | $3,300 | $3,500 | $4,000 | $5,400 | $4,600 | $5,000 | $5,200 | $5,500 | $5,700 | $6,000 |
| Family Members | 0% | $1,600 | $1,700 | $1,800 | $1,900 | $2,000 | $2,100 | $2,200 | $2,300 | $2,400 | $2,500 | $2,600 | $2,700 |
| Other | 0% | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,400 | $1,400 |
| Total Sales | $5,700 | $6,000 | $6,300 | $6,600 | $7,200 | $8,800 | $8,100 | $8,600 | $8,900 | $9,300 | $9,700 | $10,100 | |
| 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 | |
| Row 1 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Row 1 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| 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 | 0% | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $5,700 | $5,700 | $5,700 |
| Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $5,700 | $5,700 | $5,700 | |
| 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% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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,700 | $6,000 | $6,300 | $6,600 | $7,200 | $8,800 | $8,100 | $8,600 | $8,900 | $9,300 | $9,700 | $10,100 | |
| Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Gross Margin | $5,700 | $6,000 | $6,300 | $6,600 | $7,200 | $8,800 | $8,100 | $8,600 | $8,900 | $9,300 | $9,700 | $10,100 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $5,700 | $5,700 | $5,700 | |
| Sales and Marketing and Other Expenses | $1,100 | $250 | $250 | $250 | $600 | $250 | $250 | $250 | $600 | $250 | $250 | $250 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Utilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Insurance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Rent | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $5,100 | $4,250 | $4,250 | $4,250 | $4,600 | $4,250 | $4,250 | $4,250 | $4,600 | $5,950 | $5,950 | $5,950 | |
| Profit Before Interest and Taxes | $600 | $1,750 | $2,050 | $2,350 | $2,600 | $4,550 | $3,850 | $4,350 | $4,300 | $3,350 | $3,750 | $4,150 | |
| EBITDA | $600 | $1,750 | $2,050 | $2,350 | $2,600 | $4,550 | $3,850 | $4,350 | $4,300 | $3,350 | $3,750 | $4,150 | |
| Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Taxes Incurred | $180 | $438 | $513 | $588 | $650 | $1,138 | $963 | $1,088 | $1,075 | $838 | $938 | $1,038 | |
| Net Profit | $420 | $1,313 | $1,538 | $1,763 | $1,950 | $3,413 | $2,888 | $3,263 | $3,225 | $2,513 | $2,813 | $3,113 | |
| Net Profit/Sales | 7.37% | 21.88% | 24.40% | 26.70% | 27.08% | 38.78% | 35.65% | 37.94% | 36.24% | 27.02% | 28.99% | 30.82% | |
| 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 | $2,280 | $2,400 | $2,520 | $2,640 | $2,880 | $3,520 | $3,240 | $3,440 | $3,560 | $3,720 | $3,880 | $4,040 | |
| Cash from Receivables | $0 | $114 | $3,426 | $3,606 | $3,786 | $3,972 | $4,352 | $5,266 | $4,870 | $5,166 | $5,348 | $5,588 | |
| Subtotal Cash from Operations | $2,280 | $2,514 | $5,946 | $6,246 | $6,666 | $7,492 | $7,592 | $8,706 | $8,430 | $8,886 | $9,228 | $9,628 | |
| 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 | $2,280 | $2,514 | $5,946 | $6,246 | $6,666 | $7,492 | $7,592 | $8,706 | $8,430 | $8,886 | $9,228 | $9,628 | |
| 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 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $5,700 | $5,700 | $5,700 | |
| Bill Payments | $43 | $1,260 | $690 | $765 | $851 | $1,255 | $1,382 | $1,217 | $1,349 | $1,655 | $1,091 | $1,191 | |
| Subtotal Spent on Operations | $4,043 | $5,260 | $4,690 | $4,765 | $4,851 | $5,255 | $5,382 | $5,217 | $5,349 | $7,355 | $6,791 | $6,891 | |
| 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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| 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,043 | $5,260 | $4,690 | $4,765 | $4,851 | $5,255 | $5,382 | $5,217 | $5,349 | $7,355 | $6,791 | $6,891 | |
| Net Cash Flow | ($1,763) | ($2,746) | $1,256 | $1,481 | $1,815 | $2,237 | $2,210 | $3,489 | $3,081 | $1,531 | $2,437 | $2,737 | |
| Cash Balance | $3,237 | $491 | $1,747 | $3,228 | $5,043 | $7,280 | $9,491 | $12,980 | $16,061 | $17,592 | $20,029 | $22,766 | |
| 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 | $5,000 | $3,237 | $491 | $1,747 | $3,228 | $5,043 | $7,280 | $9,491 | $12,980 | $16,061 | $17,592 | $20,029 | $22,766 |
| Accounts Receivable | $0 | $3,420 | $6,906 | $7,260 | $7,614 | $8,148 | $9,456 | $9,964 | $9,858 | $10,328 | $10,742 | $11,214 | $11,686 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $5,000 | $6,657 | $7,397 | $9,007 | $10,842 | $13,191 | $16,736 | $19,455 | $22,838 | $26,389 | $28,334 | $31,243 | $34,452 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Assets | $5,000 | $6,657 | $7,397 | $9,007 | $10,842 | $13,191 | $16,736 | $19,455 | $22,838 | $26,389 | $28,334 | $31,243 | $34,452 |
| 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 | $1,237 | $665 | $737 | $810 | $1,208 | $1,341 | $1,172 | $1,293 | $1,619 | $1,051 | $1,148 | $1,245 |
| 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 | $1,237 | $665 | $737 | $810 | $1,208 | $1,341 | $1,172 | $1,293 | $1,619 | $1,051 | $1,148 | $1,245 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $0 | $1,237 | $665 | $737 | $810 | $1,208 | $1,341 | $1,172 | $1,293 | $1,619 | $1,051 | $1,148 | $1,245 |
| Paid-in Capital | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 |
| Retained Earnings | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) | ($3,000) |
| Earnings | $0 | $420 | $1,733 | $3,270 | $5,033 | $6,983 | $10,395 | $13,283 | $16,545 | $19,770 | $22,283 | $25,095 | $28,208 |
| Total Capital | $5,000 | $5,420 | $6,733 | $8,270 | $10,033 | $11,983 | $15,395 | $18,283 | $21,545 | $24,770 | $27,283 | $30,095 | $33,208 |
| Total Liabilities and Capital | $5,000 | $6,657 | $7,397 | $9,007 | $10,842 | $13,191 | $16,736 | $19,455 | $22,838 | $26,389 | $28,334 | $31,243 | $34,452 |
| Net Worth | $5,000 | $5,420 | $6,733 | $8,270 | $10,033 | $11,983 | $15,395 | $18,283 | $21,545 | $24,770 | $27,282 | $30,095 | $33,207 |