Question

In: Finance

Project 2: Micah’s Replacement Decision Project description MicahCorporation is trying to determine the initial investment required...

Project 2: Micah’s Replacement Decision

Project description

MicahCorporation is trying to determine the initial investment required to replace an old machine with a new one. The new machine costs $380,000, and an additional $20,000 will be necessary to install it. It will be depreciated under MACRS, using a 5-year recovery period. The 5-year MACRS depreciation rates are:

Year

1

2

3

4

5

6

Depreciation

20%

32%

19%

12%

12%

5%

The old machine was purchased 3 years ago at a cost of $240,000 and was being depreciated under MACRS, using a 5-year recovery period. The firm can sell the old machine for $280,000. The firm expects that a $35,000 increase in current assets and an $18,000 increase in current liabilities will accompany the replacement. The firm’s tax rate is 21%.

The new machine and the old machine are associated with the following EBITDA (earnings before interest, taxes, depreciation and amortization) over the 5-year life of the project:

Year

1

2

3

4

5

New machine’s EBITDA

220,000

220,000

220,000

220,000

220,000

Old machine’s EBITDA

210,000

190,000

170,000

150,000

130,000

Assume that the firm expects to liquidate the new machine at the end of its 5-year usable life, to net $50,000 after paying removal and cleanup costs. Had the new machine not replaced the old machine, the old machine would have been liquidated after 5 years to net $10,000. The firm expects to recover its net working capital investment upon termination of the project.

If the corporation’s capital structure is 50% debt and 50% equity, and the corporation will continue this capital structure to fund the investment on the new machine. Its cost of debt is 5% and cost of equity is 12%. Should Micah do the replacement? Support your conclusion with NPV and IRR values.

Requirements

1. Present the case solution in an Excel file with clear labels, functions and descriptions.

2. Starting with the data provided, show each step of your work that leads to the conclusion.

3. Due in D2L by 11:59PM Sunday June 1.

Hints

1. You may need the following equations:

FCF=EBIT×(1-T)+DP-net CAPX-ΔNWC

WACC=wd×rd×(1-T)+ws×rs

After-tax salvage value=MV-(MV-BV) ×T

Excel function of NPV, Excel function of IRR

2. It is a replacement decision and you need to consider the effect of the new machine relative to that of the old one.

Grading

7 points in total

Finished and submitted on time: 3 points

0-25% correct: +1

25%-50% correct: +2

50%-75% correct: +3

75%-100% correct: +4

***Please show all excel functions in answer***

Solutions

Expert Solution

Solution:

Following steps are followed:

a. Compute the free cash flows considering only old machine

b. Consider the cash flows considering New machine + Old Machine Sold

c. Compute the difference between the two cash flows

d. Compute WACC

e. Compute NPV and IRR

Excel computations are attached.

Some points to be noted.

Cash flows from selling of the machine = Selling Price of the Machine - (SP of machine - Net Block)* tax rate.... this is done since Net Gains from sale of machine will be taxed.

Considering the NPV and IRR, Micah should do the replacement.

-x-


Related Solutions

Project K has an initial required investment of $1,000,000. The project will result in operating cash...
Project K has an initial required investment of $1,000,000. The project will result in operating cash inflows of $200,000 per year for Years 1-3, $100,000 per year for Years 4-9, and have no cash flows in Year 10 and beyond. Calculate the payback period for Project K.
Ways of determine investment decision in investment planning
Ways of determine investment decision in investment planning
Following table shows the initial investment required in and cash flow (return) from a project
Following table shows the initial investment required in and cash flow (return) from a project: The expected payback period from the project is 2 years and the discount rate is 14%. Based on the Discounted Payback Period, will you accept the project?
A firm is planning an investment in a project. The initial investment is 250,000. The project...
A firm is planning an investment in a project. The initial investment is 250,000. The project returns $100,000 cash at the end of one year. At the end of second year the project returns cash of amount $F. These are only cash flows from the project. If the IRR for the project is 10%, what is the amount $F?
Question 2 (25 marks) (a) A project in South Korea requires an initial investment of 2...
Question 2 (a) A project in South Korea requires an initial investment of 2 billion South Korean won. The project is expected to generate net cash flows to the subsidiary of 3 billion and 4 billion won in the 2 years of operation, respectively. The project has no salvage value. The current value of the won is 1,100 won per U.S. dollar, and the value of the won is expected to remain constant over the next 2 years. (i). What...
Iris Company is considering a new investment project. The initial investment for the project is $200,000....
Iris Company is considering a new investment project. The initial investment for the project is $200,000. Iris is trying to estimate the net cashflows after tax for this investment. She has already figured out that the investment will generate an annual after-tax cash inflow of $54,000 from the operation. For tax purposes, the projected salvage value of the investment is $25,500. The government requires depreciating the vehicles using the straight-line method over the investment's life of 8 years. q1) Iris...
2 Sharon Company is considering an investment project that has an initial cost of $23,000 and...
2 Sharon Company is considering an investment project that has an initial cost of $23,000 and an expected life of 3 years. Annual net cash flows from the project begin 1 year after the initial investment is made and have the following probability distribution: Probability Net Cash Flows 0.25 $2000 0.50 16000 0.25 10000 Expected CFs = $11000 Sharon evaluates riskier project with CV ≥0.50 at 14% and less risky project with CV <0.50 at 10% rate. a. Calculate the...
Assume you have the following information on Project X: Initial Investment -$1,000 Required rate of return...
Assume you have the following information on Project X: Initial Investment -$1,000 Required rate of return = 10% Year Cash Flow Present Value of CF Accum. Discount CF 0 -1000 -1000 -1000 1 200 182 182 2 400 331 513 3 700 526 1039 4 300 205 1244 What is the discount payback period?
3. A project has the following characteristics: Initial investment is $1,700,000 Initial investment is depreciated to...
3. A project has the following characteristics: Initial investment is $1,700,000 Initial investment is depreciated to $0 over its 10 year life Project generates incremental after-tax cash flows (OCF) of $325,000 per year over the projects life Project requires a net working capital (NWC) investment today of $50,000, which is recovered at the end of the project Assets purchased with the initial investment are expected to have a salvage value of $74,000 at the end of the project The firm...
You are investing in a project that requires an initial investment of $500,000. The project will...
You are investing in a project that requires an initial investment of $500,000. The project will last for 10 years with the following additional cash flows (CF) at the end of each year: If the discount rate is 10%, calculate the payback periods in Excel for both the methods below; Years 1 2 3 4 5 6 7 8 9 10 CF -500,000 80,000 100,000 100,000 120,000 140,000 150,000 150,000 150,000 150,000 a) Payback Method [10] b) Discounted Payback Method...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT