| 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 | |||||||||||||
| Woodville | 0% | £20,000 | £22,000 | £24,200 | £26,620 | £29,282 | £32,210 | £35,431 | £38,974 | £42,872 | £47,159 | £51,875 | £57,062 |
| National | 0% | £2,000 | £2,200 | £2,420 | £2,662 | £2,928 | £3,221 | £3,543 | £3,897 | £4,287 | £4,716 | £5,188 | £5,706 |
| Internet | 0% | £500 | £550 | £605 | £666 | £732 | £805 | £886 | £974 | £1,072 | £1,179 | £1,297 | £1,427 |
| Corporate | 0% | £2,500 | £2,750 | £3,025 | £3,328 | £3,660 | £4,026 | £4,026 | £4,872 | £5,359 | £5,895 | £6,484 | £7,133 |
| Total Sales | £25,000 | £27,500 | £30,250 | £33,276 | £36,602 | £40,262 | £43,886 | £48,717 | £53,590 | £58,949 | £64,844 | £71,328 | |
| 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 | |
| Woodville | £15,600 | £17,160 | £18,876 | £20,764 | £22,840 | £25,124 | £27,636 | £30,400 | £33,440 | £36,784 | £40,463 | £44,508 | |
| National | £1,560 | £1,716 | £1,888 | £2,076 | £2,824 | £2,512 | £2,764 | £3,040 | £3,344 | £3,678 | £4,047 | £4,451 | |
| Internet | £390 | £429 | £472 | £519 | £571 | £628 | £691 | £836 | £836 | £920 | £1,012 | £1,113 | |
| Corporate | £1,950 | £2,145 | £2,360 | £2,596 | £2,855 | £3,140 | £3,455 | £4,180 | £4,180 | £4,598 | £5,058 | £5,564 | |
| Subtotal Direct Cost of Sales | £19,500 | £21,450 | £23,596 | £25,955 | £29,090 | £31,404 | £34,546 | £38,456 | £41,800 | £45,980 | £50,580 | £55,636 | |
| 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 | ||
| Manager/President | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Accountant | 0% | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 |
| Travel Agent | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Marketing & Advertising Dir. | 0% | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 |
| Total People | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | |
| 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 | £25,000 | £27,500 | £30,250 | £33,276 | £36,602 | £40,262 | £43,886 | £48,717 | £53,590 | £58,949 | £64,844 | £71,328 | |
| Direct Cost of Sales | £19,500 | £21,450 | £23,596 | £25,955 | £29,090 | £31,404 | £34,546 | £38,456 | £41,800 | £45,980 | £50,580 | £55,636 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £19,500 | £21,450 | £23,596 | £25,955 | £29,090 | £31,404 | £34,546 | £38,456 | £41,800 | £45,980 | £50,580 | £55,636 | |
| Gross Margin | £5,500 | £6,050 | £6,654 | £7,321 | £7,512 | £8,858 | £9,340 | £10,261 | £11,790 | £12,969 | £14,264 | £15,692 | |
| Gross Margin % | 22.00% | 22.00% | 22.00% | 22.00% | 20.52% | 22.00% | 21.28% | 21.06% | 22.00% | 22.00% | 22.00% | 22.00% | |
| Expenses | |||||||||||||
| Payroll | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | |
| Marketing/Promotion | £2,175 | £2,175 | £2,175 | £2,175 | £2,175 | £2,175 | £2,175 | £2,175 | £2,175 | £2,175 | £2,175 | £2,175 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £875 | £875 | £875 | £875 | £875 | £875 | £875 | £875 | £875 | £875 | £875 | £875 | |
| Utilities | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| 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 | £7,375 | £7,375 | £7,375 | £7,375 | £7,375 | £7,375 | £7,375 | £7,375 | £7,375 | £7,375 | £7,375 | £7,375 | |
| Profit Before Interest and Taxes | (£1,875) | (£1,325) | (£721) | (£54) | £137 | £1,483 | £1,965 | £2,886 | £4,415 | £5,594 | £6,889 | £8,317 | |
| EBITDA | (£1,875) | (£1,325) | (£721) | (£54) | £137 | £1,483 | £1,965 | £2,886 | £4,415 | £5,594 | £6,889 | £8,317 | |
| Interest Expense | £703 | £698 | £692 | £687 | £681 | £676 | £670 | £665 | £660 | £654 | £649 | £643 | |
| Taxes Incurred | (£773) | (£607) | (£424) | (£222) | (£163) | £242 | £388 | £666 | £1,127 | £1,482 | £1,872 | £2,302 | |
| Net Profit | (£1,805) | (£1,416) | (£989) | (£518) | (£381) | £565 | £906 | £1,555 | £2,629 | £3,458 | £4,368 | £5,372 | |
| Net Profit/Sales | -7.22% | -5.15% | -3.27% | -1.56% | -1.04% | 1.40% | 2.06% | 3.19% | 4.91% | 5.87% | 6.74% | 7.53% | |
| 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 | £18,750 | £20,625 | £22,688 | £24,957 | £27,452 | £30,197 | £32,915 | £36,538 | £40,193 | £44,212 | £48,633 | £53,496 | |
| Cash from Receivables | £0 | £208 | £6,271 | £6,898 | £7,588 | £8,347 | £9,181 | £10,096 | £11,012 | £12,220 | £13,442 | £14,786 | |
| Subtotal Cash from Operations | £18,750 | £20,833 | £28,958 | £31,855 | £35,039 | £38,543 | £42,096 | £46,633 | £51,204 | £56,432 | £62,075 | £68,282 | |
| 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 | £18,750 | £20,833 | £28,958 | £31,855 | £35,039 | £38,543 | £42,096 | £46,633 | £51,204 | £56,432 | £62,075 | £68,282 | |
| 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,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | |
| Bill Payments | £768 | £23,125 | £25,243 | £27,574 | £30,151 | £33,323 | £36,056 | £39,369 | £43,539 | £47,362 | £51,907 | £56,909 | |
| Subtotal Spent on Operations | £4,518 | £26,875 | £28,993 | £31,324 | £33,901 | £37,073 | £39,806 | £43,119 | £47,289 | £51,112 | £55,657 | £60,659 | |
| 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 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | |
| 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,168 | £27,525 | £29,643 | £31,974 | £34,551 | £37,723 | £40,456 | £43,769 | £47,939 | £51,762 | £56,307 | £61,309 | |
| Net Cash Flow | £13,582 | (£6,692) | (£685) | (£119) | £488 | £820 | £1,639 | £2,864 | £3,265 | £4,669 | £5,768 | £6,974 | |
| Cash Balance | £48,582 | £41,890 | £41,205 | £41,086 | £41,574 | £42,394 | £44,033 | £46,897 | £50,163 | £54,832 | £60,600 | £67,574 | |
| 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 | £35,000 | £48,582 | £41,890 | £41,205 | £41,086 | £41,574 | £42,394 | £44,033 | £46,897 | £50,163 | £54,832 | £60,600 | £67,574 |
| Accounts Receivable | £0 | £6,250 | £12,917 | £14,208 | £15,629 | £17,192 | £18,911 | £20,701 | £22,785 | £25,171 | £27,688 | £30,457 | £33,503 |
| Other Current Assets | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 |
| Total Current Assets | £52,500 | £72,332 | £72,307 | £72,913 | £74,215 | £76,266 | £78,805 | £82,234 | £87,182 | £92,833 | £100,020 | £108,557 | £118,576 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 |
| Total Assets | £79,425 | £99,257 | £99,232 | £99,838 | £101,140 | £103,191 | £105,730 | £109,159 | £114,107 | £119,758 | £126,945 | £135,482 | £145,501 |
| 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 | £22,286 | £24,327 | £26,573 | £29,043 | £32,125 | £34,749 | £37,922 | £41,965 | £45,638 | £50,016 | £54,835 | £60,133 |
| 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 | £22,286 | £24,327 | £26,573 | £29,043 | £32,125 | £34,749 | £37,922 | £41,965 | £45,638 | £50,016 | £54,835 | £60,133 |
| Long-term Liabilities | £85,000 | £84,350 | £83,700 | £83,050 | £82,400 | £81,750 | £81,100 | £80,450 | £79,800 | £79,150 | £78,500 | £77,850 | £77,200 |
| Total Liabilities | £85,000 | £106,636 | £108,027 | £109,623 | £111,443 | £113,875 | £115,849 | £118,372 | £121,765 | £124,788 | £128,516 | £132,685 | £137,333 |
| Paid-in Capital | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 |
| Retained Earnings | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) |
| Earnings | £0 | (£1,805) | (£3,220) | (£4,209) | (£4,728) | (£5,109) | (£4,544) | (£3,638) | (£2,083) | £546 | £4,004 | £8,372 | £13,743 |
| Total Capital | (£5,575) | (£7,380) | (£8,795) | (£9,784) | (£10,303) | (£10,684) | (£10,119) | (£9,213) | (£7,658) | (£5,029) | (£1,571) | £2,797 | £8,168 |
| Total Liabilities and Capital | £79,425 | £99,257 | £99,232 | £99,838 | £101,140 | £103,191 | £105,730 | £109,159 | £114,107 | £119,758 | £126,945 | £135,482 | £145,501 |
| Net Worth | (£5,575) | (£7,380) | (£8,795) | (£9,784) | (£10,303) | (£10,684) | (£10,119) | (£9,213) | (£7,658) | (£5,029) | (£1,571) | £2,797 | £8,168 |
| 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 | |||||||||||||
| Woodville | 0% | £20,000 | £22,000 | £24,200 | £26,620 | £29,282 | £32,210 | £35,431 | £38,974 | £42,872 | £47,159 | £51,875 | £57,062 |
| National | 0% | £2,000 | £2,200 | £2,420 | £2,662 | £2,928 | £3,221 | £3,543 | £3,897 | £4,287 | £4,716 | £5,188 | £5,706 |
| Internet | 0% | £500 | £550 | £605 | £666 | £732 | £805 | £886 | £974 | £1,072 | £1,179 | £1,297 | £1,427 |
| Corporate | 0% | £2,500 | £2,750 | £3,025 | £3,328 | £3,660 | £4,026 | £4,026 | £4,872 | £5,359 | £5,895 | £6,484 | £7,133 |
| Total Sales | £25,000 | £27,500 | £30,250 | £33,276 | £36,602 | £40,262 | £43,886 | £48,717 | £53,590 | £58,949 | £64,844 | £71,328 | |
| 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 | |
| Woodville | £15,600 | £17,160 | £18,876 | £20,764 | £22,840 | £25,124 | £27,636 | £30,400 | £33,440 | £36,784 | £40,463 | £44,508 | |
| National | £1,560 | £1,716 | £1,888 | £2,076 | £2,824 | £2,512 | £2,764 | £3,040 | £3,344 | £3,678 | £4,047 | £4,451 | |
| Internet | £390 | £429 | £472 | £519 | £571 | £628 | £691 | £836 | £836 | £920 | £1,012 | £1,113 | |
| Corporate | £1,950 | £2,145 | £2,360 | £2,596 | £2,855 | £3,140 | £3,455 | £4,180 | £4,180 | £4,598 | £5,058 | £5,564 | |
| Subtotal Direct Cost of Sales | £19,500 | £21,450 | £23,596 | £25,955 | £29,090 | £31,404 | £34,546 | £38,456 | £41,800 | £45,980 | £50,580 | £55,636 | |
| 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 | ||
| Manager/President | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Accountant | 0% | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 |
| Travel Agent | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Marketing & Advertising Dir. | 0% | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 |
| Total People | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | |
| 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 | £25,000 | £27,500 | £30,250 | £33,276 | £36,602 | £40,262 | £43,886 | £48,717 | £53,590 | £58,949 | £64,844 | £71,328 | |
| Direct Cost of Sales | £19,500 | £21,450 | £23,596 | £25,955 | £29,090 | £31,404 | £34,546 | £38,456 | £41,800 | £45,980 | £50,580 | £55,636 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £19,500 | £21,450 | £23,596 | £25,955 | £29,090 | £31,404 | £34,546 | £38,456 | £41,800 | £45,980 | £50,580 | £55,636 | |
| Gross Margin | £5,500 | £6,050 | £6,654 | £7,321 | £7,512 | £8,858 | £9,340 | £10,261 | £11,790 | £12,969 | £14,264 | £15,692 | |
| Gross Margin % | 22.00% | 22.00% | 22.00% | 22.00% | 20.52% | 22.00% | 21.28% | 21.06% | 22.00% | 22.00% | 22.00% | 22.00% | |
| Expenses | |||||||||||||
| Payroll | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | |
| Marketing/Promotion | £2,175 | £2,175 | £2,175 | £2,175 | £2,175 | £2,175 | £2,175 | £2,175 | £2,175 | £2,175 | £2,175 | £2,175 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £875 | £875 | £875 | £875 | £875 | £875 | £875 | £875 | £875 | £875 | £875 | £875 | |
| Utilities | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | £375 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| 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 | £7,375 | £7,375 | £7,375 | £7,375 | £7,375 | £7,375 | £7,375 | £7,375 | £7,375 | £7,375 | £7,375 | £7,375 | |
| Profit Before Interest and Taxes | (£1,875) | (£1,325) | (£721) | (£54) | £137 | £1,483 | £1,965 | £2,886 | £4,415 | £5,594 | £6,889 | £8,317 | |
| EBITDA | (£1,875) | (£1,325) | (£721) | (£54) | £137 | £1,483 | £1,965 | £2,886 | £4,415 | £5,594 | £6,889 | £8,317 | |
| Interest Expense | £703 | £698 | £692 | £687 | £681 | £676 | £670 | £665 | £660 | £654 | £649 | £643 | |
| Taxes Incurred | (£773) | (£607) | (£424) | (£222) | (£163) | £242 | £388 | £666 | £1,127 | £1,482 | £1,872 | £2,302 | |
| Net Profit | (£1,805) | (£1,416) | (£989) | (£518) | (£381) | £565 | £906 | £1,555 | £2,629 | £3,458 | £4,368 | £5,372 | |
| Net Profit/Sales | -7.22% | -5.15% | -3.27% | -1.56% | -1.04% | 1.40% | 2.06% | 3.19% | 4.91% | 5.87% | 6.74% | 7.53% | |
| 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 | £18,750 | £20,625 | £22,688 | £24,957 | £27,452 | £30,197 | £32,915 | £36,538 | £40,193 | £44,212 | £48,633 | £53,496 | |
| Cash from Receivables | £0 | £208 | £6,271 | £6,898 | £7,588 | £8,347 | £9,181 | £10,096 | £11,012 | £12,220 | £13,442 | £14,786 | |
| Subtotal Cash from Operations | £18,750 | £20,833 | £28,958 | £31,855 | £35,039 | £38,543 | £42,096 | £46,633 | £51,204 | £56,432 | £62,075 | £68,282 | |
| 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 | £18,750 | £20,833 | £28,958 | £31,855 | £35,039 | £38,543 | £42,096 | £46,633 | £51,204 | £56,432 | £62,075 | £68,282 | |
| 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,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | |
| Bill Payments | £768 | £23,125 | £25,243 | £27,574 | £30,151 | £33,323 | £36,056 | £39,369 | £43,539 | £47,362 | £51,907 | £56,909 | |
| Subtotal Spent on Operations | £4,518 | £26,875 | £28,993 | £31,324 | £33,901 | £37,073 | £39,806 | £43,119 | £47,289 | £51,112 | £55,657 | £60,659 | |
| 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 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | |
| 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,168 | £27,525 | £29,643 | £31,974 | £34,551 | £37,723 | £40,456 | £43,769 | £47,939 | £51,762 | £56,307 | £61,309 | |
| Net Cash Flow | £13,582 | (£6,692) | (£685) | (£119) | £488 | £820 | £1,639 | £2,864 | £3,265 | £4,669 | £5,768 | £6,974 | |
| Cash Balance | £48,582 | £41,890 | £41,205 | £41,086 | £41,574 | £42,394 | £44,033 | £46,897 | £50,163 | £54,832 | £60,600 | £67,574 | |
| 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 | £35,000 | £48,582 | £41,890 | £41,205 | £41,086 | £41,574 | £42,394 | £44,033 | £46,897 | £50,163 | £54,832 | £60,600 | £67,574 |
| Accounts Receivable | £0 | £6,250 | £12,917 | £14,208 | £15,629 | £17,192 | £18,911 | £20,701 | £22,785 | £25,171 | £27,688 | £30,457 | £33,503 |
| Other Current Assets | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 |
| Total Current Assets | £52,500 | £72,332 | £72,307 | £72,913 | £74,215 | £76,266 | £78,805 | £82,234 | £87,182 | £92,833 | £100,020 | £108,557 | £118,576 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 | £26,925 |
| Total Assets | £79,425 | £99,257 | £99,232 | £99,838 | £101,140 | £103,191 | £105,730 | £109,159 | £114,107 | £119,758 | £126,945 | £135,482 | £145,501 |
| 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 | £22,286 | £24,327 | £26,573 | £29,043 | £32,125 | £34,749 | £37,922 | £41,965 | £45,638 | £50,016 | £54,835 | £60,133 |
| 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 | £22,286 | £24,327 | £26,573 | £29,043 | £32,125 | £34,749 | £37,922 | £41,965 | £45,638 | £50,016 | £54,835 | £60,133 |
| Long-term Liabilities | £85,000 | £84,350 | £83,700 | £83,050 | £82,400 | £81,750 | £81,100 | £80,450 | £79,800 | £79,150 | £78,500 | £77,850 | £77,200 |
| Total Liabilities | £85,000 | £106,636 | £108,027 | £109,623 | £111,443 | £113,875 | £115,849 | £118,372 | £121,765 | £124,788 | £128,516 | £132,685 | £137,333 |
| Paid-in Capital | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 |
| Retained Earnings | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) | (£23,575) |
| Earnings | £0 | (£1,805) | (£3,220) | (£4,209) | (£4,728) | (£5,109) | (£4,544) | (£3,638) | (£2,083) | £546 | £4,004 | £8,372 | £13,743 |
| Total Capital | (£5,575) | (£7,380) | (£8,795) | (£9,784) | (£10,303) | (£10,684) | (£10,119) | (£9,213) | (£7,658) | (£5,029) | (£1,571) | £2,797 | £8,168 |
| Total Liabilities and Capital | £79,425 | £99,257 | £99,232 | £99,838 | £101,140 | £103,191 | £105,730 | £109,159 | £114,107 | £119,758 | £126,945 | £135,482 | £145,501 |
| Net Worth | (£5,575) | (£7,380) | (£8,795) | (£9,784) | (£10,303) | (£10,684) | (£10,119) | (£9,213) | (£7,658) | (£5,029) | (£1,571) | £2,797 | £8,168 |