| 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 | |||||||||||||
| Gardner and Miller Customers | 0% | £3,000 | £4,000 | £6,785 | £5,300 | £5,400 | £6,200 | £6,302 | £7,000 | £6,400 | £4,900 | £4,500 | £3,000 |
| New Customers | 0% | £0 | £0 | £0 | £0 | £1,000 | £2,500 | £3,000 | £3,700 | £4,000 | £3,000 | £3,000 | £2,000 |
| Total Sales | £3,000 | £4,000 | £6,785 | £5,300 | £6,400 | £8,700 | £9,302 | £10,700 | £10,400 | £7,900 | £7,500 | £5,000 | |
| 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 | |
| Gardner and Miller Customers | £1,050 | £1,400 | £2,375 | £1,855 | £1,890 | £2,170 | £2,206 | £2,450 | £2,240 | £1,715 | £1,575 | £1,050 | |
| New Customers | £0 | £0 | £0 | £0 | £350 | £875 | £1,050 | £1,295 | £1,400 | £1,050 | £1,050 | £700 | |
| Subtotal Direct Cost of Sales | £1,050 | £1,400 | £2,375 | £1,855 | £2,240 | £3,045 | £3,256 | £3,745 | £3,640 | £2,765 | £2,625 | £1,750 | |
| 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 | ||
| Robin Sullivan | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £3,000 | £4,000 | £6,785 | £5,300 | £6,400 | £8,700 | £9,302 | £10,700 | £10,400 | £7,900 | £7,500 | £5,000 | |
| Direct Cost of Sales | £1,050 | £1,400 | £2,375 | £1,855 | £2,240 | £3,045 | £3,256 | £3,745 | £3,640 | £2,765 | £2,625 | £1,750 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £1,050 | £1,400 | £2,375 | £1,855 | £2,240 | £3,045 | £3,256 | £3,745 | £3,640 | £2,765 | £2,625 | £1,750 | |
| Gross Margin | £1,950 | £2,600 | £4,410 | £3,445 | £4,160 | £5,655 | £6,046 | £6,955 | £6,760 | £5,135 | £4,875 | £3,250 | |
| Gross Margin % | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | |
| Expenses | |||||||||||||
| Payroll | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Sales and Marketing and Other Expenses | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £0 | |
| Depreciation | £229 | £229 | £229 | £229 | £229 | £229 | £229 | £229 | £229 | £229 | £229 | £229 | |
| Leased Equipment | £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 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £1,000 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Payroll Taxes | 15% | £525 | £525 | £525 | £525 | £525 | £525 | £525 | £525 | £525 | £525 | £525 | £525 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £6,554 | £6,054 | £6,054 | £6,054 | £6,054 | £6,054 | £6,054 | £6,054 | £6,054 | £6,054 | £6,054 | £5,954 | |
| Profit Before Interest and Taxes | (£4,604) | (£3,454) | (£1,644) | (£2,609) | (£1,894) | (£399) | (£8) | £901 | £706 | (£919) | (£1,179) | (£2,704) | |
| EBITDA | (£4,375) | (£3,225) | (£1,415) | (£2,380) | (£1,665) | (£170) | £221 | £1,130 | £935 | (£690) | (£950) | (£2,475) | |
| Interest Expense | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£4,787) | (£3,637) | (£1,827) | (£2,792) | (£2,077) | (£582) | (£191) | £718 | £523 | (£1,102) | (£1,362) | (£2,887) | |
| Net Profit/Sales | -159.58% | -90.93% | -26.93% | -52.69% | -32.46% | -6.69% | -2.05% | 6.71% | 5.03% | -13.95% | -18.16% | -57.75% | |
| 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 | £750 | £1,000 | £1,696 | £1,325 | £1,600 | £2,175 | £2,326 | £2,675 | £2,600 | £1,975 | £1,875 | £1,250 | |
| Cash from Receivables | £0 | £75 | £2,275 | £3,070 | £5,052 | £4,003 | £4,858 | £6,540 | £7,011 | £8,018 | £7,738 | £5,915 | |
| Subtotal Cash from Operations | £750 | £1,075 | £3,971 | £4,395 | £6,652 | £6,178 | £7,183 | £9,215 | £9,611 | £9,993 | £9,613 | £7,165 | |
| 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 | £750 | £1,075 | £3,971 | £4,395 | £6,652 | £6,178 | £7,183 | £9,215 | £9,611 | £9,993 | £9,613 | £7,165 | |
| 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,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Bill Payments | £135 | £4,053 | £3,941 | £4,866 | £4,376 | £4,775 | £5,560 | £5,780 | £6,250 | £6,119 | £5,269 | £5,101 | |
| Subtotal Spent on Operations | £3,635 | £7,553 | £7,441 | £8,366 | £7,876 | £8,275 | £9,060 | £9,280 | £9,750 | £9,619 | £8,769 | £8,601 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £3,635 | £7,553 | £7,441 | £8,366 | £7,876 | £8,275 | £9,060 | £9,280 | £9,750 | £9,619 | £8,769 | £8,601 | |
| Net Cash Flow | (£2,885) | (£6,478) | (£3,470) | (£3,971) | (£1,225) | (£2,098) | (£1,877) | (£65) | (£138) | £373 | £844 | (£1,436) | |
| Cash Balance | £26,815 | £20,336 | £16,867 | £12,896 | £11,671 | £9,573 | £7,696 | £7,631 | £7,492 | £7,866 | £8,710 | £7,274 | |
| 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 | £29,700 | £26,815 | £20,336 | £16,867 | £12,896 | £11,671 | £9,573 | £7,696 | £7,631 | £7,492 | £7,866 | £8,710 | £7,274 |
| Accounts Receivable | £0 | £2,250 | £5,175 | £7,989 | £8,894 | £8,643 | £11,165 | £13,284 | £14,769 | £15,558 | £13,465 | £11,353 | £9,188 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £29,700 | £29,065 | £25,511 | £24,856 | £21,790 | £20,314 | £20,738 | £20,980 | £22,400 | £23,050 | £21,331 | £20,062 | £16,461 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 |
| Accumulated Depreciation | £0 | £229 | £458 | £687 | £916 | £1,145 | £1,374 | £1,603 | £1,832 | £2,061 | £2,290 | £2,519 | £2,748 |
| Total Long-term Assets | £22,000 | £21,771 | £21,542 | £21,313 | £21,084 | £20,855 | £20,626 | £20,397 | £20,168 | £19,939 | £19,710 | £19,481 | £19,252 |
| Total Assets | £51,700 | £50,836 | £47,053 | £46,169 | £42,874 | £41,169 | £41,364 | £41,377 | £42,568 | £42,989 | £41,041 | £39,543 | £35,713 |
| 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 | £3,923 | £3,778 | £4,720 | £4,218 | £4,590 | £5,368 | £5,572 | £6,045 | £5,943 | £5,098 | £4,962 | £4,020 |
| 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 | £3,923 | £3,778 | £4,720 | £4,218 | £4,590 | £5,368 | £5,572 | £6,045 | £5,943 | £5,098 | £4,962 | £4,020 |
| Long-term Liabilities | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 |
| Total Liabilities | £22,000 | £25,923 | £25,778 | £26,720 | £26,218 | £26,590 | £27,368 | £27,572 | £28,045 | £27,943 | £27,098 | £26,962 | £26,020 |
| Paid-in Capital | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 |
| Retained Earnings | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) |
| Earnings | £0 | (£4,787) | (£8,425) | (£10,252) | (£13,044) | (£15,121) | (£15,704) | (£15,895) | (£15,177) | (£14,654) | (£15,757) | (£17,119) | (£20,006) |
| Total Capital | £29,700 | £24,913 | £21,275 | £19,448 | £16,656 | £14,579 | £13,996 | £13,805 | £14,523 | £15,046 | £13,943 | £12,581 | £9,694 |
| Total Liabilities and Capital | £51,700 | £50,836 | £47,053 | £46,169 | £42,874 | £41,169 | £41,364 | £41,377 | £42,568 | £42,989 | £41,041 | £39,543 | £35,713 |
| Net Worth | £29,700 | £24,913 | £21,275 | £19,448 | £16,656 | £14,579 | £13,996 | £13,805 | £14,523 | £15,046 | £13,943 | £12,581 | £9,694 |
| 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 | |||||||||||||
| Gardner and Miller Customers | 0% | £3,000 | £4,000 | £6,785 | £5,300 | £5,400 | £6,200 | £6,302 | £7,000 | £6,400 | £4,900 | £4,500 | £3,000 |
| New Customers | 0% | £0 | £0 | £0 | £0 | £1,000 | £2,500 | £3,000 | £3,700 | £4,000 | £3,000 | £3,000 | £2,000 |
| Total Sales | £3,000 | £4,000 | £6,785 | £5,300 | £6,400 | £8,700 | £9,302 | £10,700 | £10,400 | £7,900 | £7,500 | £5,000 | |
| 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 | |
| Gardner and Miller Customers | £1,050 | £1,400 | £2,375 | £1,855 | £1,890 | £2,170 | £2,206 | £2,450 | £2,240 | £1,715 | £1,575 | £1,050 | |
| New Customers | £0 | £0 | £0 | £0 | £350 | £875 | £1,050 | £1,295 | £1,400 | £1,050 | £1,050 | £700 | |
| Subtotal Direct Cost of Sales | £1,050 | £1,400 | £2,375 | £1,855 | £2,240 | £3,045 | £3,256 | £3,745 | £3,640 | £2,765 | £2,625 | £1,750 | |
| 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 | ||
| Robin Sullivan | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £3,000 | £4,000 | £6,785 | £5,300 | £6,400 | £8,700 | £9,302 | £10,700 | £10,400 | £7,900 | £7,500 | £5,000 | |
| Direct Cost of Sales | £1,050 | £1,400 | £2,375 | £1,855 | £2,240 | £3,045 | £3,256 | £3,745 | £3,640 | £2,765 | £2,625 | £1,750 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £1,050 | £1,400 | £2,375 | £1,855 | £2,240 | £3,045 | £3,256 | £3,745 | £3,640 | £2,765 | £2,625 | £1,750 | |
| Gross Margin | £1,950 | £2,600 | £4,410 | £3,445 | £4,160 | £5,655 | £6,046 | £6,955 | £6,760 | £5,135 | £4,875 | £3,250 | |
| Gross Margin % | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | |
| Expenses | |||||||||||||
| Payroll | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Sales and Marketing and Other Expenses | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £0 | |
| Depreciation | £229 | £229 | £229 | £229 | £229 | £229 | £229 | £229 | £229 | £229 | £229 | £229 | |
| Leased Equipment | £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 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £1,000 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Payroll Taxes | 15% | £525 | £525 | £525 | £525 | £525 | £525 | £525 | £525 | £525 | £525 | £525 | £525 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £6,554 | £6,054 | £6,054 | £6,054 | £6,054 | £6,054 | £6,054 | £6,054 | £6,054 | £6,054 | £6,054 | £5,954 | |
| Profit Before Interest and Taxes | (£4,604) | (£3,454) | (£1,644) | (£2,609) | (£1,894) | (£399) | (£8) | £901 | £706 | (£919) | (£1,179) | (£2,704) | |
| EBITDA | (£4,375) | (£3,225) | (£1,415) | (£2,380) | (£1,665) | (£170) | £221 | £1,130 | £935 | (£690) | (£950) | (£2,475) | |
| Interest Expense | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£4,787) | (£3,637) | (£1,827) | (£2,792) | (£2,077) | (£582) | (£191) | £718 | £523 | (£1,102) | (£1,362) | (£2,887) | |
| Net Profit/Sales | -159.58% | -90.93% | -26.93% | -52.69% | -32.46% | -6.69% | -2.05% | 6.71% | 5.03% | -13.95% | -18.16% | -57.75% | |
| 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 | £750 | £1,000 | £1,696 | £1,325 | £1,600 | £2,175 | £2,326 | £2,675 | £2,600 | £1,975 | £1,875 | £1,250 | |
| Cash from Receivables | £0 | £75 | £2,275 | £3,070 | £5,052 | £4,003 | £4,858 | £6,540 | £7,011 | £8,018 | £7,738 | £5,915 | |
| Subtotal Cash from Operations | £750 | £1,075 | £3,971 | £4,395 | £6,652 | £6,178 | £7,183 | £9,215 | £9,611 | £9,993 | £9,613 | £7,165 | |
| 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 | £750 | £1,075 | £3,971 | £4,395 | £6,652 | £6,178 | £7,183 | £9,215 | £9,611 | £9,993 | £9,613 | £7,165 | |
| 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,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Bill Payments | £135 | £4,053 | £3,941 | £4,866 | £4,376 | £4,775 | £5,560 | £5,780 | £6,250 | £6,119 | £5,269 | £5,101 | |
| Subtotal Spent on Operations | £3,635 | £7,553 | £7,441 | £8,366 | £7,876 | £8,275 | £9,060 | £9,280 | £9,750 | £9,619 | £8,769 | £8,601 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £3,635 | £7,553 | £7,441 | £8,366 | £7,876 | £8,275 | £9,060 | £9,280 | £9,750 | £9,619 | £8,769 | £8,601 | |
| Net Cash Flow | (£2,885) | (£6,478) | (£3,470) | (£3,971) | (£1,225) | (£2,098) | (£1,877) | (£65) | (£138) | £373 | £844 | (£1,436) | |
| Cash Balance | £26,815 | £20,336 | £16,867 | £12,896 | £11,671 | £9,573 | £7,696 | £7,631 | £7,492 | £7,866 | £8,710 | £7,274 | |
| 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 | £29,700 | £26,815 | £20,336 | £16,867 | £12,896 | £11,671 | £9,573 | £7,696 | £7,631 | £7,492 | £7,866 | £8,710 | £7,274 |
| Accounts Receivable | £0 | £2,250 | £5,175 | £7,989 | £8,894 | £8,643 | £11,165 | £13,284 | £14,769 | £15,558 | £13,465 | £11,353 | £9,188 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £29,700 | £29,065 | £25,511 | £24,856 | £21,790 | £20,314 | £20,738 | £20,980 | £22,400 | £23,050 | £21,331 | £20,062 | £16,461 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 |
| Accumulated Depreciation | £0 | £229 | £458 | £687 | £916 | £1,145 | £1,374 | £1,603 | £1,832 | £2,061 | £2,290 | £2,519 | £2,748 |
| Total Long-term Assets | £22,000 | £21,771 | £21,542 | £21,313 | £21,084 | £20,855 | £20,626 | £20,397 | £20,168 | £19,939 | £19,710 | £19,481 | £19,252 |
| Total Assets | £51,700 | £50,836 | £47,053 | £46,169 | £42,874 | £41,169 | £41,364 | £41,377 | £42,568 | £42,989 | £41,041 | £39,543 | £35,713 |
| 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 | £3,923 | £3,778 | £4,720 | £4,218 | £4,590 | £5,368 | £5,572 | £6,045 | £5,943 | £5,098 | £4,962 | £4,020 |
| 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 | £3,923 | £3,778 | £4,720 | £4,218 | £4,590 | £5,368 | £5,572 | £6,045 | £5,943 | £5,098 | £4,962 | £4,020 |
| Long-term Liabilities | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 | £22,000 |
| Total Liabilities | £22,000 | £25,923 | £25,778 | £26,720 | £26,218 | £26,590 | £27,368 | £27,572 | £28,045 | £27,943 | £27,098 | £26,962 | £26,020 |
| Paid-in Capital | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 |
| Retained Earnings | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) | (£10,300) |
| Earnings | £0 | (£4,787) | (£8,425) | (£10,252) | (£13,044) | (£15,121) | (£15,704) | (£15,895) | (£15,177) | (£14,654) | (£15,757) | (£17,119) | (£20,006) |
| Total Capital | £29,700 | £24,913 | £21,275 | £19,448 | £16,656 | £14,579 | £13,996 | £13,805 | £14,523 | £15,046 | £13,943 | £12,581 | £9,694 |
| Total Liabilities and Capital | £51,700 | £50,836 | £47,053 | £46,169 | £42,874 | £41,169 | £41,364 | £41,377 | £42,568 | £42,989 | £41,041 | £39,543 | £35,713 |
| Net Worth | £29,700 | £24,913 | £21,275 | £19,448 | £16,656 | £14,579 | £13,996 | £13,805 | £14,523 | £15,046 | £13,943 | £12,581 | £9,694 |