Question

Integrative—Investment decision   

Holliday Manufacturing is considering the replacement of an existing machine. The new machine costs $1.27 million and requires installation costs of $159,000.

The existing machine can be sold currently for $177,000 before taxes. It is 2 years​ old, cost $799,000 new, and has a $383,520 book value and a remaining useful life of 5 years. It was being depreciated under MACRS using a​ 5-year recovery period and therefore has the final 4 years of depreciation remaining. If it is held for 5 more​ years, the​ machine's market value at the end of year 5 will be $0. Over its​ 5-year life, the new machine should reduce operating costs by $359,000 per year. The new machine will be depreciated under MACRS using a​ 5-year recovery period. The new machine can be sold for $193,000 net of removal and cleanup costs at the end of 5 years. An increased investment in net working capital of $25,000 will be needed to support operations if the new machine is acquired. Assume that the firm has adequate operating income against which to deduct any loss experienced on the sale of the existing machine. The firm has a 9.2% cost of capital and is subject to a 40% tax rate.

a. Develop the net cash flows needed to analyze the proposed replacement.

b. Determine the net present value​ (NPV) of the proposal.

c. Determine the internal rate of return​ (IRR) of the proposal.

d. Make a recommendation to accept or reject the replacement​ proposal, and justify your answer.

e. What is the highest cost of capital that the firm could have and still accept the​ proposal?

Answer 1

Please see the table below. Please be guided by the second column titled “Linkage” to understand the mathematics. The last few row highlighted in yellow contain your answer. Figures in parenthesis, if any, mean negative values. All financials are in $. Adjacent cells in blue contain the formula in excel I have used to get the final output. Part (a), (b), (c) and (d) have been solved sequentially in the snapshot below.

Part (d) has been solved after the snapshot.

Part (e)

We will have to do a goal seek in excel. Please see the snapshot below:

And the output after the goal seek: Please check the answer in the green colored cell.

Hence, the highest cost of capital that the firm could have and still accept the​ proposal = 10.83%