Question

In: Finance

Marvin Industries must choose between an electric-powered and a coal-powered forklift machine for its factory. Because...

Marvin Industries must choose between an electric-powered and a coal-powered forklift machine for its factory. Because both machines perform the same function, the firm will choose only one. (They are mutually exclusive investments.) The electric-powered machine will cost more, but it will be less expensive to operate; it will cost $102,000, whereas the coal-powered machine will cost $69,500. The cost of capital that applies to both investments is 10%. The life for both types of machines is estimated to be 6 years, during which time the net cash flows for the electric-powered machine will be $26,150 per year, and those for the coal-powered machine will be $20,000 per year. Annual net cash flows include depreciation expenses.

a. Calculate the NPV and IRR for each type of machine, and decide which to recommend

Solutions

Expert Solution

Electric powered forklift

Net present value can be solved using a financial calculator. The steps to solve on the financial calculator:

  • Press the CF button.
  • CF0= -$102,000. Indicate the initial cash flow by a negative sign since it is a cash outflow.  
  • Cash flow for each year should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the NPV button and enter the cost of capital of 10%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.  

Net present value at 10% cost of capital is $11,890.07.

Coal powered forklift

Net present value can be solved using a financial calculator. The steps to solve on the financial calculator:

  • Press the CF button.
  • CF0= -$69,500. Indicate the initial cash flow by a negative sign since it is a cash outflow.  
  • Cash flow for each year should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the NPV button and enter the cost of capital of 10%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.  

Net present value at 10% cost of capital is $17,605.21.

Electric powered forklift

Internal rate of return can be calculated using a financial calculator by inputting the below:

  • Press the CF button.
  • CF0= -$102,000. The initial cash flow is indicated by a negative sign since it is a cash outflow.  
  • Cash flow for each of the fifteen years should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the IRR and CPT button to get the IRR of the project.

The IRR of the project is 13.89%.

Coal powered forklift

Internal rate of return can be calculated using a financial calculator by inputting the below:

  • Press the CF button.
  • CF0= -$102,000. The initial cash flow is indicated by a negative sign since it is a cash outflow.  
  • Cash flow for each of the fifteen years should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the IRR and CPT button to get the IRR of the project.

The IRR of the project is 18.25%.

I will recommend coal powered forklift since it generates the highest net present value.


Related Solutions

Marvin Industries must choose between an electric-powered and a coal-powered forklift machine for its factory. Because...
Marvin Industries must choose between an electric-powered and a coal-powered forklift machine for its factory. Because both machines perform the same function, the firm will choose only one. (They are mutually exclusive investments.) The electric-powered machine will cost more, but it will be less expensive to operate; it will cost $102,000, whereas the coal-powered machine will cost $69,500. The cost of capital that applies to both investments is 10%. The life for both types of machines is estimated to be...
Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in its factory.
Problem 10-9NPVs and IRRs for Mutually Exclusive ProjectsDavis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in its factory. Since both forklifts perform the same function, the firm will choose only one. (They are mutually exclusive investments.) The electric-powered truck will cost more, but it will be less expensive to operate; it will cost $21,000, whereas the gas-powered truck will cost $17,230. The cost of capital that applies to both investments is 11%. The...
Davis Industries must choose between a gas powered or an electric powered forklift truck for moving...
Davis Industries must choose between a gas powered or an electric powered forklift truck for moving materials in its factory. The electric powered truck will cost more, but it will be less expensive to operate; it will cost $22,000 whereas the gas powered will cost $17,500. The cost of capital is 12%. The life of both trucks is expected to be six years. The net cash inflows for the electric powered truck will be $6,290 per year and those for...
Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in...
Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in its factory. Because both forklifts perform the same function, the firm will choose only one. (They are mutually exclusive investments.) The electric-powered truck will cost more, but it will be less expensive to operate; it will cost $21,000, whereas the gas-powered truck will cost $17,230. The cost of capital that applies to both investments is 11%. The life for both types of truck is...
Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in...
Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in its factory. Because both forklifts perform the same function, the firm will choose only one. (They are mutually exclusive investments.) The electric-powered truck will cost more, but it will be less expensive to operate; it will cost $21,500, whereas the gas-powered truck will cost $17,960. The cost of capital that applies to both investments is 13%. The life for both types of truck is...
Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in...
Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in its factory. Because both forklifts perform the same function, the firm will choose only one. (They are mutually exclusive investments.) The electric-powered truck will cost more, but it will be less expensive to operate, it will cost $22,000, whereas the gas-powered truck will cost $17,500. The cost of capital that applies to both investments is 15%. The life cycle for both types of truck...
PLEASE COMPLETE IN EXCEL        Davis Industries must choose between a gas-powered and an electric-powered forklift...
PLEASE COMPLETE IN EXCEL        Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in its factory. Because both forklifts perform the same function, the firm will choose only one. (They are mutually exclusive investments.) The electric-powered truck will cost more, but it will be less expensive to operate, it will cost $23,000, whereas the gas-powered truck will cost $14,500. The cost of capital that applies to both investments is 13%. The life cycle...
Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in...
Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in its factory. Because both forklifts perform the same function, the firm will choose only one. (They are mutually exclusive investments.) The electric-powered truck will cost more, but it will be less expensive to operate; it will cost $21,500, whereas the gas-powered truck will cost $17,960. The cost of capital that applies to both investments is 13%. The life for both types of truck is...
Dev Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in...
Dev Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in its factory. Because both forklifts perform the same function, the firm will choose only one. (They are mutually exclusive investments.) The electric-powered truck will cost more, but it will be less expensive to operate; it will cost $21,000, whereas the gas-powered truck will cost $17,230. The cost of capital that applies to both investments is 11%. The life for both types of truck is...
10. Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials...
10. Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in its factory. Because both forklifts perform the same function, the firm will choose only one. (They are mutually exclusive investments.) The electric-powered truck will cost more, but it will be less expensive to operate; it will cost $22,000, whereas the gas-powered truck will cost $17,500. The cost of capital that applies to both investments is 12%. The life for both types of truck...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT