|
|
| Sales Forecast |
| Sales |
0% |
£54,000 |
£28,500 |
£44,500 |
£45,000 |
£57,000 |
£65,000 |
£67,000 |
£65,000 |
£70,000 |
£80,000 |
£55,000 |
£46,600 |
| Other |
0% |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Sales |
|
£54,000 |
£28,500 |
£44,500 |
£45,000 |
£57,000 |
£65,000 |
£67,000 |
£65,000 |
£70,000 |
£80,000 |
£55,000 |
£46,600 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
| Subtotal Direct Cost of Sales |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Personnel Plan |
| Name or Title or Group |
0% |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Name or Title or Group |
0% |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Name or Title or Group |
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 |
|
£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 Costs of Sales |
|
£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 |
|
£54,000 |
£28,500 |
£44,500 |
£45,000 |
£57,000 |
£65,000 |
£67,000 |
£65,000 |
£70,000 |
£80,000 |
£55,000 |
£46,600 |
| 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 |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Marketing/Promotion |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Depreciation |
|
£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 |
| 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 |
| 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 |
|
£54,000 |
£28,500 |
£44,500 |
£45,000 |
£57,000 |
£65,000 |
£67,000 |
£65,000 |
£70,000 |
£80,000 |
£55,000 |
£46,600 |
| EBITDA |
|
£54,000 |
£28,500 |
£44,500 |
£45,000 |
£57,000 |
£65,000 |
£67,000 |
£65,000 |
£70,000 |
£80,000 |
£55,000 |
£46,600 |
| Interest Expense |
|
£3,767 |
£3,767 |
£3,767 |
£3,767 |
£3,767 |
£3,767 |
£3,767 |
£3,767 |
£3,767 |
£3,767 |
£3,767 |
£3,767 |
| Taxes Incurred |
|
£15,070 |
£7,420 |
£12,220 |
£12,370 |
£15,970 |
£18,370 |
£18,970 |
£18,370 |
£19,870 |
£22,870 |
£15,370 |
£12,850 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Profit/Sales |
|
65.12% |
60.75% |
64.07% |
64.14% |
65.37% |
65.94% |
66.06% |
65.94% |
66.23% |
66.70% |
65.21% |
64.34% |

| Pro Forma Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Sales |
|
£13,500 |
£7,125 |
£11,125 |
£11,250 |
£14,250 |
£16,250 |
£16,750 |
£16,250 |
£17,500 |
£20,000 |
£13,750 |
£11,650 |
| Cash from Receivables |
|
£127,970 |
£129,320 |
£39,863 |
£21,775 |
£33,388 |
£34,050 |
£42,950 |
£48,800 |
£50,200 |
£48,875 |
£52,750 |
£59,375 |
| Subtotal Cash from Operations |
|
£141,470 |
£136,445 |
£50,988 |
£33,025 |
£47,638 |
£50,300 |
£59,700 |
£65,050 |
£67,700 |
£68,875 |
£66,500 |
£71,025 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£141,470 |
£136,445 |
£50,988 |
£33,025 |
£47,638 |
£50,300 |
£59,700 |
£65,050 |
£67,700 |
£68,875 |
£66,500 |
£71,025 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Spending |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Bill Payments |
|
£336,628 |
£18,582 |
£11,347 |
£15,992 |
£16,257 |
£19,817 |
£22,157 |
£22,717 |
£22,187 |
£23,737 |
£26,387 |
£19,053 |
| Subtotal Spent on Operations |
|
£336,628 |
£18,582 |
£11,347 |
£15,992 |
£16,257 |
£19,817 |
£22,157 |
£22,717 |
£22,187 |
£23,737 |
£26,387 |
£19,053 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£336,628 |
£18,582 |
£11,347 |
£15,992 |
£16,257 |
£19,817 |
£22,157 |
£22,717 |
£22,187 |
£23,737 |
£26,387 |
£19,053 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Balance |
|
£207,482 |
£325,345 |
£364,986 |
£382,019 |
£413,400 |
£443,883 |
£481,426 |
£523,759 |
£569,272 |
£614,410 |
£654,523 |
£706,495 |

| Pro Forma Balance Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash |
£402,640 |
£207,482 |
£325,345 |
£364,986 |
£382,019 |
£413,400 |
£443,883 |
£481,426 |
£523,759 |
£569,272 |
£614,410 |
£654,523 |
£706,495 |
| Accounts Receivable |
£255,940 |
£168,470 |
£60,525 |
£54,038 |
£66,013 |
£75,375 |
£90,075 |
£97,375 |
£97,325 |
£99,625 |
£110,750 |
£99,250 |
£74,825 |
| Other Current Assets |
£309,137 |
£309,137 |
£309,137 |
£309,137 |
£309,137 |
£309,137 |
£309,137 |
£309,137 |
£309,137 |
£309,137 |
£309,137 |
£309,137 |
£309,137 |
| Total Current Assets |
£967,717 |
£685,089 |
£695,007 |
£728,160 |
£757,168 |
£797,912 |
£843,095 |
£887,938 |
£930,221 |
£978,034 |
£1,034,297 |
£1,062,910 |
£1,090,457 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
£465,575 |
£465,575 |
£465,575 |
£465,575 |
£465,575 |
£465,575 |
£465,575 |
£465,575 |
£465,575 |
£465,575 |
£465,575 |
£465,575 |
£465,575 |
| Accumulated Depreciation |
£181,651 |
£181,651 |
£181,651 |
£181,651 |
£181,651 |
£181,651 |
£181,651 |
£181,651 |
£181,651 |
£181,651 |
£181,651 |
£181,651 |
£181,651 |
| Total Long-term Assets |
£283,924 |
£283,924 |
£283,924 |
£283,924 |
£283,924 |
£283,924 |
£283,924 |
£283,924 |
£283,924 |
£283,924 |
£283,924 |
£283,924 |
£283,924 |
| Total Assets |
£1,251,641 |
£969,013 |
£978,931 |
£1,012,084 |
£1,041,092 |
£1,081,836 |
£1,127,019 |
£1,171,862 |
£1,214,145 |
£1,261,958 |
£1,318,221 |
£1,346,834 |
£1,374,381 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Liabilities |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accounts Payable |
£336,000 |
£18,209 |
£10,814 |
£15,454 |
£15,599 |
£19,079 |
£21,399 |
£21,979 |
£21,399 |
£22,849 |
£25,749 |
£18,499 |
£16,063 |
| Current Borrowing |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Other Current Liabilities |
£100,362 |
£100,362 |
£100,362 |
£100,362 |
£100,362 |
£100,362 |
£100,362 |
£100,362 |
£100,362 |
£100,362 |
£100,362 |
£100,362 |
£100,362 |
| Subtotal Current Liabilities |
£436,362 |
£118,571 |
£111,176 |
£115,816 |
£115,961 |
£119,441 |
£121,761 |
£122,341 |
£121,761 |
£123,211 |
£126,111 |
£118,861 |
£116,425 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Liabilities |
£452,036 |
£452,036 |
£452,036 |
£452,036 |
£452,036 |
£452,036 |
£452,036 |
£452,036 |
£452,036 |
£452,036 |
£452,036 |
£452,036 |
£452,036 |
| Total Liabilities |
£888,398 |
£570,607 |
£563,212 |
£567,852 |
£567,997 |
£571,477 |
£573,797 |
£574,377 |
£573,797 |
£575,247 |
£578,147 |
£570,897 |
£568,461 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Paid-in Capital |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
| Retained Earnings |
£88,096 |
£363,143 |
£363,143 |
£363,143 |
£363,143 |
£363,143 |
£363,143 |
£363,143 |
£363,143 |
£363,143 |
£363,143 |
£363,143 |
£363,143 |
| Earnings |
£275,047 |
£35,163 |
£52,476 |
£80,989 |
£109,852 |
£147,116 |
£189,979 |
£234,242 |
£277,105 |
£323,468 |
£376,831 |
£412,694 |
£442,677 |
| Total Capital |
£363,243 |
£398,406 |
£415,719 |
£444,232 |
£473,095 |
£510,359 |
£553,222 |
£597,485 |
£640,348 |
£686,711 |
£740,074 |
£775,937 |
£805,920 |
| Total Liabilities and Capital |
£1,251,641 |
£969,013 |
£978,931 |
£1,012,084 |
£1,041,092 |
£1,081,836 |
£1,127,019 |
£1,171,862 |
£1,214,145 |
£1,261,958 |
£1,318,221 |
£1,346,834 |
£1,374,381 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Worth |
£363,243 |
£398,406 |
£415,719 |
£444,232 |
£473,095 |
£510,359 |
£553,222 |
£597,485 |
£640,348 |
£686,711 |
£740,074 |
£775,937 |
£805,920 |
|