Question

12-7 New project Analysis You must evaluate a proposal to buy a new milling machine. The base price is $108,000, and shipping and installation costs would add another $12,500. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $65,000. The applicable depreciation rates are 33, 45, 15, and 7 percent as discussed in Appendix 12A. The machine would require a $5,500 increase in working capital (increased inventory less increased accounts payable). There would be no effect on revenues, but pre-tax labor would decline by $44,000 per year. The marginal tax rate is 35 percent, and the WACC is 12 percent. Also, the firm spent $5,000 last year investigating the feasibility of using the machine.

a. How should the $5,000 spent last year be handled?

b. What is the net cost of the machine for capital budgeting purposes, that is, the Year 0 project cash flow?

c. What are the net operating cash flows during the Years 1, 2, and 3?

d. What is the terminal year cash flow?

e. Should the machine be purchased? Explain your answer

Please explain using an Excel spreadsheet

Answer 1

Answer : (a.) $5000 spent last is irrelevant for decision making as it has already spent said amount.

(b.) Net Cost of Machine = Base Price + Shipping and Installation

= 108000 + 12500

= 120500

(c.) Net opertaing Cash Flow

Year 1 = 42517.75

Year 2 = 47578.75

Year 3 = 34926.25

(d.) Terminal cash Flow = Sale of Machien after tax + Recovery of Working Capiatl

= 50702.25

(e.) Yes Accept the machine as Net Present Value is positive.

Please is the excel spreadsheet showing it :