| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| CATA | 0% | £5,475 | £3,016 | £2,434 | £3,080 | £3,080 | £3,080 | £3,080 | £3,080 | £3,080 | £3,080 | £3,080 | £3,080 |
| Corporate Clients | 0% | £899 | £1,351 | £947 | £1,000 | £1,000 | £1,000 | £1,000 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 |
| Transfers (Credit Cards) | 0% | £1,900 | £2,400 | £3,344 | £3,807 | £4,230 | £5,076 | £5,076 | £5,499 | £5,922 | £5,922 | £6,345 | £6,345 |
| Hourly Hire | 0% | £0 | £0 | £1,617 | £0 | £1,080 | £1,440 | £1,800 | £2,160 | £2,880 | £3,240 | £3,600 | £2,880 |
| Total Sales | £8,274 | £6,767 | £8,342 | £7,887 | £9,390 | £10,596 | £10,956 | £11,939 | £13,082 | £13,442 | £14,225 | £13,505 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| CATA | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Corporate Clients | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Transfers (Credit Cards) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Hourly Hire | £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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Tim Politano | 0% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £2,000 |
| Peter Battinelli | 0% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £2,000 |
| Brian | 0% | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £1,440 | £1,440 | £1,440 | £1,440 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,840 | £3,840 | £3,840 | £5,440 | |
| 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 | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | |
| Tax Rate | 30.00% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | |
| 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 | £8,274 | £6,767 | £8,342 | £7,887 | £9,390 | £10,596 | £10,956 | £11,939 | £13,082 | £13,442 | £14,225 | £13,505 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Gross Margin | £8,274 | £6,767 | £8,342 | £7,887 | £9,390 | £10,596 | £10,956 | £11,939 | £13,082 | £13,442 | £14,225 | £13,505 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,840 | £3,840 | £3,840 | £5,440 | |
| Sales and Marketing and Other Expenses | £4,036 | £3,966 | £4,057 | £4,662 | £11,610 | £3,397 | £3,038 | £3,480 | £3,169 | £3,188 | £3,618 | £2,533 | |
| Depreciation | £23 | £24 | £23 | £23 | £1,324 | £1,324 | £1,324 | £1,324 | £1,324 | £1,324 | £1,324 | £1,324 | |
| Depreciation | £55 | £55 | £55 | £55 | £55 | £55 | £55 | £55 | £55 | £55 | £55 | £55 | |
| Utilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Garage Rental | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Accounting | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | |
| Payroll Taxes | 13% | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £486 | £486 | £486 | £688 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £8,701 | £8,632 | £8,722 | £9,327 | £17,576 | £9,363 | £9,004 | £9,446 | £9,744 | £9,763 | £10,193 | £10,910 | |
| Profit Before Interest and Taxes | (£427) | (£1,865) | (£380) | (£1,440) | (£8,186) | £1,233 | £1,952 | £2,493 | £3,338 | £3,679 | £4,032 | £2,595 | |
| EBITDA | (£404) | (£1,841) | (£357) | (£1,417) | (£6,862) | £2,557 | £3,276 | £3,817 | £4,662 | £5,003 | £5,356 | £3,919 | |
| Interest Expense | £120 | £120 | £120 | £53 | £261 | £260 | £259 | £258 | £257 | £256 | £255 | £271 | |
| Taxes Incurred | (£164) | (£486) | (£123) | (£366) | (£2,070) | £238 | £415 | £547 | £755 | £839 | £925 | £569 | |
| Net Profit | (£383) | (£1,499) | (£378) | (£1,128) | (£6,378) | £734 | £1,278 | £1,687 | £2,326 | £2,584 | £2,851 | £1,755 | |
| Net Profit/Sales | -4.63% | -22.15% | -4.53% | -14.30% | -67.92% | 6.93% | 11.66% | 14.13% | 17.78% | 19.23% | 20.05% | 12.99% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £7,447 | £6,090 | £7,508 | £7,098 | £8,451 | £9,536 | £9,860 | £10,745 | £11,774 | £12,098 | £12,803 | £12,155 | |
| Cash from Receivables | £2,000 | £2,028 | £822 | £682 | £833 | £794 | £943 | £1,061 | £1,099 | £1,198 | £1,309 | £1,347 | |
| Subtotal Cash from Operations | £9,447 | £8,118 | £8,330 | £7,780 | £9,284 | £10,330 | £10,803 | £11,806 | £12,873 | £13,296 | £14,112 | £13,501 | |
| 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 | £21,000 | £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 | £43,529 | £0 | £0 | £0 | £0 | £0 | £0 | £20,570 | |
| 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 | £9,500 | £0 | £0 | £0 | £0 | £0 | £0 | £2,500 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £9,447 | £8,118 | £8,330 | £17,280 | £73,813 | £10,330 | £10,803 | £11,806 | £12,873 | £13,296 | £16,612 | £34,071 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,840 | £3,840 | £3,840 | £5,440 | |
| Bill Payments | £178 | £5,321 | £4,957 | £5,407 | £5,873 | £10,947 | £5,232 | £5,073 | £5,627 | £5,595 | £5,711 | £6,169 | |
| Subtotal Spent on Operations | £3,478 | £8,621 | £8,257 | £8,707 | £9,173 | £14,247 | £8,532 | £8,373 | £9,467 | £9,435 | £9,551 | £11,609 | |
| 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 | £8,000 | £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 | £1,194 | £1,194 | £1,194 | £1,194 | £1,194 | £1,194 | £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 | £54,410 | £0 | £0 | £0 | £0 | £0 | £0 | £27,205 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £3,478 | £8,621 | £8,257 | £16,707 | £63,583 | £15,441 | £9,726 | £9,567 | £10,661 | £10,629 | £10,745 | £38,814 | |
| Net Cash Flow | £5,969 | (£503) | £73 | £574 | £10,229 | (£5,111) | £1,078 | £2,239 | £2,212 | £2,666 | £5,867 | (£4,742) | |
| Cash Balance | £7,169 | £6,666 | £6,739 | £7,312 | £17,542 | £12,431 | £13,509 | £15,747 | £17,959 | £20,625 | £26,492 | £21,750 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £1,200 | £7,169 | £6,666 | £6,739 | £7,312 | £17,542 | £12,431 | £13,509 | £15,747 | £17,959 | £20,625 | £26,492 | £21,750 |
| Accounts Receivable | £4,000 | £2,827 | £1,477 | £1,488 | £1,595 | £1,701 | £1,967 | £2,120 | £2,253 | £2,462 | £2,609 | £2,722 | £2,726 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £5,200 | £9,996 | £8,142 | £8,227 | £8,907 | £19,243 | £14,398 | £15,629 | £18,000 | £20,421 | £23,234 | £29,214 | £24,475 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £14,000 | £14,000 | £14,000 | £14,000 | £4,500 | £58,910 | £58,910 | £58,910 | £58,910 | £58,910 | £58,910 | £56,410 | £83,615 |
| Accumulated Depreciation | £0 | £23 | £47 | £70 | £93 | £1,417 | £2,741 | £4,065 | £5,389 | £6,713 | £8,037 | £9,361 | £10,685 |
| Total Long-term Assets | £14,000 | £13,977 | £13,953 | £13,930 | £4,407 | £57,493 | £56,169 | £54,845 | £53,521 | £52,197 | £50,873 | £47,049 | £72,930 |
| Total Assets | £19,200 | £23,973 | £22,095 | £22,157 | £13,314 | £76,736 | £70,567 | £70,474 | £71,521 | £72,618 | £74,107 | £76,263 | £97,405 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £5,156 | £4,777 | £5,217 | £5,502 | £10,772 | £5,063 | £4,886 | £5,440 | £5,405 | £5,504 | £6,003 | £4,820 |
| Current Borrowing | £12,000 | £12,000 | £12,000 | £12,000 | £4,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 |
| Other Current Liabilities | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Subtotal Current Liabilities | £15,500 | £20,656 | £20,277 | £20,717 | £13,002 | £39,272 | £33,563 | £33,386 | £33,940 | £33,905 | £34,004 | £34,503 | £33,320 |
| Long-term Liabilities | £26,500 | £26,500 | £26,500 | £26,500 | £26,500 | £70,029 | £68,835 | £67,641 | £66,447 | £65,253 | £64,059 | £62,865 | £83,435 |
| Total Liabilities | £42,000 | £47,156 | £46,777 | £47,217 | £39,502 | £109,301 | £102,398 | £101,027 | £100,387 | £99,158 | £98,063 | £97,368 | £116,755 |
| Paid-in Capital | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 |
| Retained Earnings | (£56,657) | (£22,900) | (£22,900) | (£22,900) | (£22,900) | (£22,900) | (£22,900) | (£22,900) | (£22,900) | (£22,900) | (£22,900) | (£22,900) | (£22,900) |
| Earnings | £33,757 | (£383) | (£1,882) | (£2,260) | (£3,388) | (£9,765) | (£9,031) | (£7,753) | (£6,066) | (£3,740) | (£1,156) | £1,696 | £3,450 |
| Total Capital | (£22,800) | (£23,183) | (£24,682) | (£25,060) | (£26,188) | (£32,565) | (£31,831) | (£30,553) | (£28,866) | (£26,540) | (£23,956) | (£21,104) | (£19,350) |
| Total Liabilities and Capital | £19,200 | £23,973 | £22,095 | £22,157 | £13,314 | £76,736 | £70,567 | £70,474 | £71,521 | £72,618 | £74,107 | £76,263 | £97,405 |
| Net Worth | (£22,800) | (£23,183) | (£24,682) | (£25,060) | (£26,188) | (£32,565) | (£31,831) | (£30,553) | (£28,866) | (£26,540) | (£23,956) | (£21,104) | (£19,350) |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| CATA | 0% | £5,475 | £3,016 | £2,434 | £3,080 | £3,080 | £3,080 | £3,080 | £3,080 | £3,080 | £3,080 | £3,080 | £3,080 |
| Corporate Clients | 0% | £899 | £1,351 | £947 | £1,000 | £1,000 | £1,000 | £1,000 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 |
| Transfers (Credit Cards) | 0% | £1,900 | £2,400 | £3,344 | £3,807 | £4,230 | £5,076 | £5,076 | £5,499 | £5,922 | £5,922 | £6,345 | £6,345 |
| Hourly Hire | 0% | £0 | £0 | £1,617 | £0 | £1,080 | £1,440 | £1,800 | £2,160 | £2,880 | £3,240 | £3,600 | £2,880 |
| Total Sales | £8,274 | £6,767 | £8,342 | £7,887 | £9,390 | £10,596 | £10,956 | £11,939 | £13,082 | £13,442 | £14,225 | £13,505 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| CATA | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Corporate Clients | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Transfers (Credit Cards) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Hourly Hire | £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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Tim Politano | 0% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £2,000 |
| Peter Battinelli | 0% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £2,000 |
| Brian | 0% | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £1,440 | £1,440 | £1,440 | £1,440 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,840 | £3,840 | £3,840 | £5,440 | |
| 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 | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | 0.90% | |
| Tax Rate | 30.00% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | 24.50% | |
| 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 | £8,274 | £6,767 | £8,342 | £7,887 | £9,390 | £10,596 | £10,956 | £11,939 | £13,082 | £13,442 | £14,225 | £13,505 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Gross Margin | £8,274 | £6,767 | £8,342 | £7,887 | £9,390 | £10,596 | £10,956 | £11,939 | £13,082 | £13,442 | £14,225 | £13,505 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,840 | £3,840 | £3,840 | £5,440 | |
| Sales and Marketing and Other Expenses | £4,036 | £3,966 | £4,057 | £4,662 | £11,610 | £3,397 | £3,038 | £3,480 | £3,169 | £3,188 | £3,618 | £2,533 | |
| Depreciation | £23 | £24 | £23 | £23 | £1,324 | £1,324 | £1,324 | £1,324 | £1,324 | £1,324 | £1,324 | £1,324 | |
| Depreciation | £55 | £55 | £55 | £55 | £55 | £55 | £55 | £55 | £55 | £55 | £55 | £55 | |
| Utilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Garage Rental | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Accounting | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | |
| Payroll Taxes | 13% | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £486 | £486 | £486 | £688 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £8,701 | £8,632 | £8,722 | £9,327 | £17,576 | £9,363 | £9,004 | £9,446 | £9,744 | £9,763 | £10,193 | £10,910 | |
| Profit Before Interest and Taxes | (£427) | (£1,865) | (£380) | (£1,440) | (£8,186) | £1,233 | £1,952 | £2,493 | £3,338 | £3,679 | £4,032 | £2,595 | |
| EBITDA | (£404) | (£1,841) | (£357) | (£1,417) | (£6,862) | £2,557 | £3,276 | £3,817 | £4,662 | £5,003 | £5,356 | £3,919 | |
| Interest Expense | £120 | £120 | £120 | £53 | £261 | £260 | £259 | £258 | £257 | £256 | £255 | £271 | |
| Taxes Incurred | (£164) | (£486) | (£123) | (£366) | (£2,070) | £238 | £415 | £547 | £755 | £839 | £925 | £569 | |
| Net Profit | (£383) | (£1,499) | (£378) | (£1,128) | (£6,378) | £734 | £1,278 | £1,687 | £2,326 | £2,584 | £2,851 | £1,755 | |
| Net Profit/Sales | -4.63% | -22.15% | -4.53% | -14.30% | -67.92% | 6.93% | 11.66% | 14.13% | 17.78% | 19.23% | 20.05% | 12.99% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £7,447 | £6,090 | £7,508 | £7,098 | £8,451 | £9,536 | £9,860 | £10,745 | £11,774 | £12,098 | £12,803 | £12,155 | |
| Cash from Receivables | £2,000 | £2,028 | £822 | £682 | £833 | £794 | £943 | £1,061 | £1,099 | £1,198 | £1,309 | £1,347 | |
| Subtotal Cash from Operations | £9,447 | £8,118 | £8,330 | £7,780 | £9,284 | £10,330 | £10,803 | £11,806 | £12,873 | £13,296 | £14,112 | £13,501 | |
| 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 | £21,000 | £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 | £43,529 | £0 | £0 | £0 | £0 | £0 | £0 | £20,570 | |
| 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 | £9,500 | £0 | £0 | £0 | £0 | £0 | £0 | £2,500 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £9,447 | £8,118 | £8,330 | £17,280 | £73,813 | £10,330 | £10,803 | £11,806 | £12,873 | £13,296 | £16,612 | £34,071 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,840 | £3,840 | £3,840 | £5,440 | |
| Bill Payments | £178 | £5,321 | £4,957 | £5,407 | £5,873 | £10,947 | £5,232 | £5,073 | £5,627 | £5,595 | £5,711 | £6,169 | |
| Subtotal Spent on Operations | £3,478 | £8,621 | £8,257 | £8,707 | £9,173 | £14,247 | £8,532 | £8,373 | £9,467 | £9,435 | £9,551 | £11,609 | |
| 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 | £8,000 | £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 | £1,194 | £1,194 | £1,194 | £1,194 | £1,194 | £1,194 | £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 | £54,410 | £0 | £0 | £0 | £0 | £0 | £0 | £27,205 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £3,478 | £8,621 | £8,257 | £16,707 | £63,583 | £15,441 | £9,726 | £9,567 | £10,661 | £10,629 | £10,745 | £38,814 | |
| Net Cash Flow | £5,969 | (£503) | £73 | £574 | £10,229 | (£5,111) | £1,078 | £2,239 | £2,212 | £2,666 | £5,867 | (£4,742) | |
| Cash Balance | £7,169 | £6,666 | £6,739 | £7,312 | £17,542 | £12,431 | £13,509 | £15,747 | £17,959 | £20,625 | £26,492 | £21,750 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £1,200 | £7,169 | £6,666 | £6,739 | £7,312 | £17,542 | £12,431 | £13,509 | £15,747 | £17,959 | £20,625 | £26,492 | £21,750 |
| Accounts Receivable | £4,000 | £2,827 | £1,477 | £1,488 | £1,595 | £1,701 | £1,967 | £2,120 | £2,253 | £2,462 | £2,609 | £2,722 | £2,726 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £5,200 | £9,996 | £8,142 | £8,227 | £8,907 | £19,243 | £14,398 | £15,629 | £18,000 | £20,421 | £23,234 | £29,214 | £24,475 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £14,000 | £14,000 | £14,000 | £14,000 | £4,500 | £58,910 | £58,910 | £58,910 | £58,910 | £58,910 | £58,910 | £56,410 | £83,615 |
| Accumulated Depreciation | £0 | £23 | £47 | £70 | £93 | £1,417 | £2,741 | £4,065 | £5,389 | £6,713 | £8,037 | £9,361 | £10,685 |
| Total Long-term Assets | £14,000 | £13,977 | £13,953 | £13,930 | £4,407 | £57,493 | £56,169 | £54,845 | £53,521 | £52,197 | £50,873 | £47,049 | £72,930 |
| Total Assets | £19,200 | £23,973 | £22,095 | £22,157 | £13,314 | £76,736 | £70,567 | £70,474 | £71,521 | £72,618 | £74,107 | £76,263 | £97,405 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £5,156 | £4,777 | £5,217 | £5,502 | £10,772 | £5,063 | £4,886 | £5,440 | £5,405 | £5,504 | £6,003 | £4,820 |
| Current Borrowing | £12,000 | £12,000 | £12,000 | £12,000 | £4,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 |
| Other Current Liabilities | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Subtotal Current Liabilities | £15,500 | £20,656 | £20,277 | £20,717 | £13,002 | £39,272 | £33,563 | £33,386 | £33,940 | £33,905 | £34,004 | £34,503 | £33,320 |
| Long-term Liabilities | £26,500 | £26,500 | £26,500 | £26,500 | £26,500 | £70,029 | £68,835 | £67,641 | £66,447 | £65,253 | £64,059 | £62,865 | £83,435 |
| Total Liabilities | £42,000 | £47,156 | £46,777 | £47,217 | £39,502 | £109,301 | £102,398 | £101,027 | £100,387 | £99,158 | £98,063 | £97,368 | £116,755 |
| Paid-in Capital | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 |
| Retained Earnings | (£56,657) | (£22,900) | (£22,900) | (£22,900) | (£22,900) | (£22,900) | (£22,900) | (£22,900) | (£22,900) | (£22,900) | (£22,900) | (£22,900) | (£22,900) |
| Earnings | £33,757 | (£383) | (£1,882) | (£2,260) | (£3,388) | (£9,765) | (£9,031) | (£7,753) | (£6,066) | (£3,740) | (£1,156) | £1,696 | £3,450 |
| Total Capital | (£22,800) | (£23,183) | (£24,682) | (£25,060) | (£26,188) | (£32,565) | (£31,831) | (£30,553) | (£28,866) | (£26,540) | (£23,956) | (£21,104) | (£19,350) |
| Total Liabilities and Capital | £19,200 | £23,973 | £22,095 | £22,157 | £13,314 | £76,736 | £70,567 | £70,474 | £71,521 | £72,618 | £74,107 | £76,263 | £97,405 |
| Net Worth | (£22,800) | (£23,183) | (£24,682) | (£25,060) | (£26,188) | (£32,565) | (£31,831) | (£30,553) | (£28,866) | (£26,540) | (£23,956) | (£21,104) | (£19,350) |