| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Unit Sales | |||||||||||||
| Product X | 0% | 500 | 1,600 | 1,100 | 900 | 2,500 | 1,800 | 1,500 | 900 | 1,100 | 1,400 | 1,300 | 500 |
| Product Y | 0% | 325 | 365 | 325 | 295 | 315 | 285 | 285 | 235 | 145 | 145 | 145 | 111 |
| Product Z | 0% | 110 | 110 | 110 | 110 | 110 | 110 | 110 | 110 | 110 | 110 | 110 | 110 |
| Old Version Returns | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -450 | -300 | -150 | 0 | 0 |
| OEM & Customization | 0% | 3 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 3 | 0 | 0 |
| Other | 0% | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Total Unit Sales | 939 | 2,076 | 1,536 | 1,306 | 2,926 | 2,199 | 1,896 | 796 | 1,056 | 1,509 | 1,556 | 722 | |
| Unit Prices | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Product X | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | |
| Product Y | £45.00 | £45.00 | £45.00 | £45.00 | £45.00 | £45.00 | £45.00 | £45.00 | £45.00 | £45.00 | £45.00 | £45.00 | |
| Product Z | £325.00 | £325.00 | £325.00 | £325.00 | £325.00 | £325.00 | £325.00 | £325.00 | £325.00 | £325.00 | £325.00 | £325.00 | |
| Old Version Returns | £95.00 | £95.00 | £95.00 | £95.00 | £95.00 | £95.00 | £95.00 | £95.00 | £95.00 | £95.00 | £95.00 | £95.00 | |
| OEM & Customization | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | |
| Other | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | |
| Sales | |||||||||||||
| Product X | £17,500 | £56,000 | £38,500 | £31,500 | £87,500 | £63,000 | £52,500 | £31,500 | £38,500 | £49,000 | £45,500 | £17,500 | |
| Product Y | £14,625 | £16,425 | £14,625 | £13,275 | £14,175 | £12,825 | £12,825 | £10,575 | £6,525 | £6,525 | £6,525 | £4,995 | |
| Product Z | £35,750 | £35,750 | £35,750 | £35,750 | £35,750 | £35,750 | £35,750 | £35,750 | £35,750 | £35,750 | £35,750 | £35,750 | |
| Old Version Returns | £0 | £0 | £0 | £0 | £0 | £0 | £0 | (£42,750) | (£28,500) | (£14,250) | £0 | £0 | |
| OEM & Customization | £3,000 | £0 | £0 | £0 | £0 | £3,000 | £0 | £0 | £0 | £3,000 | £0 | £0 | |
| Other | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Total Sales | £72,375 | £109,675 | £90,375 | £82,025 | £138,925 | £116,075 | £102,575 | £36,575 | £53,775 | £81,525 | £89,275 | £59,745 | |
| Direct Unit Costs | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Product X | 0.00% | £7.82 | £7.82 | £7.82 | £7.82 | £7.82 | £7.82 | £7.82 | £7.82 | £7.82 | £7.82 | £7.82 | £7.82 |
| Product Y | 0.00% | £8.39 | £8.39 | £8.39 | £8.39 | £8.39 | £8.39 | £8.39 | £8.39 | £8.39 | £8.39 | £8.39 | £8.39 |
| Product Z | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Old Version Returns | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| OEM & Customization | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Other | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Product X | £3,910 | £12,512 | £8,602 | £7,038 | £19,550 | £14,076 | £11,730 | £7,038 | £8,602 | £10,948 | £10,166 | £3,910 | |
| Product Y | £2,727 | £3,062 | £2,727 | £2,475 | £2,643 | £2,391 | £2,391 | £1,972 | £1,217 | £1,217 | £1,217 | £931 | |
| Product Z | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Old Version Returns | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| OEM & Customization | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £6,637 | £15,574 | £11,329 | £9,513 | £22,193 | £16,467 | £14,121 | £9,010 | £9,819 | £12,165 | £11,383 | £4,841 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Production Personnel | |||||||||||||
| Technical Support Manager | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | |
| Technical Support Staff | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | |
| Sales and Marketing Personnel | |||||||||||||
| Marketing Manager | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| General and Administrative Personnel | |||||||||||||
| President | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Office Manager | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | |
| Other Personnel | |||||||||||||
| Development | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | |
| Pro Forma Profit and Loss | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £72,375 | £109,675 | £90,375 | £82,025 | £138,925 | £116,075 | £102,575 | £36,575 | £53,775 | £81,525 | £89,275 | £59,745 | |
| Direct Cost of Sales | £6,637 | £15,574 | £11,329 | £9,513 | £22,193 | £16,467 | £14,121 | £9,010 | £9,819 | £12,165 | £11,383 | £4,841 | |
| Production Payroll | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | |
| Freight | £1,201 | £2,056 | £1,651 | £1,479 | £2,694 | £2,146 | £1,921 | £1,434 | £1,516 | £1,741 | £1,666 | £1,041 | |
| Royalties | 10% | £7,238 | £10,968 | £9,038 | £8,203 | £13,893 | £11,608 | £10,258 | £3,658 | £5,378 | £8,153 | £8,928 | £5,975 |
| Total Cost of Sales | £17,851 | £31,373 | £24,793 | £21,970 | £41,555 | £32,996 | £29,075 | £16,877 | £19,488 | £24,834 | £24,752 | £14,632 | |
| Gross Margin | £54,524 | £78,302 | £65,582 | £60,055 | £97,370 | £83,079 | £73,500 | £19,698 | £34,287 | £56,691 | £64,523 | £45,113 | |
| Gross Margin % | 75.34% | 71.39% | 72.57% | 73.22% | 70.09% | 71.57% | 71.65% | 53.86% | 63.76% | 69.54% | 72.27% | 75.51% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Advertising/Promotion | £10,000 | £20,000 | £20,000 | £20,000 | £30,000 | £20,000 | £20,000 | £10,000 | £10,000 | £20,000 | £20,000 | £10,000 | |
| Sales Commissions | 6% | £4,343 | £6,581 | £5,423 | £4,922 | £8,336 | £6,965 | £6,155 | £2,195 | £3,227 | £4,892 | £5,357 | £3,585 |
| Graphics and Collaterals | £1,000 | £1,000 | £30,000 | £2,000 | £0 | £0 | £0 | £500 | £0 | £0 | £500 | £0 | |
| Printing | £2,200 | £500 | £500 | £18,000 | £5,000 | £0 | £0 | £500 | £500 | £500 | £500 | £500 | |
| Public Relations | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Research | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,000 | |
| Tollfree Telephone | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Trade Shows and Events | £2,000 | £0 | £0 | £0 | £2,000 | £0 | £0 | £0 | £0 | £2,000 | £0 | £0 | |
| Meals | £650 | £250 | £250 | £250 | £750 | £450 | £250 | £250 | £250 | £250 | £450 | £250 | |
| Travel | £2,000 | £400 | £400 | £400 | £2,000 | £1,000 | £500 | £500 | £1,700 | £1,700 | £500 | £1,700 | |
| Other Sales and Marketing Expenses | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Total Sales and Marketing Expenses | £28,893 | £35,431 | £63,273 | £52,272 | £54,786 | £35,115 | £33,605 | £20,645 | £22,377 | £36,042 | £34,007 | £24,735 | |
| Sales and Marketing % | 39.92% | 32.31% | 70.01% | 63.73% | 39.44% | 30.25% | 32.76% | 56.45% | 41.61% | 44.21% | 38.09% | 41.40% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | |
| Marketing/Promotion | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,000 | |
| Online Services | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Contributions | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | |
| Dues and Subscriptions | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Maintenance and Repairs | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Office Supplies | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Postage | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Professional Fees | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Telephone | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Rent | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | |
| Utilities | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Insurance | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Payroll Taxes | 10% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £11,225 | £11,225 | £11,225 | £11,225 | £11,225 | £11,225 | £11,225 | £11,225 | £11,225 | £11,225 | £11,225 | £12,225 | |
| General and Administrative % | 15.51% | 10.23% | 12.42% | 13.68% | 8.08% | 9.67% | 10.94% | 30.69% | 20.87% | 13.77% | 12.57% | 20.46% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Product Development | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Total Other Expenses | £2,625 | £2,625 | £2,625 | £2,625 | £2,625 | £2,625 | £2,625 | £2,625 | £2,625 | £2,625 | £2,625 | £2,625 | |
| Other % | 3.63% | 2.39% | 2.90% | 3.20% | 1.89% | 2.26% | 2.56% | 7.18% | 4.88% | 3.22% | 2.94% | 4.39% | |
| Total Operating Expenses | £42,743 | £49,281 | £77,123 | £66,122 | £68,636 | £48,965 | £47,455 | £34,495 | £36,227 | £49,892 | £47,857 | £39,585 | |
| Profit Before Interest and Taxes | £11,781 | £29,021 | (£11,541) | (£6,067) | £28,734 | £34,114 | £26,045 | (£14,797) | (£1,940) | £6,799 | £16,666 | £5,528 | |
| EBITDA | £11,781 | £29,021 | (£11,541) | (£6,067) | £28,734 | £34,114 | £26,045 | (£14,797) | (£1,940) | £6,799 | £16,666 | £6,528 | |
| Interest Expense | £186 | £186 | £186 | £186 | £186 | £353 | £353 | £19 | £19 | £19 | £19 | £19 | |
| Taxes Incurred | £3,479 | £8,650 | (£3,518) | (£1,876) | £8,564 | £10,128 | £7,708 | (£4,445) | (£588) | £2,034 | £4,994 | £1,652 | |
| Net Profit | £8,117 | £20,184 | (£8,209) | (£4,377) | £19,984 | £23,633 | £17,984 | (£10,371) | (£1,371) | £4,746 | £11,653 | £3,856 | |
| Net Profit/Sales | 11.21% | 18.40% | -9.08% | -5.34% | 14.38% | 20.36% | 17.53% | -28.36% | -2.55% | 5.82% | 13.05% | 6.45% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £28,950 | £43,870 | £36,150 | £32,810 | £55,570 | £46,430 | £41,030 | £14,630 | £21,510 | £32,610 | £35,710 | £23,898 | |
| Cash from Receivables | £62,028 | £63,476 | £44,171 | £65,419 | £54,058 | £50,353 | £82,898 | £69,375 | £60,225 | £22,289 | £32,820 | £49,070 | |
| Subtotal Cash from Operations | £90,978 | £107,346 | £80,321 | £98,229 | £109,628 | £96,783 | £123,928 | £84,005 | £81,735 | £54,899 | £68,530 | £72,968 | |
| 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 | £20,000 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £2,132 | £6,313 | £0 | £0 | £6,146 | £0 | £5,546 | £0 | £0 | £866 | £3,327 | £636 | |
| 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 | £93,110 | £113,659 | £80,321 | £98,229 | £115,774 | £116,783 | £129,474 | £84,005 | £81,735 | £55,765 | £71,857 | £73,604 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | |
| Bill Payments | £37,918 | £41,722 | £68,146 | £76,797 | £69,221 | £114,531 | £69,206 | £63,854 | £25,014 | £40,014 | £62,473 | £59,071 | |
| Subtotal Spent on Operations | £54,718 | £58,522 | £84,946 | £93,597 | £86,021 | £131,331 | £86,006 | £80,654 | £41,814 | £56,814 | £79,273 | £75,871 | |
| 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 | £40,000 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £20,000 | £0 | £0 | £0 | £0 | £4,453 | £10,000 | £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 | £54,718 | £58,522 | £104,946 | £93,597 | £86,021 | £131,331 | £86,006 | £125,107 | £51,814 | £56,814 | £79,273 | £75,871 | |
| Net Cash Flow | £38,392 | £55,136 | (£24,625) | £4,632 | £29,753 | (£14,548) | £43,468 | (£41,102) | £29,921 | (£1,049) | (£7,416) | (£2,267) | |
| Cash Balance | £39,017 | £94,154 | £69,529 | £74,161 | £103,914 | £89,366 | £132,834 | £91,732 | £121,653 | £120,605 | £113,189 | £110,921 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £625 | £39,017 | £94,154 | £69,529 | £74,161 | £103,914 | £89,366 | £132,834 | £91,732 | £121,653 | £120,605 | £113,189 | £110,921 |
| Accounts Receivable | £124,056 | £105,453 | £107,783 | £117,837 | £101,633 | £130,930 | £150,222 | £128,869 | £81,439 | £53,479 | £80,105 | £100,850 | £87,627 |
| Inventory | £28,623 | £21,986 | £17,132 | £12,462 | £10,464 | £24,412 | £18,114 | £15,533 | £9,911 | £10,800 | £13,381 | £12,521 | £7,680 |
| Other Current Assets | £431 | £431 | £431 | £431 | £431 | £431 | £431 | £431 | £431 | £431 | £431 | £431 | £431 |
| Total Current Assets | £153,735 | £166,888 | £219,499 | £200,258 | £186,689 | £259,687 | £258,133 | £277,667 | £183,512 | £186,363 | £214,521 | £226,990 | £206,658 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 |
| Accumulated Depreciation | £24,247 | £24,247 | £24,247 | £24,247 | £24,247 | £24,247 | £24,247 | £24,247 | £24,247 | £24,247 | £24,247 | £24,247 | £25,247 |
| Total Long-term Assets | £11,330 | £11,330 | £11,330 | £11,330 | £11,330 | £11,330 | £11,330 | £11,330 | £11,330 | £11,330 | £11,330 | £11,330 | £10,330 |
| Total Assets | £165,065 | £178,218 | £230,829 | £211,588 | £198,019 | £271,017 | £269,463 | £288,997 | £194,842 | £197,693 | £225,851 | £238,320 | £216,988 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £36,557 | £39,461 | £65,575 | £74,543 | £65,351 | £112,220 | £67,033 | £63,036 | £23,706 | £37,928 | £60,474 | £57,963 | £32,140 |
| Current Borrowing | £22,336 | £22,336 | £22,336 | £22,336 | £22,336 | £22,336 | £42,336 | £42,336 | £2,336 | £2,336 | £2,336 | £2,336 | £2,336 |
| Other Current Liabilities | £25,526 | £27,658 | £33,971 | £13,971 | £13,971 | £20,117 | £20,117 | £25,663 | £21,210 | £11,210 | £12,076 | £15,403 | £16,039 |
| Subtotal Current Liabilities | £84,419 | £89,455 | £121,882 | £110,850 | £101,658 | £154,673 | £129,486 | £131,035 | £47,252 | £51,474 | £74,886 | £75,702 | £50,515 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £84,419 | £89,455 | £121,882 | £110,850 | £101,658 | £154,673 | £129,486 | £131,035 | £47,252 | £51,474 | £74,886 | £75,702 | £50,515 |
| Paid-in Capital | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 |
| Retained Earnings | £36,668 | £3,686 | £3,686 | £3,686 | £3,686 | £3,686 | £3,686 | £3,686 | £3,686 | £3,686 | £3,686 | £3,686 | £3,686 |
| Earnings | (£32,982) | £8,117 | £28,301 | £20,092 | £15,715 | £35,698 | £59,331 | £77,315 | £66,944 | £65,573 | £70,319 | £81,972 | £85,828 |
| Total Capital | £80,646 | £88,763 | £108,947 | £100,738 | £96,361 | £116,344 | £139,977 | £157,961 | £147,590 | £146,219 | £150,965 | £162,618 | £166,474 |
| Total Liabilities and Capital | £165,065 | £178,218 | £230,829 | £211,588 | £198,019 | £271,017 | £269,463 | £288,997 | £194,842 | £197,693 | £225,851 | £238,320 | £216,988 |
| Net Worth | £80,646 | £88,763 | £108,947 | £100,738 | £96,361 | £116,344 | £139,977 | £157,961 | £147,590 | £146,219 | £150,965 | £162,618 | £166,474 |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Unit Sales | |||||||||||||
| Product X | 0% | 500 | 1,600 | 1,100 | 900 | 2,500 | 1,800 | 1,500 | 900 | 1,100 | 1,400 | 1,300 | 500 |
| Product Y | 0% | 325 | 365 | 325 | 295 | 315 | 285 | 285 | 235 | 145 | 145 | 145 | 111 |
| Product Z | 0% | 110 | 110 | 110 | 110 | 110 | 110 | 110 | 110 | 110 | 110 | 110 | 110 |
| Old Version Returns | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -450 | -300 | -150 | 0 | 0 |
| OEM & Customization | 0% | 3 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 3 | 0 | 0 |
| Other | 0% | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Total Unit Sales | 939 | 2,076 | 1,536 | 1,306 | 2,926 | 2,199 | 1,896 | 796 | 1,056 | 1,509 | 1,556 | 722 | |
| Unit Prices | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Product X | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | |
| Product Y | £45.00 | £45.00 | £45.00 | £45.00 | £45.00 | £45.00 | £45.00 | £45.00 | £45.00 | £45.00 | £45.00 | £45.00 | |
| Product Z | £325.00 | £325.00 | £325.00 | £325.00 | £325.00 | £325.00 | £325.00 | £325.00 | £325.00 | £325.00 | £325.00 | £325.00 | |
| Old Version Returns | £95.00 | £95.00 | £95.00 | £95.00 | £95.00 | £95.00 | £95.00 | £95.00 | £95.00 | £95.00 | £95.00 | £95.00 | |
| OEM & Customization | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | |
| Other | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | |
| Sales | |||||||||||||
| Product X | £17,500 | £56,000 | £38,500 | £31,500 | £87,500 | £63,000 | £52,500 | £31,500 | £38,500 | £49,000 | £45,500 | £17,500 | |
| Product Y | £14,625 | £16,425 | £14,625 | £13,275 | £14,175 | £12,825 | £12,825 | £10,575 | £6,525 | £6,525 | £6,525 | £4,995 | |
| Product Z | £35,750 | £35,750 | £35,750 | £35,750 | £35,750 | £35,750 | £35,750 | £35,750 | £35,750 | £35,750 | £35,750 | £35,750 | |
| Old Version Returns | £0 | £0 | £0 | £0 | £0 | £0 | £0 | (£42,750) | (£28,500) | (£14,250) | £0 | £0 | |
| OEM & Customization | £3,000 | £0 | £0 | £0 | £0 | £3,000 | £0 | £0 | £0 | £3,000 | £0 | £0 | |
| Other | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Total Sales | £72,375 | £109,675 | £90,375 | £82,025 | £138,925 | £116,075 | £102,575 | £36,575 | £53,775 | £81,525 | £89,275 | £59,745 | |
| Direct Unit Costs | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Product X | 0.00% | £7.82 | £7.82 | £7.82 | £7.82 | £7.82 | £7.82 | £7.82 | £7.82 | £7.82 | £7.82 | £7.82 | £7.82 |
| Product Y | 0.00% | £8.39 | £8.39 | £8.39 | £8.39 | £8.39 | £8.39 | £8.39 | £8.39 | £8.39 | £8.39 | £8.39 | £8.39 |
| Product Z | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Old Version Returns | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| OEM & Customization | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Other | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Product X | £3,910 | £12,512 | £8,602 | £7,038 | £19,550 | £14,076 | £11,730 | £7,038 | £8,602 | £10,948 | £10,166 | £3,910 | |
| Product Y | £2,727 | £3,062 | £2,727 | £2,475 | £2,643 | £2,391 | £2,391 | £1,972 | £1,217 | £1,217 | £1,217 | £931 | |
| Product Z | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Old Version Returns | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| OEM & Customization | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £6,637 | £15,574 | £11,329 | £9,513 | £22,193 | £16,467 | £14,121 | £9,010 | £9,819 | £12,165 | £11,383 | £4,841 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Production Personnel | |||||||||||||
| Technical Support Manager | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | |
| Technical Support Staff | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | |
| Sales and Marketing Personnel | |||||||||||||
| Marketing Manager | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| General and Administrative Personnel | |||||||||||||
| President | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Office Manager | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | |
| Other Personnel | |||||||||||||
| Development | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | |
| Pro Forma Profit and Loss | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £72,375 | £109,675 | £90,375 | £82,025 | £138,925 | £116,075 | £102,575 | £36,575 | £53,775 | £81,525 | £89,275 | £59,745 | |
| Direct Cost of Sales | £6,637 | £15,574 | £11,329 | £9,513 | £22,193 | £16,467 | £14,121 | £9,010 | £9,819 | £12,165 | £11,383 | £4,841 | |
| Production Payroll | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | £2,775 | |
| Freight | £1,201 | £2,056 | £1,651 | £1,479 | £2,694 | £2,146 | £1,921 | £1,434 | £1,516 | £1,741 | £1,666 | £1,041 | |
| Royalties | 10% | £7,238 | £10,968 | £9,038 | £8,203 | £13,893 | £11,608 | £10,258 | £3,658 | £5,378 | £8,153 | £8,928 | £5,975 |
| Total Cost of Sales | £17,851 | £31,373 | £24,793 | £21,970 | £41,555 | £32,996 | £29,075 | £16,877 | £19,488 | £24,834 | £24,752 | £14,632 | |
| Gross Margin | £54,524 | £78,302 | £65,582 | £60,055 | £97,370 | £83,079 | £73,500 | £19,698 | £34,287 | £56,691 | £64,523 | £45,113 | |
| Gross Margin % | 75.34% | 71.39% | 72.57% | 73.22% | 70.09% | 71.57% | 71.65% | 53.86% | 63.76% | 69.54% | 72.27% | 75.51% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Advertising/Promotion | £10,000 | £20,000 | £20,000 | £20,000 | £30,000 | £20,000 | £20,000 | £10,000 | £10,000 | £20,000 | £20,000 | £10,000 | |
| Sales Commissions | 6% | £4,343 | £6,581 | £5,423 | £4,922 | £8,336 | £6,965 | £6,155 | £2,195 | £3,227 | £4,892 | £5,357 | £3,585 |
| Graphics and Collaterals | £1,000 | £1,000 | £30,000 | £2,000 | £0 | £0 | £0 | £500 | £0 | £0 | £500 | £0 | |
| Printing | £2,200 | £500 | £500 | £18,000 | £5,000 | £0 | £0 | £500 | £500 | £500 | £500 | £500 | |
| Public Relations | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Research | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,000 | |
| Tollfree Telephone | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Trade Shows and Events | £2,000 | £0 | £0 | £0 | £2,000 | £0 | £0 | £0 | £0 | £2,000 | £0 | £0 | |
| Meals | £650 | £250 | £250 | £250 | £750 | £450 | £250 | £250 | £250 | £250 | £450 | £250 | |
| Travel | £2,000 | £400 | £400 | £400 | £2,000 | £1,000 | £500 | £500 | £1,700 | £1,700 | £500 | £1,700 | |
| Other Sales and Marketing Expenses | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Total Sales and Marketing Expenses | £28,893 | £35,431 | £63,273 | £52,272 | £54,786 | £35,115 | £33,605 | £20,645 | £22,377 | £36,042 | £34,007 | £24,735 | |
| Sales and Marketing % | 39.92% | 32.31% | 70.01% | 63.73% | 39.44% | 30.25% | 32.76% | 56.45% | 41.61% | 44.21% | 38.09% | 41.40% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | |
| Marketing/Promotion | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,000 | |
| Online Services | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Contributions | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | |
| Dues and Subscriptions | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Maintenance and Repairs | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Office Supplies | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Postage | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Professional Fees | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Telephone | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Rent | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | |
| Utilities | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Insurance | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Payroll Taxes | 10% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £11,225 | £11,225 | £11,225 | £11,225 | £11,225 | £11,225 | £11,225 | £11,225 | £11,225 | £11,225 | £11,225 | £12,225 | |
| General and Administrative % | 15.51% | 10.23% | 12.42% | 13.68% | 8.08% | 9.67% | 10.94% | 30.69% | 20.87% | 13.77% | 12.57% | 20.46% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | £2,525 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Product Development | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Total Other Expenses | £2,625 | £2,625 | £2,625 | £2,625 | £2,625 | £2,625 | £2,625 | £2,625 | £2,625 | £2,625 | £2,625 | £2,625 | |
| Other % | 3.63% | 2.39% | 2.90% | 3.20% | 1.89% | 2.26% | 2.56% | 7.18% | 4.88% | 3.22% | 2.94% | 4.39% | |
| Total Operating Expenses | £42,743 | £49,281 | £77,123 | £66,122 | £68,636 | £48,965 | £47,455 | £34,495 | £36,227 | £49,892 | £47,857 | £39,585 | |
| Profit Before Interest and Taxes | £11,781 | £29,021 | (£11,541) | (£6,067) | £28,734 | £34,114 | £26,045 | (£14,797) | (£1,940) | £6,799 | £16,666 | £5,528 | |
| EBITDA | £11,781 | £29,021 | (£11,541) | (£6,067) | £28,734 | £34,114 | £26,045 | (£14,797) | (£1,940) | £6,799 | £16,666 | £6,528 | |
| Interest Expense | £186 | £186 | £186 | £186 | £186 | £353 | £353 | £19 | £19 | £19 | £19 | £19 | |
| Taxes Incurred | £3,479 | £8,650 | (£3,518) | (£1,876) | £8,564 | £10,128 | £7,708 | (£4,445) | (£588) | £2,034 | £4,994 | £1,652 | |
| Net Profit | £8,117 | £20,184 | (£8,209) | (£4,377) | £19,984 | £23,633 | £17,984 | (£10,371) | (£1,371) | £4,746 | £11,653 | £3,856 | |
| Net Profit/Sales | 11.21% | 18.40% | -9.08% | -5.34% | 14.38% | 20.36% | 17.53% | -28.36% | -2.55% | 5.82% | 13.05% | 6.45% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £28,950 | £43,870 | £36,150 | £32,810 | £55,570 | £46,430 | £41,030 | £14,630 | £21,510 | £32,610 | £35,710 | £23,898 | |
| Cash from Receivables | £62,028 | £63,476 | £44,171 | £65,419 | £54,058 | £50,353 | £82,898 | £69,375 | £60,225 | £22,289 | £32,820 | £49,070 | |
| Subtotal Cash from Operations | £90,978 | £107,346 | £80,321 | £98,229 | £109,628 | £96,783 | £123,928 | £84,005 | £81,735 | £54,899 | £68,530 | £72,968 | |
| 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 | £20,000 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £2,132 | £6,313 | £0 | £0 | £6,146 | £0 | £5,546 | £0 | £0 | £866 | £3,327 | £636 | |
| 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 | £93,110 | £113,659 | £80,321 | £98,229 | £115,774 | £116,783 | £129,474 | £84,005 | £81,735 | £55,765 | £71,857 | £73,604 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | |
| Bill Payments | £37,918 | £41,722 | £68,146 | £76,797 | £69,221 | £114,531 | £69,206 | £63,854 | £25,014 | £40,014 | £62,473 | £59,071 | |
| Subtotal Spent on Operations | £54,718 | £58,522 | £84,946 | £93,597 | £86,021 | £131,331 | £86,006 | £80,654 | £41,814 | £56,814 | £79,273 | £75,871 | |
| 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 | £40,000 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £20,000 | £0 | £0 | £0 | £0 | £4,453 | £10,000 | £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 | £54,718 | £58,522 | £104,946 | £93,597 | £86,021 | £131,331 | £86,006 | £125,107 | £51,814 | £56,814 | £79,273 | £75,871 | |
| Net Cash Flow | £38,392 | £55,136 | (£24,625) | £4,632 | £29,753 | (£14,548) | £43,468 | (£41,102) | £29,921 | (£1,049) | (£7,416) | (£2,267) | |
| Cash Balance | £39,017 | £94,154 | £69,529 | £74,161 | £103,914 | £89,366 | £132,834 | £91,732 | £121,653 | £120,605 | £113,189 | £110,921 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £625 | £39,017 | £94,154 | £69,529 | £74,161 | £103,914 | £89,366 | £132,834 | £91,732 | £121,653 | £120,605 | £113,189 | £110,921 |
| Accounts Receivable | £124,056 | £105,453 | £107,783 | £117,837 | £101,633 | £130,930 | £150,222 | £128,869 | £81,439 | £53,479 | £80,105 | £100,850 | £87,627 |
| Inventory | £28,623 | £21,986 | £17,132 | £12,462 | £10,464 | £24,412 | £18,114 | £15,533 | £9,911 | £10,800 | £13,381 | £12,521 | £7,680 |
| Other Current Assets | £431 | £431 | £431 | £431 | £431 | £431 | £431 | £431 | £431 | £431 | £431 | £431 | £431 |
| Total Current Assets | £153,735 | £166,888 | £219,499 | £200,258 | £186,689 | £259,687 | £258,133 | £277,667 | £183,512 | £186,363 | £214,521 | £226,990 | £206,658 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 | £35,577 |
| Accumulated Depreciation | £24,247 | £24,247 | £24,247 | £24,247 | £24,247 | £24,247 | £24,247 | £24,247 | £24,247 | £24,247 | £24,247 | £24,247 | £25,247 |
| Total Long-term Assets | £11,330 | £11,330 | £11,330 | £11,330 | £11,330 | £11,330 | £11,330 | £11,330 | £11,330 | £11,330 | £11,330 | £11,330 | £10,330 |
| Total Assets | £165,065 | £178,218 | £230,829 | £211,588 | £198,019 | £271,017 | £269,463 | £288,997 | £194,842 | £197,693 | £225,851 | £238,320 | £216,988 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £36,557 | £39,461 | £65,575 | £74,543 | £65,351 | £112,220 | £67,033 | £63,036 | £23,706 | £37,928 | £60,474 | £57,963 | £32,140 |
| Current Borrowing | £22,336 | £22,336 | £22,336 | £22,336 | £22,336 | £22,336 | £42,336 | £42,336 | £2,336 | £2,336 | £2,336 | £2,336 | £2,336 |
| Other Current Liabilities | £25,526 | £27,658 | £33,971 | £13,971 | £13,971 | £20,117 | £20,117 | £25,663 | £21,210 | £11,210 | £12,076 | £15,403 | £16,039 |
| Subtotal Current Liabilities | £84,419 | £89,455 | £121,882 | £110,850 | £101,658 | £154,673 | £129,486 | £131,035 | £47,252 | £51,474 | £74,886 | £75,702 | £50,515 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £84,419 | £89,455 | £121,882 | £110,850 | £101,658 | £154,673 | £129,486 | £131,035 | £47,252 | £51,474 | £74,886 | £75,702 | £50,515 |
| Paid-in Capital | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 | £76,960 |
| Retained Earnings | £36,668 | £3,686 | £3,686 | £3,686 | £3,686 | £3,686 | £3,686 | £3,686 | £3,686 | £3,686 | £3,686 | £3,686 | £3,686 |
| Earnings | (£32,982) | £8,117 | £28,301 | £20,092 | £15,715 | £35,698 | £59,331 | £77,315 | £66,944 | £65,573 | £70,319 | £81,972 | £85,828 |
| Total Capital | £80,646 | £88,763 | £108,947 | £100,738 | £96,361 | £116,344 | £139,977 | £157,961 | £147,590 | £146,219 | £150,965 | £162,618 | £166,474 |
| Total Liabilities and Capital | £165,065 | £178,218 | £230,829 | £211,588 | £198,019 | £271,017 | £269,463 | £288,997 | £194,842 | £197,693 | £225,851 | £238,320 | £216,988 |
| Net Worth | £80,646 | £88,763 | £108,947 | £100,738 | £96,361 | £116,344 | £139,977 | £157,961 | £147,590 | £146,219 | £150,965 | £162,618 | £166,474 |