| 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 | |||||||||||||
| Gasoline | 0% | £40,000 | £40,000 | £48,000 | £55,000 | £55,000 | £55,000 | £55,000 | £55,000 | £55,000 | £55,000 | £55,000 | £55,000 |
| Food, Drinks, and Produce | 0% | £10,000 | £12,000 | £14,000 | £15,000 | £16,000 | £16,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 |
| Total Sales | £50,000 | £52,000 | £62,000 | £70,000 | £71,000 | £71,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,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 | |
| Gasoline | £35,000 | £35,000 | £42,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | |
| Food, Drinks, and Produce | £2,000 | £2,500 | £2,900 | £3,000 | £3,200 | £3,200 | £3,400 | £3,400 | £3,400 | £3,400 | £3,400 | £3,400 | |
| Subtotal Direct Cost of Sales | £37,000 | £37,500 | £44,900 | £51,000 | £51,200 | £51,200 | £51,400 | £51,400 | £51,400 | £51,400 | £51,400 | £51,400 | |
| 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 | ||
| Robert Cole | 0% | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 |
| Store/Deli Staff | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Gas Attendants | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| 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% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | £50,000 | £52,000 | £62,000 | £70,000 | £71,000 | £71,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | |
| Direct Cost of Sales | £37,000 | £37,500 | £44,900 | £51,000 | £51,200 | £51,200 | £51,400 | £51,400 | £51,400 | £51,400 | £51,400 | £51,400 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £37,000 | £37,500 | £44,900 | £51,000 | £51,200 | £51,200 | £51,400 | £51,400 | £51,400 | £51,400 | £51,400 | £51,400 | |
| Gross Margin | £13,000 | £14,500 | £17,100 | £19,000 | £19,800 | £19,800 | £20,600 | £20,600 | £20,600 | £20,600 | £20,600 | £20,600 | |
| Gross Margin % | 26.00% | 27.88% | 27.58% | 27.14% | 27.89% | 27.89% | 28.61% | 28.61% | 28.61% | 28.61% | 28.61% | 28.61% | |
| Expenses | |||||||||||||
| Payroll | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £952 | £952 | £952 | £952 | £952 | £952 | £952 | £952 | £952 | £952 | £952 | £952 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Rent | £0 | £0 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | |
| Payroll Taxes | 15% | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £12,822 | £12,822 | £14,122 | £14,122 | £14,122 | £14,122 | £14,122 | £14,122 | £14,122 | £14,122 | £14,122 | £14,122 | |
| Profit Before Interest and Taxes | £178 | £1,678 | £2,978 | £4,878 | £5,678 | £5,678 | £6,478 | £6,478 | £6,478 | £6,478 | £6,478 | £6,478 | |
| EBITDA | £1,130 | £2,630 | £3,930 | £5,830 | £6,630 | £6,630 | £7,430 | £7,430 | £7,430 | £7,430 | £7,430 | £7,430 | |
| Interest Expense | £1,229 | £1,208 | £1,188 | £1,167 | £1,146 | £1,125 | £1,104 | £1,083 | £1,063 | £1,042 | £1,021 | £1,000 | |
| Taxes Incurred | (£315) | £141 | £537 | £1,113 | £1,360 | £1,366 | £1,612 | £1,618 | £1,625 | £1,631 | £1,637 | £1,643 | |
| Net Profit | (£736) | £329 | £1,253 | £2,598 | £3,173 | £3,187 | £3,762 | £3,776 | £3,791 | £3,805 | £3,820 | £3,835 | |
| Net Profit/Sales | -1.47% | 0.63% | 2.02% | 3.71% | 4.47% | 4.49% | 5.22% | 5.24% | 5.27% | 5.29% | 5.31% | 5.33% | |
| 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 | £50,000 | £52,000 | £62,000 | £70,000 | £71,000 | £71,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | |
| Subtotal Cash from Operations | £50,000 | £52,000 | £62,000 | £70,000 | £71,000 | £71,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,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 | £50,000 | £52,000 | £62,000 | £70,000 | £71,000 | £71,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,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 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| Bill Payments | £2,356 | £69,710 | £42,025 | £58,309 | £63,158 | £57,288 | £57,082 | £57,698 | £57,471 | £57,457 | £57,442 | £57,427 | |
| Subtotal Spent on Operations | £12,156 | £79,510 | £51,825 | £68,109 | £72,958 | £67,088 | £66,882 | £67,498 | £67,271 | £67,257 | £67,242 | £67,227 | |
| 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 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| 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 | £14,656 | £82,010 | £54,325 | £70,609 | £75,458 | £69,588 | £69,382 | £69,998 | £69,771 | £69,757 | £69,742 | £69,727 | |
| Net Cash Flow | £35,344 | (£30,010) | £7,675 | (£609) | (£4,458) | £1,412 | £2,618 | £2,002 | £2,229 | £2,243 | £2,258 | £2,273 | |
| Cash Balance | £53,844 | £23,834 | £31,509 | £30,900 | £26,442 | £27,855 | £30,472 | £32,474 | £34,703 | £36,946 | £39,204 | £41,476 | |
| 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 | £18,500 | £53,844 | £23,834 | £31,509 | £30,900 | £26,442 | £27,855 | £30,472 | £32,474 | £34,703 | £36,946 | £39,204 | £41,476 |
| Inventory | £10,000 | £40,700 | £41,250 | £49,390 | £56,100 | £56,320 | £56,320 | £56,540 | £56,540 | £56,540 | £56,540 | £56,540 | £56,540 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £28,500 | £94,544 | £65,084 | £80,899 | £87,000 | £82,762 | £84,175 | £87,012 | £89,014 | £91,243 | £93,486 | £95,744 | £98,016 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 |
| Accumulated Depreciation | £0 | £952 | £1,904 | £2,856 | £3,808 | £4,760 | £5,712 | £6,664 | £7,616 | £8,568 | £9,520 | £10,472 | £11,424 |
| Total Long-term Assets | £80,000 | £79,048 | £78,096 | £77,144 | £76,192 | £75,240 | £74,288 | £73,336 | £72,384 | £71,432 | £70,480 | £69,528 | £68,576 |
| Total Assets | £108,500 | £173,592 | £143,180 | £158,043 | £163,192 | £158,002 | £158,463 | £160,348 | £161,398 | £162,675 | £163,966 | £165,272 | £166,592 |
| 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 | £68,328 | £40,087 | £56,197 | £61,248 | £55,386 | £55,159 | £55,783 | £55,556 | £55,542 | £55,528 | £55,514 | £55,500 |
| 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 | £68,328 | £40,087 | £56,197 | £61,248 | £55,386 | £55,159 | £55,783 | £55,556 | £55,542 | £55,528 | £55,514 | £55,500 |
| Long-term Liabilities | £150,000 | £147,500 | £145,000 | £142,500 | £140,000 | £137,500 | £135,000 | £132,500 | £130,000 | £127,500 | £125,000 | £122,500 | £120,000 |
| Total Liabilities | £150,000 | £215,828 | £185,087 | £198,697 | £201,248 | £192,886 | £190,159 | £188,283 | £185,556 | £183,042 | £180,528 | £178,014 | £175,500 |
| Paid-in Capital | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 |
| Retained Earnings | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) |
| Earnings | £0 | (£736) | (£407) | £846 | £3,444 | £6,617 | £9,804 | £13,566 | £17,342 | £21,133 | £24,938 | £28,758 | £32,593 |
| Total Capital | (£41,500) | (£42,236) | (£41,907) | (£40,654) | (£38,056) | (£34,883) | (£31,696) | (£27,934) | (£24,158) | (£20,367) | (£16,562) | (£12,742) | (£8,907) |
| Total Liabilities and Capital | £108,500 | £173,592 | £143,180 | £158,043 | £163,192 | £158,002 | £158,463 | £160,348 | £161,398 | £162,675 | £163,966 | £165,272 | £166,592 |
| Net Worth | (£41,500) | (£42,236) | (£41,907) | (£40,654) | (£38,056) | (£34,883) | (£31,696) | (£27,934) | (£24,158) | (£20,367) | (£16,562) | (£12,742) | (£8,907) |
| 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 | |||||||||||||
| Gasoline | 0% | £40,000 | £40,000 | £48,000 | £55,000 | £55,000 | £55,000 | £55,000 | £55,000 | £55,000 | £55,000 | £55,000 | £55,000 |
| Food, Drinks, and Produce | 0% | £10,000 | £12,000 | £14,000 | £15,000 | £16,000 | £16,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 |
| Total Sales | £50,000 | £52,000 | £62,000 | £70,000 | £71,000 | £71,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,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 | |
| Gasoline | £35,000 | £35,000 | £42,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | £48,000 | |
| Food, Drinks, and Produce | £2,000 | £2,500 | £2,900 | £3,000 | £3,200 | £3,200 | £3,400 | £3,400 | £3,400 | £3,400 | £3,400 | £3,400 | |
| Subtotal Direct Cost of Sales | £37,000 | £37,500 | £44,900 | £51,000 | £51,200 | £51,200 | £51,400 | £51,400 | £51,400 | £51,400 | £51,400 | £51,400 | |
| 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 | ||
| Robert Cole | 0% | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 |
| Store/Deli Staff | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Gas Attendants | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| 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% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | £50,000 | £52,000 | £62,000 | £70,000 | £71,000 | £71,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | |
| Direct Cost of Sales | £37,000 | £37,500 | £44,900 | £51,000 | £51,200 | £51,200 | £51,400 | £51,400 | £51,400 | £51,400 | £51,400 | £51,400 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £37,000 | £37,500 | £44,900 | £51,000 | £51,200 | £51,200 | £51,400 | £51,400 | £51,400 | £51,400 | £51,400 | £51,400 | |
| Gross Margin | £13,000 | £14,500 | £17,100 | £19,000 | £19,800 | £19,800 | £20,600 | £20,600 | £20,600 | £20,600 | £20,600 | £20,600 | |
| Gross Margin % | 26.00% | 27.88% | 27.58% | 27.14% | 27.89% | 27.89% | 28.61% | 28.61% | 28.61% | 28.61% | 28.61% | 28.61% | |
| Expenses | |||||||||||||
| Payroll | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £952 | £952 | £952 | £952 | £952 | £952 | £952 | £952 | £952 | £952 | £952 | £952 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Rent | £0 | £0 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | |
| Payroll Taxes | 15% | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £12,822 | £12,822 | £14,122 | £14,122 | £14,122 | £14,122 | £14,122 | £14,122 | £14,122 | £14,122 | £14,122 | £14,122 | |
| Profit Before Interest and Taxes | £178 | £1,678 | £2,978 | £4,878 | £5,678 | £5,678 | £6,478 | £6,478 | £6,478 | £6,478 | £6,478 | £6,478 | |
| EBITDA | £1,130 | £2,630 | £3,930 | £5,830 | £6,630 | £6,630 | £7,430 | £7,430 | £7,430 | £7,430 | £7,430 | £7,430 | |
| Interest Expense | £1,229 | £1,208 | £1,188 | £1,167 | £1,146 | £1,125 | £1,104 | £1,083 | £1,063 | £1,042 | £1,021 | £1,000 | |
| Taxes Incurred | (£315) | £141 | £537 | £1,113 | £1,360 | £1,366 | £1,612 | £1,618 | £1,625 | £1,631 | £1,637 | £1,643 | |
| Net Profit | (£736) | £329 | £1,253 | £2,598 | £3,173 | £3,187 | £3,762 | £3,776 | £3,791 | £3,805 | £3,820 | £3,835 | |
| Net Profit/Sales | -1.47% | 0.63% | 2.02% | 3.71% | 4.47% | 4.49% | 5.22% | 5.24% | 5.27% | 5.29% | 5.31% | 5.33% | |
| 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 | £50,000 | £52,000 | £62,000 | £70,000 | £71,000 | £71,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | |
| Subtotal Cash from Operations | £50,000 | £52,000 | £62,000 | £70,000 | £71,000 | £71,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,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 | £50,000 | £52,000 | £62,000 | £70,000 | £71,000 | £71,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,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 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| Bill Payments | £2,356 | £69,710 | £42,025 | £58,309 | £63,158 | £57,288 | £57,082 | £57,698 | £57,471 | £57,457 | £57,442 | £57,427 | |
| Subtotal Spent on Operations | £12,156 | £79,510 | £51,825 | £68,109 | £72,958 | £67,088 | £66,882 | £67,498 | £67,271 | £67,257 | £67,242 | £67,227 | |
| 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 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| 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 | £14,656 | £82,010 | £54,325 | £70,609 | £75,458 | £69,588 | £69,382 | £69,998 | £69,771 | £69,757 | £69,742 | £69,727 | |
| Net Cash Flow | £35,344 | (£30,010) | £7,675 | (£609) | (£4,458) | £1,412 | £2,618 | £2,002 | £2,229 | £2,243 | £2,258 | £2,273 | |
| Cash Balance | £53,844 | £23,834 | £31,509 | £30,900 | £26,442 | £27,855 | £30,472 | £32,474 | £34,703 | £36,946 | £39,204 | £41,476 | |
| 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 | £18,500 | £53,844 | £23,834 | £31,509 | £30,900 | £26,442 | £27,855 | £30,472 | £32,474 | £34,703 | £36,946 | £39,204 | £41,476 |
| Inventory | £10,000 | £40,700 | £41,250 | £49,390 | £56,100 | £56,320 | £56,320 | £56,540 | £56,540 | £56,540 | £56,540 | £56,540 | £56,540 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £28,500 | £94,544 | £65,084 | £80,899 | £87,000 | £82,762 | £84,175 | £87,012 | £89,014 | £91,243 | £93,486 | £95,744 | £98,016 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 |
| Accumulated Depreciation | £0 | £952 | £1,904 | £2,856 | £3,808 | £4,760 | £5,712 | £6,664 | £7,616 | £8,568 | £9,520 | £10,472 | £11,424 |
| Total Long-term Assets | £80,000 | £79,048 | £78,096 | £77,144 | £76,192 | £75,240 | £74,288 | £73,336 | £72,384 | £71,432 | £70,480 | £69,528 | £68,576 |
| Total Assets | £108,500 | £173,592 | £143,180 | £158,043 | £163,192 | £158,002 | £158,463 | £160,348 | £161,398 | £162,675 | £163,966 | £165,272 | £166,592 |
| 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 | £68,328 | £40,087 | £56,197 | £61,248 | £55,386 | £55,159 | £55,783 | £55,556 | £55,542 | £55,528 | £55,514 | £55,500 |
| 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 | £68,328 | £40,087 | £56,197 | £61,248 | £55,386 | £55,159 | £55,783 | £55,556 | £55,542 | £55,528 | £55,514 | £55,500 |
| Long-term Liabilities | £150,000 | £147,500 | £145,000 | £142,500 | £140,000 | £137,500 | £135,000 | £132,500 | £130,000 | £127,500 | £125,000 | £122,500 | £120,000 |
| Total Liabilities | £150,000 | £215,828 | £185,087 | £198,697 | £201,248 | £192,886 | £190,159 | £188,283 | £185,556 | £183,042 | £180,528 | £178,014 | £175,500 |
| Paid-in Capital | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 |
| Retained Earnings | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) | (£101,500) |
| Earnings | £0 | (£736) | (£407) | £846 | £3,444 | £6,617 | £9,804 | £13,566 | £17,342 | £21,133 | £24,938 | £28,758 | £32,593 |
| Total Capital | (£41,500) | (£42,236) | (£41,907) | (£40,654) | (£38,056) | (£34,883) | (£31,696) | (£27,934) | (£24,158) | (£20,367) | (£16,562) | (£12,742) | (£8,907) |
| Total Liabilities and Capital | £108,500 | £173,592 | £143,180 | £158,043 | £163,192 | £158,002 | £158,463 | £160,348 | £161,398 | £162,675 | £163,966 | £165,272 | £166,592 |
| Net Worth | (£41,500) | (£42,236) | (£41,907) | (£40,654) | (£38,056) | (£34,883) | (£31,696) | (£27,934) | (£24,158) | (£20,367) | (£16,562) | (£12,742) | (£8,907) |