| 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 | |||||||||||||
| Party Fees | 0% | £10,500 | £17,500 | £26,250 | £35,000 | £44,297 | £66,445 | £66,445 | £66,445 | £99,667 | £112,125 | £149,500 | £163,500 |
| Other Fees | 0% | £300 | £500 | £750 | £1,000 | £1,266 | £1,898 | £1,898 | £1,898 | £2,848 | £3,204 | £4,271 | £4,671 |
| Total Sales | £10,800 | £18,000 | £27,000 | £36,000 | £45,563 | £68,343 | £68,343 | £68,343 | £102,515 | £115,329 | £153,771 | £168,171 | |
| 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 | |
| Ingredients | £7,500 | £12,500 | £18,750 | £25,000 | £31,641 | £47,461 | £47,461 | £47,461 | £71,191 | £80,089 | £106,786 | £116,786 | |
| Other Supplies | £540 | £900 | £1,350 | £1,800 | £2,278 | £3,417 | £3,417 | £3,417 | £5,126 | £5,766 | £7,689 | £8,409 | |
| Subtotal Direct Cost of Sales | £8,040 | £13,400 | £20,100 | £26,800 | £33,919 | £50,878 | £50,878 | £50,878 | £76,316 | £85,856 | £114,474 | £125,194 | |
| 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 | ||
| Alan Kirby | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Kim Kirby | 0% | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 |
| Part-time cleaner | 0% | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 |
| Total People | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | |
| 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 | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Long-term Interest Rate | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Tax Rate | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.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 | £10,800 | £18,000 | £27,000 | £36,000 | £45,563 | £68,343 | £68,343 | £68,343 | £102,515 | £115,329 | £153,771 | £168,171 | |
| Direct Cost of Sales | £8,040 | £13,400 | £20,100 | £26,800 | £33,919 | £50,878 | £50,878 | £50,878 | £76,316 | £85,856 | £114,474 | £125,194 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £8,040 | £13,400 | £20,100 | £26,800 | £33,919 | £50,878 | £50,878 | £50,878 | £76,316 | £85,856 | £114,474 | £125,194 | |
| Gross Margin | £2,760 | £4,600 | £6,900 | £9,200 | £11,644 | £17,466 | £17,466 | £17,466 | £26,198 | £29,473 | £39,297 | £42,977 | |
| Gross Margin % | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | |
| Expenses | |||||||||||||
| Payroll | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | |
| Sales and Marketing and Other Expenses | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Depreciation | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Rent | £4,442 | £4,442 | £4,442 | £4,442 | £4,442 | £4,442 | £4,442 | £4,442 | £4,442 | £4,442 | £4,442 | £4,442 | |
| Utilities | £980 | £1,030 | £1,030 | £1,030 | £1,030 | £980 | £980 | £980 | £1,280 | £1,280 | £1,280 | £1,280 | |
| Office Supplies | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accountant | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Lawyer | £500 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £500 | |
| Bank Charges | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | |
| Website Payment Fees | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Website Hosting & Support | 0% | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 |
| Repairs and Maintenance | 15% | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £10,395 | £9,945 | £9,945 | £9,945 | £9,945 | £9,895 | £9,895 | £9,895 | £10,195 | £10,195 | £10,195 | £10,695 | |
| Profit Before Interest and Taxes | (£7,635) | (£5,345) | (£3,045) | (£745) | £1,698 | £7,570 | £7,570 | £7,570 | £16,003 | £19,278 | £29,102 | £32,282 | |
| EBITDA | (£7,285) | (£4,995) | (£2,695) | (£395) | £2,048 | £7,920 | £7,920 | £7,920 | £16,353 | £19,628 | £29,452 | £32,632 | |
| Interest Expense | £1,504 | £1,493 | £1,483 | £1,472 | £1,461 | £1,451 | £1,440 | £1,429 | £1,418 | £1,408 | £1,397 | £1,386 | |
| Taxes Incurred | (£2,193) | (£1,641) | (£1,087) | (£532) | £57 | £1,469 | £1,471 | £1,474 | £3,500 | £4,289 | £6,649 | £7,415 | |
| Net Profit | (£6,946) | (£5,198) | (£3,441) | (£1,685) | £180 | £4,651 | £4,659 | £4,667 | £11,084 | £13,581 | £21,056 | £23,481 | |
| Net Profit/Sales | -64.32% | -28.88% | -12.75% | -4.68% | 0.40% | 6.81% | 6.82% | 6.83% | 10.81% | 11.78% | 13.69% | 13.96% | |
| 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 | £10,800 | £18,000 | £27,000 | £36,000 | £45,563 | £68,343 | £68,343 | £68,343 | £102,515 | £115,329 | £153,771 | £168,171 | |
| Subtotal Cash from Operations | £10,800 | £18,000 | £27,000 | £36,000 | £45,563 | £68,343 | £68,343 | £68,343 | £102,515 | £115,329 | £153,771 | £168,171 | |
| 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 | £10,800 | £18,000 | £27,000 | £36,000 | £45,563 | £68,343 | £68,343 | £68,343 | £102,515 | £115,329 | £153,771 | £168,171 | |
| 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 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | |
| Bill Payments | £480 | £14,790 | £26,201 | £34,869 | £42,144 | £51,001 | £78,542 | £60,501 | £62,351 | £115,990 | £110,789 | £160,756 | |
| Subtotal Spent on Operations | £3,314 | £17,624 | £29,034 | £37,703 | £44,977 | £53,834 | £81,375 | £63,334 | £65,184 | £118,824 | £113,622 | £163,589 | |
| 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 | £1,840 | £1,840 | £1,840 | £1,840 | £1,840 | £1,840 | £1,840 | £1,840 | £1,840 | £1,840 | £1,840 | £1,840 | |
| 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 | £5,154 | £19,464 | £30,874 | £39,543 | £46,817 | £55,674 | £83,215 | £65,174 | £67,024 | £120,664 | £115,462 | £165,429 | |
| Net Cash Flow | £5,646 | (£1,464) | (£3,874) | (£3,543) | (£1,254) | £12,669 | (£14,872) | £3,169 | £35,491 | (£5,335) | £38,309 | £2,742 | |
| Cash Balance | £39,646 | £38,183 | £34,309 | £30,766 | £29,512 | £42,181 | £27,309 | £30,478 | £65,969 | £60,633 | £98,942 | £101,685 | |
| 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 | £34,000 | £39,646 | £38,183 | £34,309 | £30,766 | £29,512 | £42,181 | £27,309 | £30,478 | £65,969 | £60,633 | £98,942 | £101,685 |
| Inventory | £9,000 | £8,844 | £14,740 | £22,110 | £29,480 | £37,311 | £55,966 | £55,966 | £55,966 | £83,948 | £94,441 | £125,922 | £137,714 |
| 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 | £51,000 | £56,490 | £60,923 | £64,419 | £68,246 | £74,822 | £106,146 | £91,274 | £94,444 | £157,917 | £163,075 | £232,864 | £247,399 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 |
| Accumulated Depreciation | £0 | £350 | £700 | £1,050 | £1,400 | £1,750 | £2,100 | £2,450 | £2,800 | £3,150 | £3,500 | £3,850 | £4,200 |
| Total Long-term Assets | £42,000 | £41,650 | £41,300 | £40,950 | £40,600 | £40,250 | £39,900 | £39,550 | £39,200 | £38,850 | £38,500 | £38,150 | £37,800 |
| Total Assets | £93,000 | £98,140 | £102,223 | £105,369 | £108,846 | £115,072 | £146,046 | £130,824 | £133,644 | £196,767 | £201,575 | £271,014 | £285,199 |
| 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 | £13,927 | £25,047 | £33,474 | £40,476 | £48,362 | £76,525 | £58,484 | £58,476 | £112,355 | £105,422 | £155,646 | £148,189 |
| 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 | £13,927 | £25,047 | £33,474 | £40,476 | £48,362 | £76,525 | £58,484 | £58,476 | £112,355 | £105,422 | £155,646 | £148,189 |
| Long-term Liabilities | £259,708 | £257,868 | £256,028 | £254,188 | £252,348 | £250,508 | £248,668 | £246,828 | £244,988 | £243,148 | £241,308 | £239,468 | £237,628 |
| Total Liabilities | £259,708 | £271,795 | £281,075 | £287,662 | £292,824 | £298,870 | £325,193 | £305,312 | £303,464 | £355,503 | £346,730 | £395,114 | £385,817 |
| Paid-in Capital | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| Retained Earnings | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) |
| Earnings | £0 | (£6,946) | (£12,144) | (£15,585) | (£17,270) | (£17,090) | (£12,439) | (£7,780) | (£3,113) | £7,972 | £21,553 | £42,608 | £66,089 |
| Total Capital | (£166,708) | (£173,654) | (£178,852) | (£182,293) | (£183,978) | (£183,798) | (£179,147) | (£174,488) | (£169,821) | (£158,736) | (£145,155) | (£124,100) | (£100,619) |
| Total Liabilities and Capital | £93,000 | £98,140 | £102,223 | £105,369 | £108,846 | £115,072 | £146,046 | £130,824 | £133,644 | £196,767 | £201,575 | £271,014 | £285,199 |
| Net Worth | (£166,708) | (£173,654) | (£178,852) | (£182,293) | (£183,978) | (£183,798) | (£179,147) | (£174,488) | (£169,821) | (£158,736) | (£145,155) | (£124,100) | (£100,619) |
| 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 | |||||||||||||
| Party Fees | 0% | £10,500 | £17,500 | £26,250 | £35,000 | £44,297 | £66,445 | £66,445 | £66,445 | £99,667 | £112,125 | £149,500 | £163,500 |
| Other Fees | 0% | £300 | £500 | £750 | £1,000 | £1,266 | £1,898 | £1,898 | £1,898 | £2,848 | £3,204 | £4,271 | £4,671 |
| Total Sales | £10,800 | £18,000 | £27,000 | £36,000 | £45,563 | £68,343 | £68,343 | £68,343 | £102,515 | £115,329 | £153,771 | £168,171 | |
| 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 | |
| Ingredients | £7,500 | £12,500 | £18,750 | £25,000 | £31,641 | £47,461 | £47,461 | £47,461 | £71,191 | £80,089 | £106,786 | £116,786 | |
| Other Supplies | £540 | £900 | £1,350 | £1,800 | £2,278 | £3,417 | £3,417 | £3,417 | £5,126 | £5,766 | £7,689 | £8,409 | |
| Subtotal Direct Cost of Sales | £8,040 | £13,400 | £20,100 | £26,800 | £33,919 | £50,878 | £50,878 | £50,878 | £76,316 | £85,856 | £114,474 | £125,194 | |
| 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 | ||
| Alan Kirby | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Kim Kirby | 0% | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 |
| Part-time cleaner | 0% | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 |
| Total People | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | |
| 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 | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Long-term Interest Rate | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Tax Rate | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.00% | 24.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 | £10,800 | £18,000 | £27,000 | £36,000 | £45,563 | £68,343 | £68,343 | £68,343 | £102,515 | £115,329 | £153,771 | £168,171 | |
| Direct Cost of Sales | £8,040 | £13,400 | £20,100 | £26,800 | £33,919 | £50,878 | £50,878 | £50,878 | £76,316 | £85,856 | £114,474 | £125,194 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £8,040 | £13,400 | £20,100 | £26,800 | £33,919 | £50,878 | £50,878 | £50,878 | £76,316 | £85,856 | £114,474 | £125,194 | |
| Gross Margin | £2,760 | £4,600 | £6,900 | £9,200 | £11,644 | £17,466 | £17,466 | £17,466 | £26,198 | £29,473 | £39,297 | £42,977 | |
| Gross Margin % | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | 25.56% | |
| Expenses | |||||||||||||
| Payroll | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | |
| Sales and Marketing and Other Expenses | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Depreciation | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Rent | £4,442 | £4,442 | £4,442 | £4,442 | £4,442 | £4,442 | £4,442 | £4,442 | £4,442 | £4,442 | £4,442 | £4,442 | |
| Utilities | £980 | £1,030 | £1,030 | £1,030 | £1,030 | £980 | £980 | £980 | £1,280 | £1,280 | £1,280 | £1,280 | |
| Office Supplies | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accountant | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Lawyer | £500 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £500 | |
| Bank Charges | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | |
| Website Payment Fees | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Website Hosting & Support | 0% | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 |
| Repairs and Maintenance | 15% | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £10,395 | £9,945 | £9,945 | £9,945 | £9,945 | £9,895 | £9,895 | £9,895 | £10,195 | £10,195 | £10,195 | £10,695 | |
| Profit Before Interest and Taxes | (£7,635) | (£5,345) | (£3,045) | (£745) | £1,698 | £7,570 | £7,570 | £7,570 | £16,003 | £19,278 | £29,102 | £32,282 | |
| EBITDA | (£7,285) | (£4,995) | (£2,695) | (£395) | £2,048 | £7,920 | £7,920 | £7,920 | £16,353 | £19,628 | £29,452 | £32,632 | |
| Interest Expense | £1,504 | £1,493 | £1,483 | £1,472 | £1,461 | £1,451 | £1,440 | £1,429 | £1,418 | £1,408 | £1,397 | £1,386 | |
| Taxes Incurred | (£2,193) | (£1,641) | (£1,087) | (£532) | £57 | £1,469 | £1,471 | £1,474 | £3,500 | £4,289 | £6,649 | £7,415 | |
| Net Profit | (£6,946) | (£5,198) | (£3,441) | (£1,685) | £180 | £4,651 | £4,659 | £4,667 | £11,084 | £13,581 | £21,056 | £23,481 | |
| Net Profit/Sales | -64.32% | -28.88% | -12.75% | -4.68% | 0.40% | 6.81% | 6.82% | 6.83% | 10.81% | 11.78% | 13.69% | 13.96% | |
| 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 | £10,800 | £18,000 | £27,000 | £36,000 | £45,563 | £68,343 | £68,343 | £68,343 | £102,515 | £115,329 | £153,771 | £168,171 | |
| Subtotal Cash from Operations | £10,800 | £18,000 | £27,000 | £36,000 | £45,563 | £68,343 | £68,343 | £68,343 | £102,515 | £115,329 | £153,771 | £168,171 | |
| 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 | £10,800 | £18,000 | £27,000 | £36,000 | £45,563 | £68,343 | £68,343 | £68,343 | £102,515 | £115,329 | £153,771 | £168,171 | |
| 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 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | £2,833 | |
| Bill Payments | £480 | £14,790 | £26,201 | £34,869 | £42,144 | £51,001 | £78,542 | £60,501 | £62,351 | £115,990 | £110,789 | £160,756 | |
| Subtotal Spent on Operations | £3,314 | £17,624 | £29,034 | £37,703 | £44,977 | £53,834 | £81,375 | £63,334 | £65,184 | £118,824 | £113,622 | £163,589 | |
| 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 | £1,840 | £1,840 | £1,840 | £1,840 | £1,840 | £1,840 | £1,840 | £1,840 | £1,840 | £1,840 | £1,840 | £1,840 | |
| 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 | £5,154 | £19,464 | £30,874 | £39,543 | £46,817 | £55,674 | £83,215 | £65,174 | £67,024 | £120,664 | £115,462 | £165,429 | |
| Net Cash Flow | £5,646 | (£1,464) | (£3,874) | (£3,543) | (£1,254) | £12,669 | (£14,872) | £3,169 | £35,491 | (£5,335) | £38,309 | £2,742 | |
| Cash Balance | £39,646 | £38,183 | £34,309 | £30,766 | £29,512 | £42,181 | £27,309 | £30,478 | £65,969 | £60,633 | £98,942 | £101,685 | |
| 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 | £34,000 | £39,646 | £38,183 | £34,309 | £30,766 | £29,512 | £42,181 | £27,309 | £30,478 | £65,969 | £60,633 | £98,942 | £101,685 |
| Inventory | £9,000 | £8,844 | £14,740 | £22,110 | £29,480 | £37,311 | £55,966 | £55,966 | £55,966 | £83,948 | £94,441 | £125,922 | £137,714 |
| 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 | £51,000 | £56,490 | £60,923 | £64,419 | £68,246 | £74,822 | £106,146 | £91,274 | £94,444 | £157,917 | £163,075 | £232,864 | £247,399 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 |
| Accumulated Depreciation | £0 | £350 | £700 | £1,050 | £1,400 | £1,750 | £2,100 | £2,450 | £2,800 | £3,150 | £3,500 | £3,850 | £4,200 |
| Total Long-term Assets | £42,000 | £41,650 | £41,300 | £40,950 | £40,600 | £40,250 | £39,900 | £39,550 | £39,200 | £38,850 | £38,500 | £38,150 | £37,800 |
| Total Assets | £93,000 | £98,140 | £102,223 | £105,369 | £108,846 | £115,072 | £146,046 | £130,824 | £133,644 | £196,767 | £201,575 | £271,014 | £285,199 |
| 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 | £13,927 | £25,047 | £33,474 | £40,476 | £48,362 | £76,525 | £58,484 | £58,476 | £112,355 | £105,422 | £155,646 | £148,189 |
| 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 | £13,927 | £25,047 | £33,474 | £40,476 | £48,362 | £76,525 | £58,484 | £58,476 | £112,355 | £105,422 | £155,646 | £148,189 |
| Long-term Liabilities | £259,708 | £257,868 | £256,028 | £254,188 | £252,348 | £250,508 | £248,668 | £246,828 | £244,988 | £243,148 | £241,308 | £239,468 | £237,628 |
| Total Liabilities | £259,708 | £271,795 | £281,075 | £287,662 | £292,824 | £298,870 | £325,193 | £305,312 | £303,464 | £355,503 | £346,730 | £395,114 | £385,817 |
| Paid-in Capital | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| Retained Earnings | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) | (£196,708) |
| Earnings | £0 | (£6,946) | (£12,144) | (£15,585) | (£17,270) | (£17,090) | (£12,439) | (£7,780) | (£3,113) | £7,972 | £21,553 | £42,608 | £66,089 |
| Total Capital | (£166,708) | (£173,654) | (£178,852) | (£182,293) | (£183,978) | (£183,798) | (£179,147) | (£174,488) | (£169,821) | (£158,736) | (£145,155) | (£124,100) | (£100,619) |
| Total Liabilities and Capital | £93,000 | £98,140 | £102,223 | £105,369 | £108,846 | £115,072 | £146,046 | £130,824 | £133,644 | £196,767 | £201,575 | £271,014 | £285,199 |
| Net Worth | (£166,708) | (£173,654) | (£178,852) | (£182,293) | (£183,978) | (£183,798) | (£179,147) | (£174,488) | (£169,821) | (£158,736) | (£145,155) | (£124,100) | (£100,619) |