|
|

| Sales Forecast |
| Tulips and Roses |
0% |
2,000 |
3,000 |
2,500 |
1,500 |
3,000 |
2,500 |
3,000 |
2,200 |
1,600 |
1,700 |
1,800 |
3,500 |
| Arranged Flowers 1 |
0% |
350 |
500 |
500 |
400 |
350 |
500 |
350 |
500 |
350 |
300 |
300 |
600 |
| Arranged Flowers 2 |
0% |
350 |
500 |
500 |
400 |
350 |
500 |
350 |
500 |
350 |
300 |
300 |
600 |
| Silk Scarf |
0% |
600 |
1,000 |
600 |
600 |
1,000 |
1,000 |
1,100 |
1,200 |
800 |
800 |
800 |
1,300 |
| Other hair accessories |
0% |
1,000 |
1,000 |
1,000 |
1,000 |
1,000 |
1,000 |
1,000 |
1,000 |
1,000 |
1,000 |
1,000 |
1,000 |
| Other/seasonal bouquet |
0% |
500 |
800 |
700 |
500 |
800 |
850 |
600 |
850 |
500 |
500 |
600 |
1,000 |
| Catalog Sales |
0% |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
| Total Unit Sales |
|
4,800 |
6,800 |
5,800 |
4,400 |
6,500 |
6,350 |
6,400 |
6,250 |
4,600 |
4,600 |
4,800 |
8,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Tulips and Roses |
|
£2.25 |
£2.25 |
£2.25 |
£2.25 |
£2.25 |
£2.25 |
£2.25 |
£2.25 |
£2.25 |
£2.25 |
£2.25 |
£2.25 |
| Arranged Flowers 1 |
|
£18.99 |
£18.99 |
£18.99 |
£18.99 |
£18.99 |
£18.99 |
£18.99 |
£18.99 |
£18.99 |
£18.99 |
£18.99 |
£18.99 |
| Arranged Flowers 2 |
|
£39.99 |
£39.99 |
£39.99 |
£39.99 |
£39.99 |
£39.99 |
£39.99 |
£39.99 |
£39.99 |
£39.99 |
£39.99 |
£39.99 |
| Silk Scarf |
|
£15.99 |
£15.99 |
£15.99 |
£15.99 |
£15.99 |
£15.99 |
£15.99 |
£15.99 |
£15.99 |
£15.99 |
£15.99 |
£15.99 |
| Other hair accessories |
|
£9.99 |
£9.99 |
£9.99 |
£9.99 |
£9.99 |
£9.99 |
£9.99 |
£9.99 |
£9.99 |
£9.99 |
£9.99 |
£9.99 |
| Other/seasonal bouquet |
|
£59.99 |
£59.99 |
£59.99 |
£59.99 |
£59.99 |
£59.99 |
£59.99 |
£59.99 |
£59.99 |
£59.99 |
£59.99 |
£59.99 |
| Catalog Sales |
|
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Tulips and Roses |
|
£4,500 |
£6,750 |
£5,625 |
£3,375 |
£6,750 |
£5,625 |
£6,750 |
£4,950 |
£3,600 |
£3,825 |
£4,050 |
£7,875 |
| Arranged Flowers 1 |
|
£6,646 |
£9,495 |
£9,495 |
£7,596 |
£6,646 |
£9,495 |
£6,646 |
£9,495 |
£6,646 |
£5,697 |
£5,697 |
£11,394 |
| Arranged Flowers 2 |
|
£13,997 |
£19,995 |
£19,995 |
£15,996 |
£13,997 |
£19,995 |
£13,997 |
£19,995 |
£13,997 |
£11,997 |
£11,997 |
£23,994 |
| Silk Scarf |
|
£9,594 |
£15,990 |
£9,594 |
£9,594 |
£15,990 |
£15,990 |
£17,589 |
£19,188 |
£12,792 |
£12,792 |
£12,792 |
£20,787 |
| Other hair accessories |
|
£9,990 |
£9,990 |
£9,990 |
£9,990 |
£9,990 |
£9,990 |
£9,990 |
£9,990 |
£9,990 |
£9,990 |
£9,990 |
£9,990 |
| Other/seasonal bouquet |
|
£29,995 |
£47,992 |
£41,993 |
£29,995 |
£47,992 |
£50,992 |
£35,994 |
£50,992 |
£29,995 |
£29,995 |
£35,994 |
£59,990 |
| Catalog Sales |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Sales |
|
£74,722 |
£110,212 |
£96,692 |
£76,546 |
£101,365 |
£112,087 |
£90,966 |
£114,610 |
£77,020 |
£74,296 |
£80,520 |
£134,030 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Tulips and Roses |
66.66% |
£1.50 |
£1.50 |
£1.50 |
£1.50 |
£1.50 |
£1.50 |
£1.50 |
£1.50 |
£1.50 |
£1.50 |
£1.50 |
£1.50 |
| Arranged Flowers 1 |
63.14% |
£11.99 |
£11.99 |
£11.99 |
£11.99 |
£11.99 |
£11.99 |
£11.99 |
£11.99 |
£11.99 |
£11.99 |
£11.99 |
£11.99 |
| Arranged Flowers 2 |
70.00% |
£27.99 |
£27.99 |
£27.99 |
£27.99 |
£27.99 |
£27.99 |
£27.99 |
£27.99 |
£27.99 |
£27.99 |
£27.99 |
£27.99 |
| Silk Scarf |
53.16% |
£8.50 |
£8.50 |
£8.50 |
£8.50 |
£8.50 |
£8.50 |
£8.50 |
£8.50 |
£8.50 |
£8.50 |
£8.50 |
£8.50 |
| Other hair accessories |
65.07% |
£6.50 |
£6.50 |
£6.50 |
£6.50 |
£6.50 |
£6.50 |
£6.50 |
£6.50 |
£6.50 |
£6.50 |
£6.50 |
£6.50 |
| Other/seasonal bouquet |
70.00% |
£41.99 |
£41.99 |
£41.99 |
£41.99 |
£41.99 |
£41.99 |
£41.99 |
£41.99 |
£41.99 |
£41.99 |
£41.99 |
£41.99 |
| Catalog Sales |
66.66% |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Tulips and Roses |
|
£3,000 |
£4,500 |
£3,750 |
£2,250 |
£4,500 |
£3,750 |
£4,500 |
£3,300 |
£2,400 |
£2,550 |
£2,700 |
£5,249 |
| Arranged Flowers 1 |
|
£4,197 |
£5,995 |
£5,995 |
£4,796 |
£4,197 |
£5,995 |
£4,197 |
£5,995 |
£4,197 |
£3,597 |
£3,597 |
£7,194 |
| Arranged Flowers 2 |
|
£9,797 |
£13,996 |
£13,996 |
£11,197 |
£9,797 |
£13,996 |
£9,797 |
£13,996 |
£9,797 |
£8,398 |
£8,398 |
£16,796 |
| Silk Scarf |
|
£5,100 |
£8,500 |
£5,100 |
£5,100 |
£8,500 |
£8,500 |
£9,350 |
£10,200 |
£6,800 |
£6,800 |
£6,800 |
£11,050 |
| Other hair accessories |
|
£6,500 |
£6,500 |
£6,500 |
£6,500 |
£6,500 |
£6,500 |
£6,500 |
£6,500 |
£6,500 |
£6,500 |
£6,500 |
£6,500 |
| Other/seasonal bouquet |
|
£20,997 |
£33,594 |
£29,395 |
£20,997 |
£33,594 |
£35,694 |
£25,196 |
£35,694 |
£20,997 |
£20,997 |
£25,196 |
£41,993 |
| Catalog Sales |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Direct Cost of Sales |
|
£49,591 |
£73,086 |
£64,737 |
£50,840 |
£67,089 |
£74,436 |
£59,540 |
£75,686 |
£50,691 |
£48,842 |
£53,191 |
£88,783 |
| Personnel Plan |
| Production/Fulfillment |
0% |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
| Sales and Marketing |
0% |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
| Administration |
0% |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
| Total People |
|
3 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Payroll |
|
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |

| Pro Forma Profit and Loss |
| Direct Cost of Sales |
|
£49,591 |
£73,086 |
£64,737 |
£50,840 |
£67,089 |
£74,436 |
£59,540 |
£75,686 |
£50,691 |
£48,842 |
£53,191 |
£88,783 |
| Shipping, etc. |
|
£3,000 |
£3,060 |
£3,121 |
£3,184 |
£3,247 |
£3,312 |
£3,378 |
£3,446 |
£3,515 |
£3,585 |
£3,657 |
£3,730 |
| Total Cost of Sales |
|
£52,591 |
£76,146 |
£67,858 |
£54,024 |
£70,336 |
£77,748 |
£62,918 |
£79,132 |
£54,206 |
£52,427 |
£56,848 |
£92,513 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gross Margin |
|
£22,131 |
£34,066 |
£28,834 |
£22,522 |
£31,029 |
£34,339 |
£28,048 |
£35,478 |
£22,814 |
£21,869 |
£23,672 |
£41,517 |
| Gross Margin % |
|
29.62% |
30.91% |
29.82% |
29.42% |
30.61% |
30.64% |
30.83% |
30.96% |
29.62% |
29.44% |
29.40% |
30.98% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Payroll |
|
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
| Marketing/Promotion |
|
£6,355 |
£7,788 |
£7,160 |
£6,257 |
£7,279 |
£7,676 |
£6,720 |
£7,815 |
£6,290 |
£6,180 |
£6,395 |
£8,540 |
| Depreciation |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Rent |
|
£1,300 |
£1,300 |
£1,300 |
£1,300 |
£1,300 |
£1,300 |
£1,300 |
£1,300 |
£1,300 |
£1,300 |
£1,300 |
£1,300 |
| Utilities |
|
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
| Insurance |
|
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
| Payroll Taxes |
18% |
£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 |
|
£10,076 |
£20,578 |
£15,974 |
£10,565 |
£18,050 |
£20,963 |
£15,628 |
£21,963 |
£10,824 |
£9,989 |
£11,577 |
£27,277 |
| EBITDA |
|
£10,076 |
£20,578 |
£15,974 |
£10,565 |
£18,050 |
£20,963 |
£15,628 |
£21,963 |
£10,824 |
£9,989 |
£11,577 |
£27,277 |
| Interest Expense |
|
£282 |
£273 |
£264 |
£255 |
£245 |
£236 |
£227 |
£218 |
£208 |
£199 |
£190 |
£181 |
| Taxes Incurred |
|
£2,938 |
£6,091 |
£4,713 |
£3,093 |
£5,341 |
£6,218 |
£4,620 |
£6,523 |
£3,185 |
£2,937 |
£3,416 |
£8,129 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Profit/Sales |
|
9.17% |
12.90% |
11.37% |
9.43% |
12.30% |
12.94% |
11.85% |
13.28% |
9.65% |
9.22% |
9.90% |
14.15% |

| Pro Forma Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Sales |
|
£56,042 |
£82,659 |
£72,519 |
£57,410 |
£76,024 |
£84,065 |
£68,225 |
£85,957 |
£57,765 |
£55,722 |
£60,390 |
£100,523 |
| Cash from Receivables |
|
£0 |
£623 |
£18,976 |
£27,440 |
£24,005 |
£19,343 |
£25,431 |
£27,846 |
£22,939 |
£28,339 |
£19,232 |
£18,626 |
| Subtotal Cash from Operations |
|
£56,042 |
£83,282 |
£91,495 |
£84,850 |
£100,029 |
£103,408 |
£93,655 |
£113,803 |
£80,704 |
£84,061 |
£79,622 |
£119,148 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£56,042 |
£83,282 |
£91,495 |
£84,850 |
£100,029 |
£103,408 |
£93,655 |
£113,803 |
£80,704 |
£84,061 |
£79,622 |
£119,148 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Spending |
|
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
£3,600 |
| Bill Payments |
|
£6,895 |
£113,925 |
£114,489 |
£73,015 |
£53,489 |
£101,543 |
£100,004 |
£63,364 |
£109,569 |
£41,694 |
£62,371 |
£75,757 |
| Subtotal Spent on Operations |
|
£10,495 |
£117,525 |
£118,089 |
£76,615 |
£57,089 |
£105,143 |
£103,604 |
£66,964 |
£113,169 |
£45,294 |
£65,971 |
£79,357 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£1,111 |
£1,111 |
£1,111 |
£1,111 |
£1,111 |
£1,111 |
£1,111 |
£1,111 |
£1,111 |
£1,111 |
£1,111 |
£1,111 |
| 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 |
|
£11,606 |
£118,636 |
£119,200 |
£77,726 |
£58,200 |
£106,254 |
£104,715 |
£68,075 |
£114,280 |
£46,405 |
£67,082 |
£80,468 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Balance |
|
£114,435 |
£79,081 |
£51,376 |
£58,500 |
£100,328 |
£97,483 |
£86,423 |
£132,150 |
£98,574 |
£136,230 |
£148,770 |
£187,451 |
| Pro Forma Balance Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash |
£70,000 |
£114,435 |
£79,081 |
£51,376 |
£58,500 |
£100,328 |
£97,483 |
£86,423 |
£132,150 |
£98,574 |
£136,230 |
£148,770 |
£187,451 |
| Accounts Receivable |
£0 |
£18,681 |
£45,611 |
£50,808 |
£42,504 |
£43,840 |
£52,518 |
£49,829 |
£50,636 |
£46,952 |
£37,187 |
£38,085 |
£52,967 |
| Inventory |
£0 |
£49,591 |
£73,086 |
£64,737 |
£50,840 |
£67,089 |
£74,436 |
£59,540 |
£75,686 |
£50,691 |
£48,842 |
£53,191 |
£88,783 |
| Other Current Assets |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Current Assets |
£70,000 |
£182,707 |
£197,778 |
£166,920 |
£151,844 |
£211,257 |
£224,437 |
£195,792 |
£258,472 |
£196,217 |
£222,259 |
£240,046 |
£329,200 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 | |