| 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 | |||||||||||||
| Apparel | 0% | £2,720 | £2,747 | £2,775 | £2,802 | £2,830 | £2,859 | £2,887 | £2,916 | £2,945 | £2,975 | £3,005 | £3,035 |
| Stationary | 0% | £950 | £960 | £969 | £979 | £989 | £998 | £1,008 | £1,019 | £1,029 | £1,039 | £1,049 | £1,060 |
| Novelty | 0% | £1,750 | £1,768 | £1,785 | £1,803 | £1,821 | £1,839 | £1,858 | £1,876 | £1,895 | £1,914 | £1,933 | £1,952 |
| Accessories | 0% | £800 | £808 | £816 | £824 | £832 | £841 | £849 | £858 | £866 | £875 | £884 | £893 |
| Traditional Arts & Crafts | 0% | £300 | £303 | £306 | £309 | £312 | £315 | £318 | £322 | £325 | £328 | £331 | £335 |
| Books & Magazines | 0% | £400 | £404 | £408 | £412 | £416 | £420 | £425 | £429 | £433 | £437 | £442 | £446 |
| Others | 0% | £200 | £202 | £204 | £206 | £208 | £210 | £212 | £214 | £217 | £219 | £221 | £223 |
| Total Sales | £7,120 | £7,191 | £7,263 | £7,336 | £7,409 | £7,483 | £7,558 | £7,634 | £7,710 | £7,787 | £7,865 | £7,944 | |
| 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 | |
| Apparel | £805 | £805 | £805 | £805 | £805 | £805 | £805 | £805 | £805 | £805 | £805 | £805 | |
| Stationary | £281 | £281 | £281 | £281 | £281 | £281 | £281 | £281 | £281 | £281 | £281 | £281 | |
| Novelty | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | |
| Accessory | £237 | £237 | £237 | £237 | £237 | £237 | £237 | £237 | £237 | £237 | £237 | £237 | |
| Traditional Arts & Crafts | £89 | £89 | £89 | £89 | £89 | £89 | £89 | £89 | £89 | £89 | £89 | £89 | |
| Books & Magazines | £118 | £118 | £118 | £118 | £118 | £118 | £118 | £118 | £118 | £118 | £118 | £118 | |
| Others | £59 | £59 | £59 | £59 | £59 | £59 | £59 | £59 | £59 | £59 | £59 | £59 | |
| Subtotal Direct Cost of Sales | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | |
| 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 | ||
| Store Staff | 0% | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 |
| Marketing/Store Manager | 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 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| 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 | £7,120 | £7,191 | £7,263 | £7,336 | £7,409 | £7,483 | £7,558 | £7,634 | £7,710 | £7,787 | £7,865 | £7,944 | |
| Direct Cost of Sales | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | |
| Gross Margin | £5,013 | £5,084 | £5,156 | £5,229 | £5,302 | £5,376 | £5,451 | £5,527 | £5,603 | £5,680 | £5,758 | £5,837 | |
| Gross Margin % | 70.41% | 70.70% | 70.99% | 71.28% | 71.56% | 71.85% | 72.12% | 72.40% | 72.67% | 72.94% | 73.21% | 73.48% | |
| Expenses | |||||||||||||
| Payroll | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Marketing/Promotion | £376 | £376 | £376 | £376 | £376 | £376 | £376 | £376 | £376 | £376 | £376 | £376 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | |
| Utilities | 15% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Other | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Operating Expenses | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | |
| Profit Before Interest and Taxes | (£763) | (£692) | (£620) | (£547) | (£474) | (£400) | (£325) | (£249) | (£173) | (£96) | (£18) | £60 | |
| EBITDA | (£763) | (£692) | (£620) | (£547) | (£474) | (£400) | (£325) | (£249) | (£173) | (£96) | (£18) | £60 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£763) | (£692) | (£620) | (£547) | (£474) | (£400) | (£325) | (£249) | (£173) | (£96) | (£18) | £60 | |
| Net Profit/Sales | -10.71% | -9.62% | -8.54% | -7.46% | -6.40% | -5.34% | -4.30% | -3.27% | -2.25% | -1.23% | -0.23% | 0.76% | |
| 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 | £7,120 | £7,191 | £7,263 | £7,336 | £7,409 | £7,483 | £7,558 | £7,634 | £7,710 | £7,787 | £7,865 | £7,944 | |
| Subtotal Cash from Operations | £7,120 | £7,191 | £7,263 | £7,336 | £7,409 | £7,483 | £7,558 | £7,634 | £7,710 | £7,787 | £7,865 | £7,944 | |
| 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 | £7,120 | £7,191 | £7,263 | £7,336 | £7,409 | £7,483 | £7,558 | £7,634 | £7,710 | £7,787 | £7,865 | £7,944 | |
| 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 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Bill Payments | £133 | £3,976 | £3,976 | £3,976 | £3,976 | £3,976 | £3,976 | £3,976 | £3,976 | £3,976 | £4,504 | £19,288 | |
| Subtotal Spent on Operations | £1,933 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £6,304 | £21,088 | |
| 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 | £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 | £1,933 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £6,304 | £21,088 | |
| Net Cash Flow | £5,187 | £1,415 | £1,487 | £1,559 | £1,633 | £1,707 | £1,782 | £1,857 | £1,934 | £2,011 | £1,561 | (£13,145) | |
| Cash Balance | £74,502 | £75,918 | £77,405 | £78,964 | £80,597 | £82,304 | £84,086 | £85,943 | £87,877 | £89,887 | £91,448 | £78,303 | |
| 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 | £69,315 | £74,502 | £75,918 | £77,405 | £78,964 | £80,597 | £82,304 | £84,086 | £85,943 | £87,877 | £89,887 | £91,448 | £78,303 |
| Inventory | £25,282 | £23,175 | £21,068 | £18,962 | £16,855 | £14,748 | £12,641 | £10,534 | £8,427 | £6,321 | £4,214 | £17,947 | £15,840 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £94,597 | £97,678 | £96,986 | £96,366 | £95,819 | £95,345 | £94,945 | £94,620 | £94,370 | £94,197 | £94,101 | £109,395 | £94,143 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £94,597 | £97,678 | £96,986 | £96,366 | £95,819 | £95,345 | £94,945 | £94,620 | £94,370 | £94,197 | £94,101 | £109,395 | £94,143 |
| 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 | £3,843 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £19,156 | £3,844 |
| 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 | £3,843 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £19,156 | £3,844 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £3,843 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £19,156 | £3,844 |
| Paid-in Capital | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 |
| Retained Earnings | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) |
| Earnings | £0 | (£763) | (£1,455) | (£2,075) | (£2,622) | (£3,096) | (£3,496) | (£3,821) | (£4,070) | (£4,244) | (£4,340) | (£4,358) | (£4,297) |
| Total Capital | £94,597 | £93,834 | £93,142 | £92,522 | £91,975 | £91,501 | £91,101 | £90,776 | £90,527 | £90,353 | £90,257 | £90,239 | £90,300 |
| Total Liabilities and Capital | £94,597 | £97,678 | £96,986 | £96,366 | £95,819 | £95,345 | £94,945 | £94,620 | £94,370 | £94,197 | £94,101 | £109,395 | £94,143 |
| Net Worth | £94,597 | £93,834 | £93,142 | £92,522 | £91,975 | £91,501 | £91,101 | £90,776 | £90,527 | £90,353 | £90,257 | £90,239 | £90,300 |
| 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 | |||||||||||||
| Apparel | 0% | £2,720 | £2,747 | £2,775 | £2,802 | £2,830 | £2,859 | £2,887 | £2,916 | £2,945 | £2,975 | £3,005 | £3,035 |
| Stationary | 0% | £950 | £960 | £969 | £979 | £989 | £998 | £1,008 | £1,019 | £1,029 | £1,039 | £1,049 | £1,060 |
| Novelty | 0% | £1,750 | £1,768 | £1,785 | £1,803 | £1,821 | £1,839 | £1,858 | £1,876 | £1,895 | £1,914 | £1,933 | £1,952 |
| Accessories | 0% | £800 | £808 | £816 | £824 | £832 | £841 | £849 | £858 | £866 | £875 | £884 | £893 |
| Traditional Arts & Crafts | 0% | £300 | £303 | £306 | £309 | £312 | £315 | £318 | £322 | £325 | £328 | £331 | £335 |
| Books & Magazines | 0% | £400 | £404 | £408 | £412 | £416 | £420 | £425 | £429 | £433 | £437 | £442 | £446 |
| Others | 0% | £200 | £202 | £204 | £206 | £208 | £210 | £212 | £214 | £217 | £219 | £221 | £223 |
| Total Sales | £7,120 | £7,191 | £7,263 | £7,336 | £7,409 | £7,483 | £7,558 | £7,634 | £7,710 | £7,787 | £7,865 | £7,944 | |
| 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 | |
| Apparel | £805 | £805 | £805 | £805 | £805 | £805 | £805 | £805 | £805 | £805 | £805 | £805 | |
| Stationary | £281 | £281 | £281 | £281 | £281 | £281 | £281 | £281 | £281 | £281 | £281 | £281 | |
| Novelty | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | |
| Accessory | £237 | £237 | £237 | £237 | £237 | £237 | £237 | £237 | £237 | £237 | £237 | £237 | |
| Traditional Arts & Crafts | £89 | £89 | £89 | £89 | £89 | £89 | £89 | £89 | £89 | £89 | £89 | £89 | |
| Books & Magazines | £118 | £118 | £118 | £118 | £118 | £118 | £118 | £118 | £118 | £118 | £118 | £118 | |
| Others | £59 | £59 | £59 | £59 | £59 | £59 | £59 | £59 | £59 | £59 | £59 | £59 | |
| Subtotal Direct Cost of Sales | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | |
| 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 | ||
| Store Staff | 0% | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 |
| Marketing/Store Manager | 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 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| 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 | £7,120 | £7,191 | £7,263 | £7,336 | £7,409 | £7,483 | £7,558 | £7,634 | £7,710 | £7,787 | £7,865 | £7,944 | |
| Direct Cost of Sales | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | £2,107 | |
| Gross Margin | £5,013 | £5,084 | £5,156 | £5,229 | £5,302 | £5,376 | £5,451 | £5,527 | £5,603 | £5,680 | £5,758 | £5,837 | |
| Gross Margin % | 70.41% | 70.70% | 70.99% | 71.28% | 71.56% | 71.85% | 72.12% | 72.40% | 72.67% | 72.94% | 73.21% | 73.48% | |
| Expenses | |||||||||||||
| Payroll | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Marketing/Promotion | £376 | £376 | £376 | £376 | £376 | £376 | £376 | £376 | £376 | £376 | £376 | £376 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | |
| Utilities | 15% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Other | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Operating Expenses | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | |
| Profit Before Interest and Taxes | (£763) | (£692) | (£620) | (£547) | (£474) | (£400) | (£325) | (£249) | (£173) | (£96) | (£18) | £60 | |
| EBITDA | (£763) | (£692) | (£620) | (£547) | (£474) | (£400) | (£325) | (£249) | (£173) | (£96) | (£18) | £60 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£763) | (£692) | (£620) | (£547) | (£474) | (£400) | (£325) | (£249) | (£173) | (£96) | (£18) | £60 | |
| Net Profit/Sales | -10.71% | -9.62% | -8.54% | -7.46% | -6.40% | -5.34% | -4.30% | -3.27% | -2.25% | -1.23% | -0.23% | 0.76% | |
| 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 | £7,120 | £7,191 | £7,263 | £7,336 | £7,409 | £7,483 | £7,558 | £7,634 | £7,710 | £7,787 | £7,865 | £7,944 | |
| Subtotal Cash from Operations | £7,120 | £7,191 | £7,263 | £7,336 | £7,409 | £7,483 | £7,558 | £7,634 | £7,710 | £7,787 | £7,865 | £7,944 | |
| 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 | £7,120 | £7,191 | £7,263 | £7,336 | £7,409 | £7,483 | £7,558 | £7,634 | £7,710 | £7,787 | £7,865 | £7,944 | |
| 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 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Bill Payments | £133 | £3,976 | £3,976 | £3,976 | £3,976 | £3,976 | £3,976 | £3,976 | £3,976 | £3,976 | £4,504 | £19,288 | |
| Subtotal Spent on Operations | £1,933 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £6,304 | £21,088 | |
| 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 | £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 | £1,933 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £5,776 | £6,304 | £21,088 | |
| Net Cash Flow | £5,187 | £1,415 | £1,487 | £1,559 | £1,633 | £1,707 | £1,782 | £1,857 | £1,934 | £2,011 | £1,561 | (£13,145) | |
| Cash Balance | £74,502 | £75,918 | £77,405 | £78,964 | £80,597 | £82,304 | £84,086 | £85,943 | £87,877 | £89,887 | £91,448 | £78,303 | |
| 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 | £69,315 | £74,502 | £75,918 | £77,405 | £78,964 | £80,597 | £82,304 | £84,086 | £85,943 | £87,877 | £89,887 | £91,448 | £78,303 |
| Inventory | £25,282 | £23,175 | £21,068 | £18,962 | £16,855 | £14,748 | £12,641 | £10,534 | £8,427 | £6,321 | £4,214 | £17,947 | £15,840 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £94,597 | £97,678 | £96,986 | £96,366 | £95,819 | £95,345 | £94,945 | £94,620 | £94,370 | £94,197 | £94,101 | £109,395 | £94,143 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £94,597 | £97,678 | £96,986 | £96,366 | £95,819 | £95,345 | £94,945 | £94,620 | £94,370 | £94,197 | £94,101 | £109,395 | £94,143 |
| 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 | £3,843 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £19,156 | £3,844 |
| 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 | £3,843 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £19,156 | £3,844 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £3,843 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £3,844 | £19,156 | £3,844 |
| Paid-in Capital | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 | £166,597 |
| Retained Earnings | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) | (£72,000) |
| Earnings | £0 | (£763) | (£1,455) | (£2,075) | (£2,622) | (£3,096) | (£3,496) | (£3,821) | (£4,070) | (£4,244) | (£4,340) | (£4,358) | (£4,297) |
| Total Capital | £94,597 | £93,834 | £93,142 | £92,522 | £91,975 | £91,501 | £91,101 | £90,776 | £90,527 | £90,353 | £90,257 | £90,239 | £90,300 |
| Total Liabilities and Capital | £94,597 | £97,678 | £96,986 | £96,366 | £95,819 | £95,345 | £94,945 | £94,620 | £94,370 | £94,197 | £94,101 | £109,395 | £94,143 |
| Net Worth | £94,597 | £93,834 | £93,142 | £92,522 | £91,975 | £91,501 | £91,101 | £90,776 | £90,527 | £90,353 | £90,257 | £90,239 | £90,300 |