Fin 515 Homework Week 5

846 Words4 Pages
10-8 NPVs, IRRs, and MIRRs for Independent Projects Edelman Engineering is considering including two pieces of equipment, a truck and an overhead pulley system, in this year’s capital budget. The projects are independent. The cash outlay for the truck is $17,100 and that for the pulley system is $22,430. The firm’s cost of capital is 14%. After-tax cash flows, including depreciation, are as follows: Year | Truck | Pulley | 1 | $5,100 | $7,500 | 2 | 5,100 | 7,500 | 3 | 5,100 | 7,500 | 4 | 5,100 | 7,500 | 5 | 5,100 | 7,500 Calculate the IRR, the NPV, and the MIRR for each project, and indicate the correct accept-reject decision for each. IRR = 14.99% and 21.0% NPV = $408.71 and $3,318.10 MIRR = 14.54% and 17.20%…show more content…
(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 is estimated to be 6 years, during which time the net cash flows for the electric-powered truck will be $6,290 per year and those for the gas-powered truck will be $5,000 per year. Annual net cash flows include depreciation expenses. Calculate the NPV and IRR for each type of truck, and decide which to recommend. PV (electric-powered) = $22,000 PV (gas-powered) = $17,500 Cost of capital = 12% Number of years = 6 NCF for electric-powered = $6,290 NCF for gas-powered = $5,000 Electric-powered forklift NPV = -$22,000 + $6,290 [(1/i)-(1/(i*(1+i)n)] NPV = -$22,000 + $6,290 (4.1114) = -$22,000 + $25,861 = $3,862 IRR = rate (nper,pmt,pv,fv) = rate (6,6290, -22000,0) = 17% Gas-powered forklift NPV = -$17,500 + $5,000 [(1/i)-(1/(i*(1+i)n)] NPV = -$17,500 + $5,000 (4.1114) = -$17,500 + $20,557 = $3,057 IRR = rate (6,5000, 17500,0) = 17.95% = 18%. I would purchase the Electric-powered forklift. Being that the NPV is higher and that both have the very similar IRR. 11 – 2 Operating Cash Flow Cairn Communications is trying to estimate the first-year operating cash flow Operating Cash Flow (at t = 1) for a proposed project. The financial staff has collected the

More about Fin 515 Homework Week 5

Open Document