|
|

| Sales Forecast |
| Machine Rental |
0% |
30 |
48 |
36 |
36 |
55 |
48 |
48 |
57 |
57 |
57 |
50 |
50 |
| Extra Mix |
0% |
10 |
20 |
10 |
15 |
25 |
20 |
20 |
25 |
25 |
25 |
25 |
25 |
| Other |
0% |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
| Total Unit Sales |
|
40 |
68 |
46 |
51 |
80 |
68 |
68 |
82 |
82 |
82 |
75 |
75 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Machine Rental |
|
£100.00 |
£100.00 |
£100.00 |
£100.00 |
£100.00 |
£100.00 |
£100.00 |
£100.00 |
£100.00 |
£100.00 |
£100.00 |
£100.00 |
| Extra Mix |
|
£15.00 |
£15.00 |
£15.00 |
£15.00 |
£15.00 |
£15.00 |
£15.00 |
£15.00 |
£15.00 |
£15.00 |
£15.00 |
£15.00 |
| Other |
|
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Machine Rental |
|
£3,000 |
£4,800 |
£3,600 |
£3,600 |
£5,500 |
£4,800 |
£4,800 |
£5,700 |
£5,700 |
£5,700 |
£5,000 |
£5,000 |
| Extra Mix |
|
£150 |
£300 |
£150 |
£225 |
£375 |
£300 |
£300 |
£375 |
£375 |
£375 |
£375 |
£375 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Sales |
|
£3,150 |
£5,100 |
£3,750 |
£3,825 |
£5,875 |
£5,100 |
£5,100 |
£6,075 |
£6,075 |
£6,075 |
£5,375 |
£5,375 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Machine Rental |
0.00% |
£7.60 |
£7.60 |
£7.60 |
£7.60 |
£7.60 |
£7.60 |
£7.60 |
£7.60 |
£7.60 |
£7.60 |
£7.60 |
£7.60 |
| Extra Mix |
0.00% |
£4.80 |
£4.80 |
£4.80 |
£4.80 |
£4.80 |
£4.80 |
£4.80 |
£4.80 |
£4.80 |
£4.80 |
£4.80 |
£4.80 |
| Other |
0.00% |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Machine Rental |
|
£228 |
£365 |
£274 |
£274 |
£418 |
£365 |
£365 |
£433 |
£433 |
£433 |
£380 |
£380 |
| Extra Mix |
|
£48 |
£96 |
£48 |
£72 |
£120 |
£96 |
£96 |
£120 |
£120 |
£120 |
£120 |
£120 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Direct Cost of Sales |
|
£276 |
£461 |
£322 |
£346 |
£538 |
£461 |
£461 |
£553 |
£553 |
£553 |
£500 |
£500 |
| Personnel Plan |
| Payroll |
0% |
£900 |
£900 |
£900 |
£900 |
£900 |
£900 |
£900 |
£950 |
£950 |
£950 |
£950 |
£950 |
| 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 |
|
£900 |
£900 |
£900 |
£900 |
£900 |
£900 |
£900 |
£950 |
£950 |
£950 |
£950 |
£950 |
| 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 |
|
£276 |
£461 |
£322 |
£346 |
£538 |
£461 |
£461 |
£553 |
£553 |
£553 |
£500 |
£500 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Cost of Sales |
|
£276 |
£461 |
£322 |
£346 |
£538 |
£461 |
£461 |
£553 |
£553 |
£553 |
£500 |
£500 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gross Margin |
|
£2,874 |
£4,639 |
£3,428 |
£3,479 |
£5,337 |
£4,639 |
£4,639 |
£5,522 |
£5,522 |
£5,522 |
£4,875 |
£4,875 |
| Gross Margin % |
|
91.24% |
90.96% |
91.42% |
90.96% |
90.84% |
90.96% |
90.96% |
90.89% |
90.89% |
90.89% |
90.70% |
90.70% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Payroll |
|
£900 |
£900 |
£900 |
£900 |
£900 |
£900 |
£900 |
£950 |
£950 |
£950 |
£950 |
£950 |
| Sales and Marketing and Other Expenses |
|
£20 |
£30 |
£30 |
£20 |
£20 |
£20 |
£30 |
£20 |
£20 |
£20 |
£20 |
£30 |
| Depreciation |
|
£13 |
£13 |
£13 |
£13 |
£13 |
£13 |
£13 |
£13 |
£13 |
£13 |
£10 |
£11 |
| 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 |
|
£1,942 |
£3,697 |
£2,486 |
£2,546 |
£4,404 |
£3,706 |
£3,696 |
£4,539 |
£4,539 |
£4,539 |
£3,895 |
£3,884 |
| EBITDA |
|
£1,954 |
£3,709 |
£2,498 |
£2,559 |
£4,417 |
£3,719 |
£3,709 |
£4,552 |
£4,552 |
£4,552 |
£3,905 |
£3,895 |
| Interest Expense |
|
£91 |
£90 |
£89 |
£88 |
£87 |
£86 |
£86 |
£85 |
£84 |
£83 |
£82 |
£81 |
| Taxes Incurred |
|
£555 |
£902 |
£599 |
£615 |
£1,079 |
£905 |
£903 |
£1,114 |
£1,114 |
£1,114 |
£953 |
£951 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Profit/Sales |
|
41.13% |
53.04% |
47.94% |
48.20% |
55.11% |
53.23% |
53.10% |
54.99% |
55.00% |
55.01% |
53.20% |
53.06% |

| Pro Forma Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Sales |
|
£3,150 |
£5,100 |
£3,750 |
£3,825 |
£5,875 |
£5,100 |
£5,100 |
£6,075 |
£6,075 |
£6,075 |
£5,375 |
£5,375 |
| Subtotal Cash from Operations |
|
£3,150 |
£5,100 |
£3,750 |
£3,825 |
£5,875 |
£5,100 |
£5,100 |
£6,075 |
£6,075 |
£6,075 |
£5,375 |
£5,375 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£3,150 |
£5,100 |
£3,750 |
£3,825 |
£5,875 |
£5,100 |
£5,100 |
£6,075 |
£6,075 |
£6,075 |
£5,375 |
£5,375 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Spending |
|
£900 |
£900 |
£900 |
£900 |
£900 |
£900 |
£900 |
£950 |
£950 |
£950 |
£950 |
£950 |
| Bill Payments |
|
£22 |
£711 |
£1,978 |
£752 |
£1,705 |
£1,214 |
£1,978 |
£1,058 |
£2,185 |
£1,251 |
£2,178 |
£1,089 |
| Subtotal Spent on Operations |
|
£922 |
£1,611 |
£2,878 |
£1,652 |
£2,605 |
£2,114 |
£2,878 |
£2,008 |
£3,135 |
£2,201 |
£3,128 |
£2,039 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
| 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 |
|
£1,022 |
£1,711 |
£2,978 |
£1,752 |
£2,705 |
£2,214 |
£2,978 |
£2,108 |
£3,235 |
£2,301 |
£3,228 |
£2,139 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Balance |
|
£2,967 |
£6,356 |
£7,128 |
£9,201 |
£12,372 |
£15,258 |
£17,379 |
£21,346 |
£24,186 |
£27,961 |
£30,107 |
£33,343 |

| Pro Forma Balance Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash |
£839 |
£2,967 |
£6,356 |
£7,128 |
£9,201 |
£12,372 |
£15,258 |
£17,379 |
£21,346 |
£24,186 |
£27,961 |
£30,107 |
£33,343 |
| Inventory |
£700 |
£424 |
£963 |
£642 |
£1,296 |
£758 |
£1,297 |
£836 |
£1,283 |
£730 |
£1,177 |
£677 |
£1,177 |
| Other Current Assets |
£1,260 |
£1,260 |
£1,260 |
£1,260 |
£1,260 |
£1,260 |
£1,260 |
£1,260 |
£1,260 |
£1,260 |
£1,260 |
£1,260 |
£1,260 |
| Total Current Assets |
£2,799 |
£4,651 |
£8,579 |
£9,029 |
£11,757 |
£14,390 |
£17,815 |
£19,476 |
£23,889 |
£26,176 |
£30,397 |
£32,044 |
£35,780 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
£9,000 |
£9,000 |
£9,000 |
£9,000 |
£9,000 |
£9,000 |
£9,000 |
£9,000 |
£9,000 |
£9,000 |
£9,000 |
£9,000 |
£9,000 |
| Accumulated Depreciation |
£0 |
£13 |
£25 |
£38 |
£51 |
£64 |
£77 |
£90 |
£103 |
£116 |
£129 |
£139 |
£150 |
| Total Long-term Assets |
£9,000 |
£8,988 |
£8,975 |
£8,963 |
£8,950 |
£8,937 |
£8,924 |
£8,911 |
£8,898 |
£8,885 |
£8,872 |
£8,862 |
£8,851 |
| Total Assets |
£11,799 |
£13,638 |
£17,554 |
£17,992 |
£20,707 |
£23,326 |
£26,738 |
£28,386 |
£32,787 |
£35,061 |
£39,269 |
£40,906 |
£44,631 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Liabilities |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accounts Payable |
£0 |
£644 |
£1,954 |
£694 |
£1,665 |
£1,147 |
£1,944 |
£984 |
£2,144 |
£1,177 |
£2,143 |
£1,020 |
£1,993 |
| 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 |
£644 |
£1,954 |
£694 |
£1,665 |
£1,147 |
£1,944 |
£984 |
£2,144 |
£1,177 |
£2,143 |
£1,020 |
£1,993 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Liabilities |
£10,960 |
£10,860 |
£10,760 |
£10,660 |
£10,560 |
£10,460 |
£10,360 |
£10,260 |
£10,160 |
£10,060 |
£9,960 |
£9,860 |
£9,760 |
| Total Liabilities |
£10,960 |
£11,504 |
£12,714 |
£11,354 |
£12,225 |
£11,607 |
£12,304 |
£11,244 |
£12,304 |
£11,237 |
£12,103 |
£10,880 |
£11,753 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Paid-in Capital |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
| Retained Earnings |
(£161) |
(£161) |
(£161) |
(£161) |
(£161) |
| |