| 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 | |||||||||||||
| D Putter | 0% | £0 | £9,552 | £10,507 | £8,358 | £9,154 | £10,029 | £11,064 | £12,178 | £7,960 | £8,756 | £9,631 | £10,586 |
| V Putter | 0% | £0 | £0 | £0 | £3,980 | £4,378 | £4,776 | £5,174 | £5,572 | £3,980 | £4,378 | £5,174 | £5,572 |
| W Putter | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,980 | £4,378 | £4,776 | £5,174 |
| Scorpion | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,980 | £4,378 |
| Total Sales | £0 | £9,552 | £10,507 | £12,338 | £13,532 | £14,805 | £16,238 | £17,750 | £15,920 | £17,512 | £23,561 | £25,710 | |
| 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 | |
| Putter Cost | £0 | £2,712 | £2,983 | £3,503 | £3,842 | £4,204 | £4,610 | £5,039 | £4,520 | £4,972 | £6,576 | £7,073 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £2,712 | £2,983 | £3,503 | £3,842 | £4,204 | £4,610 | £5,039 | £4,520 | £4,972 | £6,576 | £7,073 | |
| 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 | ||
| Randy Comstock | 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 |
| Alan Comstock | 0% | £500 | £500 | £500 | £747 | £771 | £796 | £825 | £855 | £818 | £850 | £971 | £1,014 |
| Van Russell | 0% | £900 | £1,378 | £1,425 | £1,517 | £1,577 | £1,640 | £1,712 | £1,788 | £1,696 | £1,776 | £2,078 | £2,186 |
| Total People | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £3,900 | £4,378 | £4,425 | £4,764 | £4,847 | £4,936 | £5,037 | £5,143 | £5,014 | £5,126 | £5,549 | £5,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 | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.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 | £9,552 | £10,507 | £12,338 | £13,532 | £14,805 | £16,238 | £17,750 | £15,920 | £17,512 | £23,561 | £25,710 | |
| Direct Cost of Sales | £0 | £2,712 | £2,983 | £3,503 | £3,842 | £4,204 | £4,610 | £5,039 | £4,520 | £4,972 | £6,576 | £7,073 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £2,712 | £2,983 | £3,503 | £3,842 | £4,204 | £4,610 | £5,039 | £4,520 | £4,972 | £6,576 | £7,073 | |
| Gross Margin | £0 | £6,840 | £7,524 | £8,835 | £9,690 | £10,601 | £11,628 | £12,711 | £11,400 | £12,540 | £16,985 | £18,637 | |
| Gross Margin % | 0.00% | 71.61% | 71.61% | 71.61% | 71.61% | 71.60% | 71.61% | 71.61% | 71.61% | 71.61% | 72.09% | 72.49% | |
| Expenses | |||||||||||||
| Payroll | £3,900 | £4,378 | £4,425 | £4,764 | £4,847 | £4,936 | £5,037 | £5,143 | £5,014 | £5,126 | £5,549 | £5,700 | |
| Sales and Marketing and Other Expenses | £900 | £900 | £900 | £1,300 | £1,200 | £1,200 | £1,200 | £1,200 | £2,600 | £2,100 | £2,200 | £2,200 | |
| Depreciation | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Rent | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | |
| Research and Development | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £0 | £0 | £0 | £0 | |
| Equipment Maintenance and Repair | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £365 | £365 | £365 | £365 | £365 | £365 | £365 | £365 | £365 | £365 | £365 | £365 | |
| Insurance | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Total Operating Expenses | £7,090 | £7,568 | £7,615 | £8,354 | £8,337 | £8,426 | £8,527 | £8,633 | £9,404 | £9,016 | £9,539 | £9,690 | |
| Profit Before Interest and Taxes | (£7,090) | (£728) | (£91) | £481 | £1,353 | £2,175 | £3,101 | £4,079 | £1,996 | £3,524 | £7,446 | £8,947 | |
| EBITDA | (£6,990) | (£628) | £9 | £581 | £1,453 | £2,275 | £3,201 | £4,179 | £2,096 | £3,624 | £7,546 | £9,047 | |
| Interest Expense | £574 | £568 | £562 | £556 | £550 | £544 | £538 | £532 | £526 | £520 | £514 | £508 | |
| Taxes Incurred | (£2,299) | (£389) | (£196) | (£22) | £241 | £489 | £769 | £1,064 | £441 | £901 | £2,080 | £2,532 | |
| Net Profit | (£5,365) | (£907) | (£457) | (£52) | £562 | £1,142 | £1,795 | £2,483 | £1,029 | £2,103 | £4,853 | £5,908 | |
| Net Profit/Sales | 0.00% | -9.49% | -4.35% | -0.42% | 4.15% | 7.71% | 11.05% | 13.99% | 6.46% | 12.01% | 20.60% | 22.98% | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cash from Receivables | £0 | £0 | £318 | £9,584 | £10,568 | £12,378 | £13,574 | £14,853 | £16,288 | £17,689 | £15,973 | £17,714 | |
| Subtotal Cash from Operations | £0 | £0 | £318 | £9,584 | £10,568 | £12,378 | £13,574 | £14,853 | £16,288 | £17,689 | £15,973 | £17,714 | |
| 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 | £318 | £9,584 | £10,568 | £12,378 | £13,574 | £14,853 | £16,288 | £17,689 | £15,973 | £17,714 | |
| 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 | £3,900 | £4,378 | £4,425 | £4,764 | £4,847 | £4,936 | £5,037 | £5,143 | £5,014 | £5,126 | £5,549 | £5,700 | |
| Bill Payments | £45 | £1,428 | £3,275 | £3,475 | £4,029 | £4,189 | £4,490 | £6,558 | £10,454 | £9,255 | £10,818 | £14,814 | |
| Subtotal Spent on Operations | £3,945 | £5,806 | £7,701 | £8,238 | £8,876 | £9,125 | £9,526 | £11,700 | £15,468 | £14,381 | £16,368 | £20,514 | |
| 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,208 | £1,208 | £1,208 | £1,208 | £1,208 | £1,208 | £1,208 | £1,208 | £1,208 | £1,208 | £1,208 | £1,208 | |
| 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 | £7,014 | £8,909 | £9,447 | £10,084 | £10,333 | £10,735 | £12,908 | £16,676 | £15,589 | £17,576 | £21,722 | |
| Net Cash Flow | (£5,154) | (£7,014) | (£8,591) | £137 | £484 | £2,044 | £2,840 | £1,944 | (£388) | £2,100 | (£1,603) | (£4,009) | |
| Cash Balance | £18,336 | £11,322 | £2,731 | £2,868 | £3,352 | £5,396 | £8,236 | £10,180 | £9,793 | £11,893 | £10,290 | £6,281 | |
| 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 | £23,490 | £18,336 | £11,322 | £2,731 | £2,868 | £3,352 | £5,396 | £8,236 | £10,180 | £9,793 | £11,893 | £10,290 | £6,281 |
| Accounts Receivable | £0 | £0 | £9,552 | £19,741 | £22,495 | £25,459 | £27,886 | £30,549 | £33,447 | £33,078 | £32,901 | £40,489 | £48,486 |
| Inventory | £25,200 | £25,200 | £22,488 | £19,505 | £16,002 | £12,160 | £7,956 | £5,071 | £5,543 | £4,972 | £5,469 | £7,234 | £7,780 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £48,690 | £43,536 | £43,362 | £41,977 | £41,365 | £40,971 | £41,238 | £43,857 | £49,170 | £47,843 | £50,263 | £58,013 | £62,547 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 |
| Accumulated Depreciation | £0 | £100 | £200 | £300 | £400 | £500 | £600 | £700 | £800 | £900 | £1,000 | £1,100 | £1,200 |
| Total Long-term Assets | £62,160 | £62,060 | £61,960 | £61,860 | £61,760 | £61,660 | £61,560 | £61,460 | £61,360 | £61,260 | £61,160 | £61,060 | £60,960 |
| Total Assets | £110,850 | £105,596 | £105,322 | £103,837 | £103,125 | £102,631 | £102,798 | £105,317 | £110,530 | £109,103 | £111,423 | £119,073 | £123,507 |
| 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 | £1,319 | £3,160 | £3,341 | £3,889 | £4,041 | £4,276 | £6,208 | £10,147 | £8,899 | £10,324 | £14,329 | £14,064 |
| 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 | £1,319 | £3,160 | £3,341 | £3,889 | £4,041 | £4,276 | £6,208 | £10,147 | £8,899 | £10,324 | £14,329 | £14,064 |
| Long-term Liabilities | £116,000 | £114,792 | £113,583 | £112,375 | £111,167 | £109,958 | £108,750 | £107,542 | £106,333 | £105,125 | £103,917 | £102,708 | £101,500 |
| Total Liabilities | £116,000 | £116,111 | £116,744 | £115,716 | £115,056 | £114,000 | £113,026 | £113,749 | £116,480 | £114,024 | £114,241 | £117,038 | £115,564 |
| Paid-in Capital | £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 |
| Retained Earnings | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) |
| Earnings | £0 | (£5,365) | (£6,272) | (£6,729) | (£6,781) | (£6,219) | (£5,077) | (£3,283) | (£800) | £229 | £2,332 | £7,185 | £13,093 |
| Total Capital | (£5,150) | (£10,515) | (£11,422) | (£11,879) | (£11,931) | (£11,369) | (£10,227) | (£8,433) | (£5,950) | (£4,921) | (£2,818) | £2,035 | £7,943 |
| Total Liabilities and Capital | £110,850 | £105,596 | £105,322 | £103,837 | £103,125 | £102,631 | £102,798 | £105,317 | £110,530 | £109,103 | £111,423 | £119,073 | £123,507 |
| Net Worth | (£5,150) | (£10,515) | (£11,422) | (£11,879) | (£11,931) | (£11,369) | (£10,227) | (£8,433) | (£5,950) | (£4,921) | (£2,818) | £2,035 | £7,943 |
| 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 | |||||||||||||
| D Putter | 0% | £0 | £9,552 | £10,507 | £8,358 | £9,154 | £10,029 | £11,064 | £12,178 | £7,960 | £8,756 | £9,631 | £10,586 |
| V Putter | 0% | £0 | £0 | £0 | £3,980 | £4,378 | £4,776 | £5,174 | £5,572 | £3,980 | £4,378 | £5,174 | £5,572 |
| W Putter | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,980 | £4,378 | £4,776 | £5,174 |
| Scorpion | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,980 | £4,378 |
| Total Sales | £0 | £9,552 | £10,507 | £12,338 | £13,532 | £14,805 | £16,238 | £17,750 | £15,920 | £17,512 | £23,561 | £25,710 | |
| 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 | |
| Putter Cost | £0 | £2,712 | £2,983 | £3,503 | £3,842 | £4,204 | £4,610 | £5,039 | £4,520 | £4,972 | £6,576 | £7,073 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £2,712 | £2,983 | £3,503 | £3,842 | £4,204 | £4,610 | £5,039 | £4,520 | £4,972 | £6,576 | £7,073 | |
| 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 | ||
| Randy Comstock | 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 |
| Alan Comstock | 0% | £500 | £500 | £500 | £747 | £771 | £796 | £825 | £855 | £818 | £850 | £971 | £1,014 |
| Van Russell | 0% | £900 | £1,378 | £1,425 | £1,517 | £1,577 | £1,640 | £1,712 | £1,788 | £1,696 | £1,776 | £2,078 | £2,186 |
| Total People | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £3,900 | £4,378 | £4,425 | £4,764 | £4,847 | £4,936 | £5,037 | £5,143 | £5,014 | £5,126 | £5,549 | £5,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 | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.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 | £9,552 | £10,507 | £12,338 | £13,532 | £14,805 | £16,238 | £17,750 | £15,920 | £17,512 | £23,561 | £25,710 | |
| Direct Cost of Sales | £0 | £2,712 | £2,983 | £3,503 | £3,842 | £4,204 | £4,610 | £5,039 | £4,520 | £4,972 | £6,576 | £7,073 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £2,712 | £2,983 | £3,503 | £3,842 | £4,204 | £4,610 | £5,039 | £4,520 | £4,972 | £6,576 | £7,073 | |
| Gross Margin | £0 | £6,840 | £7,524 | £8,835 | £9,690 | £10,601 | £11,628 | £12,711 | £11,400 | £12,540 | £16,985 | £18,637 | |
| Gross Margin % | 0.00% | 71.61% | 71.61% | 71.61% | 71.61% | 71.60% | 71.61% | 71.61% | 71.61% | 71.61% | 72.09% | 72.49% | |
| Expenses | |||||||||||||
| Payroll | £3,900 | £4,378 | £4,425 | £4,764 | £4,847 | £4,936 | £5,037 | £5,143 | £5,014 | £5,126 | £5,549 | £5,700 | |
| Sales and Marketing and Other Expenses | £900 | £900 | £900 | £1,300 | £1,200 | £1,200 | £1,200 | £1,200 | £2,600 | £2,100 | £2,200 | £2,200 | |
| Depreciation | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Rent | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | |
| Research and Development | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £0 | £0 | £0 | £0 | |
| Equipment Maintenance and Repair | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £365 | £365 | £365 | £365 | £365 | £365 | £365 | £365 | £365 | £365 | £365 | £365 | |
| Insurance | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Total Operating Expenses | £7,090 | £7,568 | £7,615 | £8,354 | £8,337 | £8,426 | £8,527 | £8,633 | £9,404 | £9,016 | £9,539 | £9,690 | |
| Profit Before Interest and Taxes | (£7,090) | (£728) | (£91) | £481 | £1,353 | £2,175 | £3,101 | £4,079 | £1,996 | £3,524 | £7,446 | £8,947 | |
| EBITDA | (£6,990) | (£628) | £9 | £581 | £1,453 | £2,275 | £3,201 | £4,179 | £2,096 | £3,624 | £7,546 | £9,047 | |
| Interest Expense | £574 | £568 | £562 | £556 | £550 | £544 | £538 | £532 | £526 | £520 | £514 | £508 | |
| Taxes Incurred | (£2,299) | (£389) | (£196) | (£22) | £241 | £489 | £769 | £1,064 | £441 | £901 | £2,080 | £2,532 | |
| Net Profit | (£5,365) | (£907) | (£457) | (£52) | £562 | £1,142 | £1,795 | £2,483 | £1,029 | £2,103 | £4,853 | £5,908 | |
| Net Profit/Sales | 0.00% | -9.49% | -4.35% | -0.42% | 4.15% | 7.71% | 11.05% | 13.99% | 6.46% | 12.01% | 20.60% | 22.98% | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cash from Receivables | £0 | £0 | £318 | £9,584 | £10,568 | £12,378 | £13,574 | £14,853 | £16,288 | £17,689 | £15,973 | £17,714 | |
| Subtotal Cash from Operations | £0 | £0 | £318 | £9,584 | £10,568 | £12,378 | £13,574 | £14,853 | £16,288 | £17,689 | £15,973 | £17,714 | |
| 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 | £318 | £9,584 | £10,568 | £12,378 | £13,574 | £14,853 | £16,288 | £17,689 | £15,973 | £17,714 | |
| 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 | £3,900 | £4,378 | £4,425 | £4,764 | £4,847 | £4,936 | £5,037 | £5,143 | £5,014 | £5,126 | £5,549 | £5,700 | |
| Bill Payments | £45 | £1,428 | £3,275 | £3,475 | £4,029 | £4,189 | £4,490 | £6,558 | £10,454 | £9,255 | £10,818 | £14,814 | |
| Subtotal Spent on Operations | £3,945 | £5,806 | £7,701 | £8,238 | £8,876 | £9,125 | £9,526 | £11,700 | £15,468 | £14,381 | £16,368 | £20,514 | |
| 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,208 | £1,208 | £1,208 | £1,208 | £1,208 | £1,208 | £1,208 | £1,208 | £1,208 | £1,208 | £1,208 | £1,208 | |
| 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 | £7,014 | £8,909 | £9,447 | £10,084 | £10,333 | £10,735 | £12,908 | £16,676 | £15,589 | £17,576 | £21,722 | |
| Net Cash Flow | (£5,154) | (£7,014) | (£8,591) | £137 | £484 | £2,044 | £2,840 | £1,944 | (£388) | £2,100 | (£1,603) | (£4,009) | |
| Cash Balance | £18,336 | £11,322 | £2,731 | £2,868 | £3,352 | £5,396 | £8,236 | £10,180 | £9,793 | £11,893 | £10,290 | £6,281 | |
| 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 | £23,490 | £18,336 | £11,322 | £2,731 | £2,868 | £3,352 | £5,396 | £8,236 | £10,180 | £9,793 | £11,893 | £10,290 | £6,281 |
| Accounts Receivable | £0 | £0 | £9,552 | £19,741 | £22,495 | £25,459 | £27,886 | £30,549 | £33,447 | £33,078 | £32,901 | £40,489 | £48,486 |
| Inventory | £25,200 | £25,200 | £22,488 | £19,505 | £16,002 | £12,160 | £7,956 | £5,071 | £5,543 | £4,972 | £5,469 | £7,234 | £7,780 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £48,690 | £43,536 | £43,362 | £41,977 | £41,365 | £40,971 | £41,238 | £43,857 | £49,170 | £47,843 | £50,263 | £58,013 | £62,547 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 | £62,160 |
| Accumulated Depreciation | £0 | £100 | £200 | £300 | £400 | £500 | £600 | £700 | £800 | £900 | £1,000 | £1,100 | £1,200 |
| Total Long-term Assets | £62,160 | £62,060 | £61,960 | £61,860 | £61,760 | £61,660 | £61,560 | £61,460 | £61,360 | £61,260 | £61,160 | £61,060 | £60,960 |
| Total Assets | £110,850 | £105,596 | £105,322 | £103,837 | £103,125 | £102,631 | £102,798 | £105,317 | £110,530 | £109,103 | £111,423 | £119,073 | £123,507 |
| 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 | £1,319 | £3,160 | £3,341 | £3,889 | £4,041 | £4,276 | £6,208 | £10,147 | £8,899 | £10,324 | £14,329 | £14,064 |
| 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 | £1,319 | £3,160 | £3,341 | £3,889 | £4,041 | £4,276 | £6,208 | £10,147 | £8,899 | £10,324 | £14,329 | £14,064 |
| Long-term Liabilities | £116,000 | £114,792 | £113,583 | £112,375 | £111,167 | £109,958 | £108,750 | £107,542 | £106,333 | £105,125 | £103,917 | £102,708 | £101,500 |
| Total Liabilities | £116,000 | £116,111 | £116,744 | £115,716 | £115,056 | £114,000 | £113,026 | £113,749 | £116,480 | £114,024 | £114,241 | £117,038 | £115,564 |
| Paid-in Capital | £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 |
| Retained Earnings | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) | (£15,150) |
| Earnings | £0 | (£5,365) | (£6,272) | (£6,729) | (£6,781) | (£6,219) | (£5,077) | (£3,283) | (£800) | £229 | £2,332 | £7,185 | £13,093 |
| Total Capital | (£5,150) | (£10,515) | (£11,422) | (£11,879) | (£11,931) | (£11,369) | (£10,227) | (£8,433) | (£5,950) | (£4,921) | (£2,818) | £2,035 | £7,943 |
| Total Liabilities and Capital | £110,850 | £105,596 | £105,322 | £103,837 | £103,125 | £102,631 | £102,798 | £105,317 | £110,530 | £109,103 | £111,423 | £119,073 | £123,507 |
| Net Worth | (£5,150) | (£10,515) | (£11,422) | (£11,879) | (£11,931) | (£11,369) | (£10,227) | (£8,433) | (£5,950) | (£4,921) | (£2,818) | £2,035 | £7,943 |