| 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 | |||||||||||||
| Promerit Inventory Basic | 0% | £0 | £0 | £70,000 | £80,000 | £120,000 | £120,000 | £160,000 | £160,000 | £160,000 | £140,000 | £200,000 | £240,000 |
| Hardware | 0% | £0 | £0 | £54,000 | £60,000 | £75,000 | £75,000 | £105,000 | £105,000 | £105,000 | £80,000 | £100,000 | £150,000 |
| Software Modules | 0% | £0 | £0 | £0 | £11,000 | £13,000 | £15,000 | £15,000 | £15,000 | £15,000 | £10,000 | £15,000 | £20,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £0 | £0 | £124,000 | £151,000 | £208,000 | £210,000 | £280,000 | £280,000 | £280,000 | £230,000 | £315,000 | £410,000 | |
| 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 | |
| Promerit Inventory Basic | £0 | £0 | £57,000 | £60,000 | £90,000 | £90,000 | £120,000 | £120,000 | £120,000 | £90,000 | £150,000 | £190,000 | |
| Hardware | £0 | £0 | £36,000 | £40,000 | £50,000 | £50,000 | £63,000 | £63,000 | £63,000 | £50,000 | £65,000 | £100,000 | |
| Software Modules | £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 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £93,000 | £100,000 | £140,000 | £140,000 | £183,000 | £183,000 | £183,000 | £140,000 | £215,000 | £290,000 | |
| 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 | ||
| Manager | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Accounting Manager | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Sales Staff | 0% | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Software Engineers | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £0 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £28,500 | £28,500 | £28,500 | £28,500 | £28,500 | £23,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £0 | £0 | £124,000 | £151,000 | £208,000 | £210,000 | £280,000 | £280,000 | £280,000 | £230,000 | £315,000 | £410,000 | |
| Direct Cost of Sales | £0 | £0 | £93,000 | £100,000 | £140,000 | £140,000 | £183,000 | £183,000 | £183,000 | £140,000 | £215,000 | £290,000 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £93,000 | £100,000 | £140,000 | £140,000 | £183,000 | £183,000 | £183,000 | £140,000 | £215,000 | £290,000 | |
| Gross Margin | £0 | £0 | £31,000 | £51,000 | £68,000 | £70,000 | £97,000 | £97,000 | £97,000 | £90,000 | £100,000 | £120,000 | |
| Gross Margin % | 0.00% | 0.00% | 25.00% | 33.77% | 32.69% | 33.33% | 34.64% | 34.64% | 34.64% | 39.13% | 31.75% | 29.27% | |
| Expenses | |||||||||||||
| Payroll | £28,500 | £28,500 | £28,500 | £28,500 | £28,500 | £23,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | |
| Sales and Marketing and Other Expenses | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Payroll Taxes | 15% | £4,275 | £4,275 | £4,275 | £4,275 | £4,275 | £3,525 | £5,025 | £5,025 | £5,025 | £5,025 | £5,025 | £5,025 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £44,915 | £44,915 | £44,915 | £44,915 | £44,915 | £39,165 | £50,665 | £50,665 | £50,665 | £50,665 | £50,665 | £50,665 | |
| Profit Before Interest and Taxes | (£44,915) | (£44,915) | (£13,915) | £6,085 | £23,085 | £30,835 | £46,335 | £46,335 | £46,335 | £39,335 | £49,335 | £69,335 | |
| EBITDA | (£44,915) | (£44,915) | (£13,915) | £6,085 | £23,085 | £30,835 | £46,335 | £46,335 | £46,335 | £39,335 | £49,335 | £69,335 | |
| Interest Expense | £819 | £805 | £791 | £777 | £763 | £749 | £735 | £721 | £707 | £693 | £679 | £665 | |
| Taxes Incurred | (£13,720) | (£13,716) | (£4,412) | £1,592 | £6,697 | £9,026 | £13,680 | £13,684 | £13,688 | £11,593 | £14,597 | £20,601 | |
| Net Profit | (£32,014) | (£32,004) | (£10,294) | £3,716 | £15,625 | £21,060 | £31,920 | £31,930 | £31,940 | £27,050 | £34,059 | £48,069 | |
| Net Profit/Sales | 0.00% | 0.00% | -8.30% | 2.46% | 7.51% | 10.03% | 11.40% | 11.40% | 11.41% | 11.76% | 10.81% | 11.72% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £0 | £0 | £31,000 | £37,750 | £52,000 | £52,500 | £70,000 | £70,000 | £70,000 | £57,500 | £78,750 | £102,500 | |
| Cash from Receivables | £0 | £0 | £0 | £3,100 | £93,675 | £114,675 | £156,050 | £159,250 | £210,000 | £210,000 | £208,750 | £174,625 | |
| Subtotal Cash from Operations | £0 | £0 | £31,000 | £40,850 | £145,675 | £167,175 | £226,050 | £229,250 | £280,000 | £267,500 | £287,500 | £277,125 | |
| 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 | £66,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £0 | £31,000 | £106,850 | £145,675 | £167,175 | £226,050 | £229,250 | £280,000 | £267,500 | £287,500 | £277,125 | |
| 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 | £28,500 | £28,500 | £28,500 | £28,500 | £28,500 | £23,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | |
| Bill Payments | £117 | £3,514 | £6,914 | £106,227 | £120,287 | £163,927 | £167,078 | £214,580 | £214,570 | £213,057 | £172,050 | £250,140 | |
| Subtotal Spent on Operations | £28,617 | £32,014 | £35,414 | £134,727 | £148,787 | £187,427 | £200,578 | £248,080 | £248,070 | £246,557 | £205,550 | £283,640 | |
| 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 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | |
| 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 | £30,305 | £33,702 | £37,102 | £136,415 | £150,475 | £189,115 | £202,266 | £249,768 | £249,758 | £248,245 | £207,238 | £285,328 | |
| Net Cash Flow | (£30,305) | (£33,702) | (£6,102) | (£29,565) | (£4,800) | (£21,940) | £23,784 | (£20,518) | £30,242 | £19,255 | £80,262 | (£8,203) | |
| Cash Balance | £103,395 | £69,693 | £63,591 | £34,026 | £29,226 | £7,286 | £31,070 | £10,553 | £40,795 | £60,050 | £140,312 | £132,109 | |
| 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 | £133,700 | £103,395 | £69,693 | £63,591 | £34,026 | £29,226 | £7,286 | £31,070 | £10,553 | £40,795 | £60,050 | £140,312 | £132,109 |
| Accounts Receivable | £0 | £0 | £0 | £93,000 | £203,150 | £265,475 | £308,300 | £362,250 | £413,000 | £413,000 | £375,500 | £403,000 | £535,875 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £133,700 | £103,395 | £69,693 | £156,591 | £237,176 | £294,701 | £315,586 | £393,320 | £423,553 | £453,795 | £435,550 | £543,312 | £667,984 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £133,700 | £103,395 | £69,693 | £156,591 | £237,176 | £294,701 | £315,586 | £393,320 | £423,553 | £453,795 | £435,550 | £543,312 | £667,984 |
| 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,397 | £3,387 | £102,268 | £114,825 | £158,412 | £159,925 | £207,427 | £207,418 | £207,408 | £163,802 | £239,193 | £317,483 |
| 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,397 | £3,387 | £102,268 | £114,825 | £158,412 | £159,925 | £207,427 | £207,418 | £207,408 | £163,802 | £239,193 | £317,483 |
| Long-term Liabilities | £100,000 | £98,312 | £96,624 | £94,936 | £93,248 | £91,560 | £89,872 | £88,184 | £86,496 | £84,808 | £83,120 | £81,432 | £79,744 |
| Total Liabilities | £100,000 | £101,709 | £100,011 | £197,204 | £208,073 | £249,972 | £249,797 | £295,611 | £293,914 | £292,216 | £246,922 | £320,625 | £397,227 |
| Paid-in Capital | £50,000 | £50,000 | £50,000 | £50,000 | £116,000 | £116,000 | £116,000 | £116,000 | £116,000 | £116,000 | £116,000 | £116,000 | £116,000 |
| Retained Earnings | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) |
| Earnings | £0 | (£32,014) | (£64,018) | (£74,312) | (£70,597) | (£54,971) | (£33,911) | (£1,991) | £29,939 | £61,879 | £88,928 | £122,988 | £171,057 |
| Total Capital | £33,700 | £1,686 | (£30,318) | (£40,612) | £29,103 | £44,729 | £65,789 | £97,709 | £129,639 | £161,579 | £188,628 | £222,688 | £270,757 |
| Total Liabilities and Capital | £133,700 | £103,395 | £69,693 | £156,591 | £237,176 | £294,701 | £315,586 | £393,320 | £423,553 | £453,795 | £435,550 | £543,312 | £667,984 |
| Net Worth | £33,700 | £1,686 | (£30,318) | (£40,612) | £29,103 | £44,729 | £65,789 | £97,709 | £129,639 | £161,579 | £188,628 | £222,688 | £270,757 |
| 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 | |||||||||||||
| Promerit Inventory Basic | 0% | £0 | £0 | £70,000 | £80,000 | £120,000 | £120,000 | £160,000 | £160,000 | £160,000 | £140,000 | £200,000 | £240,000 |
| Hardware | 0% | £0 | £0 | £54,000 | £60,000 | £75,000 | £75,000 | £105,000 | £105,000 | £105,000 | £80,000 | £100,000 | £150,000 |
| Software Modules | 0% | £0 | £0 | £0 | £11,000 | £13,000 | £15,000 | £15,000 | £15,000 | £15,000 | £10,000 | £15,000 | £20,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £0 | £0 | £124,000 | £151,000 | £208,000 | £210,000 | £280,000 | £280,000 | £280,000 | £230,000 | £315,000 | £410,000 | |
| 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 | |
| Promerit Inventory Basic | £0 | £0 | £57,000 | £60,000 | £90,000 | £90,000 | £120,000 | £120,000 | £120,000 | £90,000 | £150,000 | £190,000 | |
| Hardware | £0 | £0 | £36,000 | £40,000 | £50,000 | £50,000 | £63,000 | £63,000 | £63,000 | £50,000 | £65,000 | £100,000 | |
| Software Modules | £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 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £93,000 | £100,000 | £140,000 | £140,000 | £183,000 | £183,000 | £183,000 | £140,000 | £215,000 | £290,000 | |
| 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 | ||
| Manager | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Accounting Manager | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Sales Staff | 0% | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Software Engineers | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £0 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £28,500 | £28,500 | £28,500 | £28,500 | £28,500 | £23,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £0 | £0 | £124,000 | £151,000 | £208,000 | £210,000 | £280,000 | £280,000 | £280,000 | £230,000 | £315,000 | £410,000 | |
| Direct Cost of Sales | £0 | £0 | £93,000 | £100,000 | £140,000 | £140,000 | £183,000 | £183,000 | £183,000 | £140,000 | £215,000 | £290,000 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £93,000 | £100,000 | £140,000 | £140,000 | £183,000 | £183,000 | £183,000 | £140,000 | £215,000 | £290,000 | |
| Gross Margin | £0 | £0 | £31,000 | £51,000 | £68,000 | £70,000 | £97,000 | £97,000 | £97,000 | £90,000 | £100,000 | £120,000 | |
| Gross Margin % | 0.00% | 0.00% | 25.00% | 33.77% | 32.69% | 33.33% | 34.64% | 34.64% | 34.64% | 39.13% | 31.75% | 29.27% | |
| Expenses | |||||||||||||
| Payroll | £28,500 | £28,500 | £28,500 | £28,500 | £28,500 | £23,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | |
| Sales and Marketing and Other Expenses | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | £140 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Payroll Taxes | 15% | £4,275 | £4,275 | £4,275 | £4,275 | £4,275 | £3,525 | £5,025 | £5,025 | £5,025 | £5,025 | £5,025 | £5,025 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £44,915 | £44,915 | £44,915 | £44,915 | £44,915 | £39,165 | £50,665 | £50,665 | £50,665 | £50,665 | £50,665 | £50,665 | |
| Profit Before Interest and Taxes | (£44,915) | (£44,915) | (£13,915) | £6,085 | £23,085 | £30,835 | £46,335 | £46,335 | £46,335 | £39,335 | £49,335 | £69,335 | |
| EBITDA | (£44,915) | (£44,915) | (£13,915) | £6,085 | £23,085 | £30,835 | £46,335 | £46,335 | £46,335 | £39,335 | £49,335 | £69,335 | |
| Interest Expense | £819 | £805 | £791 | £777 | £763 | £749 | £735 | £721 | £707 | £693 | £679 | £665 | |
| Taxes Incurred | (£13,720) | (£13,716) | (£4,412) | £1,592 | £6,697 | £9,026 | £13,680 | £13,684 | £13,688 | £11,593 | £14,597 | £20,601 | |
| Net Profit | (£32,014) | (£32,004) | (£10,294) | £3,716 | £15,625 | £21,060 | £31,920 | £31,930 | £31,940 | £27,050 | £34,059 | £48,069 | |
| Net Profit/Sales | 0.00% | 0.00% | -8.30% | 2.46% | 7.51% | 10.03% | 11.40% | 11.40% | 11.41% | 11.76% | 10.81% | 11.72% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £0 | £0 | £31,000 | £37,750 | £52,000 | £52,500 | £70,000 | £70,000 | £70,000 | £57,500 | £78,750 | £102,500 | |
| Cash from Receivables | £0 | £0 | £0 | £3,100 | £93,675 | £114,675 | £156,050 | £159,250 | £210,000 | £210,000 | £208,750 | £174,625 | |
| Subtotal Cash from Operations | £0 | £0 | £31,000 | £40,850 | £145,675 | £167,175 | £226,050 | £229,250 | £280,000 | £267,500 | £287,500 | £277,125 | |
| 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 | £66,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £0 | £31,000 | £106,850 | £145,675 | £167,175 | £226,050 | £229,250 | £280,000 | £267,500 | £287,500 | £277,125 | |
| 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 | £28,500 | £28,500 | £28,500 | £28,500 | £28,500 | £23,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | £33,500 | |
| Bill Payments | £117 | £3,514 | £6,914 | £106,227 | £120,287 | £163,927 | £167,078 | £214,580 | £214,570 | £213,057 | £172,050 | £250,140 | |
| Subtotal Spent on Operations | £28,617 | £32,014 | £35,414 | £134,727 | £148,787 | £187,427 | £200,578 | £248,080 | £248,070 | £246,557 | £205,550 | £283,640 | |
| 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 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | |
| 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 | £30,305 | £33,702 | £37,102 | £136,415 | £150,475 | £189,115 | £202,266 | £249,768 | £249,758 | £248,245 | £207,238 | £285,328 | |
| Net Cash Flow | (£30,305) | (£33,702) | (£6,102) | (£29,565) | (£4,800) | (£21,940) | £23,784 | (£20,518) | £30,242 | £19,255 | £80,262 | (£8,203) | |
| Cash Balance | £103,395 | £69,693 | £63,591 | £34,026 | £29,226 | £7,286 | £31,070 | £10,553 | £40,795 | £60,050 | £140,312 | £132,109 | |
| 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 | £133,700 | £103,395 | £69,693 | £63,591 | £34,026 | £29,226 | £7,286 | £31,070 | £10,553 | £40,795 | £60,050 | £140,312 | £132,109 |
| Accounts Receivable | £0 | £0 | £0 | £93,000 | £203,150 | £265,475 | £308,300 | £362,250 | £413,000 | £413,000 | £375,500 | £403,000 | £535,875 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £133,700 | £103,395 | £69,693 | £156,591 | £237,176 | £294,701 | £315,586 | £393,320 | £423,553 | £453,795 | £435,550 | £543,312 | £667,984 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £133,700 | £103,395 | £69,693 | £156,591 | £237,176 | £294,701 | £315,586 | £393,320 | £423,553 | £453,795 | £435,550 | £543,312 | £667,984 |
| 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,397 | £3,387 | £102,268 | £114,825 | £158,412 | £159,925 | £207,427 | £207,418 | £207,408 | £163,802 | £239,193 | £317,483 |
| 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,397 | £3,387 | £102,268 | £114,825 | £158,412 | £159,925 | £207,427 | £207,418 | £207,408 | £163,802 | £239,193 | £317,483 |
| Long-term Liabilities | £100,000 | £98,312 | £96,624 | £94,936 | £93,248 | £91,560 | £89,872 | £88,184 | £86,496 | £84,808 | £83,120 | £81,432 | £79,744 |
| Total Liabilities | £100,000 | £101,709 | £100,011 | £197,204 | £208,073 | £249,972 | £249,797 | £295,611 | £293,914 | £292,216 | £246,922 | £320,625 | £397,227 |
| Paid-in Capital | £50,000 | £50,000 | £50,000 | £50,000 | £116,000 | £116,000 | £116,000 | £116,000 | £116,000 | £116,000 | £116,000 | £116,000 | £116,000 |
| Retained Earnings | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) | (£16,300) |
| Earnings | £0 | (£32,014) | (£64,018) | (£74,312) | (£70,597) | (£54,971) | (£33,911) | (£1,991) | £29,939 | £61,879 | £88,928 | £122,988 | £171,057 |
| Total Capital | £33,700 | £1,686 | (£30,318) | (£40,612) | £29,103 | £44,729 | £65,789 | £97,709 | £129,639 | £161,579 | £188,628 | £222,688 | £270,757 |
| Total Liabilities and Capital | £133,700 | £103,395 | £69,693 | £156,591 | £237,176 | £294,701 | £315,586 | £393,320 | £423,553 | £453,795 | £435,550 | £543,312 | £667,984 |
| Net Worth | £33,700 | £1,686 | (£30,318) | (£40,612) | £29,103 | £44,729 | £65,789 | £97,709 | £129,639 | £161,579 | £188,628 | £222,688 | £270,757 |