| 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 | |||||||||||||
| Business Plans | 0% | 12 | 13 | 13 | 14 | 15 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| Start-Up Consulting | 0% | 11 | 12 | 12 | 13 | 13 | 14 | 15 | 15 | 16 | 17 | 18 | 19 |
| Annual Reviews | 0% | 14 | 15 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| Other Ongoing Business Consulting | 0% | 14 | 15 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| Total Unit Sales | 51 | 54 | 56 | 59 | 62 | 65 | 68 | 72 | 75 | 79 | 83 | 87 | |
| 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 | |
| Business Plans | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | |
| Start-Up Consulting | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | |
| Annual Reviews | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | |
| Other Ongoing Business Consulting | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | |
| Sales | |||||||||||||
| Business Plans | £18,000 | £18,900 | £19,845 | £20,837 | £21,879 | £22,973 | £24,122 | £25,328 | £26,594 | £27,924 | £29,320 | £30,786 | |
| Start-Up Consulting | £16,500 | £17,325 | £18,191 | £19,101 | £20,056 | £21,059 | £22,112 | £23,217 | £24,378 | £25,597 | £26,877 | £28,221 | |
| Annual Reviews | £14,000 | £14,700 | £15,435 | £16,207 | £17,017 | £17,868 | £18,761 | £19,699 | £20,684 | £21,719 | £22,805 | £23,945 | |
| Other Ongoing Business Consulting | £21,000 | £22,050 | £23,153 | £24,310 | £25,526 | £26,802 | £28,142 | £29,549 | £31,027 | £32,578 | £34,207 | £35,917 | |
| Total Sales | £69,500 | £72,975 | £76,624 | £80,455 | £84,478 | £88,702 | £93,137 | £97,793 | £102,683 | £107,817 | £113,208 | £118,869 | |
| 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 | |
| Business Plans | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Start-Up Consulting | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Annual Reviews | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Other Ongoing Business Consulting | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Business Plans | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Start-Up Consulting | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Annual Reviews | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Ongoing Business Consulting | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £69,500 | £72,975 | £76,624 | £80,455 | £84,478 | £88,702 | £93,137 | £97,793 | £102,683 | £107,817 | £113,208 | £118,869 | |
| Direct Cost of Sales | £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 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Gross Margin | £69,500 | £72,975 | £76,624 | £80,455 | £84,478 | £88,702 | £93,137 | £97,793 | £102,683 | £107,817 | £113,208 | £118,869 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | |
| Sales and Marketing and Other Expenses | £18,050 | £18,050 | £18,050 | £18,050 | £18,050 | £18,050 | £18,050 | £18,050 | £18,050 | £18,050 | £18,050 | £18,050 | |
| Depreciation | 5% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Utilities | 6% | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 |
| Payroll Taxes | 15% | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £76,150 | £76,150 | £76,150 | £76,150 | £76,150 | £76,150 | £76,150 | £76,150 | £76,150 | £76,150 | £76,150 | £76,150 | |
| Profit Before Interest and Taxes | (£6,650) | (£3,175) | £474 | £4,305 | £8,328 | £12,552 | £16,987 | £21,643 | £26,533 | £31,667 | £37,058 | £42,719 | |
| EBITDA | (£6,150) | (£2,675) | £974 | £4,805 | £8,828 | £13,052 | £17,487 | £22,143 | £27,033 | £32,167 | £37,558 | £43,219 | |
| Interest Expense | £808 | £783 | £758 | £733 | £708 | £683 | £658 | £633 | £608 | £583 | £558 | £533 | |
| Taxes Incurred | (£2,238) | (£990) | (£71) | £893 | £1,905 | £2,967 | £4,082 | £5,253 | £6,481 | £7,771 | £9,125 | £10,546 | |
| Net Profit | (£5,221) | (£2,969) | (£213) | £2,679 | £5,715 | £8,901 | £12,246 | £15,758 | £19,444 | £23,313 | £27,375 | £31,639 | |
| Net Profit/Sales | -7.51% | -4.07% | -0.28% | 3.33% | 6.76% | 10.03% | 13.15% | 16.11% | 18.94% | 21.62% | 24.18% | 26.62% | |
| 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 | £69,500 | £72,975 | £76,624 | £80,455 | £84,478 | £88,702 | £93,137 | £97,793 | £102,683 | £107,817 | £113,208 | £118,869 | |
| Subtotal Cash from Operations | £69,500 | £72,975 | £76,624 | £80,455 | £84,478 | £88,702 | £93,137 | £97,793 | £102,683 | £107,817 | £113,208 | £118,869 | |
| 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 | £69,500 | £72,975 | £76,624 | £80,455 | £84,478 | £88,702 | £93,137 | £97,793 | £102,683 | £107,817 | £113,208 | £118,869 | |
| 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 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | |
| Bill Payments | £1,807 | £24,262 | £25,474 | £26,368 | £27,309 | £28,298 | £29,337 | £30,429 | £31,576 | £32,782 | £34,049 | £35,380 | |
| Subtotal Spent on Operations | £51,807 | £74,262 | £75,474 | £76,368 | £77,309 | £78,298 | £79,337 | £80,429 | £81,576 | £82,782 | £84,049 | £85,380 | |
| 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 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| 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 | £54,807 | £77,262 | £78,474 | £79,368 | £80,309 | £81,298 | £82,337 | £83,429 | £84,576 | £85,782 | £87,049 | £88,380 | |
| Net Cash Flow | £14,693 | (£4,287) | (£1,850) | £1,086 | £4,169 | £7,404 | £10,800 | £14,365 | £18,107 | £22,036 | £26,160 | £30,489 | |
| Cash Balance | £164,693 | £160,406 | £158,556 | £159,643 | £163,811 | £171,215 | £182,015 | £196,380 | £214,487 | £236,523 | £262,682 | £293,171 | |
| 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 / Consultants | 0% | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | |
| 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 | £150,000 | £164,693 | £160,406 | £158,556 | £159,643 | £163,811 | £171,215 | £182,015 | £196,380 | £214,487 | £236,523 | £262,682 | £293,171 |
| Other Current Assets | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Total Current Assets | £170,000 | £184,693 | £180,406 | £178,556 | £179,643 | £183,811 | £191,215 | £202,015 | £216,380 | £234,487 | £256,523 | £282,682 | £313,171 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 |
| Accumulated Depreciation | £0 | £500 | £1,000 | £1,500 | £2,000 | £2,500 | £3,000 | £3,500 | £4,000 | £4,500 | £5,000 | £5,500 | £6,000 |
| Total Long-term Assets | £25,000 | £24,500 | £24,000 | £23,500 | £23,000 | £22,500 | £22,000 | £21,500 | £21,000 | £20,500 | £20,000 | £19,500 | £19,000 |
| Total Assets | £195,000 | £209,193 | £204,406 | £202,056 | £202,643 | £206,311 | £213,215 | £223,515 | £237,380 | £254,987 | £276,523 | £302,182 | £332,171 |
| 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 | £1,000 | £23,413 | £24,596 | £25,459 | £26,367 | £27,321 | £28,324 | £29,377 | £30,485 | £31,648 | £32,871 | £34,156 | £35,505 |
| 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 | £1,000 | £23,413 | £24,596 | £25,459 | £26,367 | £27,321 | £28,324 | £29,377 | £30,485 | £31,648 | £32,871 | £34,156 | £35,505 |
| Long-term Liabilities | £100,000 | £97,000 | £94,000 | £91,000 | £88,000 | £85,000 | £82,000 | £79,000 | £76,000 | £73,000 | £70,000 | £67,000 | £64,000 |
| Total Liabilities | £101,000 | £120,413 | £118,596 | £116,459 | £114,367 | £112,321 | £110,324 | £108,377 | £106,485 | £104,648 | £102,871 | £101,156 | £99,505 |
| Paid-in Capital | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 |
| Retained Earnings | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) |
| Earnings | £0 | (£5,221) | (£8,190) | (£8,403) | (£5,724) | (£10) | £8,891 | £21,138 | £36,895 | £56,339 | £79,652 | £107,027 | £138,666 |
| Total Capital | £94,000 | £88,779 | £85,810 | £85,597 | £88,276 | £93,990 | £102,891 | £115,138 | £130,895 | £150,339 | £173,652 | £201,027 | £232,666 |
| Total Liabilities and Capital | £195,000 | £209,193 | £204,406 | £202,056 | £202,643 | £206,311 | £213,215 | £223,515 | £237,380 | £254,987 | £276,523 | £302,182 | £332,171 |
| Net Worth | £94,000 | £88,779 | £85,810 | £85,597 | £88,276 | £93,990 | £102,891 | £115,138 | £130,895 | £150,339 | £173,652 | £201,027 | £232,666 |
| 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 | |||||||||||||
| Business Plans | 0% | 12 | 13 | 13 | 14 | 15 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| Start-Up Consulting | 0% | 11 | 12 | 12 | 13 | 13 | 14 | 15 | 15 | 16 | 17 | 18 | 19 |
| Annual Reviews | 0% | 14 | 15 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| Other Ongoing Business Consulting | 0% | 14 | 15 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| Total Unit Sales | 51 | 54 | 56 | 59 | 62 | 65 | 68 | 72 | 75 | 79 | 83 | 87 | |
| 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 | |
| Business Plans | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | |
| Start-Up Consulting | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | |
| Annual Reviews | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | |
| Other Ongoing Business Consulting | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | £1,500.00 | |
| Sales | |||||||||||||
| Business Plans | £18,000 | £18,900 | £19,845 | £20,837 | £21,879 | £22,973 | £24,122 | £25,328 | £26,594 | £27,924 | £29,320 | £30,786 | |
| Start-Up Consulting | £16,500 | £17,325 | £18,191 | £19,101 | £20,056 | £21,059 | £22,112 | £23,217 | £24,378 | £25,597 | £26,877 | £28,221 | |
| Annual Reviews | £14,000 | £14,700 | £15,435 | £16,207 | £17,017 | £17,868 | £18,761 | £19,699 | £20,684 | £21,719 | £22,805 | £23,945 | |
| Other Ongoing Business Consulting | £21,000 | £22,050 | £23,153 | £24,310 | £25,526 | £26,802 | £28,142 | £29,549 | £31,027 | £32,578 | £34,207 | £35,917 | |
| Total Sales | £69,500 | £72,975 | £76,624 | £80,455 | £84,478 | £88,702 | £93,137 | £97,793 | £102,683 | £107,817 | £113,208 | £118,869 | |
| 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 | |
| Business Plans | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Start-Up Consulting | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Annual Reviews | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Other Ongoing Business Consulting | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Business Plans | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Start-Up Consulting | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Annual Reviews | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Ongoing Business Consulting | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £69,500 | £72,975 | £76,624 | £80,455 | £84,478 | £88,702 | £93,137 | £97,793 | £102,683 | £107,817 | £113,208 | £118,869 | |
| Direct Cost of Sales | £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 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Gross Margin | £69,500 | £72,975 | £76,624 | £80,455 | £84,478 | £88,702 | £93,137 | £97,793 | £102,683 | £107,817 | £113,208 | £118,869 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | |
| Sales and Marketing and Other Expenses | £18,050 | £18,050 | £18,050 | £18,050 | £18,050 | £18,050 | £18,050 | £18,050 | £18,050 | £18,050 | £18,050 | £18,050 | |
| Depreciation | 5% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Utilities | 6% | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 |
| Payroll Taxes | 15% | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £76,150 | £76,150 | £76,150 | £76,150 | £76,150 | £76,150 | £76,150 | £76,150 | £76,150 | £76,150 | £76,150 | £76,150 | |
| Profit Before Interest and Taxes | (£6,650) | (£3,175) | £474 | £4,305 | £8,328 | £12,552 | £16,987 | £21,643 | £26,533 | £31,667 | £37,058 | £42,719 | |
| EBITDA | (£6,150) | (£2,675) | £974 | £4,805 | £8,828 | £13,052 | £17,487 | £22,143 | £27,033 | £32,167 | £37,558 | £43,219 | |
| Interest Expense | £808 | £783 | £758 | £733 | £708 | £683 | £658 | £633 | £608 | £583 | £558 | £533 | |
| Taxes Incurred | (£2,238) | (£990) | (£71) | £893 | £1,905 | £2,967 | £4,082 | £5,253 | £6,481 | £7,771 | £9,125 | £10,546 | |
| Net Profit | (£5,221) | (£2,969) | (£213) | £2,679 | £5,715 | £8,901 | £12,246 | £15,758 | £19,444 | £23,313 | £27,375 | £31,639 | |
| Net Profit/Sales | -7.51% | -4.07% | -0.28% | 3.33% | 6.76% | 10.03% | 13.15% | 16.11% | 18.94% | 21.62% | 24.18% | 26.62% | |
| 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 | £69,500 | £72,975 | £76,624 | £80,455 | £84,478 | £88,702 | £93,137 | £97,793 | £102,683 | £107,817 | £113,208 | £118,869 | |
| Subtotal Cash from Operations | £69,500 | £72,975 | £76,624 | £80,455 | £84,478 | £88,702 | £93,137 | £97,793 | £102,683 | £107,817 | £113,208 | £118,869 | |
| 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 | £69,500 | £72,975 | £76,624 | £80,455 | £84,478 | £88,702 | £93,137 | £97,793 | £102,683 | £107,817 | £113,208 | £118,869 | |
| 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 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | |
| Bill Payments | £1,807 | £24,262 | £25,474 | £26,368 | £27,309 | £28,298 | £29,337 | £30,429 | £31,576 | £32,782 | £34,049 | £35,380 | |
| Subtotal Spent on Operations | £51,807 | £74,262 | £75,474 | £76,368 | £77,309 | £78,298 | £79,337 | £80,429 | £81,576 | £82,782 | £84,049 | £85,380 | |
| 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 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| 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 | £54,807 | £77,262 | £78,474 | £79,368 | £80,309 | £81,298 | £82,337 | £83,429 | £84,576 | £85,782 | £87,049 | £88,380 | |
| Net Cash Flow | £14,693 | (£4,287) | (£1,850) | £1,086 | £4,169 | £7,404 | £10,800 | £14,365 | £18,107 | £22,036 | £26,160 | £30,489 | |
| Cash Balance | £164,693 | £160,406 | £158,556 | £159,643 | £163,811 | £171,215 | £182,015 | £196,380 | £214,487 | £236,523 | £262,682 | £293,171 | |
| 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 / Consultants | 0% | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | |
| 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 | £150,000 | £164,693 | £160,406 | £158,556 | £159,643 | £163,811 | £171,215 | £182,015 | £196,380 | £214,487 | £236,523 | £262,682 | £293,171 |
| Other Current Assets | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Total Current Assets | £170,000 | £184,693 | £180,406 | £178,556 | £179,643 | £183,811 | £191,215 | £202,015 | £216,380 | £234,487 | £256,523 | £282,682 | £313,171 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 |
| Accumulated Depreciation | £0 | £500 | £1,000 | £1,500 | £2,000 | £2,500 | £3,000 | £3,500 | £4,000 | £4,500 | £5,000 | £5,500 | £6,000 |
| Total Long-term Assets | £25,000 | £24,500 | £24,000 | £23,500 | £23,000 | £22,500 | £22,000 | £21,500 | £21,000 | £20,500 | £20,000 | £19,500 | £19,000 |
| Total Assets | £195,000 | £209,193 | £204,406 | £202,056 | £202,643 | £206,311 | £213,215 | £223,515 | £237,380 | £254,987 | £276,523 | £302,182 | £332,171 |
| 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 | £1,000 | £23,413 | £24,596 | £25,459 | £26,367 | £27,321 | £28,324 | £29,377 | £30,485 | £31,648 | £32,871 | £34,156 | £35,505 |
| 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 | £1,000 | £23,413 | £24,596 | £25,459 | £26,367 | £27,321 | £28,324 | £29,377 | £30,485 | £31,648 | £32,871 | £34,156 | £35,505 |
| Long-term Liabilities | £100,000 | £97,000 | £94,000 | £91,000 | £88,000 | £85,000 | £82,000 | £79,000 | £76,000 | £73,000 | £70,000 | £67,000 | £64,000 |
| Total Liabilities | £101,000 | £120,413 | £118,596 | £116,459 | £114,367 | £112,321 | £110,324 | £108,377 | £106,485 | £104,648 | £102,871 | £101,156 | £99,505 |
| Paid-in Capital | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 | £99,500 |
| Retained Earnings | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) | (£5,500) |
| Earnings | £0 | (£5,221) | (£8,190) | (£8,403) | (£5,724) | (£10) | £8,891 | £21,138 | £36,895 | £56,339 | £79,652 | £107,027 | £138,666 |
| Total Capital | £94,000 | £88,779 | £85,810 | £85,597 | £88,276 | £93,990 | £102,891 | £115,138 | £130,895 | £150,339 | £173,652 | £201,027 | £232,666 |
| Total Liabilities and Capital | £195,000 | £209,193 | £204,406 | £202,056 | £202,643 | £206,311 | £213,215 | £223,515 | £237,380 | £254,987 | £276,523 | £302,182 | £332,171 |
| Net Worth | £94,000 | £88,779 | £85,810 | £85,597 | £88,276 | £93,990 | £102,891 | £115,138 | £130,895 | £150,339 | £173,652 | £201,027 | £232,666 |