| 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 | |||||||||||||
| Fresh Foods, Dairy and Drinks | 0% | £2,750 | £3,524 | £3,978 | £4,206 | £4,718 | £5,227 | £4,693 | £4,011 | £3,829 | £3,640 | £3,685 | £3,848 |
| Packaged Foods | 0% | £5,789 | £8,438 | £9,177 | £9,508 | £10,378 | £10,653 | £10,332 | £9,369 | £9,351 | £9,020 | £8,448 | £8,430 |
| Hard Goods | 0% | £2,700 | £2,819 | £2,946 | £3,802 | £4,077 | £3,786 | £3,551 | £3,730 | £3,921 | £3,125 | £4,344 | £4,578 |
| Beer, Wine and Cigarettes | 0% | £8,750 | £9,088 | £9,442 | £13,450 | £14,288 | £13,216 | £11,046 | £11,498 | £11,973 | £12,471 | £12,995 | £12,545 |
| Rental Income | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Prepackaged Meals | 0% | £942 | £1,071 | £1,188 | £1,821 | £2,282 | £2,184 | £1,784 | £1,824 | £1,832 | £1,856 | £2,192 | £2,264 |
| Total Sales | £21,931 | £25,940 | £27,731 | £33,786 | £36,742 | £36,066 | £32,406 | £31,432 | £31,906 | £31,112 | £32,664 | £32,665 | |
| 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 | |
| Fresh Foods | £1,375 | £1,762 | £1,989 | £2,103 | £2,359 | £2,614 | £2,346 | £2,006 | £1,914 | £1,820 | £1,842 | £1,924 | |
| Packaged Foods | £659 | £749 | £831 | £1,275 | £1,597 | £1,529 | £1,249 | £1,277 | £1,282 | £1,299 | £1,534 | £1,585 | |
| Hard Goods | £10,965 | £12,970 | £13,866 | £16,893 | £18,371 | £18,033 | £16,203 | £15,716 | £15,953 | £15,556 | £16,332 | £16,333 | |
| Drinks (inc. beer and wine) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Prepackaged Meals | £413 | £529 | £597 | £631 | £708 | £784 | £704 | £602 | £574 | £546 | £553 | £577 | |
| Subtotal Direct Cost of Sales | £13,412 | £16,010 | £17,283 | £20,902 | £23,035 | £22,959 | £20,502 | £19,600 | £19,724 | £19,221 | £20,261 | £20,419 | |
| 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 | ||
| Heidi Renner | 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 |
| Thomas Renner | 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 |
| Cashiers | 0% | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | |
| 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 | £21,931 | £25,940 | £27,731 | £33,786 | £36,742 | £36,066 | £32,406 | £31,432 | £31,906 | £31,112 | £32,664 | £32,665 | |
| Direct Cost of Sales | £13,412 | £16,010 | £17,283 | £20,902 | £23,035 | £22,959 | £20,502 | £19,600 | £19,724 | £19,221 | £20,261 | £20,419 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £13,412 | £16,010 | £17,283 | £20,902 | £23,035 | £22,959 | £20,502 | £19,600 | £19,724 | £19,221 | £20,261 | £20,419 | |
| Gross Margin | £8,519 | £9,930 | £10,448 | £12,885 | £13,707 | £13,106 | £11,904 | £11,832 | £12,182 | £11,891 | £12,402 | £12,247 | |
| Gross Margin % | 38.84% | 38.28% | 37.68% | 38.14% | 37.31% | 36.34% | 36.73% | 37.64% | 38.18% | 38.22% | 37.97% | 37.49% | |
| Expenses | |||||||||||||
| Payroll | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | |
| Sales and Marketing and Other Expenses | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Depreciation | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| 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 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Payroll Taxes | 10% | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £12,710 | £12,710 | £12,710 | £12,710 | £12,710 | £12,710 | £12,710 | £12,710 | £12,710 | £12,710 | £12,710 | £12,710 | |
| Profit Before Interest and Taxes | (£4,191) | (£2,780) | (£2,262) | £175 | £997 | £396 | (£806) | (£878) | (£528) | (£819) | (£308) | (£464) | |
| EBITDA | (£3,691) | (£2,280) | (£1,762) | £675 | £1,497 | £896 | (£306) | (£378) | (£28) | (£319) | £192 | £37 | |
| Interest Expense | £414 | £412 | £409 | £407 | £404 | £402 | £399 | £397 | £394 | £392 | £389 | £387 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£4,606) | (£3,192) | (£2,671) | (£232) | £593 | (£5) | (£1,205) | (£1,275) | (£922) | (£1,211) | (£697) | (£850) | |
| Net Profit/Sales | -21.00% | -12.31% | -9.63% | -0.69% | 1.61% | -0.01% | -3.72% | -4.06% | -2.89% | -3.89% | -2.13% | -2.60% | |
| 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 | £21,931 | £25,940 | £27,731 | £33,786 | £36,742 | £36,066 | £32,406 | £31,432 | £31,906 | £31,112 | £32,664 | £32,665 | |
| Subtotal Cash from Operations | £21,931 | £25,940 | £27,731 | £33,786 | £36,742 | £36,066 | £32,406 | £31,432 | £31,906 | £31,112 | £32,664 | £32,665 | |
| 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 | £21,931 | £25,940 | £27,731 | £33,786 | £36,742 | £36,066 | £32,406 | £31,432 | £31,906 | £31,112 | £32,664 | £32,665 | |
| 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 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | |
| Bill Payments | £167 | £5,024 | £5,022 | £5,019 | £5,549 | £21,223 | £27,719 | £22,835 | £23,656 | £24,825 | £23,761 | £26,378 | |
| Subtotal Spent on Operations | £7,767 | £12,624 | £12,622 | £12,619 | £13,149 | £28,823 | £35,319 | £30,435 | £31,256 | £32,425 | £31,361 | £33,978 | |
| 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 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| 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 | £30,000 | £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 | £38,067 | £12,924 | £12,922 | £12,919 | £13,449 | £29,123 | £35,619 | £30,735 | £31,556 | £32,725 | £31,661 | £34,278 | |
| Net Cash Flow | (£16,137) | £13,016 | £14,810 | £20,867 | £23,293 | £6,943 | (£3,213) | £697 | £349 | (£1,613) | £1,003 | (£1,613) | |
| Cash Balance | £41,963 | £54,979 | £69,788 | £90,656 | £113,949 | £120,891 | £117,678 | £118,375 | £118,724 | £117,112 | £118,115 | £116,502 | |
| 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 | £58,100 | £41,963 | £54,979 | £69,788 | £90,656 | £113,949 | £120,891 | £117,678 | £118,375 | £118,724 | £117,112 | £118,115 | £116,502 |
| Inventory | £100,000 | £86,588 | £70,578 | £53,295 | £32,393 | £25,338 | £25,255 | £22,552 | £21,560 | £21,696 | £21,143 | £22,288 | £22,460 |
| Other Current Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Total Current Assets | £163,100 | £133,551 | £130,557 | £128,083 | £128,049 | £144,287 | £151,146 | £145,230 | £144,935 | £145,421 | £143,255 | £145,402 | £143,962 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £30,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 |
| Accumulated Depreciation | £0 | £500 | £1,000 | £1,500 | £2,000 | £2,500 | £3,000 | £3,500 | £4,000 | £4,500 | £5,000 | £5,500 | £6,000 |
| Total Long-term Assets | £30,000 | £59,500 | £59,000 | £58,500 | £58,000 | £57,500 | £57,000 | £56,500 | £56,000 | £55,500 | £55,000 | £54,500 | £54,000 |
| Total Assets | £193,100 | £193,051 | £189,557 | £186,583 | £186,049 | £201,787 | £208,146 | £201,730 | £200,935 | £200,921 | £198,255 | £199,902 | £197,962 |
| 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 | £4,857 | £4,854 | £4,852 | £4,849 | £20,294 | £26,959 | £22,048 | £22,828 | £24,036 | £22,881 | £25,525 | £24,735 |
| Current Borrowing | £50,000 | £49,700 | £49,400 | £49,100 | £48,800 | £48,500 | £48,200 | £47,900 | £47,600 | £47,300 | £47,000 | £46,700 | £46,400 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £50,000 | £54,557 | £54,254 | £53,952 | £53,649 | £68,794 | £75,159 | £69,948 | £70,428 | £71,336 | £69,881 | £72,225 | £71,135 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £50,000 | £54,557 | £54,254 | £53,952 | £53,649 | £68,794 | £75,159 | £69,948 | £70,428 | £71,336 | £69,881 | £72,225 | £71,135 |
| Paid-in Capital | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 |
| Retained Earnings | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) |
| Earnings | £0 | (£4,606) | (£7,797) | (£10,468) | (£10,700) | (£10,107) | (£10,112) | (£11,318) | (£12,592) | (£13,515) | (£14,726) | (£15,422) | (£16,273) |
| Total Capital | £143,100 | £138,494 | £135,303 | £132,632 | £132,400 | £132,993 | £132,988 | £131,782 | £130,508 | £129,585 | £128,374 | £127,678 | £126,827 |
| Total Liabilities and Capital | £193,100 | £193,051 | £189,557 | £186,583 | £186,049 | £201,787 | £208,146 | £201,730 | £200,935 | £200,921 | £198,255 | £199,902 | £197,962 |
| Net Worth | £143,100 | £138,494 | £135,303 | £132,632 | £132,400 | £132,993 | £132,988 | £131,782 | £130,508 | £129,585 | £128,374 | £127,678 | £126,827 |
| 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 | |||||||||||||
| Fresh Foods, Dairy and Drinks | 0% | £2,750 | £3,524 | £3,978 | £4,206 | £4,718 | £5,227 | £4,693 | £4,011 | £3,829 | £3,640 | £3,685 | £3,848 |
| Packaged Foods | 0% | £5,789 | £8,438 | £9,177 | £9,508 | £10,378 | £10,653 | £10,332 | £9,369 | £9,351 | £9,020 | £8,448 | £8,430 |
| Hard Goods | 0% | £2,700 | £2,819 | £2,946 | £3,802 | £4,077 | £3,786 | £3,551 | £3,730 | £3,921 | £3,125 | £4,344 | £4,578 |
| Beer, Wine and Cigarettes | 0% | £8,750 | £9,088 | £9,442 | £13,450 | £14,288 | £13,216 | £11,046 | £11,498 | £11,973 | £12,471 | £12,995 | £12,545 |
| Rental Income | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Prepackaged Meals | 0% | £942 | £1,071 | £1,188 | £1,821 | £2,282 | £2,184 | £1,784 | £1,824 | £1,832 | £1,856 | £2,192 | £2,264 |
| Total Sales | £21,931 | £25,940 | £27,731 | £33,786 | £36,742 | £36,066 | £32,406 | £31,432 | £31,906 | £31,112 | £32,664 | £32,665 | |
| 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 | |
| Fresh Foods | £1,375 | £1,762 | £1,989 | £2,103 | £2,359 | £2,614 | £2,346 | £2,006 | £1,914 | £1,820 | £1,842 | £1,924 | |
| Packaged Foods | £659 | £749 | £831 | £1,275 | £1,597 | £1,529 | £1,249 | £1,277 | £1,282 | £1,299 | £1,534 | £1,585 | |
| Hard Goods | £10,965 | £12,970 | £13,866 | £16,893 | £18,371 | £18,033 | £16,203 | £15,716 | £15,953 | £15,556 | £16,332 | £16,333 | |
| Drinks (inc. beer and wine) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Prepackaged Meals | £413 | £529 | £597 | £631 | £708 | £784 | £704 | £602 | £574 | £546 | £553 | £577 | |
| Subtotal Direct Cost of Sales | £13,412 | £16,010 | £17,283 | £20,902 | £23,035 | £22,959 | £20,502 | £19,600 | £19,724 | £19,221 | £20,261 | £20,419 | |
| 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 | ||
| Heidi Renner | 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 |
| Thomas Renner | 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 |
| Cashiers | 0% | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | |
| 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 | £21,931 | £25,940 | £27,731 | £33,786 | £36,742 | £36,066 | £32,406 | £31,432 | £31,906 | £31,112 | £32,664 | £32,665 | |
| Direct Cost of Sales | £13,412 | £16,010 | £17,283 | £20,902 | £23,035 | £22,959 | £20,502 | £19,600 | £19,724 | £19,221 | £20,261 | £20,419 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £13,412 | £16,010 | £17,283 | £20,902 | £23,035 | £22,959 | £20,502 | £19,600 | £19,724 | £19,221 | £20,261 | £20,419 | |
| Gross Margin | £8,519 | £9,930 | £10,448 | £12,885 | £13,707 | £13,106 | £11,904 | £11,832 | £12,182 | £11,891 | £12,402 | £12,247 | |
| Gross Margin % | 38.84% | 38.28% | 37.68% | 38.14% | 37.31% | 36.34% | 36.73% | 37.64% | 38.18% | 38.22% | 37.97% | 37.49% | |
| Expenses | |||||||||||||
| Payroll | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | |
| Sales and Marketing and Other Expenses | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Depreciation | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| 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 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Payroll Taxes | 10% | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 | £760 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £12,710 | £12,710 | £12,710 | £12,710 | £12,710 | £12,710 | £12,710 | £12,710 | £12,710 | £12,710 | £12,710 | £12,710 | |
| Profit Before Interest and Taxes | (£4,191) | (£2,780) | (£2,262) | £175 | £997 | £396 | (£806) | (£878) | (£528) | (£819) | (£308) | (£464) | |
| EBITDA | (£3,691) | (£2,280) | (£1,762) | £675 | £1,497 | £896 | (£306) | (£378) | (£28) | (£319) | £192 | £37 | |
| Interest Expense | £414 | £412 | £409 | £407 | £404 | £402 | £399 | £397 | £394 | £392 | £389 | £387 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£4,606) | (£3,192) | (£2,671) | (£232) | £593 | (£5) | (£1,205) | (£1,275) | (£922) | (£1,211) | (£697) | (£850) | |
| Net Profit/Sales | -21.00% | -12.31% | -9.63% | -0.69% | 1.61% | -0.01% | -3.72% | -4.06% | -2.89% | -3.89% | -2.13% | -2.60% | |
| 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 | £21,931 | £25,940 | £27,731 | £33,786 | £36,742 | £36,066 | £32,406 | £31,432 | £31,906 | £31,112 | £32,664 | £32,665 | |
| Subtotal Cash from Operations | £21,931 | £25,940 | £27,731 | £33,786 | £36,742 | £36,066 | £32,406 | £31,432 | £31,906 | £31,112 | £32,664 | £32,665 | |
| 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 | £21,931 | £25,940 | £27,731 | £33,786 | £36,742 | £36,066 | £32,406 | £31,432 | £31,906 | £31,112 | £32,664 | £32,665 | |
| 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 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | £7,600 | |
| Bill Payments | £167 | £5,024 | £5,022 | £5,019 | £5,549 | £21,223 | £27,719 | £22,835 | £23,656 | £24,825 | £23,761 | £26,378 | |
| Subtotal Spent on Operations | £7,767 | £12,624 | £12,622 | £12,619 | £13,149 | £28,823 | £35,319 | £30,435 | £31,256 | £32,425 | £31,361 | £33,978 | |
| 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 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| 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 | £30,000 | £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 | £38,067 | £12,924 | £12,922 | £12,919 | £13,449 | £29,123 | £35,619 | £30,735 | £31,556 | £32,725 | £31,661 | £34,278 | |
| Net Cash Flow | (£16,137) | £13,016 | £14,810 | £20,867 | £23,293 | £6,943 | (£3,213) | £697 | £349 | (£1,613) | £1,003 | (£1,613) | |
| Cash Balance | £41,963 | £54,979 | £69,788 | £90,656 | £113,949 | £120,891 | £117,678 | £118,375 | £118,724 | £117,112 | £118,115 | £116,502 | |
| 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 | £58,100 | £41,963 | £54,979 | £69,788 | £90,656 | £113,949 | £120,891 | £117,678 | £118,375 | £118,724 | £117,112 | £118,115 | £116,502 |
| Inventory | £100,000 | £86,588 | £70,578 | £53,295 | £32,393 | £25,338 | £25,255 | £22,552 | £21,560 | £21,696 | £21,143 | £22,288 | £22,460 |
| Other Current Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Total Current Assets | £163,100 | £133,551 | £130,557 | £128,083 | £128,049 | £144,287 | £151,146 | £145,230 | £144,935 | £145,421 | £143,255 | £145,402 | £143,962 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £30,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 |
| Accumulated Depreciation | £0 | £500 | £1,000 | £1,500 | £2,000 | £2,500 | £3,000 | £3,500 | £4,000 | £4,500 | £5,000 | £5,500 | £6,000 |
| Total Long-term Assets | £30,000 | £59,500 | £59,000 | £58,500 | £58,000 | £57,500 | £57,000 | £56,500 | £56,000 | £55,500 | £55,000 | £54,500 | £54,000 |
| Total Assets | £193,100 | £193,051 | £189,557 | £186,583 | £186,049 | £201,787 | £208,146 | £201,730 | £200,935 | £200,921 | £198,255 | £199,902 | £197,962 |
| 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 | £4,857 | £4,854 | £4,852 | £4,849 | £20,294 | £26,959 | £22,048 | £22,828 | £24,036 | £22,881 | £25,525 | £24,735 |
| Current Borrowing | £50,000 | £49,700 | £49,400 | £49,100 | £48,800 | £48,500 | £48,200 | £47,900 | £47,600 | £47,300 | £47,000 | £46,700 | £46,400 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £50,000 | £54,557 | £54,254 | £53,952 | £53,649 | £68,794 | £75,159 | £69,948 | £70,428 | £71,336 | £69,881 | £72,225 | £71,135 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £50,000 | £54,557 | £54,254 | £53,952 | £53,649 | £68,794 | £75,159 | £69,948 | £70,428 | £71,336 | £69,881 | £72,225 | £71,135 |
| Paid-in Capital | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 |
| Retained Earnings | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) | (£6,900) |
| Earnings | £0 | (£4,606) | (£7,797) | (£10,468) | (£10,700) | (£10,107) | (£10,112) | (£11,318) | (£12,592) | (£13,515) | (£14,726) | (£15,422) | (£16,273) |
| Total Capital | £143,100 | £138,494 | £135,303 | £132,632 | £132,400 | £132,993 | £132,988 | £131,782 | £130,508 | £129,585 | £128,374 | £127,678 | £126,827 |
| Total Liabilities and Capital | £193,100 | £193,051 | £189,557 | £186,583 | £186,049 | £201,787 | £208,146 | £201,730 | £200,935 | £200,921 | £198,255 | £199,902 | £197,962 |
| Net Worth | £143,100 | £138,494 | £135,303 | £132,632 | £132,400 | £132,993 | £132,988 | £131,782 | £130,508 | £129,585 | £128,374 | £127,678 | £126,827 |