Internal rate of return Peace of? Mind, Inc.? (PMI) sells extended warranties for durable consumer goods such as washing machines and refrigerators. When PMI sells an extended? warranty, it receives cash up front from the? customer, but later PMI must cover any repair costs that arise. An analyst working for PMI is considering a warranty for a new line of? big-screen TVs. A consumer who purchases the 22?-year warranty will pay PMI ?$209. On? average, the repair costs that PMI must cover will average ?$101 for each for the? warranty's 2 years. If PMI has a cost of capital of 7?%, should it offer this warranty for? sale?
The internal rate of return? (IRR) for this project is ________%. (Round to two decimal? places.)
The NPV of this project is $____. (Round to two decimal? places.)
If PMI has a cost of capital of 7?%, should it offer this warranty for? sale? (Select the best answer? below.)
A. With a cost of capital of 7?% and an IRR of −2.24?%, and an NPV of ?$26.39?, PMI should reject this project.
B. With a cost of capital of −2.24?% and an IRR of 7?%, PMI should reject this project.
C. With a cost of capital of −2.24?% and an IRR of 7?%, PMI should accept this project.
D. With a cost of capital of 7?% and an IRR of −2.24?% and a NPV of $26.39?, PMI should accept this project.
IS there a formula we can use in excel?