| Sales Forecast | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | |||||||||||||
| Placement Fees | 0% | £3,660 | £4,769 | £5,965 | £7,226 | £9,471 | £12,554 | £12,237 | £10,216 | £3,692 | £7,458 | £7,059 | £9,941 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £3,660 | £4,769 | £5,965 | £7,226 | £9,471 | £12,554 | £12,237 | £10,216 | £3,692 | £7,458 | £7,059 | £9,941 | |
| Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Placement Fees | £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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Placed Employees Personnel | |||||||||||||
| Placed Workers at 2/3 of Sales | £2,013 | £2,623 | £3,281 | £3,974 | £5,209 | £6,905 | £6,730 | £5,619 | £2,031 | £4,102 | £3,882 | £5,467 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £2,013 | £2,623 | £3,281 | £3,974 | £5,209 | £6,905 | £6,730 | £5,619 | £2,031 | £4,102 | £3,882 | £5,467 | |
| General and Administrative Personnel | |||||||||||||
| Office Employees | £0 | £213 | £350 | £350 | £350 | £466 | £700 | £1,500 | £1,750 | £1,750 | £1,750 | £1,750 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £0 | £213 | £350 | £350 | £350 | £466 | £700 | £1,500 | £1,750 | £1,750 | £1,750 | £1,750 | |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £2,013 | £2,836 | £3,631 | £4,324 | £5,559 | £7,371 | £7,430 | £7,119 | £3,781 | £5,852 | £5,632 | £7,217 | |
| General Assumptions | ||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| 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 | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £3,660 | £4,769 | £5,965 | £7,226 | £9,471 | £12,554 | £12,237 | £10,216 | £3,692 | £7,458 | £7,059 | £9,941 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Placed Employees Payroll | £2,013 | £2,623 | £3,281 | £3,974 | £5,209 | £6,905 | £6,730 | £5,619 | £2,031 | £4,102 | £3,882 | £5,467 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £2,013 | £2,623 | £3,281 | £3,974 | £5,209 | £6,905 | £6,730 | £5,619 | £2,031 | £4,102 | £3,882 | £5,467 | |
| Gross Margin | £1,647 | £2,146 | £2,684 | £3,252 | £4,262 | £5,649 | £5,507 | £4,597 | £1,661 | £3,356 | £3,177 | £4,474 | |
| Gross Margin % | 45.00% | 45.00% | 45.00% | 45.00% | 45.00% | 45.00% | 45.00% | 45.00% | 44.99% | 45.00% | 45.01% | 45.00% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Advertising/Promotion | £12 | £0 | £0 | £23 | £10 | £111 | £27 | £72 | £30 | £599 | £102 | £179 | |
| Bank Service Charges | £0 | £57 | £3 | £73 | £539 | £106 | £38 | £3 | £8 | £48 | £129 | £15 | |
| Contributions | £0 | £0 | £0 | £100 | £5 | £0 | £0 | £100 | £0 | £0 | £0 | £50 | |
| Dues & Subscriptions | £43 | £30 | £54 | £0 | £0 | £21 | £275 | £94 | £0 | £250 | £60 | £60 | |
| Total Sales and Marketing Expenses | £55 | £87 | £57 | £196 | £554 | £239 | £340 | £268 | £38 | £897 | £291 | £304 | |
| Sales and Marketing % | 1.50% | 1.82% | 0.95% | 2.71% | 5.85% | 1.90% | 2.78% | 2.63% | 1.02% | 12.03% | 4.12% | 3.06% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £0 | £213 | £350 | £350 | £350 | £466 | £700 | £1,500 | £1,750 | £1,750 | £1,750 | £1,750 | |
| Marketing/Promotion | £213 | £236 | £331 | £691 | £756 | £656 | £592 | £441 | £154 | £1,149 | £784 | £514 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Telephone & Pager | £226 | £88 | £416 | £125 | £374 | £220 | £439 | £638 | £697 | £240 | £616 | £90 | |
| Recruitment | £115 | £77 | £189 | £220 | £71 | £147 | £106 | £251 | £45 | £192 | £65 | £95 | |
| Referral Fees | £0 | £20 | £0 | £50 | £0 | £100 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £195 | £195 | £195 | £195 | £195 | £195 | £983 | £788 | £788 | £788 | £788 | £798 | |
| Office Supplies | £92 | £188 | £96 | £197 | £49 | £62 | £116 | £442 | £24 | £670 | £177 | £0 | |
| Postage | £9 | £49 | £55 | £107 | £133 | £94 | £36 | £99 | £8 | £175 | £89 | £209 | |
| Printing | £0 | £2 | £669 | £26 | £290 | £350 | £175 | £224 | £832 | £179 | £520 | £94 | |
| Professional Fees | £240 | £170 | £664 | £988 | £367 | £270 | £0 | £528 | £844 | £342 | £2,013 | £516 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Maintenance and Repairs | £0 | £0 | £103 | £100 | £0 | £25 | £0 | £39 | £0 | £0 | £44 | £0 | |
| Total General and Administrative Expenses | £1,090 | £1,239 | £3,068 | £3,049 | £2,585 | £2,585 | £3,146 | £4,949 | £5,142 | £5,485 | £6,845 | £4,065 | |
| General and Administrative % | 29.77% | 25.97% | 51.43% | 42.19% | 27.30% | 20.59% | 25.71% | 48.45% | 139.28% | 73.55% | 96.97% | 40.90% | |
| Other Expenses: | |||||||||||||
| 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 | |
| Misc. | £40 | £0 | £44 | £244 | £90 | £240 | £159 | £0 | £40 | £20 | £173 | £0 | |
| Total Other Expenses | £40 | £0 | £44 | £244 | £90 | £240 | £159 | £0 | £40 | £20 | £173 | £0 | |
| Other % | 1.09% | 0.00% | 0.74% | 3.38% | 0.95% | 1.91% | 1.30% | 0.00% | 1.08% | 0.27% | 2.45% | 0.00% | |
| Total Operating Expenses | £1,185 | £1,325 | £3,168 | £3,488 | £3,229 | £3,064 | £3,645 | £5,218 | £5,220 | £6,403 | £7,309 | £4,369 | |
| Profit Before Interest and Taxes | £462 | £821 | (£484) | (£236) | £1,033 | £2,585 | £1,862 | (£621) | (£3,559) | (£3,047) | (£4,132) | £104 | |
| EBITDA | £462 | £821 | (£484) | (£236) | £1,033 | £2,585 | £1,862 | (£621) | (£3,559) | (£3,047) | (£4,132) | £104 | |
| Interest Expense | £283 | £281 | £260 | £258 | £256 | £254 | £251 | £245 | £243 | £241 | £238 | £236 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | £180 | £540 | (£744) | (£494) | £777 | £2,332 | £1,610 | (£866) | (£3,802) | (£3,287) | (£4,370) | (£132) | |
| Net Profit/Sales | 4.90% | 11.32% | -12.48% | -6.84% | 8.21% | 18.57% | 13.16% | -8.47% | -102.97% | -44.08% | -61.91% | -1.33% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £915 | £1,192 | £1,491 | £1,807 | £2,368 | £3,139 | £3,059 | £2,554 | £923 | £1,865 | £1,765 | £2,485 | |
| Cash from Receivables | £0 | £92 | £2,773 | £3,607 | £4,505 | £5,476 | £7,180 | £9,408 | £9,127 | £7,499 | £2,863 | £5,584 | |
| Subtotal Cash from Operations | £915 | £1,284 | £4,264 | £5,413 | £6,873 | £8,614 | £10,240 | £11,962 | £10,050 | £9,363 | £4,628 | £8,069 | |
| 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 | £10,000 | |
| Subtotal Cash Received | £915 | £1,284 | £4,264 | £5,413 | £6,873 | £8,614 | £10,240 | £11,962 | £10,050 | £9,363 | £4,628 | £18,069 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £2,013 | £2,836 | £3,631 | £4,324 | £5,559 | £7,371 | £7,430 | £7,119 | £3,781 | £5,852 | £5,632 | £7,217 | |
| Bill Payments | £193 | £1,465 | £1,449 | £3,089 | £3,388 | £3,125 | £2,863 | £3,222 | £3,954 | £3,752 | £4,923 | £5,699 | |
| Subtotal Spent on Operations | £2,206 | £4,301 | £5,080 | £7,413 | £8,947 | £10,496 | £10,293 | £10,341 | £7,735 | £9,604 | £10,555 | £12,916 | |
| 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 | £2,220 | £0 | £0 | £0 | £0 | £500 | £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 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | |
| 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 | £2,581 | £4,676 | £7,675 | £7,788 | £9,322 | £10,871 | £10,668 | £11,216 | £8,110 | £9,979 | £10,930 | £13,291 | |
| Net Cash Flow | (£1,666) | (£3,392) | (£3,411) | (£2,375) | (£2,449) | (£2,257) | (£428) | £745 | £1,940 | (£616) | (£6,303) | £4,777 | |
| Cash Balance | £44,334 | £40,942 | £37,530 | £35,156 | £32,707 | £30,450 | £30,022 | £30,767 | £32,707 | £32,091 | £25,789 | £30,566 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £46,000 | £44,334 | £40,942 | £37,530 | £35,156 | £32,707 | £30,450 | £30,022 | £30,767 | £32,707 | £32,091 | £25,789 | £30,566 |
| Accounts Receivable | £0 | £2,745 | £6,230 | £7,931 | £9,744 | £12,342 | £16,282 | £18,279 | £16,534 | £10,176 | £8,270 | £10,701 | £12,573 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £46,000 | £47,079 | £47,172 | £45,462 | £44,900 | £45,049 | £46,732 | £48,301 | £47,301 | £42,883 | £40,361 | £36,490 | £43,139 |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £46,000 | £47,079 | £47,172 | £45,462 | £44,900 | £45,049 | £46,732 | £48,301 | £47,301 | £42,883 | £40,361 | £36,490 | £43,139 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £144 | £1,419 | £1,347 | £2,976 | £3,283 | £3,030 | £2,756 | £3,090 | £3,831 | £3,589 | £4,730 | £5,604 | £2,761 |
| Current Borrowing | £2,720 | £2,720 | £2,720 | £500 | £500 | £500 | £500 | £500 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £2,864 | £4,139 | £4,067 | £3,476 | £3,783 | £3,530 | £3,256 | £3,590 | £3,831 | £3,589 | £4,730 | £5,604 | £2,761 |
| Long-term Liabilities | £45,000 | £44,625 | £44,250 | £43,875 | £43,500 | £43,125 | £42,750 | £42,375 | £42,000 | £41,625 | £41,250 | £40,875 | £40,500 |
| Total Liabilities | £47,864 | £48,764 | £48,317 | £47,351 | £47,283 | £46,655 | £46,006 | £45,965 | £45,831 | £45,214 | £45,980 | £46,479 | £43,261 |
| Paid-in Capital | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £17,600 |
| Retained Earnings | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) |
| Earnings | £0 | £180 | £719 | (£25) | (£519) | £258 | £2,590 | £4,200 | £3,334 | (£467) | (£3,755) | (£8,125) | (£8,257) |
| Total Capital | (£1,864) | (£1,684) | (£1,145) | (£1,889) | (£2,383) | (£1,606) | £726 | £2,336 | £1,470 | (£2,331) | (£5,619) | (£9,989) | (£121) |
| Total Liabilities and Capital | £46,000 | £47,079 | £47,172 | £45,462 | £44,900 | £45,049 | £46,732 | £48,301 | £47,301 | £42,883 | £40,361 | £36,490 | £43,139 |
| Net Worth | (£1,864) | (£1,684) | (£1,145) | (£1,889) | (£2,383) | (£1,606) | £726 | £2,336 | £1,470 | (£2,331) | (£5,619) | (£9,989) | (£121) |
| Sales Forecast | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | |||||||||||||
| Placement Fees | 0% | £3,660 | £4,769 | £5,965 | £7,226 | £9,471 | £12,554 | £12,237 | £10,216 | £3,692 | £7,458 | £7,059 | £9,941 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £3,660 | £4,769 | £5,965 | £7,226 | £9,471 | £12,554 | £12,237 | £10,216 | £3,692 | £7,458 | £7,059 | £9,941 | |
| Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Placement Fees | £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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Placed Employees Personnel | |||||||||||||
| Placed Workers at 2/3 of Sales | £2,013 | £2,623 | £3,281 | £3,974 | £5,209 | £6,905 | £6,730 | £5,619 | £2,031 | £4,102 | £3,882 | £5,467 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £2,013 | £2,623 | £3,281 | £3,974 | £5,209 | £6,905 | £6,730 | £5,619 | £2,031 | £4,102 | £3,882 | £5,467 | |
| General and Administrative Personnel | |||||||||||||
| Office Employees | £0 | £213 | £350 | £350 | £350 | £466 | £700 | £1,500 | £1,750 | £1,750 | £1,750 | £1,750 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £0 | £213 | £350 | £350 | £350 | £466 | £700 | £1,500 | £1,750 | £1,750 | £1,750 | £1,750 | |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £2,013 | £2,836 | £3,631 | £4,324 | £5,559 | £7,371 | £7,430 | £7,119 | £3,781 | £5,852 | £5,632 | £7,217 | |
| General Assumptions | ||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| 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 | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £3,660 | £4,769 | £5,965 | £7,226 | £9,471 | £12,554 | £12,237 | £10,216 | £3,692 | £7,458 | £7,059 | £9,941 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Placed Employees Payroll | £2,013 | £2,623 | £3,281 | £3,974 | £5,209 | £6,905 | £6,730 | £5,619 | £2,031 | £4,102 | £3,882 | £5,467 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £2,013 | £2,623 | £3,281 | £3,974 | £5,209 | £6,905 | £6,730 | £5,619 | £2,031 | £4,102 | £3,882 | £5,467 | |
| Gross Margin | £1,647 | £2,146 | £2,684 | £3,252 | £4,262 | £5,649 | £5,507 | £4,597 | £1,661 | £3,356 | £3,177 | £4,474 | |
| Gross Margin % | 45.00% | 45.00% | 45.00% | 45.00% | 45.00% | 45.00% | 45.00% | 45.00% | 44.99% | 45.00% | 45.01% | 45.00% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Advertising/Promotion | £12 | £0 | £0 | £23 | £10 | £111 | £27 | £72 | £30 | £599 | £102 | £179 | |
| Bank Service Charges | £0 | £57 | £3 | £73 | £539 | £106 | £38 | £3 | £8 | £48 | £129 | £15 | |
| Contributions | £0 | £0 | £0 | £100 | £5 | £0 | £0 | £100 | £0 | £0 | £0 | £50 | |
| Dues & Subscriptions | £43 | £30 | £54 | £0 | £0 | £21 | £275 | £94 | £0 | £250 | £60 | £60 | |
| Total Sales and Marketing Expenses | £55 | £87 | £57 | £196 | £554 | £239 | £340 | £268 | £38 | £897 | £291 | £304 | |
| Sales and Marketing % | 1.50% | 1.82% | 0.95% | 2.71% | 5.85% | 1.90% | 2.78% | 2.63% | 1.02% | 12.03% | 4.12% | 3.06% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £0 | £213 | £350 | £350 | £350 | £466 | £700 | £1,500 | £1,750 | £1,750 | £1,750 | £1,750 | |
| Marketing/Promotion | £213 | £236 | £331 | £691 | £756 | £656 | £592 | £441 | £154 | £1,149 | £784 | £514 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Telephone & Pager | £226 | £88 | £416 | £125 | £374 | £220 | £439 | £638 | £697 | £240 | £616 | £90 | |
| Recruitment | £115 | £77 | £189 | £220 | £71 | £147 | £106 | £251 | £45 | £192 | £65 | £95 | |
| Referral Fees | £0 | £20 | £0 | £50 | £0 | £100 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £195 | £195 | £195 | £195 | £195 | £195 | £983 | £788 | £788 | £788 | £788 | £798 | |
| Office Supplies | £92 | £188 | £96 | £197 | £49 | £62 | £116 | £442 | £24 | £670 | £177 | £0 | |
| Postage | £9 | £49 | £55 | £107 | £133 | £94 | £36 | £99 | £8 | £175 | £89 | £209 | |
| Printing | £0 | £2 | £669 | £26 | £290 | £350 | £175 | £224 | £832 | £179 | £520 | £94 | |
| Professional Fees | £240 | £170 | £664 | £988 | £367 | £270 | £0 | £528 | £844 | £342 | £2,013 | £516 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Maintenance and Repairs | £0 | £0 | £103 | £100 | £0 | £25 | £0 | £39 | £0 | £0 | £44 | £0 | |
| Total General and Administrative Expenses | £1,090 | £1,239 | £3,068 | £3,049 | £2,585 | £2,585 | £3,146 | £4,949 | £5,142 | £5,485 | £6,845 | £4,065 | |
| General and Administrative % | 29.77% | 25.97% | 51.43% | 42.19% | 27.30% | 20.59% | 25.71% | 48.45% | 139.28% | 73.55% | 96.97% | 40.90% | |
| Other Expenses: | |||||||||||||
| 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 | |
| Misc. | £40 | £0 | £44 | £244 | £90 | £240 | £159 | £0 | £40 | £20 | £173 | £0 | |
| Total Other Expenses | £40 | £0 | £44 | £244 | £90 | £240 | £159 | £0 | £40 | £20 | £173 | £0 | |
| Other % | 1.09% | 0.00% | 0.74% | 3.38% | 0.95% | 1.91% | 1.30% | 0.00% | 1.08% | 0.27% | 2.45% | 0.00% | |
| Total Operating Expenses | £1,185 | £1,325 | £3,168 | £3,488 | £3,229 | £3,064 | £3,645 | £5,218 | £5,220 | £6,403 | £7,309 | £4,369 | |
| Profit Before Interest and Taxes | £462 | £821 | (£484) | (£236) | £1,033 | £2,585 | £1,862 | (£621) | (£3,559) | (£3,047) | (£4,132) | £104 | |
| EBITDA | £462 | £821 | (£484) | (£236) | £1,033 | £2,585 | £1,862 | (£621) | (£3,559) | (£3,047) | (£4,132) | £104 | |
| Interest Expense | £283 | £281 | £260 | £258 | £256 | £254 | £251 | £245 | £243 | £241 | £238 | £236 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | £180 | £540 | (£744) | (£494) | £777 | £2,332 | £1,610 | (£866) | (£3,802) | (£3,287) | (£4,370) | (£132) | |
| Net Profit/Sales | 4.90% | 11.32% | -12.48% | -6.84% | 8.21% | 18.57% | 13.16% | -8.47% | -102.97% | -44.08% | -61.91% | -1.33% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £915 | £1,192 | £1,491 | £1,807 | £2,368 | £3,139 | £3,059 | £2,554 | £923 | £1,865 | £1,765 | £2,485 | |
| Cash from Receivables | £0 | £92 | £2,773 | £3,607 | £4,505 | £5,476 | £7,180 | £9,408 | £9,127 | £7,499 | £2,863 | £5,584 | |
| Subtotal Cash from Operations | £915 | £1,284 | £4,264 | £5,413 | £6,873 | £8,614 | £10,240 | £11,962 | £10,050 | £9,363 | £4,628 | £8,069 | |
| 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 | £10,000 | |
| Subtotal Cash Received | £915 | £1,284 | £4,264 | £5,413 | £6,873 | £8,614 | £10,240 | £11,962 | £10,050 | £9,363 | £4,628 | £18,069 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £2,013 | £2,836 | £3,631 | £4,324 | £5,559 | £7,371 | £7,430 | £7,119 | £3,781 | £5,852 | £5,632 | £7,217 | |
| Bill Payments | £193 | £1,465 | £1,449 | £3,089 | £3,388 | £3,125 | £2,863 | £3,222 | £3,954 | £3,752 | £4,923 | £5,699 | |
| Subtotal Spent on Operations | £2,206 | £4,301 | £5,080 | £7,413 | £8,947 | £10,496 | £10,293 | £10,341 | £7,735 | £9,604 | £10,555 | £12,916 | |
| 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 | £2,220 | £0 | £0 | £0 | £0 | £500 | £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 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | |
| 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 | £2,581 | £4,676 | £7,675 | £7,788 | £9,322 | £10,871 | £10,668 | £11,216 | £8,110 | £9,979 | £10,930 | £13,291 | |
| Net Cash Flow | (£1,666) | (£3,392) | (£3,411) | (£2,375) | (£2,449) | (£2,257) | (£428) | £745 | £1,940 | (£616) | (£6,303) | £4,777 | |
| Cash Balance | £44,334 | £40,942 | £37,530 | £35,156 | £32,707 | £30,450 | £30,022 | £30,767 | £32,707 | £32,091 | £25,789 | £30,566 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £46,000 | £44,334 | £40,942 | £37,530 | £35,156 | £32,707 | £30,450 | £30,022 | £30,767 | £32,707 | £32,091 | £25,789 | £30,566 |
| Accounts Receivable | £0 | £2,745 | £6,230 | £7,931 | £9,744 | £12,342 | £16,282 | £18,279 | £16,534 | £10,176 | £8,270 | £10,701 | £12,573 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £46,000 | £47,079 | £47,172 | £45,462 | £44,900 | £45,049 | £46,732 | £48,301 | £47,301 | £42,883 | £40,361 | £36,490 | £43,139 |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £46,000 | £47,079 | £47,172 | £45,462 | £44,900 | £45,049 | £46,732 | £48,301 | £47,301 | £42,883 | £40,361 | £36,490 | £43,139 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £144 | £1,419 | £1,347 | £2,976 | £3,283 | £3,030 | £2,756 | £3,090 | £3,831 | £3,589 | £4,730 | £5,604 | £2,761 |
| Current Borrowing | £2,720 | £2,720 | £2,720 | £500 | £500 | £500 | £500 | £500 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £2,864 | £4,139 | £4,067 | £3,476 | £3,783 | £3,530 | £3,256 | £3,590 | £3,831 | £3,589 | £4,730 | £5,604 | £2,761 |
| Long-term Liabilities | £45,000 | £44,625 | £44,250 | £43,875 | £43,500 | £43,125 | £42,750 | £42,375 | £42,000 | £41,625 | £41,250 | £40,875 | £40,500 |
| Total Liabilities | £47,864 | £48,764 | £48,317 | £47,351 | £47,283 | £46,655 | £46,006 | £45,965 | £45,831 | £45,214 | £45,980 | £46,479 | £43,261 |
| Paid-in Capital | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £17,600 |
| Retained Earnings | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) | (£9,464) |
| Earnings | £0 | £180 | £719 | (£25) | (£519) | £258 | £2,590 | £4,200 | £3,334 | (£467) | (£3,755) | (£8,125) | (£8,257) |
| Total Capital | (£1,864) | (£1,684) | (£1,145) | (£1,889) | (£2,383) | (£1,606) | £726 | £2,336 | £1,470 | (£2,331) | (£5,619) | (£9,989) | (£121) |
| Total Liabilities and Capital | £46,000 | £47,079 | £47,172 | £45,462 | £44,900 | £45,049 | £46,732 | £48,301 | £47,301 | £42,883 | £40,361 | £36,490 | £43,139 |
| Net Worth | (£1,864) | (£1,684) | (£1,145) | (£1,889) | (£2,383) | (£1,606) | £726 | £2,336 | £1,470 | (£2,331) | (£5,619) | (£9,989) | (£121) |