| 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 | |||||||||||||
| Dry Cleaning | 0% | £4,176 | £5,364 | £6,156 | £8,280 | £9,216 | £9,720 | £10,728 | £11,520 | £12,456 | £12,924 | £13,212 | £13,140 |
| Laundry | 0% | £6,612 | £8,493 | £9,747 | £13,110 | £14,592 | £15,390 | £16,986 | £18,240 | £19,722 | £20,463 | £20,919 | £20,805 |
| Alteration Services | 0% | £812 | £1,043 | £1,197 | £1,610 | £1,792 | £1,890 | £2,086 | £2,240 | £2,422 | £2,513 | £2,569 | £2,555 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £11,600 | £14,900 | £17,100 | £23,000 | £25,600 | £27,000 | £29,800 | £32,000 | £34,600 | £35,900 | £36,700 | £36,500 | |
| 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 | |
| Dry Cleaning | 12% | £501 | £644 | £739 | £994 | £1,106 | £1,166 | £1,287 | £1,382 | £1,495 | £1,551 | £1,585 | £1,577 |
| Laundry | 8% | £529 | £679 | £780 | £1,049 | £1,167 | £1,231 | £1,359 | £1,459 | £1,578 | £1,637 | £1,674 | £1,664 |
| Alteration Services | 30% | £244 | £313 | £359 | £483 | £538 | £567 | £626 | £672 | £727 | £754 | £771 | £767 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £1,274 | £1,636 | £1,878 | £2,525 | £2,811 | £2,965 | £3,272 | £3,514 | £3,799 | £3,942 | £4,030 | £4,008 | |
| 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 | ||
| Director/Accountant | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Laundry expert | 0% | £2,080 | £2,080 | £2,080 | £2,080 | £2,080 | £2,080 | £2,080 | £2,080 | £2,080 | £2,080 | £2,080 | £2,080 |
| Worker-1 | 0% | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 |
| Worker-2 | 0% | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 |
| Worker-3 | 0% | £0 | £0 | £0 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 |
| Driver-1 | 0% | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 |
| Driver-2 | 0% | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 |
| Driver-3 | 0% | £0 | £0 | £0 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 6 | 6 | 6 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
| Total Payroll | £8,680 | £8,680 | £8,680 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | |
| 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 | £11,600 | £14,900 | £17,100 | £23,000 | £25,600 | £27,000 | £29,800 | £32,000 | £34,600 | £35,900 | £36,700 | £36,500 | |
| Direct Cost of Sales | £1,274 | £1,636 | £1,878 | £2,525 | £2,811 | £2,965 | £3,272 | £3,514 | £3,799 | £3,942 | £4,030 | £4,008 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £1,274 | £1,636 | £1,878 | £2,525 | £2,811 | £2,965 | £3,272 | £3,514 | £3,799 | £3,942 | £4,030 | £4,008 | |
| Gross Margin | £10,326 | £13,264 | £15,222 | £20,475 | £22,789 | £24,035 | £26,528 | £28,486 | £30,801 | £31,958 | £32,670 | £32,492 | |
| Gross Margin % | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | |
| Expenses | |||||||||||||
| Payroll | £8,680 | £8,680 | £8,680 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | |
| Marketing/Promotion | £150 | £150 | £150 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Depreciation | £250 | £250 | £250 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | |
| Rent | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Utilities | £700 | £700 | £700 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Telecommunications | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Insurance | £700 | £700 | £700 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Maintenance | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Gas | £250 | £250 | £250 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Equipment lease | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | |
| Office cleaning | 15% | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 |
| Other | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Total Operating Expenses | £15,397 | £15,397 | £15,397 | £17,663 | £17,663 | £17,663 | £17,663 | £17,663 | £17,663 | £17,663 | £17,663 | £17,663 | |
| Profit Before Interest and Taxes | (£5,070) | (£2,133) | (£174) | £2,811 | £5,126 | £6,372 | £8,865 | £10,823 | £13,138 | £14,295 | £15,007 | £14,829 | |
| EBITDA | (£4,820) | (£1,883) | £76 | £3,228 | £5,542 | £6,789 | £9,281 | £11,240 | £13,554 | £14,712 | £15,424 | £15,246 | |
| Interest Expense | £164 | £164 | £164 | £164 | £164 | £164 | £164 | £164 | £164 | £164 | £164 | £164 | |
| Taxes Incurred | (£1,570) | (£689) | (£101) | £794 | £1,489 | £1,862 | £2,610 | £3,198 | £3,892 | £4,239 | £4,453 | £4,400 | |
| Net Profit | (£3,664) | (£1,608) | (£237) | £1,853 | £3,473 | £4,346 | £6,091 | £7,461 | £9,082 | £9,892 | £10,390 | £10,266 | |
| Net Profit/Sales | -31.59% | -10.79% | -1.38% | 8.06% | 13.57% | 16.10% | 20.44% | 23.32% | 26.25% | 27.55% | 28.31% | 28.12% | |
| 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 | £11,600 | £14,900 | £17,100 | £23,000 | £25,600 | £27,000 | £29,800 | £32,000 | £34,600 | £35,900 | £36,700 | £36,500 | |
| Subtotal Cash from Operations | £11,600 | £14,900 | £17,100 | £23,000 | £25,600 | £27,000 | £29,800 | £32,000 | £34,600 | £35,900 | £36,700 | £36,500 | |
| 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 | £11,600 | £14,900 | £17,100 | £23,000 | £25,600 | £27,000 | £29,800 | £32,000 | £34,600 | £35,900 | £36,700 | £36,500 | |
| 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 | £8,680 | £8,680 | £8,680 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | |
| Bill Payments | £202 | £6,108 | £7,526 | £8,740 | £11,419 | £12,029 | £12,452 | £13,646 | £14,418 | £15,419 | £15,763 | £15,995 | |
| Subtotal Spent on Operations | £8,882 | £14,788 | £16,206 | £18,720 | £21,399 | £22,009 | £22,432 | £23,626 | £24,398 | £25,399 | £25,743 | £25,975 | |
| 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 | £334 | £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 | £10,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £9,216 | £14,788 | £16,206 | £28,720 | £21,399 | £22,009 | £22,432 | £23,626 | £24,398 | £25,399 | £25,743 | £25,975 | |
| Net Cash Flow | £2,384 | £112 | £894 | (£5,720) | £4,201 | £4,991 | £7,368 | £8,374 | £10,202 | £10,501 | £10,957 | £10,525 | |
| Cash Balance | £22,384 | £22,496 | £23,390 | £17,671 | £21,872 | £26,863 | £34,232 | £42,606 | £52,808 | £63,310 | £74,267 | £84,792 | |
| 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 | £20,000 | £22,384 | £22,496 | £23,390 | £17,671 | £21,872 | £26,863 | £34,232 | £42,606 | £52,808 | £63,310 | £74,267 | £84,792 |
| Inventory | £2,000 | £1,726 | £1,636 | £1,878 | £2,525 | £2,811 | £2,965 | £3,272 | £3,514 | £3,799 | £3,942 | £4,030 | £4,008 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £22,000 | £24,111 | £24,132 | £25,268 | £20,196 | £24,683 | £29,828 | £37,504 | £46,120 | £56,607 | £67,251 | £78,297 | £88,800 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £15,000 | £15,000 | £15,000 | £15,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 |
| Accumulated Depreciation | £0 | £250 | £500 | £750 | £1,167 | £1,583 | £2,000 | £2,417 | £2,833 | £3,250 | £3,667 | £4,083 | £4,500 |
| Total Long-term Assets | £15,000 | £14,750 | £14,500 | £14,250 | £23,833 | £23,417 | £23,000 | £22,583 | £22,167 | £21,750 | £21,333 | £20,917 | £20,500 |
| Total Assets | £37,000 | £38,861 | £38,632 | £39,518 | £44,029 | £48,100 | £52,828 | £60,087 | £68,286 | £78,357 | £88,585 | £99,213 | £109,300 |
| 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 | £5,858 | £7,238 | £8,360 | £11,018 | £11,615 | £11,998 | £13,166 | £13,904 | £14,894 | £15,229 | £15,468 | £15,289 |
| 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 | £5,858 | £7,238 | £8,360 | £11,018 | £11,615 | £11,998 | £13,166 | £13,904 | £14,894 | £15,229 | £15,468 | £15,289 |
| Long-term Liabilities | £20,000 | £19,666 | £19,666 | £19,666 | £19,666 | £19,666 | £19,666 | £19,666 | £19,666 | £19,666 | £19,666 | £19,666 | £19,666 |
| Total Liabilities | £20,000 | £25,524 | £26,904 | £28,026 | £30,684 | £31,281 | £31,664 | £32,832 | £33,570 | £34,560 | £34,895 | £35,134 | £34,955 |
| Paid-in Capital | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 |
| Retained Earnings | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) |
| Earnings | £0 | (£3,664) | (£5,272) | (£5,508) | (£3,655) | (£182) | £4,164 | £10,254 | £17,716 | £26,798 | £36,689 | £47,079 | £57,345 |
| Total Capital | £17,000 | £13,336 | £11,729 | £11,492 | £13,345 | £16,819 | £21,164 | £27,255 | £34,716 | £43,798 | £53,690 | £64,080 | £74,345 |
| Total Liabilities and Capital | £37,000 | £38,861 | £38,632 | £39,518 | £44,029 | £48,100 | £52,828 | £60,087 | £68,286 | £78,357 | £88,585 | £99,213 | £109,300 |
| Net Worth | £17,000 | £13,336 | £11,729 | £11,492 | £13,345 | £16,819 | £21,164 | £27,255 | £34,716 | £43,798 | £53,690 | £64,080 | £74,345 |
| 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 | |||||||||||||
| Dry Cleaning | 0% | £4,176 | £5,364 | £6,156 | £8,280 | £9,216 | £9,720 | £10,728 | £11,520 | £12,456 | £12,924 | £13,212 | £13,140 |
| Laundry | 0% | £6,612 | £8,493 | £9,747 | £13,110 | £14,592 | £15,390 | £16,986 | £18,240 | £19,722 | £20,463 | £20,919 | £20,805 |
| Alteration Services | 0% | £812 | £1,043 | £1,197 | £1,610 | £1,792 | £1,890 | £2,086 | £2,240 | £2,422 | £2,513 | £2,569 | £2,555 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £11,600 | £14,900 | £17,100 | £23,000 | £25,600 | £27,000 | £29,800 | £32,000 | £34,600 | £35,900 | £36,700 | £36,500 | |
| 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 | |
| Dry Cleaning | 12% | £501 | £644 | £739 | £994 | £1,106 | £1,166 | £1,287 | £1,382 | £1,495 | £1,551 | £1,585 | £1,577 |
| Laundry | 8% | £529 | £679 | £780 | £1,049 | £1,167 | £1,231 | £1,359 | £1,459 | £1,578 | £1,637 | £1,674 | £1,664 |
| Alteration Services | 30% | £244 | £313 | £359 | £483 | £538 | £567 | £626 | £672 | £727 | £754 | £771 | £767 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £1,274 | £1,636 | £1,878 | £2,525 | £2,811 | £2,965 | £3,272 | £3,514 | £3,799 | £3,942 | £4,030 | £4,008 | |
| 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 | ||
| Director/Accountant | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Laundry expert | 0% | £2,080 | £2,080 | £2,080 | £2,080 | £2,080 | £2,080 | £2,080 | £2,080 | £2,080 | £2,080 | £2,080 | £2,080 |
| Worker-1 | 0% | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 |
| Worker-2 | 0% | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 |
| Worker-3 | 0% | £0 | £0 | £0 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 | £936 |
| Driver-1 | 0% | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 |
| Driver-2 | 0% | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 |
| Driver-3 | 0% | £0 | £0 | £0 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 | £364 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 6 | 6 | 6 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
| Total Payroll | £8,680 | £8,680 | £8,680 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | |
| 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 | £11,600 | £14,900 | £17,100 | £23,000 | £25,600 | £27,000 | £29,800 | £32,000 | £34,600 | £35,900 | £36,700 | £36,500 | |
| Direct Cost of Sales | £1,274 | £1,636 | £1,878 | £2,525 | £2,811 | £2,965 | £3,272 | £3,514 | £3,799 | £3,942 | £4,030 | £4,008 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £1,274 | £1,636 | £1,878 | £2,525 | £2,811 | £2,965 | £3,272 | £3,514 | £3,799 | £3,942 | £4,030 | £4,008 | |
| Gross Margin | £10,326 | £13,264 | £15,222 | £20,475 | £22,789 | £24,035 | £26,528 | £28,486 | £30,801 | £31,958 | £32,670 | £32,492 | |
| Gross Margin % | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | |
| Expenses | |||||||||||||
| Payroll | £8,680 | £8,680 | £8,680 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | |
| Marketing/Promotion | £150 | £150 | £150 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Depreciation | £250 | £250 | £250 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | |
| Rent | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Utilities | £700 | £700 | £700 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Telecommunications | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Insurance | £700 | £700 | £700 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Maintenance | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Gas | £250 | £250 | £250 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Equipment lease | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | |
| Office cleaning | 15% | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 |
| Other | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Total Operating Expenses | £15,397 | £15,397 | £15,397 | £17,663 | £17,663 | £17,663 | £17,663 | £17,663 | £17,663 | £17,663 | £17,663 | £17,663 | |
| Profit Before Interest and Taxes | (£5,070) | (£2,133) | (£174) | £2,811 | £5,126 | £6,372 | £8,865 | £10,823 | £13,138 | £14,295 | £15,007 | £14,829 | |
| EBITDA | (£4,820) | (£1,883) | £76 | £3,228 | £5,542 | £6,789 | £9,281 | £11,240 | £13,554 | £14,712 | £15,424 | £15,246 | |
| Interest Expense | £164 | £164 | £164 | £164 | £164 | £164 | £164 | £164 | £164 | £164 | £164 | £164 | |
| Taxes Incurred | (£1,570) | (£689) | (£101) | £794 | £1,489 | £1,862 | £2,610 | £3,198 | £3,892 | £4,239 | £4,453 | £4,400 | |
| Net Profit | (£3,664) | (£1,608) | (£237) | £1,853 | £3,473 | £4,346 | £6,091 | £7,461 | £9,082 | £9,892 | £10,390 | £10,266 | |
| Net Profit/Sales | -31.59% | -10.79% | -1.38% | 8.06% | 13.57% | 16.10% | 20.44% | 23.32% | 26.25% | 27.55% | 28.31% | 28.12% | |
| 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 | £11,600 | £14,900 | £17,100 | £23,000 | £25,600 | £27,000 | £29,800 | £32,000 | £34,600 | £35,900 | £36,700 | £36,500 | |
| Subtotal Cash from Operations | £11,600 | £14,900 | £17,100 | £23,000 | £25,600 | £27,000 | £29,800 | £32,000 | £34,600 | £35,900 | £36,700 | £36,500 | |
| 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 | £11,600 | £14,900 | £17,100 | £23,000 | £25,600 | £27,000 | £29,800 | £32,000 | £34,600 | £35,900 | £36,700 | £36,500 | |
| 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 | £8,680 | £8,680 | £8,680 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | £9,980 | |
| Bill Payments | £202 | £6,108 | £7,526 | £8,740 | £11,419 | £12,029 | £12,452 | £13,646 | £14,418 | £15,419 | £15,763 | £15,995 | |
| Subtotal Spent on Operations | £8,882 | £14,788 | £16,206 | £18,720 | £21,399 | £22,009 | £22,432 | £23,626 | £24,398 | £25,399 | £25,743 | £25,975 | |
| 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 | £334 | £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 | £10,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £9,216 | £14,788 | £16,206 | £28,720 | £21,399 | £22,009 | £22,432 | £23,626 | £24,398 | £25,399 | £25,743 | £25,975 | |
| Net Cash Flow | £2,384 | £112 | £894 | (£5,720) | £4,201 | £4,991 | £7,368 | £8,374 | £10,202 | £10,501 | £10,957 | £10,525 | |
| Cash Balance | £22,384 | £22,496 | £23,390 | £17,671 | £21,872 | £26,863 | £34,232 | £42,606 | £52,808 | £63,310 | £74,267 | £84,792 | |
| 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 | £20,000 | £22,384 | £22,496 | £23,390 | £17,671 | £21,872 | £26,863 | £34,232 | £42,606 | £52,808 | £63,310 | £74,267 | £84,792 |
| Inventory | £2,000 | £1,726 | £1,636 | £1,878 | £2,525 | £2,811 | £2,965 | £3,272 | £3,514 | £3,799 | £3,942 | £4,030 | £4,008 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £22,000 | £24,111 | £24,132 | £25,268 | £20,196 | £24,683 | £29,828 | £37,504 | £46,120 | £56,607 | £67,251 | £78,297 | £88,800 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £15,000 | £15,000 | £15,000 | £15,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 |
| Accumulated Depreciation | £0 | £250 | £500 | £750 | £1,167 | £1,583 | £2,000 | £2,417 | £2,833 | £3,250 | £3,667 | £4,083 | £4,500 |
| Total Long-term Assets | £15,000 | £14,750 | £14,500 | £14,250 | £23,833 | £23,417 | £23,000 | £22,583 | £22,167 | £21,750 | £21,333 | £20,917 | £20,500 |
| Total Assets | £37,000 | £38,861 | £38,632 | £39,518 | £44,029 | £48,100 | £52,828 | £60,087 | £68,286 | £78,357 | £88,585 | £99,213 | £109,300 |
| 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 | £5,858 | £7,238 | £8,360 | £11,018 | £11,615 | £11,998 | £13,166 | £13,904 | £14,894 | £15,229 | £15,468 | £15,289 |
| 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 | £5,858 | £7,238 | £8,360 | £11,018 | £11,615 | £11,998 | £13,166 | £13,904 | £14,894 | £15,229 | £15,468 | £15,289 |
| Long-term Liabilities | £20,000 | £19,666 | £19,666 | £19,666 | £19,666 | £19,666 | £19,666 | £19,666 | £19,666 | £19,666 | £19,666 | £19,666 | £19,666 |
| Total Liabilities | £20,000 | £25,524 | £26,904 | £28,026 | £30,684 | £31,281 | £31,664 | £32,832 | £33,570 | £34,560 | £34,895 | £35,134 | £34,955 |
| Paid-in Capital | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 |
| Retained Earnings | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) | (£23,000) |
| Earnings | £0 | (£3,664) | (£5,272) | (£5,508) | (£3,655) | (£182) | £4,164 | £10,254 | £17,716 | £26,798 | £36,689 | £47,079 | £57,345 |
| Total Capital | £17,000 | £13,336 | £11,729 | £11,492 | £13,345 | £16,819 | £21,164 | £27,255 | £34,716 | £43,798 | £53,690 | £64,080 | £74,345 |
| Total Liabilities and Capital | £37,000 | £38,861 | £38,632 | £39,518 | £44,029 | £48,100 | £52,828 | £60,087 | £68,286 | £78,357 | £88,585 | £99,213 | £109,300 |
| Net Worth | £17,000 | £13,336 | £11,729 | £11,492 | £13,345 | £16,819 | £21,164 | £27,255 | £34,716 | £43,798 | £53,690 | £64,080 | £74,345 |