| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Apartment | 0% | £2,093 | £1,890 | £2,093 | £2,025 | £5,270 | £5,100 | £5,270 | £5,270 | £5,100 | £2,093 | £2,025 | £2,093 |
| Large Jacuzzi | 0% | £1,395 | £1,260 | £1,395 | £2,363 | £4,611 | £4,463 | £4,611 | £4,611 | £4,463 | £1,395 | £2,363 | £1,395 |
| Adjoining Unit | 0% | £1,116 | £1,008 | £1,116 | £1,080 | £3,953 | £3,825 | £3,953 | £3,953 | £3,825 | £1,116 | £1,080 | £1,116 |
| Smaller Unit | 0% | £977 | £882 | £977 | £945 | £3,294 | £3,188 | £3,294 | £3,294 | £3,188 | £977 | £945 | £977 |
| Total Sales | £5,580 | £5,040 | £5,580 | £6,413 | £17,128 | £16,575 | £17,128 | £17,128 | £16,575 | £5,580 | £6,413 | £5,580 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Apartment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Large Jacuzzi | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Adjoining Unit | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Smaller Unit | £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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| John Maesch | 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 |
| Frank Williams | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 |
| Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | |
| Total Payroll | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £2,000 | |
| 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 | 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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £5,580 | £5,040 | £5,580 | £6,413 | £17,128 | £16,575 | £17,128 | £17,128 | £16,575 | £5,580 | £6,413 | £5,580 | |
| 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,580 | £5,040 | £5,580 | £6,413 | £17,128 | £16,575 | £17,128 | £17,128 | £16,575 | £5,580 | £6,413 | £5,580 | |
| 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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £2,000 | |
| Sales and Marketing and Other Expenses | £392 | £217 | £217 | £217 | £217 | £217 | £217 | £217 | £217 | £217 | £217 | £217 | |
| Depreciation | £370 | £370 | £370 | £370 | £370 | £370 | £370 | £370 | £370 | £370 | £370 | £370 | |
| Insurance | £215 | £215 | £215 | £215 | £215 | £215 | £215 | £215 | £215 | £215 | £215 | £215 | |
| Telephone | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Security | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | |
| Duties & Subscriptions | £175 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | |
| Room/Housecleaning | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | |
| Groceries | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Payroll Taxes | 15% | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £300 | £300 | £300 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £3,520 | £3,170 | £3,170 | £3,170 | £3,170 | £3,170 | £3,170 | £3,170 | £3,170 | £4,320 | £4,320 | £4,320 | |
| Profit Before Interest and Taxes | £2,060 | £1,870 | £2,410 | £3,243 | £13,958 | £13,405 | £13,958 | £13,958 | £13,405 | £1,260 | £2,093 | £1,260 | |
| EBITDA | £2,430 | £2,240 | £2,780 | £3,613 | £14,328 | £13,775 | £14,328 | £14,328 | £13,775 | £1,630 | £2,463 | £1,630 | |
| Interest Expense | £4,375 | £4,375 | £4,375 | £4,375 | £4,375 | £4,375 | £4,375 | £4,375 | £4,375 | £4,375 | £4,375 | £4,375 | |
| Taxes Incurred | (£694) | (£626) | (£491) | (£283) | £2,396 | £2,258 | £2,396 | £2,396 | £2,258 | (£779) | (£571) | (£779) | |
| Net Profit | (£1,620) | (£1,879) | (£1,474) | (£849) | £7,187 | £6,773 | £7,187 | £7,187 | £6,773 | (£2,336) | (£1,712) | (£2,336) | |
| Net Profit/Sales | -29.04% | -37.27% | -26.41% | -13.24% | 41.96% | 40.86% | 41.96% | 41.96% | 40.86% | -41.86% | -26.69% | -41.86% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £1,395 | £1,260 | £1,395 | £1,603 | £4,282 | £4,144 | £4,282 | £4,282 | £4,144 | £1,395 | £1,603 | £1,395 | |
| Cash from Receivables | £2,000 | £2,140 | £4,172 | £3,794 | £4,206 | £5,077 | £12,832 | £12,445 | £12,846 | £12,832 | £12,156 | £4,206 | |
| Subtotal Cash from Operations | £3,395 | £3,400 | £5,567 | £5,397 | £8,488 | £9,221 | £17,114 | £16,727 | £16,989 | £14,227 | £13,760 | £5,601 | |
| 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 | £525,000 | £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 | £528,395 | £3,400 | £5,567 | £5,397 | £8,488 | £9,221 | £17,114 | £16,727 | £16,989 | £14,227 | £13,760 | £5,601 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £2,000 | |
| Bill Payments | £20,194 | £5,821 | £5,553 | £5,690 | £5,981 | £8,566 | £8,437 | £8,570 | £8,566 | £8,336 | £5,553 | £5,747 | |
| Subtotal Spent on Operations | £21,194 | £6,821 | £6,553 | £6,690 | £6,981 | £9,566 | £9,437 | £9,570 | £9,566 | £10,336 | £7,553 | £7,747 | |
| 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 | £500,000 | £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 | £21,194 | £6,821 | £506,553 | £6,690 | £6,981 | £9,566 | £9,437 | £9,570 | £9,566 | £10,336 | £7,553 | £7,747 | |
| Net Cash Flow | £507,201 | (£3,421) | (£500,987) | (£1,294) | £1,507 | (£345) | £7,677 | £7,157 | £7,424 | £3,891 | £6,207 | (£2,146) | |
| Cash Balance | £519,201 | £515,779 | £14,793 | £13,499 | £15,006 | £14,661 | £22,338 | £29,494 | £36,918 | £40,809 | £47,015 | £44,869 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £12,000 | £519,201 | £515,779 | £14,793 | £13,499 | £15,006 | £14,661 | £22,338 | £29,494 | £36,918 | £40,809 | £47,015 | £44,869 |
| Accounts Receivable | £4,000 | £6,185 | £7,826 | £7,839 | £8,855 | £17,495 | £24,849 | £24,863 | £25,263 | £24,849 | £16,202 | £8,855 | £8,834 |
| Other Current Assets | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Total Current Assets | £17,000 | £526,386 | £524,605 | £23,632 | £23,354 | £33,500 | £40,510 | £48,200 | £55,757 | £62,767 | £58,011 | £56,870 | £54,703 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £200,000 | £200,000 | £200,000 | £700,000 | £700,000 | £700,000 | £700,000 | £700,000 | £700,000 | £700,000 | £700,000 | £700,000 | £700,000 |
| Accumulated Depreciation | £30,000 | £30,370 | £30,740 | £31,110 | £31,480 | £31,850 | £32,220 | £32,590 | £32,960 | £33,330 | £33,700 | £34,070 | £34,440 |
| Total Long-term Assets | £170,000 | £169,630 | £169,260 | £668,890 | £668,520 | £668,150 | £667,780 | £667,410 | £667,040 | £666,670 | £666,300 | £665,930 | £665,560 |
| Total Assets | £187,000 | £696,016 | £693,865 | £692,522 | £691,874 | £701,650 | £708,290 | £715,610 | £722,797 | £729,437 | £724,311 | £722,800 | £720,263 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £20,000 | £5,636 | £5,364 | £5,494 | £5,695 | £8,285 | £8,151 | £8,285 | £8,285 | £8,151 | £5,361 | £5,562 | £5,361 |
| 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 | £20,000 | £5,636 | £5,364 | £5,494 | £5,695 | £8,285 | £8,151 | £8,285 | £8,285 | £8,151 | £5,361 | £5,562 | £5,361 |
| Long-term Liabilities | £0 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 |
| Total Liabilities | £20,000 | £530,636 | £530,364 | £530,494 | £530,695 | £533,285 | £533,151 | £533,285 | £533,285 | £533,151 | £530,361 | £530,562 | £530,361 |
| Paid-in Capital | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Retained Earnings | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 |
| Earnings | £0 | (£1,620) | (£3,499) | (£4,972) | (£5,821) | £1,366 | £8,138 | £15,326 | £22,513 | £29,285 | £26,949 | £25,238 | £22,902 |
| Total Capital | £167,000 | £165,380 | £163,501 | £162,028 | £161,179 | £168,366 | £175,138 | £182,326 | £189,513 | £196,285 | £193,949 | £192,238 | £189,902 |
| Total Liabilities and Capital | £187,000 | £696,016 | £693,865 | £692,522 | £691,874 | £701,650 | £708,290 | £715,610 | £722,797 | £729,437 | £724,311 | £722,800 | £720,263 |
| Net Worth | £167,000 | £165,380 | £163,501 | £162,028 | £161,179 | £168,366 | £175,138 | £182,326 | £189,513 | £196,285 | £193,949 | £192,238 | £189,902 |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Apartment | 0% | £2,093 | £1,890 | £2,093 | £2,025 | £5,270 | £5,100 | £5,270 | £5,270 | £5,100 | £2,093 | £2,025 | £2,093 |
| Large Jacuzzi | 0% | £1,395 | £1,260 | £1,395 | £2,363 | £4,611 | £4,463 | £4,611 | £4,611 | £4,463 | £1,395 | £2,363 | £1,395 |
| Adjoining Unit | 0% | £1,116 | £1,008 | £1,116 | £1,080 | £3,953 | £3,825 | £3,953 | £3,953 | £3,825 | £1,116 | £1,080 | £1,116 |
| Smaller Unit | 0% | £977 | £882 | £977 | £945 | £3,294 | £3,188 | £3,294 | £3,294 | £3,188 | £977 | £945 | £977 |
| Total Sales | £5,580 | £5,040 | £5,580 | £6,413 | £17,128 | £16,575 | £17,128 | £17,128 | £16,575 | £5,580 | £6,413 | £5,580 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Apartment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Large Jacuzzi | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Adjoining Unit | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Smaller Unit | £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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| John Maesch | 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 |
| Frank Williams | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 |
| Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | |
| Total Payroll | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £2,000 | |
| 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 | 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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £5,580 | £5,040 | £5,580 | £6,413 | £17,128 | £16,575 | £17,128 | £17,128 | £16,575 | £5,580 | £6,413 | £5,580 | |
| 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,580 | £5,040 | £5,580 | £6,413 | £17,128 | £16,575 | £17,128 | £17,128 | £16,575 | £5,580 | £6,413 | £5,580 | |
| 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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £2,000 | |
| Sales and Marketing and Other Expenses | £392 | £217 | £217 | £217 | £217 | £217 | £217 | £217 | £217 | £217 | £217 | £217 | |
| Depreciation | £370 | £370 | £370 | £370 | £370 | £370 | £370 | £370 | £370 | £370 | £370 | £370 | |
| Insurance | £215 | £215 | £215 | £215 | £215 | £215 | £215 | £215 | £215 | £215 | £215 | £215 | |
| Telephone | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Security | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | |
| Duties & Subscriptions | £175 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | |
| Room/Housecleaning | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | |
| Groceries | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Payroll Taxes | 15% | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £300 | £300 | £300 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £3,520 | £3,170 | £3,170 | £3,170 | £3,170 | £3,170 | £3,170 | £3,170 | £3,170 | £4,320 | £4,320 | £4,320 | |
| Profit Before Interest and Taxes | £2,060 | £1,870 | £2,410 | £3,243 | £13,958 | £13,405 | £13,958 | £13,958 | £13,405 | £1,260 | £2,093 | £1,260 | |
| EBITDA | £2,430 | £2,240 | £2,780 | £3,613 | £14,328 | £13,775 | £14,328 | £14,328 | £13,775 | £1,630 | £2,463 | £1,630 | |
| Interest Expense | £4,375 | £4,375 | £4,375 | £4,375 | £4,375 | £4,375 | £4,375 | £4,375 | £4,375 | £4,375 | £4,375 | £4,375 | |
| Taxes Incurred | (£694) | (£626) | (£491) | (£283) | £2,396 | £2,258 | £2,396 | £2,396 | £2,258 | (£779) | (£571) | (£779) | |
| Net Profit | (£1,620) | (£1,879) | (£1,474) | (£849) | £7,187 | £6,773 | £7,187 | £7,187 | £6,773 | (£2,336) | (£1,712) | (£2,336) | |
| Net Profit/Sales | -29.04% | -37.27% | -26.41% | -13.24% | 41.96% | 40.86% | 41.96% | 41.96% | 40.86% | -41.86% | -26.69% | -41.86% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £1,395 | £1,260 | £1,395 | £1,603 | £4,282 | £4,144 | £4,282 | £4,282 | £4,144 | £1,395 | £1,603 | £1,395 | |
| Cash from Receivables | £2,000 | £2,140 | £4,172 | £3,794 | £4,206 | £5,077 | £12,832 | £12,445 | £12,846 | £12,832 | £12,156 | £4,206 | |
| Subtotal Cash from Operations | £3,395 | £3,400 | £5,567 | £5,397 | £8,488 | £9,221 | £17,114 | £16,727 | £16,989 | £14,227 | £13,760 | £5,601 | |
| 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 | £525,000 | £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 | £528,395 | £3,400 | £5,567 | £5,397 | £8,488 | £9,221 | £17,114 | £16,727 | £16,989 | £14,227 | £13,760 | £5,601 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | £2,000 | |
| Bill Payments | £20,194 | £5,821 | £5,553 | £5,690 | £5,981 | £8,566 | £8,437 | £8,570 | £8,566 | £8,336 | £5,553 | £5,747 | |
| Subtotal Spent on Operations | £21,194 | £6,821 | £6,553 | £6,690 | £6,981 | £9,566 | £9,437 | £9,570 | £9,566 | £10,336 | £7,553 | £7,747 | |
| 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 | £500,000 | £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 | £21,194 | £6,821 | £506,553 | £6,690 | £6,981 | £9,566 | £9,437 | £9,570 | £9,566 | £10,336 | £7,553 | £7,747 | |
| Net Cash Flow | £507,201 | (£3,421) | (£500,987) | (£1,294) | £1,507 | (£345) | £7,677 | £7,157 | £7,424 | £3,891 | £6,207 | (£2,146) | |
| Cash Balance | £519,201 | £515,779 | £14,793 | £13,499 | £15,006 | £14,661 | £22,338 | £29,494 | £36,918 | £40,809 | £47,015 | £44,869 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £12,000 | £519,201 | £515,779 | £14,793 | £13,499 | £15,006 | £14,661 | £22,338 | £29,494 | £36,918 | £40,809 | £47,015 | £44,869 |
| Accounts Receivable | £4,000 | £6,185 | £7,826 | £7,839 | £8,855 | £17,495 | £24,849 | £24,863 | £25,263 | £24,849 | £16,202 | £8,855 | £8,834 |
| Other Current Assets | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Total Current Assets | £17,000 | £526,386 | £524,605 | £23,632 | £23,354 | £33,500 | £40,510 | £48,200 | £55,757 | £62,767 | £58,011 | £56,870 | £54,703 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £200,000 | £200,000 | £200,000 | £700,000 | £700,000 | £700,000 | £700,000 | £700,000 | £700,000 | £700,000 | £700,000 | £700,000 | £700,000 |
| Accumulated Depreciation | £30,000 | £30,370 | £30,740 | £31,110 | £31,480 | £31,850 | £32,220 | £32,590 | £32,960 | £33,330 | £33,700 | £34,070 | £34,440 |
| Total Long-term Assets | £170,000 | £169,630 | £169,260 | £668,890 | £668,520 | £668,150 | £667,780 | £667,410 | £667,040 | £666,670 | £666,300 | £665,930 | £665,560 |
| Total Assets | £187,000 | £696,016 | £693,865 | £692,522 | £691,874 | £701,650 | £708,290 | £715,610 | £722,797 | £729,437 | £724,311 | £722,800 | £720,263 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £20,000 | £5,636 | £5,364 | £5,494 | £5,695 | £8,285 | £8,151 | £8,285 | £8,285 | £8,151 | £5,361 | £5,562 | £5,361 |
| 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 | £20,000 | £5,636 | £5,364 | £5,494 | £5,695 | £8,285 | £8,151 | £8,285 | £8,285 | £8,151 | £5,361 | £5,562 | £5,361 |
| Long-term Liabilities | £0 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 |
| Total Liabilities | £20,000 | £530,636 | £530,364 | £530,494 | £530,695 | £533,285 | £533,151 | £533,285 | £533,285 | £533,151 | £530,361 | £530,562 | £530,361 |
| Paid-in Capital | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Retained Earnings | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 | £117,000 |
| Earnings | £0 | (£1,620) | (£3,499) | (£4,972) | (£5,821) | £1,366 | £8,138 | £15,326 | £22,513 | £29,285 | £26,949 | £25,238 | £22,902 |
| Total Capital | £167,000 | £165,380 | £163,501 | £162,028 | £161,179 | £168,366 | £175,138 | £182,326 | £189,513 | £196,285 | £193,949 | £192,238 | £189,902 |
| Total Liabilities and Capital | £187,000 | £696,016 | £693,865 | £692,522 | £691,874 | £701,650 | £708,290 | £715,610 | £722,797 | £729,437 | £724,311 | £722,800 | £720,263 |
| Net Worth | £167,000 | £165,380 | £163,501 | £162,028 | £161,179 | £168,366 | £175,138 | £182,326 | £189,513 | £196,285 | £193,949 | £192,238 | £189,902 |