| 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 | |||||||||||||
| Sports massage | 0% | £0 | £0 | £0 | £804 | £1,474 | £2,446 | £2,613 | £3,015 | £3,618 | £3,953 | £4,288 | £4,559 |
| Personal trainer | 0% | £0 | £0 | £0 | £768 | £1,408 | £2,336 | £2,496 | £2,880 | £3,456 | £3,776 | £4,096 | £4,355 |
| Fitness assessment | 0% | £0 | £0 | £0 | £648 | £1,188 | £1,971 | £2,106 | £2,430 | £2,916 | £3,186 | £3,456 | £3,675 |
| Bike fit | 0% | £0 | £0 | £0 | £684 | £1,254 | £2,081 | £2,223 | £2,565 | £3,078 | £3,363 | £3,648 | £3,879 |
| Cycling related injuries | 0% | £0 | £0 | £0 | £1,200 | £2,200 | £3,650 | £3,900 | £4,500 | £5,400 | £5,900 | £6,400 | £6,805 |
| Total Sales | £0 | £0 | £0 | £4,104 | £7,524 | £12,483 | £13,338 | £15,390 | £18,468 | £20,178 | £21,888 | £23,273 | |
| 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 | |
| Sports massage | £0 | £0 | £0 | £40 | £74 | £122 | £131 | £151 | £181 | £198 | £214 | £228 | |
| Personal trainer | £0 | £0 | £0 | £38 | £70 | £117 | £125 | £144 | £173 | £189 | £205 | £218 | |
| Fitness assessment | £0 | £0 | £0 | £32 | £59 | £99 | £105 | £122 | £146 | £159 | £173 | £184 | |
| Bike fit | £0 | £0 | £0 | £34 | £63 | £104 | £111 | £128 | £154 | £168 | £182 | £194 | |
| Cycling related injuries | £0 | £0 | £0 | £60 | £110 | £183 | £195 | £225 | £270 | £295 | £320 | £340 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £205 | £376 | £624 | £667 | £770 | £923 | £1,009 | £1,094 | £1,164 | |
| 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 | ||
| Arthur | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Physician | 0% | £0 | £0 | £0 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Massage therapist | 0% | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Massage therapist | 0% | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Physical therapist | 0% | £0 | £0 | £0 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Physical therapist | 0% | £0 | £0 | £0 | £0 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Coach/trainer | 0% | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Receptionist | 0% | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Accounting clerk/receptionist | 0% | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Total People | 0 | 0 | 0 | 7 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | |
| Total Payroll | £0 | £0 | £2,000 | £16,000 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | |
| 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% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | £0 | £0 | £0 | £4,104 | £7,524 | £12,483 | £13,338 | £15,390 | £18,468 | £20,178 | £21,888 | £23,273 | |
| Direct Cost of Sales | £0 | £0 | £0 | £205 | £376 | £624 | £667 | £770 | £923 | £1,009 | £1,094 | £1,164 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £205 | £376 | £624 | £667 | £770 | £923 | £1,009 | £1,094 | £1,164 | |
| Gross Margin | £0 | £0 | £0 | £3,899 | £7,148 | £11,859 | £12,671 | £14,621 | £17,545 | £19,169 | £20,794 | £22,109 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £2,000 | £16,000 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | |
| Sales and Marketing and Other Expenses | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Depreciation | £367 | £367 | £367 | £367 | £367 | £367 | £367 | £367 | £367 | £367 | £367 | £367 | |
| 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 | |
| Utilities | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | |
| Insurance | 15% | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 |
| Payroll Taxes | 15% | £0 | £0 | £300 | £2,400 | £3,225 | £3,225 | £3,225 | £3,225 | £3,225 | £3,225 | £3,225 | £3,225 |
| Total Operating Expenses | £2,457 | £2,457 | £4,757 | £20,857 | £27,182 | £27,182 | £27,182 | £27,182 | £27,182 | £27,182 | £27,182 | £27,182 | |
| Profit Before Interest and Taxes | (£2,457) | (£2,457) | (£4,757) | (£16,958) | (£20,034) | (£15,323) | (£14,511) | (£12,562) | (£9,637) | (£8,013) | (£6,388) | (£5,073) | |
| EBITDA | (£2,090) | (£2,090) | (£4,390) | (£16,591) | (£19,667) | (£14,956) | (£14,144) | (£12,195) | (£9,270) | (£7,646) | (£6,021) | (£4,706) | |
| Interest Expense | £247 | £244 | £240 | £237 | £234 | £230 | £227 | £223 | £220 | £216 | £213 | £209 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£2,704) | (£2,701) | (£4,997) | (£17,195) | (£20,268) | (£15,553) | (£14,738) | (£12,785) | (£9,857) | (£8,229) | (£6,601) | (£5,282) | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | -418.98% | -269.38% | -124.60% | -110.49% | -83.07% | -53.38% | -40.78% | -30.16% | -22.70% | |
| 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 | £0 | £0 | £0 | £4,104 | £7,524 | £12,483 | £13,338 | £15,390 | £18,468 | £20,178 | £21,888 | £23,273 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £4,104 | £7,524 | £12,483 | £13,338 | £15,390 | £18,468 | £20,178 | £21,888 | £23,273 | |
| 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 | £0 | £0 | £0 | £4,104 | £7,524 | £12,483 | £13,338 | £15,390 | £18,468 | £20,178 | £21,888 | £23,273 | |
| 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 | £0 | £0 | £2,000 | £16,000 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | |
| Bill Payments | £78 | £2,337 | £2,343 | £2,707 | £4,965 | £5,933 | £6,171 | £6,212 | £6,313 | £6,461 | £6,543 | £6,625 | |
| Subtotal Spent on Operations | £78 | £2,337 | £4,343 | £18,707 | £26,465 | £27,433 | £27,671 | £27,712 | £27,813 | £27,961 | £28,043 | £28,125 | |
| 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 | £387 | £391 | £394 | £397 | £400 | £404 | £407 | £411 | £414 | £417 | £421 | £424 | |
| 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 | £465 | £2,727 | £4,737 | £19,104 | £26,866 | £27,837 | £28,078 | £28,123 | £28,227 | £28,379 | £28,464 | £28,549 | |
| Net Cash Flow | (£465) | (£2,727) | (£4,737) | (£15,000) | (£19,342) | (£15,354) | (£14,740) | (£12,733) | (£9,759) | (£8,201) | (£6,576) | (£5,276) | |
| Cash Balance | £121,035 | £118,307 | £113,570 | £98,570 | £79,228 | £63,874 | £49,135 | £36,402 | £26,643 | £18,443 | £11,866 | £6,591 | |
| 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 | £121,500 | £121,035 | £118,307 | £113,570 | £98,570 | £79,228 | £63,874 | £49,135 | £36,402 | £26,643 | £18,443 | £11,866 | £6,591 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £121,500 | £121,035 | £118,307 | £113,570 | £98,570 | £79,228 | £63,874 | £49,135 | £36,402 | £26,643 | £18,443 | £11,866 | £6,591 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 |
| Accumulated Depreciation | £0 | £367 | £734 | £1,101 | £1,468 | £1,835 | £2,202 | £2,569 | £2,936 | £3,303 | £3,670 | £4,037 | £4,404 |
| Total Long-term Assets | £22,000 | £21,633 | £21,266 | £20,899 | £20,532 | £20,165 | £19,798 | £19,431 | £19,064 | £18,697 | £18,330 | £17,963 | £17,596 |
| Total Assets | £143,500 | £142,668 | £139,573 | £134,469 | £119,102 | £99,393 | £83,672 | £68,566 | £55,466 | £45,340 | £36,773 | £29,829 | £24,187 |
| 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 | £2,259 | £2,256 | £2,543 | £4,768 | £5,727 | £5,964 | £6,002 | £6,098 | £6,243 | £6,322 | £6,402 | £6,465 |
| 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 | £2,259 | £2,256 | £2,543 | £4,768 | £5,727 | £5,964 | £6,002 | £6,098 | £6,243 | £6,322 | £6,402 | £6,465 |
| Long-term Liabilities | £30,000 | £29,613 | £29,222 | £28,828 | £28,431 | £28,030 | £27,627 | £27,219 | £26,809 | £26,395 | £25,977 | £25,556 | £25,132 |
| Total Liabilities | £30,000 | £31,871 | £31,478 | £31,371 | £33,199 | £33,758 | £33,590 | £33,221 | £32,906 | £32,638 | £32,300 | £31,958 | £31,597 |
| Paid-in Capital | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 |
| Retained Earnings | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) |
| Earnings | £0 | (£2,704) | (£5,404) | (£10,402) | (£27,597) | (£47,864) | (£63,418) | (£78,156) | (£90,940) | (£100,798) | (£109,027) | (£115,629) | (£120,911) |
| Total Capital | £113,500 | £110,796 | £108,096 | £103,098 | £85,903 | £65,636 | £50,082 | £35,344 | £22,560 | £12,702 | £4,473 | (£2,129) | (£7,411) |
| Total Liabilities and Capital | £143,500 | £142,668 | £139,573 | £134,469 | £119,102 | £99,393 | £83,672 | £68,566 | £55,466 | £45,340 | £36,773 | £29,829 | £24,187 |
| Net Worth | £113,500 | £110,796 | £108,096 | £103,098 | £85,903 | £65,636 | £50,082 | £35,344 | £22,560 | £12,702 | £4,473 | (£2,129) | (£7,411) |
| 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 | |||||||||||||
| Sports massage | 0% | £0 | £0 | £0 | £804 | £1,474 | £2,446 | £2,613 | £3,015 | £3,618 | £3,953 | £4,288 | £4,559 |
| Personal trainer | 0% | £0 | £0 | £0 | £768 | £1,408 | £2,336 | £2,496 | £2,880 | £3,456 | £3,776 | £4,096 | £4,355 |
| Fitness assessment | 0% | £0 | £0 | £0 | £648 | £1,188 | £1,971 | £2,106 | £2,430 | £2,916 | £3,186 | £3,456 | £3,675 |
| Bike fit | 0% | £0 | £0 | £0 | £684 | £1,254 | £2,081 | £2,223 | £2,565 | £3,078 | £3,363 | £3,648 | £3,879 |
| Cycling related injuries | 0% | £0 | £0 | £0 | £1,200 | £2,200 | £3,650 | £3,900 | £4,500 | £5,400 | £5,900 | £6,400 | £6,805 |
| Total Sales | £0 | £0 | £0 | £4,104 | £7,524 | £12,483 | £13,338 | £15,390 | £18,468 | £20,178 | £21,888 | £23,273 | |
| 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 | |
| Sports massage | £0 | £0 | £0 | £40 | £74 | £122 | £131 | £151 | £181 | £198 | £214 | £228 | |
| Personal trainer | £0 | £0 | £0 | £38 | £70 | £117 | £125 | £144 | £173 | £189 | £205 | £218 | |
| Fitness assessment | £0 | £0 | £0 | £32 | £59 | £99 | £105 | £122 | £146 | £159 | £173 | £184 | |
| Bike fit | £0 | £0 | £0 | £34 | £63 | £104 | £111 | £128 | £154 | £168 | £182 | £194 | |
| Cycling related injuries | £0 | £0 | £0 | £60 | £110 | £183 | £195 | £225 | £270 | £295 | £320 | £340 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £205 | £376 | £624 | £667 | £770 | £923 | £1,009 | £1,094 | £1,164 | |
| 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 | ||
| Arthur | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Physician | 0% | £0 | £0 | £0 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Massage therapist | 0% | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Massage therapist | 0% | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Physical therapist | 0% | £0 | £0 | £0 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Physical therapist | 0% | £0 | £0 | £0 | £0 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Coach/trainer | 0% | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Receptionist | 0% | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Accounting clerk/receptionist | 0% | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Total People | 0 | 0 | 0 | 7 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | |
| Total Payroll | £0 | £0 | £2,000 | £16,000 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | |
| 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% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | £0 | £0 | £0 | £4,104 | £7,524 | £12,483 | £13,338 | £15,390 | £18,468 | £20,178 | £21,888 | £23,273 | |
| Direct Cost of Sales | £0 | £0 | £0 | £205 | £376 | £624 | £667 | £770 | £923 | £1,009 | £1,094 | £1,164 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £205 | £376 | £624 | £667 | £770 | £923 | £1,009 | £1,094 | £1,164 | |
| Gross Margin | £0 | £0 | £0 | £3,899 | £7,148 | £11,859 | £12,671 | £14,621 | £17,545 | £19,169 | £20,794 | £22,109 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £2,000 | £16,000 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | |
| Sales and Marketing and Other Expenses | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Depreciation | £367 | £367 | £367 | £367 | £367 | £367 | £367 | £367 | £367 | £367 | £367 | £367 | |
| 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 | |
| Utilities | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | |
| Insurance | 15% | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 |
| Payroll Taxes | 15% | £0 | £0 | £300 | £2,400 | £3,225 | £3,225 | £3,225 | £3,225 | £3,225 | £3,225 | £3,225 | £3,225 |
| Total Operating Expenses | £2,457 | £2,457 | £4,757 | £20,857 | £27,182 | £27,182 | £27,182 | £27,182 | £27,182 | £27,182 | £27,182 | £27,182 | |
| Profit Before Interest and Taxes | (£2,457) | (£2,457) | (£4,757) | (£16,958) | (£20,034) | (£15,323) | (£14,511) | (£12,562) | (£9,637) | (£8,013) | (£6,388) | (£5,073) | |
| EBITDA | (£2,090) | (£2,090) | (£4,390) | (£16,591) | (£19,667) | (£14,956) | (£14,144) | (£12,195) | (£9,270) | (£7,646) | (£6,021) | (£4,706) | |
| Interest Expense | £247 | £244 | £240 | £237 | £234 | £230 | £227 | £223 | £220 | £216 | £213 | £209 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£2,704) | (£2,701) | (£4,997) | (£17,195) | (£20,268) | (£15,553) | (£14,738) | (£12,785) | (£9,857) | (£8,229) | (£6,601) | (£5,282) | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | -418.98% | -269.38% | -124.60% | -110.49% | -83.07% | -53.38% | -40.78% | -30.16% | -22.70% | |
| 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 | £0 | £0 | £0 | £4,104 | £7,524 | £12,483 | £13,338 | £15,390 | £18,468 | £20,178 | £21,888 | £23,273 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £4,104 | £7,524 | £12,483 | £13,338 | £15,390 | £18,468 | £20,178 | £21,888 | £23,273 | |
| 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 | £0 | £0 | £0 | £4,104 | £7,524 | £12,483 | £13,338 | £15,390 | £18,468 | £20,178 | £21,888 | £23,273 | |
| 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 | £0 | £0 | £2,000 | £16,000 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | £21,500 | |
| Bill Payments | £78 | £2,337 | £2,343 | £2,707 | £4,965 | £5,933 | £6,171 | £6,212 | £6,313 | £6,461 | £6,543 | £6,625 | |
| Subtotal Spent on Operations | £78 | £2,337 | £4,343 | £18,707 | £26,465 | £27,433 | £27,671 | £27,712 | £27,813 | £27,961 | £28,043 | £28,125 | |
| 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 | £387 | £391 | £394 | £397 | £400 | £404 | £407 | £411 | £414 | £417 | £421 | £424 | |
| 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 | £465 | £2,727 | £4,737 | £19,104 | £26,866 | £27,837 | £28,078 | £28,123 | £28,227 | £28,379 | £28,464 | £28,549 | |
| Net Cash Flow | (£465) | (£2,727) | (£4,737) | (£15,000) | (£19,342) | (£15,354) | (£14,740) | (£12,733) | (£9,759) | (£8,201) | (£6,576) | (£5,276) | |
| Cash Balance | £121,035 | £118,307 | £113,570 | £98,570 | £79,228 | £63,874 | £49,135 | £36,402 | £26,643 | £18,443 | £11,866 | £6,591 | |
| 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 | £121,500 | £121,035 | £118,307 | £113,570 | £98,570 | £79,228 | £63,874 | £49,135 | £36,402 | £26,643 | £18,443 | £11,866 | £6,591 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £121,500 | £121,035 | £118,307 | £113,570 | £98,570 | £79,228 | £63,874 | £49,135 | £36,402 | £26,643 | £18,443 | £11,866 | £6,591 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 |
| Accumulated Depreciation | £0 | £367 | £734 | £1,101 | £1,468 | £1,835 | £2,202 | £2,569 | £2,936 | £3,303 | £3,670 | £4,037 | £4,404 |
| Total Long-term Assets | £22,000 | £21,633 | £21,266 | £20,899 | £20,532 | £20,165 | £19,798 | £19,431 | £19,064 | £18,697 | £18,330 | £17,963 | £17,596 |
| Total Assets | £143,500 | £142,668 | £139,573 | £134,469 | £119,102 | £99,393 | £83,672 | £68,566 | £55,466 | £45,340 | £36,773 | £29,829 | £24,187 |
| 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 | £2,259 | £2,256 | £2,543 | £4,768 | £5,727 | £5,964 | £6,002 | £6,098 | £6,243 | £6,322 | £6,402 | £6,465 |
| 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 | £2,259 | £2,256 | £2,543 | £4,768 | £5,727 | £5,964 | £6,002 | £6,098 | £6,243 | £6,322 | £6,402 | £6,465 |
| Long-term Liabilities | £30,000 | £29,613 | £29,222 | £28,828 | £28,431 | £28,030 | £27,627 | £27,219 | £26,809 | £26,395 | £25,977 | £25,556 | £25,132 |
| Total Liabilities | £30,000 | £31,871 | £31,478 | £31,371 | £33,199 | £33,758 | £33,590 | £33,221 | £32,906 | £32,638 | £32,300 | £31,958 | £31,597 |
| Paid-in Capital | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 | £122,000 |
| Retained Earnings | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) | (£8,500) |
| Earnings | £0 | (£2,704) | (£5,404) | (£10,402) | (£27,597) | (£47,864) | (£63,418) | (£78,156) | (£90,940) | (£100,798) | (£109,027) | (£115,629) | (£120,911) |
| Total Capital | £113,500 | £110,796 | £108,096 | £103,098 | £85,903 | £65,636 | £50,082 | £35,344 | £22,560 | £12,702 | £4,473 | (£2,129) | (£7,411) |
| Total Liabilities and Capital | £143,500 | £142,668 | £139,573 | £134,469 | £119,102 | £99,393 | £83,672 | £68,566 | £55,466 | £45,340 | £36,773 | £29,829 | £24,187 |
| Net Worth | £113,500 | £110,796 | £108,096 | £103,098 | £85,903 | £65,636 | £50,082 | £35,344 | £22,560 | £12,702 | £4,473 | (£2,129) | (£7,411) |