| 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 | |||||||||||||
| Brides & Grooms | 0% | £2,900 | £3,100 | £3,300 | £3,500 | £4,000 | £5,400 | £4,600 | £5,000 | £5,200 | £5,500 | £5,700 | £6,000 |
| Family Members | 0% | £1,600 | £1,700 | £1,800 | £1,900 | £2,000 | £2,100 | £2,200 | £2,300 | £2,400 | £2,500 | £2,600 | £2,700 |
| Other | 0% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,400 | £1,400 |
| Total Sales | £5,700 | £6,000 | £6,300 | £6,600 | £7,200 | £8,800 | £8,100 | £8,600 | £8,900 | £9,300 | £9,700 | £10,100 | |
| 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 | |
| Row 1 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Row 1 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | ||
| Owner | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,700 | £5,700 | £5,700 |
| 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 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,700 | £5,700 | £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 | 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,700 | £6,000 | £6,300 | £6,600 | £7,200 | £8,800 | £8,100 | £8,600 | £8,900 | £9,300 | £9,700 | £10,100 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Gross Margin | £5,700 | £6,000 | £6,300 | £6,600 | £7,200 | £8,800 | £8,100 | £8,600 | £8,900 | £9,300 | £9,700 | £10,100 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,700 | £5,700 | £5,700 | |
| Sales and Marketing and Other Expenses | £1,100 | £250 | £250 | £250 | £600 | £250 | £250 | £250 | £600 | £250 | £250 | £250 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £5,100 | £4,250 | £4,250 | £4,250 | £4,600 | £4,250 | £4,250 | £4,250 | £4,600 | £5,950 | £5,950 | £5,950 | |
| Profit Before Interest and Taxes | £600 | £1,750 | £2,050 | £2,350 | £2,600 | £4,550 | £3,850 | £4,350 | £4,300 | £3,350 | £3,750 | £4,150 | |
| EBITDA | £600 | £1,750 | £2,050 | £2,350 | £2,600 | £4,550 | £3,850 | £4,350 | £4,300 | £3,350 | £3,750 | £4,150 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £180 | £438 | £513 | £588 | £650 | £1,138 | £963 | £1,088 | £1,075 | £838 | £938 | £1,038 | |
| Net Profit | £420 | £1,313 | £1,538 | £1,763 | £1,950 | £3,413 | £2,888 | £3,263 | £3,225 | £2,513 | £2,813 | £3,113 | |
| Net Profit/Sales | 7.37% | 21.88% | 24.40% | 26.70% | 27.08% | 38.78% | 35.65% | 37.94% | 36.24% | 27.02% | 28.99% | 30.82% | |
| 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 | £2,280 | £2,400 | £2,520 | £2,640 | £2,880 | £3,520 | £3,240 | £3,440 | £3,560 | £3,720 | £3,880 | £4,040 | |
| Cash from Receivables | £0 | £114 | £3,426 | £3,606 | £3,786 | £3,972 | £4,352 | £5,266 | £4,870 | £5,166 | £5,348 | £5,588 | |
| Subtotal Cash from Operations | £2,280 | £2,514 | £5,946 | £6,246 | £6,666 | £7,492 | £7,592 | £8,706 | £8,430 | £8,886 | £9,228 | £9,628 | |
| 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 | £2,280 | £2,514 | £5,946 | £6,246 | £6,666 | £7,492 | £7,592 | £8,706 | £8,430 | £8,886 | £9,228 | £9,628 | |
| 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 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,700 | £5,700 | £5,700 | |
| Bill Payments | £43 | £1,260 | £690 | £765 | £851 | £1,255 | £1,382 | £1,217 | £1,349 | £1,655 | £1,091 | £1,191 | |
| Subtotal Spent on Operations | £4,043 | £5,260 | £4,690 | £4,765 | £4,851 | £5,255 | £5,382 | £5,217 | £5,349 | £7,355 | £6,791 | £6,891 | |
| 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 | £4,043 | £5,260 | £4,690 | £4,765 | £4,851 | £5,255 | £5,382 | £5,217 | £5,349 | £7,355 | £6,791 | £6,891 | |
| Net Cash Flow | (£1,763) | (£2,746) | £1,256 | £1,481 | £1,815 | £2,237 | £2,210 | £3,489 | £3,081 | £1,531 | £2,437 | £2,737 | |
| Cash Balance | £3,237 | £491 | £1,747 | £3,228 | £5,043 | £7,280 | £9,491 | £12,980 | £16,061 | £17,592 | £20,029 | £22,766 | |
| 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 | £5,000 | £3,237 | £491 | £1,747 | £3,228 | £5,043 | £7,280 | £9,491 | £12,980 | £16,061 | £17,592 | £20,029 | £22,766 |
| Accounts Receivable | £0 | £3,420 | £6,906 | £7,260 | £7,614 | £8,148 | £9,456 | £9,964 | £9,858 | £10,328 | £10,742 | £11,214 | £11,686 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £5,000 | £6,657 | £7,397 | £9,007 | £10,842 | £13,191 | £16,736 | £19,455 | £22,838 | £26,389 | £28,334 | £31,243 | £34,452 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £5,000 | £6,657 | £7,397 | £9,007 | £10,842 | £13,191 | £16,736 | £19,455 | £22,838 | £26,389 | £28,334 | £31,243 | £34,452 |
| 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,237 | £665 | £737 | £810 | £1,208 | £1,341 | £1,172 | £1,293 | £1,619 | £1,051 | £1,148 | £1,245 |
| 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,237 | £665 | £737 | £810 | £1,208 | £1,341 | £1,172 | £1,293 | £1,619 | £1,051 | £1,148 | £1,245 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £1,237 | £665 | £737 | £810 | £1,208 | £1,341 | £1,172 | £1,293 | £1,619 | £1,051 | £1,148 | £1,245 |
| Paid-in Capital | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 |
| Retained Earnings | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) |
| Earnings | £0 | £420 | £1,733 | £3,270 | £5,033 | £6,983 | £10,395 | £13,283 | £16,545 | £19,770 | £22,283 | £25,095 | £28,208 |
| Total Capital | £5,000 | £5,420 | £6,733 | £8,270 | £10,033 | £11,983 | £15,395 | £18,283 | £21,545 | £24,770 | £27,283 | £30,095 | £33,208 |
| Total Liabilities and Capital | £5,000 | £6,657 | £7,397 | £9,007 | £10,842 | £13,191 | £16,736 | £19,455 | £22,838 | £26,389 | £28,334 | £31,243 | £34,452 |
| Net Worth | £5,000 | £5,420 | £6,733 | £8,270 | £10,033 | £11,983 | £15,395 | £18,283 | £21,545 | £24,770 | £27,282 | £30,095 | £33,207 |
| 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 | |||||||||||||
| Brides & Grooms | 0% | £2,900 | £3,100 | £3,300 | £3,500 | £4,000 | £5,400 | £4,600 | £5,000 | £5,200 | £5,500 | £5,700 | £6,000 |
| Family Members | 0% | £1,600 | £1,700 | £1,800 | £1,900 | £2,000 | £2,100 | £2,200 | £2,300 | £2,400 | £2,500 | £2,600 | £2,700 |
| Other | 0% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,400 | £1,400 |
| Total Sales | £5,700 | £6,000 | £6,300 | £6,600 | £7,200 | £8,800 | £8,100 | £8,600 | £8,900 | £9,300 | £9,700 | £10,100 | |
| 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 | |
| Row 1 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Row 1 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | ||
| Owner | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,700 | £5,700 | £5,700 |
| 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 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,700 | £5,700 | £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 | 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,700 | £6,000 | £6,300 | £6,600 | £7,200 | £8,800 | £8,100 | £8,600 | £8,900 | £9,300 | £9,700 | £10,100 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Gross Margin | £5,700 | £6,000 | £6,300 | £6,600 | £7,200 | £8,800 | £8,100 | £8,600 | £8,900 | £9,300 | £9,700 | £10,100 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,700 | £5,700 | £5,700 | |
| Sales and Marketing and Other Expenses | £1,100 | £250 | £250 | £250 | £600 | £250 | £250 | £250 | £600 | £250 | £250 | £250 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £5,100 | £4,250 | £4,250 | £4,250 | £4,600 | £4,250 | £4,250 | £4,250 | £4,600 | £5,950 | £5,950 | £5,950 | |
| Profit Before Interest and Taxes | £600 | £1,750 | £2,050 | £2,350 | £2,600 | £4,550 | £3,850 | £4,350 | £4,300 | £3,350 | £3,750 | £4,150 | |
| EBITDA | £600 | £1,750 | £2,050 | £2,350 | £2,600 | £4,550 | £3,850 | £4,350 | £4,300 | £3,350 | £3,750 | £4,150 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £180 | £438 | £513 | £588 | £650 | £1,138 | £963 | £1,088 | £1,075 | £838 | £938 | £1,038 | |
| Net Profit | £420 | £1,313 | £1,538 | £1,763 | £1,950 | £3,413 | £2,888 | £3,263 | £3,225 | £2,513 | £2,813 | £3,113 | |
| Net Profit/Sales | 7.37% | 21.88% | 24.40% | 26.70% | 27.08% | 38.78% | 35.65% | 37.94% | 36.24% | 27.02% | 28.99% | 30.82% | |
| 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 | £2,280 | £2,400 | £2,520 | £2,640 | £2,880 | £3,520 | £3,240 | £3,440 | £3,560 | £3,720 | £3,880 | £4,040 | |
| Cash from Receivables | £0 | £114 | £3,426 | £3,606 | £3,786 | £3,972 | £4,352 | £5,266 | £4,870 | £5,166 | £5,348 | £5,588 | |
| Subtotal Cash from Operations | £2,280 | £2,514 | £5,946 | £6,246 | £6,666 | £7,492 | £7,592 | £8,706 | £8,430 | £8,886 | £9,228 | £9,628 | |
| 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 | £2,280 | £2,514 | £5,946 | £6,246 | £6,666 | £7,492 | £7,592 | £8,706 | £8,430 | £8,886 | £9,228 | £9,628 | |
| 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 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,700 | £5,700 | £5,700 | |
| Bill Payments | £43 | £1,260 | £690 | £765 | £851 | £1,255 | £1,382 | £1,217 | £1,349 | £1,655 | £1,091 | £1,191 | |
| Subtotal Spent on Operations | £4,043 | £5,260 | £4,690 | £4,765 | £4,851 | £5,255 | £5,382 | £5,217 | £5,349 | £7,355 | £6,791 | £6,891 | |
| 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 | £4,043 | £5,260 | £4,690 | £4,765 | £4,851 | £5,255 | £5,382 | £5,217 | £5,349 | £7,355 | £6,791 | £6,891 | |
| Net Cash Flow | (£1,763) | (£2,746) | £1,256 | £1,481 | £1,815 | £2,237 | £2,210 | £3,489 | £3,081 | £1,531 | £2,437 | £2,737 | |
| Cash Balance | £3,237 | £491 | £1,747 | £3,228 | £5,043 | £7,280 | £9,491 | £12,980 | £16,061 | £17,592 | £20,029 | £22,766 | |
| 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 | £5,000 | £3,237 | £491 | £1,747 | £3,228 | £5,043 | £7,280 | £9,491 | £12,980 | £16,061 | £17,592 | £20,029 | £22,766 |
| Accounts Receivable | £0 | £3,420 | £6,906 | £7,260 | £7,614 | £8,148 | £9,456 | £9,964 | £9,858 | £10,328 | £10,742 | £11,214 | £11,686 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £5,000 | £6,657 | £7,397 | £9,007 | £10,842 | £13,191 | £16,736 | £19,455 | £22,838 | £26,389 | £28,334 | £31,243 | £34,452 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £5,000 | £6,657 | £7,397 | £9,007 | £10,842 | £13,191 | £16,736 | £19,455 | £22,838 | £26,389 | £28,334 | £31,243 | £34,452 |
| 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,237 | £665 | £737 | £810 | £1,208 | £1,341 | £1,172 | £1,293 | £1,619 | £1,051 | £1,148 | £1,245 |
| 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,237 | £665 | £737 | £810 | £1,208 | £1,341 | £1,172 | £1,293 | £1,619 | £1,051 | £1,148 | £1,245 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £1,237 | £665 | £737 | £810 | £1,208 | £1,341 | £1,172 | £1,293 | £1,619 | £1,051 | £1,148 | £1,245 |
| Paid-in Capital | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 |
| Retained Earnings | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) | (£3,000) |
| Earnings | £0 | £420 | £1,733 | £3,270 | £5,033 | £6,983 | £10,395 | £13,283 | £16,545 | £19,770 | £22,283 | £25,095 | £28,208 |
| Total Capital | £5,000 | £5,420 | £6,733 | £8,270 | £10,033 | £11,983 | £15,395 | £18,283 | £21,545 | £24,770 | £27,283 | £30,095 | £33,208 |
| Total Liabilities and Capital | £5,000 | £6,657 | £7,397 | £9,007 | £10,842 | £13,191 | £16,736 | £19,455 | £22,838 | £26,389 | £28,334 | £31,243 | £34,452 |
| Net Worth | £5,000 | £5,420 | £6,733 | £8,270 | £10,033 | £11,983 | £15,395 | £18,283 | £21,545 | £24,770 | £27,282 | £30,095 | £33,207 |