| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| All product lines | 0% | £450,000 | £380,000 | £390,000 | £390,000 | £390,000 | £390,000 | £400,000 | £440,000 | £440,000 | £440,000 | £440,000 | £450,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £450,000 | £380,000 | £390,000 | £390,000 | £390,000 | £390,000 | £400,000 | £440,000 | £440,000 | £440,000 | £440,000 | £450,000 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| All product lines | £126,000 | £106,400 | £109,200 | £109,200 | £109,200 | £109,200 | £112,000 | £123,200 | £123,200 | £123,200 | £123,200 | £126,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £126,000 | £106,400 | £109,200 | £109,200 | £109,200 | £109,200 | £112,000 | £123,200 | £123,200 | £123,200 | £123,200 | £126,000 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| All departments | 0% | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,106 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | |
| Total Payroll | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,106 | |
| General Assumptions | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| 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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £450,000 | £380,000 | £390,000 | £390,000 | £390,000 | £390,000 | £400,000 | £440,000 | £440,000 | £440,000 | £440,000 | £450,000 | |
| Direct Cost of Sales | £126,000 | £106,400 | £109,200 | £109,200 | £109,200 | £109,200 | £112,000 | £123,200 | £123,200 | £123,200 | £123,200 | £126,000 | |
| Other | £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 Cost of Sales | £130,167 | £110,567 | £113,367 | £113,367 | £113,367 | £113,367 | £116,167 | £127,367 | £127,367 | £127,367 | £127,367 | £130,167 | |
| Gross Margin | £319,833 | £269,433 | £276,633 | £276,633 | £276,633 | £276,633 | £283,833 | £312,633 | £312,633 | £312,633 | £312,633 | £319,833 | |
| Gross Margin % | 71.07% | 70.90% | 70.93% | 70.93% | 70.93% | 70.93% | 70.96% | 71.05% | 71.05% | 71.05% | 71.05% | 71.07% | |
| Expenses | |||||||||||||
| Payroll | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,106 | |
| Sales and Marketing and Other Expenses | £99,005 | £99,005 | £99,005 | £99,005 | £99,005 | £99,005 | £99,005 | £99,005 | £99,005 | £99,005 | £99,005 | £99,005 | |
| Depreciation | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | |
| Communications | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | |
| Client Relations | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Rent | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Payroll Taxes | 15% | £7,065 | £7,065 | £7,065 | £7,065 | £7,065 | £7,065 | £7,065 | £7,065 | £7,065 | £7,065 | £7,065 | £7,066 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £160,371 | £160,371 | £160,371 | £160,371 | £160,371 | £160,371 | £160,371 | £160,371 | £160,371 | £160,371 | £160,371 | £160,377 | |
| Profit Before Interest and Taxes | £159,462 | £109,062 | £116,262 | £116,262 | £116,262 | £116,262 | £123,462 | £152,262 | £152,262 | £152,262 | £152,262 | £159,457 | |
| EBITDA | £161,662 | £111,262 | £118,462 | £118,462 | £118,462 | £118,462 | £125,662 | £154,462 | £154,462 | £154,462 | £154,462 | £161,657 | |
| Interest Expense | £20,375 | £20,266 | £20,157 | £20,047 | £36,602 | £36,266 | £35,926 | £35,584 | £35,239 | £34,891 | £34,541 | £34,541 | |
| Taxes Incurred | £41,726 | £22,199 | £24,026 | £24,054 | £19,915 | £19,999 | £21,884 | £29,170 | £29,256 | £29,343 | £29,430 | £31,229 | |
| Net Profit | £97,361 | £66,597 | £72,079 | £72,162 | £59,745 | £59,998 | £65,652 | £87,509 | £87,767 | £88,028 | £88,291 | £93,687 | |
| Net Profit/Sales | 21.64% | 17.53% | 18.48% | 18.50% | 15.32% | 15.38% | 16.41% | 19.89% | 19.95% | 20.01% | 20.07% | 20.82% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £22,500 | £19,000 | £19,500 | £19,500 | £19,500 | £19,500 | £20,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,500 | |
| Cash from Receivables | £210,000 | £224,250 | £425,283 | £361,317 | £370,500 | £370,500 | £370,500 | £370,817 | £381,267 | £418,000 | £418,000 | £418,000 | |
| Subtotal Cash from Operations | £232,500 | £243,250 | £444,783 | £380,817 | £390,000 | £390,000 | £390,500 | £392,817 | £403,267 | £440,000 | £440,000 | £440,500 | |
| 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 | £1,000,000 | £0 | £0 | £0 | £2,000,000 | £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 | £1,232,500 | £243,250 | £444,783 | £380,817 | £2,390,000 | £390,000 | £390,500 | £392,817 | £403,267 | £440,000 | £440,000 | £440,500 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,106 | |
| Bill Payments | £1,005,911 | £176,683 | £157,759 | £159,417 | £159,751 | £171,745 | £171,553 | £173,278 | £179,982 | £179,723 | £179,462 | £179,268 | |
| Subtotal Spent on Operations | £1,053,012 | £223,784 | £204,860 | £206,518 | £206,852 | £218,846 | £218,654 | £220,379 | £227,083 | £226,824 | £226,563 | £226,374 | |
| 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 | £13,021 | £13,130 | £13,239 | £13,350 | £40,382 | £40,719 | £41,058 | £41,400 | £41,745 | £42,093 | £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 | £1,053,012 | £236,805 | £217,990 | £219,757 | £220,202 | £259,228 | £259,373 | £261,437 | £268,483 | £268,569 | £268,656 | £226,374 | |
| Net Cash Flow | £179,488 | £6,445 | £226,793 | £161,059 | £2,169,798 | £130,772 | £131,127 | £131,379 | £134,784 | £171,431 | £171,344 | £214,126 | |
| Cash Balance | £624,488 | £630,932 | £857,725 | £1,018,785 | £3,188,583 | £3,319,354 | £3,450,481 | £3,581,860 | £3,716,644 | £3,888,075 | £4,059,419 | £4,273,546 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £445,000 | £624,488 | £630,932 | £857,725 | £1,018,785 | £3,188,583 | £3,319,354 | £3,450,481 | £3,581,860 | £3,716,644 | £3,888,075 | £4,059,419 | £4,273,546 |
| Accounts Receivable | £420,000 | £637,500 | £774,250 | £719,467 | £728,650 | £728,650 | £728,650 | £738,150 | £785,333 | £822,067 | £822,067 | £822,067 | £831,567 |
| Inventory | £1,545,000 | £1,419,000 | £1,312,600 | £1,203,400 | £1,094,200 | £985,000 | £875,800 | £763,800 | £640,600 | £517,400 | £394,200 | £271,000 | £145,000 |
| Other Current Assets | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 |
| Total Current Assets | £2,515,000 | £2,785,988 | £2,822,782 | £2,885,592 | £2,946,635 | £5,007,233 | £5,028,804 | £5,057,431 | £5,112,794 | £5,161,111 | £5,209,342 | £5,257,486 | £5,355,112 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 |
| Accumulated Depreciation | £80,000 | £82,200 | £84,400 | £86,600 | £88,800 | £91,000 | £93,200 | £95,400 | £97,600 | £99,800 | £102,000 | £104,200 | £106,400 |
| Total Long-term Assets | £445,000 | £442,800 | £440,600 | £438,400 | £436,200 | £434,000 | £431,800 | £429,600 | £427,400 | £425,200 | £423,000 | £420,800 | £418,600 |
| Total Assets | £2,960,000 | £3,228,788 | £3,263,382 | £3,323,992 | £3,382,835 | £5,441,233 | £5,460,604 | £5,487,031 | £5,540,194 | £5,586,311 | £5,632,342 | £5,678,286 | £5,773,712 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £1,000,000 | £171,427 | £152,445 | £154,106 | £154,026 | £166,029 | £165,785 | £167,279 | £173,991 | £173,741 | £173,488 | £173,234 | £174,973 |
| Current Borrowing | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 |
| Other Current Liabilities | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 |
| Subtotal Current Liabilities | £2,500,000 | £1,671,427 | £1,652,445 | £1,654,106 | £1,654,026 | £1,666,029 | £1,665,785 | £1,667,279 | £1,673,991 | £1,673,741 | £1,673,488 | £1,673,234 | £1,674,973 |
| Long-term Liabilities | £355,000 | £1,355,000 | £1,341,979 | £1,328,849 | £1,315,610 | £3,302,260 | £3,261,878 | £3,221,159 | £3,180,101 | £3,138,701 | £3,096,956 | £3,054,863 | £3,054,863 |
| Total Liabilities | £2,855,000 | £3,026,427 | £2,994,424 | £2,982,955 | £2,969,636 | £4,968,289 | £4,927,663 | £4,888,438 | £4,854,092 | £4,812,442 | £4,770,444 | £4,728,097 | £4,729,836 |
| Paid-in Capital | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 |
| Retained Earnings | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 |
| Earnings | £0 | £97,361 | £163,958 | £236,037 | £308,199 | £367,944 | £427,941 | £493,593 | £581,102 | £668,869 | £756,898 | £845,189 | £938,876 |
| Total Capital | £105,000 | £202,361 | £268,958 | £341,037 | £413,199 | £472,944 | £532,941 | £598,593 | £686,102 | £773,869 | £861,898 | £950,189 | £1,043,876 |
| Total Liabilities and Capital | £2,960,000 | £3,228,788 | £3,263,382 | £3,323,992 | £3,382,835 | £5,441,233 | £5,460,604 | £5,487,031 | £5,540,194 | £5,586,311 | £5,632,342 | £5,678,286 | £5,773,712 |
| Net Worth | £105,000 | £202,361 | £268,958 | £341,037 | £413,199 | £472,944 | £532,941 | £598,593 | £686,102 | £773,869 | £861,898 | £950,189 | £1,043,876 |
| Past Performance | |||
| 1997 | 1998 | 1999 | |
| Sales | £0 | £0 | £3,000,000 |
| Gross Margin | £0 | £0 | £750,000 |
| Gross Margin % | 0.00% | 0.00% | 25.00% |
| Operating Expenses | £0 | £0 | £1,200,000 |
| Collection Period (days) | 0 | 0 | 34 |
| Inventory Turnover | 0.00 | 0.00 | 6.00 |
| Balance Sheet | |||
| 1997 | 1998 | 1999 | |
| Current Assets | |||
| Cash | £0 | £0 | £445,000 |
| Accounts Receivable | £0 | £0 | £420,000 |
| Inventory | £0 | £0 | £1,545,000 |
| Other Current Assets | £0 | £0 | £105,000 |
| Total Current Assets | £0 | £0 | £2,515,000 |
| Long-term Assets | |||
| Long-term Assets | £0 | £0 | £525,000 |
| Accumulated Depreciation | £0 | £0 | £80,000 |
| Total Long-term Assets | £0 | £0 | £445,000 |
| Total Assets | £0 | £0 | £2,960,000 |
| Current Liabilities | |||
| Accounts Payable | £0 | £0 | £1,000,000 |
| Current Borrowing | £0 | £0 | £1,090,000 |
| Other Current Liabilities (interest free) | £0 | £0 | £410,000 |
| Total Current Liabilities | £0 | £0 | £2,500,000 |
| Long-term Liabilities | £0 | £0 | £355,000 |
| Total Liabilities | £0 | £0 | £2,855,000 |
| Paid-in Capital | £0 | £0 | £70,000 |
| Retained Earnings | £0 | £0 | £35,000 |
| Earnings | £0 | £0 | £0 |
| Total Capital | £0 | £0 | £105,000 |
| Total Capital and Liabilities | £0 | £0 | £2,960,000 |
| Other Inputs | |||
| Payment Days | 0 | 0 | 30 |
| Sales on Credit | £0 | £0 | £2,250,000 |
| Receivables Turnover | 0.00 | 0.00 | 5.36 |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| All product lines | 0% | £450,000 | £380,000 | £390,000 | £390,000 | £390,000 | £390,000 | £400,000 | £440,000 | £440,000 | £440,000 | £440,000 | £450,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £450,000 | £380,000 | £390,000 | £390,000 | £390,000 | £390,000 | £400,000 | £440,000 | £440,000 | £440,000 | £440,000 | £450,000 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| All product lines | £126,000 | £106,400 | £109,200 | £109,200 | £109,200 | £109,200 | £112,000 | £123,200 | £123,200 | £123,200 | £123,200 | £126,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £126,000 | £106,400 | £109,200 | £109,200 | £109,200 | £109,200 | £112,000 | £123,200 | £123,200 | £123,200 | £123,200 | £126,000 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| All departments | 0% | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,106 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | |
| Total Payroll | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,106 | |
| General Assumptions | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| 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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £450,000 | £380,000 | £390,000 | £390,000 | £390,000 | £390,000 | £400,000 | £440,000 | £440,000 | £440,000 | £440,000 | £450,000 | |
| Direct Cost of Sales | £126,000 | £106,400 | £109,200 | £109,200 | £109,200 | £109,200 | £112,000 | £123,200 | £123,200 | £123,200 | £123,200 | £126,000 | |
| Other | £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 Cost of Sales | £130,167 | £110,567 | £113,367 | £113,367 | £113,367 | £113,367 | £116,167 | £127,367 | £127,367 | £127,367 | £127,367 | £130,167 | |
| Gross Margin | £319,833 | £269,433 | £276,633 | £276,633 | £276,633 | £276,633 | £283,833 | £312,633 | £312,633 | £312,633 | £312,633 | £319,833 | |
| Gross Margin % | 71.07% | 70.90% | 70.93% | 70.93% | 70.93% | 70.93% | 70.96% | 71.05% | 71.05% | 71.05% | 71.05% | 71.07% | |
| Expenses | |||||||||||||
| Payroll | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,106 | |
| Sales and Marketing and Other Expenses | £99,005 | £99,005 | £99,005 | £99,005 | £99,005 | £99,005 | £99,005 | £99,005 | £99,005 | £99,005 | £99,005 | £99,005 | |
| Depreciation | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | |
| Communications | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | |
| Client Relations | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Rent | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Payroll Taxes | 15% | £7,065 | £7,065 | £7,065 | £7,065 | £7,065 | £7,065 | £7,065 | £7,065 | £7,065 | £7,065 | £7,065 | £7,066 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £160,371 | £160,371 | £160,371 | £160,371 | £160,371 | £160,371 | £160,371 | £160,371 | £160,371 | £160,371 | £160,371 | £160,377 | |
| Profit Before Interest and Taxes | £159,462 | £109,062 | £116,262 | £116,262 | £116,262 | £116,262 | £123,462 | £152,262 | £152,262 | £152,262 | £152,262 | £159,457 | |
| EBITDA | £161,662 | £111,262 | £118,462 | £118,462 | £118,462 | £118,462 | £125,662 | £154,462 | £154,462 | £154,462 | £154,462 | £161,657 | |
| Interest Expense | £20,375 | £20,266 | £20,157 | £20,047 | £36,602 | £36,266 | £35,926 | £35,584 | £35,239 | £34,891 | £34,541 | £34,541 | |
| Taxes Incurred | £41,726 | £22,199 | £24,026 | £24,054 | £19,915 | £19,999 | £21,884 | £29,170 | £29,256 | £29,343 | £29,430 | £31,229 | |
| Net Profit | £97,361 | £66,597 | £72,079 | £72,162 | £59,745 | £59,998 | £65,652 | £87,509 | £87,767 | £88,028 | £88,291 | £93,687 | |
| Net Profit/Sales | 21.64% | 17.53% | 18.48% | 18.50% | 15.32% | 15.38% | 16.41% | 19.89% | 19.95% | 20.01% | 20.07% | 20.82% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £22,500 | £19,000 | £19,500 | £19,500 | £19,500 | £19,500 | £20,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,500 | |
| Cash from Receivables | £210,000 | £224,250 | £425,283 | £361,317 | £370,500 | £370,500 | £370,500 | £370,817 | £381,267 | £418,000 | £418,000 | £418,000 | |
| Subtotal Cash from Operations | £232,500 | £243,250 | £444,783 | £380,817 | £390,000 | £390,000 | £390,500 | £392,817 | £403,267 | £440,000 | £440,000 | £440,500 | |
| 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 | £1,000,000 | £0 | £0 | £0 | £2,000,000 | £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 | £1,232,500 | £243,250 | £444,783 | £380,817 | £2,390,000 | £390,000 | £390,500 | £392,817 | £403,267 | £440,000 | £440,000 | £440,500 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,101 | £47,106 | |
| Bill Payments | £1,005,911 | £176,683 | £157,759 | £159,417 | £159,751 | £171,745 | £171,553 | £173,278 | £179,982 | £179,723 | £179,462 | £179,268 | |
| Subtotal Spent on Operations | £1,053,012 | £223,784 | £204,860 | £206,518 | £206,852 | £218,846 | £218,654 | £220,379 | £227,083 | £226,824 | £226,563 | £226,374 | |
| 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 | £13,021 | £13,130 | £13,239 | £13,350 | £40,382 | £40,719 | £41,058 | £41,400 | £41,745 | £42,093 | £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 | £1,053,012 | £236,805 | £217,990 | £219,757 | £220,202 | £259,228 | £259,373 | £261,437 | £268,483 | £268,569 | £268,656 | £226,374 | |
| Net Cash Flow | £179,488 | £6,445 | £226,793 | £161,059 | £2,169,798 | £130,772 | £131,127 | £131,379 | £134,784 | £171,431 | £171,344 | £214,126 | |
| Cash Balance | £624,488 | £630,932 | £857,725 | £1,018,785 | £3,188,583 | £3,319,354 | £3,450,481 | £3,581,860 | £3,716,644 | £3,888,075 | £4,059,419 | £4,273,546 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £445,000 | £624,488 | £630,932 | £857,725 | £1,018,785 | £3,188,583 | £3,319,354 | £3,450,481 | £3,581,860 | £3,716,644 | £3,888,075 | £4,059,419 | £4,273,546 |
| Accounts Receivable | £420,000 | £637,500 | £774,250 | £719,467 | £728,650 | £728,650 | £728,650 | £738,150 | £785,333 | £822,067 | £822,067 | £822,067 | £831,567 |
| Inventory | £1,545,000 | £1,419,000 | £1,312,600 | £1,203,400 | £1,094,200 | £985,000 | £875,800 | £763,800 | £640,600 | £517,400 | £394,200 | £271,000 | £145,000 |
| Other Current Assets | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 | £105,000 |
| Total Current Assets | £2,515,000 | £2,785,988 | £2,822,782 | £2,885,592 | £2,946,635 | £5,007,233 | £5,028,804 | £5,057,431 | £5,112,794 | £5,161,111 | £5,209,342 | £5,257,486 | £5,355,112 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 |
| Accumulated Depreciation | £80,000 | £82,200 | £84,400 | £86,600 | £88,800 | £91,000 | £93,200 | £95,400 | £97,600 | £99,800 | £102,000 | £104,200 | £106,400 |
| Total Long-term Assets | £445,000 | £442,800 | £440,600 | £438,400 | £436,200 | £434,000 | £431,800 | £429,600 | £427,400 | £425,200 | £423,000 | £420,800 | £418,600 |
| Total Assets | £2,960,000 | £3,228,788 | £3,263,382 | £3,323,992 | £3,382,835 | £5,441,233 | £5,460,604 | £5,487,031 | £5,540,194 | £5,586,311 | £5,632,342 | £5,678,286 | £5,773,712 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £1,000,000 | £171,427 | £152,445 | £154,106 | £154,026 | £166,029 | £165,785 | £167,279 | £173,991 | £173,741 | £173,488 | £173,234 | £174,973 |
| Current Borrowing | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 | £1,090,000 |
| Other Current Liabilities | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 | £410,000 |
| Subtotal Current Liabilities | £2,500,000 | £1,671,427 | £1,652,445 | £1,654,106 | £1,654,026 | £1,666,029 | £1,665,785 | £1,667,279 | £1,673,991 | £1,673,741 | £1,673,488 | £1,673,234 | £1,674,973 |
| Long-term Liabilities | £355,000 | £1,355,000 | £1,341,979 | £1,328,849 | £1,315,610 | £3,302,260 | £3,261,878 | £3,221,159 | £3,180,101 | £3,138,701 | £3,096,956 | £3,054,863 | £3,054,863 |
| Total Liabilities | £2,855,000 | £3,026,427 | £2,994,424 | £2,982,955 | £2,969,636 | £4,968,289 | £4,927,663 | £4,888,438 | £4,854,092 | £4,812,442 | £4,770,444 | £4,728,097 | £4,729,836 |
| Paid-in Capital | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 |
| Retained Earnings | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 |
| Earnings | £0 | £97,361 | £163,958 | £236,037 | £308,199 | £367,944 | £427,941 | £493,593 | £581,102 | £668,869 | £756,898 | £845,189 | £938,876 |
| Total Capital | £105,000 | £202,361 | £268,958 | £341,037 | £413,199 | £472,944 | £532,941 | £598,593 | £686,102 | £773,869 | £861,898 | £950,189 | £1,043,876 |
| Total Liabilities and Capital | £2,960,000 | £3,228,788 | £3,263,382 | £3,323,992 | £3,382,835 | £5,441,233 | £5,460,604 | £5,487,031 | £5,540,194 | £5,586,311 | £5,632,342 | £5,678,286 | £5,773,712 |
| Net Worth | £105,000 | £202,361 | £268,958 | £341,037 | £413,199 | £472,944 | £532,941 | £598,593 | £686,102 | £773,869 | £861,898 | £950,189 | £1,043,876 |
| Past Performance | |||
| 1997 | 1998 | 1999 | |
| Sales | £0 | £0 | £3,000,000 |
| Gross Margin | £0 | £0 | £750,000 |
| Gross Margin % | 0.00% | 0.00% | 25.00% |
| Operating Expenses | £0 | £0 | £1,200,000 |
| Collection Period (days) | 0 | 0 | 34 |
| Inventory Turnover | 0.00 | 0.00 | 6.00 |
| Balance Sheet | |||
| 1997 | 1998 | 1999 | |
| Current Assets | |||
| Cash | £0 | £0 | £445,000 |
| Accounts Receivable | £0 | £0 | £420,000 |
| Inventory | £0 | £0 | £1,545,000 |
| Other Current Assets | £0 | £0 | £105,000 |
| Total Current Assets | £0 | £0 | £2,515,000 |
| Long-term Assets | |||
| Long-term Assets | £0 | £0 | £525,000 |
| Accumulated Depreciation | £0 | £0 | £80,000 |
| Total Long-term Assets | £0 | £0 | £445,000 |
| Total Assets | £0 | £0 | £2,960,000 |
| Current Liabilities | |||
| Accounts Payable | £0 | £0 | £1,000,000 |
| Current Borrowing | £0 | £0 | £1,090,000 |
| Other Current Liabilities (interest free) | £0 | £0 | £410,000 |
| Total Current Liabilities | £0 | £0 | £2,500,000 |
| Long-term Liabilities | £0 | £0 | £355,000 |
| Total Liabilities | £0 | £0 | £2,855,000 |
| Paid-in Capital | £0 | £0 | £70,000 |
| Retained Earnings | £0 | £0 | £35,000 |
| Earnings | £0 | £0 | £0 |
| Total Capital | £0 | £0 | £105,000 |
| Total Capital and Liabilities | £0 | £0 | £2,960,000 |
| Other Inputs | |||
| Payment Days | 0 | 0 | 30 |
| Sales on Credit | £0 | £0 | £2,250,000 |
| Receivables Turnover | 0.00 | 0.00 | 5.36 |