| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Families | 0% | £0 | £3,445 | £3,665 | £3,701 | £3,898 | £3,998 | £4,141 | £4,202 | £4,336 | £4,454 | £4,545 | £4,641 |
| Individuals | 0% | £0 | £2,722 | £2,895 | £2,924 | £3,079 | £3,158 | £3,271 | £3,320 | £3,425 | £3,519 | £3,591 | £3,666 |
| Total Sales | £0 | £6,167 | £6,560 | £6,625 | £6,977 | £7,156 | £7,412 | £7,522 | £7,761 | £7,973 | £8,136 | £8,307 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Families | £0 | £1,034 | £1,100 | £1,110 | £1,169 | £1,199 | £1,242 | £1,261 | £1,301 | £1,336 | £1,364 | £1,392 | |
| Individuals | £0 | £816 | £869 | £877 | £924 | £948 | £981 | £996 | £1,028 | £1,056 | £1,077 | £1,100 | |
| Subtotal Direct Cost of Sales | £0 | £1,850 | £1,968 | £1,987 | £2,093 | £2,147 | £2,224 | £2,256 | £2,328 | £2,392 | £2,441 | £2,492 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Kevin | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Cook | 0% | £0 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 |
| Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Misc. | 0% | £0 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 |
| Total People | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £2,000 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | |
| 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% | 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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £0 | £6,167 | £6,560 | £6,625 | £6,977 | £7,156 | £7,412 | £7,522 | £7,761 | £7,973 | £8,136 | £8,307 | |
| Direct Cost of Sales | £0 | £1,850 | £1,968 | £1,987 | £2,093 | £2,147 | £2,224 | £2,256 | £2,328 | £2,392 | £2,441 | £2,492 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £1,850 | £1,968 | £1,987 | £2,093 | £2,147 | £2,224 | £2,256 | £2,328 | £2,392 | £2,441 | £2,492 | |
| Gross Margin | £0 | £4,317 | £4,592 | £4,637 | £4,884 | £5,009 | £5,189 | £5,265 | £5,433 | £5,581 | £5,695 | £5,815 | |
| Gross Margin % | 0.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | |
| Sales and Marketing and Other Expenses | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Depreciation | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | |
| Rent | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Utilities | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 15% | £300 | £608 | £608 | £608 | £608 | £608 | £608 | £608 | £608 | £608 | £608 | £608 |
| Other | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | |
| Total Operating Expenses | £4,908 | £7,266 | £7,266 | £7,266 | £7,266 | £7,266 | £7,266 | £7,266 | £7,266 | £7,266 | £7,266 | £7,266 | |
| Profit Before Interest and Taxes | (£4,908) | (£2,949) | (£2,673) | (£2,628) | (£2,381) | (£2,256) | (£2,077) | (£2,000) | (£1,832) | (£1,685) | (£1,571) | (£1,450) | |
| EBITDA | (£3,825) | (£1,866) | (£1,590) | (£1,545) | (£1,298) | (£1,173) | (£994) | (£917) | (£749) | (£602) | (£488) | (£367) | |
| Interest Expense | £24 | £190 | £186 | £181 | £177 | £172 | £168 | £163 | £158 | £154 | £149 | £145 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£4,932) | (£3,139) | (£2,859) | (£2,809) | (£2,558) | (£2,428) | (£2,244) | (£2,163) | (£1,991) | (£1,838) | (£1,720) | (£1,595) | |
| Net Profit/Sales | 0.00% | -50.91% | -43.58% | -42.41% | -36.66% | -33.93% | -30.28% | -28.76% | -25.65% | -23.06% | -21.14% | -19.20% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £0 | £6,167 | £6,560 | £6,625 | £6,977 | £7,156 | £7,412 | £7,522 | £7,761 | £7,973 | £8,136 | £8,307 | |
| Subtotal Cash from Operations | £0 | £6,167 | £6,560 | £6,625 | £6,977 | £7,156 | £7,412 | £7,522 | £7,761 | £7,973 | £8,136 | £8,307 | |
| 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 | £20,000 | £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 | £10,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £10,000 | £26,167 | £6,560 | £6,625 | £6,977 | £7,156 | £7,412 | £7,522 | £7,761 | £7,973 | £8,136 | £8,307 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £2,000 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | |
| Bill Payments | £4,304 | £1,926 | £4,177 | £4,287 | £4,305 | £4,404 | £4,454 | £4,525 | £4,554 | £4,621 | £4,680 | £4,724 | |
| Subtotal Spent on Operations | £6,304 | £5,976 | £8,227 | £8,337 | £8,355 | £8,454 | £8,504 | £8,575 | £8,604 | £8,671 | £8,730 | £8,774 | |
| 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 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | |
| 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 | £6,304 | £5,976 | £8,777 | £8,887 | £8,905 | £9,004 | £9,054 | £9,125 | £9,154 | £9,221 | £9,280 | £9,324 | |
| Net Cash Flow | £3,696 | £20,190 | (£2,216) | (£2,262) | (£1,927) | (£1,848) | (£1,642) | (£1,603) | (£1,393) | (£1,249) | (£1,144) | (£1,017) | |
| Cash Balance | £8,685 | £28,876 | £26,659 | £24,397 | £22,470 | £20,622 | £18,981 | £17,377 | £15,985 | £14,736 | £13,592 | £12,575 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £4,989 | £8,685 | £28,876 | £26,659 | £24,397 | £22,470 | £20,622 | £18,981 | £17,377 | £15,985 | £14,736 | £13,592 | £12,575 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £4,989 | £8,685 | £28,876 | £26,659 | £24,397 | £22,470 | £20,622 | £18,981 | £17,377 | £15,985 | £14,736 | £13,592 | £12,575 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 |
| Accumulated Depreciation | £8,989 | £10,072 | £11,155 | £12,238 | £13,321 | £14,404 | £15,487 | £16,570 | £17,653 | £18,736 | £19,819 | £20,902 | £21,985 |
| Total Long-term Assets | £13,152 | £12,069 | £10,986 | £9,903 | £8,820 | £7,737 | £6,654 | £5,571 | £4,488 | £3,405 | £2,322 | £1,239 | £156 |
| Total Assets | £18,141 | £20,754 | £39,862 | £36,562 | £33,217 | £30,207 | £27,276 | £24,552 | £21,865 | £19,390 | £17,058 | £14,831 | £12,731 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £4,242 | £1,787 | £4,034 | £4,144 | £4,158 | £4,256 | £4,303 | £4,373 | £4,400 | £4,465 | £4,522 | £4,565 | £4,610 |
| Current Borrowing | £0 | £0 | £20,000 | £19,450 | £18,900 | £18,350 | £17,800 | £17,250 | £16,700 | £16,150 | £15,600 | £15,050 | £14,500 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £4,242 | £1,787 | £24,034 | £23,594 | £23,058 | £22,606 | £22,103 | £21,623 | £21,100 | £20,615 | £20,122 | £19,615 | £19,110 |
| Long-term Liabilities | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 |
| Total Liabilities | £7,100 | £4,645 | £26,892 | £26,452 | £25,916 | £25,464 | £24,961 | £24,481 | £23,958 | £23,473 | £22,980 | £22,473 | £21,968 |
| Paid-in Capital | £0 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Retained Earnings | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 |
| Earnings | £0 | (£4,932) | (£8,071) | (£10,930) | (£13,740) | (£16,298) | (£18,726) | (£20,970) | (£23,134) | (£25,125) | (£26,963) | (£28,683) | (£30,278) |
| Total Capital | £11,041 | £16,109 | £12,970 | £10,111 | £7,301 | £4,743 | £2,315 | £71 | (£2,093) | (£4,084) | (£5,922) | (£7,642) | (£9,237) |
| Total Liabilities and Capital | £18,141 | £20,754 | £39,862 | £36,562 | £33,217 | £30,207 | £27,276 | £24,552 | £21,865 | £19,390 | £17,058 | £14,831 | £12,731 |
| Net Worth | £11,041 | £16,109 | £12,970 | £10,111 | £7,301 | £4,743 | £2,315 | £71 | (£2,093) | (£4,084) | (£5,922) | (£7,642) | (£9,237) |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Families | 0% | £0 | £3,445 | £3,665 | £3,701 | £3,898 | £3,998 | £4,141 | £4,202 | £4,336 | £4,454 | £4,545 | £4,641 |
| Individuals | 0% | £0 | £2,722 | £2,895 | £2,924 | £3,079 | £3,158 | £3,271 | £3,320 | £3,425 | £3,519 | £3,591 | £3,666 |
| Total Sales | £0 | £6,167 | £6,560 | £6,625 | £6,977 | £7,156 | £7,412 | £7,522 | £7,761 | £7,973 | £8,136 | £8,307 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Families | £0 | £1,034 | £1,100 | £1,110 | £1,169 | £1,199 | £1,242 | £1,261 | £1,301 | £1,336 | £1,364 | £1,392 | |
| Individuals | £0 | £816 | £869 | £877 | £924 | £948 | £981 | £996 | £1,028 | £1,056 | £1,077 | £1,100 | |
| Subtotal Direct Cost of Sales | £0 | £1,850 | £1,968 | £1,987 | £2,093 | £2,147 | £2,224 | £2,256 | £2,328 | £2,392 | £2,441 | £2,492 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Kevin | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Cook | 0% | £0 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 | £1,150 |
| Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Misc. | 0% | £0 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 |
| Total People | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £2,000 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | |
| 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% | 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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £0 | £6,167 | £6,560 | £6,625 | £6,977 | £7,156 | £7,412 | £7,522 | £7,761 | £7,973 | £8,136 | £8,307 | |
| Direct Cost of Sales | £0 | £1,850 | £1,968 | £1,987 | £2,093 | £2,147 | £2,224 | £2,256 | £2,328 | £2,392 | £2,441 | £2,492 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £1,850 | £1,968 | £1,987 | £2,093 | £2,147 | £2,224 | £2,256 | £2,328 | £2,392 | £2,441 | £2,492 | |
| Gross Margin | £0 | £4,317 | £4,592 | £4,637 | £4,884 | £5,009 | £5,189 | £5,265 | £5,433 | £5,581 | £5,695 | £5,815 | |
| Gross Margin % | 0.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | |
| Sales and Marketing and Other Expenses | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Depreciation | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | |
| Rent | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Utilities | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 15% | £300 | £608 | £608 | £608 | £608 | £608 | £608 | £608 | £608 | £608 | £608 | £608 |
| Other | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | |
| Total Operating Expenses | £4,908 | £7,266 | £7,266 | £7,266 | £7,266 | £7,266 | £7,266 | £7,266 | £7,266 | £7,266 | £7,266 | £7,266 | |
| Profit Before Interest and Taxes | (£4,908) | (£2,949) | (£2,673) | (£2,628) | (£2,381) | (£2,256) | (£2,077) | (£2,000) | (£1,832) | (£1,685) | (£1,571) | (£1,450) | |
| EBITDA | (£3,825) | (£1,866) | (£1,590) | (£1,545) | (£1,298) | (£1,173) | (£994) | (£917) | (£749) | (£602) | (£488) | (£367) | |
| Interest Expense | £24 | £190 | £186 | £181 | £177 | £172 | £168 | £163 | £158 | £154 | £149 | £145 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£4,932) | (£3,139) | (£2,859) | (£2,809) | (£2,558) | (£2,428) | (£2,244) | (£2,163) | (£1,991) | (£1,838) | (£1,720) | (£1,595) | |
| Net Profit/Sales | 0.00% | -50.91% | -43.58% | -42.41% | -36.66% | -33.93% | -30.28% | -28.76% | -25.65% | -23.06% | -21.14% | -19.20% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £0 | £6,167 | £6,560 | £6,625 | £6,977 | £7,156 | £7,412 | £7,522 | £7,761 | £7,973 | £8,136 | £8,307 | |
| Subtotal Cash from Operations | £0 | £6,167 | £6,560 | £6,625 | £6,977 | £7,156 | £7,412 | £7,522 | £7,761 | £7,973 | £8,136 | £8,307 | |
| 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 | £20,000 | £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 | £10,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £10,000 | £26,167 | £6,560 | £6,625 | £6,977 | £7,156 | £7,412 | £7,522 | £7,761 | £7,973 | £8,136 | £8,307 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £2,000 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | £4,050 | |
| Bill Payments | £4,304 | £1,926 | £4,177 | £4,287 | £4,305 | £4,404 | £4,454 | £4,525 | £4,554 | £4,621 | £4,680 | £4,724 | |
| Subtotal Spent on Operations | £6,304 | £5,976 | £8,227 | £8,337 | £8,355 | £8,454 | £8,504 | £8,575 | £8,604 | £8,671 | £8,730 | £8,774 | |
| 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 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | |
| 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 | £6,304 | £5,976 | £8,777 | £8,887 | £8,905 | £9,004 | £9,054 | £9,125 | £9,154 | £9,221 | £9,280 | £9,324 | |
| Net Cash Flow | £3,696 | £20,190 | (£2,216) | (£2,262) | (£1,927) | (£1,848) | (£1,642) | (£1,603) | (£1,393) | (£1,249) | (£1,144) | (£1,017) | |
| Cash Balance | £8,685 | £28,876 | £26,659 | £24,397 | £22,470 | £20,622 | £18,981 | £17,377 | £15,985 | £14,736 | £13,592 | £12,575 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £4,989 | £8,685 | £28,876 | £26,659 | £24,397 | £22,470 | £20,622 | £18,981 | £17,377 | £15,985 | £14,736 | £13,592 | £12,575 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £4,989 | £8,685 | £28,876 | £26,659 | £24,397 | £22,470 | £20,622 | £18,981 | £17,377 | £15,985 | £14,736 | £13,592 | £12,575 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 | £22,141 |
| Accumulated Depreciation | £8,989 | £10,072 | £11,155 | £12,238 | £13,321 | £14,404 | £15,487 | £16,570 | £17,653 | £18,736 | £19,819 | £20,902 | £21,985 |
| Total Long-term Assets | £13,152 | £12,069 | £10,986 | £9,903 | £8,820 | £7,737 | £6,654 | £5,571 | £4,488 | £3,405 | £2,322 | £1,239 | £156 |
| Total Assets | £18,141 | £20,754 | £39,862 | £36,562 | £33,217 | £30,207 | £27,276 | £24,552 | £21,865 | £19,390 | £17,058 | £14,831 | £12,731 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £4,242 | £1,787 | £4,034 | £4,144 | £4,158 | £4,256 | £4,303 | £4,373 | £4,400 | £4,465 | £4,522 | £4,565 | £4,610 |
| Current Borrowing | £0 | £0 | £20,000 | £19,450 | £18,900 | £18,350 | £17,800 | £17,250 | £16,700 | £16,150 | £15,600 | £15,050 | £14,500 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £4,242 | £1,787 | £24,034 | £23,594 | £23,058 | £22,606 | £22,103 | £21,623 | £21,100 | £20,615 | £20,122 | £19,615 | £19,110 |
| Long-term Liabilities | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 | £2,858 |
| Total Liabilities | £7,100 | £4,645 | £26,892 | £26,452 | £25,916 | £25,464 | £24,961 | £24,481 | £23,958 | £23,473 | £22,980 | £22,473 | £21,968 |
| Paid-in Capital | £0 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Retained Earnings | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 | £11,041 |
| Earnings | £0 | (£4,932) | (£8,071) | (£10,930) | (£13,740) | (£16,298) | (£18,726) | (£20,970) | (£23,134) | (£25,125) | (£26,963) | (£28,683) | (£30,278) |
| Total Capital | £11,041 | £16,109 | £12,970 | £10,111 | £7,301 | £4,743 | £2,315 | £71 | (£2,093) | (£4,084) | (£5,922) | (£7,642) | (£9,237) |
| Total Liabilities and Capital | £18,141 | £20,754 | £39,862 | £36,562 | £33,217 | £30,207 | £27,276 | £24,552 | £21,865 | £19,390 | £17,058 | £14,831 | £12,731 |
| Net Worth | £11,041 | £16,109 | £12,970 | £10,111 | £7,301 | £4,743 | £2,315 | £71 | (£2,093) | (£4,084) | (£5,922) | (£7,642) | (£9,237) |