|
|

| Sales Forecast |
| Executive desk oak |
15% |
14 |
16 |
16 |
16 |
15 |
12 |
12 |
15 |
15 |
26 |
27 |
25 |
| Executive desk cherry |
5% |
2 |
3 |
3 |
3 |
2 |
2 |
2 |
2 |
3 |
4 |
3 |
2 |
| Other furniture oak |
5% |
3 |
4 |
4 |
4 |
3 |
3 |
3 |
4 |
4 |
4 |
5 |
4 |
| Other furniture cherry |
5% |
0 |
1 |
0 |
0 |
0 |
1 |
0 |
1 |
1 |
1 |
1 |
1 |
| Other |
20% |
1 |
0 |
0 |
1 |
1 |
0 |
1 |
0 |
0 |
1 |
1 |
0 |
| Total Unit Sales |
|
20 |
24 |
23 |
24 |
21 |
18 |
18 |
22 |
23 |
36 |
37 |
32 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Executive desk oak |
|
£1,600.00 |
£1,600.00 |
£1,600.00 |
£1,600.00 |
£1,600.00 |
£1,600.00 |
£1,600.00 |
£1,600.00 |
£1,600.00 |
£1,600.00 |
£1,600.00 |
£1,600.00 |
| Executive desk cherry |
|
£1,750.00 |
£1,750.00 |
£1,750.00 |
£1,750.00 |
£1,750.00 |
£1,750.00 |
£1,750.00 |
£1,750.00 |
£1,750.00 |
£1,750.00 |
£1,750.00 |
£1,750.00 |
| Other furniture oak |
|
£900.00 |
£900.00 |
£900.00 |
£900.00 |
£900.00 |
£900.00 |
£900.00 |
£900.00 |
£900.00 |
£900.00 |
£900.00 |
£900.00 |
| Other furniture cherry |
|
£1,000.00 |
£1,000.00 |
£1,000.00 |
£1,000.00 |
£1,000.00 |
£1,000.00 |
£1,000.00 |
£1,000.00 |
£1,000.00 |
£1,000.00 |
£1,000.00 |
£1,000.00 |
| Other |
|
£2,500.00 |
£2,500.00 |
£2,500.00 |
£2,500.00 |
£2,500.00 |
£2,500.00 |
£2,500.00 |
£2,500.00 |
£2,500.00 |
£2,500.00 |
£2,500.00 |
£2,500.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Executive desk oak |
|
£22,400 |
£25,600 |
£25,600 |
£25,600 |
£24,000 |
£19,200 |
£19,200 |
£24,000 |
£24,000 |
£41,600 |
£43,200 |
£40,000 |
| Executive desk cherry |
|
£3,500 |
£5,250 |
£5,250 |
£5,250 |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
£5,250 |
£7,000 |
£5,250 |
£3,500 |
| Other furniture oak |
|
£2,700 |
£3,600 |
£3,600 |
£3,600 |
£2,700 |
£2,700 |
£2,700 |
£3,600 |
£3,600 |
£3,600 |
£4,500 |
£3,600 |
| Other furniture cherry |
|
£0 |
£1,000 |
£0 |
£0 |
£0 |
£1,000 |
£0 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
| Other |
|
£2,500 |
£0 |
£0 |
£2,500 |
£2,500 |
£0 |
£2,500 |
£0 |
£0 |
£2,500 |
£2,500 |
£0 |
| Total Sales |
|
£31,100 |
£35,450 |
£34,450 |
£36,950 |
£32,700 |
£26,400 |
£27,900 |
£32,100 |
£33,850 |
£55,700 |
£56,450 |
£48,100 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Executive desk oak |
0.00% |
£400.00 |
£400.00 |
£400.00 |
£400.00 |
£400.00 |
£400.00 |
£400.00 |
£400.00 |
£400.00 |
£400.00 |
£400.00 |
£400.00 |
| Executive desk cherry |
0.00% |
£525.00 |
£525.00 |
£525.00 |
£525.00 |
£525.00 |
£525.00 |
£525.00 |
£525.00 |
£525.00 |
£525.00 |
£525.00 |
£525.00 |
| Other furniture oak |
0.00% |
£180.00 |
£180.00 |
£180.00 |
£180.00 |
£180.00 |
£180.00 |
£180.00 |
£180.00 |
£180.00 |
£180.00 |
£180.00 |
£180.00 |
| Other furniture cherry |
0.00% |
£300.00 |
£300.00 |
£300.00 |
£300.00 |
£300.00 |
£300.00 |
£300.00 |
£300.00 |
£300.00 |
£300.00 |
£300.00 |
£300.00 |
| Other |
0.00% |
£625.00 |
£625.00 |
£625.00 |
£625.00 |
£625.00 |
£625.00 |
£625.00 |
£625.00 |
£625.00 |
£625.00 |
£625.00 |
£625.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Executive desk oak |
|
£5,600 |
£6,400 |
£6,400 |
£6,400 |
£6,000 |
£4,800 |
£4,800 |
£6,000 |
£6,000 |
£10,400 |
£10,800 |
£10,000 |
| Executive desk cherry |
|
£1,050 |
£1,575 |
£1,575 |
£1,575 |
£1,050 |
£1,050 |
£1,050 |
£1,050 |
£1,575 |
£2,100 |
£1,575 |
£1,050 |
| Other furniture oak |
|
£540 |
£720 |
£720 |
£720 |
£540 |
£540 |
£540 |
£720 |
£720 |
£720 |
£900 |
£720 |
| Other furniture cherry |
|
£0 |
£300 |
£0 |
£0 |
£0 |
£300 |
£0 |
£300 |
£300 |
£300 |
£300 |
£300 |
| Other |
|
£625 |
£0 |
£0 |
£625 |
£625 |
£0 |
£625 |
£0 |
£0 |
£625 |
£625 |
£0 |
| Subtotal Direct Cost of Sales |
|
£7,815 |
£8,995 |
£8,695 |
£9,320 |
£8,215 |
£6,690 |
£7,015 |
£8,070 |
£8,595 |
£14,145 |
£14,200 |
£12,070 |

| Personnel Plan |
| Workshop manager |
5% |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
| Assembly |
5% |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
| Other |
|
£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 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal |
|
£4,300 |
£4,300 |
£4,300 |
£4,300 |
£4,300 |
£4,300 |
£4,300 |
£4,300 |
£4,300 |
£4,300 |
£4,300 |
£4,300 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Marketing manager |
5% |
£4,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
| Name or title |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Name or title |
|
£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 |
|
£4,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| President |
5% |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
| Name or title |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Name or title |
|
£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 |
|
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Design |
5% |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
| Name or title |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Name or title |
|
£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 |
|
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total People |
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Payroll |
|
£12,550 |
£11,550 |
£11,550 |
£11,550 |
£11,550 |
£11,550 |
£11,550 |
£11,550 |
£11,550 |
£11,550 |
£11,550 |
£11,550 |
| 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 |
|
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.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 |
|
£7,815 |
£8,995 |
£8,695 |
£9,320 |
£8,215 |
£6,690 |
£7,015 |
£8,070 |
£8,595 |
£14,145 |
£14,200 |
£12,070 |
| Production Payroll |
|
£4,300 |
£4,300 |
£4,300 |
£4,300 |
£4,300 |
£4,300 |
£4,300 |
£4,300 |
£4,300 |
£4,300 |
£4,300 |
£4,300 |
| Other |
|
£3,110 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Cost of Sales |
|
£15,225 |
£13,295 |
£12,995 |
£13,620 |
£12,515 |
£10,990 |
£11,315 |
£12,370 |
£12,895 |
£18,445 |
£18,500 |
£16,370 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gross Margin |
|
£15,875 |
£22,155 |
£21,455 |
£23,330 |
£20,185 |
£15,410 |
£16,585 |
£19,730 |
£20,955 |
£37,255 |
£37,950 |
£31,730 |
| Gross Margin % |
|
51.05% |
62.50% |
62.28% |
63.14% |
61.73% |
58.37% |
59.44% |
61.46% |
61.91% |
66.89% |
67.23% |
65.97% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sales and Marketing Payroll |
|
£4,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
| Miscellaneous |
|
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
| Advertising/Promotion |
|
£8,000 |
£8,000 |
£0 |
£8,000 |
£8,000 |
£0 |
£8,000 |
£8,000 |
£0 |
£8,000 |
£8,000 |
£0 |
| Events |
|
£0 |
£750 |
£0 |
£0 |
£3,000 |
£0 |
£0 |
£0 |
£0 |
£2,500 |
£0 |
£0 |
| Public Relations |
|
£0 |
£250 |
£0 |
£0 |
£500 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Travel |
|
£0 |
£500 |
£0 |
£0 |
£2,000 |
£0 |
£500 |
£0 |
£0 |
£1,500 |
£0 |
£0 |
| Total Sales and Marketing Expenses |
|
£12,200 |
£12,700 |
£3,200 |
£11,200 |
£16,700 |
£3,200 |
£11,700 |
£11,200 |
£3,200 |
£15,200 |
£11,200 |
£3,200 |
| Sales and Marketing % |
|
39.23% |
35.83% |
9.29% |
30.31% |
51.07% |
12.12% |
41.94% |
34.89% |
9.45% |
27.29% |
19.84% |
6.65% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| General and Administrative Payroll |
|
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
| Sales and Marketing and Other Expenses |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Depreciation |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£1,000 |
| Depreciation |
|
£125 |
£125 |
£125 |
£125 |
£125 |
£125 |
£125 |
£125 |
£125 |
£125 |
£125 |
£125 |
| Utilities |
|
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
| Insurance |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£500 |
| Rent |
|
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
| Other |
|
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
| Payroll Taxes |
15% |
£1,883 |
£1,733 |
£1,733 |
£1,733 |
£1,733 |
£1,733 |
£1,733 |
£1,733 |
£1,733 |
£1,733 |
£1,733 |
£1,733 |
| Other General and Administrative Expenses |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total General and Administrative Expenses |
|
£6,608 |
£6,458 |
£6,458 |
£6,458 |
£6,458 |
£6,458 |
£6,458 |
£6,458 |
£6,458 |
£6,458 |
£6,458 |
£7,958 |
| General and Administrative % |
|
21.25% |
18.22% |
18.74% |
17.48% |
19.75% |
24.46% |
23.15% |
20.12% |
19.08% |
11.59% |
11.44% |
16.54% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Other Payroll |
|
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
| Consultants |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Contract/Consultants |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Other Expenses |
|
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
£250 |
| Other % |
|
0.80% |
0.71% |
0.73% |
0.68% |
0.76% |
0.95% |
0.90% |
0.78% |
0.74% |
0.45% |
0.44% |
0.52% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Profit Before Interest and Taxes |
|
(£3,183) |
£2,748 |
£11,548 |
£5,423 |
(£3,223) |
£5,503 |
(£1,823) |
£1,823 |
£11,048 |
£15,348 |
£20,043 |
£20,323 |
| EBITDA |
|
(£3,183) |
£2,748 |
£11,548 |
£5,423 |
(£3,223) |
£5,503 |
(£1,823) |
£1,823 |
£11,048 |
£15,348 |
£20,043 |
£21,323 |
| Interest Expense |
|
£625 |
£667 |
£667 |
£708 |
£667 |
£625 |
£625 |
£667 |
£708 |
£875 |
£958 |
£958 |
| Taxes Incurred |
|
(£1,142) |
£520 |
£2,720 |
£1,179 |
(£972) |
£1,219 |
(£612) |
£289 |
£2,585 |
£3,618 |
£4,771 |
£4,841 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Profit/Sales |
|
-8.57% |
4.40% |
23.69% |
9.57% |
-8.92% |
13.86% |
-6.58% |
2.70% |
22.91% |
19.49% |
25.36% |
30.19% |
| Pro Forma Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Sales |
|
£7,775 |
£8,863 |
£8,613 |
£9,238 |
£8,175 |
£6,600 |
£6,975 |
£8,025 |
£8,463 |
£13,925 |
£14,113 |
£12,025 |
| Cash from Receivables |
| |