| 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 | |||||||||||||
| Fresh Brewed Coffee | 0% | £3,239 | £3,271 | £3,304 | £3,337 | £3,371 | £3,404 | £3,438 | £3,473 | £3,507 | £3,542 | £3,578 | £3,614 |
| Espresso Based Beverages | 0% | £4,219 | £4,261 | £4,304 | £4,347 | £4,390 | £4,434 | £4,479 | £4,523 | £4,569 | £4,614 | £4,660 | £4,707 |
| Specialty Drinks | 0% | £2,738 | £2,765 | £2,793 | £2,821 | £2,849 | £2,878 | £2,906 | £2,936 | £2,965 | £2,995 | £3,024 | £3,055 |
| Pastries/Desserts | 0% | £1,140 | £1,151 | £1,163 | £1,175 | £1,186 | £1,198 | £1,210 | £1,222 | £1,234 | £1,247 | £1,259 | £1,272 |
| Music/CDs | 0% | £915 | £924 | £933 | £943 | £952 | £962 | £971 | £981 | £991 | £1,001 | £1,011 | £1,021 |
| Books | 0% | £915 | £924 | £933 | £943 | £952 | £962 | £971 | £981 | £991 | £1,001 | £1,011 | £1,021 |
| Fresh Roasted Coffee | 0% | £1,525 | £1,540 | £1,556 | £1,571 | £1,587 | £1,603 | £1,619 | £1,635 | £1,651 | £1,668 | £1,685 | £1,701 |
| Misc Candies/Products | 0% | £1,350 | £1,364 | £1,377 | £1,391 | £1,405 | £1,419 | £1,433 | £1,447 | £1,462 | £1,476 | £1,491 | £1,506 |
| Total Sales | £16,041 | £16,201 | £16,363 | £16,527 | £16,692 | £16,859 | £17,028 | £17,198 | £17,370 | £17,544 | £17,719 | £17,896 | |
| 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 | |
| Fresh Brewed Coffee | £108 | £109 | £110 | £111 | £112 | £114 | £115 | £116 | £117 | £118 | £119 | £120 | |
| Espresso Based Beverages | £304 | £307 | £310 | £313 | £316 | £320 | £323 | £326 | £329 | £332 | £336 | £339 | |
| Specialty Drinks | £569 | £575 | £580 | £586 | £592 | £598 | £604 | £610 | £616 | £622 | £629 | £635 | |
| Fresh Roasted Coffee | £458 | £463 | £467 | £472 | £477 | £481 | £486 | £491 | £496 | £501 | £506 | £511 | |
| Pastries/Desserts | 50% | £570 | £576 | £581 | £587 | £593 | £599 | £605 | £611 | £617 | £623 | £630 | £636 |
| Candies, etc. | 50% | £675 | £682 | £689 | £695 | £702 | £709 | £717 | £724 | £731 | £738 | £746 | £753 |
| Books/Music | £916 | £925 | £934 | £944 | £953 | £963 | £972 | £982 | £992 | £1,002 | £1,012 | £1,022 | |
| Subtotal Direct Cost of Sales | £3,600 | £3,636 | £3,672 | £3,709 | £3,746 | £3,784 | £3,821 | £3,860 | £3,898 | £3,937 | £3,977 | £4,016 | |
| 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 | ||
| Albert Brown - Operations Manager | 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 |
| Owner | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Baristas | 0% | £4,680 | £4,680 | £4,680 | £4,680 | £4,680 | £4,680 | £4,680 | £4,680 | £4,680 | £4,680 | £4,680 | £4,680 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | |
| 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 | £16,041 | £16,201 | £16,363 | £16,527 | £16,692 | £16,859 | £17,028 | £17,198 | £17,370 | £17,544 | £17,719 | £17,896 | |
| Direct Cost of Sales | £3,600 | £3,636 | £3,672 | £3,709 | £3,746 | £3,784 | £3,821 | £3,860 | £3,898 | £3,937 | £3,977 | £4,016 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £3,600 | £3,636 | £3,672 | £3,709 | £3,746 | £3,784 | £3,821 | £3,860 | £3,898 | £3,937 | £3,977 | £4,016 | |
| Gross Margin | £12,441 | £12,565 | £12,691 | £12,818 | £12,946 | £13,076 | £13,206 | £13,338 | £13,472 | £13,607 | £13,743 | £13,880 | |
| Gross Margin % | 77.56% | 77.56% | 77.56% | 77.56% | 77.56% | 77.56% | 77.56% | 77.56% | 77.56% | 77.56% | 77.56% | 77.56% | |
| Expenses | |||||||||||||
| Payroll | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | |
| Marketing/Promotion | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Depreciation | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | |
| Leased Equipment | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £400 | £400 | £400 | £400 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Rent | £2,365 | £2,365 | £2,365 | £2,365 | £2,365 | £2,365 | £2,365 | £2,365 | £2,365 | £2,365 | £2,365 | £2,365 | |
| Website Hosting and Maintenance | 0% | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 |
| Payroll Taxes | 15% | £927 | £927 | £927 | £927 | £927 | £927 | £927 | £927 | £916 | £927 | £927 | £927 |
| Other | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Total Operating Expenses | £11,614 | £11,614 | £11,614 | £11,614 | £11,614 | £11,614 | £11,614 | £11,614 | £11,703 | £11,714 | £11,714 | £11,714 | |
| Profit Before Interest and Taxes | £827 | £951 | £1,077 | £1,204 | £1,332 | £1,462 | £1,592 | £1,724 | £1,769 | £1,893 | £2,029 | £2,166 | |
| EBITDA | £994 | £1,118 | £1,244 | £1,371 | £1,499 | £1,629 | £1,759 | £1,891 | £1,936 | £2,060 | £2,196 | £2,333 | |
| Interest Expense | £132 | £131 | £131 | £130 | £129 | £128 | £127 | £126 | £125 | £124 | £123 | £122 | |
| Taxes Incurred | £174 | £205 | £237 | £269 | £301 | £333 | £366 | £400 | £411 | £442 | £476 | £511 | |
| Net Profit | £521 | £615 | £710 | £806 | £903 | £1,000 | £1,099 | £1,199 | £1,233 | £1,326 | £1,429 | £1,533 | |
| Net Profit/Sales | 3.25% | 3.80% | 4.34% | 4.88% | 5.41% | 5.93% | 6.45% | 6.97% | 7.10% | 7.56% | 8.07% | 8.57% | |
| 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 | £16,041 | £16,201 | £16,363 | £16,527 | £16,692 | £16,859 | £17,028 | £17,198 | £17,370 | £17,544 | £17,719 | £17,896 | |
| Subtotal Cash from Operations | £16,041 | £16,201 | £16,363 | £16,527 | £16,692 | £16,859 | £17,028 | £17,198 | £17,370 | £17,544 | £17,719 | £17,896 | |
| 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 | £16,041 | £16,201 | £16,363 | £16,527 | £16,692 | £16,859 | £17,028 | £17,198 | £17,370 | £17,544 | £17,719 | £17,896 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | |
| Bill Payments | £219 | £6,662 | £9,243 | £9,349 | £9,417 | £9,486 | £9,555 | £9,626 | £9,699 | £9,836 | £9,916 | £9,989 | |
| Subtotal Spent on Operations | £6,399 | £12,842 | £15,423 | £15,529 | £15,597 | £15,666 | £15,735 | £15,806 | £15,879 | £16,016 | £16,096 | £16,169 | |
| 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 | £555 | £555 | £555 | £555 | £555 | £555 | £555 | £555 | £555 | £555 | £555 | £555 | |
| 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 | £6,954 | £13,397 | £15,978 | £16,084 | £16,152 | £16,221 | £16,290 | £16,361 | £16,434 | £16,571 | £16,651 | £16,724 | |
| Net Cash Flow | £9,087 | £2,804 | £386 | £443 | £540 | £638 | £737 | £837 | £936 | £973 | £1,068 | £1,173 | |
| Cash Balance | £39,687 | £42,491 | £42,877 | £43,320 | £43,861 | £44,499 | £45,237 | £46,074 | £47,010 | £47,983 | £49,052 | £50,224 | |
| 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 | £30,600 | £39,687 | £42,491 | £42,877 | £43,320 | £43,861 | £44,499 | £45,237 | £46,074 | £47,010 | £47,983 | £49,052 | £50,224 |
| Inventory | £6,600 | £4,000 | £4,000 | £4,040 | £4,080 | £4,121 | £4,162 | £4,204 | £4,246 | £4,288 | £4,331 | £4,374 | £4,418 |
| Other Current Assets | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 |
| Total Current Assets | £49,200 | £55,687 | £58,491 | £58,917 | £59,400 | £59,982 | £60,661 | £61,440 | £62,320 | £63,298 | £64,314 | £65,426 | £66,642 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 |
| Accumulated Depreciation | £0 | £167 | £334 | £501 | £668 | £835 | £1,002 | £1,169 | £1,336 | £1,503 | £1,670 | £1,837 | £2,004 |
| Total Long-term Assets | £16,000 | £15,833 | £15,666 | £15,499 | £15,332 | £15,165 | £14,998 | £14,831 | £14,664 | £14,497 | £14,330 | £14,163 | £13,996 |
| Total Assets | £65,200 | £71,520 | £74,157 | £74,416 | £74,732 | £75,147 | £75,659 | £76,271 | £76,984 | £77,795 | £78,644 | £79,589 | £80,638 |
| 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 | £6,354 | £8,931 | £9,035 | £9,101 | £9,167 | £9,235 | £9,303 | £9,371 | £9,505 | £9,583 | £9,654 | £9,725 |
| 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 | £6,354 | £8,931 | £9,035 | £9,101 | £9,167 | £9,235 | £9,303 | £9,371 | £9,505 | £9,583 | £9,654 | £9,725 |
| Long-term Liabilities | £80,000 | £79,445 | £78,890 | £78,335 | £77,780 | £77,225 | £76,670 | £76,115 | £75,560 | £75,005 | £74,450 | £73,895 | £73,340 |
| Total Liabilities | £80,000 | £85,799 | £87,821 | £87,370 | £86,881 | £86,392 | £85,905 | £85,418 | £84,931 | £84,510 | £84,033 | £83,549 | £83,065 |
| Paid-in Capital | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Retained Earnings | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) |
| Earnings | £0 | £521 | £1,136 | £1,846 | £2,652 | £3,554 | £4,554 | £5,654 | £6,852 | £8,085 | £9,412 | £10,841 | £12,373 |
| Total Capital | (£14,800) | (£14,279) | (£13,664) | (£12,954) | (£12,148) | (£11,246) | (£10,246) | (£9,146) | (£7,948) | (£6,715) | (£5,388) | (£3,959) | (£2,427) |
| Total Liabilities and Capital | £65,200 | £71,520 | £74,157 | £74,416 | £74,732 | £75,147 | £75,659 | £76,271 | £76,984 | £77,795 | £78,644 | £79,589 | £80,638 |
| Net Worth | (£14,800) | (£14,279) | (£13,664) | (£12,954) | (£12,148) | (£11,246) | (£10,246) | (£9,146) | (£7,948) | (£6,715) | (£5,388) | (£3,959) | (£2,427) |
| 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 | |||||||||||||
| Fresh Brewed Coffee | 0% | £3,239 | £3,271 | £3,304 | £3,337 | £3,371 | £3,404 | £3,438 | £3,473 | £3,507 | £3,542 | £3,578 | £3,614 |
| Espresso Based Beverages | 0% | £4,219 | £4,261 | £4,304 | £4,347 | £4,390 | £4,434 | £4,479 | £4,523 | £4,569 | £4,614 | £4,660 | £4,707 |
| Specialty Drinks | 0% | £2,738 | £2,765 | £2,793 | £2,821 | £2,849 | £2,878 | £2,906 | £2,936 | £2,965 | £2,995 | £3,024 | £3,055 |
| Pastries/Desserts | 0% | £1,140 | £1,151 | £1,163 | £1,175 | £1,186 | £1,198 | £1,210 | £1,222 | £1,234 | £1,247 | £1,259 | £1,272 |
| Music/CDs | 0% | £915 | £924 | £933 | £943 | £952 | £962 | £971 | £981 | £991 | £1,001 | £1,011 | £1,021 |
| Books | 0% | £915 | £924 | £933 | £943 | £952 | £962 | £971 | £981 | £991 | £1,001 | £1,011 | £1,021 |
| Fresh Roasted Coffee | 0% | £1,525 | £1,540 | £1,556 | £1,571 | £1,587 | £1,603 | £1,619 | £1,635 | £1,651 | £1,668 | £1,685 | £1,701 |
| Misc Candies/Products | 0% | £1,350 | £1,364 | £1,377 | £1,391 | £1,405 | £1,419 | £1,433 | £1,447 | £1,462 | £1,476 | £1,491 | £1,506 |
| Total Sales | £16,041 | £16,201 | £16,363 | £16,527 | £16,692 | £16,859 | £17,028 | £17,198 | £17,370 | £17,544 | £17,719 | £17,896 | |
| 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 | |
| Fresh Brewed Coffee | £108 | £109 | £110 | £111 | £112 | £114 | £115 | £116 | £117 | £118 | £119 | £120 | |
| Espresso Based Beverages | £304 | £307 | £310 | £313 | £316 | £320 | £323 | £326 | £329 | £332 | £336 | £339 | |
| Specialty Drinks | £569 | £575 | £580 | £586 | £592 | £598 | £604 | £610 | £616 | £622 | £629 | £635 | |
| Fresh Roasted Coffee | £458 | £463 | £467 | £472 | £477 | £481 | £486 | £491 | £496 | £501 | £506 | £511 | |
| Pastries/Desserts | 50% | £570 | £576 | £581 | £587 | £593 | £599 | £605 | £611 | £617 | £623 | £630 | £636 |
| Candies, etc. | 50% | £675 | £682 | £689 | £695 | £702 | £709 | £717 | £724 | £731 | £738 | £746 | £753 |
| Books/Music | £916 | £925 | £934 | £944 | £953 | £963 | £972 | £982 | £992 | £1,002 | £1,012 | £1,022 | |
| Subtotal Direct Cost of Sales | £3,600 | £3,636 | £3,672 | £3,709 | £3,746 | £3,784 | £3,821 | £3,860 | £3,898 | £3,937 | £3,977 | £4,016 | |
| 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 | ||
| Albert Brown - Operations Manager | 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 |
| Owner | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Baristas | 0% | £4,680 | £4,680 | £4,680 | £4,680 | £4,680 | £4,680 | £4,680 | £4,680 | £4,680 | £4,680 | £4,680 | £4,680 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | |
| 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 | £16,041 | £16,201 | £16,363 | £16,527 | £16,692 | £16,859 | £17,028 | £17,198 | £17,370 | £17,544 | £17,719 | £17,896 | |
| Direct Cost of Sales | £3,600 | £3,636 | £3,672 | £3,709 | £3,746 | £3,784 | £3,821 | £3,860 | £3,898 | £3,937 | £3,977 | £4,016 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £3,600 | £3,636 | £3,672 | £3,709 | £3,746 | £3,784 | £3,821 | £3,860 | £3,898 | £3,937 | £3,977 | £4,016 | |
| Gross Margin | £12,441 | £12,565 | £12,691 | £12,818 | £12,946 | £13,076 | £13,206 | £13,338 | £13,472 | £13,607 | £13,743 | £13,880 | |
| Gross Margin % | 77.56% | 77.56% | 77.56% | 77.56% | 77.56% | 77.56% | 77.56% | 77.56% | 77.56% | 77.56% | 77.56% | 77.56% | |
| Expenses | |||||||||||||
| Payroll | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | |
| Marketing/Promotion | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Depreciation | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | |
| Leased Equipment | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £400 | £400 | £400 | £400 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Rent | £2,365 | £2,365 | £2,365 | £2,365 | £2,365 | £2,365 | £2,365 | £2,365 | £2,365 | £2,365 | £2,365 | £2,365 | |
| Website Hosting and Maintenance | 0% | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 |
| Payroll Taxes | 15% | £927 | £927 | £927 | £927 | £927 | £927 | £927 | £927 | £916 | £927 | £927 | £927 |
| Other | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Total Operating Expenses | £11,614 | £11,614 | £11,614 | £11,614 | £11,614 | £11,614 | £11,614 | £11,614 | £11,703 | £11,714 | £11,714 | £11,714 | |
| Profit Before Interest and Taxes | £827 | £951 | £1,077 | £1,204 | £1,332 | £1,462 | £1,592 | £1,724 | £1,769 | £1,893 | £2,029 | £2,166 | |
| EBITDA | £994 | £1,118 | £1,244 | £1,371 | £1,499 | £1,629 | £1,759 | £1,891 | £1,936 | £2,060 | £2,196 | £2,333 | |
| Interest Expense | £132 | £131 | £131 | £130 | £129 | £128 | £127 | £126 | £125 | £124 | £123 | £122 | |
| Taxes Incurred | £174 | £205 | £237 | £269 | £301 | £333 | £366 | £400 | £411 | £442 | £476 | £511 | |
| Net Profit | £521 | £615 | £710 | £806 | £903 | £1,000 | £1,099 | £1,199 | £1,233 | £1,326 | £1,429 | £1,533 | |
| Net Profit/Sales | 3.25% | 3.80% | 4.34% | 4.88% | 5.41% | 5.93% | 6.45% | 6.97% | 7.10% | 7.56% | 8.07% | 8.57% | |
| 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 | £16,041 | £16,201 | £16,363 | £16,527 | £16,692 | £16,859 | £17,028 | £17,198 | £17,370 | £17,544 | £17,719 | £17,896 | |
| Subtotal Cash from Operations | £16,041 | £16,201 | £16,363 | £16,527 | £16,692 | £16,859 | £17,028 | £17,198 | £17,370 | £17,544 | £17,719 | £17,896 | |
| 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 | £16,041 | £16,201 | £16,363 | £16,527 | £16,692 | £16,859 | £17,028 | £17,198 | £17,370 | £17,544 | £17,719 | £17,896 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | £6,180 | |
| Bill Payments | £219 | £6,662 | £9,243 | £9,349 | £9,417 | £9,486 | £9,555 | £9,626 | £9,699 | £9,836 | £9,916 | £9,989 | |
| Subtotal Spent on Operations | £6,399 | £12,842 | £15,423 | £15,529 | £15,597 | £15,666 | £15,735 | £15,806 | £15,879 | £16,016 | £16,096 | £16,169 | |
| 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 | £555 | £555 | £555 | £555 | £555 | £555 | £555 | £555 | £555 | £555 | £555 | £555 | |
| 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 | £6,954 | £13,397 | £15,978 | £16,084 | £16,152 | £16,221 | £16,290 | £16,361 | £16,434 | £16,571 | £16,651 | £16,724 | |
| Net Cash Flow | £9,087 | £2,804 | £386 | £443 | £540 | £638 | £737 | £837 | £936 | £973 | £1,068 | £1,173 | |
| Cash Balance | £39,687 | £42,491 | £42,877 | £43,320 | £43,861 | £44,499 | £45,237 | £46,074 | £47,010 | £47,983 | £49,052 | £50,224 | |
| 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 | £30,600 | £39,687 | £42,491 | £42,877 | £43,320 | £43,861 | £44,499 | £45,237 | £46,074 | £47,010 | £47,983 | £49,052 | £50,224 |
| Inventory | £6,600 | £4,000 | £4,000 | £4,040 | £4,080 | £4,121 | £4,162 | £4,204 | £4,246 | £4,288 | £4,331 | £4,374 | £4,418 |
| Other Current Assets | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 |
| Total Current Assets | £49,200 | £55,687 | £58,491 | £58,917 | £59,400 | £59,982 | £60,661 | £61,440 | £62,320 | £63,298 | £64,314 | £65,426 | £66,642 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 |
| Accumulated Depreciation | £0 | £167 | £334 | £501 | £668 | £835 | £1,002 | £1,169 | £1,336 | £1,503 | £1,670 | £1,837 | £2,004 |
| Total Long-term Assets | £16,000 | £15,833 | £15,666 | £15,499 | £15,332 | £15,165 | £14,998 | £14,831 | £14,664 | £14,497 | £14,330 | £14,163 | £13,996 |
| Total Assets | £65,200 | £71,520 | £74,157 | £74,416 | £74,732 | £75,147 | £75,659 | £76,271 | £76,984 | £77,795 | £78,644 | £79,589 | £80,638 |
| 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 | £6,354 | £8,931 | £9,035 | £9,101 | £9,167 | £9,235 | £9,303 | £9,371 | £9,505 | £9,583 | £9,654 | £9,725 |
| 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 | £6,354 | £8,931 | £9,035 | £9,101 | £9,167 | £9,235 | £9,303 | £9,371 | £9,505 | £9,583 | £9,654 | £9,725 |
| Long-term Liabilities | £80,000 | £79,445 | £78,890 | £78,335 | £77,780 | £77,225 | £76,670 | £76,115 | £75,560 | £75,005 | £74,450 | £73,895 | £73,340 |
| Total Liabilities | £80,000 | £85,799 | £87,821 | £87,370 | £86,881 | £86,392 | £85,905 | £85,418 | £84,931 | £84,510 | £84,033 | £83,549 | £83,065 |
| Paid-in Capital | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Retained Earnings | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) | (£29,800) |
| Earnings | £0 | £521 | £1,136 | £1,846 | £2,652 | £3,554 | £4,554 | £5,654 | £6,852 | £8,085 | £9,412 | £10,841 | £12,373 |
| Total Capital | (£14,800) | (£14,279) | (£13,664) | (£12,954) | (£12,148) | (£11,246) | (£10,246) | (£9,146) | (£7,948) | (£6,715) | (£5,388) | (£3,959) | (£2,427) |
| Total Liabilities and Capital | £65,200 | £71,520 | £74,157 | £74,416 | £74,732 | £75,147 | £75,659 | £76,271 | £76,984 | £77,795 | £78,644 | £79,589 | £80,638 |
| Net Worth | (£14,800) | (£14,279) | (£13,664) | (£12,954) | (£12,148) | (£11,246) | (£10,246) | (£9,146) | (£7,948) | (£6,715) | (£5,388) | (£3,959) | (£2,427) |