|
|
| Sales Forecast |
| 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
| 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 |
| 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 |
| 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% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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/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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|