| Sales Forecast | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | |||||||||||||
| Supermarkets | 0% | £9,000 | £9,000 | £10,000 | £9,000 | £10,000 | £10,000 | £10,000 | £11,000 | £12,000 | £12,000 | £13,000 | £13,000 |
| Grocery Stores | 0% | £14,000 | £14,000 | £14,000 | £15,000 | £15,000 | £15,000 | £15,000 | £16,000 | £16,000 | £16,000 | £17,000 | £18,000 |
| Total Sales | £23,000 | £23,000 | £24,000 | £24,000 | £25,000 | £25,000 | £25,000 | £27,000 | £28,000 | £28,000 | £30,000 | £31,000 | |
| Direct Cost of Sales | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Supermarkets | £900 | £900 | £1,000 | £900 | £1,000 | £1,000 | £1,000 | £1,100 | £1,200 | £1,200 | £1,300 | £1,300 | |
| Grocery Stores | £1,400 | £1,400 | £1,400 | £1,500 | £1,500 | £1,500 | £1,500 | £1,600 | £1,600 | £1,600 | £1,700 | £1,800 | |
| Subtotal Direct Cost of Sales | £2,300 | £2,300 | £2,400 | £2,400 | £2,500 | £2,500 | £2,500 | £2,700 | £2,800 | £2,800 | £3,000 | £3,100 | |
| Personnel Plan | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Production Manager | 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 |
| Sales Manager | 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 |
| Production Staff | 0% | £6,800 | £6,800 | £6,800 | £6,800 | £6,800 | £6,800 | £6,800 | £6,800 | £6,800 | £6,800 | £6,800 | £6,800 |
| Delivery | 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 |
| Store Staff | 0% | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Total People | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
| Total Payroll | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | |
| General Assumptions | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| 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 | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | £23,000 | £23,000 | £24,000 | £24,000 | £25,000 | £25,000 | £25,000 | £27,000 | £28,000 | £28,000 | £30,000 | £31,000 | |
| Direct Cost of Sales | £2,300 | £2,300 | £2,400 | £2,400 | £2,500 | £2,500 | £2,500 | £2,700 | £2,800 | £2,800 | £3,000 | £3,100 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £2,300 | £2,300 | £2,400 | £2,400 | £2,500 | £2,500 | £2,500 | £2,700 | £2,800 | £2,800 | £3,000 | £3,100 | |
| Gross Margin | £20,700 | £20,700 | £21,600 | £21,600 | £22,500 | £22,500 | £22,500 | £24,300 | £25,200 | £25,200 | £27,000 | £27,900 | |
| Gross Margin % | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | |
| Expenses | |||||||||||||
| Payroll | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | |
| Sales and Marketing and Other Expenses | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Rent | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Payroll Taxes | 15% | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £22,490 | £22,490 | £22,490 | £22,490 | £22,490 | £22,490 | £22,490 | £22,490 | £22,490 | £22,490 | £22,490 | £22,490 | |
| Profit Before Interest and Taxes | (£1,790) | (£1,790) | (£890) | (£890) | £10 | £10 | £10 | £1,810 | £2,710 | £2,710 | £4,510 | £5,410 | |
| EBITDA | (£990) | (£990) | (£90) | (£90) | £810 | £810 | £810 | £2,610 | £3,510 | £3,510 | £5,310 | £6,210 | |
| Interest Expense | £345 | £332 | £402 | £388 | £458 | £445 | £432 | £418 | £405 | £392 | £378 | £365 | |
| Taxes Incurred | (£641) | (£636) | (£388) | (£383) | (£135) | (£131) | (£127) | £418 | £692 | £696 | £1,240 | £1,514 | |
| Net Profit | (£1,495) | (£1,485) | (£904) | (£895) | (£314) | (£305) | (£295) | £974 | £1,614 | £1,623 | £2,892 | £3,532 | |
| Net Profit/Sales | -6.50% | -6.46% | -3.77% | -3.73% | -1.26% | -1.22% | -1.18% | 3.61% | 5.76% | 5.80% | 9.64% | 11.39% | |
| Pro Forma Cash Flow | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £5,750 | £5,750 | £6,000 | £6,000 | £6,250 | £6,250 | £6,250 | £6,750 | £7,000 | £7,000 | £7,500 | £7,750 | |
| Cash from Receivables | £7,000 | £7,575 | £17,250 | £17,275 | £18,000 | £18,025 | £18,750 | £18,750 | £18,800 | £20,275 | £21,000 | £21,050 | |
| Subtotal Cash from Operations | £12,750 | £13,325 | £23,250 | £23,275 | £24,250 | £24,275 | £25,000 | £25,500 | £25,800 | £27,275 | £28,500 | £28,800 | |
| 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 | £30,000 | £0 | £10,000 | £0 | £10,000 | £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,750 | £13,325 | £33,250 | £23,275 | £34,250 | £24,275 | £25,000 | £25,500 | £25,800 | £27,275 | £28,500 | £28,800 | |
| Expenditures | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | |
| Bill Payments | £10,160 | £4,794 | £4,850 | £6,769 | £7,512 | £8,020 | £7,904 | £7,927 | £8,854 | £9,093 | £9,009 | £9,936 | |
| Subtotal Spent on Operations | £26,760 | £21,394 | £21,450 | £23,369 | £24,112 | £24,620 | £24,504 | £24,527 | £25,454 | £25,693 | £25,609 | £26,536 | |
| 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 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| 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 | £28,360 | £22,994 | £23,050 | £24,969 | £25,712 | £26,220 | £26,104 | £26,127 | £27,054 | £27,293 | £27,209 | £28,136 | |
| Net Cash Flow | £14,390 | (£9,669) | £10,200 | (£1,694) | £8,538 | (£1,945) | (£1,104) | (£627) | (£1,254) | (£18) | £1,291 | £664 | |
| Cash Balance | £84,390 | £74,721 | £84,921 | £83,226 | £91,764 | £89,819 | £88,715 | £88,088 | £86,834 | £86,816 | £88,107 | £88,771 | |
| Pro Forma Balance Sheet | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £70,000 | £84,390 | £74,721 | £84,921 | £83,226 | £91,764 | £89,819 | £88,715 | £88,088 | £86,834 | £86,816 | £88,107 | £88,771 |
| Accounts Receivable | £14,000 | £24,250 | £33,925 | £34,675 | £35,400 | £36,150 | £36,875 | £36,875 | £38,375 | £40,575 | £41,300 | £42,800 | £45,000 |
| Inventory | £8,000 | £5,700 | £3,400 | £2,640 | £2,640 | £2,750 | £2,750 | £2,750 | £2,970 | £3,080 | £3,080 | £3,300 | £3,410 |
| Other Current Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Total Current Assets | £97,000 | £119,340 | £117,046 | £127,236 | £126,266 | £135,664 | £134,444 | £133,340 | £134,433 | £135,489 | £136,196 | £139,207 | £142,181 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 |
| Accumulated Depreciation | £5,248 | £6,048 | £6,848 | £7,648 | £8,448 | £9,248 | £10,048 | £10,848 | £11,648 | £12,448 | £13,248 | £14,048 | £14,848 |
| Total Long-term Assets | £31,488 | £30,688 | £29,888 | £29,088 | £28,288 | £27,488 | £26,688 | £25,888 | £25,088 | £24,288 | £23,488 | £22,688 | £21,888 |
| Total Assets | £128,488 | £150,028 | £146,934 | £156,324 | £154,554 | £163,152 | £161,132 | £159,228 | £159,521 | £159,777 | £159,684 | £161,895 | £164,069 |
| Liabilities and Capital | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £10,000 | £4,635 | £4,626 | £6,519 | £7,245 | £7,756 | £7,641 | £7,632 | £8,551 | £8,793 | £8,678 | £9,597 | £9,839 |
| Current Borrowing | £3,000 | £2,900 | £2,800 | £2,700 | £2,600 | £2,500 | £2,400 | £2,300 | £2,200 | £2,100 | £2,000 | £1,900 | £1,800 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £13,000 | £7,535 | £7,426 | £9,219 | £9,845 | £10,256 | £10,041 | £9,932 | £10,751 | £10,893 | £10,678 | £11,497 | £11,639 |
| Long-term Liabilities | £10,000 | £38,500 | £37,000 | £45,500 | £44,000 | £52,500 | £51,000 | £49,500 | £48,000 | £46,500 | £45,000 | £43,500 | £42,000 |
| Total Liabilities | £23,000 | £46,035 | £44,426 | £54,719 | £53,845 | £62,756 | £61,041 | £59,432 | £58,751 | £57,393 | £55,678 | £54,997 | £53,639 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retained Earnings | £81,488 | £105,488 | £105,488 | £105,488 | £105,488 | £105,488 | £105,488 | £105,488 | £105,488 | £105,488 | £105,488 | £105,488 | £105,488 |
| Earnings | £24,000 | (£1,495) | (£2,980) | (£3,884) | (£4,779) | (£5,092) | (£5,397) | (£5,692) | (£4,718) | (£3,104) | (£1,482) | £1,411 | £4,942 |
| Total Capital | £105,488 | £103,994 | £102,508 | £101,604 | £100,709 | £100,396 | £100,091 | £99,796 | £100,770 | £102,384 | £104,006 | £106,899 | £110,430 |
| Total Liabilities and Capital | £128,488 | £150,028 | £146,934 | £156,324 | £154,554 | £163,152 | £161,132 | £159,228 | £159,521 | £159,777 | £159,684 | £161,895 | £164,069 |
| Net Worth | £105,488 | £103,994 | £102,508 | £101,604 | £100,709 | £100,396 | £100,091 | £99,796 | £100,770 | £102,384 | £104,006 | £106,899 | £110,430 |
| Sales Forecast | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | |||||||||||||
| Supermarkets | 0% | £9,000 | £9,000 | £10,000 | £9,000 | £10,000 | £10,000 | £10,000 | £11,000 | £12,000 | £12,000 | £13,000 | £13,000 |
| Grocery Stores | 0% | £14,000 | £14,000 | £14,000 | £15,000 | £15,000 | £15,000 | £15,000 | £16,000 | £16,000 | £16,000 | £17,000 | £18,000 |
| Total Sales | £23,000 | £23,000 | £24,000 | £24,000 | £25,000 | £25,000 | £25,000 | £27,000 | £28,000 | £28,000 | £30,000 | £31,000 | |
| Direct Cost of Sales | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Supermarkets | £900 | £900 | £1,000 | £900 | £1,000 | £1,000 | £1,000 | £1,100 | £1,200 | £1,200 | £1,300 | £1,300 | |
| Grocery Stores | £1,400 | £1,400 | £1,400 | £1,500 | £1,500 | £1,500 | £1,500 | £1,600 | £1,600 | £1,600 | £1,700 | £1,800 | |
| Subtotal Direct Cost of Sales | £2,300 | £2,300 | £2,400 | £2,400 | £2,500 | £2,500 | £2,500 | £2,700 | £2,800 | £2,800 | £3,000 | £3,100 | |
| Personnel Plan | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Production Manager | 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 |
| Sales Manager | 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 |
| Production Staff | 0% | £6,800 | £6,800 | £6,800 | £6,800 | £6,800 | £6,800 | £6,800 | £6,800 | £6,800 | £6,800 | £6,800 | £6,800 |
| Delivery | 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 |
| Store Staff | 0% | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Total People | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
| Total Payroll | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | |
| General Assumptions | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| 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 | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | £23,000 | £23,000 | £24,000 | £24,000 | £25,000 | £25,000 | £25,000 | £27,000 | £28,000 | £28,000 | £30,000 | £31,000 | |
| Direct Cost of Sales | £2,300 | £2,300 | £2,400 | £2,400 | £2,500 | £2,500 | £2,500 | £2,700 | £2,800 | £2,800 | £3,000 | £3,100 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £2,300 | £2,300 | £2,400 | £2,400 | £2,500 | £2,500 | £2,500 | £2,700 | £2,800 | £2,800 | £3,000 | £3,100 | |
| Gross Margin | £20,700 | £20,700 | £21,600 | £21,600 | £22,500 | £22,500 | £22,500 | £24,300 | £25,200 | £25,200 | £27,000 | £27,900 | |
| Gross Margin % | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | |
| Expenses | |||||||||||||
| Payroll | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | |
| Sales and Marketing and Other Expenses | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Rent | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Payroll Taxes | 15% | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 | £2,490 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £22,490 | £22,490 | £22,490 | £22,490 | £22,490 | £22,490 | £22,490 | £22,490 | £22,490 | £22,490 | £22,490 | £22,490 | |
| Profit Before Interest and Taxes | (£1,790) | (£1,790) | (£890) | (£890) | £10 | £10 | £10 | £1,810 | £2,710 | £2,710 | £4,510 | £5,410 | |
| EBITDA | (£990) | (£990) | (£90) | (£90) | £810 | £810 | £810 | £2,610 | £3,510 | £3,510 | £5,310 | £6,210 | |
| Interest Expense | £345 | £332 | £402 | £388 | £458 | £445 | £432 | £418 | £405 | £392 | £378 | £365 | |
| Taxes Incurred | (£641) | (£636) | (£388) | (£383) | (£135) | (£131) | (£127) | £418 | £692 | £696 | £1,240 | £1,514 | |
| Net Profit | (£1,495) | (£1,485) | (£904) | (£895) | (£314) | (£305) | (£295) | £974 | £1,614 | £1,623 | £2,892 | £3,532 | |
| Net Profit/Sales | -6.50% | -6.46% | -3.77% | -3.73% | -1.26% | -1.22% | -1.18% | 3.61% | 5.76% | 5.80% | 9.64% | 11.39% | |
| Pro Forma Cash Flow | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £5,750 | £5,750 | £6,000 | £6,000 | £6,250 | £6,250 | £6,250 | £6,750 | £7,000 | £7,000 | £7,500 | £7,750 | |
| Cash from Receivables | £7,000 | £7,575 | £17,250 | £17,275 | £18,000 | £18,025 | £18,750 | £18,750 | £18,800 | £20,275 | £21,000 | £21,050 | |
| Subtotal Cash from Operations | £12,750 | £13,325 | £23,250 | £23,275 | £24,250 | £24,275 | £25,000 | £25,500 | £25,800 | £27,275 | £28,500 | £28,800 | |
| 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 | £30,000 | £0 | £10,000 | £0 | £10,000 | £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,750 | £13,325 | £33,250 | £23,275 | £34,250 | £24,275 | £25,000 | £25,500 | £25,800 | £27,275 | £28,500 | £28,800 | |
| Expenditures | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | £16,600 | |
| Bill Payments | £10,160 | £4,794 | £4,850 | £6,769 | £7,512 | £8,020 | £7,904 | £7,927 | £8,854 | £9,093 | £9,009 | £9,936 | |
| Subtotal Spent on Operations | £26,760 | £21,394 | £21,450 | £23,369 | £24,112 | £24,620 | £24,504 | £24,527 | £25,454 | £25,693 | £25,609 | £26,536 | |
| 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 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| 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 | £28,360 | £22,994 | £23,050 | £24,969 | £25,712 | £26,220 | £26,104 | £26,127 | £27,054 | £27,293 | £27,209 | £28,136 | |
| Net Cash Flow | £14,390 | (£9,669) | £10,200 | (£1,694) | £8,538 | (£1,945) | (£1,104) | (£627) | (£1,254) | (£18) | £1,291 | £664 | |
| Cash Balance | £84,390 | £74,721 | £84,921 | £83,226 | £91,764 | £89,819 | £88,715 | £88,088 | £86,834 | £86,816 | £88,107 | £88,771 | |
| Pro Forma Balance Sheet | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £70,000 | £84,390 | £74,721 | £84,921 | £83,226 | £91,764 | £89,819 | £88,715 | £88,088 | £86,834 | £86,816 | £88,107 | £88,771 |
| Accounts Receivable | £14,000 | £24,250 | £33,925 | £34,675 | £35,400 | £36,150 | £36,875 | £36,875 | £38,375 | £40,575 | £41,300 | £42,800 | £45,000 |
| Inventory | £8,000 | £5,700 | £3,400 | £2,640 | £2,640 | £2,750 | £2,750 | £2,750 | £2,970 | £3,080 | £3,080 | £3,300 | £3,410 |
| Other Current Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Total Current Assets | £97,000 | £119,340 | £117,046 | £127,236 | £126,266 | £135,664 | £134,444 | £133,340 | £134,433 | £135,489 | £136,196 | £139,207 | £142,181 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 | £36,736 |
| Accumulated Depreciation | £5,248 | £6,048 | £6,848 | £7,648 | £8,448 | £9,248 | £10,048 | £10,848 | £11,648 | £12,448 | £13,248 | £14,048 | £14,848 |
| Total Long-term Assets | £31,488 | £30,688 | £29,888 | £29,088 | £28,288 | £27,488 | £26,688 | £25,888 | £25,088 | £24,288 | £23,488 | £22,688 | £21,888 |
| Total Assets | £128,488 | £150,028 | £146,934 | £156,324 | £154,554 | £163,152 | £161,132 | £159,228 | £159,521 | £159,777 | £159,684 | £161,895 | £164,069 |
| Liabilities and Capital | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £10,000 | £4,635 | £4,626 | £6,519 | £7,245 | £7,756 | £7,641 | £7,632 | £8,551 | £8,793 | £8,678 | £9,597 | £9,839 |
| Current Borrowing | £3,000 | £2,900 | £2,800 | £2,700 | £2,600 | £2,500 | £2,400 | £2,300 | £2,200 | £2,100 | £2,000 | £1,900 | £1,800 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £13,000 | £7,535 | £7,426 | £9,219 | £9,845 | £10,256 | £10,041 | £9,932 | £10,751 | £10,893 | £10,678 | £11,497 | £11,639 |
| Long-term Liabilities | £10,000 | £38,500 | £37,000 | £45,500 | £44,000 | £52,500 | £51,000 | £49,500 | £48,000 | £46,500 | £45,000 | £43,500 | £42,000 |
| Total Liabilities | £23,000 | £46,035 | £44,426 | £54,719 | £53,845 | £62,756 | £61,041 | £59,432 | £58,751 | £57,393 | £55,678 | £54,997 | £53,639 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retained Earnings | £81,488 | £105,488 | £105,488 | £105,488 | £105,488 | £105,488 | £105,488 | £105,488 | £105,488 | £105,488 | £105,488 | £105,488 | £105,488 |
| Earnings | £24,000 | (£1,495) | (£2,980) | (£3,884) | (£4,779) | (£5,092) | (£5,397) | (£5,692) | (£4,718) | (£3,104) | (£1,482) | £1,411 | £4,942 |
| Total Capital | £105,488 | £103,994 | £102,508 | £101,604 | £100,709 | £100,396 | £100,091 | £99,796 | £100,770 | £102,384 | £104,006 | £106,899 | £110,430 |
| Total Liabilities and Capital | £128,488 | £150,028 | £146,934 | £156,324 | £154,554 | £163,152 | £161,132 | £159,228 | £159,521 | £159,777 | £159,684 | £161,895 | £164,069 |
| Net Worth | £105,488 | £103,994 | £102,508 | £101,604 | £100,709 | £100,396 | £100,091 | £99,796 | £100,770 | £102,384 | £104,006 | £106,899 | £110,430 |