| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Shuttle Tickets | 0% | £40,000 | £40,000 | £45,000 | £45,000 | £50,000 | £50,000 | £50,000 | £40,000 | £50,000 | £40,000 | £50,000 | £50,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £40,000 | £40,000 | £45,000 | £45,000 | £50,000 | £50,000 | £50,000 | £40,000 | £50,000 | £40,000 | £50,000 | £50,000 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Shuttle Tickets | £0 | £5,000 | £6,000 | £6,000 | £7,000 | £7,000 | £7,000 | £6,000 | £6,000 | £5,000 | £6,000 | £6,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £5,000 | £6,000 | £6,000 | £7,000 | £7,000 | £7,000 | £6,000 | £6,000 | £5,000 | £6,000 | £6,000 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Bob Wilson | 0% | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Mary Wilson | 0% | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Drivers | 0% | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 |
| Office Staff/Sales | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Total People | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | |
| Total Payroll | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,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% | 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 | £40,000 | £40,000 | £45,000 | £45,000 | £50,000 | £50,000 | £50,000 | £40,000 | £50,000 | £40,000 | £50,000 | £50,000 | |
| Direct Cost of Sales | £0 | £5,000 | £6,000 | £6,000 | £7,000 | £7,000 | £7,000 | £6,000 | £6,000 | £5,000 | £6,000 | £6,000 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £5,000 | £6,000 | £6,000 | £7,000 | £7,000 | £7,000 | £6,000 | £6,000 | £5,000 | £6,000 | £6,000 | |
| Gross Margin | £40,000 | £35,000 | £39,000 | £39,000 | £43,000 | £43,000 | £43,000 | £34,000 | £44,000 | £35,000 | £44,000 | £44,000 | |
| Gross Margin % | 100.00% | 87.50% | 86.67% | 86.67% | 86.00% | 86.00% | 86.00% | 85.00% | 88.00% | 87.50% | 88.00% | 88.00% | |
| Expenses | |||||||||||||
| Payroll | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | |
| Sales and Marketing and Other Expenses | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Depreciation | £1,547 | £1,547 | £1,547 | £1,547 | £1,547 | £1,547 | £1,547 | £1,547 | £1,547 | £1,547 | £1,547 | £1,547 | |
| 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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Rent | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Payroll Taxes | 15% | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £36,147 | £36,147 | £36,147 | £36,147 | £36,147 | £36,147 | £36,147 | £36,147 | £36,147 | £36,147 | £36,147 | £36,147 | |
| Profit Before Interest and Taxes | £3,853 | (£1,147) | £2,853 | £2,853 | £6,853 | £6,853 | £6,853 | (£2,147) | £7,853 | (£1,147) | £7,853 | £7,853 | |
| EBITDA | £5,400 | £400 | £4,400 | £4,400 | £8,400 | £8,400 | £8,400 | (£600) | £9,400 | £400 | £9,400 | £9,400 | |
| Interest Expense | £655 | £643 | £632 | £620 | £608 | £597 | £585 | £573 | £562 | £550 | £538 | £527 | |
| Taxes Incurred | £959 | (£537) | £666 | £670 | £1,873 | £1,877 | £1,880 | (£816) | £2,187 | (£509) | £2,194 | £2,198 | |
| Net Profit | £2,239 | (£1,253) | £1,555 | £1,563 | £4,371 | £4,379 | £4,388 | (£1,904) | £5,104 | (£1,188) | £5,120 | £5,128 | |
| Net Profit/Sales | 5.60% | -3.13% | 3.46% | 3.47% | 8.74% | 8.76% | 8.78% | -4.76% | 10.21% | -2.97% | 10.24% | 10.26% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £40,000 | £40,000 | £45,000 | £45,000 | £50,000 | £50,000 | £50,000 | £40,000 | £50,000 | £40,000 | £50,000 | £50,000 | |
| Subtotal Cash from Operations | £40,000 | £40,000 | £45,000 | £45,000 | £50,000 | £50,000 | £50,000 | £40,000 | £50,000 | £40,000 | £50,000 | £50,000 | |
| 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) | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| 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 | £42,000 | £42,000 | £47,000 | £47,000 | £52,000 | £52,000 | £52,000 | £42,000 | £52,000 | £42,000 | £52,000 | £52,000 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | |
| Bill Payments | £16,407 | £12,331 | £15,779 | £17,898 | £17,963 | £20,081 | £20,073 | £19,942 | £16,457 | £19,225 | £15,764 | £19,332 | |
| Subtotal Spent on Operations | £40,407 | £36,331 | £39,779 | £41,898 | £41,963 | £44,081 | £44,073 | £43,942 | £40,457 | £43,225 | £39,764 | £43,332 | |
| 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 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | |
| Purchase Other Current Assets | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Purchase Long-term Assets | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £45,807 | £41,731 | £45,179 | £47,298 | £47,363 | £49,481 | £49,473 | £49,342 | £45,857 | £48,625 | £45,164 | £48,732 | |
| Net Cash Flow | (£3,807) | £269 | £1,821 | (£298) | £4,637 | £2,519 | £2,527 | (£7,342) | £6,143 | (£6,625) | £6,836 | £3,268 | |
| Cash Balance | £46,193 | £46,462 | £48,283 | £47,985 | £52,622 | £55,141 | £57,667 | £50,325 | £56,468 | £49,843 | £56,679 | £59,947 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £50,000 | £46,193 | £46,462 | £48,283 | £47,985 | £52,622 | £55,141 | £57,667 | £50,325 | £56,468 | £49,843 | £56,679 | £59,947 |
| Other Current Assets | £0 | £2,000 | £4,000 | £6,000 | £8,000 | £10,000 | £12,000 | £14,000 | £16,000 | £18,000 | £20,000 | £22,000 | £24,000 |
| Total Current Assets | £50,000 | £48,193 | £50,462 | £54,283 | £55,985 | £62,622 | £67,141 | £71,667 | £66,325 | £74,468 | £69,843 | £78,679 | £83,947 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £130,000 | £132,000 | £134,000 | £136,000 | £138,000 | £140,000 | £142,000 | £144,000 | £146,000 | £148,000 | £150,000 | £152,000 | £154,000 |
| Accumulated Depreciation | £24,000 | £25,547 | £27,094 | £28,641 | £30,188 | £31,735 | £33,282 | £34,829 | £36,376 | £37,923 | £39,470 | £41,017 | £42,564 |
| Total Long-term Assets | £106,000 | £106,453 | £106,906 | £107,359 | £107,812 | £108,265 | £108,718 | £109,171 | £109,624 | £110,077 | £110,530 | £110,983 | £111,436 |
| Total Assets | £156,000 | £154,646 | £157,368 | £161,642 | £163,797 | £170,887 | £175,859 | £180,838 | £175,949 | £184,545 | £180,373 | £189,662 | £195,383 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £16,000 | £11,807 | £15,183 | £17,301 | £17,294 | £19,412 | £19,404 | £19,397 | £15,812 | £18,704 | £15,120 | £18,688 | £18,680 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £2,000 | £4,000 | £6,000 | £8,000 | £10,000 | £12,000 | £14,000 | £16,000 | £18,000 | £20,000 | £22,000 | £24,000 |
| Subtotal Current Liabilities | £16,000 | £13,807 | £19,183 | £23,301 | £25,294 | £29,412 | £31,404 | £33,397 | £31,812 | £36,704 | £35,120 | £40,688 | £42,680 |
| Long-term Liabilities | £80,000 | £78,600 | £77,200 | £75,800 | £74,400 | £73,000 | £71,600 | £70,200 | £68,800 | £67,400 | £66,000 | £64,600 | £63,200 |
| Total Liabilities | £96,000 | £92,407 | £96,383 | £99,101 | £99,694 | £102,412 | £103,004 | £103,597 | £100,612 | £104,104 | £101,120 | £105,288 | £105,880 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retained Earnings | £45,500 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 |
| Earnings | £14,500 | £2,239 | £985 | £2,540 | £4,103 | £8,475 | £12,854 | £17,242 | £15,337 | £20,441 | £19,253 | £24,374 | £29,502 |
| Total Capital | £60,000 | £62,239 | £60,985 | £62,540 | £64,103 | £68,475 | £72,854 | £77,242 | £75,337 | £80,441 | £79,254 | £84,374 | £89,502 |
| Total Liabilities and Capital | £156,000 | £154,646 | £157,368 | £161,642 | £163,797 | £170,887 | £175,859 | £180,838 | £175,949 | £184,545 | £180,373 | £189,662 | £195,383 |
| Net Worth | £60,000 | £62,239 | £60,985 | £62,540 | £64,103 | £68,475 | £72,854 | £77,242 | £75,337 | £80,441 | £79,254 | £84,374 | £89,502 |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Shuttle Tickets | 0% | £40,000 | £40,000 | £45,000 | £45,000 | £50,000 | £50,000 | £50,000 | £40,000 | £50,000 | £40,000 | £50,000 | £50,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £40,000 | £40,000 | £45,000 | £45,000 | £50,000 | £50,000 | £50,000 | £40,000 | £50,000 | £40,000 | £50,000 | £50,000 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Shuttle Tickets | £0 | £5,000 | £6,000 | £6,000 | £7,000 | £7,000 | £7,000 | £6,000 | £6,000 | £5,000 | £6,000 | £6,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £5,000 | £6,000 | £6,000 | £7,000 | £7,000 | £7,000 | £6,000 | £6,000 | £5,000 | £6,000 | £6,000 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Bob Wilson | 0% | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Mary Wilson | 0% | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Drivers | 0% | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 | £16,000 |
| Office Staff/Sales | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Total People | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | |
| Total Payroll | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,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% | 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 | £40,000 | £40,000 | £45,000 | £45,000 | £50,000 | £50,000 | £50,000 | £40,000 | £50,000 | £40,000 | £50,000 | £50,000 | |
| Direct Cost of Sales | £0 | £5,000 | £6,000 | £6,000 | £7,000 | £7,000 | £7,000 | £6,000 | £6,000 | £5,000 | £6,000 | £6,000 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £5,000 | £6,000 | £6,000 | £7,000 | £7,000 | £7,000 | £6,000 | £6,000 | £5,000 | £6,000 | £6,000 | |
| Gross Margin | £40,000 | £35,000 | £39,000 | £39,000 | £43,000 | £43,000 | £43,000 | £34,000 | £44,000 | £35,000 | £44,000 | £44,000 | |
| Gross Margin % | 100.00% | 87.50% | 86.67% | 86.67% | 86.00% | 86.00% | 86.00% | 85.00% | 88.00% | 87.50% | 88.00% | 88.00% | |
| Expenses | |||||||||||||
| Payroll | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | |
| Sales and Marketing and Other Expenses | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Depreciation | £1,547 | £1,547 | £1,547 | £1,547 | £1,547 | £1,547 | £1,547 | £1,547 | £1,547 | £1,547 | £1,547 | £1,547 | |
| 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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Rent | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Payroll Taxes | 15% | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £36,147 | £36,147 | £36,147 | £36,147 | £36,147 | £36,147 | £36,147 | £36,147 | £36,147 | £36,147 | £36,147 | £36,147 | |
| Profit Before Interest and Taxes | £3,853 | (£1,147) | £2,853 | £2,853 | £6,853 | £6,853 | £6,853 | (£2,147) | £7,853 | (£1,147) | £7,853 | £7,853 | |
| EBITDA | £5,400 | £400 | £4,400 | £4,400 | £8,400 | £8,400 | £8,400 | (£600) | £9,400 | £400 | £9,400 | £9,400 | |
| Interest Expense | £655 | £643 | £632 | £620 | £608 | £597 | £585 | £573 | £562 | £550 | £538 | £527 | |
| Taxes Incurred | £959 | (£537) | £666 | £670 | £1,873 | £1,877 | £1,880 | (£816) | £2,187 | (£509) | £2,194 | £2,198 | |
| Net Profit | £2,239 | (£1,253) | £1,555 | £1,563 | £4,371 | £4,379 | £4,388 | (£1,904) | £5,104 | (£1,188) | £5,120 | £5,128 | |
| Net Profit/Sales | 5.60% | -3.13% | 3.46% | 3.47% | 8.74% | 8.76% | 8.78% | -4.76% | 10.21% | -2.97% | 10.24% | 10.26% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £40,000 | £40,000 | £45,000 | £45,000 | £50,000 | £50,000 | £50,000 | £40,000 | £50,000 | £40,000 | £50,000 | £50,000 | |
| Subtotal Cash from Operations | £40,000 | £40,000 | £45,000 | £45,000 | £50,000 | £50,000 | £50,000 | £40,000 | £50,000 | £40,000 | £50,000 | £50,000 | |
| 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) | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| 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 | £42,000 | £42,000 | £47,000 | £47,000 | £52,000 | £52,000 | £52,000 | £42,000 | £52,000 | £42,000 | £52,000 | £52,000 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 | |
| Bill Payments | £16,407 | £12,331 | £15,779 | £17,898 | £17,963 | £20,081 | £20,073 | £19,942 | £16,457 | £19,225 | £15,764 | £19,332 | |
| Subtotal Spent on Operations | £40,407 | £36,331 | £39,779 | £41,898 | £41,963 | £44,081 | £44,073 | £43,942 | £40,457 | £43,225 | £39,764 | £43,332 | |
| 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 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | |
| Purchase Other Current Assets | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Purchase Long-term Assets | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £45,807 | £41,731 | £45,179 | £47,298 | £47,363 | £49,481 | £49,473 | £49,342 | £45,857 | £48,625 | £45,164 | £48,732 | |
| Net Cash Flow | (£3,807) | £269 | £1,821 | (£298) | £4,637 | £2,519 | £2,527 | (£7,342) | £6,143 | (£6,625) | £6,836 | £3,268 | |
| Cash Balance | £46,193 | £46,462 | £48,283 | £47,985 | £52,622 | £55,141 | £57,667 | £50,325 | £56,468 | £49,843 | £56,679 | £59,947 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £50,000 | £46,193 | £46,462 | £48,283 | £47,985 | £52,622 | £55,141 | £57,667 | £50,325 | £56,468 | £49,843 | £56,679 | £59,947 |
| Other Current Assets | £0 | £2,000 | £4,000 | £6,000 | £8,000 | £10,000 | £12,000 | £14,000 | £16,000 | £18,000 | £20,000 | £22,000 | £24,000 |
| Total Current Assets | £50,000 | £48,193 | £50,462 | £54,283 | £55,985 | £62,622 | £67,141 | £71,667 | £66,325 | £74,468 | £69,843 | £78,679 | £83,947 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £130,000 | £132,000 | £134,000 | £136,000 | £138,000 | £140,000 | £142,000 | £144,000 | £146,000 | £148,000 | £150,000 | £152,000 | £154,000 |
| Accumulated Depreciation | £24,000 | £25,547 | £27,094 | £28,641 | £30,188 | £31,735 | £33,282 | £34,829 | £36,376 | £37,923 | £39,470 | £41,017 | £42,564 |
| Total Long-term Assets | £106,000 | £106,453 | £106,906 | £107,359 | £107,812 | £108,265 | £108,718 | £109,171 | £109,624 | £110,077 | £110,530 | £110,983 | £111,436 |
| Total Assets | £156,000 | £154,646 | £157,368 | £161,642 | £163,797 | £170,887 | £175,859 | £180,838 | £175,949 | £184,545 | £180,373 | £189,662 | £195,383 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £16,000 | £11,807 | £15,183 | £17,301 | £17,294 | £19,412 | £19,404 | £19,397 | £15,812 | £18,704 | £15,120 | £18,688 | £18,680 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £2,000 | £4,000 | £6,000 | £8,000 | £10,000 | £12,000 | £14,000 | £16,000 | £18,000 | £20,000 | £22,000 | £24,000 |
| Subtotal Current Liabilities | £16,000 | £13,807 | £19,183 | £23,301 | £25,294 | £29,412 | £31,404 | £33,397 | £31,812 | £36,704 | £35,120 | £40,688 | £42,680 |
| Long-term Liabilities | £80,000 | £78,600 | £77,200 | £75,800 | £74,400 | £73,000 | £71,600 | £70,200 | £68,800 | £67,400 | £66,000 | £64,600 | £63,200 |
| Total Liabilities | £96,000 | £92,407 | £96,383 | £99,101 | £99,694 | £102,412 | £103,004 | £103,597 | £100,612 | £104,104 | £101,120 | £105,288 | £105,880 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retained Earnings | £45,500 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 | £60,000 |
| Earnings | £14,500 | £2,239 | £985 | £2,540 | £4,103 | £8,475 | £12,854 | £17,242 | £15,337 | £20,441 | £19,253 | £24,374 | £29,502 |
| Total Capital | £60,000 | £62,239 | £60,985 | £62,540 | £64,103 | £68,475 | £72,854 | £77,242 | £75,337 | £80,441 | £79,254 | £84,374 | £89,502 |
| Total Liabilities and Capital | £156,000 | £154,646 | £157,368 | £161,642 | £163,797 | £170,887 | £175,859 | £180,838 | £175,949 | £184,545 | £180,373 | £189,662 | £195,383 |
| Net Worth | £60,000 | £62,239 | £60,985 | £62,540 | £64,103 | £68,475 | £72,854 | £77,242 | £75,337 | £80,441 | £79,254 | £84,374 | £89,502 |