| 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 | |||||||||||||
| Law firms | 0% | £0 | £3,525 | £7,214 | £8,600 | £10,254 | £11,458 | £15,455 | £17,458 | £18,524 | £19,874 | £19,952 | £20,145 |
| Assorted customers | 0% | £0 | £954 | £1,245 | £1,154 | £1,547 | £2,154 | £2,658 | £2,014 | £2,147 | £2,200 | £2,314 | £2,454 |
| Total Sales | £0 | £4,479 | £8,459 | £9,754 | £11,801 | £13,612 | £18,113 | £19,472 | £20,671 | £22,074 | £22,266 | £22,599 | |
| 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 | |
| Law firms | £0 | £71 | £144 | £172 | £205 | £229 | £309 | £349 | £370 | £397 | £399 | £403 | |
| Assorted customers | £0 | £19 | £25 | £23 | £31 | £43 | £53 | £40 | £43 | £44 | £46 | £49 | |
| Subtotal Direct Cost of Sales | £0 | £90 | £169 | £195 | £236 | £272 | £362 | £389 | £413 | £441 | £445 | £452 | |
| 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 | ||
| Alwy Laate | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Dispatcher | 0% | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 |
| Messenger | 0% | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 |
| Messenger | 0% | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 |
| Messenger | 0% | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 |
| Messenger | 0% | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 |
| Messenger | 0% | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 |
| Messenger | 0% | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 |
| Messenger | 0% | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £0 | £4,479 | £8,459 | £9,754 | £11,801 | £13,612 | £18,113 | £19,472 | £20,671 | £22,074 | £22,266 | £22,599 | |
| Direct Cost of Sales | £0 | £90 | £169 | £195 | £236 | £272 | £362 | £389 | £413 | £441 | £445 | £452 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £90 | £169 | £195 | £236 | £272 | £362 | £389 | £413 | £441 | £445 | £452 | |
| Gross Margin | £0 | £4,389 | £8,290 | £9,559 | £11,565 | £13,340 | £17,751 | £19,083 | £20,258 | £21,633 | £21,821 | £22,147 | |
| Gross Margin % | 0.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | |
| Expenses | |||||||||||||
| Payroll | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | |
| Sales and Marketing and Other Expenses | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Depreciation | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Cellular service | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Utilities | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Rent | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Payroll Taxes | 15% | £2,217 | £2,217 | £2,217 | £2,217 | £2,217 | £2,217 | £2,217 | £2,217 | £2,217 | £2,217 | £2,217 | £2,217 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £18,772 | £18,772 | £18,772 | £18,772 | £18,772 | £18,772 | £18,772 | £18,772 | £18,772 | £18,772 | £18,772 | £18,772 | |
| Profit Before Interest and Taxes | (£18,772) | (£14,383) | (£10,482) | (£9,213) | (£7,207) | (£5,432) | (£1,021) | £311 | £1,486 | £2,861 | £3,049 | £3,375 | |
| EBITDA | (£18,647) | (£14,258) | (£10,357) | (£9,088) | (£7,082) | (£5,307) | (£896) | £436 | £1,611 | £2,986 | £3,174 | £3,500 | |
| Interest Expense | £411 | £405 | £399 | £392 | £386 | £380 | £374 | £367 | £361 | £354 | £348 | £341 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£19,183) | (£14,787) | (£10,881) | (£9,605) | (£7,593) | (£5,812) | (£1,395) | (£57) | £1,125 | £2,506 | £2,701 | £3,034 | |
| Net Profit/Sales | 0.00% | -330.14% | -128.63% | -98.48% | -64.34% | -42.70% | -7.70% | -0.29% | 5.44% | 11.35% | 12.13% | 13.42% | |
| 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 | £1,120 | £2,115 | £2,439 | £2,950 | £3,403 | £4,528 | £4,868 | £5,168 | £5,519 | £5,567 | £5,650 | |
| Cash from Receivables | £0 | £0 | £112 | £3,459 | £6,377 | £7,367 | £8,896 | £10,322 | £13,619 | £14,634 | £15,538 | £16,560 | |
| Subtotal Cash from Operations | £0 | £1,120 | £2,227 | £5,897 | £9,327 | £10,770 | £13,424 | £15,190 | £18,786 | £20,152 | £21,105 | £22,210 | |
| 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 | £0 | £1,120 | £2,227 | £5,897 | £9,327 | £10,770 | £13,424 | £15,190 | £18,786 | £20,152 | £21,105 | £22,210 | |
| 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 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | |
| Bill Payments | £143 | £4,280 | £4,364 | £4,435 | £4,456 | £4,490 | £4,522 | £4,604 | £4,624 | £4,642 | £4,663 | £4,660 | |
| Subtotal Spent on Operations | £14,923 | £19,060 | £19,144 | £19,215 | £19,236 | £19,270 | £19,302 | £19,384 | £19,404 | £19,422 | £19,443 | £19,440 | |
| 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 | £720 | £726 | £732 | £739 | £745 | £751 | £757 | £764 | £770 | £777 | £783 | £790 | |
| 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 | £15,643 | £19,787 | £19,876 | £19,954 | £19,980 | £20,021 | £20,059 | £20,147 | £20,174 | £20,199 | £20,226 | £20,230 | |
| Net Cash Flow | (£15,643) | (£18,667) | (£17,649) | (£14,057) | (£10,654) | (£9,252) | (£6,635) | (£4,958) | (£1,388) | (£46) | £879 | £1,980 | |
| Cash Balance | £85,557 | £66,890 | £49,241 | £35,184 | £24,530 | £15,279 | £8,644 | £3,686 | £2,298 | £2,252 | £3,131 | £5,111 | |
| 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 | £101,200 | £85,557 | £66,890 | £49,241 | £35,184 | £24,530 | £15,279 | £8,644 | £3,686 | £2,298 | £2,252 | £3,131 | £5,111 |
| Accounts Receivable | £0 | £0 | £3,359 | £9,592 | £13,448 | £15,922 | £18,765 | £23,453 | £27,736 | £29,620 | £31,542 | £32,703 | £33,092 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £101,200 | £85,557 | £70,249 | £58,832 | £48,632 | £40,453 | £34,043 | £32,097 | £31,422 | £31,918 | £33,794 | £35,834 | £38,203 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 |
| Accumulated Depreciation | £0 | £125 | £250 | £375 | £500 | £625 | £750 | £875 | £1,000 | £1,125 | £1,250 | £1,375 | £1,500 |
| Total Long-term Assets | £7,500 | £7,375 | £7,250 | £7,125 | £7,000 | £6,875 | £6,750 | £6,625 | £6,500 | £6,375 | £6,250 | £6,125 | £6,000 |
| Total Assets | £108,700 | £92,932 | £77,499 | £65,957 | £55,632 | £47,328 | £40,793 | £38,722 | £37,922 | £38,293 | £40,044 | £41,959 | £44,203 |
| 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 | £4,135 | £4,216 | £4,287 | £4,306 | £4,340 | £4,368 | £4,449 | £4,470 | £4,487 | £4,507 | £4,505 | £4,505 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £4,135 | £4,216 | £4,287 | £4,306 | £4,340 | £4,368 | £4,449 | £4,470 | £4,487 | £4,507 | £4,505 | £4,505 |
| Long-term Liabilities | £50,000 | £49,280 | £48,553 | £47,821 | £47,082 | £46,337 | £45,586 | £44,829 | £44,065 | £43,295 | £42,518 | £41,735 | £40,945 |
| Total Liabilities | £50,000 | £53,415 | £52,769 | £52,108 | £51,388 | £50,677 | £49,955 | £49,278 | £48,534 | £47,781 | £47,025 | £46,240 | £45,450 |
| Paid-in Capital | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 |
| Retained Earnings | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) |
| Earnings | £0 | (£19,183) | (£33,970) | (£44,851) | (£54,456) | (£62,049) | (£67,861) | (£69,256) | (£69,313) | (£68,188) | (£65,682) | (£62,981) | (£59,947) |
| Total Capital | £58,700 | £39,517 | £24,730 | £13,849 | £4,244 | (£3,349) | (£9,161) | (£10,556) | (£10,613) | (£9,488) | (£6,982) | (£4,281) | (£1,247) |
| Total Liabilities and Capital | £108,700 | £92,932 | £77,499 | £65,957 | £55,632 | £47,328 | £40,793 | £38,722 | £37,922 | £38,293 | £40,044 | £41,959 | £44,203 |
| Net Worth | £58,700 | £39,517 | £24,730 | £13,849 | £4,244 | (£3,349) | (£9,161) | (£10,556) | (£10,613) | (£9,488) | (£6,982) | (£4,281) | (£1,247) |
| 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 | |||||||||||||
| Law firms | 0% | £0 | £3,525 | £7,214 | £8,600 | £10,254 | £11,458 | £15,455 | £17,458 | £18,524 | £19,874 | £19,952 | £20,145 |
| Assorted customers | 0% | £0 | £954 | £1,245 | £1,154 | £1,547 | £2,154 | £2,658 | £2,014 | £2,147 | £2,200 | £2,314 | £2,454 |
| Total Sales | £0 | £4,479 | £8,459 | £9,754 | £11,801 | £13,612 | £18,113 | £19,472 | £20,671 | £22,074 | £22,266 | £22,599 | |
| 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 | |
| Law firms | £0 | £71 | £144 | £172 | £205 | £229 | £309 | £349 | £370 | £397 | £399 | £403 | |
| Assorted customers | £0 | £19 | £25 | £23 | £31 | £43 | £53 | £40 | £43 | £44 | £46 | £49 | |
| Subtotal Direct Cost of Sales | £0 | £90 | £169 | £195 | £236 | £272 | £362 | £389 | £413 | £441 | £445 | £452 | |
| 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 | ||
| Alwy Laate | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Dispatcher | 0% | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 |
| Messenger | 0% | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 |
| Messenger | 0% | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 |
| Messenger | 0% | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 |
| Messenger | 0% | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 |
| Messenger | 0% | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 |
| Messenger | 0% | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 |
| Messenger | 0% | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 | £1,440 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £0 | £4,479 | £8,459 | £9,754 | £11,801 | £13,612 | £18,113 | £19,472 | £20,671 | £22,074 | £22,266 | £22,599 | |
| Direct Cost of Sales | £0 | £90 | £169 | £195 | £236 | £272 | £362 | £389 | £413 | £441 | £445 | £452 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £90 | £169 | £195 | £236 | £272 | £362 | £389 | £413 | £441 | £445 | £452 | |
| Gross Margin | £0 | £4,389 | £8,290 | £9,559 | £11,565 | £13,340 | £17,751 | £19,083 | £20,258 | £21,633 | £21,821 | £22,147 | |
| Gross Margin % | 0.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | 98.00% | |
| Expenses | |||||||||||||
| Payroll | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | |
| Sales and Marketing and Other Expenses | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Depreciation | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Cellular service | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Utilities | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Rent | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Payroll Taxes | 15% | £2,217 | £2,217 | £2,217 | £2,217 | £2,217 | £2,217 | £2,217 | £2,217 | £2,217 | £2,217 | £2,217 | £2,217 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £18,772 | £18,772 | £18,772 | £18,772 | £18,772 | £18,772 | £18,772 | £18,772 | £18,772 | £18,772 | £18,772 | £18,772 | |
| Profit Before Interest and Taxes | (£18,772) | (£14,383) | (£10,482) | (£9,213) | (£7,207) | (£5,432) | (£1,021) | £311 | £1,486 | £2,861 | £3,049 | £3,375 | |
| EBITDA | (£18,647) | (£14,258) | (£10,357) | (£9,088) | (£7,082) | (£5,307) | (£896) | £436 | £1,611 | £2,986 | £3,174 | £3,500 | |
| Interest Expense | £411 | £405 | £399 | £392 | £386 | £380 | £374 | £367 | £361 | £354 | £348 | £341 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£19,183) | (£14,787) | (£10,881) | (£9,605) | (£7,593) | (£5,812) | (£1,395) | (£57) | £1,125 | £2,506 | £2,701 | £3,034 | |
| Net Profit/Sales | 0.00% | -330.14% | -128.63% | -98.48% | -64.34% | -42.70% | -7.70% | -0.29% | 5.44% | 11.35% | 12.13% | 13.42% | |
| 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 | £1,120 | £2,115 | £2,439 | £2,950 | £3,403 | £4,528 | £4,868 | £5,168 | £5,519 | £5,567 | £5,650 | |
| Cash from Receivables | £0 | £0 | £112 | £3,459 | £6,377 | £7,367 | £8,896 | £10,322 | £13,619 | £14,634 | £15,538 | £16,560 | |
| Subtotal Cash from Operations | £0 | £1,120 | £2,227 | £5,897 | £9,327 | £10,770 | £13,424 | £15,190 | £18,786 | £20,152 | £21,105 | £22,210 | |
| 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 | £0 | £1,120 | £2,227 | £5,897 | £9,327 | £10,770 | £13,424 | £15,190 | £18,786 | £20,152 | £21,105 | £22,210 | |
| 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 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | £14,780 | |
| Bill Payments | £143 | £4,280 | £4,364 | £4,435 | £4,456 | £4,490 | £4,522 | £4,604 | £4,624 | £4,642 | £4,663 | £4,660 | |
| Subtotal Spent on Operations | £14,923 | £19,060 | £19,144 | £19,215 | £19,236 | £19,270 | £19,302 | £19,384 | £19,404 | £19,422 | £19,443 | £19,440 | |
| 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 | £720 | £726 | £732 | £739 | £745 | £751 | £757 | £764 | £770 | £777 | £783 | £790 | |
| 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 | £15,643 | £19,787 | £19,876 | £19,954 | £19,980 | £20,021 | £20,059 | £20,147 | £20,174 | £20,199 | £20,226 | £20,230 | |
| Net Cash Flow | (£15,643) | (£18,667) | (£17,649) | (£14,057) | (£10,654) | (£9,252) | (£6,635) | (£4,958) | (£1,388) | (£46) | £879 | £1,980 | |
| Cash Balance | £85,557 | £66,890 | £49,241 | £35,184 | £24,530 | £15,279 | £8,644 | £3,686 | £2,298 | £2,252 | £3,131 | £5,111 | |
| 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 | £101,200 | £85,557 | £66,890 | £49,241 | £35,184 | £24,530 | £15,279 | £8,644 | £3,686 | £2,298 | £2,252 | £3,131 | £5,111 |
| Accounts Receivable | £0 | £0 | £3,359 | £9,592 | £13,448 | £15,922 | £18,765 | £23,453 | £27,736 | £29,620 | £31,542 | £32,703 | £33,092 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £101,200 | £85,557 | £70,249 | £58,832 | £48,632 | £40,453 | £34,043 | £32,097 | £31,422 | £31,918 | £33,794 | £35,834 | £38,203 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 |
| Accumulated Depreciation | £0 | £125 | £250 | £375 | £500 | £625 | £750 | £875 | £1,000 | £1,125 | £1,250 | £1,375 | £1,500 |
| Total Long-term Assets | £7,500 | £7,375 | £7,250 | £7,125 | £7,000 | £6,875 | £6,750 | £6,625 | £6,500 | £6,375 | £6,250 | £6,125 | £6,000 |
| Total Assets | £108,700 | £92,932 | £77,499 | £65,957 | £55,632 | £47,328 | £40,793 | £38,722 | £37,922 | £38,293 | £40,044 | £41,959 | £44,203 |
| 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 | £4,135 | £4,216 | £4,287 | £4,306 | £4,340 | £4,368 | £4,449 | £4,470 | £4,487 | £4,507 | £4,505 | £4,505 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £4,135 | £4,216 | £4,287 | £4,306 | £4,340 | £4,368 | £4,449 | £4,470 | £4,487 | £4,507 | £4,505 | £4,505 |
| Long-term Liabilities | £50,000 | £49,280 | £48,553 | £47,821 | £47,082 | £46,337 | £45,586 | £44,829 | £44,065 | £43,295 | £42,518 | £41,735 | £40,945 |
| Total Liabilities | £50,000 | £53,415 | £52,769 | £52,108 | £51,388 | £50,677 | £49,955 | £49,278 | £48,534 | £47,781 | £47,025 | £46,240 | £45,450 |
| Paid-in Capital | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 |
| Retained Earnings | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) |
| Earnings | £0 | (£19,183) | (£33,970) | (£44,851) | (£54,456) | (£62,049) | (£67,861) | (£69,256) | (£69,313) | (£68,188) | (£65,682) | (£62,981) | (£59,947) |
| Total Capital | £58,700 | £39,517 | £24,730 | £13,849 | £4,244 | (£3,349) | (£9,161) | (£10,556) | (£10,613) | (£9,488) | (£6,982) | (£4,281) | (£1,247) |
| Total Liabilities and Capital | £108,700 | £92,932 | £77,499 | £65,957 | £55,632 | £47,328 | £40,793 | £38,722 | £37,922 | £38,293 | £40,044 | £41,959 | £44,203 |
| Net Worth | £58,700 | £39,517 | £24,730 | £13,849 | £4,244 | (£3,349) | (£9,161) | (£10,556) | (£10,613) | (£9,488) | (£6,982) | (£4,281) | (£1,247) |