| 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 | |||||||||||||
| Perishable Items | 0% | £6,000 | £6,500 | £7,000 | £7,500 | £8,500 | £9,000 | £9,000 | £9,000 | £10,000 | £12,000 | £12,000 | £17,000 |
| Non-Perishible Items | 0% | £12,000 | £13,000 | £14,000 | £15,000 | £17,000 | £18,000 | £18,000 | £18,000 | £19,000 | £21,000 | £21,000 | £26,000 |
| Total Sales | £18,000 | £19,500 | £21,000 | £22,500 | £25,500 | £27,000 | £27,000 | £27,000 | £29,000 | £33,000 | £33,000 | £43,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 | |
| Perishable Items | £3,000 | £3,250 | £3,500 | £3,750 | £4,250 | £4,500 | £4,500 | £4,500 | £5,000 | £6,000 | £6,000 | £8,500 | |
| Non-Perishable Items | £6,000 | £6,500 | £7,000 | £7,500 | £8,500 | £9,000 | £9,000 | £9,000 | £9,500 | £10,500 | £10,500 | £13,000 | |
| Subtotal Direct Cost of Sales | £9,000 | £9,750 | £10,500 | £11,250 | £12,750 | £13,500 | £13,500 | £13,500 | £14,500 | £16,500 | £16,500 | £21,500 | |
| 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 | ||
| Owner | 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 |
| Owner/Manager | 0% | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Full Time | 0% | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Full Time | 0% | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Full Time | 0% | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Full Time | 0% | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Part Time | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Part Time | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Part Time | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Part Time | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Total People | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | |
| Total Payroll | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | |
| 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 | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Long-term Interest Rate | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.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 | £18,000 | £19,500 | £21,000 | £22,500 | £25,500 | £27,000 | £27,000 | £27,000 | £29,000 | £33,000 | £33,000 | £43,000 | |
| Direct Cost of Sales | £9,000 | £9,750 | £10,500 | £11,250 | £12,750 | £13,500 | £13,500 | £13,500 | £14,500 | £16,500 | £16,500 | £21,500 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £9,000 | £9,750 | £10,500 | £11,250 | £12,750 | £13,500 | £13,500 | £13,500 | £14,500 | £16,500 | £16,500 | £21,500 | |
| Gross Margin | £9,000 | £9,750 | £10,500 | £11,250 | £12,750 | £13,500 | £13,500 | £13,500 | £14,500 | £16,500 | £16,500 | £21,500 | |
| Gross Margin % | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | |
| Expenses | |||||||||||||
| Payroll | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | |
| Sales and Marketing and Other Expenses | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Depreciation | £95 | £95 | £95 | £95 | £95 | £95 | £95 | £95 | £95 | £95 | £95 | £95 | |
| Rent | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £0 | |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Payroll Taxes | 15% | £1,815 | £1,815 | £1,815 | £1,815 | £1,815 | £1,815 | £1,815 | £1,815 | £1,815 | £1,815 | £1,815 | £1,815 |
| Other | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Operating Expenses | £18,810 | £18,810 | £18,810 | £18,810 | £18,810 | £18,810 | £18,810 | £18,810 | £18,810 | £18,810 | £18,810 | £18,510 | |
| Profit Before Interest and Taxes | (£9,810) | (£9,060) | (£8,310) | (£7,560) | (£6,060) | (£5,310) | (£5,310) | (£5,310) | (£4,310) | (£2,310) | (£2,310) | £2,990 | |
| EBITDA | (£9,715) | (£8,965) | (£8,215) | (£7,465) | (£5,965) | (£5,215) | (£5,215) | (£5,215) | (£4,215) | (£2,215) | (£2,215) | £3,085 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £18 | £17 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£9,810) | (£9,060) | (£8,310) | (£7,560) | (£6,060) | (£5,310) | (£5,310) | (£5,310) | (£4,310) | (£2,310) | (£2,328) | £2,973 | |
| Net Profit/Sales | -54.50% | -46.46% | -39.57% | -33.60% | -23.77% | -19.67% | -19.67% | -19.67% | -14.86% | -7.00% | -7.05% | 6.91% | |
| 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 | £18,000 | £19,500 | £21,000 | £22,500 | £25,500 | £27,000 | £27,000 | £27,000 | £29,000 | £33,000 | £33,000 | £43,000 | |
| Subtotal Cash from Operations | £18,000 | £19,500 | £21,000 | £22,500 | £25,500 | £27,000 | £27,000 | £27,000 | £29,000 | £33,000 | £33,000 | £43,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 | £3,000 | £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 | £2,000 | £0 | |
| Subtotal Cash Received | £18,000 | £19,500 | £21,000 | £22,500 | £25,500 | £27,000 | £27,000 | £27,000 | £29,000 | £33,000 | £38,000 | £43,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 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | |
| Bill Payments | £6,221 | £6,931 | £16,152 | £17,965 | £18,768 | £21,013 | £20,913 | £20,115 | £20,185 | £22,318 | £25,242 | £23,472 | |
| Subtotal Spent on Operations | £18,321 | £19,031 | £28,252 | £30,065 | £30,868 | £33,113 | £33,013 | £32,215 | £32,285 | £34,418 | £37,342 | £35,572 | |
| 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 | £100 | |
| 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 | £18,321 | £19,031 | £28,252 | £30,065 | £30,868 | £33,113 | £33,013 | £32,215 | £32,285 | £34,418 | £37,342 | £35,672 | |
| Net Cash Flow | (£321) | £469 | (£7,252) | (£7,565) | (£5,368) | (£6,113) | (£6,013) | (£5,215) | (£3,285) | (£1,418) | £658 | £7,328 | |
| Cash Balance | £42,180 | £42,649 | £35,397 | £27,832 | £22,465 | £16,352 | £10,340 | £5,125 | £1,840 | £421 | £1,079 | £8,406 | |
| 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 | £42,500 | £42,180 | £42,649 | £35,397 | £27,832 | £22,465 | £16,352 | £10,340 | £5,125 | £1,840 | £421 | £1,079 | £8,406 |
| Inventory | £20,000 | £11,000 | £10,725 | £11,550 | £12,375 | £14,025 | £14,850 | £14,850 | £14,850 | £15,950 | £18,150 | £18,150 | £23,650 |
| Other Current Assets | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Total Current Assets | £63,500 | £54,180 | £54,374 | £47,947 | £41,207 | £37,490 | £32,202 | £26,190 | £20,975 | £18,790 | £19,571 | £20,229 | £33,056 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Accumulated Depreciation | £0 | £95 | £190 | £286 | £381 | £476 | £571 | £667 | £762 | £857 | £952 | £1,048 | £1,143 |
| Total Long-term Assets | £10,000 | £9,905 | £9,810 | £9,714 | £9,619 | £9,524 | £9,429 | £9,333 | £9,238 | £9,143 | £9,048 | £8,952 | £8,857 |
| Total Assets | £73,500 | £64,084 | £64,183 | £57,661 | £50,826 | £47,013 | £41,631 | £35,523 | £30,213 | £27,932 | £28,619 | £29,181 | £41,914 |
| 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 | £6,000 | £6,395 | £15,554 | £17,342 | £18,067 | £20,315 | £20,242 | £19,445 | £19,445 | £21,475 | £24,471 | £22,361 | £32,221 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,000 | £2,900 |
| Other Current Liabilities | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Subtotal Current Liabilities | £6,500 | £6,895 | £16,054 | £17,842 | £18,567 | £20,815 | £20,742 | £19,945 | £19,945 | £21,975 | £24,971 | £25,861 | £35,621 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £6,500 | £6,895 | £16,054 | £17,842 | £18,567 | £20,815 | £20,742 | £19,945 | £19,945 | £21,975 | £24,971 | £25,861 | £35,621 |
| Paid-in Capital | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £82,000 | £82,000 |
| Retained Earnings | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) |
| Earnings | £0 | (£9,810) | (£18,870) | (£27,181) | (£34,741) | (£40,801) | (£46,111) | (£51,422) | (£56,732) | (£61,042) | (£63,352) | (£65,680) | (£62,707) |
| Total Capital | £67,000 | £57,190 | £48,130 | £39,819 | £32,259 | £26,199 | £20,889 | £15,578 | £10,268 | £5,958 | £3,648 | £3,320 | £6,293 |
| Total Liabilities and Capital | £73,500 | £64,084 | £64,183 | £57,661 | £50,826 | £47,013 | £41,631 | £35,523 | £30,213 | £27,932 | £28,619 | £29,181 | £41,914 |
| Net Worth | £67,000 | £57,190 | £48,130 | £39,819 | £32,259 | £26,199 | £20,889 | £15,578 | £10,268 | £5,958 | £3,648 | £3,320 | £6,293 |
| 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 | |||||||||||||
| Perishable Items | 0% | £6,000 | £6,500 | £7,000 | £7,500 | £8,500 | £9,000 | £9,000 | £9,000 | £10,000 | £12,000 | £12,000 | £17,000 |
| Non-Perishible Items | 0% | £12,000 | £13,000 | £14,000 | £15,000 | £17,000 | £18,000 | £18,000 | £18,000 | £19,000 | £21,000 | £21,000 | £26,000 |
| Total Sales | £18,000 | £19,500 | £21,000 | £22,500 | £25,500 | £27,000 | £27,000 | £27,000 | £29,000 | £33,000 | £33,000 | £43,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 | |
| Perishable Items | £3,000 | £3,250 | £3,500 | £3,750 | £4,250 | £4,500 | £4,500 | £4,500 | £5,000 | £6,000 | £6,000 | £8,500 | |
| Non-Perishable Items | £6,000 | £6,500 | £7,000 | £7,500 | £8,500 | £9,000 | £9,000 | £9,000 | £9,500 | £10,500 | £10,500 | £13,000 | |
| Subtotal Direct Cost of Sales | £9,000 | £9,750 | £10,500 | £11,250 | £12,750 | £13,500 | £13,500 | £13,500 | £14,500 | £16,500 | £16,500 | £21,500 | |
| 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 | ||
| Owner | 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 |
| Owner/Manager | 0% | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Full Time | 0% | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Full Time | 0% | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Full Time | 0% | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Full Time | 0% | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Part Time | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Part Time | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Part Time | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Part Time | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Total People | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | |
| Total Payroll | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | |
| 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 | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Long-term Interest Rate | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | 20.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 | £18,000 | £19,500 | £21,000 | £22,500 | £25,500 | £27,000 | £27,000 | £27,000 | £29,000 | £33,000 | £33,000 | £43,000 | |
| Direct Cost of Sales | £9,000 | £9,750 | £10,500 | £11,250 | £12,750 | £13,500 | £13,500 | £13,500 | £14,500 | £16,500 | £16,500 | £21,500 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £9,000 | £9,750 | £10,500 | £11,250 | £12,750 | £13,500 | £13,500 | £13,500 | £14,500 | £16,500 | £16,500 | £21,500 | |
| Gross Margin | £9,000 | £9,750 | £10,500 | £11,250 | £12,750 | £13,500 | £13,500 | £13,500 | £14,500 | £16,500 | £16,500 | £21,500 | |
| Gross Margin % | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | |
| Expenses | |||||||||||||
| Payroll | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | |
| Sales and Marketing and Other Expenses | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Depreciation | £95 | £95 | £95 | £95 | £95 | £95 | £95 | £95 | £95 | £95 | £95 | £95 | |
| Rent | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £0 | |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Payroll Taxes | 15% | £1,815 | £1,815 | £1,815 | £1,815 | £1,815 | £1,815 | £1,815 | £1,815 | £1,815 | £1,815 | £1,815 | £1,815 |
| Other | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Operating Expenses | £18,810 | £18,810 | £18,810 | £18,810 | £18,810 | £18,810 | £18,810 | £18,810 | £18,810 | £18,810 | £18,810 | £18,510 | |
| Profit Before Interest and Taxes | (£9,810) | (£9,060) | (£8,310) | (£7,560) | (£6,060) | (£5,310) | (£5,310) | (£5,310) | (£4,310) | (£2,310) | (£2,310) | £2,990 | |
| EBITDA | (£9,715) | (£8,965) | (£8,215) | (£7,465) | (£5,965) | (£5,215) | (£5,215) | (£5,215) | (£4,215) | (£2,215) | (£2,215) | £3,085 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £18 | £17 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£9,810) | (£9,060) | (£8,310) | (£7,560) | (£6,060) | (£5,310) | (£5,310) | (£5,310) | (£4,310) | (£2,310) | (£2,328) | £2,973 | |
| Net Profit/Sales | -54.50% | -46.46% | -39.57% | -33.60% | -23.77% | -19.67% | -19.67% | -19.67% | -14.86% | -7.00% | -7.05% | 6.91% | |
| 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 | £18,000 | £19,500 | £21,000 | £22,500 | £25,500 | £27,000 | £27,000 | £27,000 | £29,000 | £33,000 | £33,000 | £43,000 | |
| Subtotal Cash from Operations | £18,000 | £19,500 | £21,000 | £22,500 | £25,500 | £27,000 | £27,000 | £27,000 | £29,000 | £33,000 | £33,000 | £43,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 | £3,000 | £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 | £2,000 | £0 | |
| Subtotal Cash Received | £18,000 | £19,500 | £21,000 | £22,500 | £25,500 | £27,000 | £27,000 | £27,000 | £29,000 | £33,000 | £38,000 | £43,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 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | |
| Bill Payments | £6,221 | £6,931 | £16,152 | £17,965 | £18,768 | £21,013 | £20,913 | £20,115 | £20,185 | £22,318 | £25,242 | £23,472 | |
| Subtotal Spent on Operations | £18,321 | £19,031 | £28,252 | £30,065 | £30,868 | £33,113 | £33,013 | £32,215 | £32,285 | £34,418 | £37,342 | £35,572 | |
| 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 | £100 | |
| 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 | £18,321 | £19,031 | £28,252 | £30,065 | £30,868 | £33,113 | £33,013 | £32,215 | £32,285 | £34,418 | £37,342 | £35,672 | |
| Net Cash Flow | (£321) | £469 | (£7,252) | (£7,565) | (£5,368) | (£6,113) | (£6,013) | (£5,215) | (£3,285) | (£1,418) | £658 | £7,328 | |
| Cash Balance | £42,180 | £42,649 | £35,397 | £27,832 | £22,465 | £16,352 | £10,340 | £5,125 | £1,840 | £421 | £1,079 | £8,406 | |
| 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 | £42,500 | £42,180 | £42,649 | £35,397 | £27,832 | £22,465 | £16,352 | £10,340 | £5,125 | £1,840 | £421 | £1,079 | £8,406 |
| Inventory | £20,000 | £11,000 | £10,725 | £11,550 | £12,375 | £14,025 | £14,850 | £14,850 | £14,850 | £15,950 | £18,150 | £18,150 | £23,650 |
| Other Current Assets | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Total Current Assets | £63,500 | £54,180 | £54,374 | £47,947 | £41,207 | £37,490 | £32,202 | £26,190 | £20,975 | £18,790 | £19,571 | £20,229 | £33,056 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Accumulated Depreciation | £0 | £95 | £190 | £286 | £381 | £476 | £571 | £667 | £762 | £857 | £952 | £1,048 | £1,143 |
| Total Long-term Assets | £10,000 | £9,905 | £9,810 | £9,714 | £9,619 | £9,524 | £9,429 | £9,333 | £9,238 | £9,143 | £9,048 | £8,952 | £8,857 |
| Total Assets | £73,500 | £64,084 | £64,183 | £57,661 | £50,826 | £47,013 | £41,631 | £35,523 | £30,213 | £27,932 | £28,619 | £29,181 | £41,914 |
| 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 | £6,000 | £6,395 | £15,554 | £17,342 | £18,067 | £20,315 | £20,242 | £19,445 | £19,445 | £21,475 | £24,471 | £22,361 | £32,221 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,000 | £2,900 |
| Other Current Liabilities | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Subtotal Current Liabilities | £6,500 | £6,895 | £16,054 | £17,842 | £18,567 | £20,815 | £20,742 | £19,945 | £19,945 | £21,975 | £24,971 | £25,861 | £35,621 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £6,500 | £6,895 | £16,054 | £17,842 | £18,567 | £20,815 | £20,742 | £19,945 | £19,945 | £21,975 | £24,971 | £25,861 | £35,621 |
| Paid-in Capital | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £82,000 | £82,000 |
| Retained Earnings | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) | (£13,000) |
| Earnings | £0 | (£9,810) | (£18,870) | (£27,181) | (£34,741) | (£40,801) | (£46,111) | (£51,422) | (£56,732) | (£61,042) | (£63,352) | (£65,680) | (£62,707) |
| Total Capital | £67,000 | £57,190 | £48,130 | £39,819 | £32,259 | £26,199 | £20,889 | £15,578 | £10,268 | £5,958 | £3,648 | £3,320 | £6,293 |
| Total Liabilities and Capital | £73,500 | £64,084 | £64,183 | £57,661 | £50,826 | £47,013 | £41,631 | £35,523 | £30,213 | £27,932 | £28,619 | £29,181 | £41,914 |
| Net Worth | £67,000 | £57,190 | £48,130 | £39,819 | £32,259 | £26,199 | £20,889 | £15,578 | £10,268 | £5,958 | £3,648 | £3,320 | £6,293 |