Question

In: Finance

Harper Mining Ltd is considering to invest in one of the two following equipment. Each equipment...

Harper Mining Ltd is considering to invest in one of the two following equipment. Each equipment will last 5 years and have no salvage value at the end. The company’s required rate of return for all investment projects is 7%. The cash flows of the projects are provided below. Equipment 1 Equipment 2 Cost $150,000 $165,000 Future Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 56,000 53,000 65,000 55,000 43,000 67,000 74,000 62,000 65,000 53,000 Required: a) Identify which option of equipment should the company accept based on net present value (NPV) method. (Note: All answers should be rounded up to 2 decimal places) ANSWER: b) Identify which option of equipment should the company accept based on discounted pay back method. ANSWER:

Solutions

Expert Solution

REQUIRED RATE OF RETURN-7%

Present value of cash out flow for equipment -1                       150,000
Present value of cash out flow for equipment -2                       165,000
Calculation of Present Value of Cash Inflows
Year Cash Inflow For EQ-1 PV Of Cash Inflow for EQ-1 Cash Inflow For EQ-2 PV Of Cash Inflow for EQ-2
1                    56,000.00 52336.45                    67,000.00    62616.82
2                    53,000.00 46292.25                    74,000.00 64634.47
3                    65,000.00 53059.36                    62,000.00 50610.47
4                    55,000.00 41959.24                    65,000.00 49588.19
5                    43,000.00 30658.41                    53,000.00 37788.27
Total                  272,000.00 224,305.71                  321,000.00 265,238.22

NPV OF EQUIPMENT-1

PV OF CASH INFLOW- 224305.71

PV OF CASH OUTFLOW-150000

NET PRESENT VALUE-74301.71

NPV OF EQUIPMENT-2

PV OF CASH INFLOW- 265238.22

PV OF CASH OUTFLOW-165000

NET PRESENT VALUE-100238.22

AS PER NPV METHOD EQUIPMENT-2 GETS MORE RETURNS, SO IT IS BETTER TO PURCHASE EQUIPMENT-2.

Calculation of Discounting Payback Period.

Calculation of Discounting Payback Period
Year PV Of Cash Inflow for EQ-1 Net Invested Cash
0 0 150000
1 52336.45    97663.55
2 46292.25 51371.3
3 53059.36   
4 41959.24
5 30658.41
NET VALUE REQUIRED DURING THE 3RD YEAR 51371.3

The table indicates that the real payback period is located somewhere between Year 2 and Year 3

There is 51371.3 of investment yet to be paid back at the end of Year 2, and there is 53059.36 of cash flow projected for Year 3. We assumes the same monthly amount of cash flow in Year 3, which means that he can estimate final Discounting payback as being just short of 2.11 years.

Calculation of Discounting Payback Period for EQ-2
Year PV Of Cash Inflow for EQ-2 Net Invested Cash
0 0 165000
1 62616.82 102383.18
2 64634.47 37748.71
3 50610.47
4 49588.19
5 37788.27
NET VALUE REQUIRED DURING THE 3RD YEAR 37,748.71

The table indicates that the real payback period is located somewhere between Year 2 and Year 3

There is 37748.71 of investment yet to be paid back at the end of Year 2, and there is 50610.47 of cash flow projected for Year 3. We assumes the same monthly amount of cash flow in Year 3, which means that he can estimate final Discounting payback as being just short of 2.9 years.

Therefore, As per Discounting Payback Period method, it is better to purchase Equipment-2, Because EQ-2 Contains lower Payback Period.


Related Solutions

Question 4 (10 marks) Harper Mining Ltd is considering to invest in one of the two...
Question 4 Harper Mining Ltd is considering to invest in one of the two following equipment. Each equipment will last 5 years and have no salvage value at the end. The company’s required rate of return for all investment projects is 7%. The cash flows of the projects are provided below. Equipment 1 Equipment 2 Cost $150,000 $165,000 Future Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 56,000 53,000 65,000 55,000 43,000 67,000 74,000 62,000 65,000...
Bunnings Ltd is considering to invest in one of the two following projects to buy a new equipment.
Bunnings Ltd is considering to invest in one of the two following projects to buy a new equipment. Each equipment will last 5 years and have no salvage value at the end. The company’s required rate of return for all investment projects is 8%. The cash flows of the projects are provided below.Equipment 1Equipment 2Cost$186,000$195,000Future Cash FlowsYear 1Year 2Year 3Year 4Year 586 00093 00083 00075 00055 00097 00084 00086 00075 00063 000Required:Identify which option of equipment should the company accept...
Bunnings Ltd is considering to invest in one of the two following projects to buy a new equipment.
Bunnings Ltd is considering to invest in one of the two following projects to buy a new equipment. Each equipment will last 5 years and have no salvage value at the end. The company’s required rate of return for all investment projects is 8%. The cash flows of the projects are provided below. Equipment 1 Equipment 2 Cost $186,000 $195,000 Future Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 86 000 93 000 83 000 75...
Bunnings Ltd is considering to invest in one of the two following projects to buy a...
Bunnings Ltd is considering to invest in one of the two following projects to buy a new equipment. Each equipment will last 5 years and have no salvage value at the end. The company’s required rate of return for all investment projects is 8%. The cash flows of the projects are provided below. Equipment 1 Equipment 2 Cost $186,000 $195,000 Future Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 86 000 93 000 83 000 75...
Giant Machinery Ltd is considering to invest in one of the two following Projects to buy...
Giant Machinery Ltd is considering to invest in one of the two following Projects to buy a new equipment. Each project will last 5 years and have no salvage value at the end. The company’s required rate of return for all investment projects is 9%. The cash flows of the projects are provided below. Project 1 Project 2 Cost $175,000 $185,000 Future Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 76,000 83,000 67,000 65,000 55,000 87,000...
Question 5 (7 marks) Bunnings Ltd is considering to invest in one of the two following...
Question 5 Bunnings Ltd is considering to invest in one of the two following projects to buy a new equipment. Each equipment will last 5 years and have no salvage value at the end. The company’s required rate of return for all investment projects is 8%. The cash flows of the projects are provided below. Equipment 1 Equipment 2 Cost $186,000 $195,000 Future Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 86 000 93 000 83...
Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the same...
Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the same start-up costs. Project A will produce annual cash flows of $42,000 at the beginning of each year for eight years. Project B will produce cash flows of $48,000 at the end of each year for seven years. The company requires a 12% return. Required: a) Which project should the company select and why? b) Which project should the company select if the interest rate...
Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the same...
Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the same start-up costs. Project A will produce annual cash flows of $42,000 at the beginning of each year for eight years. Project B will produce cash flows of $48,000 at the end of each year for seven years. The company requires a 12% return. Required: 1. a) Which project should the company select and why? 2. b) Which project should the company select if the...
Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the same...
Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the same start-up costs. Project A will produce annual cash flows of $42,000 at the beginning of each year for eight years. Project B will produce cash flows of $48,000 at the end of each year for seven years. The company requires a 12% return. Required: a) Which project should the company select and why? b) Which project should the company select if the interest rate...
Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the same...
Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the same start-up costs. Project A will produce annual cash flow of $42 000 at the beginning of each year for eight years. Project B will produce cash flow of $48 000 at the end of each year for seven years. The company requires a 12% return. Required: a. Which project should the company select and why? b. Which project should the company select if the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT