In: Accounting
This exercise parallels the machine-purchase decision for the
Mendoza Company that is discussed in the body of the chapter.
Assume that Mendoza is exploring whether to enter a complementary
line of business. The existing business line generates annual cash
revenues of approximately $5,600,000 and cash expenses of
$3,780,000, one-third of which are labor costs. The current level
of investment in this existing division is $12,300,000. (Sales and
costs of this division are not affected by the investment decision
regarding the complementary line.)
Mendoza estimates that incremental (noncash) net working capital of
$42,000 will be needed to support the new business line. No
additional facilities-level costs would be needed to support the
new line—there is currently sufficient excess capacity. However,
the new line would require additional cash expenses (overhead
costs) of $460,000 per year. Raw materials costs associated with
the new line are expected to be $1,500,000 per year, while the
total labor cost is expected to double.
The CFO of the company estimates that new machinery costing
$4,000,000 would need to be purchased. This machinery has a
five-year useful life and an estimated salvage (terminal) value of
$640,000. For tax purposes, assume that the Mendoza Company would
use the straight-line method (with estimated salvage value
considered in the calculation).
Assume, further, that the weighted-average cost of capital (WACC)
for Mendoza is 11% (after-tax) and that the combined (federal and
state) income tax rate is 42%. Finally, assume that the new
business line is expected to generate annual cash revenue of
$4,200,000.
Required:
Determine relevant cash flows (after-tax) at each of the following
three points: (1) project initiation, (2) project operation, and
(3) project disposal (termination). For purposes of this last
calculation, you can assume that the asset is sold at the end of
its useful life for the salvage value used to establish the annual
straight-line depreciation deductions; further, you can assume that
at the end of the project’s life Mendoza will fully recover its
initial investment in net working capital.
1) Determine relevant cash flow (after-tax) at project initiation.
2) Determine relevant cash flow (after-tax) at project initiation.
Incremental cash revenues |
- | ? |
Incremental cash Expenses |
- | - |
? | ? | - |
? | ? | - |
? | ? | - |
? | ? | - |
? | ? | - |
Incremental non-cash expenses: |
- | - |
? | ? | ? |
Incremental operating income |
- | ? |
? | - | ? |
After-tax operating income |
- | ? |
? | - | ? |
Annual after-tax cash inflow |
- | ? |
3. Determine relevant cash flow (after-tax) at project disposal (termination - end of year 5).
1) Relevant cash flow (after-tax) at project initiation:- |
|
Machinery | $ -40,00,000.00 |
Net Working Capital | $ -42,000.00 |
cash flow (after-tax) at project initiation | $ -40,42,000.00 |
2) Annual after-tax cash inflow (time periods 1 through 5): | |
Cash Revenue | $ 42,00,000.00 |
Cash Expenses (overhead cost) | $ -4,60,000.00 |
Raw Materials | $ -15,00,000.00 |
Labor Cost (3780000*1/3) | $ -12,60,000.00 |
Cash Outflows before tax | $ 9,80,000.00 |
Depreciation Expenses | $ -6,72,000.00 |
Taxable Income | $ 3,08,000.00 |
Income Tax @42% | $ -1,29,360.00 |
Income After tax | $ 1,78,640.00 |
Add: depreciation | $ 6,72,000.00 |
Annual after-tax cash inflow | $ 8,50,640.00 |
Depreciation = ((4000000-640000)/5 = $672,000 per year |
3) Cash flow (after-tax) at project disposal (termination) (end of year 5) | |
Salvage Value | $ -6,40,000.00 |
Net Working Capital | $ -42,000.00 |
Cash flow (after-tax) at project disposal (end of year 5) | $ -6,82,000.00 |