| 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 | |||||||||||||
| Corporations | 0% | £0 | £0 | £7,645 | £8,212 | £8,455 | £8,747 | £9,212 | £9,454 | £9,987 | £10,112 | £10,414 | £10,654 |
| Government Agencies | 0% | £0 | £0 | £8,774 | £9,454 | £9,746 | £10,096 | £10,654 | £10,945 | £11,584 | £11,734 | £12,097 | £12,385 |
| Other | 0% | £0 | £0 | £5,048 | £5,354 | £5,486 | £5,643 | £5,894 | £6,025 | £6,313 | £6,380 | £6,544 | £6,673 |
| Total Sales | £0 | £0 | £21,467 | £23,021 | £23,687 | £24,487 | £25,761 | £26,424 | £27,884 | £28,227 | £29,054 | £29,712 | |
| 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 | |
| Corporations | £0 | £0 | £3,669 | £4,038 | £4,196 | £4,386 | £4,688 | £4,845 | £5,192 | £5,273 | £5,469 | £5,625 | |
| Government Agencies | £0 | £0 | £4,403 | £4,845 | £5,035 | £5,263 | £5,625 | £5,814 | £6,230 | £6,327 | £6,563 | £6,750 | |
| Other | £0 | £0 | £1,981 | £2,180 | £2,266 | £2,368 | £2,531 | £2,616 | £2,803 | £2,847 | £2,953 | £3,038 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £10,054 | £11,064 | £11,496 | £12,016 | £12,845 | £13,276 | £14,225 | £14,447 | £14,985 | £15,413 | |
| 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 | ||
| Stan | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Willma | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Sales | 0% | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Sales | 0% | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Accounting | 0% | £0 | £0 | £0 | £0 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 |
| Shipping | 0% | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Shipping | 0% | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Shipping | 0% | £0 | £0 | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Admin/customer support | 0% | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Admin/customer support | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £800 | £800 | £800 | £800 | £800 | £800 |
| Total People | 0 | 0 | 5 | 5 | 8 | 9 | 11 | 11 | 11 | 11 | 11 | 11 | |
| Total Payroll | £0 | £0 | £8,000 | £8,000 | £11,800 | £12,800 | £15,100 | £15,100 | £15,100 | £15,100 | £15,100 | £15,100 | |
| 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 | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | |
| Long-term Interest Rate | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.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 | £0 | £0 | £21,467 | £23,021 | £23,687 | £24,487 | £25,761 | £26,424 | £27,884 | £28,227 | £29,054 | £29,712 | |
| Direct Cost of Sales | £0 | £0 | £10,054 | £11,064 | £11,496 | £12,016 | £12,845 | £13,276 | £14,225 | £14,447 | £14,985 | £15,413 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £10,054 | £11,064 | £11,496 | £12,016 | £12,845 | £13,276 | £14,225 | £14,447 | £14,985 | £15,413 | |
| Gross Margin | £0 | £0 | £11,414 | £11,957 | £12,190 | £12,470 | £12,916 | £13,148 | £13,660 | £13,779 | £14,069 | £14,299 | |
| Gross Margin % | 0.00% | 0.00% | 53.17% | 51.94% | 51.46% | 50.93% | 50.14% | 49.76% | 48.99% | 48.82% | 48.42% | 48.13% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £8,000 | £8,000 | £11,800 | £12,800 | £15,100 | £15,100 | £15,100 | £15,100 | £15,100 | £15,100 | |
| Sales and Marketing and Other Expenses | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Depreciation | £725 | £725 | £725 | £725 | £725 | £725 | £725 | £725 | £725 | £725 | £725 | £725 | |
| Rent | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Utilities | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 15% | £0 | £0 | £1,200 | £1,200 | £1,770 | £1,920 | £2,265 | £2,265 | £2,265 | £2,265 | £2,265 | £2,265 |
| Website Maintenance | £0 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Total Operating Expenses | £2,625 | £3,125 | £12,325 | £12,325 | £16,695 | £17,845 | £20,490 | £20,490 | £20,490 | £20,490 | £20,490 | £20,490 | |
| Profit Before Interest and Taxes | (£2,625) | (£3,125) | (£911) | (£368) | (£4,505) | (£5,375) | (£7,574) | (£7,342) | (£6,830) | (£6,711) | (£6,421) | (£6,191) | |
| EBITDA | (£1,900) | (£2,400) | (£186) | £357 | (£3,780) | (£4,650) | (£6,849) | (£6,617) | (£6,105) | (£5,986) | (£5,696) | (£5,466) | |
| Interest Expense | £332 | £330 | £328 | £326 | £324 | £322 | £320 | £318 | £316 | £315 | £313 | £311 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£2,957) | (£3,455) | (£1,239) | (£694) | (£4,829) | (£5,697) | (£7,894) | (£7,660) | (£7,147) | (£7,025) | (£6,734) | (£6,501) | |
| Net Profit/Sales | 0.00% | 0.00% | -5.77% | -3.01% | -20.39% | -23.26% | -30.64% | -28.99% | -25.63% | -24.89% | -23.18% | -21.88% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £0 | £0 | £5,367 | £5,755 | £5,922 | £6,122 | £6,440 | £6,606 | £6,971 | £7,057 | £7,264 | £7,428 | |
| Cash from Receivables | £0 | £0 | £0 | £537 | £16,139 | £17,282 | £17,785 | £18,397 | £19,337 | £19,854 | £20,922 | £21,191 | |
| Subtotal Cash from Operations | £0 | £0 | £5,367 | £6,292 | £22,061 | £23,404 | £24,225 | £25,003 | £26,308 | £26,911 | £28,185 | £28,619 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £0 | £5,367 | £6,292 | £22,061 | £23,404 | £24,225 | £25,003 | £26,308 | £26,911 | £28,185 | £28,619 | |
| 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 | £0 | £0 | £8,000 | £8,000 | £11,800 | £12,800 | £15,100 | £15,100 | £15,100 | £15,100 | £15,100 | £15,100 | |
| Bill Payments | £74 | £2,248 | £2,770 | £3,928 | £3,945 | £4,854 | £15,401 | £18,659 | £18,739 | £20,139 | £19,678 | £20,511 | |
| Subtotal Spent on Operations | £74 | £2,248 | £10,770 | £11,928 | £15,745 | £17,654 | £30,501 | £33,759 | £33,839 | £35,239 | £34,778 | £35,611 | |
| 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 | £273 | £275 | £277 | £279 | £281 | £283 | £284 | £286 | £288 | £290 | £292 | £294 | |
| 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 | £348 | £2,523 | £11,047 | £12,207 | £16,026 | £17,936 | £30,785 | £34,045 | £34,127 | £35,529 | £35,070 | £35,905 | |
| Net Cash Flow | (£348) | (£2,523) | (£5,680) | (£5,915) | £6,035 | £5,468 | (£6,560) | (£9,043) | (£7,819) | (£8,618) | (£6,885) | (£7,286) | |
| Cash Balance | £128,352 | £125,829 | £120,149 | £114,235 | £120,270 | £125,738 | £119,177 | £110,135 | £102,316 | £93,698 | £86,814 | £79,527 | |
| 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 | £128,700 | £128,352 | £125,829 | £120,149 | £114,235 | £120,270 | £125,738 | £119,177 | £110,135 | £102,316 | £93,698 | £86,814 | £79,527 |
| Other Current Assets | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Total Current Assets | £178,200 | £177,852 | £175,329 | £175,696 | £175,447 | £171,612 | £176,792 | £172,596 | £165,405 | £160,112 | £153,032 | £147,554 | £141,788 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 |
| Accumulated Depreciation | £0 | £725 | £1,450 | £2,175 | £2,900 | £3,625 | £4,350 | £5,075 | £5,800 | £6,525 | £7,250 | £7,975 | £8,700 |
| Total Long-term Assets | £43,500 | £42,775 | £42,050 | £41,325 | £40,600 | £39,875 | £39,150 | £38,425 | £37,700 | £36,975 | £36,250 | £35,525 | £34,800 |
| Total Assets | £221,700 | £220,627 | £217,379 | £217,021 | £216,047 | £211,487 | £215,942 | £211,021 | £203,105 | £197,087 | £189,282 | £183,079 | £176,588 |
| 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 | £2,157 | £2,639 | £3,797 | £3,795 | £4,344 | £14,779 | £18,036 | £18,067 | £19,484 | £18,995 | £19,817 | £20,122 |
| 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 | £2,157 | £2,639 | £3,797 | £3,795 | £4,344 | £14,779 | £18,036 | £18,067 | £19,484 | £18,995 | £19,817 | £20,122 |
| Long-term Liabilities | £50,000 | £49,727 | £49,452 | £49,175 | £48,896 | £48,615 | £48,333 | £48,048 | £47,762 | £47,474 | £47,183 | £46,891 | £46,597 |
| Total Liabilities | £50,000 | £51,884 | £52,090 | £52,972 | £52,691 | £52,959 | £63,112 | £66,084 | £65,829 | £66,957 | £66,178 | £66,709 | £66,719 |
| Paid-in Capital | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 |
| Retained Earnings | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) |
| Earnings | £0 | (£2,957) | (£6,411) | (£7,650) | (£8,344) | (£13,173) | (£18,870) | (£26,764) | (£34,424) | (£41,571) | (£48,596) | (£55,329) | (£61,831) |
| Total Capital | £171,700 | £168,743 | £165,289 | £164,050 | £163,356 | £158,527 | £152,830 | £144,936 | £137,276 | £130,129 | £123,104 | £116,371 | £109,869 |
| Total Liabilities and Capital | £221,700 | £220,627 | £217,379 | £217,021 | £216,047 | £211,487 | £215,942 | £211,021 | £203,105 | £197,087 | £189,282 | £183,079 | £176,588 |
| Net Worth | £171,700 | £168,743 | £165,289 | £164,050 | £163,356 | £158,527 | £152,830 | £144,936 | £137,276 | £130,129 | £123,104 | £116,371 | £109,869 |
| 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 | |||||||||||||
| Corporations | 0% | £0 | £0 | £7,645 | £8,212 | £8,455 | £8,747 | £9,212 | £9,454 | £9,987 | £10,112 | £10,414 | £10,654 |
| Government Agencies | 0% | £0 | £0 | £8,774 | £9,454 | £9,746 | £10,096 | £10,654 | £10,945 | £11,584 | £11,734 | £12,097 | £12,385 |
| Other | 0% | £0 | £0 | £5,048 | £5,354 | £5,486 | £5,643 | £5,894 | £6,025 | £6,313 | £6,380 | £6,544 | £6,673 |
| Total Sales | £0 | £0 | £21,467 | £23,021 | £23,687 | £24,487 | £25,761 | £26,424 | £27,884 | £28,227 | £29,054 | £29,712 | |
| 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 | |
| Corporations | £0 | £0 | £3,669 | £4,038 | £4,196 | £4,386 | £4,688 | £4,845 | £5,192 | £5,273 | £5,469 | £5,625 | |
| Government Agencies | £0 | £0 | £4,403 | £4,845 | £5,035 | £5,263 | £5,625 | £5,814 | £6,230 | £6,327 | £6,563 | £6,750 | |
| Other | £0 | £0 | £1,981 | £2,180 | £2,266 | £2,368 | £2,531 | £2,616 | £2,803 | £2,847 | £2,953 | £3,038 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £10,054 | £11,064 | £11,496 | £12,016 | £12,845 | £13,276 | £14,225 | £14,447 | £14,985 | £15,413 | |
| 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 | ||
| Stan | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Willma | 0% | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Sales | 0% | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Sales | 0% | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Accounting | 0% | £0 | £0 | £0 | £0 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 |
| Shipping | 0% | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Shipping | 0% | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Shipping | 0% | £0 | £0 | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Admin/customer support | 0% | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Admin/customer support | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £800 | £800 | £800 | £800 | £800 | £800 |
| Total People | 0 | 0 | 5 | 5 | 8 | 9 | 11 | 11 | 11 | 11 | 11 | 11 | |
| Total Payroll | £0 | £0 | £8,000 | £8,000 | £11,800 | £12,800 | £15,100 | £15,100 | £15,100 | £15,100 | £15,100 | £15,100 | |
| 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 | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | |
| Long-term Interest Rate | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.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 | £0 | £0 | £21,467 | £23,021 | £23,687 | £24,487 | £25,761 | £26,424 | £27,884 | £28,227 | £29,054 | £29,712 | |
| Direct Cost of Sales | £0 | £0 | £10,054 | £11,064 | £11,496 | £12,016 | £12,845 | £13,276 | £14,225 | £14,447 | £14,985 | £15,413 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £10,054 | £11,064 | £11,496 | £12,016 | £12,845 | £13,276 | £14,225 | £14,447 | £14,985 | £15,413 | |
| Gross Margin | £0 | £0 | £11,414 | £11,957 | £12,190 | £12,470 | £12,916 | £13,148 | £13,660 | £13,779 | £14,069 | £14,299 | |
| Gross Margin % | 0.00% | 0.00% | 53.17% | 51.94% | 51.46% | 50.93% | 50.14% | 49.76% | 48.99% | 48.82% | 48.42% | 48.13% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £8,000 | £8,000 | £11,800 | £12,800 | £15,100 | £15,100 | £15,100 | £15,100 | £15,100 | £15,100 | |
| Sales and Marketing and Other Expenses | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Depreciation | £725 | £725 | £725 | £725 | £725 | £725 | £725 | £725 | £725 | £725 | £725 | £725 | |
| Rent | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Utilities | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 15% | £0 | £0 | £1,200 | £1,200 | £1,770 | £1,920 | £2,265 | £2,265 | £2,265 | £2,265 | £2,265 | £2,265 |
| Website Maintenance | £0 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Total Operating Expenses | £2,625 | £3,125 | £12,325 | £12,325 | £16,695 | £17,845 | £20,490 | £20,490 | £20,490 | £20,490 | £20,490 | £20,490 | |
| Profit Before Interest and Taxes | (£2,625) | (£3,125) | (£911) | (£368) | (£4,505) | (£5,375) | (£7,574) | (£7,342) | (£6,830) | (£6,711) | (£6,421) | (£6,191) | |
| EBITDA | (£1,900) | (£2,400) | (£186) | £357 | (£3,780) | (£4,650) | (£6,849) | (£6,617) | (£6,105) | (£5,986) | (£5,696) | (£5,466) | |
| Interest Expense | £332 | £330 | £328 | £326 | £324 | £322 | £320 | £318 | £316 | £315 | £313 | £311 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£2,957) | (£3,455) | (£1,239) | (£694) | (£4,829) | (£5,697) | (£7,894) | (£7,660) | (£7,147) | (£7,025) | (£6,734) | (£6,501) | |
| Net Profit/Sales | 0.00% | 0.00% | -5.77% | -3.01% | -20.39% | -23.26% | -30.64% | -28.99% | -25.63% | -24.89% | -23.18% | -21.88% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £0 | £0 | £5,367 | £5,755 | £5,922 | £6,122 | £6,440 | £6,606 | £6,971 | £7,057 | £7,264 | £7,428 | |
| Cash from Receivables | £0 | £0 | £0 | £537 | £16,139 | £17,282 | £17,785 | £18,397 | £19,337 | £19,854 | £20,922 | £21,191 | |
| Subtotal Cash from Operations | £0 | £0 | £5,367 | £6,292 | £22,061 | £23,404 | £24,225 | £25,003 | £26,308 | £26,911 | £28,185 | £28,619 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £0 | £5,367 | £6,292 | £22,061 | £23,404 | £24,225 | £25,003 | £26,308 | £26,911 | £28,185 | £28,619 | |
| 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 | £0 | £0 | £8,000 | £8,000 | £11,800 | £12,800 | £15,100 | £15,100 | £15,100 | £15,100 | £15,100 | £15,100 | |
| Bill Payments | £74 | £2,248 | £2,770 | £3,928 | £3,945 | £4,854 | £15,401 | £18,659 | £18,739 | £20,139 | £19,678 | £20,511 | |
| Subtotal Spent on Operations | £74 | £2,248 | £10,770 | £11,928 | £15,745 | £17,654 | £30,501 | £33,759 | £33,839 | £35,239 | £34,778 | £35,611 | |
| 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 | £273 | £275 | £277 | £279 | £281 | £283 | £284 | £286 | £288 | £290 | £292 | £294 | |
| 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 | £348 | £2,523 | £11,047 | £12,207 | £16,026 | £17,936 | £30,785 | £34,045 | £34,127 | £35,529 | £35,070 | £35,905 | |
| Net Cash Flow | (£348) | (£2,523) | (£5,680) | (£5,915) | £6,035 | £5,468 | (£6,560) | (£9,043) | (£7,819) | (£8,618) | (£6,885) | (£7,286) | |
| Cash Balance | £128,352 | £125,829 | £120,149 | £114,235 | £120,270 | £125,738 | £119,177 | £110,135 | £102,316 | £93,698 | £86,814 | £79,527 | |
| 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 | £128,700 | £128,352 | £125,829 | £120,149 | £114,235 | £120,270 | £125,738 | £119,177 | £110,135 | £102,316 | £93,698 | £86,814 | £79,527 |
| Other Current Assets | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Total Current Assets | £178,200 | £177,852 | £175,329 | £175,696 | £175,447 | £171,612 | £176,792 | £172,596 | £165,405 | £160,112 | £153,032 | £147,554 | £141,788 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 | £43,500 |
| Accumulated Depreciation | £0 | £725 | £1,450 | £2,175 | £2,900 | £3,625 | £4,350 | £5,075 | £5,800 | £6,525 | £7,250 | £7,975 | £8,700 |
| Total Long-term Assets | £43,500 | £42,775 | £42,050 | £41,325 | £40,600 | £39,875 | £39,150 | £38,425 | £37,700 | £36,975 | £36,250 | £35,525 | £34,800 |
| Total Assets | £221,700 | £220,627 | £217,379 | £217,021 | £216,047 | £211,487 | £215,942 | £211,021 | £203,105 | £197,087 | £189,282 | £183,079 | £176,588 |
| 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 | £2,157 | £2,639 | £3,797 | £3,795 | £4,344 | £14,779 | £18,036 | £18,067 | £19,484 | £18,995 | £19,817 | £20,122 |
| 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 | £2,157 | £2,639 | £3,797 | £3,795 | £4,344 | £14,779 | £18,036 | £18,067 | £19,484 | £18,995 | £19,817 | £20,122 |
| Long-term Liabilities | £50,000 | £49,727 | £49,452 | £49,175 | £48,896 | £48,615 | £48,333 | £48,048 | £47,762 | £47,474 | £47,183 | £46,891 | £46,597 |
| Total Liabilities | £50,000 | £51,884 | £52,090 | £52,972 | £52,691 | £52,959 | £63,112 | £66,084 | £65,829 | £66,957 | £66,178 | £66,709 | £66,719 |
| Paid-in Capital | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 | £213,000 |
| Retained Earnings | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) | (£41,300) |
| Earnings | £0 | (£2,957) | (£6,411) | (£7,650) | (£8,344) | (£13,173) | (£18,870) | (£26,764) | (£34,424) | (£41,571) | (£48,596) | (£55,329) | (£61,831) |
| Total Capital | £171,700 | £168,743 | £165,289 | £164,050 | £163,356 | £158,527 | £152,830 | £144,936 | £137,276 | £130,129 | £123,104 | £116,371 | £109,869 |
| Total Liabilities and Capital | £221,700 | £220,627 | £217,379 | £217,021 | £216,047 | £211,487 | £215,942 | £211,021 | £203,105 | £197,087 | £189,282 | £183,079 | £176,588 |
| Net Worth | £171,700 | £168,743 | £165,289 | £164,050 | £163,356 | £158,527 | £152,830 | £144,936 | £137,276 | £130,129 | £123,104 | £116,371 | £109,869 |