| 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 | |||||||||||||
| Pharaceutical Companies | 0% | £100,000 | £125,000 | £130,000 | £135,000 | £140,000 | £145,000 | £150,000 | £155,000 | £160,000 | £165,000 | £170,000 | £200,000 |
| Medical Professionals | 0% | £30,000 | £60,000 | £120,000 | £150,000 | £20,000 | £22,000 | £30,000 | £35,000 | £40,000 | £50,000 | £70,000 | £90,000 |
| Bio-Tech | 0% | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £300,000 | £300,000 | £300,000 | £300,000 | £30,000 | £30,000 |
| Medical Devices | 0% | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £210,000 | £265,000 | £330,000 | £365,000 | £240,000 | £247,000 | £530,000 | £540,000 | £550,000 | £565,000 | £320,000 | £370,000 | |
| 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 | |
| Pharaceutical Companies | £150 | £100 | £100 | £120 | £300 | £500 | £700 | £900 | £1,200 | £1,500 | £1,700 | £1,900 | |
| Medical Professionals | £150 | £150 | £150 | £150 | £150 | £160 | £160 | £175 | £200 | £250 | £250 | £450 | |
| Bio-Tech | £400 | £400 | £800 | £900 | £1,000 | £1,300 | £15,000 | £2,000 | £2,500 | £3,000 | £3,200 | £3,700 | |
| Medical Devices | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £2,700 | £2,650 | £3,050 | £3,170 | £3,450 | £3,960 | £17,860 | £5,075 | £5,900 | £6,750 | £7,150 | £8,050 | |
| 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 | ||
| Dr. Wu | 0% | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 |
| Dr. Rayder | 0% | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 |
| CEO | 0% | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 |
| IT Director | 0% | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 |
| Marketing Director | 0% | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 |
| Secretary | 0% | £1,900 | £1,900 | £1,900 | £1,900 | £1,900 | £1,900 | £1,900 | £1,900 | £1,900 | £1,900 | £1,900 | £1,900 |
| Secretary 2 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Secretary 3 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Bookkeepter | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Secretary 4 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Secretary 5 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| CFO | 0% | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 |
| Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | |
| 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 | 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 | |||||||||||||
| 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 | £210,000 | £265,000 | £330,000 | £365,000 | £240,000 | £247,000 | £530,000 | £540,000 | £550,000 | £565,000 | £320,000 | £370,000 | |
| Direct Cost of Sales | £2,700 | £2,650 | £3,050 | £3,170 | £3,450 | £3,960 | £17,860 | £5,075 | £5,900 | £6,750 | £7,150 | £8,050 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £2,700 | £2,650 | £3,050 | £3,170 | £3,450 | £3,960 | £17,860 | £5,075 | £5,900 | £6,750 | £7,150 | £8,050 | |
| Gross Margin | £207,300 | £262,350 | £326,950 | £361,830 | £236,550 | £243,040 | £512,140 | £534,925 | £544,100 | £558,250 | £312,850 | £361,950 | |
| Gross Margin % | 98.71% | 99.00% | 99.08% | 99.13% | 98.56% | 98.40% | 96.63% | 99.06% | 98.93% | 98.81% | 97.77% | 97.82% | |
| Expenses | |||||||||||||
| Payroll | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | |
| Sales and Marketing and Other Expenses | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| 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 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | |
| Payroll Taxes | 15% | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £54,976 | £54,976 | £54,976 | £54,976 | £54,976 | £54,976 | £54,976 | £54,976 | £54,976 | £54,976 | £54,976 | £54,976 | |
| Profit Before Interest and Taxes | £152,324 | £207,374 | £271,974 | £306,854 | £181,574 | £188,064 | £457,164 | £479,949 | £489,124 | £503,274 | £257,874 | £306,974 | |
| EBITDA | £152,324 | £207,374 | £271,974 | £306,854 | £181,574 | £188,064 | £457,164 | £479,949 | £489,124 | £503,274 | £257,874 | £306,974 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £45,697 | £62,212 | £81,592 | £92,056 | £54,472 | £56,419 | £137,149 | £143,985 | £146,737 | £150,982 | £77,362 | £92,092 | |
| Net Profit | £106,627 | £145,162 | £190,382 | £214,798 | £127,102 | £131,645 | £320,015 | £335,964 | £342,387 | £352,292 | £180,512 | £214,882 | |
| Net Profit/Sales | 50.77% | 54.78% | 57.69% | 58.85% | 52.96% | 53.30% | 60.38% | 62.22% | 62.25% | 62.35% | 56.41% | 58.08% | |
| 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 | £210,000 | £265,000 | £330,000 | £365,000 | £240,000 | £247,000 | £530,000 | £540,000 | £550,000 | £565,000 | £320,000 | £370,000 | |
| Subtotal Cash from Operations | £210,000 | £265,000 | £330,000 | £365,000 | £240,000 | £247,000 | £530,000 | £540,000 | £550,000 | £565,000 | £320,000 | £370,000 | |
| 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 | £210,000 | £265,000 | £330,000 | £365,000 | £240,000 | £247,000 | £530,000 | £540,000 | £550,000 | £565,000 | £320,000 | £370,000 | |
| 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 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | |
| Bill Payments | £2,466 | £74,522 | £91,098 | £110,571 | £119,559 | £83,580 | £89,110 | £180,387 | £174,755 | £178,383 | £180,868 | £110,609 | |
| Subtotal Spent on Operations | £31,866 | £103,922 | £120,498 | £139,971 | £148,959 | £112,980 | £118,510 | £209,787 | £204,155 | £207,783 | £210,268 | £140,009 | |
| 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 | £31,866 | £103,922 | £120,498 | £139,971 | £148,959 | £112,980 | £118,510 | £209,787 | £204,155 | £207,783 | £210,268 | £140,009 | |
| Net Cash Flow | £178,134 | £161,078 | £209,502 | £225,029 | £91,041 | £134,020 | £411,490 | £330,213 | £345,845 | £357,217 | £109,732 | £229,991 | |
| Cash Balance | £482,134 | £643,212 | £852,715 | £1,077,744 | £1,168,785 | £1,302,805 | £1,714,295 | £2,044,508 | £2,390,353 | £2,747,570 | £2,857,303 | £3,087,294 | |
| 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 | £304,000 | £482,134 | £643,212 | £852,715 | £1,077,744 | £1,168,785 | £1,302,805 | £1,714,295 | £2,044,508 | £2,390,353 | £2,747,570 | £2,857,303 | £3,087,294 |
| Other Current Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Total Current Assets | £309,000 | £487,134 | £648,212 | £857,715 | £1,082,744 | £1,173,785 | £1,307,805 | £1,719,295 | £2,049,508 | £2,395,353 | £2,752,570 | £2,862,303 | £3,092,294 |
| 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 | £309,000 | £487,134 | £648,212 | £857,715 | £1,082,744 | £1,173,785 | £1,307,805 | £1,719,295 | £2,049,508 | £2,395,353 | £2,752,570 | £2,862,303 | £3,092,294 |
| 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 | £0 | £71,507 | £87,424 | £106,544 | £116,775 | £80,715 | £83,090 | £174,566 | £168,815 | £172,273 | £177,198 | £106,419 | £121,528 |
| 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 | £71,507 | £87,424 | £106,544 | £116,775 | £80,715 | £83,090 | £174,566 | £168,815 | £172,273 | £177,198 | £106,419 | £121,528 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £71,507 | £87,424 | £106,544 | £116,775 | £80,715 | £83,090 | £174,566 | £168,815 | £172,273 | £177,198 | £106,419 | £121,528 |
| Paid-in Capital | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 |
| Retained Earnings | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) |
| Earnings | £0 | £106,627 | £251,789 | £442,170 | £656,968 | £784,070 | £915,715 | £1,235,730 | £1,571,694 | £1,914,081 | £2,266,373 | £2,446,884 | £2,661,766 |
| Total Capital | £309,000 | £415,627 | £560,789 | £751,170 | £965,968 | £1,093,070 | £1,224,715 | £1,544,730 | £1,880,694 | £2,223,081 | £2,575,373 | £2,755,884 | £2,970,766 |
| Total Liabilities and Capital | £309,000 | £487,134 | £648,212 | £857,715 | £1,082,744 | £1,173,785 | £1,307,805 | £1,719,295 | £2,049,508 | £2,395,353 | £2,752,570 | £2,862,303 | £3,092,294 |
| Net Worth | £309,000 | £415,627 | £560,789 | £751,170 | £965,968 | £1,093,070 | £1,224,715 | £1,544,730 | £1,880,694 | £2,223,081 | £2,575,373 | £2,755,884 | £2,970,766 |
| 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 | |||||||||||||
| Pharaceutical Companies | 0% | £100,000 | £125,000 | £130,000 | £135,000 | £140,000 | £145,000 | £150,000 | £155,000 | £160,000 | £165,000 | £170,000 | £200,000 |
| Medical Professionals | 0% | £30,000 | £60,000 | £120,000 | £150,000 | £20,000 | £22,000 | £30,000 | £35,000 | £40,000 | £50,000 | £70,000 | £90,000 |
| Bio-Tech | 0% | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £300,000 | £300,000 | £300,000 | £300,000 | £30,000 | £30,000 |
| Medical Devices | 0% | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £210,000 | £265,000 | £330,000 | £365,000 | £240,000 | £247,000 | £530,000 | £540,000 | £550,000 | £565,000 | £320,000 | £370,000 | |
| 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 | |
| Pharaceutical Companies | £150 | £100 | £100 | £120 | £300 | £500 | £700 | £900 | £1,200 | £1,500 | £1,700 | £1,900 | |
| Medical Professionals | £150 | £150 | £150 | £150 | £150 | £160 | £160 | £175 | £200 | £250 | £250 | £450 | |
| Bio-Tech | £400 | £400 | £800 | £900 | £1,000 | £1,300 | £15,000 | £2,000 | £2,500 | £3,000 | £3,200 | £3,700 | |
| Medical Devices | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £2,700 | £2,650 | £3,050 | £3,170 | £3,450 | £3,960 | £17,860 | £5,075 | £5,900 | £6,750 | £7,150 | £8,050 | |
| 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 | ||
| Dr. Wu | 0% | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 |
| Dr. Rayder | 0% | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 |
| CEO | 0% | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 |
| IT Director | 0% | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 |
| Marketing Director | 0% | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 |
| Secretary | 0% | £1,900 | £1,900 | £1,900 | £1,900 | £1,900 | £1,900 | £1,900 | £1,900 | £1,900 | £1,900 | £1,900 | £1,900 |
| Secretary 2 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Secretary 3 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Bookkeepter | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Secretary 4 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Secretary 5 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| CFO | 0% | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 |
| Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | |
| 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 | 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 | |||||||||||||
| 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 | £210,000 | £265,000 | £330,000 | £365,000 | £240,000 | £247,000 | £530,000 | £540,000 | £550,000 | £565,000 | £320,000 | £370,000 | |
| Direct Cost of Sales | £2,700 | £2,650 | £3,050 | £3,170 | £3,450 | £3,960 | £17,860 | £5,075 | £5,900 | £6,750 | £7,150 | £8,050 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £2,700 | £2,650 | £3,050 | £3,170 | £3,450 | £3,960 | £17,860 | £5,075 | £5,900 | £6,750 | £7,150 | £8,050 | |
| Gross Margin | £207,300 | £262,350 | £326,950 | £361,830 | £236,550 | £243,040 | £512,140 | £534,925 | £544,100 | £558,250 | £312,850 | £361,950 | |
| Gross Margin % | 98.71% | 99.00% | 99.08% | 99.13% | 98.56% | 98.40% | 96.63% | 99.06% | 98.93% | 98.81% | 97.77% | 97.82% | |
| Expenses | |||||||||||||
| Payroll | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | |
| Sales and Marketing and Other Expenses | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| 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 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | |
| Payroll Taxes | 15% | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £54,976 | £54,976 | £54,976 | £54,976 | £54,976 | £54,976 | £54,976 | £54,976 | £54,976 | £54,976 | £54,976 | £54,976 | |
| Profit Before Interest and Taxes | £152,324 | £207,374 | £271,974 | £306,854 | £181,574 | £188,064 | £457,164 | £479,949 | £489,124 | £503,274 | £257,874 | £306,974 | |
| EBITDA | £152,324 | £207,374 | £271,974 | £306,854 | £181,574 | £188,064 | £457,164 | £479,949 | £489,124 | £503,274 | £257,874 | £306,974 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £45,697 | £62,212 | £81,592 | £92,056 | £54,472 | £56,419 | £137,149 | £143,985 | £146,737 | £150,982 | £77,362 | £92,092 | |
| Net Profit | £106,627 | £145,162 | £190,382 | £214,798 | £127,102 | £131,645 | £320,015 | £335,964 | £342,387 | £352,292 | £180,512 | £214,882 | |
| Net Profit/Sales | 50.77% | 54.78% | 57.69% | 58.85% | 52.96% | 53.30% | 60.38% | 62.22% | 62.25% | 62.35% | 56.41% | 58.08% | |
| 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 | £210,000 | £265,000 | £330,000 | £365,000 | £240,000 | £247,000 | £530,000 | £540,000 | £550,000 | £565,000 | £320,000 | £370,000 | |
| Subtotal Cash from Operations | £210,000 | £265,000 | £330,000 | £365,000 | £240,000 | £247,000 | £530,000 | £540,000 | £550,000 | £565,000 | £320,000 | £370,000 | |
| 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 | £210,000 | £265,000 | £330,000 | £365,000 | £240,000 | £247,000 | £530,000 | £540,000 | £550,000 | £565,000 | £320,000 | £370,000 | |
| 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 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | £29,400 | |
| Bill Payments | £2,466 | £74,522 | £91,098 | £110,571 | £119,559 | £83,580 | £89,110 | £180,387 | £174,755 | £178,383 | £180,868 | £110,609 | |
| Subtotal Spent on Operations | £31,866 | £103,922 | £120,498 | £139,971 | £148,959 | £112,980 | £118,510 | £209,787 | £204,155 | £207,783 | £210,268 | £140,009 | |
| 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 | £31,866 | £103,922 | £120,498 | £139,971 | £148,959 | £112,980 | £118,510 | £209,787 | £204,155 | £207,783 | £210,268 | £140,009 | |
| Net Cash Flow | £178,134 | £161,078 | £209,502 | £225,029 | £91,041 | £134,020 | £411,490 | £330,213 | £345,845 | £357,217 | £109,732 | £229,991 | |
| Cash Balance | £482,134 | £643,212 | £852,715 | £1,077,744 | £1,168,785 | £1,302,805 | £1,714,295 | £2,044,508 | £2,390,353 | £2,747,570 | £2,857,303 | £3,087,294 | |
| 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 | £304,000 | £482,134 | £643,212 | £852,715 | £1,077,744 | £1,168,785 | £1,302,805 | £1,714,295 | £2,044,508 | £2,390,353 | £2,747,570 | £2,857,303 | £3,087,294 |
| Other Current Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Total Current Assets | £309,000 | £487,134 | £648,212 | £857,715 | £1,082,744 | £1,173,785 | £1,307,805 | £1,719,295 | £2,049,508 | £2,395,353 | £2,752,570 | £2,862,303 | £3,092,294 |
| 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 | £309,000 | £487,134 | £648,212 | £857,715 | £1,082,744 | £1,173,785 | £1,307,805 | £1,719,295 | £2,049,508 | £2,395,353 | £2,752,570 | £2,862,303 | £3,092,294 |
| 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 | £0 | £71,507 | £87,424 | £106,544 | £116,775 | £80,715 | £83,090 | £174,566 | £168,815 | £172,273 | £177,198 | £106,419 | £121,528 |
| 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 | £71,507 | £87,424 | £106,544 | £116,775 | £80,715 | £83,090 | £174,566 | £168,815 | £172,273 | £177,198 | £106,419 | £121,528 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £71,507 | £87,424 | £106,544 | £116,775 | £80,715 | £83,090 | £174,566 | £168,815 | £172,273 | £177,198 | £106,419 | £121,528 |
| Paid-in Capital | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 | £408,000 |
| Retained Earnings | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) | (£99,000) |
| Earnings | £0 | £106,627 | £251,789 | £442,170 | £656,968 | £784,070 | £915,715 | £1,235,730 | £1,571,694 | £1,914,081 | £2,266,373 | £2,446,884 | £2,661,766 |
| Total Capital | £309,000 | £415,627 | £560,789 | £751,170 | £965,968 | £1,093,070 | £1,224,715 | £1,544,730 | £1,880,694 | £2,223,081 | £2,575,373 | £2,755,884 | £2,970,766 |
| Total Liabilities and Capital | £309,000 | £487,134 | £648,212 | £857,715 | £1,082,744 | £1,173,785 | £1,307,805 | £1,719,295 | £2,049,508 | £2,395,353 | £2,752,570 | £2,862,303 | £3,092,294 |
| Net Worth | £309,000 | £415,627 | £560,789 | £751,170 | £965,968 | £1,093,070 | £1,224,715 | £1,544,730 | £1,880,694 | £2,223,081 | £2,575,373 | £2,755,884 | £2,970,766 |