| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Engineering & Architect (E&A) | 0% | £6,250,000 | £3,750,000 | £2,500,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £2,500,000 |
| Engineering & Procurement | 0% | £10,000,000 | £6,000,000 | £4,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £4,000,000 |
| Engineering & Construction | 0% | £3,750,000 | £2,250,000 | £1,500,000 | £750,000 | £750,000 | £750,000 | £750,000 | £750,000 | £750,000 | £750,000 | £750,000 | £1,500,000 |
| Project management (PM) | 0% | £5,000,000 | £3,000,000 | £2,000,000 | £1,000,000 | £1,000,000 | £1,000,000 | £1,000,000 | £1,000,000 | £1,000,000 | £1,000,000 | £1,000,000 | £2,000,000 |
| Total Sales | £25,000,000 | £15,000,000 | £10,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £10,000,000 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Engineering & Architect (E&A) | £3,375,000 | £2,025,000 | £1,350,000 | £675,000 | £675,000 | £675,000 | £675,000 | £675,000 | £675,000 | £675,000 | £675,000 | £1,350,000 | |
| Engineering & Procurement | £5,400,000 | £3,240,000 | £2,160,000 | £1,080,000 | £1,080,000 | £1,080,000 | £1,080,000 | £1,080,000 | £1,080,000 | £1,080,000 | £1,080,000 | £2,160,000 | |
| Engineering & Construction | £2,025,000 | £1,215,000 | £810,000 | £405,000 | £405,000 | £405,000 | £405,000 | £405,000 | £405,000 | £405,000 | £405,000 | £810,000 | |
| Project management (PM) | £2,700,000 | £1,620,000 | £1,080,000 | £540,000 | £540,000 | £540,000 | £540,000 | £540,000 | £540,000 | £540,000 | £540,000 | £1,080,000 | |
| Subtotal Direct Cost of Sales | £13,500,000 | £8,100,000 | £5,400,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £5,400,000 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| President Director/Chief Representative | 0% | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 |
| Executive Secretary | 0% | £540 | £540 | £540 | £540 | £540 | £540 | £540 | £540 | £540 | £540 | £540 | £540 |
| VP Sales & Marketing | 0% | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 |
| Sales Manager | 0% | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Marketing & Business Dev. Manager | 0% | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Secretary | 0% | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 |
| VP Internal Business Management (IBM) | 0% | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 |
| Finance Manager/Senior Accountant | 0% | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Accountant | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Human Resources Manager | 0% | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Administrative Officer | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Legal Officer | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Bookkeeper | 0% | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 |
| Clerical | 0% | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 |
| Clerical | 0% | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 |
| Clerical | 0% | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 |
| Clerical | 0% | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | |
| General Assumptions | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | |
| Long-term Interest Rate | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | |
| Tax Rate | 25.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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £25,000,000 | £15,000,000 | £10,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £10,000,000 | |
| Direct Cost of Sales | £13,500,000 | £8,100,000 | £5,400,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £5,400,000 | |
| Power System Studies | £5,000 | £5,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £0 | £0 | |
| Total Cost of Sales | £13,505,000 | £8,105,000 | £5,406,000 | £2,706,000 | £2,706,000 | £2,706,000 | £2,706,000 | £2,706,000 | £2,706,000 | £2,706,000 | £2,700,000 | £5,400,000 | |
| Gross Margin | £11,495,000 | £6,895,000 | £4,594,000 | £2,294,000 | £2,294,000 | £2,294,000 | £2,294,000 | £2,294,000 | £2,294,000 | £2,294,000 | £2,300,000 | £4,600,000 | |
| Gross Margin % | 45.98% | 45.97% | 45.94% | 45.88% | 45.88% | 45.88% | 45.88% | 45.88% | 45.88% | 45.88% | 46.00% | 46.00% | |
| Expenses | |||||||||||||
| Payroll | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | |
| Sales and Marketing and Other Expenses | £388,500 | £382,000 | £382,000 | £388,500 | £382,000 | £382,000 | £388,500 | £382,000 | £382,000 | £388,500 | £382,000 | £382,000 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Utilities | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Insurance | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Rent | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Payroll Taxes | 15% | £2,798 | £2,798 | £2,798 | £2,798 | £2,798 | £2,798 | £2,798 | £2,798 | £2,798 | £2,798 | £2,798 | £2,798 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £420,952 | £414,452 | £414,452 | £420,952 | £414,452 | £414,452 | £420,952 | £414,452 | £414,452 | £420,952 | £414,452 | £414,452 | |
| Profit Before Interest and Taxes | £11,074,048 | £6,480,548 | £4,179,548 | £1,873,048 | £1,879,548 | £1,879,548 | £1,873,048 | £1,879,548 | £1,879,548 | £1,873,048 | £1,885,548 | £4,185,548 | |
| EBITDA | £11,074,048 | £6,480,548 | £4,179,548 | £1,873,048 | £1,879,548 | £1,879,548 | £1,873,048 | £1,879,548 | £1,879,548 | £1,873,048 | £1,885,548 | £4,185,548 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £2,768,512 | £1,620,137 | £1,044,887 | £468,262 | £469,887 | £469,887 | £468,262 | £469,887 | £469,887 | £468,262 | £471,387 | £1,046,387 | |
| Net Profit | £8,305,536 | £4,860,411 | £3,134,661 | £1,404,786 | £1,409,661 | £1,409,661 | £1,404,786 | £1,409,661 | £1,409,661 | £1,404,786 | £1,414,161 | £3,139,161 | |
| Net Profit/Sales | 33.22% | 32.40% | 31.35% | 28.10% | 28.19% | 28.19% | 28.10% | 28.19% | 28.19% | 28.10% | 28.28% | 31.39% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £12,500,000 | £7,500,000 | £5,000,000 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | £5,000,000 | |
| Cash from Receivables | £5,348,858 | £5,765,525 | £12,333,333 | £7,416,667 | £4,916,667 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | |
| Subtotal Cash from Operations | £17,848,858 | £13,265,525 | £17,333,333 | £9,916,667 | £7,416,667 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £7,500,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 | £17,848,858 | £13,265,525 | £17,333,333 | £9,916,667 | £7,416,667 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £7,500,000 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | |
| Bill Payments | £4,892,688 | £16,457,314 | £10,011,793 | £6,737,681 | £3,576,398 | £3,571,685 | £3,571,848 | £3,576,398 | £3,571,685 | £3,571,848 | £3,576,248 | £3,676,352 | |
| Subtotal Spent on Operations | £4,911,342 | £16,475,968 | £10,030,447 | £6,756,335 | £3,595,052 | £3,590,339 | £3,590,502 | £3,595,052 | £3,590,339 | £3,590,502 | £3,594,902 | £3,695,006 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £4,911,342 | £16,475,968 | £10,030,447 | £6,756,335 | £3,595,052 | £3,590,339 | £3,590,502 | £3,595,052 | £3,590,339 | £3,590,502 | £3,594,902 | £3,695,006 | |
| Net Cash Flow | £12,937,516 | (£3,210,444) | £7,302,886 | £3,160,332 | £3,821,615 | £1,409,661 | £1,409,498 | £1,404,948 | £1,409,661 | £1,409,498 | £1,405,098 | £3,804,994 | |
| Cash Balance | £39,187,516 | £35,977,072 | £43,279,958 | £46,440,290 | £50,261,905 | £51,671,566 | £53,081,064 | £54,486,013 | £55,895,674 | £57,305,172 | £58,710,270 | £62,515,265 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £26,250,000 | £39,187,516 | £35,977,072 | £43,279,958 | £46,440,290 | £50,261,905 | £51,671,566 | £53,081,064 | £54,486,013 | £55,895,674 | £57,305,172 | £58,710,270 | £62,515,265 |
| Accounts Receivable | £10,697,716 | £17,848,858 | £19,583,333 | £12,250,000 | £7,333,333 | £4,916,667 | £4,916,667 | £4,916,667 | £4,916,667 | £4,916,667 | £4,916,667 | £4,916,667 | £7,416,667 |
| Other Current Assets | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 |
| Total Current Assets | £37,868,096 | £57,956,754 | £56,480,785 | £56,450,338 | £54,694,003 | £56,098,952 | £57,508,612 | £58,918,111 | £60,323,059 | £61,732,720 | £63,142,219 | £64,547,317 | £70,852,311 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 |
| Total Assets | £39,112,061 | £59,200,719 | £57,724,750 | £57,694,303 | £55,937,968 | £57,342,917 | £58,752,577 | £60,162,076 | £61,567,024 | £62,976,685 | £64,386,184 | £65,791,282 | £72,096,276 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £4,336,828 | £16,119,950 | £9,783,571 | £6,618,462 | £3,457,341 | £3,452,629 | £3,452,629 | £3,457,341 | £3,452,629 | £3,452,629 | £3,457,341 | £3,448,279 | £6,614,112 |
| 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 | £4,336,828 | £16,119,950 | £9,783,571 | £6,618,462 | £3,457,341 | £3,452,629 | £3,452,629 | £3,457,341 | £3,452,629 | £3,452,629 | £3,457,341 | £3,448,279 | £6,614,112 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £4,336,828 | £16,119,950 | £9,783,571 | £6,618,462 | £3,457,341 | £3,452,629 | £3,452,629 | £3,457,341 | £3,452,629 | £3,452,629 | £3,457,341 | £3,448,279 | £6,614,112 |
| Paid-in Capital | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 |
| Retained Earnings | £1,781,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 |
| Earnings | £28,250,000 | £8,305,536 | £13,165,947 | £16,300,608 | £17,705,394 | £19,115,055 | £20,524,716 | £21,929,501 | £23,339,162 | £24,748,823 | £26,153,609 | £27,567,770 | £30,706,931 |
| Total Capital | £34,775,233 | £43,080,769 | £47,941,180 | £51,075,841 | £52,480,627 | £53,890,288 | £55,299,949 | £56,704,734 | £58,114,395 | £59,524,056 | £60,928,842 | £62,343,003 | £65,482,164 |
| Total Liabilities and Capital | £39,112,061 | £59,200,719 | £57,724,750 | £57,694,303 | £55,937,968 | £57,342,917 | £58,752,577 | £60,162,076 | £61,567,024 | £62,976,685 | £64,386,184 | £65,791,282 | £72,096,276 |
| Net Worth | £34,775,233 | £43,080,769 | £47,941,180 | £51,075,841 | £52,480,627 | £53,890,288 | £55,299,949 | £56,704,734 | £58,114,395 | £59,524,056 | £60,928,842 | £62,343,003 | £65,482,164 |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Engineering & Architect (E&A) | 0% | £6,250,000 | £3,750,000 | £2,500,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £1,250,000 | £2,500,000 |
| Engineering & Procurement | 0% | £10,000,000 | £6,000,000 | £4,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £4,000,000 |
| Engineering & Construction | 0% | £3,750,000 | £2,250,000 | £1,500,000 | £750,000 | £750,000 | £750,000 | £750,000 | £750,000 | £750,000 | £750,000 | £750,000 | £1,500,000 |
| Project management (PM) | 0% | £5,000,000 | £3,000,000 | £2,000,000 | £1,000,000 | £1,000,000 | £1,000,000 | £1,000,000 | £1,000,000 | £1,000,000 | £1,000,000 | £1,000,000 | £2,000,000 |
| Total Sales | £25,000,000 | £15,000,000 | £10,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £10,000,000 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Engineering & Architect (E&A) | £3,375,000 | £2,025,000 | £1,350,000 | £675,000 | £675,000 | £675,000 | £675,000 | £675,000 | £675,000 | £675,000 | £675,000 | £1,350,000 | |
| Engineering & Procurement | £5,400,000 | £3,240,000 | £2,160,000 | £1,080,000 | £1,080,000 | £1,080,000 | £1,080,000 | £1,080,000 | £1,080,000 | £1,080,000 | £1,080,000 | £2,160,000 | |
| Engineering & Construction | £2,025,000 | £1,215,000 | £810,000 | £405,000 | £405,000 | £405,000 | £405,000 | £405,000 | £405,000 | £405,000 | £405,000 | £810,000 | |
| Project management (PM) | £2,700,000 | £1,620,000 | £1,080,000 | £540,000 | £540,000 | £540,000 | £540,000 | £540,000 | £540,000 | £540,000 | £540,000 | £1,080,000 | |
| Subtotal Direct Cost of Sales | £13,500,000 | £8,100,000 | £5,400,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £5,400,000 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| President Director/Chief Representative | 0% | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 |
| Executive Secretary | 0% | £540 | £540 | £540 | £540 | £540 | £540 | £540 | £540 | £540 | £540 | £540 | £540 |
| VP Sales & Marketing | 0% | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 |
| Sales Manager | 0% | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Marketing & Business Dev. Manager | 0% | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Secretary | 0% | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 |
| VP Internal Business Management (IBM) | 0% | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 | £2,166 |
| Finance Manager/Senior Accountant | 0% | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Accountant | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Human Resources Manager | 0% | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Administrative Officer | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Legal Officer | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Bookkeeper | 0% | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 |
| Clerical | 0% | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 |
| Clerical | 0% | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 |
| Clerical | 0% | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 |
| Clerical | 0% | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 | £108 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | |
| General Assumptions | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | 8.50% | |
| Long-term Interest Rate | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | |
| Tax Rate | 25.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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £25,000,000 | £15,000,000 | £10,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £10,000,000 | |
| Direct Cost of Sales | £13,500,000 | £8,100,000 | £5,400,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £2,700,000 | £5,400,000 | |
| Power System Studies | £5,000 | £5,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £0 | £0 | |
| Total Cost of Sales | £13,505,000 | £8,105,000 | £5,406,000 | £2,706,000 | £2,706,000 | £2,706,000 | £2,706,000 | £2,706,000 | £2,706,000 | £2,706,000 | £2,700,000 | £5,400,000 | |
| Gross Margin | £11,495,000 | £6,895,000 | £4,594,000 | £2,294,000 | £2,294,000 | £2,294,000 | £2,294,000 | £2,294,000 | £2,294,000 | £2,294,000 | £2,300,000 | £4,600,000 | |
| Gross Margin % | 45.98% | 45.97% | 45.94% | 45.88% | 45.88% | 45.88% | 45.88% | 45.88% | 45.88% | 45.88% | 46.00% | 46.00% | |
| Expenses | |||||||||||||
| Payroll | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | |
| Sales and Marketing and Other Expenses | £388,500 | £382,000 | £382,000 | £388,500 | £382,000 | £382,000 | £388,500 | £382,000 | £382,000 | £388,500 | £382,000 | £382,000 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Utilities | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Insurance | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Rent | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Payroll Taxes | 15% | £2,798 | £2,798 | £2,798 | £2,798 | £2,798 | £2,798 | £2,798 | £2,798 | £2,798 | £2,798 | £2,798 | £2,798 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £420,952 | £414,452 | £414,452 | £420,952 | £414,452 | £414,452 | £420,952 | £414,452 | £414,452 | £420,952 | £414,452 | £414,452 | |
| Profit Before Interest and Taxes | £11,074,048 | £6,480,548 | £4,179,548 | £1,873,048 | £1,879,548 | £1,879,548 | £1,873,048 | £1,879,548 | £1,879,548 | £1,873,048 | £1,885,548 | £4,185,548 | |
| EBITDA | £11,074,048 | £6,480,548 | £4,179,548 | £1,873,048 | £1,879,548 | £1,879,548 | £1,873,048 | £1,879,548 | £1,879,548 | £1,873,048 | £1,885,548 | £4,185,548 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £2,768,512 | £1,620,137 | £1,044,887 | £468,262 | £469,887 | £469,887 | £468,262 | £469,887 | £469,887 | £468,262 | £471,387 | £1,046,387 | |
| Net Profit | £8,305,536 | £4,860,411 | £3,134,661 | £1,404,786 | £1,409,661 | £1,409,661 | £1,404,786 | £1,409,661 | £1,409,661 | £1,404,786 | £1,414,161 | £3,139,161 | |
| Net Profit/Sales | 33.22% | 32.40% | 31.35% | 28.10% | 28.19% | 28.19% | 28.10% | 28.19% | 28.19% | 28.10% | 28.28% | 31.39% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £12,500,000 | £7,500,000 | £5,000,000 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | £5,000,000 | |
| Cash from Receivables | £5,348,858 | £5,765,525 | £12,333,333 | £7,416,667 | £4,916,667 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | £2,500,000 | |
| Subtotal Cash from Operations | £17,848,858 | £13,265,525 | £17,333,333 | £9,916,667 | £7,416,667 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £7,500,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 | £17,848,858 | £13,265,525 | £17,333,333 | £9,916,667 | £7,416,667 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £5,000,000 | £7,500,000 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | £18,654 | |
| Bill Payments | £4,892,688 | £16,457,314 | £10,011,793 | £6,737,681 | £3,576,398 | £3,571,685 | £3,571,848 | £3,576,398 | £3,571,685 | £3,571,848 | £3,576,248 | £3,676,352 | |
| Subtotal Spent on Operations | £4,911,342 | £16,475,968 | £10,030,447 | £6,756,335 | £3,595,052 | £3,590,339 | £3,590,502 | £3,595,052 | £3,590,339 | £3,590,502 | £3,594,902 | £3,695,006 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £4,911,342 | £16,475,968 | £10,030,447 | £6,756,335 | £3,595,052 | £3,590,339 | £3,590,502 | £3,595,052 | £3,590,339 | £3,590,502 | £3,594,902 | £3,695,006 | |
| Net Cash Flow | £12,937,516 | (£3,210,444) | £7,302,886 | £3,160,332 | £3,821,615 | £1,409,661 | £1,409,498 | £1,404,948 | £1,409,661 | £1,409,498 | £1,405,098 | £3,804,994 | |
| Cash Balance | £39,187,516 | £35,977,072 | £43,279,958 | £46,440,290 | £50,261,905 | £51,671,566 | £53,081,064 | £54,486,013 | £55,895,674 | £57,305,172 | £58,710,270 | £62,515,265 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £26,250,000 | £39,187,516 | £35,977,072 | £43,279,958 | £46,440,290 | £50,261,905 | £51,671,566 | £53,081,064 | £54,486,013 | £55,895,674 | £57,305,172 | £58,710,270 | £62,515,265 |
| Accounts Receivable | £10,697,716 | £17,848,858 | £19,583,333 | £12,250,000 | £7,333,333 | £4,916,667 | £4,916,667 | £4,916,667 | £4,916,667 | £4,916,667 | £4,916,667 | £4,916,667 | £7,416,667 |
| Other Current Assets | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 | £920,380 |
| Total Current Assets | £37,868,096 | £57,956,754 | £56,480,785 | £56,450,338 | £54,694,003 | £56,098,952 | £57,508,612 | £58,918,111 | £60,323,059 | £61,732,720 | £63,142,219 | £64,547,317 | £70,852,311 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 | £1,243,965 |
| Total Assets | £39,112,061 | £59,200,719 | £57,724,750 | £57,694,303 | £55,937,968 | £57,342,917 | £58,752,577 | £60,162,076 | £61,567,024 | £62,976,685 | £64,386,184 | £65,791,282 | £72,096,276 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £4,336,828 | £16,119,950 | £9,783,571 | £6,618,462 | £3,457,341 | £3,452,629 | £3,452,629 | £3,457,341 | £3,452,629 | £3,452,629 | £3,457,341 | £3,448,279 | £6,614,112 |
| 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 | £4,336,828 | £16,119,950 | £9,783,571 | £6,618,462 | £3,457,341 | £3,452,629 | £3,452,629 | £3,457,341 | £3,452,629 | £3,452,629 | £3,457,341 | £3,448,279 | £6,614,112 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £4,336,828 | £16,119,950 | £9,783,571 | £6,618,462 | £3,457,341 | £3,452,629 | £3,452,629 | £3,457,341 | £3,452,629 | £3,452,629 | £3,457,341 | £3,448,279 | £6,614,112 |
| Paid-in Capital | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 | £4,743,900 |
| Retained Earnings | £1,781,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 | £30,031,333 |
| Earnings | £28,250,000 | £8,305,536 | £13,165,947 | £16,300,608 | £17,705,394 | £19,115,055 | £20,524,716 | £21,929,501 | £23,339,162 | £24,748,823 | £26,153,609 | £27,567,770 | £30,706,931 |
| Total Capital | £34,775,233 | £43,080,769 | £47,941,180 | £51,075,841 | £52,480,627 | £53,890,288 | £55,299,949 | £56,704,734 | £58,114,395 | £59,524,056 | £60,928,842 | £62,343,003 | £65,482,164 |
| Total Liabilities and Capital | £39,112,061 | £59,200,719 | £57,724,750 | £57,694,303 | £55,937,968 | £57,342,917 | £58,752,577 | £60,162,076 | £61,567,024 | £62,976,685 | £64,386,184 | £65,791,282 | £72,096,276 |
| Net Worth | £34,775,233 | £43,080,769 | £47,941,180 | £51,075,841 | £52,480,627 | £53,890,288 | £55,299,949 | £56,704,734 | £58,114,395 | £59,524,056 | £60,928,842 | £62,343,003 | £65,482,164 |