Question: [Excel The following cash flow pattern has two IRRsDraw a graph of the NPV of those cash flows as a function of the discount rate.

[Excel The following cash flow pattern has two IRRsDraw a graph of the NPV of those cash flows as a function of the discount rate. Then use the IRR function to identify the two IRRs. Would you invest in this project if the opportunity cost were 20%? Please CLICK HERE to download the template, fill the highlighted cells, then submit your answers to the link below year 0 1 2 3 4 5 Cash flow -500 360 360 380 360 -1000 E Multiple IRRs Time Line Period Cash Flows 0 1 ($500.00) $360.00 2 $360.00 3 $360.00 4 5 $360.00 ##****#***# Discount Rates INPV 0% 3% 6% 9% 12% 15% 18% 21% 24% 27% 30% 33% 36% . 39% 42% 45% Identifying The Two IRRS First IRR If the cost of capital is 20% Your decision
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
