| 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 | |||||||||||||
| Portrait Sales (HRN) | 0% | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 |
| Artwork Sales (PN) | 0% | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 |
| School-aged Classes | 0% | £3,000 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 |
| Retired/non-work Classes | 0% | £0 | £0 | £0 | £0 | £0 | £3,160 | £3,160 | £3,160 | £3,160 | £3,160 | £3,160 | £6,320 |
| Evening/working Classes | 0% | £0 | £0 | £3,584 | £3,584 | £3,584 | £3,584 | £3,584 | £3,584 | £3,584 | £3,584 | £3,584 | £3,584 |
| Sale of Art Supplies | 0% | £0 | £0 | £640 | £640 | £640 | £1,240 | £1,240 | £1,240 | £2,140 | £2,140 | £2,140 | £2,740 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £3,950 | £4,550 | £8,774 | £8,774 | £8,774 | £12,534 | £12,534 | £12,534 | £13,434 | £13,434 | £13,434 | £17,194 | |
| 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 | |
| Portrait Sales (HRN) | £98 | £98 | £98 | £98 | £98 | £98 | £98 | £98 | £98 | £98 | £98 | £98 | |
| Artwork Sales (PN) | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | |
| School-aged Classes | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £0 | £0 | £0 | £0 | |
| Retired/non-work Classes | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Evening/working Classes | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sale of Art Supplies | £0 | £0 | £448 | £448 | £448 | £868 | £868 | £868 | £1,498 | £1,498 | £1,498 | £1,918 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £413 | £413 | £861 | £861 | £861 | £1,281 | £1,281 | £1,281 | £1,641 | £1,641 | £1,641 | £2,061 | |
| 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 | ||
| Hannah | 0% | £0 | £0 | £500 | £500 | £1,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Paul | 0% | £1,000 | £1,000 | £1,000 | £1,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 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £1,000 | £1,000 | £1,500 | £1,500 | £3,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| 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% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.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 | £3,950 | £4,550 | £8,774 | £8,774 | £8,774 | £12,534 | £12,534 | £12,534 | £13,434 | £13,434 | £13,434 | £17,194 | |
| Direct Cost of Sales | £413 | £413 | £861 | £861 | £861 | £1,281 | £1,281 | £1,281 | £1,641 | £1,641 | £1,641 | £2,061 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £413 | £413 | £861 | £861 | £861 | £1,281 | £1,281 | £1,281 | £1,641 | £1,641 | £1,641 | £2,061 | |
| Gross Margin | £3,538 | £4,138 | £7,914 | £7,914 | £7,914 | £11,254 | £11,254 | £11,254 | £11,794 | £11,794 | £11,794 | £15,134 | |
| Gross Margin % | 89.56% | 90.93% | 90.19% | 90.19% | 90.19% | 89.78% | 89.78% | 89.78% | 87.79% | 87.79% | 87.79% | 88.02% | |
| Expenses | |||||||||||||
| Payroll | £1,000 | £1,000 | £1,500 | £1,500 | £3,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Sales and Marketing and Other Expenses | £400 | £400 | £400 | £449 | £1,593 | £899 | £899 | £899 | £2,043 | £899 | £899 | £1,349 | |
| Depreciation | £0 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities (Gas & Elec.) | £175 | £175 | £175 | £175 | £95 | £75 | £75 | £75 | £97 | £175 | £175 | £175 | |
| Insurance | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | |
| Rent | £1,225 | £1,225 | £1,225 | £1,225 | £1,225 | £1,225 | £1,225 | £1,225 | £1,225 | £1,225 | £1,225 | £1,225 | |
| Payroll Taxes | 15% | £150 | £150 | £225 | £225 | £450 | £600 | £600 | £600 | £600 | £600 | £600 | £600 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £2,995 | £3,167 | £3,742 | £3,791 | £6,580 | £7,016 | £7,016 | £7,016 | £8,182 | £7,116 | £7,116 | £7,566 | |
| Profit Before Interest and Taxes | £543 | £971 | £4,172 | £4,123 | £1,334 | £4,238 | £4,238 | £4,238 | £3,612 | £4,678 | £4,678 | £7,568 | |
| EBITDA | £543 | £1,143 | £4,344 | £4,295 | £1,506 | £4,410 | £4,410 | £4,410 | £3,784 | £4,850 | £4,850 | £7,740 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £163 | £340 | £1,460 | £1,443 | £467 | £1,483 | £1,483 | £1,483 | £1,264 | £1,637 | £1,637 | £2,649 | |
| Net Profit | £380 | £631 | £2,711 | £2,680 | £867 | £2,754 | £2,754 | £2,754 | £2,347 | £3,040 | £3,040 | £4,919 | |
| Net Profit/Sales | 9.61% | 13.86% | 30.90% | 30.54% | 9.88% | 21.98% | 21.98% | 21.98% | 17.47% | 22.63% | 22.63% | 28.61% | |
| 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 | £3,950 | £4,550 | £8,774 | £8,774 | £8,774 | £12,534 | £12,534 | £12,534 | £13,434 | £13,434 | £13,434 | £17,194 | |
| Subtotal Cash from Operations | £3,950 | £4,550 | £8,774 | £8,774 | £8,774 | £12,534 | £12,534 | £12,534 | £13,434 | £13,434 | £13,434 | £17,194 | |
| 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 | £3,950 | £4,550 | £8,774 | £8,774 | £8,774 | £12,534 | £12,534 | £12,534 | £13,434 | £13,434 | £13,434 | £17,194 | |
| 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,000 | £1,000 | £1,500 | £1,500 | £3,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Bill Payments | £105 | £3,164 | £3,375 | £4,531 | £4,572 | £4,893 | £5,429 | £5,608 | £5,664 | £7,274 | £6,222 | £6,300 | |
| Subtotal Spent on Operations | £1,105 | £4,164 | £4,875 | £6,031 | £7,572 | £8,893 | £9,429 | £9,608 | £9,664 | £11,274 | £10,222 | £10,300 | |
| 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,105 | £4,164 | £4,875 | £6,031 | £7,572 | £8,893 | £9,429 | £9,608 | £9,664 | £11,274 | £10,222 | £10,300 | |
| Net Cash Flow | £2,845 | £386 | £3,899 | £2,743 | £1,202 | £3,641 | £3,105 | £2,926 | £3,770 | £2,160 | £3,212 | £6,894 | |
| Cash Balance | £2,845 | £3,231 | £7,131 | £9,873 | £11,075 | £14,716 | £17,821 | £20,748 | £24,517 | £26,677 | £29,889 | £36,784 | |
| 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 | £0 | £2,845 | £3,231 | £7,131 | £9,873 | £11,075 | £14,716 | £17,821 | £20,748 | £24,517 | £26,677 | £29,889 | £36,784 |
| Inventory | £0 | £588 | £1,175 | £1,315 | £1,454 | £1,594 | £1,409 | £1,409 | £1,409 | £1,805 | £1,805 | £1,805 | £2,267 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £0 | £3,432 | £4,406 | £8,445 | £11,327 | £12,669 | £16,125 | £19,230 | £22,156 | £26,322 | £28,482 | £31,694 | £39,050 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 |
| Accumulated Depreciation | £0 | £0 | £172 | £344 | £516 | £688 | £860 | £1,032 | £1,204 | £1,376 | £1,548 | £1,720 | £1,892 |
| Total Long-term Assets | £6,200 | £6,200 | £6,028 | £5,856 | £5,684 | £5,512 | £5,340 | £5,168 | £4,996 | £4,824 | £4,652 | £4,480 | £4,308 |
| Total Assets | £6,200 | £9,632 | £10,434 | £14,301 | £17,011 | £18,181 | £21,465 | £24,398 | £27,152 | £31,146 | £33,134 | £36,174 | £43,358 |
| 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,052 | £3,224 | £4,379 | £4,410 | £4,712 | £5,242 | £5,421 | £5,421 | £7,067 | £6,014 | £6,014 | £8,280 |
| 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,052 | £3,224 | £4,379 | £4,410 | £4,712 | £5,242 | £5,421 | £5,421 | £7,067 | £6,014 | £6,014 | £8,280 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £3,052 | £3,224 | £4,379 | £4,410 | £4,712 | £5,242 | £5,421 | £5,421 | £7,067 | £6,014 | £6,014 | £8,280 |
| Paid-in Capital | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 |
| Retained Earnings | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) |
| Earnings | £0 | £380 | £1,011 | £3,722 | £6,402 | £7,268 | £10,023 | £12,777 | £15,532 | £17,879 | £20,919 | £23,960 | £28,879 |
| Total Capital | £6,200 | £6,580 | £7,211 | £9,922 | £12,602 | £13,468 | £16,223 | £18,977 | £21,732 | £24,079 | £27,119 | £30,160 | £35,079 |
| Total Liabilities and Capital | £6,200 | £9,632 | £10,434 | £14,301 | £17,011 | £18,181 | £21,465 | £24,398 | £27,152 | £31,146 | £33,134 | £36,174 | £43,358 |
| Net Worth | £6,200 | £6,580 | £7,211 | £9,922 | £12,602 | £13,468 | £16,223 | £18,977 | £21,732 | £24,079 | £27,119 | £30,160 | £35,079 |
| 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 | |||||||||||||
| Portrait Sales (HRN) | 0% | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 |
| Artwork Sales (PN) | 0% | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 |
| School-aged Classes | 0% | £3,000 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 |
| Retired/non-work Classes | 0% | £0 | £0 | £0 | £0 | £0 | £3,160 | £3,160 | £3,160 | £3,160 | £3,160 | £3,160 | £6,320 |
| Evening/working Classes | 0% | £0 | £0 | £3,584 | £3,584 | £3,584 | £3,584 | £3,584 | £3,584 | £3,584 | £3,584 | £3,584 | £3,584 |
| Sale of Art Supplies | 0% | £0 | £0 | £640 | £640 | £640 | £1,240 | £1,240 | £1,240 | £2,140 | £2,140 | £2,140 | £2,740 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £3,950 | £4,550 | £8,774 | £8,774 | £8,774 | £12,534 | £12,534 | £12,534 | £13,434 | £13,434 | £13,434 | £17,194 | |
| 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 | |
| Portrait Sales (HRN) | £98 | £98 | £98 | £98 | £98 | £98 | £98 | £98 | £98 | £98 | £98 | £98 | |
| Artwork Sales (PN) | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | |
| School-aged Classes | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £0 | £0 | £0 | £0 | |
| Retired/non-work Classes | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Evening/working Classes | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sale of Art Supplies | £0 | £0 | £448 | £448 | £448 | £868 | £868 | £868 | £1,498 | £1,498 | £1,498 | £1,918 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £413 | £413 | £861 | £861 | £861 | £1,281 | £1,281 | £1,281 | £1,641 | £1,641 | £1,641 | £2,061 | |
| 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 | ||
| Hannah | 0% | £0 | £0 | £500 | £500 | £1,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Paul | 0% | £1,000 | £1,000 | £1,000 | £1,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 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £1,000 | £1,000 | £1,500 | £1,500 | £3,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| 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% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.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 | £3,950 | £4,550 | £8,774 | £8,774 | £8,774 | £12,534 | £12,534 | £12,534 | £13,434 | £13,434 | £13,434 | £17,194 | |
| Direct Cost of Sales | £413 | £413 | £861 | £861 | £861 | £1,281 | £1,281 | £1,281 | £1,641 | £1,641 | £1,641 | £2,061 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £413 | £413 | £861 | £861 | £861 | £1,281 | £1,281 | £1,281 | £1,641 | £1,641 | £1,641 | £2,061 | |
| Gross Margin | £3,538 | £4,138 | £7,914 | £7,914 | £7,914 | £11,254 | £11,254 | £11,254 | £11,794 | £11,794 | £11,794 | £15,134 | |
| Gross Margin % | 89.56% | 90.93% | 90.19% | 90.19% | 90.19% | 89.78% | 89.78% | 89.78% | 87.79% | 87.79% | 87.79% | 88.02% | |
| Expenses | |||||||||||||
| Payroll | £1,000 | £1,000 | £1,500 | £1,500 | £3,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Sales and Marketing and Other Expenses | £400 | £400 | £400 | £449 | £1,593 | £899 | £899 | £899 | £2,043 | £899 | £899 | £1,349 | |
| Depreciation | £0 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | £172 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities (Gas & Elec.) | £175 | £175 | £175 | £175 | £95 | £75 | £75 | £75 | £97 | £175 | £175 | £175 | |
| Insurance | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | £45 | |
| Rent | £1,225 | £1,225 | £1,225 | £1,225 | £1,225 | £1,225 | £1,225 | £1,225 | £1,225 | £1,225 | £1,225 | £1,225 | |
| Payroll Taxes | 15% | £150 | £150 | £225 | £225 | £450 | £600 | £600 | £600 | £600 | £600 | £600 | £600 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £2,995 | £3,167 | £3,742 | £3,791 | £6,580 | £7,016 | £7,016 | £7,016 | £8,182 | £7,116 | £7,116 | £7,566 | |
| Profit Before Interest and Taxes | £543 | £971 | £4,172 | £4,123 | £1,334 | £4,238 | £4,238 | £4,238 | £3,612 | £4,678 | £4,678 | £7,568 | |
| EBITDA | £543 | £1,143 | £4,344 | £4,295 | £1,506 | £4,410 | £4,410 | £4,410 | £3,784 | £4,850 | £4,850 | £7,740 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £163 | £340 | £1,460 | £1,443 | £467 | £1,483 | £1,483 | £1,483 | £1,264 | £1,637 | £1,637 | £2,649 | |
| Net Profit | £380 | £631 | £2,711 | £2,680 | £867 | £2,754 | £2,754 | £2,754 | £2,347 | £3,040 | £3,040 | £4,919 | |
| Net Profit/Sales | 9.61% | 13.86% | 30.90% | 30.54% | 9.88% | 21.98% | 21.98% | 21.98% | 17.47% | 22.63% | 22.63% | 28.61% | |
| 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 | £3,950 | £4,550 | £8,774 | £8,774 | £8,774 | £12,534 | £12,534 | £12,534 | £13,434 | £13,434 | £13,434 | £17,194 | |
| Subtotal Cash from Operations | £3,950 | £4,550 | £8,774 | £8,774 | £8,774 | £12,534 | £12,534 | £12,534 | £13,434 | £13,434 | £13,434 | £17,194 | |
| 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 | £3,950 | £4,550 | £8,774 | £8,774 | £8,774 | £12,534 | £12,534 | £12,534 | £13,434 | £13,434 | £13,434 | £17,194 | |
| 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,000 | £1,000 | £1,500 | £1,500 | £3,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Bill Payments | £105 | £3,164 | £3,375 | £4,531 | £4,572 | £4,893 | £5,429 | £5,608 | £5,664 | £7,274 | £6,222 | £6,300 | |
| Subtotal Spent on Operations | £1,105 | £4,164 | £4,875 | £6,031 | £7,572 | £8,893 | £9,429 | £9,608 | £9,664 | £11,274 | £10,222 | £10,300 | |
| 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,105 | £4,164 | £4,875 | £6,031 | £7,572 | £8,893 | £9,429 | £9,608 | £9,664 | £11,274 | £10,222 | £10,300 | |
| Net Cash Flow | £2,845 | £386 | £3,899 | £2,743 | £1,202 | £3,641 | £3,105 | £2,926 | £3,770 | £2,160 | £3,212 | £6,894 | |
| Cash Balance | £2,845 | £3,231 | £7,131 | £9,873 | £11,075 | £14,716 | £17,821 | £20,748 | £24,517 | £26,677 | £29,889 | £36,784 | |
| 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 | £0 | £2,845 | £3,231 | £7,131 | £9,873 | £11,075 | £14,716 | £17,821 | £20,748 | £24,517 | £26,677 | £29,889 | £36,784 |
| Inventory | £0 | £588 | £1,175 | £1,315 | £1,454 | £1,594 | £1,409 | £1,409 | £1,409 | £1,805 | £1,805 | £1,805 | £2,267 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £0 | £3,432 | £4,406 | £8,445 | £11,327 | £12,669 | £16,125 | £19,230 | £22,156 | £26,322 | £28,482 | £31,694 | £39,050 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 | £6,200 |
| Accumulated Depreciation | £0 | £0 | £172 | £344 | £516 | £688 | £860 | £1,032 | £1,204 | £1,376 | £1,548 | £1,720 | £1,892 |
| Total Long-term Assets | £6,200 | £6,200 | £6,028 | £5,856 | £5,684 | £5,512 | £5,340 | £5,168 | £4,996 | £4,824 | £4,652 | £4,480 | £4,308 |
| Total Assets | £6,200 | £9,632 | £10,434 | £14,301 | £17,011 | £18,181 | £21,465 | £24,398 | £27,152 | £31,146 | £33,134 | £36,174 | £43,358 |
| 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,052 | £3,224 | £4,379 | £4,410 | £4,712 | £5,242 | £5,421 | £5,421 | £7,067 | £6,014 | £6,014 | £8,280 |
| 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,052 | £3,224 | £4,379 | £4,410 | £4,712 | £5,242 | £5,421 | £5,421 | £7,067 | £6,014 | £6,014 | £8,280 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £3,052 | £3,224 | £4,379 | £4,410 | £4,712 | £5,242 | £5,421 | £5,421 | £7,067 | £6,014 | £6,014 | £8,280 |
| Paid-in Capital | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 | £8,265 |
| Retained Earnings | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) | (£2,065) |
| Earnings | £0 | £380 | £1,011 | £3,722 | £6,402 | £7,268 | £10,023 | £12,777 | £15,532 | £17,879 | £20,919 | £23,960 | £28,879 |
| Total Capital | £6,200 | £6,580 | £7,211 | £9,922 | £12,602 | £13,468 | £16,223 | £18,977 | £21,732 | £24,079 | £27,119 | £30,160 | £35,079 |
| Total Liabilities and Capital | £6,200 | £9,632 | £10,434 | £14,301 | £17,011 | £18,181 | £21,465 | £24,398 | £27,152 | £31,146 | £33,134 | £36,174 | £43,358 |
| Net Worth | £6,200 | £6,580 | £7,211 | £9,922 | £12,602 | £13,468 | £16,223 | £18,977 | £21,732 | £24,079 | £27,119 | £30,160 | £35,079 |