| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Membership Fees | 0% | £5,000 | £5,000 | £5,417 | £5,833 | £6,250 | £6,667 | £6,667 | £6,667 | £7,083 | £7,500 | £7,917 | £7,917 |
| Weekend Classes (Special) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £200 | £200 | £200 | £200 |
| Seminars/Private Lessions | 0% | £50 | £35 | £50 | £750 | £50 | £50 | £800 | £50 | £50 | £800 | £50 | £50 |
| Belt Testing Fees | 0% | £675 | £0 | £0 | £788 | £0 | £0 | £900 | £0 | £0 | £1,069 | £0 | £0 |
| Total Sales | £5,725 | £5,035 | £5,467 | £7,371 | £6,300 | £6,717 | £8,367 | £6,717 | £7,333 | £9,569 | £8,167 | £8,167 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Membership Fees | £1,300 | £1,300 | £1,383 | £1,467 | £1,550 | £1,633 | £1,300 | £1,300 | £1,363 | £1,425 | £1,488 | £1,488 | |
| Weekend Classes (Special) | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Seminars/Private Lessions | £10 | £10 | £10 | £50 | £10 | £10 | £50 | £10 | £10 | £50 | £10 | £10 | |
| Belt Testing Fees | £110 | £0 | £0 | £110 | £0 | £0 | £120 | £0 | £0 | £150 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £1,470 | £1,360 | £1,443 | £1,677 | £1,610 | £1,693 | £1,520 | £1,360 | £1,423 | £1,675 | £1,548 | £1,548 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Owner (Shihan) | 0% | £500 | £500 | £500 | £500 | £500 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Sales Associate/Receptionist | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £500 | £500 | £500 | £500 | £500 |
| Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £500 | £500 | £500 | £500 | £500 | £1,000 | £1,000 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| General Assumptions | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | |
| Long-term Interest Rate | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £5,725 | £5,035 | £5,467 | £7,371 | £6,300 | £6,717 | £8,367 | £6,717 | £7,333 | £9,569 | £8,167 | £8,167 | |
| Direct Cost of Sales | £1,470 | £1,360 | £1,443 | £1,677 | £1,610 | £1,693 | £1,520 | £1,360 | £1,423 | £1,675 | £1,548 | £1,548 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £1,470 | £1,360 | £1,443 | £1,677 | £1,610 | £1,693 | £1,520 | £1,360 | £1,423 | £1,675 | £1,548 | £1,548 | |
| Gross Margin | £4,255 | £3,675 | £4,024 | £5,694 | £4,690 | £5,024 | £6,847 | £5,357 | £5,910 | £7,894 | £6,619 | £6,619 | |
| Gross Margin % | 74.32% | 72.99% | 73.61% | 77.25% | 74.44% | 74.80% | 81.83% | 79.75% | 80.59% | 82.50% | 81.05% | 81.05% | |
| Expenses | |||||||||||||
| Payroll | £500 | £500 | £500 | £500 | £500 | £1,000 | £1,000 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Sales and Marketing and Other Expenses | £1,747 | £987 | £1,387 | £1,187 | £1,087 | £1,187 | £4,087 | £2,187 | £1,187 | £1,587 | £1,387 | £1,387 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | . | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 |
| Utilities | £610 | £510 | £320 | £320 | £320 | £380 | £400 | £480 | £300 | £300 | £404 | £500 | |
| Telephone | £303 | £303 | £299 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £310 | £310 | £310 | £310 | £310 | £310 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Rent | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Payroll Taxes | 15% | £75 | £75 | £75 | £75 | £75 | £150 | £150 | £225 | £225 | £225 | £225 | £225 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £4,695 | £3,835 | £4,041 | £3,842 | £3,742 | £4,477 | £7,487 | £6,242 | £5,062 | £5,462 | £5,366 | £5,462 | |
| Profit Before Interest and Taxes | (£440) | (£160) | (£17) | £1,852 | £948 | £547 | (£640) | (£885) | £848 | £2,432 | £1,253 | £1,157 | |
| EBITDA | (£440) | (£160) | (£17) | £1,852 | £948 | £547 | (£640) | (£885) | £848 | £2,432 | £1,253 | £1,157 | |
| Interest Expense | £260 | £257 | £254 | £252 | £249 | £246 | £244 | £391 | £388 | £385 | £381 | £377 | |
| Taxes Incurred | (£210) | (£104) | (£68) | £400 | £175 | £75 | (£221) | (£319) | £115 | £512 | £218 | £195 | |
| Net Profit | (£490) | (£313) | (£204) | £1,200 | £524 | £226 | (£663) | (£957) | £345 | £1,535 | £654 | £585 | |
| Net Profit/Sales | -8.56% | -6.21% | -3.72% | 16.28% | 8.32% | 3.36% | -7.92% | -14.25% | 4.70% | 16.04% | 8.01% | 7.17% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £5,725 | £5,035 | £5,467 | £7,371 | £6,300 | £6,717 | £8,367 | £6,717 | £7,333 | £9,569 | £8,167 | £8,167 | |
| Subtotal Cash from Operations | £5,725 | £5,035 | £5,467 | £7,371 | £6,300 | £6,717 | £8,367 | £6,717 | £7,333 | £9,569 | £8,167 | £8,167 | |
| 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 | £20,000 | £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,725 | £5,035 | £5,467 | £7,371 | £6,300 | £6,717 | £8,367 | £26,717 | £7,333 | £9,569 | £8,167 | £8,167 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £500 | £500 | £500 | £500 | £500 | £1,000 | £1,000 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Bill Payments | £4,690 | £5,686 | £4,859 | £5,187 | £5,658 | £5,283 | £5,576 | £7,968 | £6,151 | £5,523 | £6,517 | £6,015 | |
| Subtotal Spent on Operations | £5,190 | £6,186 | £5,359 | £5,687 | £6,158 | £6,283 | £6,576 | £9,468 | £7,651 | £7,023 | £8,017 | £7,515 | |
| 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 | £271 | £271 | £271 | £271 | £271 | £271 | £271 | £271 | £271 | £271 | £271 | £271 | |
| 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 | £230 | £230 | |
| 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 | £5,000 | £5,000 | £5,000 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £5,461 | £6,457 | £5,630 | £5,958 | £6,429 | £6,554 | £6,847 | £14,739 | £12,922 | £12,294 | £8,518 | £8,016 | |
| Net Cash Flow | £264 | (£1,422) | (£163) | £1,413 | (£129) | £163 | £1,520 | £11,978 | (£5,589) | (£2,725) | (£351) | £151 | |
| Cash Balance | £1,764 | £342 | £179 | £1,592 | £1,463 | £1,626 | £3,146 | £15,124 | £9,535 | £6,811 | £6,460 | £6,611 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £1,500 | £1,764 | £342 | £179 | £1,592 | £1,463 | £1,626 | £3,146 | £15,124 | £9,535 | £6,811 | £6,460 | £6,611 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £1,500 | £1,764 | £342 | £179 | £1,592 | £1,463 | £1,626 | £3,146 | £15,124 | £9,535 | £6,811 | £6,460 | £6,611 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £45,000 | £50,000 | £55,000 | £55,000 | £55,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £45,000 | £50,000 | £55,000 | £55,000 | £55,000 |
| Total Assets | £41,500 | £41,764 | £40,342 | £40,179 | £41,592 | £41,463 | £41,626 | £43,146 | £60,124 | £59,535 | £61,811 | £61,460 | £61,611 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £4,500 | £5,524 | £4,686 | £4,998 | £5,482 | £5,100 | £5,308 | £7,762 | £5,968 | £5,305 | £6,316 | £5,813 | £5,879 |
| Current Borrowing | £15,000 | £14,729 | £14,458 | £14,187 | £13,916 | £13,645 | £13,374 | £13,103 | £12,832 | £12,561 | £12,290 | £12,019 | £11,748 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £19,500 | £20,253 | £19,144 | £19,185 | £19,398 | £18,745 | £18,682 | £20,865 | £18,800 | £17,866 | £18,606 | £17,832 | £17,627 |
| Long-term Liabilities | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £35,000 | £35,000 | £35,000 | £34,770 | £34,540 |
| Total Liabilities | £34,500 | £35,253 | £34,144 | £34,185 | £34,398 | £33,745 | £33,682 | £35,865 | £53,800 | £52,866 | £53,606 | £52,602 | £52,167 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retained Earnings | £3,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 |
| Earnings | £4,000 | (£490) | (£803) | (£1,006) | £194 | £718 | £944 | £281 | (£676) | (£331) | £1,204 | £1,858 | £2,444 |
| Total Capital | £7,000 | £6,510 | £6,197 | £5,994 | £7,194 | £7,718 | £7,944 | £7,281 | £6,324 | £6,669 | £8,204 | £8,858 | £9,444 |
| Total Liabilities and Capital | £41,500 | £41,764 | £40,342 | £40,179 | £41,592 | £41,463 | £41,626 | £43,146 | £60,124 | £59,535 | £61,811 | £61,460 | £61,611 |
| Net Worth | £7,000 | £6,510 | £6,197 | £5,994 | £7,194 | £7,718 | £7,944 | £7,281 | £6,324 | £6,669 | £8,204 | £8,858 | £9,444 |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Membership Fees | 0% | £5,000 | £5,000 | £5,417 | £5,833 | £6,250 | £6,667 | £6,667 | £6,667 | £7,083 | £7,500 | £7,917 | £7,917 |
| Weekend Classes (Special) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £200 | £200 | £200 | £200 |
| Seminars/Private Lessions | 0% | £50 | £35 | £50 | £750 | £50 | £50 | £800 | £50 | £50 | £800 | £50 | £50 |
| Belt Testing Fees | 0% | £675 | £0 | £0 | £788 | £0 | £0 | £900 | £0 | £0 | £1,069 | £0 | £0 |
| Total Sales | £5,725 | £5,035 | £5,467 | £7,371 | £6,300 | £6,717 | £8,367 | £6,717 | £7,333 | £9,569 | £8,167 | £8,167 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Membership Fees | £1,300 | £1,300 | £1,383 | £1,467 | £1,550 | £1,633 | £1,300 | £1,300 | £1,363 | £1,425 | £1,488 | £1,488 | |
| Weekend Classes (Special) | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Seminars/Private Lessions | £10 | £10 | £10 | £50 | £10 | £10 | £50 | £10 | £10 | £50 | £10 | £10 | |
| Belt Testing Fees | £110 | £0 | £0 | £110 | £0 | £0 | £120 | £0 | £0 | £150 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £1,470 | £1,360 | £1,443 | £1,677 | £1,610 | £1,693 | £1,520 | £1,360 | £1,423 | £1,675 | £1,548 | £1,548 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Owner (Shihan) | 0% | £500 | £500 | £500 | £500 | £500 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Sales Associate/Receptionist | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £500 | £500 | £500 | £500 | £500 |
| Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £500 | £500 | £500 | £500 | £500 | £1,000 | £1,000 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| General Assumptions | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | |
| Long-term Interest Rate | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £5,725 | £5,035 | £5,467 | £7,371 | £6,300 | £6,717 | £8,367 | £6,717 | £7,333 | £9,569 | £8,167 | £8,167 | |
| Direct Cost of Sales | £1,470 | £1,360 | £1,443 | £1,677 | £1,610 | £1,693 | £1,520 | £1,360 | £1,423 | £1,675 | £1,548 | £1,548 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £1,470 | £1,360 | £1,443 | £1,677 | £1,610 | £1,693 | £1,520 | £1,360 | £1,423 | £1,675 | £1,548 | £1,548 | |
| Gross Margin | £4,255 | £3,675 | £4,024 | £5,694 | £4,690 | £5,024 | £6,847 | £5,357 | £5,910 | £7,894 | £6,619 | £6,619 | |
| Gross Margin % | 74.32% | 72.99% | 73.61% | 77.25% | 74.44% | 74.80% | 81.83% | 79.75% | 80.59% | 82.50% | 81.05% | 81.05% | |
| Expenses | |||||||||||||
| Payroll | £500 | £500 | £500 | £500 | £500 | £1,000 | £1,000 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Sales and Marketing and Other Expenses | £1,747 | £987 | £1,387 | £1,187 | £1,087 | £1,187 | £4,087 | £2,187 | £1,187 | £1,587 | £1,387 | £1,387 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | . | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 |
| Utilities | £610 | £510 | £320 | £320 | £320 | £380 | £400 | £480 | £300 | £300 | £404 | £500 | |
| Telephone | £303 | £303 | £299 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £310 | £310 | £310 | £310 | £310 | £310 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Rent | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Payroll Taxes | 15% | £75 | £75 | £75 | £75 | £75 | £150 | £150 | £225 | £225 | £225 | £225 | £225 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £4,695 | £3,835 | £4,041 | £3,842 | £3,742 | £4,477 | £7,487 | £6,242 | £5,062 | £5,462 | £5,366 | £5,462 | |
| Profit Before Interest and Taxes | (£440) | (£160) | (£17) | £1,852 | £948 | £547 | (£640) | (£885) | £848 | £2,432 | £1,253 | £1,157 | |
| EBITDA | (£440) | (£160) | (£17) | £1,852 | £948 | £547 | (£640) | (£885) | £848 | £2,432 | £1,253 | £1,157 | |
| Interest Expense | £260 | £257 | £254 | £252 | £249 | £246 | £244 | £391 | £388 | £385 | £381 | £377 | |
| Taxes Incurred | (£210) | (£104) | (£68) | £400 | £175 | £75 | (£221) | (£319) | £115 | £512 | £218 | £195 | |
| Net Profit | (£490) | (£313) | (£204) | £1,200 | £524 | £226 | (£663) | (£957) | £345 | £1,535 | £654 | £585 | |
| Net Profit/Sales | -8.56% | -6.21% | -3.72% | 16.28% | 8.32% | 3.36% | -7.92% | -14.25% | 4.70% | 16.04% | 8.01% | 7.17% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £5,725 | £5,035 | £5,467 | £7,371 | £6,300 | £6,717 | £8,367 | £6,717 | £7,333 | £9,569 | £8,167 | £8,167 | |
| Subtotal Cash from Operations | £5,725 | £5,035 | £5,467 | £7,371 | £6,300 | £6,717 | £8,367 | £6,717 | £7,333 | £9,569 | £8,167 | £8,167 | |
| 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 | £20,000 | £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,725 | £5,035 | £5,467 | £7,371 | £6,300 | £6,717 | £8,367 | £26,717 | £7,333 | £9,569 | £8,167 | £8,167 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £500 | £500 | £500 | £500 | £500 | £1,000 | £1,000 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Bill Payments | £4,690 | £5,686 | £4,859 | £5,187 | £5,658 | £5,283 | £5,576 | £7,968 | £6,151 | £5,523 | £6,517 | £6,015 | |
| Subtotal Spent on Operations | £5,190 | £6,186 | £5,359 | £5,687 | £6,158 | £6,283 | £6,576 | £9,468 | £7,651 | £7,023 | £8,017 | £7,515 | |
| 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 | £271 | £271 | £271 | £271 | £271 | £271 | £271 | £271 | £271 | £271 | £271 | £271 | |
| 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 | £230 | £230 | |
| 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 | £5,000 | £5,000 | £5,000 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £5,461 | £6,457 | £5,630 | £5,958 | £6,429 | £6,554 | £6,847 | £14,739 | £12,922 | £12,294 | £8,518 | £8,016 | |
| Net Cash Flow | £264 | (£1,422) | (£163) | £1,413 | (£129) | £163 | £1,520 | £11,978 | (£5,589) | (£2,725) | (£351) | £151 | |
| Cash Balance | £1,764 | £342 | £179 | £1,592 | £1,463 | £1,626 | £3,146 | £15,124 | £9,535 | £6,811 | £6,460 | £6,611 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £1,500 | £1,764 | £342 | £179 | £1,592 | £1,463 | £1,626 | £3,146 | £15,124 | £9,535 | £6,811 | £6,460 | £6,611 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £1,500 | £1,764 | £342 | £179 | £1,592 | £1,463 | £1,626 | £3,146 | £15,124 | £9,535 | £6,811 | £6,460 | £6,611 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £45,000 | £50,000 | £55,000 | £55,000 | £55,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £40,000 | £45,000 | £50,000 | £55,000 | £55,000 | £55,000 |
| Total Assets | £41,500 | £41,764 | £40,342 | £40,179 | £41,592 | £41,463 | £41,626 | £43,146 | £60,124 | £59,535 | £61,811 | £61,460 | £61,611 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £4,500 | £5,524 | £4,686 | £4,998 | £5,482 | £5,100 | £5,308 | £7,762 | £5,968 | £5,305 | £6,316 | £5,813 | £5,879 |
| Current Borrowing | £15,000 | £14,729 | £14,458 | £14,187 | £13,916 | £13,645 | £13,374 | £13,103 | £12,832 | £12,561 | £12,290 | £12,019 | £11,748 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £19,500 | £20,253 | £19,144 | £19,185 | £19,398 | £18,745 | £18,682 | £20,865 | £18,800 | £17,866 | £18,606 | £17,832 | £17,627 |
| Long-term Liabilities | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £35,000 | £35,000 | £35,000 | £34,770 | £34,540 |
| Total Liabilities | £34,500 | £35,253 | £34,144 | £34,185 | £34,398 | £33,745 | £33,682 | £35,865 | £53,800 | £52,866 | £53,606 | £52,602 | £52,167 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retained Earnings | £3,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 |
| Earnings | £4,000 | (£490) | (£803) | (£1,006) | £194 | £718 | £944 | £281 | (£676) | (£331) | £1,204 | £1,858 | £2,444 |
| Total Capital | £7,000 | £6,510 | £6,197 | £5,994 | £7,194 | £7,718 | £7,944 | £7,281 | £6,324 | £6,669 | £8,204 | £8,858 | £9,444 |
| Total Liabilities and Capital | £41,500 | £41,764 | £40,342 | £40,179 | £41,592 | £41,463 | £41,626 | £43,146 | £60,124 | £59,535 | £61,811 | £61,460 | £61,611 |
| Net Worth | £7,000 | £6,510 | £6,197 | £5,994 | £7,194 | £7,718 | £7,944 | £7,281 | £6,324 | £6,669 | £8,204 | £8,858 | £9,444 |