| 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 | |||||||||||||
| Doggie care hours (all inclusive) | 20% | £5,125 | £5,395 | £6,835 | £12,595 | £9,265 | £7,825 | £8,095 | £8,635 | £11,245 | £15,714 | £20,395 | £24,355 |
| Other | 20% | £765 | £585 | £705 | £1,215 | £585 | £705 | £1,215 | £1,095 | £1,305 | £1,785 | £2,055 | £2,235 |
| Total Sales | £5,890 | £5,980 | £7,540 | £13,810 | £9,850 | £8,530 | £9,310 | £9,730 | £12,550 | £17,499 | £22,450 | £26,590 | |
| 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 | |
| Doggie care hours (all inclusive) | 10% | £513 | £540 | £684 | £1,260 | £927 | £783 | £810 | £864 | £1,125 | £1,571 | £2,040 | £2,436 |
| Other | 35% | £268 | £205 | £247 | £425 | £205 | £247 | £425 | £383 | £457 | £625 | £719 | £782 |
| Subtotal Direct Cost of Sales | £780 | £744 | £930 | £1,685 | £1,131 | £1,029 | £1,235 | £1,247 | £1,581 | £2,196 | £2,759 | £3,218 | |
| 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 | ||
| Dog care assistants/groomers | 0% | £3,200 | £3,200 | £3,200 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £6,400 | £6,400 |
| Admin/etc. | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £1,200 | £1,200 | £1,200 | £1,200 |
| Total People | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 6 | 6 | |
| Total Payroll | £3,700 | £3,700 | £3,700 | £5,300 | £5,300 | £5,300 | £5,300 | £5,300 | £6,000 | £6,000 | £7,600 | £7,600 | |
| 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% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £5,890 | £5,980 | £7,540 | £13,810 | £9,850 | £8,530 | £9,310 | £9,730 | £12,550 | £17,499 | £22,450 | £26,590 | |
| Direct Cost of Sales | £780 | £744 | £930 | £1,685 | £1,131 | £1,029 | £1,235 | £1,247 | £1,581 | £2,196 | £2,759 | £3,218 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £780 | £744 | £930 | £1,685 | £1,131 | £1,029 | £1,235 | £1,247 | £1,581 | £2,196 | £2,759 | £3,218 | |
| Gross Margin | £5,110 | £5,236 | £6,610 | £12,125 | £8,719 | £7,501 | £8,075 | £8,483 | £10,969 | £15,303 | £19,691 | £23,372 | |
| Gross Margin % | 86.75% | 87.55% | 87.66% | 87.80% | 88.52% | 87.93% | 86.74% | 87.19% | 87.40% | 87.45% | 87.71% | 87.90% | |
| Expenses | |||||||||||||
| Payroll | £3,700 | £3,700 | £3,700 | £5,300 | £5,300 | £5,300 | £5,300 | £5,300 | £6,000 | £6,000 | £7,600 | £7,600 | |
| Sales and Marketing and Other Expenses | £3,000 | £2,000 | £2,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £750 | £750 | £750 | £750 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £200 | £200 | £200 | £225 | £225 | £225 | £225 | £225 | £250 | £250 | £250 | £250 | |
| Insurance | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Rent | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Payroll Taxes | 15% | £555 | £555 | £555 | £795 | £795 | £795 | £795 | £795 | £900 | £900 | £1,140 | £1,140 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £10,455 | £9,455 | £9,455 | £10,320 | £10,320 | £10,320 | £10,320 | £10,320 | £10,900 | £10,900 | £12,740 | £12,740 | |
| Profit Before Interest and Taxes | (£5,345) | (£4,219) | (£2,845) | £1,805 | (£1,601) | (£2,819) | (£2,245) | (£1,837) | £69 | £4,403 | £6,951 | £10,632 | |
| EBITDA | (£5,345) | (£4,219) | (£2,845) | £1,805 | (£1,601) | (£2,819) | (£2,245) | (£1,837) | £69 | £4,403 | £6,951 | £10,632 | |
| Interest Expense | £325 | £316 | £308 | £299 | £291 | £282 | £273 | £264 | £255 | £246 | £237 | £228 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£5,670) | (£4,536) | (£3,153) | £1,506 | (£1,892) | (£3,101) | (£2,518) | (£2,101) | (£186) | £4,157 | £6,714 | £10,405 | |
| Net Profit/Sales | -96.27% | -75.85% | -41.82% | 10.90% | -19.21% | -36.36% | -27.04% | -21.59% | -1.49% | 23.75% | 29.91% | 39.13% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £5,890 | £5,980 | £7,540 | £13,810 | £9,850 | £8,530 | £9,310 | £9,730 | £12,550 | £17,499 | £22,450 | £26,590 | |
| Subtotal Cash from Operations | £5,890 | £5,980 | £7,540 | £13,810 | £9,850 | £8,530 | £9,310 | £9,730 | £12,550 | £17,499 | £22,450 | £26,590 | |
| 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 | £10,000 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £5,890 | £5,980 | £7,540 | £13,810 | £9,850 | £8,530 | £19,310 | £9,730 | £12,550 | £17,499 | £22,450 | £26,590 | |
| 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,700 | £3,700 | £3,700 | £5,300 | £5,300 | £5,300 | £5,300 | £5,300 | £6,000 | £6,000 | £7,600 | £7,600 | |
| Bill Payments | £262 | £7,825 | £6,822 | £6,994 | £6,985 | £6,438 | £6,338 | £6,528 | £6,538 | £6,757 | £7,369 | £8,151 | |
| Subtotal Spent on Operations | £3,962 | £11,525 | £10,522 | £12,294 | £12,285 | £11,738 | £11,638 | £11,828 | £12,538 | £12,757 | £14,969 | £15,751 | |
| 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 | £1,009 | £1,017 | £1,025 | £1,034 | £1,043 | £1,051 | £1,060 | £1,069 | £1,078 | £1,087 | £1,096 | £1,105 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £10,000 | |
| 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 | £4,971 | £12,542 | £11,547 | £13,328 | £13,328 | £12,789 | £12,698 | £12,897 | £13,616 | £13,843 | £16,065 | £26,856 | |
| Net Cash Flow | £919 | (£6,562) | (£4,007) | £482 | (£3,478) | (£4,259) | £6,612 | (£3,167) | (£1,066) | £3,656 | £6,385 | (£266) | |
| Cash Balance | £20,919 | £14,357 | £10,350 | £10,832 | £7,355 | £3,095 | £9,707 | £6,541 | £5,475 | £9,131 | £15,516 | £15,251 | |
| 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 | £20,000 | £20,919 | £14,357 | £10,350 | £10,832 | £7,355 | £3,095 | £9,707 | £6,541 | £5,475 | £9,131 | £15,516 | £15,251 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £20,000 | £20,919 | £14,357 | £10,350 | £10,832 | £7,355 | £3,095 | £9,707 | £6,541 | £5,475 | £9,131 | £15,516 | £15,251 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 |
| Total Assets | £27,500 | £28,419 | £21,857 | £17,850 | £18,332 | £14,855 | £10,595 | £17,207 | £14,041 | £12,975 | £16,631 | £23,016 | £22,751 |
| 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 | £7,598 | £6,589 | £6,760 | £6,771 | £6,227 | £6,120 | £6,310 | £6,313 | £6,512 | £7,097 | £7,864 | £8,299 |
| Current Borrowing | £40,000 | £38,991 | £37,974 | £36,949 | £35,915 | £34,872 | £33,821 | £32,761 | £31,692 | £30,614 | £29,528 | £28,432 | £27,327 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £0 |
| Subtotal Current Liabilities | £40,000 | £46,590 | £44,563 | £43,709 | £42,686 | £41,100 | £39,941 | £49,071 | £48,005 | £47,126 | £46,625 | £46,296 | £35,626 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £40,000 | £46,590 | £44,563 | £43,709 | £42,686 | £41,100 | £39,941 | £49,071 | £48,005 | £47,126 | £46,625 | £46,296 | £35,626 |
| Paid-in Capital | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Retained Earnings | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) |
| Earnings | £0 | (£5,670) | (£10,206) | (£13,359) | (£11,853) | (£13,745) | (£16,846) | (£19,364) | (£21,465) | (£21,651) | (£17,494) | (£10,780) | (£375) |
| Total Capital | (£12,500) | (£18,170) | (£22,706) | (£25,859) | (£24,353) | (£26,245) | (£29,346) | (£31,864) | (£33,965) | (£34,151) | (£29,994) | (£23,280) | (£12,875) |
| Total Liabilities and Capital | £27,500 | £28,419 | £21,857 | £17,850 | £18,332 | £14,855 | £10,595 | £17,207 | £14,041 | £12,975 | £16,631 | £23,016 | £22,751 |
| Net Worth | (£12,500) | (£18,170) | (£22,706) | (£25,859) | (£24,353) | (£26,245) | (£29,346) | (£31,864) | (£33,965) | (£34,151) | (£29,994) | (£23,280) | (£12,875) |
| 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 | |||||||||||||
| Doggie care hours (all inclusive) | 20% | £5,125 | £5,395 | £6,835 | £12,595 | £9,265 | £7,825 | £8,095 | £8,635 | £11,245 | £15,714 | £20,395 | £24,355 |
| Other | 20% | £765 | £585 | £705 | £1,215 | £585 | £705 | £1,215 | £1,095 | £1,305 | £1,785 | £2,055 | £2,235 |
| Total Sales | £5,890 | £5,980 | £7,540 | £13,810 | £9,850 | £8,530 | £9,310 | £9,730 | £12,550 | £17,499 | £22,450 | £26,590 | |
| 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 | |
| Doggie care hours (all inclusive) | 10% | £513 | £540 | £684 | £1,260 | £927 | £783 | £810 | £864 | £1,125 | £1,571 | £2,040 | £2,436 |
| Other | 35% | £268 | £205 | £247 | £425 | £205 | £247 | £425 | £383 | £457 | £625 | £719 | £782 |
| Subtotal Direct Cost of Sales | £780 | £744 | £930 | £1,685 | £1,131 | £1,029 | £1,235 | £1,247 | £1,581 | £2,196 | £2,759 | £3,218 | |
| 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 | ||
| Dog care assistants/groomers | 0% | £3,200 | £3,200 | £3,200 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £6,400 | £6,400 |
| Admin/etc. | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £1,200 | £1,200 | £1,200 | £1,200 |
| Total People | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 6 | 6 | |
| Total Payroll | £3,700 | £3,700 | £3,700 | £5,300 | £5,300 | £5,300 | £5,300 | £5,300 | £6,000 | £6,000 | £7,600 | £7,600 | |
| 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% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £5,890 | £5,980 | £7,540 | £13,810 | £9,850 | £8,530 | £9,310 | £9,730 | £12,550 | £17,499 | £22,450 | £26,590 | |
| Direct Cost of Sales | £780 | £744 | £930 | £1,685 | £1,131 | £1,029 | £1,235 | £1,247 | £1,581 | £2,196 | £2,759 | £3,218 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £780 | £744 | £930 | £1,685 | £1,131 | £1,029 | £1,235 | £1,247 | £1,581 | £2,196 | £2,759 | £3,218 | |
| Gross Margin | £5,110 | £5,236 | £6,610 | £12,125 | £8,719 | £7,501 | £8,075 | £8,483 | £10,969 | £15,303 | £19,691 | £23,372 | |
| Gross Margin % | 86.75% | 87.55% | 87.66% | 87.80% | 88.52% | 87.93% | 86.74% | 87.19% | 87.40% | 87.45% | 87.71% | 87.90% | |
| Expenses | |||||||||||||
| Payroll | £3,700 | £3,700 | £3,700 | £5,300 | £5,300 | £5,300 | £5,300 | £5,300 | £6,000 | £6,000 | £7,600 | £7,600 | |
| Sales and Marketing and Other Expenses | £3,000 | £2,000 | £2,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £750 | £750 | £750 | £750 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £200 | £200 | £200 | £225 | £225 | £225 | £225 | £225 | £250 | £250 | £250 | £250 | |
| Insurance | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Rent | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Payroll Taxes | 15% | £555 | £555 | £555 | £795 | £795 | £795 | £795 | £795 | £900 | £900 | £1,140 | £1,140 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £10,455 | £9,455 | £9,455 | £10,320 | £10,320 | £10,320 | £10,320 | £10,320 | £10,900 | £10,900 | £12,740 | £12,740 | |
| Profit Before Interest and Taxes | (£5,345) | (£4,219) | (£2,845) | £1,805 | (£1,601) | (£2,819) | (£2,245) | (£1,837) | £69 | £4,403 | £6,951 | £10,632 | |
| EBITDA | (£5,345) | (£4,219) | (£2,845) | £1,805 | (£1,601) | (£2,819) | (£2,245) | (£1,837) | £69 | £4,403 | £6,951 | £10,632 | |
| Interest Expense | £325 | £316 | £308 | £299 | £291 | £282 | £273 | £264 | £255 | £246 | £237 | £228 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£5,670) | (£4,536) | (£3,153) | £1,506 | (£1,892) | (£3,101) | (£2,518) | (£2,101) | (£186) | £4,157 | £6,714 | £10,405 | |
| Net Profit/Sales | -96.27% | -75.85% | -41.82% | 10.90% | -19.21% | -36.36% | -27.04% | -21.59% | -1.49% | 23.75% | 29.91% | 39.13% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £5,890 | £5,980 | £7,540 | £13,810 | £9,850 | £8,530 | £9,310 | £9,730 | £12,550 | £17,499 | £22,450 | £26,590 | |
| Subtotal Cash from Operations | £5,890 | £5,980 | £7,540 | £13,810 | £9,850 | £8,530 | £9,310 | £9,730 | £12,550 | £17,499 | £22,450 | £26,590 | |
| 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 | £10,000 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £5,890 | £5,980 | £7,540 | £13,810 | £9,850 | £8,530 | £19,310 | £9,730 | £12,550 | £17,499 | £22,450 | £26,590 | |
| 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,700 | £3,700 | £3,700 | £5,300 | £5,300 | £5,300 | £5,300 | £5,300 | £6,000 | £6,000 | £7,600 | £7,600 | |
| Bill Payments | £262 | £7,825 | £6,822 | £6,994 | £6,985 | £6,438 | £6,338 | £6,528 | £6,538 | £6,757 | £7,369 | £8,151 | |
| Subtotal Spent on Operations | £3,962 | £11,525 | £10,522 | £12,294 | £12,285 | £11,738 | £11,638 | £11,828 | £12,538 | £12,757 | £14,969 | £15,751 | |
| 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 | £1,009 | £1,017 | £1,025 | £1,034 | £1,043 | £1,051 | £1,060 | £1,069 | £1,078 | £1,087 | £1,096 | £1,105 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £10,000 | |
| 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 | £4,971 | £12,542 | £11,547 | £13,328 | £13,328 | £12,789 | £12,698 | £12,897 | £13,616 | £13,843 | £16,065 | £26,856 | |
| Net Cash Flow | £919 | (£6,562) | (£4,007) | £482 | (£3,478) | (£4,259) | £6,612 | (£3,167) | (£1,066) | £3,656 | £6,385 | (£266) | |
| Cash Balance | £20,919 | £14,357 | £10,350 | £10,832 | £7,355 | £3,095 | £9,707 | £6,541 | £5,475 | £9,131 | £15,516 | £15,251 | |
| 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 | £20,000 | £20,919 | £14,357 | £10,350 | £10,832 | £7,355 | £3,095 | £9,707 | £6,541 | £5,475 | £9,131 | £15,516 | £15,251 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £20,000 | £20,919 | £14,357 | £10,350 | £10,832 | £7,355 | £3,095 | £9,707 | £6,541 | £5,475 | £9,131 | £15,516 | £15,251 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 |
| Total Assets | £27,500 | £28,419 | £21,857 | £17,850 | £18,332 | £14,855 | £10,595 | £17,207 | £14,041 | £12,975 | £16,631 | £23,016 | £22,751 |
| 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 | £7,598 | £6,589 | £6,760 | £6,771 | £6,227 | £6,120 | £6,310 | £6,313 | £6,512 | £7,097 | £7,864 | £8,299 |
| Current Borrowing | £40,000 | £38,991 | £37,974 | £36,949 | £35,915 | £34,872 | £33,821 | £32,761 | £31,692 | £30,614 | £29,528 | £28,432 | £27,327 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £0 |
| Subtotal Current Liabilities | £40,000 | £46,590 | £44,563 | £43,709 | £42,686 | £41,100 | £39,941 | £49,071 | £48,005 | £47,126 | £46,625 | £46,296 | £35,626 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £40,000 | £46,590 | £44,563 | £43,709 | £42,686 | £41,100 | £39,941 | £49,071 | £48,005 | £47,126 | £46,625 | £46,296 | £35,626 |
| Paid-in Capital | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Retained Earnings | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) | (£32,500) |
| Earnings | £0 | (£5,670) | (£10,206) | (£13,359) | (£11,853) | (£13,745) | (£16,846) | (£19,364) | (£21,465) | (£21,651) | (£17,494) | (£10,780) | (£375) |
| Total Capital | (£12,500) | (£18,170) | (£22,706) | (£25,859) | (£24,353) | (£26,245) | (£29,346) | (£31,864) | (£33,965) | (£34,151) | (£29,994) | (£23,280) | (£12,875) |
| Total Liabilities and Capital | £27,500 | £28,419 | £21,857 | £17,850 | £18,332 | £14,855 | £10,595 | £17,207 | £14,041 | £12,975 | £16,631 | £23,016 | £22,751 |
| Net Worth | (£12,500) | (£18,170) | (£22,706) | (£25,859) | (£24,353) | (£26,245) | (£29,346) | (£31,864) | (£33,965) | (£34,151) | (£29,994) | (£23,280) | (£12,875) |