| 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 | |||||||||||||
| Painting Supplies | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Drawing/Illustration | 0% | £200 | £200 | £200 | £200 | £300 | £300 | £200 | £200 | £200 | £200 | £200 | £200 |
| Books/Media | 0% | £500 | £500 | £500 | £500 | £1,000 | £1,000 | £500 | £500 | £500 | £500 | £500 | £500 |
| Cutting Tools | 0% | £100 | £100 | £100 | £100 | £200 | £200 | £100 | £100 | £100 | £100 | £100 | £100 |
| Adhesives | 0% | £100 | £100 | £100 | £100 | £200 | £200 | £100 | £100 | £100 | £100 | £100 | £100 |
| Glass | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £100 | £150 | £150 | £150 | £200 |
| Ceramics | 0% | £300 | £300 | £300 | £300 | £400 | £400 | £300 | £300 | £300 | £300 | £300 | £300 |
| Crafts | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £2,000 | £2,000 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Gifts/Studio Environment | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,500 | £2,500 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Print Making | 0% | £350 | £350 | £350 | £350 | £400 | £400 | £350 | £350 | £350 | £350 | £350 | £350 |
| Sculpture | 0% | £250 | £250 | £250 | £250 | £300 | £300 | £250 | £250 | £250 | £250 | £250 | £250 |
| Portfolios/Transporting | 0% | £200 | £200 | £200 | £200 | £400 | £400 | £200 | £200 | £200 | £200 | £200 | £200 |
| Gallery Sales | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Fabrics/Yarn | 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 |
| Equipment | 0% | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 |
| Clothing/Accessories | 0% | £200 | £200 | £200 | £200 | £300 | £300 | £200 | £200 | £200 | £200 | £200 | £200 |
| Paper/Boards | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Classes | 0% | £0 | £50 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 |
| Canvas/Surfaces | 0% | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 |
| Total Sales | £25,700 | £25,750 | £25,800 | £25,800 | £29,100 | £29,100 | £25,800 | £25,900 | £25,950 | £25,950 | £25,950 | £26,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 | |
| Inventory | 50% | £12,850 | £12,875 | £12,900 | £12,900 | £14,550 | £14,550 | £12,900 | £12,950 | £12,975 | £12,975 | £12,975 | £13,000 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £12,850 | £12,875 | £12,900 | £12,900 | £14,550 | £14,550 | £12,900 | £12,950 | £12,975 | £12,975 | £12,975 | £13,000 | |
| 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 | ||
| Owners | 5% | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 |
| Other | 5% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | 5% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 2 | 2 | 2 | 2 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | |
| 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 | £25,700 | £25,750 | £25,800 | £25,800 | £29,100 | £29,100 | £25,800 | £25,900 | £25,950 | £25,950 | £25,950 | £26,000 | |
| Direct Cost of Sales | £12,850 | £12,875 | £12,900 | £12,900 | £14,550 | £14,550 | £12,900 | £12,950 | £12,975 | £12,975 | £12,975 | £13,000 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £12,850 | £12,875 | £12,900 | £12,900 | £14,550 | £14,550 | £12,900 | £12,950 | £12,975 | £12,975 | £12,975 | £13,000 | |
| Gross Margin | £12,850 | £12,875 | £12,900 | £12,900 | £14,550 | £14,550 | £12,900 | £12,950 | £12,975 | £12,975 | £12,975 | £13,000 | |
| 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 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | |
| Marketing/Promotion | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Utilities | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | |
| Profit Before Interest and Taxes | £2,350 | £2,375 | £2,400 | £2,400 | £4,050 | £4,050 | £2,400 | £2,450 | £2,475 | £2,475 | £2,475 | £2,500 | |
| EBITDA | £2,350 | £2,375 | £2,400 | £2,400 | £4,050 | £4,050 | £2,400 | £2,450 | £2,475 | £2,475 | £2,475 | £2,500 | |
| Interest Expense | £1,039 | £1,028 | £1,017 | £1,006 | £995 | £984 | £973 | £963 | £952 | £941 | £930 | £919 | |
| Taxes Incurred | £393 | £404 | £415 | £418 | £916 | £920 | £428 | £446 | £457 | £460 | £464 | £474 | |
| Net Profit | £918 | £943 | £968 | £976 | £2,138 | £2,146 | £999 | £1,041 | £1,066 | £1,074 | £1,082 | £1,107 | |
| Net Profit/Sales | 3.57% | 3.66% | 3.75% | 3.78% | 7.35% | 7.37% | 3.87% | 4.02% | 4.11% | 4.14% | 4.17% | 4.26% | |
| 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 | £25,700 | £25,750 | £25,800 | £25,800 | £29,100 | £29,100 | £25,800 | £25,900 | £25,950 | £25,950 | £25,950 | £26,000 | |
| Subtotal Cash from Operations | £25,700 | £25,750 | £25,800 | £25,800 | £29,100 | £29,100 | £25,800 | £25,900 | £25,950 | £25,950 | £25,950 | £26,000 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £25,700 | £25,750 | £25,800 | £25,800 | £29,100 | £29,100 | £25,800 | £25,900 | £25,950 | £25,950 | £25,950 | £26,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 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | |
| Bill Payments | £593 | £17,842 | £19,558 | £19,573 | £19,946 | £37,411 | £20,952 | £6,730 | £16,371 | £19,625 | £19,376 | £19,377 | |
| Subtotal Spent on Operations | £6,093 | £23,342 | £25,058 | £25,073 | £25,446 | £42,911 | £26,452 | £12,230 | £21,871 | £25,125 | £24,876 | £24,877 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £2,188 | £2,188 | £2,188 | £2,188 | £2,188 | £2,188 | £2,188 | £2,188 | £2,188 | £2,188 | £2,188 | £2,188 | |
| 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 | £8,280 | £25,529 | £27,246 | £27,261 | £27,633 | £45,099 | £28,640 | £14,417 | £24,059 | £27,313 | £27,063 | £27,065 | |
| Net Cash Flow | £17,420 | £221 | (£1,446) | (£1,461) | £1,467 | (£15,999) | (£2,840) | £11,483 | £1,891 | (£1,363) | (£1,113) | (£1,065) | |
| Cash Balance | £48,470 | £48,691 | £47,245 | £45,784 | £47,251 | £31,252 | £28,412 | £39,895 | £41,786 | £40,424 | £39,310 | £38,246 | |
| 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 | £31,050 | £48,470 | £48,691 | £47,245 | £45,784 | £47,251 | £31,252 | £28,412 | £39,895 | £41,786 | £40,424 | £39,310 | £38,246 |
| Inventory | £130,000 | £128,500 | £128,750 | £129,000 | £129,000 | £145,500 | £145,500 | £132,600 | £129,500 | £129,750 | £129,750 | £129,750 | £130,000 |
| Other Current Assets | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 |
| Total Current Assets | £187,050 | £202,970 | £203,441 | £202,245 | £200,784 | £218,751 | £202,752 | £187,012 | £195,395 | £197,536 | £196,174 | £195,060 | £194,246 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 |
| Total Assets | £227,050 | £242,970 | £243,441 | £242,245 | £240,784 | £258,751 | £242,752 | £227,012 | £235,395 | £237,536 | £236,174 | £235,060 | £234,246 |
| 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 | £17,190 | £18,905 | £18,929 | £18,680 | £36,696 | £20,739 | £6,188 | £15,717 | £18,979 | £18,730 | £18,723 | £18,988 |
| 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 | £17,190 | £18,905 | £18,929 | £18,680 | £36,696 | £20,739 | £6,188 | £15,717 | £18,979 | £18,730 | £18,723 | £18,988 |
| Long-term Liabilities | £210,000 | £207,813 | £205,625 | £203,438 | £201,250 | £199,063 | £196,875 | £194,688 | £192,500 | £190,313 | £188,125 | £185,938 | £183,750 |
| Total Liabilities | £210,000 | £225,002 | £224,530 | £222,367 | £219,930 | £235,759 | £217,614 | £200,876 | £208,217 | £209,292 | £206,855 | £204,660 | £202,738 |
| Paid-in Capital | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 |
| Retained Earnings | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) |
| Earnings | £0 | £918 | £1,860 | £2,828 | £3,804 | £5,942 | £8,088 | £9,087 | £10,128 | £11,195 | £12,269 | £13,350 | £14,457 |
| Total Capital | £17,050 | £17,968 | £18,910 | £19,878 | £20,854 | £22,992 | £25,138 | £26,137 | £27,178 | £28,245 | £29,319 | £30,400 | £31,507 |
| Total Liabilities and Capital | £227,050 | £242,970 | £243,441 | £242,245 | £240,784 | £258,751 | £242,752 | £227,012 | £235,395 | £237,536 | £236,174 | £235,060 | £234,246 |
| Net Worth | £17,050 | £17,968 | £18,910 | £19,878 | £20,854 | £22,992 | £25,138 | £26,137 | £27,178 | £28,245 | £29,319 | £30,400 | £31,507 |
| 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 | |||||||||||||
| Painting Supplies | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Drawing/Illustration | 0% | £200 | £200 | £200 | £200 | £300 | £300 | £200 | £200 | £200 | £200 | £200 | £200 |
| Books/Media | 0% | £500 | £500 | £500 | £500 | £1,000 | £1,000 | £500 | £500 | £500 | £500 | £500 | £500 |
| Cutting Tools | 0% | £100 | £100 | £100 | £100 | £200 | £200 | £100 | £100 | £100 | £100 | £100 | £100 |
| Adhesives | 0% | £100 | £100 | £100 | £100 | £200 | £200 | £100 | £100 | £100 | £100 | £100 | £100 |
| Glass | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £100 | £150 | £150 | £150 | £200 |
| Ceramics | 0% | £300 | £300 | £300 | £300 | £400 | £400 | £300 | £300 | £300 | £300 | £300 | £300 |
| Crafts | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £2,000 | £2,000 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Gifts/Studio Environment | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,500 | £2,500 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Print Making | 0% | £350 | £350 | £350 | £350 | £400 | £400 | £350 | £350 | £350 | £350 | £350 | £350 |
| Sculpture | 0% | £250 | £250 | £250 | £250 | £300 | £300 | £250 | £250 | £250 | £250 | £250 | £250 |
| Portfolios/Transporting | 0% | £200 | £200 | £200 | £200 | £400 | £400 | £200 | £200 | £200 | £200 | £200 | £200 |
| Gallery Sales | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Fabrics/Yarn | 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 |
| Equipment | 0% | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 |
| Clothing/Accessories | 0% | £200 | £200 | £200 | £200 | £300 | £300 | £200 | £200 | £200 | £200 | £200 | £200 |
| Paper/Boards | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Classes | 0% | £0 | £50 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 |
| Canvas/Surfaces | 0% | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 |
| Total Sales | £25,700 | £25,750 | £25,800 | £25,800 | £29,100 | £29,100 | £25,800 | £25,900 | £25,950 | £25,950 | £25,950 | £26,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 | |
| Inventory | 50% | £12,850 | £12,875 | £12,900 | £12,900 | £14,550 | £14,550 | £12,900 | £12,950 | £12,975 | £12,975 | £12,975 | £13,000 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £12,850 | £12,875 | £12,900 | £12,900 | £14,550 | £14,550 | £12,900 | £12,950 | £12,975 | £12,975 | £12,975 | £13,000 | |
| 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 | ||
| Owners | 5% | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 |
| Other | 5% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | 5% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 2 | 2 | 2 | 2 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | |
| 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 | £25,700 | £25,750 | £25,800 | £25,800 | £29,100 | £29,100 | £25,800 | £25,900 | £25,950 | £25,950 | £25,950 | £26,000 | |
| Direct Cost of Sales | £12,850 | £12,875 | £12,900 | £12,900 | £14,550 | £14,550 | £12,900 | £12,950 | £12,975 | £12,975 | £12,975 | £13,000 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £12,850 | £12,875 | £12,900 | £12,900 | £14,550 | £14,550 | £12,900 | £12,950 | £12,975 | £12,975 | £12,975 | £13,000 | |
| Gross Margin | £12,850 | £12,875 | £12,900 | £12,900 | £14,550 | £14,550 | £12,900 | £12,950 | £12,975 | £12,975 | £12,975 | £13,000 | |
| 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 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | |
| Marketing/Promotion | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Utilities | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | |
| Profit Before Interest and Taxes | £2,350 | £2,375 | £2,400 | £2,400 | £4,050 | £4,050 | £2,400 | £2,450 | £2,475 | £2,475 | £2,475 | £2,500 | |
| EBITDA | £2,350 | £2,375 | £2,400 | £2,400 | £4,050 | £4,050 | £2,400 | £2,450 | £2,475 | £2,475 | £2,475 | £2,500 | |
| Interest Expense | £1,039 | £1,028 | £1,017 | £1,006 | £995 | £984 | £973 | £963 | £952 | £941 | £930 | £919 | |
| Taxes Incurred | £393 | £404 | £415 | £418 | £916 | £920 | £428 | £446 | £457 | £460 | £464 | £474 | |
| Net Profit | £918 | £943 | £968 | £976 | £2,138 | £2,146 | £999 | £1,041 | £1,066 | £1,074 | £1,082 | £1,107 | |
| Net Profit/Sales | 3.57% | 3.66% | 3.75% | 3.78% | 7.35% | 7.37% | 3.87% | 4.02% | 4.11% | 4.14% | 4.17% | 4.26% | |
| 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 | £25,700 | £25,750 | £25,800 | £25,800 | £29,100 | £29,100 | £25,800 | £25,900 | £25,950 | £25,950 | £25,950 | £26,000 | |
| Subtotal Cash from Operations | £25,700 | £25,750 | £25,800 | £25,800 | £29,100 | £29,100 | £25,800 | £25,900 | £25,950 | £25,950 | £25,950 | £26,000 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £25,700 | £25,750 | £25,800 | £25,800 | £29,100 | £29,100 | £25,800 | £25,900 | £25,950 | £25,950 | £25,950 | £26,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 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | |
| Bill Payments | £593 | £17,842 | £19,558 | £19,573 | £19,946 | £37,411 | £20,952 | £6,730 | £16,371 | £19,625 | £19,376 | £19,377 | |
| Subtotal Spent on Operations | £6,093 | £23,342 | £25,058 | £25,073 | £25,446 | £42,911 | £26,452 | £12,230 | £21,871 | £25,125 | £24,876 | £24,877 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £2,188 | £2,188 | £2,188 | £2,188 | £2,188 | £2,188 | £2,188 | £2,188 | £2,188 | £2,188 | £2,188 | £2,188 | |
| 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 | £8,280 | £25,529 | £27,246 | £27,261 | £27,633 | £45,099 | £28,640 | £14,417 | £24,059 | £27,313 | £27,063 | £27,065 | |
| Net Cash Flow | £17,420 | £221 | (£1,446) | (£1,461) | £1,467 | (£15,999) | (£2,840) | £11,483 | £1,891 | (£1,363) | (£1,113) | (£1,065) | |
| Cash Balance | £48,470 | £48,691 | £47,245 | £45,784 | £47,251 | £31,252 | £28,412 | £39,895 | £41,786 | £40,424 | £39,310 | £38,246 | |
| 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 | £31,050 | £48,470 | £48,691 | £47,245 | £45,784 | £47,251 | £31,252 | £28,412 | £39,895 | £41,786 | £40,424 | £39,310 | £38,246 |
| Inventory | £130,000 | £128,500 | £128,750 | £129,000 | £129,000 | £145,500 | £145,500 | £132,600 | £129,500 | £129,750 | £129,750 | £129,750 | £130,000 |
| Other Current Assets | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 | £26,000 |
| Total Current Assets | £187,050 | £202,970 | £203,441 | £202,245 | £200,784 | £218,751 | £202,752 | £187,012 | £195,395 | £197,536 | £196,174 | £195,060 | £194,246 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 |
| Total Assets | £227,050 | £242,970 | £243,441 | £242,245 | £240,784 | £258,751 | £242,752 | £227,012 | £235,395 | £237,536 | £236,174 | £235,060 | £234,246 |
| 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 | £17,190 | £18,905 | £18,929 | £18,680 | £36,696 | £20,739 | £6,188 | £15,717 | £18,979 | £18,730 | £18,723 | £18,988 |
| 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 | £17,190 | £18,905 | £18,929 | £18,680 | £36,696 | £20,739 | £6,188 | £15,717 | £18,979 | £18,730 | £18,723 | £18,988 |
| Long-term Liabilities | £210,000 | £207,813 | £205,625 | £203,438 | £201,250 | £199,063 | £196,875 | £194,688 | £192,500 | £190,313 | £188,125 | £185,938 | £183,750 |
| Total Liabilities | £210,000 | £225,002 | £224,530 | £222,367 | £219,930 | £235,759 | £217,614 | £200,876 | £208,217 | £209,292 | £206,855 | £204,660 | £202,738 |
| Paid-in Capital | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 |
| Retained Earnings | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) | (£27,950) |
| Earnings | £0 | £918 | £1,860 | £2,828 | £3,804 | £5,942 | £8,088 | £9,087 | £10,128 | £11,195 | £12,269 | £13,350 | £14,457 |
| Total Capital | £17,050 | £17,968 | £18,910 | £19,878 | £20,854 | £22,992 | £25,138 | £26,137 | £27,178 | £28,245 | £29,319 | £30,400 | £31,507 |
| Total Liabilities and Capital | £227,050 | £242,970 | £243,441 | £242,245 | £240,784 | £258,751 | £242,752 | £227,012 | £235,395 | £237,536 | £236,174 | £235,060 | £234,246 |
| Net Worth | £17,050 | £17,968 | £18,910 | £19,878 | £20,854 | £22,992 | £25,138 | £26,137 | £27,178 | £28,245 | £29,319 | £30,400 | £31,507 |