| 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 | |||||||||||||
| Lingerie | 0% | £27,930 | £36,400 | £37,450 | £54,964 | £25,844 | £36,960 | £39,312 | £38,220 | £38,584 | £34,944 | £31,150 | £37,800 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £27,930 | £36,400 | £37,450 | £54,964 | £25,844 | £36,960 | £39,312 | £38,220 | £38,584 | £34,944 | £31,150 | £37,800 | |
| 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 | |
| Lingerie cost | £13,965 | £18,200 | £18,725 | £27,482 | £12,922 | £18,480 | £19,656 | £19,110 | £19,292 | £17,472 | £15,575 | £18,900 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £13,965 | £18,200 | £18,725 | £27,482 | £12,922 | £18,480 | £19,656 | £19,110 | £19,292 | £17,472 | £15,575 | £18,900 | |
| 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 | ||
| Terry Levine--CEO | 0% | £2,292 | £4,583 | £4,583 | £4,583 | £4,583 | £4,583 | £4,583 | £4,583 | £4,583 | £4,583 | £4,583 | £4,583 |
| Manager | 0% | £3,010 | £2,520 | £2,520 | £3,010 | £2,520 | £2,520 | £2,520 | £2,520 | £2,520 | £2,520 | £2,520 | £2,520 |
| Salespeople | 0% | £720 | £1,440 | £1,440 | £1,600 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 |
| Total People | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £6,022 | £8,543 | £8,543 | £9,193 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | |
| 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 | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | |
| Long-term Interest Rate | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.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 | £27,930 | £36,400 | £37,450 | £54,964 | £25,844 | £36,960 | £39,312 | £38,220 | £38,584 | £34,944 | £31,150 | £37,800 | |
| Direct Cost of Sales | £13,965 | £18,200 | £18,725 | £27,482 | £12,922 | £18,480 | £19,656 | £19,110 | £19,292 | £17,472 | £15,575 | £18,900 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £13,965 | £18,200 | £18,725 | £27,482 | £12,922 | £18,480 | £19,656 | £19,110 | £19,292 | £17,472 | £15,575 | £18,900 | |
| Gross Margin | £13,965 | £18,200 | £18,725 | £27,482 | £12,922 | £18,480 | £19,656 | £19,110 | £19,292 | £17,472 | £15,575 | £18,900 | |
| 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 | £6,022 | £8,543 | £8,543 | £9,193 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | |
| Marketing and Advertising | £3,025 | £2,025 | £2,025 | £5,000 | £2,315 | £2,600 | £1,735 | £580 | £1,735 | £2,850 | £290 | £2,315 | |
| Depreciation | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Start-up inventory amortization | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | |
| Packaging | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Cell Phone | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Travel | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Utilities | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Merchandiser | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Buying Consultant | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Web Design | £0 | £0 | £0 | £0 | £1,000 | £60 | £60 | £60 | £60 | £60 | £60 | £60 | |
| Insurance | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | |
| Credit Card Fees | 15% | £642 | £837 | £861 | £1,264 | £594 | £850 | £904 | £879 | £887 | £804 | £716 | £869 |
| Accountant | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Total Operating Expenses | £15,397 | £17,113 | £17,137 | £21,165 | £18,160 | £17,761 | £16,950 | £15,770 | £16,933 | £17,965 | £15,317 | £17,495 | |
| Profit Before Interest and Taxes | (£1,432) | £1,087 | £1,588 | £6,317 | (£5,238) | £719 | £2,706 | £3,340 | £2,359 | (£493) | £258 | £1,405 | |
| EBITDA | (£1,182) | £1,337 | £1,838 | £6,567 | (£4,988) | £969 | £2,956 | £3,590 | £2,609 | (£243) | £508 | £1,655 | |
| Interest Expense | £1,119 | £1,113 | £1,107 | £1,101 | £1,095 | £1,089 | £1,082 | £1,076 | £1,070 | £1,064 | £1,057 | £1,051 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£2,551) | (£26) | £481 | £5,216 | (£6,333) | (£370) | £1,623 | £2,264 | £1,289 | (£1,556) | (£800) | £354 | |
| Net Profit/Sales | -9.14% | -0.07% | 1.28% | 9.49% | -24.51% | -1.00% | 4.13% | 5.92% | 3.34% | -4.45% | -2.57% | 0.94% | |
| 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 | £27,930 | £36,400 | £37,450 | £54,964 | £25,844 | £36,960 | £39,312 | £38,220 | £38,584 | £34,944 | £31,150 | £37,800 | |
| Subtotal Cash from Operations | £27,930 | £36,400 | £37,450 | £54,964 | £25,844 | £36,960 | £39,312 | £38,220 | £38,584 | £34,944 | £31,150 | £37,800 | |
| 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 | £27,930 | £36,400 | £37,450 | £54,964 | £25,844 | £36,960 | £39,312 | £38,220 | £38,584 | £34,944 | £31,150 | £37,800 | |
| 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 | £6,022 | £8,543 | £8,543 | £9,193 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | |
| Bill Payments | £341 | £10,217 | £9,434 | £9,851 | £21,060 | £11,165 | £31,511 | £30,068 | £26,634 | £28,603 | £25,551 | £21,445 | |
| Subtotal Spent on Operations | £6,363 | £18,760 | £17,977 | £19,044 | £29,603 | £19,708 | £40,054 | £38,611 | £35,177 | £37,146 | £34,094 | £29,988 | |
| 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 | £792 | £798 | £804 | £810 | £816 | £822 | £829 | £835 | £841 | £847 | £854 | £860 | |
| 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 | £7,155 | £19,558 | £18,781 | £19,854 | £30,419 | £20,530 | £40,883 | £39,446 | £36,018 | £37,993 | £34,948 | £30,848 | |
| Net Cash Flow | £20,775 | £16,842 | £18,669 | £35,110 | (£4,575) | £16,430 | (£1,571) | (£1,226) | £2,566 | (£3,049) | (£3,798) | £6,952 | |
| Cash Balance | £38,975 | £55,816 | £74,485 | £109,596 | £105,021 | £121,450 | £119,879 | £118,653 | £121,219 | £118,170 | £114,373 | £121,325 | |
| 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,200 | £38,975 | £55,816 | £74,485 | £109,596 | £105,021 | £121,450 | £119,879 | £118,653 | £121,219 | £118,170 | £114,373 | £121,325 |
| Inventory | £100,000 | £86,035 | £67,835 | £49,110 | £30,230 | £17,308 | £20,328 | £21,622 | £21,021 | £21,221 | £19,219 | £17,133 | £20,790 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £118,200 | £125,010 | £123,651 | £123,595 | £139,826 | £122,329 | £141,778 | £141,501 | £139,674 | £142,440 | £137,390 | £131,505 | £142,115 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Accumulated Depreciation | £0 | £250 | £500 | £750 | £1,000 | £1,250 | £1,500 | £1,750 | £2,000 | £2,250 | £2,500 | £2,750 | £3,000 |
| Total Long-term Assets | £15,000 | £14,750 | £14,500 | £14,250 | £14,000 | £13,750 | £13,500 | £13,250 | £13,000 | £12,750 | £12,500 | £12,250 | £12,000 |
| Total Assets | £133,200 | £139,760 | £138,151 | £137,845 | £153,826 | £136,079 | £155,278 | £154,751 | £152,674 | £155,190 | £149,890 | £143,755 | £154,115 |
| 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 | £9,903 | £9,119 | £9,136 | £20,711 | £10,114 | £30,505 | £29,183 | £25,677 | £27,746 | £24,848 | £20,368 | £31,234 |
| 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 | £9,903 | £9,119 | £9,136 | £20,711 | £10,114 | £30,505 | £29,183 | £25,677 | £27,746 | £24,848 | £20,368 | £31,234 |
| Long-term Liabilities | £150,000 | £149,208 | £148,410 | £147,606 | £146,796 | £145,980 | £145,158 | £144,329 | £143,494 | £142,653 | £141,806 | £140,952 | £140,092 |
| Total Liabilities | £150,000 | £159,111 | £157,529 | £156,742 | £167,507 | £156,094 | £175,663 | £173,512 | £169,171 | £170,399 | £166,654 | £161,320 | £171,326 |
| Paid-in Capital | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 |
| Retained Earnings | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) |
| Earnings | £0 | (£2,551) | (£2,578) | (£2,097) | £3,119 | (£3,215) | (£3,584) | (£1,961) | £303 | £1,591 | £35 | (£764) | (£410) |
| Total Capital | (£16,800) | (£19,351) | (£19,378) | (£18,897) | (£13,681) | (£20,015) | (£20,384) | (£18,761) | (£16,497) | (£15,209) | (£16,765) | (£17,564) | (£17,210) |
| Total Liabilities and Capital | £133,200 | £139,760 | £138,151 | £137,845 | £153,826 | £136,079 | £155,278 | £154,751 | £152,674 | £155,190 | £149,890 | £143,755 | £154,115 |
| Net Worth | (£16,800) | (£19,351) | (£19,378) | (£18,897) | (£13,681) | (£20,015) | (£20,384) | (£18,761) | (£16,497) | (£15,209) | (£16,765) | (£17,564) | (£17,210) |
| 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 | |||||||||||||
| Lingerie | 0% | £27,930 | £36,400 | £37,450 | £54,964 | £25,844 | £36,960 | £39,312 | £38,220 | £38,584 | £34,944 | £31,150 | £37,800 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £27,930 | £36,400 | £37,450 | £54,964 | £25,844 | £36,960 | £39,312 | £38,220 | £38,584 | £34,944 | £31,150 | £37,800 | |
| 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 | |
| Lingerie cost | £13,965 | £18,200 | £18,725 | £27,482 | £12,922 | £18,480 | £19,656 | £19,110 | £19,292 | £17,472 | £15,575 | £18,900 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £13,965 | £18,200 | £18,725 | £27,482 | £12,922 | £18,480 | £19,656 | £19,110 | £19,292 | £17,472 | £15,575 | £18,900 | |
| 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 | ||
| Terry Levine--CEO | 0% | £2,292 | £4,583 | £4,583 | £4,583 | £4,583 | £4,583 | £4,583 | £4,583 | £4,583 | £4,583 | £4,583 | £4,583 |
| Manager | 0% | £3,010 | £2,520 | £2,520 | £3,010 | £2,520 | £2,520 | £2,520 | £2,520 | £2,520 | £2,520 | £2,520 | £2,520 |
| Salespeople | 0% | £720 | £1,440 | £1,440 | £1,600 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 |
| Total People | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £6,022 | £8,543 | £8,543 | £9,193 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | |
| 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 | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | |
| Long-term Interest Rate | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.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 | £27,930 | £36,400 | £37,450 | £54,964 | £25,844 | £36,960 | £39,312 | £38,220 | £38,584 | £34,944 | £31,150 | £37,800 | |
| Direct Cost of Sales | £13,965 | £18,200 | £18,725 | £27,482 | £12,922 | £18,480 | £19,656 | £19,110 | £19,292 | £17,472 | £15,575 | £18,900 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £13,965 | £18,200 | £18,725 | £27,482 | £12,922 | £18,480 | £19,656 | £19,110 | £19,292 | £17,472 | £15,575 | £18,900 | |
| Gross Margin | £13,965 | £18,200 | £18,725 | £27,482 | £12,922 | £18,480 | £19,656 | £19,110 | £19,292 | £17,472 | £15,575 | £18,900 | |
| 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 | £6,022 | £8,543 | £8,543 | £9,193 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | |
| Marketing and Advertising | £3,025 | £2,025 | £2,025 | £5,000 | £2,315 | £2,600 | £1,735 | £580 | £1,735 | £2,850 | £290 | £2,315 | |
| Depreciation | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Start-up inventory amortization | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | |
| Packaging | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Cell Phone | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Travel | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Utilities | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Merchandiser | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Buying Consultant | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Web Design | £0 | £0 | £0 | £0 | £1,000 | £60 | £60 | £60 | £60 | £60 | £60 | £60 | |
| Insurance | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | |
| Credit Card Fees | 15% | £642 | £837 | £861 | £1,264 | £594 | £850 | £904 | £879 | £887 | £804 | £716 | £869 |
| Accountant | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Total Operating Expenses | £15,397 | £17,113 | £17,137 | £21,165 | £18,160 | £17,761 | £16,950 | £15,770 | £16,933 | £17,965 | £15,317 | £17,495 | |
| Profit Before Interest and Taxes | (£1,432) | £1,087 | £1,588 | £6,317 | (£5,238) | £719 | £2,706 | £3,340 | £2,359 | (£493) | £258 | £1,405 | |
| EBITDA | (£1,182) | £1,337 | £1,838 | £6,567 | (£4,988) | £969 | £2,956 | £3,590 | £2,609 | (£243) | £508 | £1,655 | |
| Interest Expense | £1,119 | £1,113 | £1,107 | £1,101 | £1,095 | £1,089 | £1,082 | £1,076 | £1,070 | £1,064 | £1,057 | £1,051 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£2,551) | (£26) | £481 | £5,216 | (£6,333) | (£370) | £1,623 | £2,264 | £1,289 | (£1,556) | (£800) | £354 | |
| Net Profit/Sales | -9.14% | -0.07% | 1.28% | 9.49% | -24.51% | -1.00% | 4.13% | 5.92% | 3.34% | -4.45% | -2.57% | 0.94% | |
| 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 | £27,930 | £36,400 | £37,450 | £54,964 | £25,844 | £36,960 | £39,312 | £38,220 | £38,584 | £34,944 | £31,150 | £37,800 | |
| Subtotal Cash from Operations | £27,930 | £36,400 | £37,450 | £54,964 | £25,844 | £36,960 | £39,312 | £38,220 | £38,584 | £34,944 | £31,150 | £37,800 | |
| 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 | £27,930 | £36,400 | £37,450 | £54,964 | £25,844 | £36,960 | £39,312 | £38,220 | £38,584 | £34,944 | £31,150 | £37,800 | |
| 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 | £6,022 | £8,543 | £8,543 | £9,193 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | £8,543 | |
| Bill Payments | £341 | £10,217 | £9,434 | £9,851 | £21,060 | £11,165 | £31,511 | £30,068 | £26,634 | £28,603 | £25,551 | £21,445 | |
| Subtotal Spent on Operations | £6,363 | £18,760 | £17,977 | £19,044 | £29,603 | £19,708 | £40,054 | £38,611 | £35,177 | £37,146 | £34,094 | £29,988 | |
| 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 | £792 | £798 | £804 | £810 | £816 | £822 | £829 | £835 | £841 | £847 | £854 | £860 | |
| 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 | £7,155 | £19,558 | £18,781 | £19,854 | £30,419 | £20,530 | £40,883 | £39,446 | £36,018 | £37,993 | £34,948 | £30,848 | |
| Net Cash Flow | £20,775 | £16,842 | £18,669 | £35,110 | (£4,575) | £16,430 | (£1,571) | (£1,226) | £2,566 | (£3,049) | (£3,798) | £6,952 | |
| Cash Balance | £38,975 | £55,816 | £74,485 | £109,596 | £105,021 | £121,450 | £119,879 | £118,653 | £121,219 | £118,170 | £114,373 | £121,325 | |
| 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,200 | £38,975 | £55,816 | £74,485 | £109,596 | £105,021 | £121,450 | £119,879 | £118,653 | £121,219 | £118,170 | £114,373 | £121,325 |
| Inventory | £100,000 | £86,035 | £67,835 | £49,110 | £30,230 | £17,308 | £20,328 | £21,622 | £21,021 | £21,221 | £19,219 | £17,133 | £20,790 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £118,200 | £125,010 | £123,651 | £123,595 | £139,826 | £122,329 | £141,778 | £141,501 | £139,674 | £142,440 | £137,390 | £131,505 | £142,115 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Accumulated Depreciation | £0 | £250 | £500 | £750 | £1,000 | £1,250 | £1,500 | £1,750 | £2,000 | £2,250 | £2,500 | £2,750 | £3,000 |
| Total Long-term Assets | £15,000 | £14,750 | £14,500 | £14,250 | £14,000 | £13,750 | £13,500 | £13,250 | £13,000 | £12,750 | £12,500 | £12,250 | £12,000 |
| Total Assets | £133,200 | £139,760 | £138,151 | £137,845 | £153,826 | £136,079 | £155,278 | £154,751 | £152,674 | £155,190 | £149,890 | £143,755 | £154,115 |
| 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 | £9,903 | £9,119 | £9,136 | £20,711 | £10,114 | £30,505 | £29,183 | £25,677 | £27,746 | £24,848 | £20,368 | £31,234 |
| 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 | £9,903 | £9,119 | £9,136 | £20,711 | £10,114 | £30,505 | £29,183 | £25,677 | £27,746 | £24,848 | £20,368 | £31,234 |
| Long-term Liabilities | £150,000 | £149,208 | £148,410 | £147,606 | £146,796 | £145,980 | £145,158 | £144,329 | £143,494 | £142,653 | £141,806 | £140,952 | £140,092 |
| Total Liabilities | £150,000 | £159,111 | £157,529 | £156,742 | £167,507 | £156,094 | £175,663 | £173,512 | £169,171 | £170,399 | £166,654 | £161,320 | £171,326 |
| Paid-in Capital | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 | £21,750 |
| Retained Earnings | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) | (£38,550) |
| Earnings | £0 | (£2,551) | (£2,578) | (£2,097) | £3,119 | (£3,215) | (£3,584) | (£1,961) | £303 | £1,591 | £35 | (£764) | (£410) |
| Total Capital | (£16,800) | (£19,351) | (£19,378) | (£18,897) | (£13,681) | (£20,015) | (£20,384) | (£18,761) | (£16,497) | (£15,209) | (£16,765) | (£17,564) | (£17,210) |
| Total Liabilities and Capital | £133,200 | £139,760 | £138,151 | £137,845 | £153,826 | £136,079 | £155,278 | £154,751 | £152,674 | £155,190 | £149,890 | £143,755 | £154,115 |
| Net Worth | (£16,800) | (£19,351) | (£19,378) | (£18,897) | (£13,681) | (£20,015) | (£20,384) | (£18,761) | (£16,497) | (£15,209) | (£16,765) | (£17,564) | (£17,210) |