| 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 | |||||||||||||
| Drinks | 0% | £28,000 | £33,040 | £38,987 | £46,005 | £54,286 | £64,057 | £75,588 | £89,193 | £105,248 | £124,193 | £146,547 | £172,926 |
| Snacks | 0% | £25,000 | £29,500 | £34,810 | £41,076 | £48,469 | £57,194 | £67,489 | £79,637 | £93,971 | £110,886 | £130,846 | £154,398 |
| Magazines/newspapers | 0% | £6,000 | £7,080 | £8,354 | £9,858 | £11,633 | £13,727 | £16,197 | £19,113 | £22,553 | £26,613 | £31,403 | £37,056 |
| General grocery items | 0% | £8,000 | £9,440 | £11,139 | £13,144 | £15,510 | £18,302 | £21,596 | £25,484 | £30,071 | £35,484 | £41,871 | £49,407 |
| Other | 0% | £4,000 | £4,720 | £5,570 | £6,572 | £7,755 | £9,151 | £10,798 | £12,742 | £15,035 | £17,742 | £20,935 | £24,704 |
| Total Sales | £71,000 | £83,780 | £98,860 | £116,655 | £137,653 | £162,431 | £191,668 | £226,169 | £266,879 | £314,917 | £371,602 | £438,491 | |
| 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 | |
| Drinks | £21,560 | £25,441 | £30,020 | £35,424 | £41,800 | £49,324 | £58,202 | £68,679 | £81,041 | £95,628 | £112,841 | £133,153 | |
| Snacks | £19,250 | £22,715 | £26,804 | £31,628 | £37,321 | £44,039 | £51,966 | £61,320 | £72,358 | £85,382 | £100,751 | £118,887 | |
| Magazines/newspapers | £4,620 | £5,452 | £6,433 | £7,591 | £8,957 | £10,569 | £12,472 | £14,717 | £17,366 | £20,492 | £24,180 | £28,533 | |
| General grocery items | £6,160 | £7,269 | £8,577 | £10,121 | £11,943 | £14,093 | £16,629 | £19,623 | £23,155 | £27,322 | £32,240 | £38,044 | |
| Other | £3,080 | £3,634 | £4,289 | £5,061 | £5,971 | £7,046 | £8,315 | £9,811 | £11,577 | £13,661 | £16,120 | £19,022 | |
| Subtotal Direct Cost of Sales | £54,670 | £64,511 | £76,123 | £89,825 | £105,993 | £125,072 | £147,585 | £174,150 | £205,497 | £242,486 | £286,134 | £337,638 | |
| 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 | ||
| Mr. Bean | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Mrs. Tuck | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Mr. Takeda | 0% | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Office manager | 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 |
| Technicians | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £3,000 | £3,000 | £4,500 | £4,500 | £4,500 | £4,500 |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 6 | 6 | 7 | 7 | 7 | 7 | |
| Total Payroll | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £14,200 | £14,200 | £15,700 | £15,700 | £15,700 | £15,700 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £71,000 | £83,780 | £98,860 | £116,655 | £137,653 | £162,431 | £191,668 | £226,169 | £266,879 | £314,917 | £371,602 | £438,491 | |
| Direct Cost of Sales | £54,670 | £64,511 | £76,123 | £89,825 | £105,993 | £125,072 | £147,585 | £174,150 | £205,497 | £242,486 | £286,134 | £337,638 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £54,670 | £64,511 | £76,123 | £89,825 | £105,993 | £125,072 | £147,585 | £174,150 | £205,497 | £242,486 | £286,134 | £337,638 | |
| Gross Margin | £16,330 | £19,269 | £22,738 | £26,831 | £31,660 | £37,359 | £44,084 | £52,019 | £61,382 | £72,431 | £85,469 | £100,853 | |
| Gross Margin % | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | |
| Expenses | |||||||||||||
| Payroll | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £14,200 | £14,200 | £15,700 | £15,700 | £15,700 | £15,700 | |
| Sales and Marketing and Other Expenses | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Depreciation | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Leased equipment | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £6,000 | |
| Rent | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| Utilities | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | |
| Accounting/bookeeping | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £750 | £750 | |
| Insurance | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £3,000 | £4,000 | £5,000 | £10,000 | |
| Total Operating Expenses | £35,400 | £35,400 | £35,400 | £35,400 | £35,400 | £35,400 | £36,900 | £36,900 | £39,400 | £40,400 | £41,650 | £48,650 | |
| Profit Before Interest and Taxes | (£19,070) | (£16,131) | (£12,662) | (£8,569) | (£3,740) | £1,959 | £7,184 | £15,119 | £21,982 | £32,031 | £43,819 | £52,203 | |
| EBITDA | (£18,470) | (£15,531) | (£12,062) | (£7,969) | (£3,140) | £2,559 | £7,784 | £15,719 | £22,582 | £32,631 | £44,419 | £52,803 | |
| Interest Expense | £958 | £1,375 | £1,375 | £1,375 | £1,375 | £1,375 | £1,375 | £1,375 | £1,417 | £1,417 | £1,417 | £1,417 | |
| Taxes Incurred | (£6,008) | (£5,252) | (£4,211) | (£2,983) | (£1,534) | £175 | £1,743 | £4,123 | £6,170 | £9,184 | £12,721 | £15,236 | |
| Net Profit | (£14,020) | (£12,254) | (£9,826) | (£6,961) | (£3,580) | £409 | £4,066 | £9,621 | £14,396 | £21,430 | £29,681 | £35,550 | |
| Net Profit/Sales | -19.75% | -14.63% | -9.94% | -5.97% | -2.60% | 0.25% | 2.12% | 4.25% | 5.39% | 6.80% | 7.99% | 8.11% | |
| 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 | £71,000 | £83,780 | £98,860 | £116,655 | £137,653 | £162,431 | £191,668 | £226,169 | £266,879 | £314,917 | £371,602 | £438,491 | |
| Subtotal Cash from Operations | £71,000 | £83,780 | £98,860 | £116,655 | £137,653 | £162,431 | £191,668 | £226,169 | £266,879 | £314,917 | £371,602 | £438,491 | |
| 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 | £5,000 | £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 | £50,000 | £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 | £50,000 | £0 | £0 | £0 | £0 | £0 | £0 | £4,000 | |
| Subtotal Cash Received | £71,000 | £133,780 | £98,860 | £116,655 | £187,653 | £162,431 | £191,668 | £226,169 | £271,879 | £314,917 | £371,602 | £442,491 | |
| 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 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £14,200 | £14,200 | £15,700 | £15,700 | £15,700 | £15,700 | |
| Bill Payments | £12,062 | £120,914 | £94,045 | £108,734 | £126,066 | £146,518 | £170,637 | £198,680 | £232,293 | £272,239 | £319,734 | £375,955 | |
| Subtotal Spent on Operations | £24,762 | £133,614 | £106,745 | £121,434 | £138,766 | £159,218 | £184,837 | £212,880 | £247,993 | £287,939 | £335,434 | £391,655 | |
| 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 | £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 | £24,762 | £133,614 | £106,745 | £121,434 | £138,766 | £159,218 | £184,837 | £212,880 | £247,993 | £287,939 | £335,434 | £391,655 | |
| Net Cash Flow | £46,238 | £166 | (£7,885) | (£4,779) | £48,887 | £3,212 | £6,831 | £13,289 | £23,886 | £26,979 | £36,168 | £50,835 | |
| Cash Balance | £160,058 | £160,225 | £152,340 | £147,561 | £196,448 | £199,661 | £206,492 | £219,780 | £243,667 | £270,645 | £306,813 | £357,649 | |
| 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 | £113,820 | £160,058 | £160,225 | £152,340 | £147,561 | £196,448 | £199,661 | £206,492 | £219,780 | £243,667 | £270,645 | £306,813 | £357,649 |
| Inventory | £10,000 | £60,137 | £70,962 | £83,735 | £98,807 | £116,592 | £137,579 | £162,343 | £191,565 | £226,047 | £266,735 | £314,747 | £371,402 |
| Other Current Assets | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 |
| Total Current Assets | £131,820 | £228,195 | £239,186 | £244,074 | £254,368 | £321,040 | £345,239 | £376,835 | £419,345 | £477,713 | £545,380 | £629,561 | £737,050 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 |
| Accumulated Depreciation | £0 | £600 | £1,200 | £1,800 | £2,400 | £3,000 | £3,600 | £4,200 | £4,800 | £5,400 | £6,000 | £6,600 | £7,200 |
| Total Long-term Assets | £72,000 | £71,400 | £70,800 | £70,200 | £69,600 | £69,000 | £68,400 | £67,800 | £67,200 | £66,600 | £66,000 | £65,400 | £64,800 |
| Total Assets | £203,820 | £299,595 | £309,986 | £314,274 | £323,968 | £390,040 | £413,639 | £444,635 | £486,545 | £544,313 | £611,380 | £694,961 | £801,850 |
| 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 | £8,000 | £117,795 | £90,440 | £104,554 | £121,209 | £140,862 | £164,052 | £190,981 | £223,271 | £261,643 | £307,280 | £361,179 | £428,518 |
| Current Borrowing | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Other Current Liabilities | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Subtotal Current Liabilities | £33,000 | £142,795 | £115,440 | £129,554 | £146,209 | £165,862 | £189,052 | £215,981 | £248,271 | £291,643 | £337,280 | £391,179 | £458,518 |
| Long-term Liabilities | £100,000 | £100,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 |
| Total Liabilities | £133,000 | £242,795 | £265,440 | £279,554 | £296,209 | £315,862 | £339,052 | £365,981 | £398,271 | £441,643 | £487,280 | £541,179 | £608,518 |
| Paid-in Capital | £320,000 | £320,000 | £320,000 | £320,000 | £320,000 | £370,000 | £370,000 | £370,000 | £370,000 | £370,000 | £370,000 | £370,000 | £374,000 |
| Retained Earnings | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) |
| Earnings | £0 | (£14,020) | (£26,274) | (£36,100) | (£43,061) | (£46,641) | (£46,232) | (£42,166) | (£32,545) | (£18,150) | £3,280 | £32,962 | £68,512 |
| Total Capital | £70,820 | £56,800 | £44,546 | £34,720 | £27,759 | £74,179 | £74,588 | £78,654 | £88,275 | £102,670 | £124,100 | £153,782 | £193,332 |
| Total Liabilities and Capital | £203,820 | £299,595 | £309,986 | £314,274 | £323,968 | £390,040 | £413,639 | £444,635 | £486,545 | £544,313 | £611,380 | £694,961 | £801,850 |
| Net Worth | £70,820 | £56,800 | £44,546 | £34,720 | £27,759 | £74,179 | £74,588 | £78,654 | £88,275 | £102,670 | £124,100 | £153,782 | £193,332 |
| 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 | |||||||||||||
| Drinks | 0% | £28,000 | £33,040 | £38,987 | £46,005 | £54,286 | £64,057 | £75,588 | £89,193 | £105,248 | £124,193 | £146,547 | £172,926 |
| Snacks | 0% | £25,000 | £29,500 | £34,810 | £41,076 | £48,469 | £57,194 | £67,489 | £79,637 | £93,971 | £110,886 | £130,846 | £154,398 |
| Magazines/newspapers | 0% | £6,000 | £7,080 | £8,354 | £9,858 | £11,633 | £13,727 | £16,197 | £19,113 | £22,553 | £26,613 | £31,403 | £37,056 |
| General grocery items | 0% | £8,000 | £9,440 | £11,139 | £13,144 | £15,510 | £18,302 | £21,596 | £25,484 | £30,071 | £35,484 | £41,871 | £49,407 |
| Other | 0% | £4,000 | £4,720 | £5,570 | £6,572 | £7,755 | £9,151 | £10,798 | £12,742 | £15,035 | £17,742 | £20,935 | £24,704 |
| Total Sales | £71,000 | £83,780 | £98,860 | £116,655 | £137,653 | £162,431 | £191,668 | £226,169 | £266,879 | £314,917 | £371,602 | £438,491 | |
| 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 | |
| Drinks | £21,560 | £25,441 | £30,020 | £35,424 | £41,800 | £49,324 | £58,202 | £68,679 | £81,041 | £95,628 | £112,841 | £133,153 | |
| Snacks | £19,250 | £22,715 | £26,804 | £31,628 | £37,321 | £44,039 | £51,966 | £61,320 | £72,358 | £85,382 | £100,751 | £118,887 | |
| Magazines/newspapers | £4,620 | £5,452 | £6,433 | £7,591 | £8,957 | £10,569 | £12,472 | £14,717 | £17,366 | £20,492 | £24,180 | £28,533 | |
| General grocery items | £6,160 | £7,269 | £8,577 | £10,121 | £11,943 | £14,093 | £16,629 | £19,623 | £23,155 | £27,322 | £32,240 | £38,044 | |
| Other | £3,080 | £3,634 | £4,289 | £5,061 | £5,971 | £7,046 | £8,315 | £9,811 | £11,577 | £13,661 | £16,120 | £19,022 | |
| Subtotal Direct Cost of Sales | £54,670 | £64,511 | £76,123 | £89,825 | £105,993 | £125,072 | £147,585 | £174,150 | £205,497 | £242,486 | £286,134 | £337,638 | |
| 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 | ||
| Mr. Bean | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Mrs. Tuck | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Mr. Takeda | 0% | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Office manager | 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 |
| Technicians | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £3,000 | £3,000 | £4,500 | £4,500 | £4,500 | £4,500 |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 6 | 6 | 7 | 7 | 7 | 7 | |
| Total Payroll | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £14,200 | £14,200 | £15,700 | £15,700 | £15,700 | £15,700 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £71,000 | £83,780 | £98,860 | £116,655 | £137,653 | £162,431 | £191,668 | £226,169 | £266,879 | £314,917 | £371,602 | £438,491 | |
| Direct Cost of Sales | £54,670 | £64,511 | £76,123 | £89,825 | £105,993 | £125,072 | £147,585 | £174,150 | £205,497 | £242,486 | £286,134 | £337,638 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £54,670 | £64,511 | £76,123 | £89,825 | £105,993 | £125,072 | £147,585 | £174,150 | £205,497 | £242,486 | £286,134 | £337,638 | |
| Gross Margin | £16,330 | £19,269 | £22,738 | £26,831 | £31,660 | £37,359 | £44,084 | £52,019 | £61,382 | £72,431 | £85,469 | £100,853 | |
| Gross Margin % | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | |
| Expenses | |||||||||||||
| Payroll | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £14,200 | £14,200 | £15,700 | £15,700 | £15,700 | £15,700 | |
| Sales and Marketing and Other Expenses | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Depreciation | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Leased equipment | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £6,000 | |
| Rent | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| Utilities | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | |
| Accounting/bookeeping | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £750 | £750 | |
| Insurance | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £3,000 | £4,000 | £5,000 | £10,000 | |
| Total Operating Expenses | £35,400 | £35,400 | £35,400 | £35,400 | £35,400 | £35,400 | £36,900 | £36,900 | £39,400 | £40,400 | £41,650 | £48,650 | |
| Profit Before Interest and Taxes | (£19,070) | (£16,131) | (£12,662) | (£8,569) | (£3,740) | £1,959 | £7,184 | £15,119 | £21,982 | £32,031 | £43,819 | £52,203 | |
| EBITDA | (£18,470) | (£15,531) | (£12,062) | (£7,969) | (£3,140) | £2,559 | £7,784 | £15,719 | £22,582 | £32,631 | £44,419 | £52,803 | |
| Interest Expense | £958 | £1,375 | £1,375 | £1,375 | £1,375 | £1,375 | £1,375 | £1,375 | £1,417 | £1,417 | £1,417 | £1,417 | |
| Taxes Incurred | (£6,008) | (£5,252) | (£4,211) | (£2,983) | (£1,534) | £175 | £1,743 | £4,123 | £6,170 | £9,184 | £12,721 | £15,236 | |
| Net Profit | (£14,020) | (£12,254) | (£9,826) | (£6,961) | (£3,580) | £409 | £4,066 | £9,621 | £14,396 | £21,430 | £29,681 | £35,550 | |
| Net Profit/Sales | -19.75% | -14.63% | -9.94% | -5.97% | -2.60% | 0.25% | 2.12% | 4.25% | 5.39% | 6.80% | 7.99% | 8.11% | |
| 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 | £71,000 | £83,780 | £98,860 | £116,655 | £137,653 | £162,431 | £191,668 | £226,169 | £266,879 | £314,917 | £371,602 | £438,491 | |
| Subtotal Cash from Operations | £71,000 | £83,780 | £98,860 | £116,655 | £137,653 | £162,431 | £191,668 | £226,169 | £266,879 | £314,917 | £371,602 | £438,491 | |
| 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 | £5,000 | £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 | £50,000 | £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 | £50,000 | £0 | £0 | £0 | £0 | £0 | £0 | £4,000 | |
| Subtotal Cash Received | £71,000 | £133,780 | £98,860 | £116,655 | £187,653 | £162,431 | £191,668 | £226,169 | £271,879 | £314,917 | £371,602 | £442,491 | |
| 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 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £12,700 | £14,200 | £14,200 | £15,700 | £15,700 | £15,700 | £15,700 | |
| Bill Payments | £12,062 | £120,914 | £94,045 | £108,734 | £126,066 | £146,518 | £170,637 | £198,680 | £232,293 | £272,239 | £319,734 | £375,955 | |
| Subtotal Spent on Operations | £24,762 | £133,614 | £106,745 | £121,434 | £138,766 | £159,218 | £184,837 | £212,880 | £247,993 | £287,939 | £335,434 | £391,655 | |
| 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 | £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 | £24,762 | £133,614 | £106,745 | £121,434 | £138,766 | £159,218 | £184,837 | £212,880 | £247,993 | £287,939 | £335,434 | £391,655 | |
| Net Cash Flow | £46,238 | £166 | (£7,885) | (£4,779) | £48,887 | £3,212 | £6,831 | £13,289 | £23,886 | £26,979 | £36,168 | £50,835 | |
| Cash Balance | £160,058 | £160,225 | £152,340 | £147,561 | £196,448 | £199,661 | £206,492 | £219,780 | £243,667 | £270,645 | £306,813 | £357,649 | |
| 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 | £113,820 | £160,058 | £160,225 | £152,340 | £147,561 | £196,448 | £199,661 | £206,492 | £219,780 | £243,667 | £270,645 | £306,813 | £357,649 |
| Inventory | £10,000 | £60,137 | £70,962 | £83,735 | £98,807 | £116,592 | £137,579 | £162,343 | £191,565 | £226,047 | £266,735 | £314,747 | £371,402 |
| Other Current Assets | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 |
| Total Current Assets | £131,820 | £228,195 | £239,186 | £244,074 | £254,368 | £321,040 | £345,239 | £376,835 | £419,345 | £477,713 | £545,380 | £629,561 | £737,050 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 | £72,000 |
| Accumulated Depreciation | £0 | £600 | £1,200 | £1,800 | £2,400 | £3,000 | £3,600 | £4,200 | £4,800 | £5,400 | £6,000 | £6,600 | £7,200 |
| Total Long-term Assets | £72,000 | £71,400 | £70,800 | £70,200 | £69,600 | £69,000 | £68,400 | £67,800 | £67,200 | £66,600 | £66,000 | £65,400 | £64,800 |
| Total Assets | £203,820 | £299,595 | £309,986 | £314,274 | £323,968 | £390,040 | £413,639 | £444,635 | £486,545 | £544,313 | £611,380 | £694,961 | £801,850 |
| 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 | £8,000 | £117,795 | £90,440 | £104,554 | £121,209 | £140,862 | £164,052 | £190,981 | £223,271 | £261,643 | £307,280 | £361,179 | £428,518 |
| Current Borrowing | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Other Current Liabilities | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Subtotal Current Liabilities | £33,000 | £142,795 | £115,440 | £129,554 | £146,209 | £165,862 | £189,052 | £215,981 | £248,271 | £291,643 | £337,280 | £391,179 | £458,518 |
| Long-term Liabilities | £100,000 | £100,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 |
| Total Liabilities | £133,000 | £242,795 | £265,440 | £279,554 | £296,209 | £315,862 | £339,052 | £365,981 | £398,271 | £441,643 | £487,280 | £541,179 | £608,518 |
| Paid-in Capital | £320,000 | £320,000 | £320,000 | £320,000 | £320,000 | £370,000 | £370,000 | £370,000 | £370,000 | £370,000 | £370,000 | £370,000 | £374,000 |
| Retained Earnings | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) | (£249,180) |
| Earnings | £0 | (£14,020) | (£26,274) | (£36,100) | (£43,061) | (£46,641) | (£46,232) | (£42,166) | (£32,545) | (£18,150) | £3,280 | £32,962 | £68,512 |
| Total Capital | £70,820 | £56,800 | £44,546 | £34,720 | £27,759 | £74,179 | £74,588 | £78,654 | £88,275 | £102,670 | £124,100 | £153,782 | £193,332 |
| Total Liabilities and Capital | £203,820 | £299,595 | £309,986 | £314,274 | £323,968 | £390,040 | £413,639 | £444,635 | £486,545 | £544,313 | £611,380 | £694,961 | £801,850 |
| Net Worth | £70,820 | £56,800 | £44,546 | £34,720 | £27,759 | £74,179 | £74,588 | £78,654 | £88,275 | £102,670 | £124,100 | £153,782 | £193,332 |