| 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 | ||
| Unit Sales | |||||||||||||
| Established Realtors | 0% | 200 | 300 | 600 | 800 | 1,050 | 1,500 | 1,800 | 1,900 | 2,150 | 2,350 | 2,550 | 2,800 |
| New Realtors | 0% | 50 | 90 | 100 | 100 | 100 | 150 | 200 | 200 | 200 | 200 | 200 | 200 |
| Old Timers | 0% | 0 | 0 | 6 | 10 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 |
| Total Unit Sales | 250 | 390 | 706 | 910 | 1,170 | 1,670 | 2,020 | 2,120 | 2,370 | 2,570 | 2,770 | 3,020 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Established Realtors | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | |
| New Realtors | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | |
| Old Timers | £250.00 | £250.00 | £250.00 | £250.00 | £250.00 | £250.00 | £250.00 | £250.00 | £250.00 | £250.00 | £250.00 | £250.00 | |
| Sales | |||||||||||||
| Established Realtors | £80,000 | £120,000 | £240,000 | £320,000 | £420,000 | £600,000 | £720,000 | £760,000 | £860,000 | £940,000 | £1,020,000 | £1,120,000 | |
| New Realtors | £15,000 | £27,000 | £30,000 | £30,000 | £30,000 | £45,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | |
| Old Timers | £0 | £0 | £1,500 | £2,500 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Total Sales | £95,000 | £147,000 | £271,500 | £352,500 | £455,000 | £650,000 | £785,000 | £825,000 | £925,000 | £1,005,000 | £1,085,000 | £1,185,000 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Established Realtors | 0.00% | £65.00 | £65.00 | £65.00 | £65.00 | £65.00 | £65.00 | £65.00 | £65.00 | £65.00 | £65.00 | £65.00 | £65.00 |
| New Realtors | 0.00% | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 |
| Old Timers | 0.00% | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 |
| Direct Cost of Sales | |||||||||||||
| Established Realtors | £13,000 | £19,500 | £39,000 | £52,000 | £68,250 | £97,500 | £117,000 | £123,500 | £139,750 | £152,750 | £165,750 | £182,000 | |
| New Realtors | £3,000 | £5,400 | £6,000 | £6,000 | £6,000 | £9,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | |
| Old Timers | £0 | £0 | £360 | £600 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Subtotal Direct Cost of Sales | £16,000 | £24,900 | £45,360 | £58,600 | £75,450 | £107,700 | £130,200 | £136,700 | £152,950 | £165,950 | £178,950 | £195,200 | |
| 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 | ||
| Secretary Corporate | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Director of Conventions/Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,750 | £3,750 | £3,750 |
| National Convention Staff | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,500 | £5,000 | £5,000 |
| Online Help | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Director of Realest® Relations | 0% | £5,409 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 |
| Clerical Secretary | 0% | £0 | £0 | £0 | £0 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 |
| Managing Director | 0% | £5,833 | £5,833 | £5,833 | £5,833 | £5,833 | £5,833 | £5,833 | £5,833 | £5,833 | £5,833 | £5,833 | £5,833 |
| Regional Sales Administrator | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Managing Broker | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Total People | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 7 | 7 | 7 | |
| Total Payroll | £16,242 | £16,250 | £16,250 | £16,250 | £17,917 | £17,917 | £17,917 | £17,917 | £17,917 | £24,167 | £26,667 | £26,667 | |
| 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% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £95,000 | £147,000 | £271,500 | £352,500 | £455,000 | £650,000 | £785,000 | £825,000 | £925,000 | £1,005,000 | £1,085,000 | £1,185,000 | |
| Direct Cost of Sales | £16,000 | £24,900 | £45,360 | £58,600 | £75,450 | £107,700 | £130,200 | £136,700 | £152,950 | £165,950 | £178,950 | £195,200 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £16,000 | £24,900 | £45,360 | £58,600 | £75,450 | £107,700 | £130,200 | £136,700 | £152,950 | £165,950 | £178,950 | £195,200 | |
| Gross Margin | £79,000 | £122,100 | £226,140 | £293,900 | £379,550 | £542,300 | £654,800 | £688,300 | £772,050 | £839,050 | £906,050 | £989,800 | |
| Gross Margin % | 83.16% | 83.06% | 83.29% | 83.38% | 83.42% | 83.43% | 83.41% | 83.43% | 83.46% | 83.49% | 83.51% | 83.53% | |
| Expenses | |||||||||||||
| Payroll | £16,242 | £16,250 | £16,250 | £16,250 | £17,917 | £17,917 | £17,917 | £17,917 | £17,917 | £24,167 | £26,667 | £26,667 | |
| Sales and Marketing and Other Expenses | £3,420 | £6,320 | £6,320 | £6,320 | £6,320 | £6,320 | £6,320 | £6,320 | £6,320 | £6,320 | £6,320 | £6,320 | |
| Depreciation | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Website | £15,000 | £15,000 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Utilities | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Insurance | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Rent | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Payroll Taxes | 15% | £2,436 | £2,438 | £2,438 | £2,438 | £2,688 | £2,688 | £2,688 | £2,688 | £2,688 | £3,625 | £4,000 | £4,000 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £41,198 | £44,108 | £31,608 | £31,608 | £33,525 | £33,525 | £33,525 | £33,525 | £33,525 | £40,712 | £43,587 | £43,587 | |
| Profit Before Interest and Taxes | £37,802 | £77,993 | £194,533 | £262,293 | £346,025 | £508,775 | £621,275 | £654,775 | £738,525 | £798,338 | £862,463 | £946,213 | |
| EBITDA | £38,002 | £78,193 | £194,733 | £262,493 | £346,225 | £508,975 | £621,475 | £654,975 | £738,725 | £798,538 | £862,663 | £946,413 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £11,341 | £19,498 | £48,633 | £65,573 | £86,506 | £127,194 | £155,319 | £163,694 | £184,631 | £199,584 | £215,616 | £236,553 | |
| Net Profit | £26,461 | £58,494 | £145,899 | £196,719 | £259,519 | £381,582 | £465,957 | £491,082 | £553,894 | £598,753 | £646,847 | £709,660 | |
| Net Profit/Sales | 27.85% | 39.79% | 53.74% | 55.81% | 57.04% | 58.70% | 59.36% | 59.53% | 59.88% | 59.58% | 59.62% | 59.89% | |
| 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 | £95,000 | £147,000 | £271,500 | £352,500 | £455,000 | £650,000 | £785,000 | £825,000 | £925,000 | £1,005,000 | £1,085,000 | £1,185,000 | |
| Subtotal Cash from Operations | £95,000 | £147,000 | £271,500 | £352,500 | £455,000 | £650,000 | £785,000 | £825,000 | £925,000 | £1,005,000 | £1,085,000 | £1,185,000 | |
| 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 | £95,000 | £147,000 | £271,500 | £352,500 | £455,000 | £650,000 | £785,000 | £825,000 | £925,000 | £1,005,000 | £1,085,000 | £1,185,000 | |
| 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 | £16,242 | £16,250 | £16,250 | £16,250 | £17,917 | £17,917 | £17,917 | £17,917 | £17,917 | £24,167 | £26,667 | £26,667 | |
| Bill Payments | £1,737 | £52,762 | £73,292 | £110,157 | £140,598 | £179,795 | £251,989 | £301,422 | £317,041 | £353,952 | £382,860 | £412,525 | |
| Subtotal Spent on Operations | £17,979 | £69,012 | £89,542 | £126,407 | £158,515 | £197,712 | £269,906 | £319,339 | £334,958 | £378,119 | £409,527 | £439,192 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £5,000 | £5,000 | £5,000 | £5,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £22,979 | £74,012 | £94,542 | £131,407 | £168,515 | £207,712 | £279,906 | £329,339 | £344,958 | £388,119 | £419,527 | £449,192 | |
| Net Cash Flow | £72,021 | £72,988 | £176,958 | £221,093 | £286,485 | £442,288 | £505,094 | £495,661 | £580,042 | £616,881 | £665,473 | £735,808 | |
| Cash Balance | £137,021 | £210,009 | £386,967 | £608,061 | £894,545 | £1,336,833 | £1,841,927 | £2,337,588 | £2,917,630 | £3,534,511 | £4,199,984 | £4,935,792 | |
| 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 | £65,000 | £137,021 | £210,009 | £386,967 | £608,061 | £894,545 | £1,336,833 | £1,841,927 | £2,337,588 | £2,917,630 | £3,534,511 | £4,199,984 | £4,935,792 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £65,000 | £137,021 | £210,009 | £386,967 | £608,061 | £894,545 | £1,336,833 | £1,841,927 | £2,337,588 | £2,917,630 | £3,534,511 | £4,199,984 | £4,935,792 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £5,000 | £10,000 | £15,000 | £20,000 | £30,000 | £40,000 | £50,000 | £60,000 | £70,000 | £80,000 | £90,000 | £100,000 |
| Accumulated Depreciation | £0 | £200 | £400 | £600 | £800 | £1,000 | £1,200 | £1,400 | £1,600 | £1,800 | £2,000 | £2,200 | £2,400 |
| Total Long-term Assets | £0 | £4,800 | £9,600 | £14,400 | £19,200 | £29,000 | £38,800 | £48,600 | £58,400 | £68,200 | £78,000 | £87,800 | £97,600 |
| Total Assets | £65,000 | £141,821 | £219,609 | £401,367 | £627,261 | £923,545 | £1,375,633 | £1,890,527 | £2,395,988 | £2,985,830 | £3,612,511 | £4,287,784 | £5,033,392 |
| 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 | £50,360 | £69,654 | £105,512 | £134,686 | £171,452 | £241,958 | £290,896 | £305,275 | £341,223 | £369,150 | £397,576 | £433,524 |
| 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 | £50,360 | £69,654 | £105,512 | £134,686 | £171,452 | £241,958 | £290,896 | £305,275 | £341,223 | £369,150 | £397,576 | £433,524 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £50,360 | £69,654 | £105,512 | £134,686 | £171,452 | £241,958 | £290,896 | £305,275 | £341,223 | £369,150 | £397,576 | £433,524 |
| Paid-in Capital | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 |
| Retained Earnings | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) |
| Earnings | £0 | £26,461 | £84,956 | £230,855 | £427,574 | £687,093 | £1,068,675 | £1,534,632 | £2,025,713 | £2,579,607 | £3,178,361 | £3,825,208 | £4,534,868 |
| Total Capital | £65,000 | £91,461 | £149,956 | £295,855 | £492,574 | £752,093 | £1,133,675 | £1,599,632 | £2,090,713 | £2,644,607 | £3,243,361 | £3,890,208 | £4,599,868 |
| Total Liabilities and Capital | £65,000 | £141,821 | £219,609 | £401,367 | £627,261 | £923,545 | £1,375,633 | £1,890,527 | £2,395,988 | £2,985,830 | £3,612,511 | £4,287,784 | £5,033,392 |
| Net Worth | £65,000 | £91,461 | £149,956 | £295,855 | £492,574 | £752,093 | £1,133,675 | £1,599,632 | £2,090,713 | £2,644,607 | £3,243,361 | £3,890,208 | £4,599,868 |
| 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 | ||
| Unit Sales | |||||||||||||
| Established Realtors | 0% | 200 | 300 | 600 | 800 | 1,050 | 1,500 | 1,800 | 1,900 | 2,150 | 2,350 | 2,550 | 2,800 |
| New Realtors | 0% | 50 | 90 | 100 | 100 | 100 | 150 | 200 | 200 | 200 | 200 | 200 | 200 |
| Old Timers | 0% | 0 | 0 | 6 | 10 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 |
| Total Unit Sales | 250 | 390 | 706 | 910 | 1,170 | 1,670 | 2,020 | 2,120 | 2,370 | 2,570 | 2,770 | 3,020 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Established Realtors | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | |
| New Realtors | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | |
| Old Timers | £250.00 | £250.00 | £250.00 | £250.00 | £250.00 | £250.00 | £250.00 | £250.00 | £250.00 | £250.00 | £250.00 | £250.00 | |
| Sales | |||||||||||||
| Established Realtors | £80,000 | £120,000 | £240,000 | £320,000 | £420,000 | £600,000 | £720,000 | £760,000 | £860,000 | £940,000 | £1,020,000 | £1,120,000 | |
| New Realtors | £15,000 | £27,000 | £30,000 | £30,000 | £30,000 | £45,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | |
| Old Timers | £0 | £0 | £1,500 | £2,500 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Total Sales | £95,000 | £147,000 | £271,500 | £352,500 | £455,000 | £650,000 | £785,000 | £825,000 | £925,000 | £1,005,000 | £1,085,000 | £1,185,000 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Established Realtors | 0.00% | £65.00 | £65.00 | £65.00 | £65.00 | £65.00 | £65.00 | £65.00 | £65.00 | £65.00 | £65.00 | £65.00 | £65.00 |
| New Realtors | 0.00% | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 |
| Old Timers | 0.00% | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 | £60.00 |
| Direct Cost of Sales | |||||||||||||
| Established Realtors | £13,000 | £19,500 | £39,000 | £52,000 | £68,250 | £97,500 | £117,000 | £123,500 | £139,750 | £152,750 | £165,750 | £182,000 | |
| New Realtors | £3,000 | £5,400 | £6,000 | £6,000 | £6,000 | £9,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | |
| Old Timers | £0 | £0 | £360 | £600 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Subtotal Direct Cost of Sales | £16,000 | £24,900 | £45,360 | £58,600 | £75,450 | £107,700 | £130,200 | £136,700 | £152,950 | £165,950 | £178,950 | £195,200 | |
| 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 | ||
| Secretary Corporate | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Director of Conventions/Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,750 | £3,750 | £3,750 |
| National Convention Staff | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,500 | £5,000 | £5,000 |
| Online Help | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Director of Realest® Relations | 0% | £5,409 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 | £5,417 |
| Clerical Secretary | 0% | £0 | £0 | £0 | £0 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 |
| Managing Director | 0% | £5,833 | £5,833 | £5,833 | £5,833 | £5,833 | £5,833 | £5,833 | £5,833 | £5,833 | £5,833 | £5,833 | £5,833 |
| Regional Sales Administrator | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Managing Broker | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Total People | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 7 | 7 | 7 | |
| Total Payroll | £16,242 | £16,250 | £16,250 | £16,250 | £17,917 | £17,917 | £17,917 | £17,917 | £17,917 | £24,167 | £26,667 | £26,667 | |
| 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% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £95,000 | £147,000 | £271,500 | £352,500 | £455,000 | £650,000 | £785,000 | £825,000 | £925,000 | £1,005,000 | £1,085,000 | £1,185,000 | |
| Direct Cost of Sales | £16,000 | £24,900 | £45,360 | £58,600 | £75,450 | £107,700 | £130,200 | £136,700 | £152,950 | £165,950 | £178,950 | £195,200 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £16,000 | £24,900 | £45,360 | £58,600 | £75,450 | £107,700 | £130,200 | £136,700 | £152,950 | £165,950 | £178,950 | £195,200 | |
| Gross Margin | £79,000 | £122,100 | £226,140 | £293,900 | £379,550 | £542,300 | £654,800 | £688,300 | £772,050 | £839,050 | £906,050 | £989,800 | |
| Gross Margin % | 83.16% | 83.06% | 83.29% | 83.38% | 83.42% | 83.43% | 83.41% | 83.43% | 83.46% | 83.49% | 83.51% | 83.53% | |
| Expenses | |||||||||||||
| Payroll | £16,242 | £16,250 | £16,250 | £16,250 | £17,917 | £17,917 | £17,917 | £17,917 | £17,917 | £24,167 | £26,667 | £26,667 | |
| Sales and Marketing and Other Expenses | £3,420 | £6,320 | £6,320 | £6,320 | £6,320 | £6,320 | £6,320 | £6,320 | £6,320 | £6,320 | £6,320 | £6,320 | |
| Depreciation | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Website | £15,000 | £15,000 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Utilities | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Insurance | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Rent | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Payroll Taxes | 15% | £2,436 | £2,438 | £2,438 | £2,438 | £2,688 | £2,688 | £2,688 | £2,688 | £2,688 | £3,625 | £4,000 | £4,000 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £41,198 | £44,108 | £31,608 | £31,608 | £33,525 | £33,525 | £33,525 | £33,525 | £33,525 | £40,712 | £43,587 | £43,587 | |
| Profit Before Interest and Taxes | £37,802 | £77,993 | £194,533 | £262,293 | £346,025 | £508,775 | £621,275 | £654,775 | £738,525 | £798,338 | £862,463 | £946,213 | |
| EBITDA | £38,002 | £78,193 | £194,733 | £262,493 | £346,225 | £508,975 | £621,475 | £654,975 | £738,725 | £798,538 | £862,663 | £946,413 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £11,341 | £19,498 | £48,633 | £65,573 | £86,506 | £127,194 | £155,319 | £163,694 | £184,631 | £199,584 | £215,616 | £236,553 | |
| Net Profit | £26,461 | £58,494 | £145,899 | £196,719 | £259,519 | £381,582 | £465,957 | £491,082 | £553,894 | £598,753 | £646,847 | £709,660 | |
| Net Profit/Sales | 27.85% | 39.79% | 53.74% | 55.81% | 57.04% | 58.70% | 59.36% | 59.53% | 59.88% | 59.58% | 59.62% | 59.89% | |
| 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 | £95,000 | £147,000 | £271,500 | £352,500 | £455,000 | £650,000 | £785,000 | £825,000 | £925,000 | £1,005,000 | £1,085,000 | £1,185,000 | |
| Subtotal Cash from Operations | £95,000 | £147,000 | £271,500 | £352,500 | £455,000 | £650,000 | £785,000 | £825,000 | £925,000 | £1,005,000 | £1,085,000 | £1,185,000 | |
| 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 | £95,000 | £147,000 | £271,500 | £352,500 | £455,000 | £650,000 | £785,000 | £825,000 | £925,000 | £1,005,000 | £1,085,000 | £1,185,000 | |
| 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 | £16,242 | £16,250 | £16,250 | £16,250 | £17,917 | £17,917 | £17,917 | £17,917 | £17,917 | £24,167 | £26,667 | £26,667 | |
| Bill Payments | £1,737 | £52,762 | £73,292 | £110,157 | £140,598 | £179,795 | £251,989 | £301,422 | £317,041 | £353,952 | £382,860 | £412,525 | |
| Subtotal Spent on Operations | £17,979 | £69,012 | £89,542 | £126,407 | £158,515 | £197,712 | £269,906 | £319,339 | £334,958 | £378,119 | £409,527 | £439,192 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £5,000 | £5,000 | £5,000 | £5,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £22,979 | £74,012 | £94,542 | £131,407 | £168,515 | £207,712 | £279,906 | £329,339 | £344,958 | £388,119 | £419,527 | £449,192 | |
| Net Cash Flow | £72,021 | £72,988 | £176,958 | £221,093 | £286,485 | £442,288 | £505,094 | £495,661 | £580,042 | £616,881 | £665,473 | £735,808 | |
| Cash Balance | £137,021 | £210,009 | £386,967 | £608,061 | £894,545 | £1,336,833 | £1,841,927 | £2,337,588 | £2,917,630 | £3,534,511 | £4,199,984 | £4,935,792 | |
| 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 | £65,000 | £137,021 | £210,009 | £386,967 | £608,061 | £894,545 | £1,336,833 | £1,841,927 | £2,337,588 | £2,917,630 | £3,534,511 | £4,199,984 | £4,935,792 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £65,000 | £137,021 | £210,009 | £386,967 | £608,061 | £894,545 | £1,336,833 | £1,841,927 | £2,337,588 | £2,917,630 | £3,534,511 | £4,199,984 | £4,935,792 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £5,000 | £10,000 | £15,000 | £20,000 | £30,000 | £40,000 | £50,000 | £60,000 | £70,000 | £80,000 | £90,000 | £100,000 |
| Accumulated Depreciation | £0 | £200 | £400 | £600 | £800 | £1,000 | £1,200 | £1,400 | £1,600 | £1,800 | £2,000 | £2,200 | £2,400 |
| Total Long-term Assets | £0 | £4,800 | £9,600 | £14,400 | £19,200 | £29,000 | £38,800 | £48,600 | £58,400 | £68,200 | £78,000 | £87,800 | £97,600 |
| Total Assets | £65,000 | £141,821 | £219,609 | £401,367 | £627,261 | £923,545 | £1,375,633 | £1,890,527 | £2,395,988 | £2,985,830 | £3,612,511 | £4,287,784 | £5,033,392 |
| 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 | £50,360 | £69,654 | £105,512 | £134,686 | £171,452 | £241,958 | £290,896 | £305,275 | £341,223 | £369,150 | £397,576 | £433,524 |
| 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 | £50,360 | £69,654 | £105,512 | £134,686 | £171,452 | £241,958 | £290,896 | £305,275 | £341,223 | £369,150 | £397,576 | £433,524 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £50,360 | £69,654 | £105,512 | £134,686 | £171,452 | £241,958 | £290,896 | £305,275 | £341,223 | £369,150 | £397,576 | £433,524 |
| Paid-in Capital | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 | £125,050 |
| Retained Earnings | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) | (£60,050) |
| Earnings | £0 | £26,461 | £84,956 | £230,855 | £427,574 | £687,093 | £1,068,675 | £1,534,632 | £2,025,713 | £2,579,607 | £3,178,361 | £3,825,208 | £4,534,868 |
| Total Capital | £65,000 | £91,461 | £149,956 | £295,855 | £492,574 | £752,093 | £1,133,675 | £1,599,632 | £2,090,713 | £2,644,607 | £3,243,361 | £3,890,208 | £4,599,868 |
| Total Liabilities and Capital | £65,000 | £141,821 | £219,609 | £401,367 | £627,261 | £923,545 | £1,375,633 | £1,890,527 | £2,395,988 | £2,985,830 | £3,612,511 | £4,287,784 | £5,033,392 |
| Net Worth | £65,000 | £91,461 | £149,956 | £295,855 | £492,574 | £752,093 | £1,133,675 | £1,599,632 | £2,090,713 | £2,644,607 | £3,243,361 | £3,890,208 | £4,599,868 |