Question: can you answer this question in Excel as a formula please? Create a new Tab in your Excel worksheet & place company name at the

can you answer this question in Excel as a formula please?

can you answer this question in Excel as a formula please? Create

Create a new Tab in your Excel worksheet \& place company name at the top of your worksheet. Yakima Racks is evaluating two alternative, mutually exclusive methods for a new kayak carrier frame. It has developed the following estimated after-tax cost savings for each alternative method. Project managers require an appropriately applied IRR methodology for their decisions. If the project discount rate is 11%, and the cash flows are those noted below, which method would recommend? Provide results for both traditional NPV analysis and an appropriately applied IRR analysis. Explain your recommendation fully on your worksheet. Show all cash flows and related analysis. Clearly specify your recommendation and reasoning clearly on your worksheet. A: Titanium Pully CFs: TO=(115,000), T1=1,000; T2=5,000; T3=25,000; T4=45,000; T5=100,000 B: Metal Hook CFs: T0 =(95,000),T1=45,000;T2=35,000;T3=30,000;T4=20,000;T5=10,000 Method A (Titanium Pulley) since the incremental IRR is greater than the discount rate. Method A (Titanium Pulley) since it has a higher NPV than the Method B. Method B (Metal Hook) since it has an IRR that is higher than Method A. Method B (Metal Hook) since the incremental IRR is less than the discount rate. None of the above. Specify answer clearly in your worksheet

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!