|
|
| Sales Forecast |
| Commercial Buildings |
0% |
£0 |
£0 |
£8,000 |
£0 |
£13,000 |
£30,000 |
£40,000 |
£50,000 |
£10,000 |
£28,000 |
£0 |
£0 |
| Residential Buildings |
0% |
£5,000 |
£10,000 |
£12,000 |
£17,000 |
£20,000 |
£20,000 |
£28,000 |
£8,500 |
£15,000 |
£13,000 |
£5,000 |
£4,000 |
| Total Sales |
|
£5,000 |
£10,000 |
£20,000 |
£17,000 |
£33,000 |
£50,000 |
£68,000 |
£58,500 |
£25,000 |
£41,000 |
£5,000 |
£4,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Commercial Buildings |
|
£0 |
£0 |
£1,760 |
£0 |
£2,860 |
£6,600 |
£8,000 |
£11,500 |
£2,200 |
£7,560 |
£0 |
£0 |
| Residential Buildings |
|
£1,500 |
£3,000 |
£3,600 |
£5,100 |
£6,000 |
£6,000 |
£8,400 |
£2,550 |
£4,500 |
£3,900 |
£1,500 |
£1,200 |
| Subtotal Direct Cost of Sales |
|
£1,500 |
£3,000 |
£5,360 |
£5,100 |
£8,860 |
£12,600 |
£16,400 |
£14,050 |
£6,700 |
£11,460 |
£1,500 |
£1,200 |

| Personnel Plan |
| Project Forman #1 |
|
£1,900 |
£1,900 |
£1,900 |
£1,900 |
£1,900 |
£1,900 |
£1,900 |
£1,900 |
£1,900 |
£1,900 |
£1,900 |
£1,900 |
| Project Foreman #2 |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Residential Painter |
|
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
| Residential Painter |
|
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
| Residential Painter |
|
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
| Commercial Painter |
|
£0 |
£0 |
£1,075 |
£0 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£0 |
£0 |
| Commercial Painter |
|
£0 |
£0 |
£1,075 |
£0 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£0 |
£0 |
| Commercial Painter |
|
£0 |
£0 |
£1,075 |
£0 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£1,075 |
£0 |
£0 |
| Commercial Painter |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Commercial Painter |
|
£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 |
|
£5,125 |
£5,125 |
£8,350 |
£5,125 |
£8,350 |
£8,350 |
£8,350 |
£8,350 |
£8,350 |
£8,350 |
£5,125 |
£5,125 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mr. Anthony Barnum, Contracting and Sales |
|
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal |
|
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mr. William Barnum. Operations |
|
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
| Mr. Michael Kruger, Expeditor and Q&A |
|
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
| Expeditor |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Expeditor |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal |
|
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total People |
|
7 |
7 |
10 |
7 |
10 |
10 |
10 |
10 |
10 |
10 |
7 |
7 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Payroll |
|
£12,625 |
£12,625 |
£15,850 |
£12,625 |
£15,850 |
£15,850 |
£15,850 |
£15,850 |
£15,850 |
£15,850 |
£12,625 |
£12,625 |
| 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% |
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 |
| Direct Cost of Sales |
|
£1,500 |
£3,000 |
£5,360 |
£5,100 |
£8,860 |
£12,600 |
£16,400 |
£14,050 |
£6,700 |
£11,460 |
£1,500 |
£1,200 |
| Production Payroll |
|
£5,125 |
£5,125 |
£8,350 |
£5,125 |
£8,350 |
£8,350 |
£8,350 |
£8,350 |
£8,350 |
£8,350 |
£5,125 |
£5,125 |
| Other Production Expenses |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Cost of Sales |
|
£6,625 |
£8,125 |
£13,710 |
£10,225 |
£17,210 |
£20,950 |
£24,750 |
£22,400 |
£15,050 |
£19,810 |
£6,625 |
£6,325 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gross Margin |
|
(£1,625) |
£1,875 |
£6,290 |
£6,775 |
£15,790 |
£29,050 |
£43,250 |
£36,100 |
£9,950 |
£21,190 |
(£1,625) |
(£2,325) |
| Gross Margin % |
|
-32.50% |
18.75% |
31.45% |
39.85% |
47.85% |
58.10% |
63.60% |
61.71% |
39.80% |
51.68% |
-32.50% |
-58.13% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sales and Marketing Payroll |
|
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
| Advertising/Promotion |
|
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
| Travel |
|
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
| Miscellaneous |
|
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
| Total Sales and Marketing Expenses |
|
£3,200 |
£3,200 |
£3,200 |
£3,200 |
£3,200 |
£3,200 |
£3,200 |
£3,200 |
£3,200 |
£3,200 |
£3,200 |
£3,200 |
| Sales and Marketing % |
|
64.00% |
32.00% |
16.00% |
18.82% |
9.70% |
6.40% |
4.71% |
5.47% |
12.80% |
7.80% |
64.00% |
80.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| General and Administrative Payroll |
|
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
| Sales and Marketing and Other Expenses |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Depreciation |
|
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
| Leased Equipment |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Utilities |
|
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
| Insurance |
|
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
| Rent |
|
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
| Payroll Taxes |
15% |
£1,894 |
£1,894 |
£2,378 |
£1,894 |
£2,378 |
£2,378 |
£2,378 |
£2,378 |
£2,378 |
£2,378 |
£1,894 |
£1,894 |
| Other General and Administrative Expenses |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total General and Administrative Expenses |
|
£9,444 |
£9,444 |
£9,928 |
£9,444 |
£9,928 |
£9,928 |
£9,928 |
£9,928 |
£9,928 |
£9,928 |
£9,444 |
£9,444 |
| General and Administrative % |
|
188.88% |
94.44% |
49.64% |
55.55% |
30.08% |
19.86% |
14.60% |
16.97% |
39.71% |
24.21% |
188.88% |
236.09% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Other Payroll |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Consultants |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Bookkeeper and acountant |
|
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
| Total Other Expenses |
|
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
| Other % |
|
4.00% |
2.00% |
1.00% |
1.18% |
0.61% |
0.40% |
0.29% |
0.34% |
0.80% |
0.49% |
4.00% |
5.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Profit Before Interest and Taxes |
|
(£14,469) |
(£10,969) |
(£7,038) |
(£6,069) |
£2,463 |
£15,723 |
£29,923 |
£22,773 |
(£3,378) |
£7,863 |
(£14,469) |
(£15,169) |
| EBITDA |
|
(£14,369) |
(£10,869) |
(£6,938) |
(£5,969) |
£2,563 |
£15,823 |
£30,023 |
£22,873 |
(£3,278) |
£7,963 |
(£14,369) |
(£15,069) |
| Interest Expense |
|
£58 |
£58 |
£58 |
£58 |
£58 |
£58 |
£58 |
£58 |
£58 |
£58 |
£58 |
£58 |
| Taxes Incurred |
|
(£4,358) |
(£3,308) |
(£2,129) |
(£1,838) |
£721 |
£4,699 |
£8,959 |
£6,814 |
(£1,031) |
£2,341 |
(£4,358) |
(£4,568) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Profit/Sales |
|
-203.38% |
-77.19% |
-24.84% |
-25.23% |
5.10% |
21.93% |
30.74% |
27.18% |
-9.62% |
13.32% |
-203.38% |
-266.47% |

| Pro Forma Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Sales |
|
£2,500 |
£5,000 |
£10,000 |
£8,500 |
£16,500 |
£25,000 |
£34,000 |
£29,250 |
£12,500 |
£20,500 |
£2,500 |
£2,000 |
| Cash from Receivables |
|
£0 |
£83 |
£2,583 |
£5,167 |
£9,950 |
£8,767 |
£16,783 |
£25,300 |
£33,842 |
£28,692 |
£12,767 |
£19,900 |
| Subtotal Cash from Operations |
|
£2,500 |
£5,083 |
£12,583 |
£13,667 |
£26,450 |
£33,767 |
£50,783 |
£54,550 |
£46,342 |
£49,192 |
£15,267 |
£21,900 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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,500 |
£5,083 |
£12,583 |
£13,667 |
£26,450 |
£33,767 |
£50,783 |
£54,550 |
£46,342 |
£49,192 |
£15,267 |
£21,900 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Spending |
|
£12,625 |
£12,625 |
£15,850 |
£12,625 |
£15,850 |
£15,850 |
£15,850 |
£15,850 |
£15,850 |
£15,850 |
£12,625 |
£12,625 |
| Bill Payments |
|
£108 |
£3,357 |
£6,810 |
£11,502 |
£8,652 |
£19,760 |
£27,470 |
£34,950 |
£23,421 |
£5,378 |
£22,688 |
£937 |
| Subtotal Spent on Operations |
|
£12,733 |
£15,982 |
£22,660 |
£24,127 |
£24,502 |
£35,610 |
£43,320 |
£50,800 |
£39,271 |
£21,228 |
£35,313 |
£13,562 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£12,733 |
£15,982 |
£22,660 |
| |