| 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 | |||||||||||||
| Massage Therapy | 0% | £9,000 | £14,105 | £20,150 | £29,250 | £40,300 | £42,900 | £50,375 | £56,420 | £54,600 | £64,480 | £68,250 | £78,000 |
| Facials and Anti-Aging Treatments | 0% | £3,600 | £6,045 | £8,060 | £9,750 | £12,090 | £13,650 | £16,120 | £18,135 | £18,200 | £22,165 | £23,400 | £26,195 |
| Outcall Services | 0% | £400 | £800 | £1,200 | £1,600 | £1,600 | £1,760 | £2,080 | £2,400 | £2,560 | £2,800 | £3,200 | £3,200 |
| Retail | 0% | £1,240 | £2,480 | £3,100 | £3,600 | £4,650 | £6,000 | £6,975 | £7,750 | £9,800 | £15,500 | £16,500 | £17,250 |
| Total Sales | £14,240 | £23,430 | £32,510 | £44,200 | £58,640 | £64,310 | £75,550 | £84,705 | £85,160 | £104,945 | £111,350 | £124,645 | |
| 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 | |
| Linens and Cleaning | 1% | £65 | £105 | £147 | £203 | £270 | £292 | £343 | £385 | £377 | £447 | £474 | £537 |
| Oils & Lotions | 2% | £260 | £419 | £588 | £812 | £1,080 | £1,166 | £1,372 | £1,539 | £1,507 | £1,789 | £1,897 | £2,148 |
| Cost of Retail products / 50% of Sales | 50% | £620 | £1,240 | £1,550 | £1,800 | £2,325 | £3,000 | £3,488 | £3,875 | £4,900 | £7,750 | £8,250 | £8,625 |
| Subtotal Direct Cost of Sales | £945 | £1,764 | £2,285 | £2,815 | £3,675 | £4,458 | £5,202 | £5,799 | £6,784 | £9,986 | £10,621 | £11,310 | |
| 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 | ||
| Owner Draw | 0% | £3,750 | £5,000 | £6,000 | £7,500 | £8,000 | £8,500 | £9,000 | £9,500 | £10,000 | £11,000 | £12,500 | £12,500 |
| Front Desk | 0% | £0 | £1,500 | £1,820 | £1,820 | £3,640 | £3,640 | £3,640 | £3,640 | £3,640 | £3,640 | £3,640 | £3,640 |
| Total People | 1 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £3,750 | £6,500 | £7,820 | £9,320 | £11,640 | £12,140 | £12,640 | £13,140 | £13,640 | £14,640 | £16,140 | £16,140 | |
| 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 | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Long-term Interest Rate | 5.65% | 5.65% | 5.65% | 5.65% | 5.65% | 5.65% | 5.65% | 5.65% | 5.65% | 5.65% | 5.65% | 5.65% | |
| Tax Rate | 30.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.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 | £14,240 | £23,430 | £32,510 | £44,200 | £58,640 | £64,310 | £75,550 | £84,705 | £85,160 | £104,945 | £111,350 | £124,645 | |
| Direct Cost of Sales | £945 | £1,764 | £2,285 | £2,815 | £3,675 | £4,458 | £5,202 | £5,799 | £6,784 | £9,986 | £10,621 | £11,310 | |
| Massage Therapists' commission | 55% | £4,950 | £7,758 | £11,083 | £16,088 | £22,165 | £23,595 | £27,706 | £31,031 | £30,030 | £35,464 | £37,538 | £42,900 |
| Aestheticians' commission | 40% | £1,440 | £2,418 | £3,224 | £3,900 | £4,836 | £5,460 | £6,448 | £7,254 | £7,280 | £8,866 | £9,360 | £10,478 |
| Out-call Services commission | 65% | £260 | £520 | £780 | £1,040 | £1,040 | £1,144 | £1,352 | £1,560 | £1,664 | £1,820 | £2,080 | £2,080 |
| Total Cost of Sales | £7,595 | £12,460 | £17,372 | £23,843 | £31,716 | £34,657 | £40,708 | £45,644 | £45,758 | £56,136 | £59,599 | £66,768 | |
| Gross Margin | £6,645 | £10,971 | £15,138 | £20,358 | £26,924 | £29,653 | £34,842 | £39,061 | £39,402 | £48,809 | £51,751 | £57,877 | |
| Gross Margin % | 46.66% | 46.82% | 46.56% | 46.06% | 45.91% | 46.11% | 46.12% | 46.11% | 46.27% | 46.51% | 46.48% | 46.43% | |
| Expenses | |||||||||||||
| Payroll | £3,750 | £6,500 | £7,820 | £9,320 | £11,640 | £12,140 | £12,640 | £13,140 | £13,640 | £14,640 | £16,140 | £16,140 | |
| Marketing/Promotion | £2,000 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | |
| Utilities | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Advertising | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Insurance | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Payroll Taxes | 20% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Phone | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Software Support | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £100 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Total Operating Expenses | £12,100 | £13,850 | £15,170 | £16,670 | £18,990 | £19,490 | £19,990 | £20,490 | £20,990 | £21,990 | £23,490 | £23,490 | |
| Profit Before Interest and Taxes | (£5,455) | (£2,880) | (£32) | £3,688 | £7,934 | £10,163 | £14,852 | £18,571 | £18,412 | £26,819 | £28,261 | £34,387 | |
| EBITDA | (£5,455) | (£2,880) | (£32) | £3,688 | £7,934 | £10,163 | £14,852 | £18,571 | £18,412 | £26,819 | £28,261 | £34,387 | |
| Interest Expense | £200 | £196 | £192 | £188 | £184 | £180 | £176 | £172 | £167 | £163 | £159 | £155 | |
| Taxes Incurred | (£1,697) | (£861) | (£63) | £980 | £2,170 | £2,795 | £4,109 | £5,152 | £5,108 | £7,464 | £7,869 | £9,585 | |
| Net Profit | (£3,959) | (£2,214) | (£161) | £2,520 | £5,580 | £7,188 | £10,567 | £13,248 | £13,136 | £19,192 | £20,233 | £24,647 | |
| Net Profit/Sales | -27.80% | -9.45% | -0.50% | 5.70% | 9.52% | 11.18% | 13.99% | 15.64% | 15.43% | 18.29% | 18.17% | 19.77% | |
| 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 | £14,098 | £22,961 | £31,535 | £42,874 | £56,881 | £62,381 | £73,284 | £82,164 | £82,605 | £101,797 | £108,010 | £120,906 | |
| Cash from Receivables | £0 | £0 | £5 | £153 | £485 | £987 | £1,340 | £1,765 | £1,941 | £2,276 | £2,542 | £2,575 | |
| Subtotal Cash from Operations | £14,098 | £22,961 | £31,539 | £43,027 | £57,366 | £63,368 | £74,624 | £83,929 | £84,546 | £104,072 | £110,551 | £123,480 | |
| 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 | £14,098 | £22,961 | £31,539 | £43,027 | £57,366 | £63,368 | £74,624 | £83,929 | £84,546 | £104,072 | £110,551 | £123,480 | |
| 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 | £3,750 | £6,500 | £7,820 | £9,320 | £11,640 | £12,140 | £12,640 | £13,140 | £13,640 | £14,640 | £16,140 | £16,140 | |
| Bill Payments | £450 | £13,633 | £17,604 | £24,369 | £33,257 | £42,481 | £46,087 | £53,355 | £58,990 | £59,973 | £74,670 | £75,973 | |
| Subtotal Spent on Operations | £4,200 | £20,133 | £25,424 | £33,689 | £44,897 | £54,621 | £58,727 | £66,495 | £72,630 | £74,613 | £90,810 | £92,113 | |
| 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 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | |
| 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 | £4,900 | £20,833 | £26,124 | £34,389 | £45,597 | £55,321 | £59,427 | £67,195 | £73,330 | £75,313 | £91,510 | £92,813 | |
| Net Cash Flow | £9,197 | £2,129 | £5,416 | £8,638 | £11,769 | £8,046 | £15,197 | £16,733 | £11,215 | £28,759 | £19,041 | £30,667 | |
| Cash Balance | £55,652 | £57,781 | £63,197 | £71,835 | £83,604 | £91,651 | £106,847 | £123,581 | £134,796 | £163,555 | £182,596 | £213,263 | |
| 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 | £46,455 | £55,652 | £57,781 | £63,197 | £71,835 | £83,604 | £91,651 | £106,847 | £123,581 | £134,796 | £163,555 | £182,596 | £213,263 |
| Accounts Receivable | £0 | £142 | £611 | £1,582 | £2,754 | £4,028 | £4,970 | £5,896 | £6,673 | £7,287 | £8,160 | £8,958 | £10,123 |
| Inventory | £6,000 | £5,055 | £3,291 | £2,514 | £3,097 | £4,042 | £4,904 | £5,722 | £6,379 | £7,462 | £10,985 | £11,683 | £12,441 |
| Other Current Assets | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 |
| Total Current Assets | £84,550 | £92,945 | £93,778 | £99,387 | £109,781 | £123,769 | £133,619 | £150,561 | £168,727 | £181,640 | £214,795 | £235,333 | £267,923 |
| 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 | £84,550 | £92,945 | £93,778 | £99,387 | £109,781 | £123,769 | £133,619 | £150,561 | £168,727 | £181,640 | £214,795 | £235,333 | £267,923 |
| 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 | £13,053 | £16,801 | £23,271 | £31,845 | £40,953 | £44,315 | £51,390 | £57,008 | £57,485 | £72,148 | £73,153 | £81,795 |
| Current Borrowing | £35,000 | £34,300 | £33,600 | £32,900 | £32,200 | £31,500 | £30,800 | £30,100 | £29,400 | £28,700 | £28,000 | £27,300 | £26,600 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £35,000 | £47,353 | £50,401 | £56,171 | £64,045 | £72,453 | £75,115 | £81,490 | £86,408 | £86,185 | £100,148 | £100,453 | £108,395 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £35,000 | £47,353 | £50,401 | £56,171 | £64,045 | £72,453 | £75,115 | £81,490 | £86,408 | £86,185 | £100,148 | £100,453 | £108,395 |
| Paid-in Capital | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 |
| Retained Earnings | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) |
| Earnings | £0 | (£3,959) | (£6,173) | (£6,334) | (£3,814) | £1,766 | £8,954 | £19,521 | £32,769 | £45,905 | £65,097 | £85,331 | £109,978 |
| Total Capital | £49,550 | £45,591 | £43,377 | £43,216 | £45,736 | £51,316 | £58,504 | £69,071 | £82,319 | £95,455 | £114,647 | £134,881 | £159,528 |
| Total Liabilities and Capital | £84,550 | £92,945 | £93,778 | £99,387 | £109,781 | £123,769 | £133,619 | £150,561 | £168,727 | £181,640 | £214,795 | £235,333 | £267,923 |
| Net Worth | £49,550 | £45,591 | £43,377 | £43,216 | £45,736 | £51,316 | £58,504 | £69,071 | £82,319 | £95,455 | £114,647 | £134,881 | £159,528 |
| 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 | |||||||||||||
| Massage Therapy | 0% | £9,000 | £14,105 | £20,150 | £29,250 | £40,300 | £42,900 | £50,375 | £56,420 | £54,600 | £64,480 | £68,250 | £78,000 |
| Facials and Anti-Aging Treatments | 0% | £3,600 | £6,045 | £8,060 | £9,750 | £12,090 | £13,650 | £16,120 | £18,135 | £18,200 | £22,165 | £23,400 | £26,195 |
| Outcall Services | 0% | £400 | £800 | £1,200 | £1,600 | £1,600 | £1,760 | £2,080 | £2,400 | £2,560 | £2,800 | £3,200 | £3,200 |
| Retail | 0% | £1,240 | £2,480 | £3,100 | £3,600 | £4,650 | £6,000 | £6,975 | £7,750 | £9,800 | £15,500 | £16,500 | £17,250 |
| Total Sales | £14,240 | £23,430 | £32,510 | £44,200 | £58,640 | £64,310 | £75,550 | £84,705 | £85,160 | £104,945 | £111,350 | £124,645 | |
| 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 | |
| Linens and Cleaning | 1% | £65 | £105 | £147 | £203 | £270 | £292 | £343 | £385 | £377 | £447 | £474 | £537 |
| Oils & Lotions | 2% | £260 | £419 | £588 | £812 | £1,080 | £1,166 | £1,372 | £1,539 | £1,507 | £1,789 | £1,897 | £2,148 |
| Cost of Retail products / 50% of Sales | 50% | £620 | £1,240 | £1,550 | £1,800 | £2,325 | £3,000 | £3,488 | £3,875 | £4,900 | £7,750 | £8,250 | £8,625 |
| Subtotal Direct Cost of Sales | £945 | £1,764 | £2,285 | £2,815 | £3,675 | £4,458 | £5,202 | £5,799 | £6,784 | £9,986 | £10,621 | £11,310 | |
| 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 | ||
| Owner Draw | 0% | £3,750 | £5,000 | £6,000 | £7,500 | £8,000 | £8,500 | £9,000 | £9,500 | £10,000 | £11,000 | £12,500 | £12,500 |
| Front Desk | 0% | £0 | £1,500 | £1,820 | £1,820 | £3,640 | £3,640 | £3,640 | £3,640 | £3,640 | £3,640 | £3,640 | £3,640 |
| Total People | 1 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £3,750 | £6,500 | £7,820 | £9,320 | £11,640 | £12,140 | £12,640 | £13,140 | £13,640 | £14,640 | £16,140 | £16,140 | |
| 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 | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Long-term Interest Rate | 5.65% | 5.65% | 5.65% | 5.65% | 5.65% | 5.65% | 5.65% | 5.65% | 5.65% | 5.65% | 5.65% | 5.65% | |
| Tax Rate | 30.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.00% | 28.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 | £14,240 | £23,430 | £32,510 | £44,200 | £58,640 | £64,310 | £75,550 | £84,705 | £85,160 | £104,945 | £111,350 | £124,645 | |
| Direct Cost of Sales | £945 | £1,764 | £2,285 | £2,815 | £3,675 | £4,458 | £5,202 | £5,799 | £6,784 | £9,986 | £10,621 | £11,310 | |
| Massage Therapists' commission | 55% | £4,950 | £7,758 | £11,083 | £16,088 | £22,165 | £23,595 | £27,706 | £31,031 | £30,030 | £35,464 | £37,538 | £42,900 |
| Aestheticians' commission | 40% | £1,440 | £2,418 | £3,224 | £3,900 | £4,836 | £5,460 | £6,448 | £7,254 | £7,280 | £8,866 | £9,360 | £10,478 |
| Out-call Services commission | 65% | £260 | £520 | £780 | £1,040 | £1,040 | £1,144 | £1,352 | £1,560 | £1,664 | £1,820 | £2,080 | £2,080 |
| Total Cost of Sales | £7,595 | £12,460 | £17,372 | £23,843 | £31,716 | £34,657 | £40,708 | £45,644 | £45,758 | £56,136 | £59,599 | £66,768 | |
| Gross Margin | £6,645 | £10,971 | £15,138 | £20,358 | £26,924 | £29,653 | £34,842 | £39,061 | £39,402 | £48,809 | £51,751 | £57,877 | |
| Gross Margin % | 46.66% | 46.82% | 46.56% | 46.06% | 45.91% | 46.11% | 46.12% | 46.11% | 46.27% | 46.51% | 46.48% | 46.43% | |
| Expenses | |||||||||||||
| Payroll | £3,750 | £6,500 | £7,820 | £9,320 | £11,640 | £12,140 | £12,640 | £13,140 | £13,640 | £14,640 | £16,140 | £16,140 | |
| Marketing/Promotion | £2,000 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | |
| Utilities | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Advertising | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Insurance | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Payroll Taxes | 20% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Phone | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Software Support | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £100 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Total Operating Expenses | £12,100 | £13,850 | £15,170 | £16,670 | £18,990 | £19,490 | £19,990 | £20,490 | £20,990 | £21,990 | £23,490 | £23,490 | |
| Profit Before Interest and Taxes | (£5,455) | (£2,880) | (£32) | £3,688 | £7,934 | £10,163 | £14,852 | £18,571 | £18,412 | £26,819 | £28,261 | £34,387 | |
| EBITDA | (£5,455) | (£2,880) | (£32) | £3,688 | £7,934 | £10,163 | £14,852 | £18,571 | £18,412 | £26,819 | £28,261 | £34,387 | |
| Interest Expense | £200 | £196 | £192 | £188 | £184 | £180 | £176 | £172 | £167 | £163 | £159 | £155 | |
| Taxes Incurred | (£1,697) | (£861) | (£63) | £980 | £2,170 | £2,795 | £4,109 | £5,152 | £5,108 | £7,464 | £7,869 | £9,585 | |
| Net Profit | (£3,959) | (£2,214) | (£161) | £2,520 | £5,580 | £7,188 | £10,567 | £13,248 | £13,136 | £19,192 | £20,233 | £24,647 | |
| Net Profit/Sales | -27.80% | -9.45% | -0.50% | 5.70% | 9.52% | 11.18% | 13.99% | 15.64% | 15.43% | 18.29% | 18.17% | 19.77% | |
| 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 | £14,098 | £22,961 | £31,535 | £42,874 | £56,881 | £62,381 | £73,284 | £82,164 | £82,605 | £101,797 | £108,010 | £120,906 | |
| Cash from Receivables | £0 | £0 | £5 | £153 | £485 | £987 | £1,340 | £1,765 | £1,941 | £2,276 | £2,542 | £2,575 | |
| Subtotal Cash from Operations | £14,098 | £22,961 | £31,539 | £43,027 | £57,366 | £63,368 | £74,624 | £83,929 | £84,546 | £104,072 | £110,551 | £123,480 | |
| 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 | £14,098 | £22,961 | £31,539 | £43,027 | £57,366 | £63,368 | £74,624 | £83,929 | £84,546 | £104,072 | £110,551 | £123,480 | |
| 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 | £3,750 | £6,500 | £7,820 | £9,320 | £11,640 | £12,140 | £12,640 | £13,140 | £13,640 | £14,640 | £16,140 | £16,140 | |
| Bill Payments | £450 | £13,633 | £17,604 | £24,369 | £33,257 | £42,481 | £46,087 | £53,355 | £58,990 | £59,973 | £74,670 | £75,973 | |
| Subtotal Spent on Operations | £4,200 | £20,133 | £25,424 | £33,689 | £44,897 | £54,621 | £58,727 | £66,495 | £72,630 | £74,613 | £90,810 | £92,113 | |
| 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 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | |
| 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 | £4,900 | £20,833 | £26,124 | £34,389 | £45,597 | £55,321 | £59,427 | £67,195 | £73,330 | £75,313 | £91,510 | £92,813 | |
| Net Cash Flow | £9,197 | £2,129 | £5,416 | £8,638 | £11,769 | £8,046 | £15,197 | £16,733 | £11,215 | £28,759 | £19,041 | £30,667 | |
| Cash Balance | £55,652 | £57,781 | £63,197 | £71,835 | £83,604 | £91,651 | £106,847 | £123,581 | £134,796 | £163,555 | £182,596 | £213,263 | |
| 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 | £46,455 | £55,652 | £57,781 | £63,197 | £71,835 | £83,604 | £91,651 | £106,847 | £123,581 | £134,796 | £163,555 | £182,596 | £213,263 |
| Accounts Receivable | £0 | £142 | £611 | £1,582 | £2,754 | £4,028 | £4,970 | £5,896 | £6,673 | £7,287 | £8,160 | £8,958 | £10,123 |
| Inventory | £6,000 | £5,055 | £3,291 | £2,514 | £3,097 | £4,042 | £4,904 | £5,722 | £6,379 | £7,462 | £10,985 | £11,683 | £12,441 |
| Other Current Assets | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 | £32,095 |
| Total Current Assets | £84,550 | £92,945 | £93,778 | £99,387 | £109,781 | £123,769 | £133,619 | £150,561 | £168,727 | £181,640 | £214,795 | £235,333 | £267,923 |
| 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 | £84,550 | £92,945 | £93,778 | £99,387 | £109,781 | £123,769 | £133,619 | £150,561 | £168,727 | £181,640 | £214,795 | £235,333 | £267,923 |
| 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 | £13,053 | £16,801 | £23,271 | £31,845 | £40,953 | £44,315 | £51,390 | £57,008 | £57,485 | £72,148 | £73,153 | £81,795 |
| Current Borrowing | £35,000 | £34,300 | £33,600 | £32,900 | £32,200 | £31,500 | £30,800 | £30,100 | £29,400 | £28,700 | £28,000 | £27,300 | £26,600 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £35,000 | £47,353 | £50,401 | £56,171 | £64,045 | £72,453 | £75,115 | £81,490 | £86,408 | £86,185 | £100,148 | £100,453 | £108,395 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £35,000 | £47,353 | £50,401 | £56,171 | £64,045 | £72,453 | £75,115 | £81,490 | £86,408 | £86,185 | £100,148 | £100,453 | £108,395 |
| Paid-in Capital | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 | £130,000 |
| Retained Earnings | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) | (£80,450) |
| Earnings | £0 | (£3,959) | (£6,173) | (£6,334) | (£3,814) | £1,766 | £8,954 | £19,521 | £32,769 | £45,905 | £65,097 | £85,331 | £109,978 |
| Total Capital | £49,550 | £45,591 | £43,377 | £43,216 | £45,736 | £51,316 | £58,504 | £69,071 | £82,319 | £95,455 | £114,647 | £134,881 | £159,528 |
| Total Liabilities and Capital | £84,550 | £92,945 | £93,778 | £99,387 | £109,781 | £123,769 | £133,619 | £150,561 | £168,727 | £181,640 | £214,795 | £235,333 | £267,923 |
| Net Worth | £49,550 | £45,591 | £43,377 | £43,216 | £45,736 | £51,316 | £58,504 | £69,071 | £82,319 | £95,455 | £114,647 | £134,881 | £159,528 |