The following sections will outline the important financial assumptions, key financial indicators, Break-even Analysis, profit and loss, cash flow, and balance sheet.
7.1 Important Assumptions
The following table highlights some of the important financial assumptions for Gamehenge Tapers Co-op.
| General Assumptions |
| Plan Month |
1 |
2 |
3 |
| Current Interest Rate |
10.00% |
10.00% |
10.00% |
| Long-term Interest Rate |
10.00% |
10.00% |
10.00% |
| Tax Rate |
2.50% |
0.00% |
2.50% |
| Other |
0 |
0 |
0 |
7.2 Break-even Analysis
The Break-even Analysis shows what we need in monthly revenue to break even.
| Break-even Analysis |
|
|
| Monthly Revenue Break-even |
£1,741 |
|
|
| Average Percent Variable Cost |
82% |
| Estimated Monthly Fixed Cost |
£319 |
7.3 Projected Surplus or Deficit
THe following table will indicate projected surplus or deficit.
| Surplus and Deficit |
| Direct Cost |
£33,565 |
£37,391 |
£37,939 |
| Other |
£0 |
£0 |
£0 |
| Total Direct Cost |
£33,565 |
£37,391 |
£37,939 |
|
|
|
|
| Gross Surplus |
£7,529 |
£4,155 |
£4,215 |
| Gross Surplus % |
18.32% |
10.00% |
10.00% |
|
|
|
|
|
|
|
|
| Payroll |
£0 |
£0 |
£0 |
| Sales and Marketing and Other Expenses |
£600 |
£600 |
£600 |
| Depreciation |
£228 |
£228 |
£228 |
| Leased Equipment |
£0 |
£0 |
£0 |
| Utilities |
£0 |
£0 |
£0 |
| Insurance |
£600 |
£600 |
£600 |
| Rent |
£2,400 |
£2,400 |
£2,400 |
| Payroll Taxes |
£0 |
£0 |
£0 |
| Other |
£0 |
£0 |
£0 |
|
|
|
|
|
|
|
|
| Surplus Before Interest and Taxes |
£3,701 |
£327 |
£387 |
| EBITDA |
£3,929 |
£555 |
£615 |
| Interest Expense |
£0 |
£0 |
£0 |
| Taxes Incurred |
(£48) |
£0 |
£10 |
|
|
|
|
| Net Surplus/Funding |
9.12% |
0.79% |
0.90% |
7.4 Projected Cash Flow
The following chart and table will indicate projected cash flow.
| Pro Forma Cash Flow |
|
|
|
|
| Cash from Operations |
|
|
|
| Cash Funding |
£41,094 |
£41,545 |
£42,154 |
| Subtotal Cash from Operations |
£41,094 |
£41,545 |
£42,154 |
|
|
|
|
| Additional Cash Received |
|
|
|
| Sales Tax, VAT, HST/GST Received |
£0 |
£0 |
£0 |
| New Current Borrowing |
£0 |
£0 |
£0 |
| New Other Liabilities (interest-free) |
£0 |
£0 |
£0 |
| New Long-term Liabilities |
£0 |
£0 |
£0 |
| Sales of Other Current Assets |
£0 |
£0 |
£0 |
| Sales of Long-term Assets |
£0 |
£0 |
£0 |
| New Investment Received |
£0 |
£0 |
£0 |
| Subtotal Cash Received |
£41,094 |
£41,545 |
£42,154 |
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
| Cash Spending |
£0 |
£0 |
£0 |
| Bill Payments |
£36,615 |
£42,634 |
£41,602 |
| Subtotal Spent on Operations |
£36,615 |
£42,634 |
£41,602 |
|
|
|
|
| Additional Cash Spent |
|
|
|
| Sales Tax, VAT, HST/GST Paid Out |
£0 |
£0 |
£0 |
| Principal Repayment of Current Borrowing |
£0 |
£0 |
£0 |
| Other Liabilities Principal Repayment |
£0 |
£0 |
£0 |
| Long-term Liabilities Principal Repayment |
£0 |
£0 |
£0 |
| Purchase Other Current Assets |
£0 |
£0 |
£0 |
| Purchase Long-term Assets |
£0 |
£0 |
£0 |
| Dividends |
£0 |
£0 |
£0 |
| Subtotal Cash Spent |
£36,615 |
£42,634 |
£41,602 |
|
|
|
|
| Cash Balance |
£4,729 |
£3,641 |
£4,193 |
7.5 Projected Balance Sheet
The following table will indicate the projected balance sheet.
| Pro Forma Balance Sheet |
|
|
|
|
| Current Assets |
|
|
|
| Cash |
£4,729 |
£3,641 |
£4,193 |
| Inventory |
£4,083 |
£4,548 |
£4,615 |
| Other Current Assets |
£0 |
£0 |
£0 |
| Total Current Assets |
£8,812 |
£8,189 |
£8,808 |
|
|
|
|
| Long-term Assets |
|
|
|
| Long-term Assets |
£1,150 |
£1,150 |
£1,150 |
| Accumulated Depreciation |
£228 |
£456 |
£684 |
| Total Long-term Assets |
£922 |
£694 |
£466 |
| Total Assets |
£9,734 |
£8,883 |
£9,274 |
|
|
|
|
|
|
|
|
| Current Liabilities |
|
|
|
| Accounts Payable |
£4,585 |
£3,407 |
£3,420 |
| Current Borrowing |
£0 |
£0 |
£0 |
| Other Current Liabilities |
£0 |
£0 |
£0 |
| Subtotal Current Liabilities |
£4,585 |
£3,407 |
£3,420 |
|
|
|
|
| Long-term Liabilities |
£0 |
£0 |
£0 |
| Total Liabilities |
£4,585 |
£3,407 |
£3,420 |
|
|
|
|
| Paid-in Capital |
£2,000 |
£2,000 |
£2,000 |
| Accumulated Surplus/Deficit |
(£600) |
£3,149 |
£3,476 |
| Surplus/Deficit |
£3,749 |
£327 |
£378 |
| Total Capital |
£5,149 |
£5,476 |
£5,853 |
| Total Liabilities and Capital |
£9,734 |
£8,883 |
£9,274 |
|
|
|
|
| Net Worth |
£5,149 |
£5,476 |
£5,853 |