| Personnel Plan | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| All departments | 0% | £36,231 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | |
| Total Payroll | £36,231 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | |
| Sales Forecast | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | |||||||||||||
| Hosting Services | 0% | £13,953 | £13,953 | £16,279 | £19,767 | £23,255 | £23,255 | £23,255 | £23,255 | £23,255 | £23,255 | £23,255 | £23,255 |
| Internet Sales | 0% | £18,140 | £18,140 | £21,163 | £25,698 | £30,233 | £30,233 | £30,233 | £30,233 | £30,233 | £30,233 | £30,233 | £30,233 |
| Computing Solutions | 0% | £27,907 | £27,907 | £32,558 | £39,535 | £46,512 | £46,512 | £46,512 | £46,512 | £46,512 | £46,512 | £46,512 | £46,512 |
| Total Sales | £60,000 | £60,000 | £70,000 | £85,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | |
| Direct Cost of Sales | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Hosting Services | £1,298 | £1,298 | £1,514 | £1,839 | £2,163 | £2,163 | £2,163 | £2,163 | £2,163 | £2,163 | £2,163 | £2,163 | |
| Internet Sales | £1,687 | £1,687 | £1,969 | £2,390 | £2,813 | £2,813 | £2,813 | £2,813 | £2,813 | £2,813 | £2,813 | £2,812 | |
| Computing Solutions | £2,595 | £2,595 | £3,028 | £3,677 | £4,327 | £4,327 | £4,327 | £4,327 | £4,327 | £4,327 | £4,327 | £4,327 | |
| Subtotal Direct Cost of Sales | £5,580 | £5,580 | £6,511 | £7,906 | £9,303 | £9,303 | £9,303 | £9,303 | £9,303 | £9,303 | £9,303 | £9,302 | |
| General Assumptions | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| 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 Cash Flow | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £15,000 | £15,000 | £17,500 | £21,250 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | |
| Cash from Receivables | £20,000 | £21,500 | £45,000 | £45,250 | £52,875 | £64,125 | £75,000 | £75,000 | £75,000 | £75,000 | £75,000 | £75,000 | |
| Subtotal Cash from Operations | £35,000 | £36,500 | £62,500 | £66,500 | £77,875 | £89,125 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,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 | £914,900 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,000,000 | £0 | £0 | £0 | |
| Subtotal Cash Received | £949,900 | £36,500 | £62,500 | £66,500 | £77,875 | £89,125 | £100,000 | £100,000 | £3,100,000 | £100,000 | £100,000 | £100,000 | |
| Expenditures | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £36,231 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | |
| Bill Payments | £32,126 | £63,773 | £63,771 | £63,750 | £65,140 | £66,491 | £66,491 | £66,491 | £66,491 | £66,491 | £66,491 | £66,491 | |
| Subtotal Spent on Operations | £68,357 | £100,005 | £100,003 | £99,982 | £101,372 | £102,723 | £102,723 | £102,723 | £102,723 | £102,723 | £102,723 | £102,723 | |
| 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 | £646 | £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 | £22,000 | £30,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £90,357 | £130,005 | £200,003 | £200,628 | £201,372 | £202,723 | £202,723 | £202,723 | £202,723 | £202,723 | £202,723 | £202,723 | |
| Net Cash Flow | £859,543 | (£93,505) | (£137,503) | (£134,128) | (£123,497) | (£113,598) | (£102,723) | (£102,723) | £2,897,277 | (£102,723) | (£102,723) | (£102,723) | |
| Cash Balance | £889,543 | £796,038 | £658,535 | £524,407 | £400,910 | £287,312 | £184,589 | £81,866 | £2,979,144 | £2,876,421 | £2,773,698 | £2,670,975 | |
| Pro Forma Profit and Loss | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | £60,000 | £60,000 | £70,000 | £85,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | |
| Direct Cost of Sales | £5,580 | £5,580 | £6,511 | £7,906 | £9,303 | £9,303 | £9,303 | £9,303 | £9,303 | £9,303 | £9,303 | £9,302 | |
| Other | £4,000 | £4,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Total Cost of Sales | £9,580 | £9,580 | £9,511 | £10,906 | £12,303 | £12,303 | £12,303 | £12,303 | £12,303 | £12,303 | £12,303 | £12,302 | |
| Gross Margin | £50,420 | £50,420 | £60,489 | £74,094 | £87,697 | £87,697 | £87,697 | £87,697 | £87,697 | £87,697 | £87,697 | £87,698 | |
| Gross Margin % | 84.03% | 84.03% | 86.41% | 87.17% | 87.70% | 87.70% | 87.70% | 87.70% | 87.70% | 87.70% | 87.70% | 87.70% | |
| Expenses | |||||||||||||
| Payroll | £36,231 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | |
| Sales and Marketing and Other Expenses | £40,300 | £40,300 | £40,300 | £40,300 | £40,300 | £40,300 | £40,300 | £40,300 | £40,300 | £40,300 | £40,300 | £40,300 | |
| Depreciation | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Rent | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Utilities | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Continuing Education | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Payroll Taxes | 15% | £5,435 | £5,435 | £5,435 | £5,435 | £5,435 | £5,435 | £5,435 | £5,435 | £5,435 | £5,435 | £5,435 | £5,435 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £92,966 | £92,967 | £92,967 | £92,967 | £92,967 | £92,967 | £92,967 | £92,967 | £92,967 | £92,967 | £92,967 | £92,967 | |
| Profit Before Interest and Taxes | (£42,546) | (£42,547) | (£32,478) | (£18,873) | (£5,270) | (£5,270) | (£5,270) | (£5,270) | (£5,270) | (£5,270) | (£5,270) | (£5,269) | |
| EBITDA | (£39,546) | (£39,547) | (£29,478) | (£15,873) | (£2,270) | (£2,270) | (£2,270) | (£2,270) | (£2,270) | (£2,270) | (£2,270) | (£2,269) | |
| Interest Expense | £458 | £458 | £458 | £453 | £453 | £453 | £453 | £453 | £453 | £453 | £453 | £453 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£43,004) | (£43,005) | (£32,936) | (£19,326) | (£5,723) | (£5,723) | (£5,723) | (£5,723) | (£5,723) | (£5,723) | (£5,723) | (£5,722) | |
| Net Profit/Sales | -71.67% | -71.68% | -47.05% | -22.74% | -5.72% | -5.72% | -5.72% | -5.72% | -5.72% | -5.72% | -5.72% | -5.72% | |
| Pro Forma Balance Sheet | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £30,000 | £889,543 | £796,038 | £658,535 | £524,407 | £400,910 | £287,312 | £184,589 | £81,866 | £2,979,144 | £2,876,421 | £2,773,698 | £2,670,975 |
| Accounts Receivable | £40,000 | £65,000 | £88,500 | £96,000 | £114,500 | £136,625 | £147,500 | £147,500 | £147,500 | £147,500 | £147,500 | £147,500 | £147,500 |
| 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 | £75,000 | £959,543 | £889,538 | £759,535 | £643,907 | £542,535 | £439,812 | £337,089 | £234,366 | £3,131,644 | £3,028,921 | £2,926,198 | £2,823,475 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £100,000 | £122,000 | £152,000 | £252,000 | £352,000 | £452,000 | £552,000 | £652,000 | £752,000 | £852,000 | £952,000 | £1,052,000 | £1,152,000 |
| Accumulated Depreciation | £20,000 | £23,000 | £26,000 | £29,000 | £32,000 | £35,000 | £38,000 | £41,000 | £44,000 | £47,000 | £50,000 | £53,000 | £56,000 |
| Total Long-term Assets | £80,000 | £99,000 | £126,000 | £223,000 | £320,000 | £417,000 | £514,000 | £611,000 | £708,000 | £805,000 | £902,000 | £999,000 | £1,096,000 |
| Total Assets | £155,000 | £1,058,543 | £1,015,538 | £982,535 | £963,907 | £959,535 | £953,812 | £948,089 | £942,366 | £3,936,644 | £3,930,921 | £3,925,198 | £3,919,475 |
| Liabilities and Capital | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £30,000 | £61,647 | £61,647 | £61,581 | £62,924 | £64,274 | £64,274 | £64,274 | £64,274 | £64,274 | £64,274 | £64,274 | £64,273 |
| Current Borrowing | £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 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £35,000 | £66,647 | £66,647 | £66,581 | £67,924 | £69,274 | £69,274 | £69,274 | £69,274 | £69,274 | £69,274 | £69,274 | £69,273 |
| Long-term Liabilities | £50,000 | £50,000 | £50,000 | £50,000 | £49,354 | £49,354 | £49,354 | £49,354 | £49,354 | £49,354 | £49,354 | £49,354 | £49,354 |
| Total Liabilities | £85,000 | £116,647 | £116,647 | £116,581 | £117,278 | £118,628 | £118,628 | £118,628 | £118,628 | £118,628 | £118,628 | £118,628 | £118,627 |
| Paid-in Capital | £25,000 | £939,900 | £939,900 | £939,900 | £939,900 | £939,900 | £939,900 | £939,900 | £939,900 | £3,939,900 | £3,939,900 | £3,939,900 | £3,939,900 |
| Retained Earnings | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 |
| Earnings | £0 | (£43,004) | (£86,009) | (£118,945) | (£138,271) | (£143,994) | (£149,717) | (£155,439) | (£161,162) | (£166,885) | (£172,608) | (£178,330) | (£184,052) |
| Total Capital | £70,000 | £941,896 | £898,891 | £865,955 | £846,629 | £840,906 | £835,184 | £829,461 | £823,738 | £3,818,015 | £3,812,293 | £3,806,570 | £3,800,848 |
| Total Liabilities and Capital | £155,000 | £1,058,543 | £1,015,538 | £982,535 | £963,907 | £959,535 | £953,812 | £948,089 | £942,366 | £3,936,644 | £3,930,921 | £3,925,198 | £3,919,475 |
| Net Worth | £70,000 | £941,896 | £898,891 | £865,955 | £846,629 | £840,906 | £835,183 | £829,461 | £823,738 | £3,818,015 | £3,812,293 | £3,806,570 | £3,800,848 |
| Personnel Plan | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| All departments | 0% | £36,231 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | |
| Total Payroll | £36,231 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | |
| Sales Forecast | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | |||||||||||||
| Hosting Services | 0% | £13,953 | £13,953 | £16,279 | £19,767 | £23,255 | £23,255 | £23,255 | £23,255 | £23,255 | £23,255 | £23,255 | £23,255 |
| Internet Sales | 0% | £18,140 | £18,140 | £21,163 | £25,698 | £30,233 | £30,233 | £30,233 | £30,233 | £30,233 | £30,233 | £30,233 | £30,233 |
| Computing Solutions | 0% | £27,907 | £27,907 | £32,558 | £39,535 | £46,512 | £46,512 | £46,512 | £46,512 | £46,512 | £46,512 | £46,512 | £46,512 |
| Total Sales | £60,000 | £60,000 | £70,000 | £85,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | |
| Direct Cost of Sales | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Hosting Services | £1,298 | £1,298 | £1,514 | £1,839 | £2,163 | £2,163 | £2,163 | £2,163 | £2,163 | £2,163 | £2,163 | £2,163 | |
| Internet Sales | £1,687 | £1,687 | £1,969 | £2,390 | £2,813 | £2,813 | £2,813 | £2,813 | £2,813 | £2,813 | £2,813 | £2,812 | |
| Computing Solutions | £2,595 | £2,595 | £3,028 | £3,677 | £4,327 | £4,327 | £4,327 | £4,327 | £4,327 | £4,327 | £4,327 | £4,327 | |
| Subtotal Direct Cost of Sales | £5,580 | £5,580 | £6,511 | £7,906 | £9,303 | £9,303 | £9,303 | £9,303 | £9,303 | £9,303 | £9,303 | £9,302 | |
| General Assumptions | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| 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 Cash Flow | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £15,000 | £15,000 | £17,500 | £21,250 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | |
| Cash from Receivables | £20,000 | £21,500 | £45,000 | £45,250 | £52,875 | £64,125 | £75,000 | £75,000 | £75,000 | £75,000 | £75,000 | £75,000 | |
| Subtotal Cash from Operations | £35,000 | £36,500 | £62,500 | £66,500 | £77,875 | £89,125 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,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 | £914,900 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,000,000 | £0 | £0 | £0 | |
| Subtotal Cash Received | £949,900 | £36,500 | £62,500 | £66,500 | £77,875 | £89,125 | £100,000 | £100,000 | £3,100,000 | £100,000 | £100,000 | £100,000 | |
| Expenditures | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £36,231 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | |
| Bill Payments | £32,126 | £63,773 | £63,771 | £63,750 | £65,140 | £66,491 | £66,491 | £66,491 | £66,491 | £66,491 | £66,491 | £66,491 | |
| Subtotal Spent on Operations | £68,357 | £100,005 | £100,003 | £99,982 | £101,372 | £102,723 | £102,723 | £102,723 | £102,723 | £102,723 | £102,723 | £102,723 | |
| 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 | £646 | £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 | £22,000 | £30,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £90,357 | £130,005 | £200,003 | £200,628 | £201,372 | £202,723 | £202,723 | £202,723 | £202,723 | £202,723 | £202,723 | £202,723 | |
| Net Cash Flow | £859,543 | (£93,505) | (£137,503) | (£134,128) | (£123,497) | (£113,598) | (£102,723) | (£102,723) | £2,897,277 | (£102,723) | (£102,723) | (£102,723) | |
| Cash Balance | £889,543 | £796,038 | £658,535 | £524,407 | £400,910 | £287,312 | £184,589 | £81,866 | £2,979,144 | £2,876,421 | £2,773,698 | £2,670,975 | |
| Pro Forma Profit and Loss | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | £60,000 | £60,000 | £70,000 | £85,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | |
| Direct Cost of Sales | £5,580 | £5,580 | £6,511 | £7,906 | £9,303 | £9,303 | £9,303 | £9,303 | £9,303 | £9,303 | £9,303 | £9,302 | |
| Other | £4,000 | £4,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Total Cost of Sales | £9,580 | £9,580 | £9,511 | £10,906 | £12,303 | £12,303 | £12,303 | £12,303 | £12,303 | £12,303 | £12,303 | £12,302 | |
| Gross Margin | £50,420 | £50,420 | £60,489 | £74,094 | £87,697 | £87,697 | £87,697 | £87,697 | £87,697 | £87,697 | £87,697 | £87,698 | |
| Gross Margin % | 84.03% | 84.03% | 86.41% | 87.17% | 87.70% | 87.70% | 87.70% | 87.70% | 87.70% | 87.70% | 87.70% | 87.70% | |
| Expenses | |||||||||||||
| Payroll | £36,231 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | £36,232 | |
| Sales and Marketing and Other Expenses | £40,300 | £40,300 | £40,300 | £40,300 | £40,300 | £40,300 | £40,300 | £40,300 | £40,300 | £40,300 | £40,300 | £40,300 | |
| Depreciation | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Rent | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Utilities | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Continuing Education | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Payroll Taxes | 15% | £5,435 | £5,435 | £5,435 | £5,435 | £5,435 | £5,435 | £5,435 | £5,435 | £5,435 | £5,435 | £5,435 | £5,435 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £92,966 | £92,967 | £92,967 | £92,967 | £92,967 | £92,967 | £92,967 | £92,967 | £92,967 | £92,967 | £92,967 | £92,967 | |
| Profit Before Interest and Taxes | (£42,546) | (£42,547) | (£32,478) | (£18,873) | (£5,270) | (£5,270) | (£5,270) | (£5,270) | (£5,270) | (£5,270) | (£5,270) | (£5,269) | |
| EBITDA | (£39,546) | (£39,547) | (£29,478) | (£15,873) | (£2,270) | (£2,270) | (£2,270) | (£2,270) | (£2,270) | (£2,270) | (£2,270) | (£2,269) | |
| Interest Expense | £458 | £458 | £458 | £453 | £453 | £453 | £453 | £453 | £453 | £453 | £453 | £453 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£43,004) | (£43,005) | (£32,936) | (£19,326) | (£5,723) | (£5,723) | (£5,723) | (£5,723) | (£5,723) | (£5,723) | (£5,723) | (£5,722) | |
| Net Profit/Sales | -71.67% | -71.68% | -47.05% | -22.74% | -5.72% | -5.72% | -5.72% | -5.72% | -5.72% | -5.72% | -5.72% | -5.72% | |
| Pro Forma Balance Sheet | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £30,000 | £889,543 | £796,038 | £658,535 | £524,407 | £400,910 | £287,312 | £184,589 | £81,866 | £2,979,144 | £2,876,421 | £2,773,698 | £2,670,975 |
| Accounts Receivable | £40,000 | £65,000 | £88,500 | £96,000 | £114,500 | £136,625 | £147,500 | £147,500 | £147,500 | £147,500 | £147,500 | £147,500 | £147,500 |
| 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 | £75,000 | £959,543 | £889,538 | £759,535 | £643,907 | £542,535 | £439,812 | £337,089 | £234,366 | £3,131,644 | £3,028,921 | £2,926,198 | £2,823,475 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £100,000 | £122,000 | £152,000 | £252,000 | £352,000 | £452,000 | £552,000 | £652,000 | £752,000 | £852,000 | £952,000 | £1,052,000 | £1,152,000 |
| Accumulated Depreciation | £20,000 | £23,000 | £26,000 | £29,000 | £32,000 | £35,000 | £38,000 | £41,000 | £44,000 | £47,000 | £50,000 | £53,000 | £56,000 |
| Total Long-term Assets | £80,000 | £99,000 | £126,000 | £223,000 | £320,000 | £417,000 | £514,000 | £611,000 | £708,000 | £805,000 | £902,000 | £999,000 | £1,096,000 |
| Total Assets | £155,000 | £1,058,543 | £1,015,538 | £982,535 | £963,907 | £959,535 | £953,812 | £948,089 | £942,366 | £3,936,644 | £3,930,921 | £3,925,198 | £3,919,475 |
| Liabilities and Capital | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £30,000 | £61,647 | £61,647 | £61,581 | £62,924 | £64,274 | £64,274 | £64,274 | £64,274 | £64,274 | £64,274 | £64,274 | £64,273 |
| Current Borrowing | £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 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £35,000 | £66,647 | £66,647 | £66,581 | £67,924 | £69,274 | £69,274 | £69,274 | £69,274 | £69,274 | £69,274 | £69,274 | £69,273 |
| Long-term Liabilities | £50,000 | £50,000 | £50,000 | £50,000 | £49,354 | £49,354 | £49,354 | £49,354 | £49,354 | £49,354 | £49,354 | £49,354 | £49,354 |
| Total Liabilities | £85,000 | £116,647 | £116,647 | £116,581 | £117,278 | £118,628 | £118,628 | £118,628 | £118,628 | £118,628 | £118,628 | £118,628 | £118,627 |
| Paid-in Capital | £25,000 | £939,900 | £939,900 | £939,900 | £939,900 | £939,900 | £939,900 | £939,900 | £939,900 | £3,939,900 | £3,939,900 | £3,939,900 | £3,939,900 |
| Retained Earnings | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 |
| Earnings | £0 | (£43,004) | (£86,009) | (£118,945) | (£138,271) | (£143,994) | (£149,717) | (£155,439) | (£161,162) | (£166,885) | (£172,608) | (£178,330) | (£184,052) |
| Total Capital | £70,000 | £941,896 | £898,891 | £865,955 | £846,629 | £840,906 | £835,184 | £829,461 | £823,738 | £3,818,015 | £3,812,293 | £3,806,570 | £3,800,848 |
| Total Liabilities and Capital | £155,000 | £1,058,543 | £1,015,538 | £982,535 | £963,907 | £959,535 | £953,812 | £948,089 | £942,366 | £3,936,644 | £3,930,921 | £3,925,198 | £3,919,475 |
| Net Worth | £70,000 | £941,896 | £898,891 | £865,955 | £846,629 | £840,906 | £835,183 | £829,461 | £823,738 | £3,818,015 | £3,812,293 | £3,806,570 | £3,800,848 |