| 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 | |||||||||||||
| MedStim- Logic Controller | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| MedStim- Array of Coils | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 |
| TheraMag- Logic Controller | 0% | 0 | 0 | 0 | 0 | 4 | 6 | 10 | 15 | 30 | 45 | 60 | 80 |
| TheraMag- Array of Coils | 0% | 0 | 0 | 0 | 0 | 4 | 6 | 10 | 15 | 30 | 45 | 60 | 80 |
| Total Unit Sales | 0 | 0 | 0 | 0 | 8 | 12 | 20 | 30 | 60 | 90 | 120 | 166 | |
| 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 | |
| MedStim- Logic Controller | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | |
| MedStim- Array of Coils | £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 | |
| TheraMag- Logic Controller | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | |
| TheraMag- Array of Coils | £80.00 | £80.00 | £80.00 | £80.00 | £80.00 | £80.00 | £80.00 | £80.00 | £80.00 | £80.00 | £80.00 | £80.00 | |
| Sales | |||||||||||||
| MedStim- Logic Controller | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £18,500 | |
| MedStim- Array of Coils | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £7,500 | |
| TheraMag- Logic Controller | £0 | £0 | £0 | £0 | £1,200 | £1,800 | £3,000 | £4,500 | £9,000 | £13,500 | £18,000 | £24,000 | |
| TheraMag- Array of Coils | £0 | £0 | £0 | £0 | £320 | £480 | £800 | £1,200 | £2,400 | £3,600 | £4,800 | £6,400 | |
| Total Sales | £0 | £0 | £0 | £0 | £1,520 | £2,280 | £3,800 | £5,700 | £11,400 | £17,100 | £22,800 | £56,400 | |
| 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 | |
| MedStim- Logic Controller | 0.00% | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 |
| MedStim- Array of Coils | 0.00% | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 |
| TheraMag- Logic Controller | 0.00% | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 |
| TheraMag- Array of Coils | 0.00% | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 |
| Direct Cost of Sales | |||||||||||||
| MedStim- Logic Controller | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,000 | |
| MedStim- Array of Coils | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | |
| TheraMag- Logic Controller | £0 | £0 | £0 | £0 | £800 | £1,200 | £2,000 | £3,000 | £6,000 | £9,000 | £12,000 | £16,000 | |
| TheraMag- Array of Coils | £0 | £0 | £0 | £0 | £200 | £300 | £500 | £750 | £1,500 | £2,250 | £3,000 | £4,000 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £1,000 | £1,500 | £2,500 | £3,750 | £7,500 | £11,250 | £15,000 | £24,500 | |
| 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 | ||
| Production Personnel | |||||||||||||
| Production Manager | £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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales and Marketing Personnel | |||||||||||||
| VP Sales/Marketing | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Sales Manager | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Field Sales Manager | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Marketing/Product Manager | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales Reps | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales Administrator | £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 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| General and Administrative Personnel | |||||||||||||
| CEO | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| CFO | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| VP Corp Development | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £5,000 | £5,000 | |
| Executive Assistant | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | |
| Executive Secretary | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Controller | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Adminstrative Staff (4) | £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 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £17,000 | £17,000 | |
| Other Personnel | |||||||||||||
| VP Research & Development | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Quality Contol Engineer | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Design Engineer | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Research Engineers (2) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Junior Engineer | £0 | £0 | £0 | £0 | £0 | £0 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 7 | 7 | |
| Total Payroll | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £22,500 | £22,500 | £22,500 | £22,500 | £29,500 | £29,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 | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | |
| Long-term Interest Rate | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | |
| 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 | £0 | £0 | £1,520 | £2,280 | £3,800 | £5,700 | £11,400 | £17,100 | £22,800 | £56,400 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £1,000 | £1,500 | £2,500 | £3,750 | £7,500 | £11,250 | £15,000 | £24,500 | |
| Production Payroll | £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 | £1,000 | £1,500 | £2,500 | £3,750 | £7,500 | £11,250 | £15,000 | £24,500 | |
| Gross Margin | £0 | £0 | £0 | £0 | £520 | £780 | £1,300 | £1,950 | £3,900 | £5,850 | £7,800 | £31,900 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 34.21% | 34.21% | 34.21% | 34.21% | 34.21% | 34.21% | 34.21% | 56.56% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Advertising/Promotion | £0 | £0 | £0 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Travel | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Research and Design Expenses | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | |
| Miscellaneous | £0 | £0 | £0 | £0 | £0 | £0 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Total Sales and Marketing Expenses | £23,000 | £23,000 | £23,000 | £30,000 | £30,000 | £30,000 | £30,500 | £30,500 | £30,500 | £30,500 | £30,500 | £30,500 | |
| Sales and Marketing % | 0.00% | 0.00% | 0.00% | 0.00% | 1973.68% | 1315.79% | 802.63% | 535.09% | 267.54% | 178.36% | 133.77% | 54.08% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £17,000 | £17,000 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Insurance | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| 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 | 21% | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,725 | £4,725 | £4,725 | £4,725 | £6,195 | £6,195 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £19,700 | £19,700 | £19,700 | £19,700 | £19,700 | £19,700 | £20,225 | £20,225 | £20,225 | £20,225 | £28,695 | £28,695 | |
| General and Administrative % | 0.00% | 0.00% | 0.00% | 0.00% | 1296.05% | 864.04% | 532.24% | 354.82% | 177.41% | 118.27% | 125.86% | 50.88% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Contract/Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expenses | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | |
| Other % | 0.00% | 0.00% | 0.00% | 0.00% | 460.53% | 307.02% | 250.00% | 166.67% | 83.33% | 55.56% | 41.67% | 16.84% | |
| Total Operating Expenses | £49,700 | £49,700 | £49,700 | £56,700 | £56,700 | £56,700 | £60,225 | £60,225 | £60,225 | £60,225 | £68,695 | £68,695 | |
| Profit Before Interest and Taxes | (£49,700) | (£49,700) | (£49,700) | (£56,700) | (£56,180) | (£55,920) | (£58,925) | (£58,275) | (£56,325) | (£54,375) | (£60,895) | (£36,795) | |
| EBITDA | (£49,700) | (£49,700) | (£49,700) | (£56,700) | (£56,180) | (£55,920) | (£58,925) | (£58,275) | (£56,325) | (£54,375) | (£60,895) | (£36,795) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£49,700) | (£49,700) | (£49,700) | (£56,700) | (£56,180) | (£55,920) | (£58,925) | (£58,275) | (£56,325) | (£54,375) | (£60,895) | (£36,795) | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | -3696.05% | -2452.63% | -1550.66% | -1022.37% | -494.08% | -317.98% | -267.08% | -65.24% | |
| 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 | £82,000 | £59,010 | £757,310 | £705,610 | £653,677 | £595,287 | £535,666 | £474,724 | £412,592 | £351,485 | £288,340 | £217,096 | £152,954 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £0 | £1,140 | £2,242 | £3,648 | £5,605 | £10,545 | £16,815 | £23,085 | £50,280 |
| Inventory | £0 | £0 | £0 | £0 | £0 | £1,100 | £1,650 | £2,750 | £4,125 | £8,250 | £12,375 | £16,500 | £26,950 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £82,000 | £59,010 | £757,310 | £705,610 | £653,677 | £597,527 | £539,558 | £481,122 | £422,322 | £370,280 | £317,530 | £256,681 | £230,184 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £2,000 | £4,000 | £6,000 | £8,000 | £10,000 | £12,000 | £14,000 | £16,000 | £18,000 | £20,000 | £25,000 | £30,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £2,000 | £4,000 | £6,000 | £8,000 | £10,000 | £12,000 | £14,000 | £16,000 | £18,000 | £20,000 | £25,000 | £30,000 |
| Total Assets | £82,000 | £61,010 | £761,310 | £711,610 | £661,677 | £607,527 | £551,558 | £495,122 | £438,322 | £388,280 | £337,530 | £281,681 | £260,184 |
| 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 | £28,710 | £28,710 | £28,710 | £35,477 | £37,507 | £37,458 | £39,948 | £41,422 | £47,705 | £51,330 | £56,376 | £71,674 |
| 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 | £28,710 | £28,710 | £28,710 | £35,477 | £37,507 | £37,458 | £39,948 | £41,422 | £47,705 | £51,330 | £56,376 | £71,674 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £28,710 | £28,710 | £28,710 | £35,477 | £37,507 | £37,458 | £39,948 | £41,422 | £47,705 | £51,330 | £56,376 | £71,674 |
| Paid-in Capital | £250,000 | £250,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 | £1,000,000 | £1,000,000 | £1,000,000 |
| Retained Earnings | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) |
| Earnings | £0 | (£49,700) | (£99,400) | (£149,100) | (£205,800) | (£261,980) | (£317,900) | (£376,825) | (£435,100) | (£491,425) | (£545,800) | (£606,695) | (£643,490) |
| Total Capital | £82,000 | £32,300 | £732,600 | £682,900 | £626,200 | £570,020 | £514,100 | £455,175 | £396,900 | £340,575 | £286,200 | £225,305 | £188,510 |
| Total Liabilities and Capital | £82,000 | £61,010 | £761,310 | £711,610 | £661,677 | £607,527 | £551,558 | £495,123 | £438,322 | £388,280 | £337,530 | £281,681 | £260,184 |
| Net Worth | £82,000 | £32,300 | £732,600 | £682,900 | £626,200 | £570,020 | £514,100 | £455,175 | £396,900 | £340,575 | £286,200 | £225,305 | £188,510 |
| 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 | £0 | £0 | £380 | £570 | £950 | £1,425 | £2,850 | £4,275 | £5,700 | £14,100 | |
| Cash from Receivables | £0 | £0 | £0 | £0 | £0 | £608 | £1,444 | £2,318 | £3,610 | £6,555 | £10,830 | £15,105 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £380 | £1,178 | £2,394 | £3,743 | £6,460 | £10,830 | £16,530 | £29,205 | |
| 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 | £750,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £750,000 | £0 | £0 | £380 | £1,178 | £2,394 | £3,743 | £6,460 | £10,830 | £16,530 | £29,205 | |
| 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 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £22,500 | £22,500 | £22,500 | £22,500 | £29,500 | £29,500 | |
| Bill Payments | £990 | £29,700 | £29,700 | £29,933 | £36,770 | £38,798 | £38,836 | £41,376 | £43,067 | £49,475 | £53,274 | £58,848 | |
| Subtotal Spent on Operations | £20,990 | £49,700 | £49,700 | £49,933 | £56,770 | £58,798 | £61,336 | £63,876 | £65,567 | £71,975 | £82,774 | £88,348 | |
| 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 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £5,000 | £5,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £22,990 | £51,700 | £51,700 | £51,933 | £58,770 | £60,798 | £63,336 | £65,876 | £67,567 | £73,975 | £87,774 | £93,348 | |
| Net Cash Flow | (£22,990) | £698,300 | (£51,700) | (£51,933) | (£58,390) | (£59,620) | (£60,942) | (£62,133) | (£61,107) | (£63,145) | (£71,244) | (£64,143) | |
| Cash Balance | £59,010 | £757,310 | £705,610 | £653,677 | £595,287 | £535,666 | £474,724 | £412,592 | £351,485 | £288,340 | £217,096 | £152,954 | |
| 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 | |||||||||||||
| MedStim- Logic Controller | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| MedStim- Array of Coils | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 |
| TheraMag- Logic Controller | 0% | 0 | 0 | 0 | 0 | 4 | 6 | 10 | 15 | 30 | 45 | 60 | 80 |
| TheraMag- Array of Coils | 0% | 0 | 0 | 0 | 0 | 4 | 6 | 10 | 15 | 30 | 45 | 60 | 80 |
| Total Unit Sales | 0 | 0 | 0 | 0 | 8 | 12 | 20 | 30 | 60 | 90 | 120 | 166 | |
| 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 | |
| MedStim- Logic Controller | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | £18,500.00 | |
| MedStim- Array of Coils | £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 | |
| TheraMag- Logic Controller | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | |
| TheraMag- Array of Coils | £80.00 | £80.00 | £80.00 | £80.00 | £80.00 | £80.00 | £80.00 | £80.00 | £80.00 | £80.00 | £80.00 | £80.00 | |
| Sales | |||||||||||||
| MedStim- Logic Controller | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £18,500 | |
| MedStim- Array of Coils | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £7,500 | |
| TheraMag- Logic Controller | £0 | £0 | £0 | £0 | £1,200 | £1,800 | £3,000 | £4,500 | £9,000 | £13,500 | £18,000 | £24,000 | |
| TheraMag- Array of Coils | £0 | £0 | £0 | £0 | £320 | £480 | £800 | £1,200 | £2,400 | £3,600 | £4,800 | £6,400 | |
| Total Sales | £0 | £0 | £0 | £0 | £1,520 | £2,280 | £3,800 | £5,700 | £11,400 | £17,100 | £22,800 | £56,400 | |
| 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 | |
| MedStim- Logic Controller | 0.00% | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 | £3,000.00 |
| MedStim- Array of Coils | 0.00% | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 |
| TheraMag- Logic Controller | 0.00% | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 |
| TheraMag- Array of Coils | 0.00% | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 |
| Direct Cost of Sales | |||||||||||||
| MedStim- Logic Controller | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,000 | |
| MedStim- Array of Coils | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | |
| TheraMag- Logic Controller | £0 | £0 | £0 | £0 | £800 | £1,200 | £2,000 | £3,000 | £6,000 | £9,000 | £12,000 | £16,000 | |
| TheraMag- Array of Coils | £0 | £0 | £0 | £0 | £200 | £300 | £500 | £750 | £1,500 | £2,250 | £3,000 | £4,000 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £1,000 | £1,500 | £2,500 | £3,750 | £7,500 | £11,250 | £15,000 | £24,500 | |
| 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 | ||
| Production Personnel | |||||||||||||
| Production Manager | £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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales and Marketing Personnel | |||||||||||||
| VP Sales/Marketing | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Sales Manager | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Field Sales Manager | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Marketing/Product Manager | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales Reps | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales Administrator | £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 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| General and Administrative Personnel | |||||||||||||
| CEO | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| CFO | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| VP Corp Development | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £5,000 | £5,000 | |
| Executive Assistant | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | |
| Executive Secretary | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Controller | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Adminstrative Staff (4) | £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 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £17,000 | £17,000 | |
| Other Personnel | |||||||||||||
| VP Research & Development | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Quality Contol Engineer | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Design Engineer | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Research Engineers (2) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Junior Engineer | £0 | £0 | £0 | £0 | £0 | £0 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 7 | 7 | |
| Total Payroll | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £22,500 | £22,500 | £22,500 | £22,500 | £29,500 | £29,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 | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | |
| Long-term Interest Rate | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | |
| 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 | £0 | £0 | £1,520 | £2,280 | £3,800 | £5,700 | £11,400 | £17,100 | £22,800 | £56,400 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £1,000 | £1,500 | £2,500 | £3,750 | £7,500 | £11,250 | £15,000 | £24,500 | |
| Production Payroll | £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 | £1,000 | £1,500 | £2,500 | £3,750 | £7,500 | £11,250 | £15,000 | £24,500 | |
| Gross Margin | £0 | £0 | £0 | £0 | £520 | £780 | £1,300 | £1,950 | £3,900 | £5,850 | £7,800 | £31,900 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 34.21% | 34.21% | 34.21% | 34.21% | 34.21% | 34.21% | 34.21% | 56.56% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Advertising/Promotion | £0 | £0 | £0 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Travel | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Research and Design Expenses | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | |
| Miscellaneous | £0 | £0 | £0 | £0 | £0 | £0 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Total Sales and Marketing Expenses | £23,000 | £23,000 | £23,000 | £30,000 | £30,000 | £30,000 | £30,500 | £30,500 | £30,500 | £30,500 | £30,500 | £30,500 | |
| Sales and Marketing % | 0.00% | 0.00% | 0.00% | 0.00% | 1973.68% | 1315.79% | 802.63% | 535.09% | 267.54% | 178.36% | 133.77% | 54.08% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £17,000 | £17,000 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Insurance | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| 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 | 21% | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,725 | £4,725 | £4,725 | £4,725 | £6,195 | £6,195 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £19,700 | £19,700 | £19,700 | £19,700 | £19,700 | £19,700 | £20,225 | £20,225 | £20,225 | £20,225 | £28,695 | £28,695 | |
| General and Administrative % | 0.00% | 0.00% | 0.00% | 0.00% | 1296.05% | 864.04% | 532.24% | 354.82% | 177.41% | 118.27% | 125.86% | 50.88% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Contract/Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expenses | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | |
| Other % | 0.00% | 0.00% | 0.00% | 0.00% | 460.53% | 307.02% | 250.00% | 166.67% | 83.33% | 55.56% | 41.67% | 16.84% | |
| Total Operating Expenses | £49,700 | £49,700 | £49,700 | £56,700 | £56,700 | £56,700 | £60,225 | £60,225 | £60,225 | £60,225 | £68,695 | £68,695 | |
| Profit Before Interest and Taxes | (£49,700) | (£49,700) | (£49,700) | (£56,700) | (£56,180) | (£55,920) | (£58,925) | (£58,275) | (£56,325) | (£54,375) | (£60,895) | (£36,795) | |
| EBITDA | (£49,700) | (£49,700) | (£49,700) | (£56,700) | (£56,180) | (£55,920) | (£58,925) | (£58,275) | (£56,325) | (£54,375) | (£60,895) | (£36,795) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£49,700) | (£49,700) | (£49,700) | (£56,700) | (£56,180) | (£55,920) | (£58,925) | (£58,275) | (£56,325) | (£54,375) | (£60,895) | (£36,795) | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | -3696.05% | -2452.63% | -1550.66% | -1022.37% | -494.08% | -317.98% | -267.08% | -65.24% | |
| 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 | £82,000 | £59,010 | £757,310 | £705,610 | £653,677 | £595,287 | £535,666 | £474,724 | £412,592 | £351,485 | £288,340 | £217,096 | £152,954 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £0 | £1,140 | £2,242 | £3,648 | £5,605 | £10,545 | £16,815 | £23,085 | £50,280 |
| Inventory | £0 | £0 | £0 | £0 | £0 | £1,100 | £1,650 | £2,750 | £4,125 | £8,250 | £12,375 | £16,500 | £26,950 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £82,000 | £59,010 | £757,310 | £705,610 | £653,677 | £597,527 | £539,558 | £481,122 | £422,322 | £370,280 | £317,530 | £256,681 | £230,184 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £2,000 | £4,000 | £6,000 | £8,000 | £10,000 | £12,000 | £14,000 | £16,000 | £18,000 | £20,000 | £25,000 | £30,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £2,000 | £4,000 | £6,000 | £8,000 | £10,000 | £12,000 | £14,000 | £16,000 | £18,000 | £20,000 | £25,000 | £30,000 |
| Total Assets | £82,000 | £61,010 | £761,310 | £711,610 | £661,677 | £607,527 | £551,558 | £495,122 | £438,322 | £388,280 | £337,530 | £281,681 | £260,184 |
| 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 | £28,710 | £28,710 | £28,710 | £35,477 | £37,507 | £37,458 | £39,948 | £41,422 | £47,705 | £51,330 | £56,376 | £71,674 |
| 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 | £28,710 | £28,710 | £28,710 | £35,477 | £37,507 | £37,458 | £39,948 | £41,422 | £47,705 | £51,330 | £56,376 | £71,674 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £28,710 | £28,710 | £28,710 | £35,477 | £37,507 | £37,458 | £39,948 | £41,422 | £47,705 | £51,330 | £56,376 | £71,674 |
| Paid-in Capital | £250,000 | £250,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 | £1,000,000 | £1,000,000 | £1,000,000 |
| Retained Earnings | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) | (£168,000) |
| Earnings | £0 | (£49,700) | (£99,400) | (£149,100) | (£205,800) | (£261,980) | (£317,900) | (£376,825) | (£435,100) | (£491,425) | (£545,800) | (£606,695) | (£643,490) |
| Total Capital | £82,000 | £32,300 | £732,600 | £682,900 | £626,200 | £570,020 | £514,100 | £455,175 | £396,900 | £340,575 | £286,200 | £225,305 | £188,510 |
| Total Liabilities and Capital | £82,000 | £61,010 | £761,310 | £711,610 | £661,677 | £607,527 | £551,558 | £495,123 | £438,322 | £388,280 | £337,530 | £281,681 | £260,184 |
| Net Worth | £82,000 | £32,300 | £732,600 | £682,900 | £626,200 | £570,020 | £514,100 | £455,175 | £396,900 | £340,575 | £286,200 | £225,305 | £188,510 |
| 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 | £0 | £0 | £380 | £570 | £950 | £1,425 | £2,850 | £4,275 | £5,700 | £14,100 | |
| Cash from Receivables | £0 | £0 | £0 | £0 | £0 | £608 | £1,444 | £2,318 | £3,610 | £6,555 | £10,830 | £15,105 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £380 | £1,178 | £2,394 | £3,743 | £6,460 | £10,830 | £16,530 | £29,205 | |
| 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 | £750,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £750,000 | £0 | £0 | £380 | £1,178 | £2,394 | £3,743 | £6,460 | £10,830 | £16,530 | £29,205 | |
| 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 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £22,500 | £22,500 | £22,500 | £22,500 | £29,500 | £29,500 | |
| Bill Payments | £990 | £29,700 | £29,700 | £29,933 | £36,770 | £38,798 | £38,836 | £41,376 | £43,067 | £49,475 | £53,274 | £58,848 | |
| Subtotal Spent on Operations | £20,990 | £49,700 | £49,700 | £49,933 | £56,770 | £58,798 | £61,336 | £63,876 | £65,567 | £71,975 | £82,774 | £88,348 | |
| 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 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £5,000 | £5,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £22,990 | £51,700 | £51,700 | £51,933 | £58,770 | £60,798 | £63,336 | £65,876 | £67,567 | £73,975 | £87,774 | £93,348 | |
| Net Cash Flow | (£22,990) | £698,300 | (£51,700) | (£51,933) | (£58,390) | (£59,620) | (£60,942) | (£62,133) | (£61,107) | (£63,145) | (£71,244) | (£64,143) | |
| Cash Balance | £59,010 | £757,310 | £705,610 | £653,677 | £595,287 | £535,666 | £474,724 | £412,592 | £351,485 | £288,340 | £217,096 | £152,954 | |