| Sales Forecast | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | |||||||||||||
| Scoops | 0% | £0 | £0 | £0 | £0 | £30,975 | £32,450 | £33,925 | £36,875 | £38,350 | £39,825 | £42,775 | £44,250 |
| Bags | 0% | £0 | £0 | £0 | £0 | £7,088 | £7,425 | £7,763 | £8,438 | £15,863 | £16,538 | £17,550 | £18,563 |
| Total Sales | £0 | £0 | £0 | £0 | £38,063 | £39,875 | £41,688 | £45,313 | £54,213 | £56,363 | £60,325 | £62,813 | |
| Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Scoops | £0 | £0 | £0 | £0 | £12,600 | £13,200 | £13,800 | £15,000 | £15,600 | £16,200 | £17,400 | £18,000 | |
| Bags | £0 | £0 | £0 | £0 | £3,150 | £3,300 | £3,450 | £3,750 | £7,050 | £7,350 | £7,800 | £8,250 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £15,750 | £16,500 | £17,250 | £18,750 | £22,650 | £23,550 | £25,200 | £26,250 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| General Manager | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Sales Manager | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Marketing Assistant | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Marketing Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Operations Assistant | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Operations Manager | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Total People | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £0 | £0 | £0 | £0 | £38,063 | £39,875 | £41,688 | £45,313 | £54,213 | £56,363 | £60,325 | £62,813 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £15,750 | £16,500 | £17,250 | £18,750 | £22,650 | £23,550 | £25,200 | £26,250 | |
| Shipping and Handling - scoops | £0 | £0 | £0 | £2,361 | £464 | £382 | £297 | £2,815 | £676 | £574 | £471 | £357 | |
| Shipping and Handling - bags | £0 | £0 | £0 | £1,594 | £318 | £262 | £203 | £2,576 | £947 | £822 | £692 | £555 | |
| Total Cost of Sales | £0 | £0 | £0 | £3,955 | £16,532 | £17,145 | £17,750 | £24,141 | £24,273 | £24,946 | £26,364 | £27,162 | |
| Gross Margin | £0 | £0 | £0 | (£3,955) | £21,530 | £22,730 | £23,937 | £21,171 | £29,939 | £31,417 | £33,961 | £35,650 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 56.57% | 57.00% | 57.42% | 46.72% | 55.23% | 55.74% | 56.30% | 56.76% | |
| Expenses | |||||||||||||
| Payroll | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £5,709 | £5,981 | £6,253 | £6,797 | £8,132 | £8,454 | £9,049 | £9,422 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Utilities | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance - liability | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Payroll Taxes | 15% | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £7,275 | £7,275 | £7,275 | £7,275 | £12,984 | £13,256 | £13,528 | £14,072 | £15,407 | £15,729 | £16,324 | £16,697 | |
| Profit Before Interest and Taxes | (£7,275) | (£7,275) | (£7,275) | (£11,230) | £8,546 | £9,474 | £10,409 | £7,099 | £14,532 | £15,687 | £17,638 | £18,954 | |
| EBITDA | (£7,275) | (£7,275) | (£7,275) | (£11,230) | £8,546 | £9,474 | £10,409 | £7,099 | £14,532 | £15,687 | £17,638 | £18,954 | |
| Interest Expense | £425 | £418 | £411 | £404 | £397 | £390 | £383 | £376 | £369 | £362 | £355 | £348 | |
| Taxes Incurred | (£2,310) | (£2,308) | (£2,306) | (£3,490) | £2,445 | £2,725 | £3,008 | £2,017 | £4,249 | £4,598 | £5,185 | £5,582 | |
| Net Profit | (£5,390) | (£5,385) | (£5,380) | (£8,144) | £5,704 | £6,359 | £7,018 | £4,706 | £9,914 | £10,728 | £12,098 | £13,024 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 14.99% | 15.95% | 16.84% | 10.39% | 18.29% | 19.03% | 20.05% | 20.73% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £0 | £0 | £0 | £0 | £9,516 | £9,969 | £10,422 | £11,328 | £13,553 | £14,091 | £15,081 | £15,703 | |
| Cash from Receivables | £0 | £0 | £0 | £0 | £0 | £952 | £28,592 | £29,952 | £31,356 | £34,207 | £40,713 | £42,371 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £9,516 | £10,920 | £39,014 | £41,280 | £44,909 | £48,298 | £55,794 | £58,074 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £0 | £0 | £0 | £9,516 | £10,920 | £39,014 | £41,280 | £44,909 | £48,298 | £55,794 | £58,074 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | |
| Bill Payments | (£110) | (£174) | (£232) | (£118) | £1,354 | £24,798 | £36,001 | £29,456 | £33,601 | £40,133 | £42,041 | £42,947 | |
| Subtotal Spent on Operations | £5,390 | £5,326 | £5,268 | £5,382 | £6,854 | £30,298 | £41,501 | £34,956 | £39,101 | £45,633 | £47,541 | £48,447 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | |
| 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 | £5,390 | £6,726 | £6,668 | £6,782 | £8,254 | £31,698 | £42,901 | £36,356 | £40,501 | £47,033 | £48,941 | £49,847 | |
| Net Cash Flow | (£5,390) | (£6,726) | (£6,668) | (£6,782) | £1,261 | (£20,778) | (£3,887) | £4,924 | £4,409 | £1,264 | £6,853 | £8,227 | |
| Cash Balance | £94,610 | £87,884 | £81,216 | £74,433 | £75,695 | £54,917 | £51,030 | £55,954 | £60,363 | £61,627 | £68,480 | £76,707 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £100,000 | £94,610 | £87,884 | £81,216 | £74,433 | £75,695 | £54,917 | £51,030 | £55,954 | £60,363 | £61,627 | £68,480 | £76,707 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £0 | £28,547 | £57,502 | £60,175 | £64,208 | £73,511 | £81,576 | £86,107 | £90,845 |
| Inventory | £0 | £0 | £0 | £0 | £0 | £17,325 | £18,150 | £18,975 | £20,625 | £24,915 | £25,905 | £27,720 | £28,875 |
| Other Current Assets | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Total Current Assets | £115,000 | £109,610 | £102,884 | £96,216 | £89,433 | £136,567 | £145,569 | £145,180 | £155,787 | £173,789 | £184,108 | £197,307 | £211,427 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £115,000 | £109,610 | £102,884 | £96,216 | £89,433 | £136,567 | £145,569 | £145,180 | £155,787 | £173,789 | £184,108 | £197,307 | £211,427 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £0 | £59 | £171 | £2,933 | £45,762 | £49,805 | £43,798 | £51,098 | £60,586 | £61,577 | £64,078 | £66,575 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £0 | £59 | £171 | £2,933 | £45,762 | £49,805 | £43,798 | £51,098 | £60,586 | £61,577 | £64,078 | £66,575 |
| Long-term Liabilities | £85,000 | £85,000 | £83,600 | £82,200 | £80,800 | £79,400 | £78,000 | £76,600 | £75,200 | £73,800 | £72,400 | £71,000 | £69,600 |
| Total Liabilities | £85,000 | £85,000 | £83,659 | £82,371 | £83,733 | £125,162 | £127,805 | £120,398 | £126,298 | £134,386 | £133,977 | £135,078 | £136,175 |
| Paid-in Capital | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Retained Earnings | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) |
| Earnings | £0 | (£5,390) | (£10,775) | (£16,155) | (£24,299) | (£18,595) | (£12,236) | (£5,218) | (£512) | £9,403 | £20,130 | £32,228 | £45,252 |
| Total Capital | £30,000 | £24,610 | £19,225 | £13,845 | £5,701 | £11,405 | £17,764 | £24,782 | £29,488 | £39,403 | £50,130 | £62,228 | £75,252 |
| Total Liabilities and Capital | £115,000 | £109,610 | £102,884 | £96,216 | £89,433 | £136,567 | £145,569 | £145,180 | £155,787 | £173,789 | £184,108 | £197,307 | £211,427 |
| Net Worth | £30,000 | £24,610 | £19,225 | £13,845 | £5,701 | £11,405 | £17,764 | £24,782 | £29,488 | £39,403 | £50,130 | £62,228 | £75,252 |
| Sales Forecast | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | |||||||||||||
| Scoops | 0% | £0 | £0 | £0 | £0 | £30,975 | £32,450 | £33,925 | £36,875 | £38,350 | £39,825 | £42,775 | £44,250 |
| Bags | 0% | £0 | £0 | £0 | £0 | £7,088 | £7,425 | £7,763 | £8,438 | £15,863 | £16,538 | £17,550 | £18,563 |
| Total Sales | £0 | £0 | £0 | £0 | £38,063 | £39,875 | £41,688 | £45,313 | £54,213 | £56,363 | £60,325 | £62,813 | |
| Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Scoops | £0 | £0 | £0 | £0 | £12,600 | £13,200 | £13,800 | £15,000 | £15,600 | £16,200 | £17,400 | £18,000 | |
| Bags | £0 | £0 | £0 | £0 | £3,150 | £3,300 | £3,450 | £3,750 | £7,050 | £7,350 | £7,800 | £8,250 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £15,750 | £16,500 | £17,250 | £18,750 | £22,650 | £23,550 | £25,200 | £26,250 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| General Manager | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Sales Manager | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Marketing Assistant | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Marketing Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Operations Assistant | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Operations Manager | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Total People | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £0 | £0 | £0 | £0 | £38,063 | £39,875 | £41,688 | £45,313 | £54,213 | £56,363 | £60,325 | £62,813 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £15,750 | £16,500 | £17,250 | £18,750 | £22,650 | £23,550 | £25,200 | £26,250 | |
| Shipping and Handling - scoops | £0 | £0 | £0 | £2,361 | £464 | £382 | £297 | £2,815 | £676 | £574 | £471 | £357 | |
| Shipping and Handling - bags | £0 | £0 | £0 | £1,594 | £318 | £262 | £203 | £2,576 | £947 | £822 | £692 | £555 | |
| Total Cost of Sales | £0 | £0 | £0 | £3,955 | £16,532 | £17,145 | £17,750 | £24,141 | £24,273 | £24,946 | £26,364 | £27,162 | |
| Gross Margin | £0 | £0 | £0 | (£3,955) | £21,530 | £22,730 | £23,937 | £21,171 | £29,939 | £31,417 | £33,961 | £35,650 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 56.57% | 57.00% | 57.42% | 46.72% | 55.23% | 55.74% | 56.30% | 56.76% | |
| Expenses | |||||||||||||
| Payroll | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £5,709 | £5,981 | £6,253 | £6,797 | £8,132 | £8,454 | £9,049 | £9,422 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Utilities | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance - liability | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Payroll Taxes | 15% | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £7,275 | £7,275 | £7,275 | £7,275 | £12,984 | £13,256 | £13,528 | £14,072 | £15,407 | £15,729 | £16,324 | £16,697 | |
| Profit Before Interest and Taxes | (£7,275) | (£7,275) | (£7,275) | (£11,230) | £8,546 | £9,474 | £10,409 | £7,099 | £14,532 | £15,687 | £17,638 | £18,954 | |
| EBITDA | (£7,275) | (£7,275) | (£7,275) | (£11,230) | £8,546 | £9,474 | £10,409 | £7,099 | £14,532 | £15,687 | £17,638 | £18,954 | |
| Interest Expense | £425 | £418 | £411 | £404 | £397 | £390 | £383 | £376 | £369 | £362 | £355 | £348 | |
| Taxes Incurred | (£2,310) | (£2,308) | (£2,306) | (£3,490) | £2,445 | £2,725 | £3,008 | £2,017 | £4,249 | £4,598 | £5,185 | £5,582 | |
| Net Profit | (£5,390) | (£5,385) | (£5,380) | (£8,144) | £5,704 | £6,359 | £7,018 | £4,706 | £9,914 | £10,728 | £12,098 | £13,024 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 14.99% | 15.95% | 16.84% | 10.39% | 18.29% | 19.03% | 20.05% | 20.73% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £0 | £0 | £0 | £0 | £9,516 | £9,969 | £10,422 | £11,328 | £13,553 | £14,091 | £15,081 | £15,703 | |
| Cash from Receivables | £0 | £0 | £0 | £0 | £0 | £952 | £28,592 | £29,952 | £31,356 | £34,207 | £40,713 | £42,371 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £9,516 | £10,920 | £39,014 | £41,280 | £44,909 | £48,298 | £55,794 | £58,074 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £0 | £0 | £0 | £9,516 | £10,920 | £39,014 | £41,280 | £44,909 | £48,298 | £55,794 | £58,074 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | |
| Bill Payments | (£110) | (£174) | (£232) | (£118) | £1,354 | £24,798 | £36,001 | £29,456 | £33,601 | £40,133 | £42,041 | £42,947 | |
| Subtotal Spent on Operations | £5,390 | £5,326 | £5,268 | £5,382 | £6,854 | £30,298 | £41,501 | £34,956 | £39,101 | £45,633 | £47,541 | £48,447 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | |
| 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 | £5,390 | £6,726 | £6,668 | £6,782 | £8,254 | £31,698 | £42,901 | £36,356 | £40,501 | £47,033 | £48,941 | £49,847 | |
| Net Cash Flow | (£5,390) | (£6,726) | (£6,668) | (£6,782) | £1,261 | (£20,778) | (£3,887) | £4,924 | £4,409 | £1,264 | £6,853 | £8,227 | |
| Cash Balance | £94,610 | £87,884 | £81,216 | £74,433 | £75,695 | £54,917 | £51,030 | £55,954 | £60,363 | £61,627 | £68,480 | £76,707 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £100,000 | £94,610 | £87,884 | £81,216 | £74,433 | £75,695 | £54,917 | £51,030 | £55,954 | £60,363 | £61,627 | £68,480 | £76,707 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £0 | £28,547 | £57,502 | £60,175 | £64,208 | £73,511 | £81,576 | £86,107 | £90,845 |
| Inventory | £0 | £0 | £0 | £0 | £0 | £17,325 | £18,150 | £18,975 | £20,625 | £24,915 | £25,905 | £27,720 | £28,875 |
| Other Current Assets | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Total Current Assets | £115,000 | £109,610 | £102,884 | £96,216 | £89,433 | £136,567 | £145,569 | £145,180 | £155,787 | £173,789 | £184,108 | £197,307 | £211,427 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £115,000 | £109,610 | £102,884 | £96,216 | £89,433 | £136,567 | £145,569 | £145,180 | £155,787 | £173,789 | £184,108 | £197,307 | £211,427 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £0 | £59 | £171 | £2,933 | £45,762 | £49,805 | £43,798 | £51,098 | £60,586 | £61,577 | £64,078 | £66,575 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £0 | £59 | £171 | £2,933 | £45,762 | £49,805 | £43,798 | £51,098 | £60,586 | £61,577 | £64,078 | £66,575 |
| Long-term Liabilities | £85,000 | £85,000 | £83,600 | £82,200 | £80,800 | £79,400 | £78,000 | £76,600 | £75,200 | £73,800 | £72,400 | £71,000 | £69,600 |
| Total Liabilities | £85,000 | £85,000 | £83,659 | £82,371 | £83,733 | £125,162 | £127,805 | £120,398 | £126,298 | £134,386 | £133,977 | £135,078 | £136,175 |
| Paid-in Capital | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Retained Earnings | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) |
| Earnings | £0 | (£5,390) | (£10,775) | (£16,155) | (£24,299) | (£18,595) | (£12,236) | (£5,218) | (£512) | £9,403 | £20,130 | £32,228 | £45,252 |
| Total Capital | £30,000 | £24,610 | £19,225 | £13,845 | £5,701 | £11,405 | £17,764 | £24,782 | £29,488 | £39,403 | £50,130 | £62,228 | £75,252 |
| Total Liabilities and Capital | £115,000 | £109,610 | £102,884 | £96,216 | £89,433 | £136,567 | £145,569 | £145,180 | £155,787 | £173,789 | £184,108 | £197,307 | £211,427 |
| Net Worth | £30,000 | £24,610 | £19,225 | £13,845 | £5,701 | £11,405 | £17,764 | £24,782 | £29,488 | £39,403 | £50,130 | £62,228 | £75,252 |