| 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 | |||||||||||||
| Membership Fees | 0% | £2,200 | £4,400 | £6,600 | £8,800 | £11,000 | £13,200 | £15,950 | £17,600 | £19,800 | £22,000 | £22,000 | £22,000 |
| Golf Equipment | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Food & Beverages | 0% | £180 | £360 | £540 | £720 | £900 | £1,080 | £1,260 | £1,440 | £1,620 | £1,800 | £1,800 | £1,800 |
| Cigars | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £500 | £500 | £500 | £500 | £500 | £500 |
| Private Lessons | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £250 | £250 | £250 | £250 | £250 | £250 |
| Equipment Rental | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £250 | £250 | £250 | £250 | £250 | £250 |
| Advertising | 0% | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Extra Performance Analysis | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £250 | £250 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £100 | £100 | £100 | £100 | £100 | £100 |
| Total Sales | £2,380 | £7,760 | £12,140 | £14,520 | £16,900 | £19,280 | £23,310 | £25,140 | £27,520 | £29,900 | £30,150 | £30,150 | |
| 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 | |
| Membership Fees | £110 | £220 | £330 | £440 | £550 | £660 | £795 | £880 | £990 | £1,100 | £1,100 | £1,100 | |
| Golf Equipment | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Food & Beverages | £36 | £72 | £108 | £144 | £180 | £216 | £252 | £288 | £324 | £360 | £360 | £360 | |
| Cigars | £0 | £0 | £0 | £0 | £0 | £0 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Private Lessons | £0 | £0 | £0 | £0 | £0 | £0 | £190 | £190 | £190 | £190 | £190 | £190 | |
| Equipment Rental | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Advertising | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Extra Performance Analysis | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Subtotal Direct Cost of Sales | £146 | £292 | £1,938 | £2,084 | £2,230 | £2,376 | £2,912 | £3,033 | £3,179 | £3,325 | £3,325 | £3,325 | |
| 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 | ||
| Managing Director & consultant | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Administration 1 - Part time | 0% | £800 | £800 | £1,200 | £800 | £1,200 | £800 | £800 | £800 | £800 | £1,600 | £800 | £800 |
| Administration 2 - Part time | 0% | £800 | £800 | £1,200 | £800 | £1,200 | £800 | £800 | £800 | £800 | £1,600 | £800 | £800 |
| Administration 3 - Part time | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Janitor | 0% | £900 | £900 | £1,350 | £900 | £1,350 | £900 | £900 | £900 | £900 | £1,800 | £900 | £900 |
| Janitor assistant | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Cleaning Person 1 - Part time | 0% | £800 | £800 | £1,200 | £800 | £1,200 | £800 | £800 | £800 | £800 | £1,600 | £800 | £800 |
| Cleaning Person 2 - Part time | 0% | £800 | £800 | £1,200 | £800 | £1,200 | £800 | £800 | £800 | £800 | £1,600 | £800 | £800 |
| Professional instructor | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accountant | 0% | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 |
| Guard 1 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Guard 2 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £8,400 | £8,400 | £10,450 | £8,400 | £10,450 | £8,400 | £8,400 | £8,400 | £8,400 | £12,500 | £8,400 | £8,400 | |
| 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 | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | |
| Long-term 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% | |
| 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% | |
| Personnel Burden | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 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 | £2,380 | £7,760 | £12,140 | £14,520 | £16,900 | £19,280 | £23,310 | £25,140 | £27,520 | £29,900 | £30,150 | £30,150 | |
| Direct Cost of Sales | £146 | £292 | £1,938 | £2,084 | £2,230 | £2,376 | £2,912 | £3,033 | £3,179 | £3,325 | £3,325 | £3,325 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £146 | £292 | £1,938 | £2,084 | £2,230 | £2,376 | £2,912 | £3,033 | £3,179 | £3,325 | £3,325 | £3,325 | |
| Gross Margin | £2,234 | £7,468 | £10,202 | £12,436 | £14,670 | £16,904 | £20,398 | £22,107 | £24,341 | £26,575 | £26,825 | £26,825 | |
| Gross Margin % | 93.87% | 96.24% | 84.04% | 85.65% | 86.80% | 87.68% | 87.51% | 87.94% | 88.45% | 88.88% | 88.97% | 88.97% | |
| Expenses | |||||||||||||
| Payroll | £8,400 | £8,400 | £10,450 | £8,400 | £10,450 | £8,400 | £8,400 | £8,400 | £8,400 | £12,500 | £8,400 | £8,400 | |
| Sales and Marketing and Other Expenses | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | |
| Rent (site) | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Supplies (Office & Janitorial) | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Web Site Expenses | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Utilities | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Insurance (fire,damages, loss) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £10,000 | |
| Payroll Taxes | 15% | £1,260 | £1,260 | £1,568 | £1,260 | £1,568 | £1,260 | £1,260 | £1,260 | £1,260 | £1,875 | £1,260 | £1,260 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £15,810 | £15,810 | £18,168 | £15,810 | £18,168 | £15,810 | £15,810 | £15,810 | £15,810 | £20,525 | £15,810 | £25,810 | |
| Profit Before Interest and Taxes | (£11,176) | (£5,942) | (£4,366) | (£974) | £103 | £3,494 | £6,988 | £8,697 | £8,531 | £6,050 | £11,015 | £1,015 | |
| EBITDA | (£9,926) | (£4,692) | (£3,116) | £276 | £1,353 | £4,744 | £8,238 | £9,947 | £9,781 | £7,300 | £12,265 | £2,265 | |
| Interest Expense | £814 | £811 | £808 | £805 | £802 | £799 | £796 | £793 | £790 | £788 | £785 | £782 | |
| Taxes Incurred | (£3,597) | (£2,363) | (£1,811) | (£623) | (£245) | £943 | £2,167 | £2,766 | £2,709 | £1,842 | £3,581 | £82 | |
| Net Profit | (£8,393) | (£4,389) | (£3,363) | (£1,156) | (£455) | £1,752 | £4,025 | £5,137 | £5,031 | £3,421 | £6,650 | £152 | |
| Net Profit/Sales | -352.64% | -56.56% | -27.70% | -7.96% | -2.69% | 9.09% | 17.27% | 20.44% | 18.28% | 11.44% | 22.06% | 0.50% | |
| 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 | £2,380 | £7,760 | £12,140 | £14,520 | £16,900 | £19,280 | £23,310 | £25,140 | £27,520 | £29,900 | £30,150 | £30,150 | |
| Subtotal Cash from Operations | £2,380 | £7,760 | £12,140 | £14,520 | £16,900 | £19,280 | £23,310 | £25,140 | £27,520 | £29,900 | £30,150 | £30,150 | |
| Additional Cash Received | |||||||||||||
| Non Operating (Other) Income | £2,400 | £2,400 | £3,600 | £2,400 | £3,600 | £2,400 | £2,400 | £2,400 | £0 | £0 | £0 | £0 | |
| 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 | £4,780 | £10,160 | £15,740 | £16,920 | £20,500 | £21,680 | £25,710 | £27,540 | £27,520 | £29,900 | £30,150 | £30,150 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £8,400 | £8,400 | £10,450 | £8,400 | £10,450 | £8,400 | £8,400 | £8,400 | £8,400 | £12,500 | £8,400 | £8,400 | |
| Bill Payments | £117 | £3,569 | £4,983 | £7,437 | £8,454 | £9,289 | £10,337 | £12,059 | £12,755 | £12,835 | £12,767 | £14,067 | |
| Subtotal Spent on Operations | £8,517 | £11,969 | £15,433 | £15,837 | £18,904 | £17,689 | £18,737 | £20,459 | £21,155 | £25,335 | £21,167 | £22,467 | |
| Additional Cash Spent | |||||||||||||
| Non Operating (Other) Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| 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 | £9,017 | £12,469 | £15,933 | £16,337 | £19,404 | £18,189 | £19,237 | £20,959 | £21,655 | £25,835 | £21,667 | £22,967 | |
| Net Cash Flow | (£4,237) | (£2,309) | (£193) | £583 | £1,096 | £3,491 | £6,473 | £6,581 | £5,865 | £4,065 | £8,483 | £7,183 | |
| Cash Balance | £9,763 | £7,454 | £7,261 | £7,844 | £8,940 | £12,431 | £18,904 | £25,485 | £31,350 | £35,415 | £43,898 | £51,081 | |
| 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 | £14,000 | £9,763 | £7,454 | £7,261 | £7,844 | £8,940 | £12,431 | £18,904 | £25,485 | £31,350 | £35,415 | £43,898 | £51,081 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £14,000 | £9,763 | £7,454 | £7,261 | £7,844 | £8,940 | £12,431 | £18,904 | £25,485 | £31,350 | £35,415 | £43,898 | £51,081 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 |
| Accumulated Depreciation | £0 | £1,250 | £2,500 | £3,750 | £5,000 | £6,250 | £7,500 | £8,750 | £10,000 | £11,250 | £12,500 | £13,750 | £15,000 |
| Total Long-term Assets | £65,000 | £63,750 | £62,500 | £61,250 | £60,000 | £58,750 | £57,500 | £56,250 | £55,000 | £53,750 | £52,500 | £51,250 | £50,000 |
| Total Assets | £79,000 | £73,513 | £69,954 | £68,511 | £67,844 | £67,690 | £69,931 | £75,154 | £80,485 | £85,100 | £87,915 | £95,148 | £101,081 |
| 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,405 | £4,736 | £7,156 | £8,145 | £8,946 | £9,936 | £11,634 | £12,328 | £12,411 | £12,305 | £13,389 | £19,670 |
| 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,405 | £4,736 | £7,156 | £8,145 | £8,946 | £9,936 | £11,634 | £12,328 | £12,411 | £12,305 | £13,389 | £19,670 |
| Long-term Liabilities | £140,000 | £139,500 | £139,000 | £138,500 | £138,000 | £137,500 | £137,000 | £136,500 | £136,000 | £135,500 | £135,000 | £134,500 | £134,000 |
| Total Liabilities | £140,000 | £142,905 | £143,736 | £145,656 | £146,145 | £146,446 | £146,936 | £148,134 | £148,328 | £147,911 | £147,305 | £147,889 | £153,670 |
| Paid-in Capital | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 |
| Retained Earnings | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) |
| Earnings | £0 | (£8,393) | (£12,782) | (£16,145) | (£17,301) | (£17,756) | (£16,004) | (£11,980) | (£6,842) | (£1,811) | £1,610 | £8,259 | £8,411 |
| Total Capital | (£61,000) | (£69,393) | (£73,782) | (£77,145) | (£78,301) | (£78,756) | (£77,004) | (£72,980) | (£67,842) | (£62,811) | (£59,390) | (£52,741) | (£52,589) |
| Total Liabilities and Capital | £79,000 | £73,513 | £69,954 | £68,511 | £67,844 | £67,690 | £69,931 | £75,154 | £80,485 | £85,100 | £87,915 | £95,148 | £101,081 |
| Net Worth | (£61,000) | (£69,393) | (£73,782) | (£77,145) | (£78,301) | (£78,756) | (£77,004) | (£72,980) | (£67,842) | (£62,811) | (£59,390) | (£52,741) | (£52,589) |
| 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 | |||||||||||||
| Membership Fees | 0% | £2,200 | £4,400 | £6,600 | £8,800 | £11,000 | £13,200 | £15,950 | £17,600 | £19,800 | £22,000 | £22,000 | £22,000 |
| Golf Equipment | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Food & Beverages | 0% | £180 | £360 | £540 | £720 | £900 | £1,080 | £1,260 | £1,440 | £1,620 | £1,800 | £1,800 | £1,800 |
| Cigars | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £500 | £500 | £500 | £500 | £500 | £500 |
| Private Lessons | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £250 | £250 | £250 | £250 | £250 | £250 |
| Equipment Rental | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £250 | £250 | £250 | £250 | £250 | £250 |
| Advertising | 0% | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Extra Performance Analysis | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £250 | £250 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £100 | £100 | £100 | £100 | £100 | £100 |
| Total Sales | £2,380 | £7,760 | £12,140 | £14,520 | £16,900 | £19,280 | £23,310 | £25,140 | £27,520 | £29,900 | £30,150 | £30,150 | |
| 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 | |
| Membership Fees | £110 | £220 | £330 | £440 | £550 | £660 | £795 | £880 | £990 | £1,100 | £1,100 | £1,100 | |
| Golf Equipment | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Food & Beverages | £36 | £72 | £108 | £144 | £180 | £216 | £252 | £288 | £324 | £360 | £360 | £360 | |
| Cigars | £0 | £0 | £0 | £0 | £0 | £0 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Private Lessons | £0 | £0 | £0 | £0 | £0 | £0 | £190 | £190 | £190 | £190 | £190 | £190 | |
| Equipment Rental | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Advertising | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Extra Performance Analysis | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Subtotal Direct Cost of Sales | £146 | £292 | £1,938 | £2,084 | £2,230 | £2,376 | £2,912 | £3,033 | £3,179 | £3,325 | £3,325 | £3,325 | |
| 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 | ||
| Managing Director & consultant | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Administration 1 - Part time | 0% | £800 | £800 | £1,200 | £800 | £1,200 | £800 | £800 | £800 | £800 | £1,600 | £800 | £800 |
| Administration 2 - Part time | 0% | £800 | £800 | £1,200 | £800 | £1,200 | £800 | £800 | £800 | £800 | £1,600 | £800 | £800 |
| Administration 3 - Part time | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Janitor | 0% | £900 | £900 | £1,350 | £900 | £1,350 | £900 | £900 | £900 | £900 | £1,800 | £900 | £900 |
| Janitor assistant | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Cleaning Person 1 - Part time | 0% | £800 | £800 | £1,200 | £800 | £1,200 | £800 | £800 | £800 | £800 | £1,600 | £800 | £800 |
| Cleaning Person 2 - Part time | 0% | £800 | £800 | £1,200 | £800 | £1,200 | £800 | £800 | £800 | £800 | £1,600 | £800 | £800 |
| Professional instructor | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accountant | 0% | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 |
| Guard 1 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Guard 2 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £8,400 | £8,400 | £10,450 | £8,400 | £10,450 | £8,400 | £8,400 | £8,400 | £8,400 | £12,500 | £8,400 | £8,400 | |
| 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 | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | |
| Long-term 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% | |
| 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% | |
| Personnel Burden | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 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 | £2,380 | £7,760 | £12,140 | £14,520 | £16,900 | £19,280 | £23,310 | £25,140 | £27,520 | £29,900 | £30,150 | £30,150 | |
| Direct Cost of Sales | £146 | £292 | £1,938 | £2,084 | £2,230 | £2,376 | £2,912 | £3,033 | £3,179 | £3,325 | £3,325 | £3,325 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £146 | £292 | £1,938 | £2,084 | £2,230 | £2,376 | £2,912 | £3,033 | £3,179 | £3,325 | £3,325 | £3,325 | |
| Gross Margin | £2,234 | £7,468 | £10,202 | £12,436 | £14,670 | £16,904 | £20,398 | £22,107 | £24,341 | £26,575 | £26,825 | £26,825 | |
| Gross Margin % | 93.87% | 96.24% | 84.04% | 85.65% | 86.80% | 87.68% | 87.51% | 87.94% | 88.45% | 88.88% | 88.97% | 88.97% | |
| Expenses | |||||||||||||
| Payroll | £8,400 | £8,400 | £10,450 | £8,400 | £10,450 | £8,400 | £8,400 | £8,400 | £8,400 | £12,500 | £8,400 | £8,400 | |
| Sales and Marketing and Other Expenses | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | |
| Rent (site) | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Supplies (Office & Janitorial) | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Web Site Expenses | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Utilities | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Insurance (fire,damages, loss) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £10,000 | |
| Payroll Taxes | 15% | £1,260 | £1,260 | £1,568 | £1,260 | £1,568 | £1,260 | £1,260 | £1,260 | £1,260 | £1,875 | £1,260 | £1,260 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £15,810 | £15,810 | £18,168 | £15,810 | £18,168 | £15,810 | £15,810 | £15,810 | £15,810 | £20,525 | £15,810 | £25,810 | |
| Profit Before Interest and Taxes | (£11,176) | (£5,942) | (£4,366) | (£974) | £103 | £3,494 | £6,988 | £8,697 | £8,531 | £6,050 | £11,015 | £1,015 | |
| EBITDA | (£9,926) | (£4,692) | (£3,116) | £276 | £1,353 | £4,744 | £8,238 | £9,947 | £9,781 | £7,300 | £12,265 | £2,265 | |
| Interest Expense | £814 | £811 | £808 | £805 | £802 | £799 | £796 | £793 | £790 | £788 | £785 | £782 | |
| Taxes Incurred | (£3,597) | (£2,363) | (£1,811) | (£623) | (£245) | £943 | £2,167 | £2,766 | £2,709 | £1,842 | £3,581 | £82 | |
| Net Profit | (£8,393) | (£4,389) | (£3,363) | (£1,156) | (£455) | £1,752 | £4,025 | £5,137 | £5,031 | £3,421 | £6,650 | £152 | |
| Net Profit/Sales | -352.64% | -56.56% | -27.70% | -7.96% | -2.69% | 9.09% | 17.27% | 20.44% | 18.28% | 11.44% | 22.06% | 0.50% | |
| 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 | £2,380 | £7,760 | £12,140 | £14,520 | £16,900 | £19,280 | £23,310 | £25,140 | £27,520 | £29,900 | £30,150 | £30,150 | |
| Subtotal Cash from Operations | £2,380 | £7,760 | £12,140 | £14,520 | £16,900 | £19,280 | £23,310 | £25,140 | £27,520 | £29,900 | £30,150 | £30,150 | |
| Additional Cash Received | |||||||||||||
| Non Operating (Other) Income | £2,400 | £2,400 | £3,600 | £2,400 | £3,600 | £2,400 | £2,400 | £2,400 | £0 | £0 | £0 | £0 | |
| 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 | £4,780 | £10,160 | £15,740 | £16,920 | £20,500 | £21,680 | £25,710 | £27,540 | £27,520 | £29,900 | £30,150 | £30,150 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £8,400 | £8,400 | £10,450 | £8,400 | £10,450 | £8,400 | £8,400 | £8,400 | £8,400 | £12,500 | £8,400 | £8,400 | |
| Bill Payments | £117 | £3,569 | £4,983 | £7,437 | £8,454 | £9,289 | £10,337 | £12,059 | £12,755 | £12,835 | £12,767 | £14,067 | |
| Subtotal Spent on Operations | £8,517 | £11,969 | £15,433 | £15,837 | £18,904 | £17,689 | £18,737 | £20,459 | £21,155 | £25,335 | £21,167 | £22,467 | |
| Additional Cash Spent | |||||||||||||
| Non Operating (Other) Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| 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 | £9,017 | £12,469 | £15,933 | £16,337 | £19,404 | £18,189 | £19,237 | £20,959 | £21,655 | £25,835 | £21,667 | £22,967 | |
| Net Cash Flow | (£4,237) | (£2,309) | (£193) | £583 | £1,096 | £3,491 | £6,473 | £6,581 | £5,865 | £4,065 | £8,483 | £7,183 | |
| Cash Balance | £9,763 | £7,454 | £7,261 | £7,844 | £8,940 | £12,431 | £18,904 | £25,485 | £31,350 | £35,415 | £43,898 | £51,081 | |
| 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 | £14,000 | £9,763 | £7,454 | £7,261 | £7,844 | £8,940 | £12,431 | £18,904 | £25,485 | £31,350 | £35,415 | £43,898 | £51,081 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £14,000 | £9,763 | £7,454 | £7,261 | £7,844 | £8,940 | £12,431 | £18,904 | £25,485 | £31,350 | £35,415 | £43,898 | £51,081 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 |
| Accumulated Depreciation | £0 | £1,250 | £2,500 | £3,750 | £5,000 | £6,250 | £7,500 | £8,750 | £10,000 | £11,250 | £12,500 | £13,750 | £15,000 |
| Total Long-term Assets | £65,000 | £63,750 | £62,500 | £61,250 | £60,000 | £58,750 | £57,500 | £56,250 | £55,000 | £53,750 | £52,500 | £51,250 | £50,000 |
| Total Assets | £79,000 | £73,513 | £69,954 | £68,511 | £67,844 | £67,690 | £69,931 | £75,154 | £80,485 | £85,100 | £87,915 | £95,148 | £101,081 |
| 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,405 | £4,736 | £7,156 | £8,145 | £8,946 | £9,936 | £11,634 | £12,328 | £12,411 | £12,305 | £13,389 | £19,670 |
| 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,405 | £4,736 | £7,156 | £8,145 | £8,946 | £9,936 | £11,634 | £12,328 | £12,411 | £12,305 | £13,389 | £19,670 |
| Long-term Liabilities | £140,000 | £139,500 | £139,000 | £138,500 | £138,000 | £137,500 | £137,000 | £136,500 | £136,000 | £135,500 | £135,000 | £134,500 | £134,000 |
| Total Liabilities | £140,000 | £142,905 | £143,736 | £145,656 | £146,145 | £146,446 | £146,936 | £148,134 | £148,328 | £147,911 | £147,305 | £147,889 | £153,670 |
| Paid-in Capital | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 |
| Retained Earnings | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) | (£261,000) |
| Earnings | £0 | (£8,393) | (£12,782) | (£16,145) | (£17,301) | (£17,756) | (£16,004) | (£11,980) | (£6,842) | (£1,811) | £1,610 | £8,259 | £8,411 |
| Total Capital | (£61,000) | (£69,393) | (£73,782) | (£77,145) | (£78,301) | (£78,756) | (£77,004) | (£72,980) | (£67,842) | (£62,811) | (£59,390) | (£52,741) | (£52,589) |
| Total Liabilities and Capital | £79,000 | £73,513 | £69,954 | £68,511 | £67,844 | £67,690 | £69,931 | £75,154 | £80,485 | £85,100 | £87,915 | £95,148 | £101,081 |
| Net Worth | (£61,000) | (£69,393) | (£73,782) | (£77,145) | (£78,301) | (£78,756) | (£77,004) | (£72,980) | (£67,842) | (£62,811) | (£59,390) | (£52,741) | (£52,589) |