| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Unit Sales | |||||||||||||
| Product Wrasse | 0% | 78 | 40 | 22 | 30 | 45 | 65 | 80 | 95 | 105 | 110 | 190 | 180 |
| Product Parrotfish | 0% | 78 | 40 | 22 | 30 | 45 | 65 | 80 | 95 | 105 | 110 | 190 | 180 |
| Product Damselfish | 0% | 78 | 40 | 22 | 30 | 45 | 65 | 80 | 95 | 105 | 110 | 190 | 180 |
| Other | 0% | 20 | 15 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 254 | 135 | 69 | 90 | 135 | 195 | 240 | 285 | 315 | 330 | 570 | 540 | |
| Unit Prices | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Product Wrasse | £412.00 | £412.00 | £412.00 | £412.00 | £412.00 | £412.00 | £412.00 | £412.00 | £412.00 | £412.00 | £412.00 | £412.00 | |
| Product Parrotfish | £610.00 | £610.00 | £610.00 | £610.00 | £610.00 | £610.00 | £610.00 | £610.00 | £610.00 | £610.00 | £610.00 | £610.00 | |
| Product Damselfish | £457.00 | £457.00 | £457.00 | £457.00 | £457.00 | £457.00 | £457.00 | £457.00 | £457.00 | £457.00 | £457.00 | £457.00 | |
| Other | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | |
| Sales | |||||||||||||
| Product Wrasse | £32,136 | £16,480 | £9,064 | £12,360 | £18,540 | £26,780 | £32,960 | £39,140 | £43,260 | £45,320 | £78,280 | £74,160 | |
| Product Parrotfish | £47,580 | £24,400 | £13,420 | £18,300 | £27,450 | £39,650 | £48,800 | £57,950 | £64,050 | £67,100 | £115,900 | £109,800 | |
| Product Damselfish | £35,646 | £18,280 | £10,054 | £13,710 | £20,565 | £29,705 | £36,560 | £43,415 | £47,985 | £50,270 | £86,830 | £82,260 | |
| Other | £39,900 | £29,925 | £5,985 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £155,262 | £89,085 | £38,523 | £44,370 | £66,555 | £96,135 | £118,320 | £140,505 | £155,295 | £162,690 | £281,010 | £266,220 | |
| Direct Unit Costs | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Product Wrasse | 0.00% | £165.85 | £165.85 | £165.85 | £165.85 | £165.85 | £165.85 | £165.85 | £165.85 | £165.85 | £165.85 | £165.85 | £165.85 |
| Product Parrotfish | 0.00% | £244.35 | £244.35 | £244.35 | £244.35 | £244.35 | £244.35 | £244.35 | £244.35 | £244.35 | £244.35 | £244.35 | £244.35 |
| Product Damselfish | 0.00% | £183.85 | £183.85 | £183.85 | £183.85 | £183.85 | £183.85 | £183.85 | £183.85 | £183.85 | £183.85 | £183.85 | £183.85 |
| Other | 0.00% | £630.00 | £630.00 | £630.00 | £630.00 | £630.00 | £630.00 | £630.00 | £630.00 | £630.00 | £630.00 | £630.00 | £630.00 |
| Direct Cost of Sales | |||||||||||||
| Product Wrasse | £12,936 | £6,634 | £3,649 | £4,976 | £7,463 | £10,780 | £13,268 | £15,756 | £17,414 | £18,244 | £31,512 | £29,853 | |
| Product Parrotfish | £19,059 | £9,774 | £5,376 | £7,331 | £10,996 | £15,883 | £19,548 | £23,213 | £25,657 | £26,879 | £46,427 | £43,983 | |
| Product Damselfish | £14,340 | £7,354 | £4,045 | £5,516 | £8,273 | £11,950 | £14,708 | £17,466 | £19,304 | £20,224 | £34,932 | £33,093 | |
| Other | £12,600 | £9,450 | £1,890 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £58,936 | £33,212 | £14,959 | £17,822 | £26,732 | £38,613 | £47,524 | £56,435 | £62,375 | £65,346 | £112,870 | £106,929 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| President | 0% | £0 | £8,450 | £16,901 | £8,333 | £8,333 | £8,333 | £8,333 | £8,333 | £8,333 | £8,333 | £8,333 | £8,333 |
| Sales Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Office Manager | 0% | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £2,000 | £2,500 | £2,500 | £2,500 | £3,000 | £3,000 | £3,000 |
| Salesperson (VAR's) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Salesperson (OEM's) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Technicians | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| In-house Software Engineer | 0% | £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 | £0 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £1,000 | £9,450 | £17,901 | £10,333 | £10,333 | £10,333 | £15,833 | £15,833 | £15,833 | £16,333 | £16,333 | £16,333 | |
| 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 | 43.50% | 43.50% | 43.50% | 43.50% | 43.50% | 43.50% | 43.50% | 43.50% | 43.50% | 43.50% | 43.50% | 43.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 | £155,262 | £89,085 | £38,523 | £44,370 | £66,555 | £96,135 | £118,320 | £140,505 | £155,295 | £162,690 | £281,010 | £266,220 | |
| Direct Cost of Sales | £58,936 | £33,212 | £14,959 | £17,822 | £26,732 | £38,613 | £47,524 | £56,435 | £62,375 | £65,346 | £112,870 | £106,929 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £58,936 | £33,212 | £14,959 | £17,822 | £26,732 | £38,613 | £47,524 | £56,435 | £62,375 | £65,346 | £112,870 | £106,929 | |
| Gross Margin | £96,326 | £55,873 | £23,564 | £26,549 | £39,823 | £57,522 | £70,796 | £84,070 | £92,920 | £97,345 | £168,141 | £159,291 | |
| Gross Margin % | 62.04% | 62.72% | 61.17% | 59.83% | 59.83% | 59.83% | 59.83% | 59.83% | 59.83% | 59.83% | 59.83% | 59.83% | |
| Expenses | |||||||||||||
| Payroll | £1,000 | £9,450 | £17,901 | £10,333 | £10,333 | £10,333 | £15,833 | £15,833 | £15,833 | £16,333 | £16,333 | £16,333 | |
| Sales and Marketing and Other Expenses | £5,380 | £1,340 | £4,991 | £4,988 | £5,087 | £20,221 | £5,320 | £15,420 | £15,487 | £15,520 | £16,053 | £15,986 | |
| Depreciation | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £87 | |
| Leased Equipment | £219 | £219 | £219 | £219 | £219 | £219 | £219 | £219 | £219 | £219 | £219 | £219 | |
| Healthcare | £856 | £856 | £856 | £856 | £856 | £856 | £856 | £856 | £856 | £856 | £856 | £856 | |
| On-line Services | £50 | £25 | £160 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | |
| Telephone | £151 | £361 | £202 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Utilities | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | |
| Rent | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Payroll Taxes | 9% | £90 | £851 | £1,611 | £930 | £930 | £930 | £1,425 | £1,425 | £1,425 | £1,470 | £1,470 | £1,470 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £9,049 | £14,405 | £27,243 | £18,989 | £19,088 | £34,222 | £25,316 | £35,416 | £35,483 | £36,061 | £36,594 | £36,531 | |
| Profit Before Interest and Taxes | £87,277 | £41,469 | (£3,679) | £7,560 | £20,735 | £23,300 | £45,480 | £48,654 | £57,437 | £61,284 | £131,547 | £122,760 | |
| EBITDA | £87,360 | £41,552 | (£3,596) | £7,643 | £20,818 | £23,383 | £45,563 | £48,737 | £57,520 | £61,367 | £131,630 | £122,847 | |
| Interest Expense | £724 | £1,141 | £224 | £100 | £183 | £350 | £517 | £642 | £642 | £642 | £642 | £1,225 | |
| Taxes Incurred | £37,651 | £17,543 | (£1,698) | £3,245 | £8,940 | £9,983 | £19,559 | £20,885 | £24,706 | £26,379 | £56,944 | £52,868 | |
| Net Profit | £48,903 | £22,785 | (£2,205) | £4,215 | £11,612 | £12,967 | £25,404 | £27,127 | £32,089 | £34,263 | £73,961 | £68,667 | |
| Net Profit/Sales | 31.50% | 25.58% | -5.72% | 9.50% | 17.45% | 13.49% | 21.47% | 19.31% | 20.66% | 21.06% | 26.32% | 25.79% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £38,816 | £22,271 | £9,631 | £11,093 | £16,639 | £24,034 | £29,580 | £35,126 | £38,824 | £40,673 | £70,253 | £66,555 | |
| Cash from Receivables | £11,180 | £15,061 | £114,792 | £65,550 | £29,038 | £33,832 | £50,656 | £72,656 | £89,295 | £105,749 | £116,656 | £124,976 | |
| Subtotal Cash from Operations | £49,995 | £37,332 | £124,423 | £76,642 | £45,677 | £57,866 | £80,236 | £107,782 | £128,118 | £146,421 | £186,909 | £191,531 | |
| 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 | £60,000 | £50,000 | £0 | £0 | £10,000 | £20,000 | £20,000 | £15,000 | £0 | £0 | £0 | £70,000 | |
| 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 | £109,995 | £87,332 | £124,423 | £76,642 | £55,677 | £77,866 | £100,236 | £122,782 | £128,118 | £146,421 | £186,909 | £261,531 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £1,000 | £9,450 | £17,901 | £10,333 | £10,333 | £10,333 | £15,833 | £15,833 | £15,833 | £16,333 | £16,333 | £16,333 | |
| Bill Payments | £18,132 | £69,253 | £27,781 | £8,451 | £28,654 | £55,379 | £85,854 | £87,484 | £107,482 | £113,873 | £119,533 | £240,632 | |
| Subtotal Spent on Operations | £19,132 | £78,703 | £45,682 | £18,784 | £38,987 | £65,712 | £101,687 | £103,317 | £123,315 | £130,206 | £135,866 | £256,965 | |
| 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 | £14,866 | £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 | £110,000 | £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 | £19,132 | £78,703 | £155,682 | £33,650 | £38,987 | £65,712 | £101,687 | £103,317 | £123,315 | £130,206 | £135,866 | £256,965 | |
| Net Cash Flow | £90,863 | £8,630 | (£31,259) | £42,992 | £16,690 | £12,154 | (£1,451) | £19,466 | £4,803 | £16,215 | £51,043 | £4,565 | |
| Cash Balance | £89,583 | £98,212 | £66,953 | £109,945 | £126,635 | £138,789 | £137,338 | £156,803 | £161,606 | £177,821 | £228,864 | £233,429 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | (£1,280) | £89,583 | £98,212 | £66,953 | £109,945 | £126,635 | £138,789 | £137,338 | £156,803 | £161,606 | £177,821 | £228,864 | £233,429 |
| Accounts Receivable | £22,359 | £127,626 | £179,379 | £93,479 | £61,207 | £82,085 | £120,354 | £158,438 | £191,161 | £218,337 | £234,606 | £328,708 | £403,397 |
| Inventory | £99,447 | £64,829 | £36,533 | £21,574 | £19,604 | £29,405 | £42,475 | £52,276 | £62,078 | £68,613 | £71,880 | £124,156 | £117,622 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £120,526 | £282,038 | £314,124 | £182,006 | £190,756 | £238,125 | £301,617 | £348,052 | £410,042 | £448,556 | £484,308 | £681,728 | £754,449 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 |
| Accumulated Depreciation | £13,478 | £13,561 | £13,644 | £13,727 | £13,810 | £13,893 | £13,976 | £14,059 | £14,142 | £14,225 | £14,308 | £14,391 | £14,478 |
| Total Long-term Assets | £4,826 | £4,743 | £4,660 | £4,577 | £4,494 | £4,411 | £4,328 | £4,245 | £4,162 | £4,079 | £3,996 | £3,913 | £3,826 |
| Total Assets | £125,352 | £286,781 | £318,784 | £186,583 | £195,250 | £242,536 | £305,945 | £352,297 | £414,204 | £452,635 | £488,304 | £685,641 | £758,275 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £15,777 | £68,304 | £27,521 | £7,526 | £26,843 | £52,518 | £82,961 | £83,908 | £103,688 | £110,030 | £111,436 | £234,812 | £168,778 |
| Current Borrowing | £14,866 | £14,866 | £14,866 | £14,866 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 |
| Subtotal Current Liabilities | £48,168 | £100,695 | £59,912 | £39,917 | £44,368 | £70,043 | £100,486 | £101,433 | £121,213 | £127,555 | £128,961 | £252,337 | £186,303 |
| Long-term Liabilities | £12,000 | £72,000 | £122,000 | £12,000 | £12,000 | £22,000 | £42,000 | £62,000 | £77,000 | £77,000 | £77,000 | £77,000 | £147,000 |
| Total Liabilities | £60,168 | £172,695 | £181,912 | £51,917 | £56,368 | £92,043 | £142,486 | £163,433 | £198,213 | £204,555 | £205,961 | £329,337 | £333,303 |
| Paid-in Capital | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 |
| Retained Earnings | (£16,341) | £62,274 | £62,274 | £62,274 | £62,274 | £62,274 | £62,274 | £62,274 | £62,274 | £62,274 | £62,274 | £62,274 | £62,274 |
| Earnings | £78,615 | £48,903 | £71,688 | £69,483 | £73,697 | £85,309 | £98,275 | £123,680 | £150,807 | £182,896 | £217,159 | £291,120 | £359,787 |
| Total Capital | £65,184 | £114,087 | £136,872 | £134,667 | £138,881 | £150,493 | £163,459 | £188,864 | £215,991 | £248,080 | £282,343 | £356,304 | £424,971 |
| Total Liabilities and Capital | £125,352 | £286,781 | £318,784 | £186,583 | £195,250 | £242,536 | £305,945 | £352,297 | £414,204 | £452,635 | £488,304 | £685,641 | £758,275 |
| Net Worth | £65,184 | £114,087 | £136,872 | £134,667 | £138,881 | £150,493 | £163,459 | £188,864 | £215,991 | £248,080 | £282,343 | £356,304 | £424,971 |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Unit Sales | |||||||||||||
| Product Wrasse | 0% | 78 | 40 | 22 | 30 | 45 | 65 | 80 | 95 | 105 | 110 | 190 | 180 |
| Product Parrotfish | 0% | 78 | 40 | 22 | 30 | 45 | 65 | 80 | 95 | 105 | 110 | 190 | 180 |
| Product Damselfish | 0% | 78 | 40 | 22 | 30 | 45 | 65 | 80 | 95 | 105 | 110 | 190 | 180 |
| Other | 0% | 20 | 15 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 254 | 135 | 69 | 90 | 135 | 195 | 240 | 285 | 315 | 330 | 570 | 540 | |
| Unit Prices | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Product Wrasse | £412.00 | £412.00 | £412.00 | £412.00 | £412.00 | £412.00 | £412.00 | £412.00 | £412.00 | £412.00 | £412.00 | £412.00 | |
| Product Parrotfish | £610.00 | £610.00 | £610.00 | £610.00 | £610.00 | £610.00 | £610.00 | £610.00 | £610.00 | £610.00 | £610.00 | £610.00 | |
| Product Damselfish | £457.00 | £457.00 | £457.00 | £457.00 | £457.00 | £457.00 | £457.00 | £457.00 | £457.00 | £457.00 | £457.00 | £457.00 | |
| Other | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | £1,995.00 | |
| Sales | |||||||||||||
| Product Wrasse | £32,136 | £16,480 | £9,064 | £12,360 | £18,540 | £26,780 | £32,960 | £39,140 | £43,260 | £45,320 | £78,280 | £74,160 | |
| Product Parrotfish | £47,580 | £24,400 | £13,420 | £18,300 | £27,450 | £39,650 | £48,800 | £57,950 | £64,050 | £67,100 | £115,900 | £109,800 | |
| Product Damselfish | £35,646 | £18,280 | £10,054 | £13,710 | £20,565 | £29,705 | £36,560 | £43,415 | £47,985 | £50,270 | £86,830 | £82,260 | |
| Other | £39,900 | £29,925 | £5,985 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £155,262 | £89,085 | £38,523 | £44,370 | £66,555 | £96,135 | £118,320 | £140,505 | £155,295 | £162,690 | £281,010 | £266,220 | |
| Direct Unit Costs | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Product Wrasse | 0.00% | £165.85 | £165.85 | £165.85 | £165.85 | £165.85 | £165.85 | £165.85 | £165.85 | £165.85 | £165.85 | £165.85 | £165.85 |
| Product Parrotfish | 0.00% | £244.35 | £244.35 | £244.35 | £244.35 | £244.35 | £244.35 | £244.35 | £244.35 | £244.35 | £244.35 | £244.35 | £244.35 |
| Product Damselfish | 0.00% | £183.85 | £183.85 | £183.85 | £183.85 | £183.85 | £183.85 | £183.85 | £183.85 | £183.85 | £183.85 | £183.85 | £183.85 |
| Other | 0.00% | £630.00 | £630.00 | £630.00 | £630.00 | £630.00 | £630.00 | £630.00 | £630.00 | £630.00 | £630.00 | £630.00 | £630.00 |
| Direct Cost of Sales | |||||||||||||
| Product Wrasse | £12,936 | £6,634 | £3,649 | £4,976 | £7,463 | £10,780 | £13,268 | £15,756 | £17,414 | £18,244 | £31,512 | £29,853 | |
| Product Parrotfish | £19,059 | £9,774 | £5,376 | £7,331 | £10,996 | £15,883 | £19,548 | £23,213 | £25,657 | £26,879 | £46,427 | £43,983 | |
| Product Damselfish | £14,340 | £7,354 | £4,045 | £5,516 | £8,273 | £11,950 | £14,708 | £17,466 | £19,304 | £20,224 | £34,932 | £33,093 | |
| Other | £12,600 | £9,450 | £1,890 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £58,936 | £33,212 | £14,959 | £17,822 | £26,732 | £38,613 | £47,524 | £56,435 | £62,375 | £65,346 | £112,870 | £106,929 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| President | 0% | £0 | £8,450 | £16,901 | £8,333 | £8,333 | £8,333 | £8,333 | £8,333 | £8,333 | £8,333 | £8,333 | £8,333 |
| Sales Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Office Manager | 0% | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £2,000 | £2,500 | £2,500 | £2,500 | £3,000 | £3,000 | £3,000 |
| Salesperson (VAR's) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Salesperson (OEM's) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Technicians | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| In-house Software Engineer | 0% | £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 | £0 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £1,000 | £9,450 | £17,901 | £10,333 | £10,333 | £10,333 | £15,833 | £15,833 | £15,833 | £16,333 | £16,333 | £16,333 | |
| 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 | 43.50% | 43.50% | 43.50% | 43.50% | 43.50% | 43.50% | 43.50% | 43.50% | 43.50% | 43.50% | 43.50% | 43.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 | £155,262 | £89,085 | £38,523 | £44,370 | £66,555 | £96,135 | £118,320 | £140,505 | £155,295 | £162,690 | £281,010 | £266,220 | |
| Direct Cost of Sales | £58,936 | £33,212 | £14,959 | £17,822 | £26,732 | £38,613 | £47,524 | £56,435 | £62,375 | £65,346 | £112,870 | £106,929 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £58,936 | £33,212 | £14,959 | £17,822 | £26,732 | £38,613 | £47,524 | £56,435 | £62,375 | £65,346 | £112,870 | £106,929 | |
| Gross Margin | £96,326 | £55,873 | £23,564 | £26,549 | £39,823 | £57,522 | £70,796 | £84,070 | £92,920 | £97,345 | £168,141 | £159,291 | |
| Gross Margin % | 62.04% | 62.72% | 61.17% | 59.83% | 59.83% | 59.83% | 59.83% | 59.83% | 59.83% | 59.83% | 59.83% | 59.83% | |
| Expenses | |||||||||||||
| Payroll | £1,000 | £9,450 | £17,901 | £10,333 | £10,333 | £10,333 | £15,833 | £15,833 | £15,833 | £16,333 | £16,333 | £16,333 | |
| Sales and Marketing and Other Expenses | £5,380 | £1,340 | £4,991 | £4,988 | £5,087 | £20,221 | £5,320 | £15,420 | £15,487 | £15,520 | £16,053 | £15,986 | |
| Depreciation | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £87 | |
| Leased Equipment | £219 | £219 | £219 | £219 | £219 | £219 | £219 | £219 | £219 | £219 | £219 | £219 | |
| Healthcare | £856 | £856 | £856 | £856 | £856 | £856 | £856 | £856 | £856 | £856 | £856 | £856 | |
| On-line Services | £50 | £25 | £160 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | |
| Telephone | £151 | £361 | £202 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Utilities | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | |
| Rent | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Payroll Taxes | 9% | £90 | £851 | £1,611 | £930 | £930 | £930 | £1,425 | £1,425 | £1,425 | £1,470 | £1,470 | £1,470 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £9,049 | £14,405 | £27,243 | £18,989 | £19,088 | £34,222 | £25,316 | £35,416 | £35,483 | £36,061 | £36,594 | £36,531 | |
| Profit Before Interest and Taxes | £87,277 | £41,469 | (£3,679) | £7,560 | £20,735 | £23,300 | £45,480 | £48,654 | £57,437 | £61,284 | £131,547 | £122,760 | |
| EBITDA | £87,360 | £41,552 | (£3,596) | £7,643 | £20,818 | £23,383 | £45,563 | £48,737 | £57,520 | £61,367 | £131,630 | £122,847 | |
| Interest Expense | £724 | £1,141 | £224 | £100 | £183 | £350 | £517 | £642 | £642 | £642 | £642 | £1,225 | |
| Taxes Incurred | £37,651 | £17,543 | (£1,698) | £3,245 | £8,940 | £9,983 | £19,559 | £20,885 | £24,706 | £26,379 | £56,944 | £52,868 | |
| Net Profit | £48,903 | £22,785 | (£2,205) | £4,215 | £11,612 | £12,967 | £25,404 | £27,127 | £32,089 | £34,263 | £73,961 | £68,667 | |
| Net Profit/Sales | 31.50% | 25.58% | -5.72% | 9.50% | 17.45% | 13.49% | 21.47% | 19.31% | 20.66% | 21.06% | 26.32% | 25.79% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £38,816 | £22,271 | £9,631 | £11,093 | £16,639 | £24,034 | £29,580 | £35,126 | £38,824 | £40,673 | £70,253 | £66,555 | |
| Cash from Receivables | £11,180 | £15,061 | £114,792 | £65,550 | £29,038 | £33,832 | £50,656 | £72,656 | £89,295 | £105,749 | £116,656 | £124,976 | |
| Subtotal Cash from Operations | £49,995 | £37,332 | £124,423 | £76,642 | £45,677 | £57,866 | £80,236 | £107,782 | £128,118 | £146,421 | £186,909 | £191,531 | |
| 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 | £60,000 | £50,000 | £0 | £0 | £10,000 | £20,000 | £20,000 | £15,000 | £0 | £0 | £0 | £70,000 | |
| 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 | £109,995 | £87,332 | £124,423 | £76,642 | £55,677 | £77,866 | £100,236 | £122,782 | £128,118 | £146,421 | £186,909 | £261,531 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £1,000 | £9,450 | £17,901 | £10,333 | £10,333 | £10,333 | £15,833 | £15,833 | £15,833 | £16,333 | £16,333 | £16,333 | |
| Bill Payments | £18,132 | £69,253 | £27,781 | £8,451 | £28,654 | £55,379 | £85,854 | £87,484 | £107,482 | £113,873 | £119,533 | £240,632 | |
| Subtotal Spent on Operations | £19,132 | £78,703 | £45,682 | £18,784 | £38,987 | £65,712 | £101,687 | £103,317 | £123,315 | £130,206 | £135,866 | £256,965 | |
| 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 | £14,866 | £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 | £110,000 | £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 | £19,132 | £78,703 | £155,682 | £33,650 | £38,987 | £65,712 | £101,687 | £103,317 | £123,315 | £130,206 | £135,866 | £256,965 | |
| Net Cash Flow | £90,863 | £8,630 | (£31,259) | £42,992 | £16,690 | £12,154 | (£1,451) | £19,466 | £4,803 | £16,215 | £51,043 | £4,565 | |
| Cash Balance | £89,583 | £98,212 | £66,953 | £109,945 | £126,635 | £138,789 | £137,338 | £156,803 | £161,606 | £177,821 | £228,864 | £233,429 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | (£1,280) | £89,583 | £98,212 | £66,953 | £109,945 | £126,635 | £138,789 | £137,338 | £156,803 | £161,606 | £177,821 | £228,864 | £233,429 |
| Accounts Receivable | £22,359 | £127,626 | £179,379 | £93,479 | £61,207 | £82,085 | £120,354 | £158,438 | £191,161 | £218,337 | £234,606 | £328,708 | £403,397 |
| Inventory | £99,447 | £64,829 | £36,533 | £21,574 | £19,604 | £29,405 | £42,475 | £52,276 | £62,078 | £68,613 | £71,880 | £124,156 | £117,622 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £120,526 | £282,038 | £314,124 | £182,006 | £190,756 | £238,125 | £301,617 | £348,052 | £410,042 | £448,556 | £484,308 | £681,728 | £754,449 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 | £18,304 |
| Accumulated Depreciation | £13,478 | £13,561 | £13,644 | £13,727 | £13,810 | £13,893 | £13,976 | £14,059 | £14,142 | £14,225 | £14,308 | £14,391 | £14,478 |
| Total Long-term Assets | £4,826 | £4,743 | £4,660 | £4,577 | £4,494 | £4,411 | £4,328 | £4,245 | £4,162 | £4,079 | £3,996 | £3,913 | £3,826 |
| Total Assets | £125,352 | £286,781 | £318,784 | £186,583 | £195,250 | £242,536 | £305,945 | £352,297 | £414,204 | £452,635 | £488,304 | £685,641 | £758,275 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £15,777 | £68,304 | £27,521 | £7,526 | £26,843 | £52,518 | £82,961 | £83,908 | £103,688 | £110,030 | £111,436 | £234,812 | £168,778 |
| Current Borrowing | £14,866 | £14,866 | £14,866 | £14,866 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 | £17,525 |
| Subtotal Current Liabilities | £48,168 | £100,695 | £59,912 | £39,917 | £44,368 | £70,043 | £100,486 | £101,433 | £121,213 | £127,555 | £128,961 | £252,337 | £186,303 |
| Long-term Liabilities | £12,000 | £72,000 | £122,000 | £12,000 | £12,000 | £22,000 | £42,000 | £62,000 | £77,000 | £77,000 | £77,000 | £77,000 | £147,000 |
| Total Liabilities | £60,168 | £172,695 | £181,912 | £51,917 | £56,368 | £92,043 | £142,486 | £163,433 | £198,213 | £204,555 | £205,961 | £329,337 | £333,303 |
| Paid-in Capital | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 | £2,910 |
| Retained Earnings | (£16,341) | £62,274 | £62,274 | £62,274 | £62,274 | £62,274 | £62,274 | £62,274 | £62,274 | £62,274 | £62,274 | £62,274 | £62,274 |
| Earnings | £78,615 | £48,903 | £71,688 | £69,483 | £73,697 | £85,309 | £98,275 | £123,680 | £150,807 | £182,896 | £217,159 | £291,120 | £359,787 |
| Total Capital | £65,184 | £114,087 | £136,872 | £134,667 | £138,881 | £150,493 | £163,459 | £188,864 | £215,991 | £248,080 | £282,343 | £356,304 | £424,971 |
| Total Liabilities and Capital | £125,352 | £286,781 | £318,784 | £186,583 | £195,250 | £242,536 | £305,945 | £352,297 | £414,204 | £452,635 | £488,304 | £685,641 | £758,275 |
| Net Worth | £65,184 | £114,087 | £136,872 | £134,667 | £138,881 | £150,493 | £163,459 | £188,864 | £215,991 | £248,080 | £282,343 | £356,304 | £424,971 |