| 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 | ||
| Unit Sales | |||||||||||||
| Specialty Microbrewed Beer | 0% | 2,356 | 2,592 | 2,851 | 3,136 | 3,449 | 3,794 | 4,174 | 4,591 | 5,050 | 5,555 | 6,111 | 6,722 |
| Normal Microbrewed Beer | 0% | 1,984 | 2,182 | 2,401 | 2,641 | 2,905 | 3,195 | 3,515 | 3,866 | 4,253 | 4,678 | 5,146 | 5,661 |
| Domestic Beer | 0% | 1,860 | 2,046 | 2,251 | 2,476 | 2,723 | 2,996 | 3,295 | 3,625 | 3,987 | 4,386 | 4,824 | 5,307 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 6,200 | 6,820 | 7,502 | 8,252 | 9,077 | 9,985 | 10,984 | 12,082 | 13,290 | 14,619 | 16,081 | 17,689 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Specialty Microbrewed Beer | £3.25 | £3.25 | £3.25 | £3.25 | £3.25 | £3.25 | £3.25 | £3.25 | £3.25 | £3.25 | £3.25 | £3.25 | |
| Normal Microbrewed Beer | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | |
| Domestic Beer | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | |
| Other | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
| Sales | |||||||||||||
| Specialty Microbrewed Beer | £7,657 | £8,423 | £9,265 | £10,191 | £11,211 | £12,332 | £13,565 | £14,921 | £16,413 | £18,055 | £19,860 | £21,846 | |
| Normal Microbrewed Beer | £5,952 | £6,547 | £7,202 | £7,922 | £8,714 | £9,586 | £10,544 | £11,599 | £12,759 | £14,035 | £15,438 | £16,982 | |
| Domestic Beer | £4,650 | £5,115 | £5,627 | £6,189 | £6,808 | £7,489 | £8,238 | £9,062 | £9,968 | £10,964 | £12,061 | £13,267 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £18,259 | £20,085 | £22,093 | £24,303 | £26,733 | £29,406 | £32,347 | £35,582 | £39,140 | £43,054 | £47,359 | £52,095 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Specialty Microbrewed Beer | 0.00% | £0.81 | £0.81 | £0.81 | £0.81 | £0.81 | £0.81 | £0.81 | £0.81 | £0.81 | £0.81 | £0.81 | £0.81 |
| Normal Microbrewed Beer | 0.00% | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 |
| Domestic Beer | 0.00% | £0.48 | £0.48 | £0.48 | £0.48 | £0.48 | £0.48 | £0.48 | £0.48 | £0.48 | £0.48 | £0.48 | £0.48 |
| Other | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Specialty Microbrewed Beer | £1,908 | £2,099 | £2,309 | £2,540 | £2,794 | £3,073 | £3,381 | £3,719 | £4,091 | £4,500 | £4,950 | £5,445 | |
| Normal Microbrewed Beer | £1,290 | £1,419 | £1,560 | £1,716 | £1,888 | £2,077 | £2,285 | £2,513 | £2,764 | £3,041 | £3,345 | £3,679 | |
| Domestic Beer | £893 | £982 | £1,080 | £1,188 | £1,307 | £1,438 | £1,582 | £1,740 | £1,914 | £2,105 | £2,316 | £2,547 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £4,091 | £4,500 | £4,950 | £5,445 | £5,989 | £6,588 | £7,247 | £7,972 | £8,769 | £9,646 | £10,610 | £11,671 | |
| 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 | ||
| Production Personnel | |||||||||||||
| Manager | £1,640 | £1,640 | £1,640 | £1,640 | £1,640 | £1,640 | £1,640 | £1,640 | £1,640 | £1,640 | £1,640 | £1,640 | |
| Part-Time Employee 1 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | |
| Part-Time Employee 2 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | |
| Part-Time Employee 3 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | |
| Part-Time Employee 4 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | |
| Part-Time Employee 5 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | |
| Part-Time Employee 6 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | |
| Sales and Marketing Personnel | |||||||||||||
| Name or title | £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 | |
| Subtotal | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| General and Administrative Personnel | |||||||||||||
| Dashiell Lavine (Part-Owner) | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Tyler Vogel (Part-Owner) | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Other Personnel | |||||||||||||
| Name or title | £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 | |
| Subtotal | £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 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | |
| 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% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £18,259 | £20,085 | £22,093 | £24,303 | £26,733 | £29,406 | £32,347 | £35,582 | £39,140 | £43,054 | £47,359 | £52,095 | |
| Direct Cost of Sales | £4,091 | £4,500 | £4,950 | £5,445 | £5,989 | £6,588 | £7,247 | £7,972 | £8,769 | £9,646 | £10,610 | £11,671 | |
| Production Payroll | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | |
| Other | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Total Cost of Sales | £10,929 | £11,338 | £11,788 | £12,283 | £12,827 | £13,426 | £14,085 | £14,810 | £15,607 | £16,484 | £17,448 | £18,509 | |
| Gross Margin | £7,330 | £8,747 | £10,306 | £12,020 | £13,906 | £15,980 | £18,262 | £20,772 | £23,533 | £26,570 | £29,911 | £33,586 | |
| Gross Margin % | 40.15% | 43.55% | 46.65% | 49.46% | 52.02% | 54.34% | 56.46% | 58.38% | 60.13% | 61.71% | 63.16% | 64.47% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Advertising/Promotion | £5,000 | £4,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Miscellaneous | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Total Sales and Marketing Expenses | £5,500 | £4,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Sales and Marketing % | 30.12% | 22.40% | 15.84% | 14.40% | 13.09% | 11.90% | 10.82% | 9.84% | 8.94% | 8.13% | 7.39% | 6.72% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Insurance | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | |
| Rent | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Payroll Taxes | 15% | £1,326 | £1,326 | £1,326 | £1,326 | £1,326 | £1,326 | £1,326 | £1,326 | £1,326 | £1,326 | £1,326 | £1,326 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £8,276 | £8,276 | £8,276 | £8,276 | £8,276 | £8,276 | £8,276 | £8,276 | £8,276 | £8,276 | £8,276 | £8,276 | |
| General and Administrative % | 45.32% | 41.20% | 37.46% | 34.05% | 30.96% | 28.14% | 25.58% | 23.26% | 21.14% | 19.22% | 17.47% | 15.89% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Contract/Consultants | £1,000 | £1,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expenses | £1,000 | £1,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other % | 5.48% | 4.98% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| Total Operating Expenses | £14,776 | £13,776 | £11,776 | £11,776 | £11,776 | £11,776 | £11,776 | £11,776 | £11,776 | £11,776 | £11,776 | £11,776 | |
| Profit Before Interest and Taxes | (£7,445) | (£5,029) | (£1,470) | £244 | £2,130 | £4,204 | £6,486 | £8,996 | £11,757 | £14,794 | £18,135 | £21,810 | |
| EBITDA | (£7,445) | (£5,029) | (£1,470) | £244 | £2,130 | £4,204 | £6,486 | £8,996 | £11,757 | £14,794 | £18,135 | £21,810 | |
| Interest Expense | £0 | £0 | £0 | £0 | £17 | £17 | £17 | £8 | £8 | £8 | £0 | £0 | |
| Taxes Incurred | (£2,234) | (£1,257) | (£368) | £61 | £528 | £1,047 | £1,617 | £2,247 | £2,937 | £3,696 | £4,534 | £5,452 | |
| Net Profit | (£5,212) | (£3,771) | (£1,103) | £183 | £1,585 | £3,141 | £4,852 | £6,741 | £8,812 | £11,089 | £13,601 | £16,357 | |
| Net Profit/Sales | -28.54% | -18.78% | -4.99% | 0.75% | 5.93% | 10.68% | 15.00% | 18.94% | 22.51% | 25.76% | 28.72% | 31.40% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £18,259 | £20,085 | £22,093 | £24,303 | £26,733 | £29,406 | £32,347 | £35,582 | £39,140 | £43,054 | £47,359 | £52,095 | |
| Subtotal Cash from Operations | £18,259 | £20,085 | £22,093 | £24,303 | £26,733 | £29,406 | £32,347 | £35,582 | £39,140 | £43,054 | £47,359 | £52,095 | |
| 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 | £2,000 | £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 | £3,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £18,259 | £20,085 | £22,093 | £27,303 | £28,733 | £29,406 | £32,347 | £35,582 | £39,140 | £43,054 | £47,359 | £52,095 | |
| 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 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | |
| Bill Payments | £595 | £17,773 | £15,448 | £14,885 | £15,862 | £16,948 | £18,130 | £19,429 | £20,852 | £22,425 | £24,154 | £26,050 | |
| Subtotal Spent on Operations | £9,433 | £26,611 | £24,286 | £23,723 | £24,700 | £25,786 | £26,968 | £28,267 | £29,690 | £31,263 | £32,992 | £34,888 | |
| 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 | £1,000 | £0 | £0 | £1,000 | £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 | £5,000 | £0 | £0 | £5,000 | £0 | £0 | £0 | £20,000 | £0 | £0 | £20,000 | £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 | £14,433 | £26,611 | £24,286 | £28,723 | £24,700 | £25,786 | £26,968 | £49,267 | £29,690 | £31,263 | £53,992 | £34,888 | |
| Net Cash Flow | £3,826 | (£6,526) | (£2,192) | (£1,421) | £4,033 | £3,620 | £5,379 | (£13,685) | £9,450 | £11,791 | (£6,633) | £17,207 | |
| Cash Balance | £11,746 | £5,220 | £3,027 | £1,606 | £5,639 | £9,260 | £14,639 | £954 | £10,403 | £22,195 | £15,562 | £32,769 | |
| 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 | £7,920 | £11,746 | £5,220 | £3,027 | £1,606 | £5,639 | £9,260 | £14,639 | £954 | £10,403 | £22,195 | £15,562 | £32,769 |
| Inventory | £1,280 | £4,500 | £4,950 | £5,445 | £5,989 | £6,588 | £7,247 | £7,972 | £8,769 | £9,646 | £10,610 | £11,671 | £12,839 |
| Other Current Assets | £0 | £5,000 | £5,000 | £5,000 | £10,000 | £10,000 | £10,000 | £10,000 | £30,000 | £30,000 | £30,000 | £50,000 | £50,000 |
| Total Current Assets | £9,200 | £21,246 | £15,169 | £13,472 | £17,596 | £22,228 | £26,507 | £32,611 | £39,723 | £50,049 | £62,805 | £77,233 | £95,607 |
| 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 | £9,200 | £21,246 | £15,169 | £13,472 | £17,596 | £22,228 | £26,507 | £32,611 | £39,723 | £50,049 | £62,805 | £77,233 | £95,607 |
| 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,258 | £14,953 | £14,358 | £15,299 | £16,345 | £17,483 | £18,735 | £20,107 | £21,621 | £23,288 | £25,115 | £27,131 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £1,000 | £1,000 | £1,000 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £17,258 | £14,953 | £14,358 | £15,299 | £18,345 | £19,483 | £20,735 | £21,107 | £22,621 | £24,288 | £25,115 | £27,131 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £17,258 | £14,953 | £14,358 | £15,299 | £18,345 | £19,483 | £20,735 | £21,107 | £22,621 | £24,288 | £25,115 | £27,131 |
| Paid-in Capital | £75,000 | £75,000 | £75,000 | £75,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 |
| Retained Earnings | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) |
| Earnings | £0 | (£5,212) | (£8,983) | (£10,086) | (£9,903) | (£8,318) | (£5,177) | (£325) | £6,416 | £15,228 | £26,317 | £39,919 | £56,276 |
| Total Capital | £9,200 | £3,988 | £217 | (£886) | £2,297 | £3,882 | £7,023 | £11,875 | £18,616 | £27,428 | £38,517 | £52,119 | £68,476 |
| Total Liabilities and Capital | £9,200 | £21,246 | £15,169 | £13,472 | £17,596 | £22,228 | £26,507 | £32,611 | £39,723 | £50,049 | £62,805 | £77,233 | £95,607 |
| Net Worth | £9,200 | £3,988 | £217 | (£886) | £2,297 | £3,882 | £7,023 | £11,875 | £18,616 | £27,428 | £38,517 | £52,119 | £68,476 |
| 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 | ||
| Unit Sales | |||||||||||||
| Specialty Microbrewed Beer | 0% | 2,356 | 2,592 | 2,851 | 3,136 | 3,449 | 3,794 | 4,174 | 4,591 | 5,050 | 5,555 | 6,111 | 6,722 |
| Normal Microbrewed Beer | 0% | 1,984 | 2,182 | 2,401 | 2,641 | 2,905 | 3,195 | 3,515 | 3,866 | 4,253 | 4,678 | 5,146 | 5,661 |
| Domestic Beer | 0% | 1,860 | 2,046 | 2,251 | 2,476 | 2,723 | 2,996 | 3,295 | 3,625 | 3,987 | 4,386 | 4,824 | 5,307 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 6,200 | 6,820 | 7,502 | 8,252 | 9,077 | 9,985 | 10,984 | 12,082 | 13,290 | 14,619 | 16,081 | 17,689 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Specialty Microbrewed Beer | £3.25 | £3.25 | £3.25 | £3.25 | £3.25 | £3.25 | £3.25 | £3.25 | £3.25 | £3.25 | £3.25 | £3.25 | |
| Normal Microbrewed Beer | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | |
| Domestic Beer | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | |
| Other | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
| Sales | |||||||||||||
| Specialty Microbrewed Beer | £7,657 | £8,423 | £9,265 | £10,191 | £11,211 | £12,332 | £13,565 | £14,921 | £16,413 | £18,055 | £19,860 | £21,846 | |
| Normal Microbrewed Beer | £5,952 | £6,547 | £7,202 | £7,922 | £8,714 | £9,586 | £10,544 | £11,599 | £12,759 | £14,035 | £15,438 | £16,982 | |
| Domestic Beer | £4,650 | £5,115 | £5,627 | £6,189 | £6,808 | £7,489 | £8,238 | £9,062 | £9,968 | £10,964 | £12,061 | £13,267 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £18,259 | £20,085 | £22,093 | £24,303 | £26,733 | £29,406 | £32,347 | £35,582 | £39,140 | £43,054 | £47,359 | £52,095 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Specialty Microbrewed Beer | 0.00% | £0.81 | £0.81 | £0.81 | £0.81 | £0.81 | £0.81 | £0.81 | £0.81 | £0.81 | £0.81 | £0.81 | £0.81 |
| Normal Microbrewed Beer | 0.00% | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 |
| Domestic Beer | 0.00% | £0.48 | £0.48 | £0.48 | £0.48 | £0.48 | £0.48 | £0.48 | £0.48 | £0.48 | £0.48 | £0.48 | £0.48 |
| Other | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Specialty Microbrewed Beer | £1,908 | £2,099 | £2,309 | £2,540 | £2,794 | £3,073 | £3,381 | £3,719 | £4,091 | £4,500 | £4,950 | £5,445 | |
| Normal Microbrewed Beer | £1,290 | £1,419 | £1,560 | £1,716 | £1,888 | £2,077 | £2,285 | £2,513 | £2,764 | £3,041 | £3,345 | £3,679 | |
| Domestic Beer | £893 | £982 | £1,080 | £1,188 | £1,307 | £1,438 | £1,582 | £1,740 | £1,914 | £2,105 | £2,316 | £2,547 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £4,091 | £4,500 | £4,950 | £5,445 | £5,989 | £6,588 | £7,247 | £7,972 | £8,769 | £9,646 | £10,610 | £11,671 | |
| 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 | ||
| Production Personnel | |||||||||||||
| Manager | £1,640 | £1,640 | £1,640 | £1,640 | £1,640 | £1,640 | £1,640 | £1,640 | £1,640 | £1,640 | £1,640 | £1,640 | |
| Part-Time Employee 1 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | |
| Part-Time Employee 2 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | |
| Part-Time Employee 3 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | |
| Part-Time Employee 4 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | |
| Part-Time Employee 5 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | |
| Part-Time Employee 6 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | £533 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | |
| Sales and Marketing Personnel | |||||||||||||
| Name or title | £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 | |
| Subtotal | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| General and Administrative Personnel | |||||||||||||
| Dashiell Lavine (Part-Owner) | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Tyler Vogel (Part-Owner) | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Other Personnel | |||||||||||||
| Name or title | £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 | |
| Subtotal | £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 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | |
| 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% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £18,259 | £20,085 | £22,093 | £24,303 | £26,733 | £29,406 | £32,347 | £35,582 | £39,140 | £43,054 | £47,359 | £52,095 | |
| Direct Cost of Sales | £4,091 | £4,500 | £4,950 | £5,445 | £5,989 | £6,588 | £7,247 | £7,972 | £8,769 | £9,646 | £10,610 | £11,671 | |
| Production Payroll | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | £4,838 | |
| Other | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Total Cost of Sales | £10,929 | £11,338 | £11,788 | £12,283 | £12,827 | £13,426 | £14,085 | £14,810 | £15,607 | £16,484 | £17,448 | £18,509 | |
| Gross Margin | £7,330 | £8,747 | £10,306 | £12,020 | £13,906 | £15,980 | £18,262 | £20,772 | £23,533 | £26,570 | £29,911 | £33,586 | |
| Gross Margin % | 40.15% | 43.55% | 46.65% | 49.46% | 52.02% | 54.34% | 56.46% | 58.38% | 60.13% | 61.71% | 63.16% | 64.47% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Advertising/Promotion | £5,000 | £4,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Miscellaneous | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Total Sales and Marketing Expenses | £5,500 | £4,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Sales and Marketing % | 30.12% | 22.40% | 15.84% | 14.40% | 13.09% | 11.90% | 10.82% | 9.84% | 8.94% | 8.13% | 7.39% | 6.72% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Insurance | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | |
| Rent | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Payroll Taxes | 15% | £1,326 | £1,326 | £1,326 | £1,326 | £1,326 | £1,326 | £1,326 | £1,326 | £1,326 | £1,326 | £1,326 | £1,326 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £8,276 | £8,276 | £8,276 | £8,276 | £8,276 | £8,276 | £8,276 | £8,276 | £8,276 | £8,276 | £8,276 | £8,276 | |
| General and Administrative % | 45.32% | 41.20% | 37.46% | 34.05% | 30.96% | 28.14% | 25.58% | 23.26% | 21.14% | 19.22% | 17.47% | 15.89% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Contract/Consultants | £1,000 | £1,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expenses | £1,000 | £1,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other % | 5.48% | 4.98% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| Total Operating Expenses | £14,776 | £13,776 | £11,776 | £11,776 | £11,776 | £11,776 | £11,776 | £11,776 | £11,776 | £11,776 | £11,776 | £11,776 | |
| Profit Before Interest and Taxes | (£7,445) | (£5,029) | (£1,470) | £244 | £2,130 | £4,204 | £6,486 | £8,996 | £11,757 | £14,794 | £18,135 | £21,810 | |
| EBITDA | (£7,445) | (£5,029) | (£1,470) | £244 | £2,130 | £4,204 | £6,486 | £8,996 | £11,757 | £14,794 | £18,135 | £21,810 | |
| Interest Expense | £0 | £0 | £0 | £0 | £17 | £17 | £17 | £8 | £8 | £8 | £0 | £0 | |
| Taxes Incurred | (£2,234) | (£1,257) | (£368) | £61 | £528 | £1,047 | £1,617 | £2,247 | £2,937 | £3,696 | £4,534 | £5,452 | |
| Net Profit | (£5,212) | (£3,771) | (£1,103) | £183 | £1,585 | £3,141 | £4,852 | £6,741 | £8,812 | £11,089 | £13,601 | £16,357 | |
| Net Profit/Sales | -28.54% | -18.78% | -4.99% | 0.75% | 5.93% | 10.68% | 15.00% | 18.94% | 22.51% | 25.76% | 28.72% | 31.40% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £18,259 | £20,085 | £22,093 | £24,303 | £26,733 | £29,406 | £32,347 | £35,582 | £39,140 | £43,054 | £47,359 | £52,095 | |
| Subtotal Cash from Operations | £18,259 | £20,085 | £22,093 | £24,303 | £26,733 | £29,406 | £32,347 | £35,582 | £39,140 | £43,054 | £47,359 | £52,095 | |
| 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 | £2,000 | £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 | £3,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £18,259 | £20,085 | £22,093 | £27,303 | £28,733 | £29,406 | £32,347 | £35,582 | £39,140 | £43,054 | £47,359 | £52,095 | |
| 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 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | £8,838 | |
| Bill Payments | £595 | £17,773 | £15,448 | £14,885 | £15,862 | £16,948 | £18,130 | £19,429 | £20,852 | £22,425 | £24,154 | £26,050 | |
| Subtotal Spent on Operations | £9,433 | £26,611 | £24,286 | £23,723 | £24,700 | £25,786 | £26,968 | £28,267 | £29,690 | £31,263 | £32,992 | £34,888 | |
| 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 | £1,000 | £0 | £0 | £1,000 | £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 | £5,000 | £0 | £0 | £5,000 | £0 | £0 | £0 | £20,000 | £0 | £0 | £20,000 | £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 | £14,433 | £26,611 | £24,286 | £28,723 | £24,700 | £25,786 | £26,968 | £49,267 | £29,690 | £31,263 | £53,992 | £34,888 | |
| Net Cash Flow | £3,826 | (£6,526) | (£2,192) | (£1,421) | £4,033 | £3,620 | £5,379 | (£13,685) | £9,450 | £11,791 | (£6,633) | £17,207 | |
| Cash Balance | £11,746 | £5,220 | £3,027 | £1,606 | £5,639 | £9,260 | £14,639 | £954 | £10,403 | £22,195 | £15,562 | £32,769 | |
| 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 | £7,920 | £11,746 | £5,220 | £3,027 | £1,606 | £5,639 | £9,260 | £14,639 | £954 | £10,403 | £22,195 | £15,562 | £32,769 |
| Inventory | £1,280 | £4,500 | £4,950 | £5,445 | £5,989 | £6,588 | £7,247 | £7,972 | £8,769 | £9,646 | £10,610 | £11,671 | £12,839 |
| Other Current Assets | £0 | £5,000 | £5,000 | £5,000 | £10,000 | £10,000 | £10,000 | £10,000 | £30,000 | £30,000 | £30,000 | £50,000 | £50,000 |
| Total Current Assets | £9,200 | £21,246 | £15,169 | £13,472 | £17,596 | £22,228 | £26,507 | £32,611 | £39,723 | £50,049 | £62,805 | £77,233 | £95,607 |
| 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 | £9,200 | £21,246 | £15,169 | £13,472 | £17,596 | £22,228 | £26,507 | £32,611 | £39,723 | £50,049 | £62,805 | £77,233 | £95,607 |
| 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,258 | £14,953 | £14,358 | £15,299 | £16,345 | £17,483 | £18,735 | £20,107 | £21,621 | £23,288 | £25,115 | £27,131 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £1,000 | £1,000 | £1,000 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £17,258 | £14,953 | £14,358 | £15,299 | £18,345 | £19,483 | £20,735 | £21,107 | £22,621 | £24,288 | £25,115 | £27,131 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £17,258 | £14,953 | £14,358 | £15,299 | £18,345 | £19,483 | £20,735 | £21,107 | £22,621 | £24,288 | £25,115 | £27,131 |
| Paid-in Capital | £75,000 | £75,000 | £75,000 | £75,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 |
| Retained Earnings | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) | (£65,800) |
| Earnings | £0 | (£5,212) | (£8,983) | (£10,086) | (£9,903) | (£8,318) | (£5,177) | (£325) | £6,416 | £15,228 | £26,317 | £39,919 | £56,276 |
| Total Capital | £9,200 | £3,988 | £217 | (£886) | £2,297 | £3,882 | £7,023 | £11,875 | £18,616 | £27,428 | £38,517 | £52,119 | £68,476 |
| Total Liabilities and Capital | £9,200 | £21,246 | £15,169 | £13,472 | £17,596 | £22,228 | £26,507 | £32,611 | £39,723 | £50,049 | £62,805 | £77,233 | £95,607 |
| Net Worth | £9,200 | £3,988 | £217 | (£886) | £2,297 | £3,882 | £7,023 | £11,875 | £18,616 | £27,428 | £38,517 | £52,119 | £68,476 |