Читайте также:
|
|
The personnel burden is very low because benefits are not paid to part-timers. And the short-term interest rate is extraordinarily low because of Mr. Brinkman's long-standing relationship with High Desert Credit Union.
Table: General Assumptions
General Assumptions | |||
Year 1 | Year 2 | Year 3 | |
Plan Month | |||
Current Interest Rate | 7.00% | 7.00% | 7.00% |
Long-term Interest Rate | 20.00% | 20.00% | 20.00% |
Tax Rate | 25.42% | 25.00% | 25.42% |
Other |
7.2 Break-even Analysis
A Break-even Analysis table has been completed on the basis of average costs/prices. With fixed costs, average sales, and average variable costs, the table and chart show what we need per month to break-even.
Chart: Break-even Analysis
Table: Break-even Analysis
Break-even Analysis | |
Monthly Revenue Break-even | $37,570 |
Assumptions: | |
Average Percent Variable Cost | 50% |
Estimated Monthly Fixed Cost | $18,785 |
7.3 Projected Cash Flow
We are positioning ourselves in the market as a medium risk concern with steady cash flows. Accounts payable is paid at the end of each month, while sales are in cash, giving the Dollar Store an excellent cash structure. Fifty percent of cash above a TBA amount will be invested into semi-liquid stock portfolios to decrease the opportunity cost of cash held.
Table: Cash Flow
Pro Forma Cash Flow | |||
Year 1 | Year 2 | Year 3 | |
Cash Received | |||
Cash from Operations | |||
Cash Sales | $325,500 | $390,600 | $468,720 |
Subtotal Cash from Operations | $325,500 | $390,600 | $468,720 |
Additional Cash Received | |||
Sales Tax, VAT, HST/GST Received | $0 | $0 | $0 |
New Current Borrowing | $3,000 | $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 | $2,000 | $0 | $0 |
Subtotal Cash Received | $330,500 | $390,600 | $468,720 |
Expenditures | Year 1 | Year 2 | Year 3 |
Expenditures from Operations | |||
Cash Spending | $145,200 | $151,100 | $162,200 |
Bill Payments | $219,294 | $235,193 | $270,516 |
Subtotal Spent on Operations | $364,494 | $386,293 | $432,716 |
Additional Cash Spent | |||
Sales Tax, VAT, HST/GST Paid Out | $0 | $0 | $0 |
Principal Repayment of Current Borrowing | $100 | $1,200 | $1,200 |
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 | $364,594 | $387,493 | $433,916 |
Net Cash Flow | ($34,094) | $3,107 | $34,804 |
Cash Balance | $8,406 | $11,513 | $46,318 |
Chart: Cash
Дата добавления: 2015-10-26; просмотров: 77 | Нарушение авторских прав
<== предыдущая страница | | | следующая страница ==> |
Sales Forecast | | | Projected Profit and Loss |