| 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 | |||||||||||||
| Coffee beverages | 0% | £24,000 | £27,000 | £28,800 | £28,800 | £28,800 | £28,800 | £28,800 | £28,800 | £29,400 | £31,200 | £33,000 | £33,000 |
| Coffee beans | 0% | £6,000 | £6,750 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,350 | £7,800 | £8,250 | £8,250 |
| Pastries, etc. | 0% | £10,000 | £11,250 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,250 | £13,000 | £13,750 | £13,750 |
| Total Sales | £40,000 | £45,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £49,000 | £52,000 | £55,000 | £55,000 | |
| 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 | |
| Coffee beverages | £6,000 | £6,750 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,350 | £7,800 | £8,250 | £8,250 | |
| Coffee beans | £3,000 | £3,375 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,675 | £3,900 | £4,125 | £4,125 | |
| Pastries, etc. | £5,000 | £5,625 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,125 | £6,500 | £6,875 | £6,875 | |
| Subtotal Direct Cost of Sales | £14,000 | £15,750 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £17,150 | £18,200 | £19,250 | £19,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 | ||
| Manager | 0% | £2,917 | £2,917 | £2,917 | £2,917 | £2,917 | £2,917 | £2,917 | £2,917 | £2,917 | £2,917 | £2,917 | £2,917 |
| Baristas | 0% | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 |
| Employees | 0% | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 |
| Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma 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 | £40,000 | £45,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £49,000 | £52,000 | £55,000 | £55,000 | |
| Direct Cost of Sales | £14,000 | £15,750 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £17,150 | £18,200 | £19,250 | £19,250 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £14,000 | £15,750 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £17,150 | £18,200 | £19,250 | £19,250 | |
| Gross Margin | £26,000 | £29,250 | £31,200 | £31,200 | £31,200 | £31,200 | £31,200 | £31,200 | £31,850 | £33,800 | £35,750 | £35,750 | |
| Gross Margin % | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | |
| Expenses | |||||||||||||
| Payroll | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | |
| Sales and Marketing and Other Expenses | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | |
| Depreciation | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | |
| Rent | £0 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | |
| Rent | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Maintenance | £400 | £450 | £480 | £480 | £480 | £480 | £480 | £480 | £490 | £520 | £550 | £550 | |
| Utilities/Phone | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Payroll Taxes | 15% | £1,558 | £1,558 | £1,558 | £1,558 | £1,558 | £1,558 | £1,558 | £1,558 | £1,558 | £1,558 | £1,558 | £1,558 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £16,191 | £20,641 | £20,671 | £20,671 | £20,671 | £20,671 | £20,671 | £20,671 | £20,681 | £20,711 | £20,741 | £20,741 | |
| Profit Before Interest and Taxes | £9,809 | £8,609 | £10,529 | £10,529 | £10,529 | £10,529 | £10,529 | £10,529 | £11,169 | £13,089 | £15,009 | £15,009 | |
| EBITDA | £10,259 | £9,059 | £10,979 | £10,979 | £10,979 | £10,979 | £10,979 | £10,979 | £11,619 | £13,539 | £15,459 | £15,459 | |
| Interest Expense | £248 | £245 | £243 | £241 | £239 | £236 | £234 | £232 | £229 | £227 | £225 | £223 | |
| Taxes Incurred | £2,868 | £2,091 | £2,572 | £2,572 | £2,573 | £2,573 | £2,574 | £2,574 | £2,735 | £3,216 | £3,696 | £3,697 | |
| Net Profit | £6,693 | £6,273 | £7,715 | £7,716 | £7,718 | £7,720 | £7,721 | £7,723 | £8,205 | £9,647 | £11,088 | £11,090 | |
| Net Profit/Sales | 16.73% | 13.94% | 16.07% | 16.08% | 16.08% | 16.08% | 16.09% | 16.09% | 16.74% | 18.55% | 20.16% | 20.16% | |
| 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 | £40,000 | £45,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £49,000 | £52,000 | £55,000 | £55,000 | |
| Subtotal Cash from Operations | £40,000 | £45,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £49,000 | £52,000 | £55,000 | £55,000 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £40,000 | £45,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £49,000 | £52,000 | £55,000 | £55,000 | |
| 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 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | |
| Bill Payments | £728 | £22,112 | £29,845 | £30,569 | £29,450 | £29,449 | £29,447 | £29,445 | £29,474 | £30,424 | £32,727 | £34,195 | |
| Subtotal Spent on Operations | £11,112 | £32,496 | £40,228 | £40,952 | £39,834 | £39,832 | £39,830 | £39,829 | £39,857 | £40,808 | £43,110 | £44,578 | |
| 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 | £275 | £275 | £275 | £275 | £275 | £275 | £275 | £275 | £275 | £275 | £275 | £275 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £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 | £11,387 | £32,771 | £40,503 | £41,227 | £40,109 | £40,107 | £40,105 | £40,104 | £40,132 | £41,083 | £43,385 | £44,853 | |
| Net Cash Flow | £28,613 | £12,229 | £7,497 | £6,773 | £7,891 | £7,893 | £7,895 | £7,896 | £8,868 | £10,917 | £11,615 | £10,147 | |
| Cash Balance | £95,736 | £107,966 | £115,462 | £122,235 | £130,127 | £138,020 | £145,914 | £153,811 | £162,679 | £173,596 | £185,211 | £195,358 | |
| 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 | £67,123 | £95,736 | £107,966 | £115,462 | £122,235 | £130,127 | £138,020 | £145,914 | £153,811 | £162,679 | £173,596 | £185,211 | £195,358 |
| Inventory | £16,027 | £15,400 | £17,325 | £18,480 | £18,480 | £18,480 | £18,480 | £18,480 | £18,480 | £18,865 | £20,020 | £21,175 | £21,175 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £83,150 | £111,136 | £125,291 | £133,942 | £140,715 | £148,607 | £156,500 | £164,394 | £172,291 | £181,544 | £193,616 | £206,386 | £216,533 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 |
| Accumulated Depreciation | £0 | £450 | £900 | £1,350 | £1,800 | £2,250 | £2,700 | £3,150 | £3,600 | £4,050 | £4,500 | £4,950 | £5,400 |
| Total Long-term Assets | £59,170 | £58,720 | £58,270 | £57,820 | £57,370 | £56,920 | £56,470 | £56,020 | £55,570 | £55,120 | £54,670 | £54,220 | £53,770 |
| Total Assets | £142,320 | £169,856 | £183,561 | £191,762 | £198,085 | £205,527 | £212,970 | £220,414 | £227,861 | £236,664 | £248,286 | £260,606 | £270,303 |
| 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 | £21,118 | £28,825 | £29,587 | £28,469 | £28,467 | £28,465 | £28,464 | £28,462 | £29,335 | £31,586 | £33,092 | £31,974 |
| Current Borrowing | £10,000 | £9,725 | £9,450 | £9,175 | £8,900 | £8,625 | £8,350 | £8,075 | £7,800 | £7,525 | £7,250 | £6,975 | £6,700 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £10,000 | £30,843 | £38,275 | £38,762 | £37,369 | £37,092 | £36,815 | £36,539 | £36,262 | £36,860 | £38,836 | £40,067 | £38,674 |
| Long-term Liabilities | £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 |
| Total Liabilities | £30,000 | £50,843 | £58,275 | £58,762 | £57,369 | £57,092 | £56,815 | £56,539 | £56,262 | £56,860 | £58,836 | £60,067 | £58,674 |
| Paid-in Capital | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 |
| Retained Earnings | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) |
| Earnings | £0 | £6,693 | £12,966 | £20,680 | £28,397 | £36,115 | £43,834 | £51,556 | £59,279 | £67,484 | £77,130 | £88,218 | £99,308 |
| Total Capital | £112,320 | £119,013 | £125,286 | £133,000 | £140,717 | £148,435 | £156,154 | £163,876 | £171,599 | £179,804 | £189,450 | £200,538 | £211,628 |
| Total Liabilities and Capital | £142,320 | £169,856 | £183,561 | £191,762 | £198,085 | £205,527 | £212,970 | £220,414 | £227,861 | £236,664 | £248,286 | £260,606 | £270,303 |
| Net Worth | £112,320 | £119,013 | £125,286 | £133,000 | £140,717 | £148,435 | £156,154 | £163,876 | £171,599 | £179,804 | £189,450 | £200,538 | £211,628 |
| 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 | |||||||||||||
| Coffee beverages | 0% | £24,000 | £27,000 | £28,800 | £28,800 | £28,800 | £28,800 | £28,800 | £28,800 | £29,400 | £31,200 | £33,000 | £33,000 |
| Coffee beans | 0% | £6,000 | £6,750 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,350 | £7,800 | £8,250 | £8,250 |
| Pastries, etc. | 0% | £10,000 | £11,250 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,250 | £13,000 | £13,750 | £13,750 |
| Total Sales | £40,000 | £45,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £49,000 | £52,000 | £55,000 | £55,000 | |
| 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 | |
| Coffee beverages | £6,000 | £6,750 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,350 | £7,800 | £8,250 | £8,250 | |
| Coffee beans | £3,000 | £3,375 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,675 | £3,900 | £4,125 | £4,125 | |
| Pastries, etc. | £5,000 | £5,625 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,125 | £6,500 | £6,875 | £6,875 | |
| Subtotal Direct Cost of Sales | £14,000 | £15,750 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £17,150 | £18,200 | £19,250 | £19,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 | ||
| Manager | 0% | £2,917 | £2,917 | £2,917 | £2,917 | £2,917 | £2,917 | £2,917 | £2,917 | £2,917 | £2,917 | £2,917 | £2,917 |
| Baristas | 0% | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 |
| Employees | 0% | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 | £3,300 |
| Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma 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 | £40,000 | £45,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £49,000 | £52,000 | £55,000 | £55,000 | |
| Direct Cost of Sales | £14,000 | £15,750 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £17,150 | £18,200 | £19,250 | £19,250 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £14,000 | £15,750 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £16,800 | £17,150 | £18,200 | £19,250 | £19,250 | |
| Gross Margin | £26,000 | £29,250 | £31,200 | £31,200 | £31,200 | £31,200 | £31,200 | £31,200 | £31,850 | £33,800 | £35,750 | £35,750 | |
| Gross Margin % | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | |
| Expenses | |||||||||||||
| Payroll | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | |
| Sales and Marketing and Other Expenses | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | £2,150 | |
| Depreciation | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | |
| Rent | £0 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | |
| Rent | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Maintenance | £400 | £450 | £480 | £480 | £480 | £480 | £480 | £480 | £490 | £520 | £550 | £550 | |
| Utilities/Phone | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Payroll Taxes | 15% | £1,558 | £1,558 | £1,558 | £1,558 | £1,558 | £1,558 | £1,558 | £1,558 | £1,558 | £1,558 | £1,558 | £1,558 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £16,191 | £20,641 | £20,671 | £20,671 | £20,671 | £20,671 | £20,671 | £20,671 | £20,681 | £20,711 | £20,741 | £20,741 | |
| Profit Before Interest and Taxes | £9,809 | £8,609 | £10,529 | £10,529 | £10,529 | £10,529 | £10,529 | £10,529 | £11,169 | £13,089 | £15,009 | £15,009 | |
| EBITDA | £10,259 | £9,059 | £10,979 | £10,979 | £10,979 | £10,979 | £10,979 | £10,979 | £11,619 | £13,539 | £15,459 | £15,459 | |
| Interest Expense | £248 | £245 | £243 | £241 | £239 | £236 | £234 | £232 | £229 | £227 | £225 | £223 | |
| Taxes Incurred | £2,868 | £2,091 | £2,572 | £2,572 | £2,573 | £2,573 | £2,574 | £2,574 | £2,735 | £3,216 | £3,696 | £3,697 | |
| Net Profit | £6,693 | £6,273 | £7,715 | £7,716 | £7,718 | £7,720 | £7,721 | £7,723 | £8,205 | £9,647 | £11,088 | £11,090 | |
| Net Profit/Sales | 16.73% | 13.94% | 16.07% | 16.08% | 16.08% | 16.08% | 16.09% | 16.09% | 16.74% | 18.55% | 20.16% | 20.16% | |
| 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 | £40,000 | £45,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £49,000 | £52,000 | £55,000 | £55,000 | |
| Subtotal Cash from Operations | £40,000 | £45,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £49,000 | £52,000 | £55,000 | £55,000 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £40,000 | £45,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £49,000 | £52,000 | £55,000 | £55,000 | |
| 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 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | £10,383 | |
| Bill Payments | £728 | £22,112 | £29,845 | £30,569 | £29,450 | £29,449 | £29,447 | £29,445 | £29,474 | £30,424 | £32,727 | £34,195 | |
| Subtotal Spent on Operations | £11,112 | £32,496 | £40,228 | £40,952 | £39,834 | £39,832 | £39,830 | £39,829 | £39,857 | £40,808 | £43,110 | £44,578 | |
| 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 | £275 | £275 | £275 | £275 | £275 | £275 | £275 | £275 | £275 | £275 | £275 | £275 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £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 | £11,387 | £32,771 | £40,503 | £41,227 | £40,109 | £40,107 | £40,105 | £40,104 | £40,132 | £41,083 | £43,385 | £44,853 | |
| Net Cash Flow | £28,613 | £12,229 | £7,497 | £6,773 | £7,891 | £7,893 | £7,895 | £7,896 | £8,868 | £10,917 | £11,615 | £10,147 | |
| Cash Balance | £95,736 | £107,966 | £115,462 | £122,235 | £130,127 | £138,020 | £145,914 | £153,811 | £162,679 | £173,596 | £185,211 | £195,358 | |
| 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 | £67,123 | £95,736 | £107,966 | £115,462 | £122,235 | £130,127 | £138,020 | £145,914 | £153,811 | £162,679 | £173,596 | £185,211 | £195,358 |
| Inventory | £16,027 | £15,400 | £17,325 | £18,480 | £18,480 | £18,480 | £18,480 | £18,480 | £18,480 | £18,865 | £20,020 | £21,175 | £21,175 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £83,150 | £111,136 | £125,291 | £133,942 | £140,715 | £148,607 | £156,500 | £164,394 | £172,291 | £181,544 | £193,616 | £206,386 | £216,533 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 | £59,170 |
| Accumulated Depreciation | £0 | £450 | £900 | £1,350 | £1,800 | £2,250 | £2,700 | £3,150 | £3,600 | £4,050 | £4,500 | £4,950 | £5,400 |
| Total Long-term Assets | £59,170 | £58,720 | £58,270 | £57,820 | £57,370 | £56,920 | £56,470 | £56,020 | £55,570 | £55,120 | £54,670 | £54,220 | £53,770 |
| Total Assets | £142,320 | £169,856 | £183,561 | £191,762 | £198,085 | £205,527 | £212,970 | £220,414 | £227,861 | £236,664 | £248,286 | £260,606 | £270,303 |
| 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 | £21,118 | £28,825 | £29,587 | £28,469 | £28,467 | £28,465 | £28,464 | £28,462 | £29,335 | £31,586 | £33,092 | £31,974 |
| Current Borrowing | £10,000 | £9,725 | £9,450 | £9,175 | £8,900 | £8,625 | £8,350 | £8,075 | £7,800 | £7,525 | £7,250 | £6,975 | £6,700 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £10,000 | £30,843 | £38,275 | £38,762 | £37,369 | £37,092 | £36,815 | £36,539 | £36,262 | £36,860 | £38,836 | £40,067 | £38,674 |
| Long-term Liabilities | £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 |
| Total Liabilities | £30,000 | £50,843 | £58,275 | £58,762 | £57,369 | £57,092 | £56,815 | £56,539 | £56,262 | £56,860 | £58,836 | £60,067 | £58,674 |
| Paid-in Capital | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 | £140,000 |
| Retained Earnings | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) | (£27,680) |
| Earnings | £0 | £6,693 | £12,966 | £20,680 | £28,397 | £36,115 | £43,834 | £51,556 | £59,279 | £67,484 | £77,130 | £88,218 | £99,308 |
| Total Capital | £112,320 | £119,013 | £125,286 | £133,000 | £140,717 | £148,435 | £156,154 | £163,876 | £171,599 | £179,804 | £189,450 | £200,538 | £211,628 |
| Total Liabilities and Capital | £142,320 | £169,856 | £183,561 | £191,762 | £198,085 | £205,527 | £212,970 | £220,414 | £227,861 | £236,664 | £248,286 | £260,606 | £270,303 |
| Net Worth | £112,320 | £119,013 | £125,286 | £133,000 | £140,717 | £148,435 | £156,154 | £163,876 | £171,599 | £179,804 | £189,450 | £200,538 | £211,628 |