| 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 | |||||||||||||
| Hardware Products | £3,000 | £3,900 | £5,070 | £6,591 | £8,568 | £11,138 | £14,479 | £18,823 | £24,470 | £31,811 | £41,354 | £53,760 | |
| Key Services | £300 | £390 | £507 | £659 | £857 | £1,114 | £1,448 | £1,882 | £2,447 | £3,181 | £4,135 | £5,376 | |
| Repair Services | £500 | £650 | £845 | £1,098 | £1,427 | £1,855 | £2,412 | £3,136 | £4,077 | £5,300 | £6,890 | £8,957 | |
| Installation Services | £1,500 | £1,950 | £2,535 | £3,296 | £4,285 | £5,570 | £7,241 | £9,413 | £12,237 | £15,908 | £20,680 | £26,884 | |
| Emergency Services | £400 | £520 | £676 | £879 | £1,143 | £1,486 | £1,932 | £2,512 | £3,266 | £4,246 | £5,520 | £7,176 | |
| Referral Commissions | £1,000 | £1,300 | £1,690 | £2,197 | £2,856 | £3,713 | £4,827 | £6,275 | £8,158 | £10,605 | £13,786 | £17,922 | |
| Total Sales | £6,700 | £8,710 | £11,323 | £14,720 | £19,136 | £24,876 | £32,339 | £42,041 | £54,655 | £71,051 | £92,365 | £120,075 | |
| 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 | |
| Hardware Cost | £1,800 | £2,340 | £3,042 | £3,955 | £5,141 | £6,683 | £8,687 | £11,294 | £14,682 | £19,087 | £24,812 | £32,256 | |
| Services Cost | £540 | £702 | £913 | £1,186 | £1,542 | £2,005 | £2,607 | £3,389 | £4,405 | £5,727 | £7,445 | £9,679 | |
| Subtotal Direct Cost of Sales | £2,340 | £3,042 | £3,955 | £5,141 | £6,683 | £8,688 | £11,294 | £14,682 | £19,087 | £24,814 | £32,257 | £41,935 | |
| 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 | ||
| Owner | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,000 | £6,000 | |
| Assistant Store Manager | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Store Staff | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Assistant Locksmith | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £9,000 | £10,000 | |
| 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 | £6,700 | £8,710 | £11,323 | £14,720 | £19,136 | £24,876 | £32,339 | £42,041 | £54,655 | £71,051 | £92,365 | £120,075 | |
| Direct Cost of Sales | £2,340 | £3,042 | £3,955 | £5,141 | £6,683 | £8,688 | £11,294 | £14,682 | £19,087 | £24,814 | £32,257 | £41,935 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £2,340 | £3,042 | £3,955 | £5,141 | £6,683 | £8,688 | £11,294 | £14,682 | £19,087 | £24,814 | £32,257 | £41,935 | |
| Gross Margin | £4,360 | £5,668 | £7,368 | £9,579 | £12,453 | £16,188 | £21,045 | £27,359 | £35,568 | £46,237 | £60,108 | £78,140 | |
| Gross Margin % | 65.07% | 65.07% | 65.07% | 65.07% | 65.08% | 65.08% | 65.08% | 65.08% | 65.08% | 65.08% | 65.08% | 65.08% | |
| Expenses | |||||||||||||
| Payroll | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £9,000 | £10,000 | |
| Marketing/Promotion | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Depreciation | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,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 | |
| Utilities | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Insurance & Bonding | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Payroll Taxes | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Store Supplies | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Van Fuel, Maintenance & Parking | 15.00% | £300 | £350 | £400 | £450 | £475 | £500 | £500 | £500 | £500 | £525 | £525 | £525 |
| Training and Education | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Total Operating Expenses | £16,300 | £16,350 | £16,400 | £16,450 | £16,475 | £16,500 | £16,500 | £16,500 | £16,500 | £16,525 | £17,525 | £18,525 | |
| Profit Before Interest and Taxes | (£11,940) | (£10,682) | (£9,032) | (£6,871) | (£4,022) | (£312) | £4,545 | £10,859 | £19,068 | £29,712 | £42,583 | £59,615 | |
| EBITDA | (£10,440) | (£9,182) | (£7,532) | (£5,371) | (£2,522) | £1,188 | £6,045 | £12,359 | £20,568 | £31,212 | £44,083 | £61,115 | |
| Interest Expense | £699 | £690 | £681 | £672 | £656 | £641 | £619 | £598 | £576 | £542 | £508 | £473 | |
| Taxes Incurred | (£3,792) | (£3,412) | (£2,914) | (£2,263) | (£1,404) | (£286) | £1,178 | £3,078 | £5,548 | £8,751 | £12,623 | £17,743 | |
| Net Profit | (£8,847) | (£7,960) | (£6,799) | (£5,280) | (£3,275) | (£667) | £2,748 | £7,183 | £12,944 | £20,420 | £29,453 | £41,399 | |
| Net Profit/Sales | -132.05% | -91.39% | -60.04% | -35.87% | -17.11% | -2.68% | 8.50% | 17.09% | 23.68% | 28.74% | 31.89% | 34.48% | |
| 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 | £5,025 | £6,533 | £8,492 | £11,040 | £14,352 | £18,657 | £24,254 | £31,531 | £40,991 | £53,288 | £69,274 | £90,056 | |
| Cash from Receivables | £0 | £893 | £1,943 | £2,526 | £3,284 | £4,269 | £5,549 | £7,214 | £9,378 | £12,192 | £15,850 | £20,605 | |
| Subtotal Cash from Operations | £5,025 | £7,426 | £10,435 | £13,566 | £17,636 | £22,926 | £29,804 | £38,745 | £50,370 | £65,480 | £85,124 | £110,661 | |
| 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 | £5,025 | £7,426 | £10,435 | £13,566 | £17,636 | £22,926 | £29,804 | £38,745 | £50,370 | £65,480 | £85,124 | £110,661 | |
| 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,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £9,000 | £10,000 | |
| Bill Payments | £20,124 | £3,721 | £4,146 | £4,690 | £5,388 | £6,506 | £14,937 | £25,531 | £32,431 | £41,406 | £53,074 | £67,941 | |
| Subtotal Spent on Operations | £28,124 | £11,721 | £12,146 | £12,690 | £13,388 | £14,506 | £22,937 | £33,531 | £40,431 | £49,406 | £62,074 | £77,941 | |
| 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 | £500 | £500 | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £2,000 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | |
| Purchase Other Current Assets | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £29,724 | £13,321 | £13,746 | £14,290 | £15,488 | £16,606 | £26,037 | £36,631 | £43,531 | £53,506 | £66,174 | £82,041 | |
| Net Cash Flow | (£24,699) | (£5,896) | (£3,311) | (£724) | £2,148 | £6,320 | £3,767 | £2,114 | £6,838 | £11,974 | £18,949 | £28,620 | |
| Cash Balance | £19,551 | £13,656 | £10,345 | £9,620 | £11,768 | £18,088 | £21,855 | £23,969 | £30,807 | £42,781 | £61,730 | £90,350 | |
| 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 | £44,250 | £19,551 | £13,656 | £10,345 | £9,620 | £11,768 | £18,088 | £21,855 | £23,969 | £30,807 | £42,781 | £61,730 | £90,350 |
| Accounts Receivable | £0 | £1,675 | £2,959 | £3,847 | £5,001 | £6,501 | £8,452 | £10,987 | £14,283 | £18,569 | £24,139 | £31,381 | £40,795 |
| Inventory | £40,000 | £37,660 | £34,618 | £30,663 | £25,522 | £18,839 | £17,376 | £22,588 | £29,365 | £38,175 | £49,627 | £64,515 | £83,869 |
| Other Current Assets | £20,000 | £20,500 | £21,000 | £21,500 | £22,000 | £22,500 | £23,000 | £23,500 | £24,000 | £24,500 | £25,000 | £25,500 | £26,000 |
| Total Current Assets | £104,250 | £79,386 | £72,233 | £66,355 | £62,144 | £59,609 | £66,915 | £78,930 | £91,617 | £112,050 | £141,548 | £183,126 | £241,014 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,500 | £41,000 | £41,500 | £42,000 | £42,500 | £43,000 |
| Accumulated Depreciation | £0 | £1,500 | £3,000 | £4,500 | £6,000 | £7,500 | £9,000 | £10,500 | £12,000 | £13,500 | £15,000 | £16,500 | £18,000 |
| Total Long-term Assets | £40,000 | £38,500 | £37,000 | £35,500 | £34,000 | £32,500 | £31,000 | £30,000 | £29,000 | £28,000 | £27,000 | £26,000 | £25,000 |
| Total Assets | £144,250 | £117,886 | £109,233 | £101,855 | £96,144 | £92,109 | £97,915 | £108,930 | £120,617 | £140,050 | £168,548 | £209,126 | £266,014 |
| 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 | £20,000 | £3,584 | £3,991 | £4,512 | £5,180 | £6,020 | £14,093 | £24,460 | £31,064 | £39,653 | £50,831 | £65,057 | £83,646 |
| Current Borrowing | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £9,500 | £9,000 | £8,000 | £7,000 | £6,000 | £4,000 | £2,000 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £30,000 | £13,584 | £13,991 | £14,512 | £15,180 | £15,520 | £23,093 | £32,460 | £38,064 | £45,653 | £54,831 | £67,057 | £83,646 |
| Long-term Liabilities | £70,000 | £68,900 | £67,800 | £66,700 | £65,600 | £64,500 | £63,400 | £62,300 | £61,200 | £60,100 | £59,000 | £57,900 | £56,800 |
| Total Liabilities | £100,000 | £82,484 | £81,791 | £81,212 | £80,780 | £80,020 | £86,493 | £94,760 | £99,264 | £105,753 | £113,831 | £124,957 | £140,446 |
| Paid-in Capital | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 |
| Retained Earnings | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) |
| Earnings | £0 | (£8,847) | (£16,808) | (£23,607) | (£28,886) | (£32,161) | (£32,828) | (£30,080) | (£22,897) | (£9,953) | £10,466 | £39,919 | £81,318 |
| Total Capital | £44,250 | £35,403 | £27,442 | £20,643 | £15,364 | £12,089 | £11,422 | £14,170 | £21,353 | £34,297 | £54,716 | £84,169 | £125,568 |
| Total Liabilities and Capital | £144,250 | £117,886 | £109,233 | £101,855 | £96,144 | £92,109 | £97,915 | £108,930 | £120,617 | £140,050 | £168,548 | £209,126 | £266,014 |
| Net Worth | £44,250 | £35,403 | £27,442 | £20,643 | £15,364 | £12,089 | £11,422 | £14,170 | £21,353 | £34,297 | £54,716 | £84,169 | £125,568 |
| 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 | |||||||||||||
| Hardware Products | £3,000 | £3,900 | £5,070 | £6,591 | £8,568 | £11,138 | £14,479 | £18,823 | £24,470 | £31,811 | £41,354 | £53,760 | |
| Key Services | £300 | £390 | £507 | £659 | £857 | £1,114 | £1,448 | £1,882 | £2,447 | £3,181 | £4,135 | £5,376 | |
| Repair Services | £500 | £650 | £845 | £1,098 | £1,427 | £1,855 | £2,412 | £3,136 | £4,077 | £5,300 | £6,890 | £8,957 | |
| Installation Services | £1,500 | £1,950 | £2,535 | £3,296 | £4,285 | £5,570 | £7,241 | £9,413 | £12,237 | £15,908 | £20,680 | £26,884 | |
| Emergency Services | £400 | £520 | £676 | £879 | £1,143 | £1,486 | £1,932 | £2,512 | £3,266 | £4,246 | £5,520 | £7,176 | |
| Referral Commissions | £1,000 | £1,300 | £1,690 | £2,197 | £2,856 | £3,713 | £4,827 | £6,275 | £8,158 | £10,605 | £13,786 | £17,922 | |
| Total Sales | £6,700 | £8,710 | £11,323 | £14,720 | £19,136 | £24,876 | £32,339 | £42,041 | £54,655 | £71,051 | £92,365 | £120,075 | |
| 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 | |
| Hardware Cost | £1,800 | £2,340 | £3,042 | £3,955 | £5,141 | £6,683 | £8,687 | £11,294 | £14,682 | £19,087 | £24,812 | £32,256 | |
| Services Cost | £540 | £702 | £913 | £1,186 | £1,542 | £2,005 | £2,607 | £3,389 | £4,405 | £5,727 | £7,445 | £9,679 | |
| Subtotal Direct Cost of Sales | £2,340 | £3,042 | £3,955 | £5,141 | £6,683 | £8,688 | £11,294 | £14,682 | £19,087 | £24,814 | £32,257 | £41,935 | |
| 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 | ||
| Owner | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,000 | £6,000 | |
| Assistant Store Manager | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Store Staff | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Assistant Locksmith | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £9,000 | £10,000 | |
| 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 | £6,700 | £8,710 | £11,323 | £14,720 | £19,136 | £24,876 | £32,339 | £42,041 | £54,655 | £71,051 | £92,365 | £120,075 | |
| Direct Cost of Sales | £2,340 | £3,042 | £3,955 | £5,141 | £6,683 | £8,688 | £11,294 | £14,682 | £19,087 | £24,814 | £32,257 | £41,935 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £2,340 | £3,042 | £3,955 | £5,141 | £6,683 | £8,688 | £11,294 | £14,682 | £19,087 | £24,814 | £32,257 | £41,935 | |
| Gross Margin | £4,360 | £5,668 | £7,368 | £9,579 | £12,453 | £16,188 | £21,045 | £27,359 | £35,568 | £46,237 | £60,108 | £78,140 | |
| Gross Margin % | 65.07% | 65.07% | 65.07% | 65.07% | 65.08% | 65.08% | 65.08% | 65.08% | 65.08% | 65.08% | 65.08% | 65.08% | |
| Expenses | |||||||||||||
| Payroll | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £9,000 | £10,000 | |
| Marketing/Promotion | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Depreciation | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,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 | |
| Utilities | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Insurance & Bonding | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Payroll Taxes | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Store Supplies | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Van Fuel, Maintenance & Parking | 15.00% | £300 | £350 | £400 | £450 | £475 | £500 | £500 | £500 | £500 | £525 | £525 | £525 |
| Training and Education | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Total Operating Expenses | £16,300 | £16,350 | £16,400 | £16,450 | £16,475 | £16,500 | £16,500 | £16,500 | £16,500 | £16,525 | £17,525 | £18,525 | |
| Profit Before Interest and Taxes | (£11,940) | (£10,682) | (£9,032) | (£6,871) | (£4,022) | (£312) | £4,545 | £10,859 | £19,068 | £29,712 | £42,583 | £59,615 | |
| EBITDA | (£10,440) | (£9,182) | (£7,532) | (£5,371) | (£2,522) | £1,188 | £6,045 | £12,359 | £20,568 | £31,212 | £44,083 | £61,115 | |
| Interest Expense | £699 | £690 | £681 | £672 | £656 | £641 | £619 | £598 | £576 | £542 | £508 | £473 | |
| Taxes Incurred | (£3,792) | (£3,412) | (£2,914) | (£2,263) | (£1,404) | (£286) | £1,178 | £3,078 | £5,548 | £8,751 | £12,623 | £17,743 | |
| Net Profit | (£8,847) | (£7,960) | (£6,799) | (£5,280) | (£3,275) | (£667) | £2,748 | £7,183 | £12,944 | £20,420 | £29,453 | £41,399 | |
| Net Profit/Sales | -132.05% | -91.39% | -60.04% | -35.87% | -17.11% | -2.68% | 8.50% | 17.09% | 23.68% | 28.74% | 31.89% | 34.48% | |
| 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 | £5,025 | £6,533 | £8,492 | £11,040 | £14,352 | £18,657 | £24,254 | £31,531 | £40,991 | £53,288 | £69,274 | £90,056 | |
| Cash from Receivables | £0 | £893 | £1,943 | £2,526 | £3,284 | £4,269 | £5,549 | £7,214 | £9,378 | £12,192 | £15,850 | £20,605 | |
| Subtotal Cash from Operations | £5,025 | £7,426 | £10,435 | £13,566 | £17,636 | £22,926 | £29,804 | £38,745 | £50,370 | £65,480 | £85,124 | £110,661 | |
| 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 | £5,025 | £7,426 | £10,435 | £13,566 | £17,636 | £22,926 | £29,804 | £38,745 | £50,370 | £65,480 | £85,124 | £110,661 | |
| 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,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £9,000 | £10,000 | |
| Bill Payments | £20,124 | £3,721 | £4,146 | £4,690 | £5,388 | £6,506 | £14,937 | £25,531 | £32,431 | £41,406 | £53,074 | £67,941 | |
| Subtotal Spent on Operations | £28,124 | £11,721 | £12,146 | £12,690 | £13,388 | £14,506 | £22,937 | £33,531 | £40,431 | £49,406 | £62,074 | £77,941 | |
| 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 | £500 | £500 | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £2,000 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | |
| Purchase Other Current Assets | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £29,724 | £13,321 | £13,746 | £14,290 | £15,488 | £16,606 | £26,037 | £36,631 | £43,531 | £53,506 | £66,174 | £82,041 | |
| Net Cash Flow | (£24,699) | (£5,896) | (£3,311) | (£724) | £2,148 | £6,320 | £3,767 | £2,114 | £6,838 | £11,974 | £18,949 | £28,620 | |
| Cash Balance | £19,551 | £13,656 | £10,345 | £9,620 | £11,768 | £18,088 | £21,855 | £23,969 | £30,807 | £42,781 | £61,730 | £90,350 | |
| 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 | £44,250 | £19,551 | £13,656 | £10,345 | £9,620 | £11,768 | £18,088 | £21,855 | £23,969 | £30,807 | £42,781 | £61,730 | £90,350 |
| Accounts Receivable | £0 | £1,675 | £2,959 | £3,847 | £5,001 | £6,501 | £8,452 | £10,987 | £14,283 | £18,569 | £24,139 | £31,381 | £40,795 |
| Inventory | £40,000 | £37,660 | £34,618 | £30,663 | £25,522 | £18,839 | £17,376 | £22,588 | £29,365 | £38,175 | £49,627 | £64,515 | £83,869 |
| Other Current Assets | £20,000 | £20,500 | £21,000 | £21,500 | £22,000 | £22,500 | £23,000 | £23,500 | £24,000 | £24,500 | £25,000 | £25,500 | £26,000 |
| Total Current Assets | £104,250 | £79,386 | £72,233 | £66,355 | £62,144 | £59,609 | £66,915 | £78,930 | £91,617 | £112,050 | £141,548 | £183,126 | £241,014 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,500 | £41,000 | £41,500 | £42,000 | £42,500 | £43,000 |
| Accumulated Depreciation | £0 | £1,500 | £3,000 | £4,500 | £6,000 | £7,500 | £9,000 | £10,500 | £12,000 | £13,500 | £15,000 | £16,500 | £18,000 |
| Total Long-term Assets | £40,000 | £38,500 | £37,000 | £35,500 | £34,000 | £32,500 | £31,000 | £30,000 | £29,000 | £28,000 | £27,000 | £26,000 | £25,000 |
| Total Assets | £144,250 | £117,886 | £109,233 | £101,855 | £96,144 | £92,109 | £97,915 | £108,930 | £120,617 | £140,050 | £168,548 | £209,126 | £266,014 |
| 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 | £20,000 | £3,584 | £3,991 | £4,512 | £5,180 | £6,020 | £14,093 | £24,460 | £31,064 | £39,653 | £50,831 | £65,057 | £83,646 |
| Current Borrowing | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £9,500 | £9,000 | £8,000 | £7,000 | £6,000 | £4,000 | £2,000 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £30,000 | £13,584 | £13,991 | £14,512 | £15,180 | £15,520 | £23,093 | £32,460 | £38,064 | £45,653 | £54,831 | £67,057 | £83,646 |
| Long-term Liabilities | £70,000 | £68,900 | £67,800 | £66,700 | £65,600 | £64,500 | £63,400 | £62,300 | £61,200 | £60,100 | £59,000 | £57,900 | £56,800 |
| Total Liabilities | £100,000 | £82,484 | £81,791 | £81,212 | £80,780 | £80,020 | £86,493 | £94,760 | £99,264 | £105,753 | £113,831 | £124,957 | £140,446 |
| Paid-in Capital | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 | £77,000 |
| Retained Earnings | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) | (£32,750) |
| Earnings | £0 | (£8,847) | (£16,808) | (£23,607) | (£28,886) | (£32,161) | (£32,828) | (£30,080) | (£22,897) | (£9,953) | £10,466 | £39,919 | £81,318 |
| Total Capital | £44,250 | £35,403 | £27,442 | £20,643 | £15,364 | £12,089 | £11,422 | £14,170 | £21,353 | £34,297 | £54,716 | £84,169 | £125,568 |
| Total Liabilities and Capital | £144,250 | £117,886 | £109,233 | £101,855 | £96,144 | £92,109 | £97,915 | £108,930 | £120,617 | £140,050 | £168,548 | £209,126 | £266,014 |
| Net Worth | £44,250 | £35,403 | £27,442 | £20,643 | £15,364 | £12,089 | £11,422 | £14,170 | £21,353 | £34,297 | £54,716 | £84,169 | £125,568 |