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,700,000 and cash expenses of $3,810,000, one-third of which are labor costs. The current level of investment in this existing division is $12,350,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 $44,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 $470,000 per year. Raw materials costs associated with the new line are expected to be $1,550,000 per year, while the total labor cost is expected to double. The CFO of the company estimates that new machinery costing $4,250,000 would need to be purchased. This machinery has a seven-year useful life and an estimated salvage (terminal) value of $680,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 10% (after-tax) and that the combined (federal and state) income tax rate is 41%. Finally, assume that the new business line is expected to generate annual cash revenue of $4,300,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.
Step 1: Formulas and basic calculation used
Depreciation = Machine value/life of machine = $4,250,000/7 = $607,142.86
Present value = Cash flow after tax (1+interest rate) ^ (number of years)
Labor cost has doubled and it was initially 1/3rd of $3,810,000 = $1,270,000
So added labor cost = $1,270,000
Step 2: Project initiation is year 0, project operation are years 1-6 and project disposal is year 7.
New Business Line | Project initiation | Project operation | Project display | |||||
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |
Net working capital | -44000 | 44000 | ||||||
Additional cash expenses | -470000 | -470000 | -470000 | -470000 | -470000 | -470000 | -470000 | |
Raw material cost | -1550000 | -1550000 | -1550000 | -1550000 | -1550000 | -1550000 | -1550000 | |
Labor cost | -1270000 | -1270000 | -1270000 | -1270000 | -1270000 | -1270000 | -1270000 | |
Machinery cost | -4250000 | |||||||
Salvage value | 0 | 0 | 0 | 0 | 0 | 0 | 680000 | |
Annual cash revenue | 4300000 | 4300000 | 4300000 | 4300000 | 4300000 | 4300000 | 4300000 | |
Net cash flow | -4294000 | 1010000 | 1010000 | 1010000 | 1010000 | 1010000 | 1010000 | 1734000 |
Depreciation | 607143 | 607143 | 607143 | 607143 | 607143 | 607143 | 607143 | |
Cash flow before tax | -4294000 | 402857 | 402857 | 402857 | 402857 | 402857 | 402857 | 1126857 |
Tax @41% | 0 | 165171 | 165171 | 165171 | 165171 | 165171 | 165171 | 462011 |
Cash flow after tax + Depreciation | -4294000 | 844829 | 844829 | 844829 | 844829 | 844829 | 844829 | 1271989 |
Present value of cash flow | -4294000 | 768026.36 | 698205.79 | 634732.53 | 577029.57 | 524572.34 | 476883.95 | 652731.48 |
NPV value | 38182.02 |
Project is executable as the sum of all the present value of cash flows is positive.
Step 3 - Cash flows at project initiation = -$4,294,000
Cash flows at project operation = $3,679.450.54
Cash flows at project disposal = $652,731.48
This exercise parallels the machine-purchase decision for the Mendoza Company that is discussed in the body...
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,250,000 and cash expenses of $3,765,000, one-third of which are labor costs. The current level of investment in this existing division is $12,500,000. (Sales and costs of this division are not affected by the investment decision regarding the...
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 $4,950,000 and cash expenses of $3,735,000, one-third of which are labor costs. The current level of investment in this existing division is $12,600,000. (Sales and costs of this division are not affected by the investment decision regarding the...
Check my work 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,400,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,450,000. (Sales and costs of this division are not affected by the investment...
Check my work 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,400,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,450,000. (Sales and costs of this division are not affected by the investment...
Check my work 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,500,000 and cash expenses of $3,750,000, one-third of which are labor costs. The current level of investment in this existing division is $12,250,000. (Sales and costs of this division are not affected by the investment...
Assume that it is January 1, 2019, and that the Mendoza Company is considering the replacement of a machine that has been used for the past 3 years in a special project for the company. This project is expected to continue for an additional 5 years (i.e., until the end of 2023). Mendoza will either keep the existing machine for another 5 years (8 years total) or replace the existing machine now with a new model that has a 5-year...
A company is evaluating the purchase of Machine A. The new machine would cost $120,000 and would be depreciated for tax purposes using the straight-line method over an estimated ten-year life to its expected salvage value of $20,000. The new machine would require an addition of $30,000 to working capital. In each year of Machine A’s life, the company would reduce its pre-tax costs by $40,000. The company has a 12% cost of capital and is in the 35% marginal...
Graziano Corporation (GC) is considering a project to purchase new equipment. The equipment would be depreciated by the straight-line method over its 3-year life and would have a zero-salvage value. The project requires an investment of $6,000 today on net working capital. Revenues and other operating costs are expected to be constant over the project's 3-year life. However, this project would compete with other company’s products and would reduce its pre-tax annual cash flows of $5,000 per year. The investment...
A company is evaluating the purchase of a machine to improve product quality and output levels. The new machine would cost $1.6 million and would be depreciated for tax purposes using the straight-line method over an estimated six-year life to its expected salvage value of $100,000. The new machine would require an addition of $70,000 to working capital at the beginning of the project, which will of course be returned to the firm at the end of the project. In...
Graziano Corporation (GC) is considering a project to purchase new equipment. The equipment would be depreciated by the straight-line method over its 3-year life and would have a zero-salvage value. The project requires an investment of $6,000 today on net working capital. Revenues and other operating costs are expected to be constant over the project's 3-year life. However, this project would compete with other company’s products and would reduce its pre-tax annual cash flows of $5,000 per year. The investment...