Can someone please explain how to do the last two parts? (d-1, d-2) I have a fin
ID: 2810534 • Letter: C
Question
Can someone please explain how to do the last two parts? (d-1, d-2) I have a financial calculator I am using. It would really help if you could explaon the process or show your work. Thank you.
Suppose you are offered $9,700 today but must make the following payments Year Cash Flows ($) $ 9,700 2 3 4 5,100 3,800 2,900 1,900 a. What is the IRR of this offer? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) IRR 18.60 % b. If the appropriate discount rate is 13 percent, should you accept this offer? Reject Accept c. If the appropriate discount rate is 24 percent, should you accept this offer? Accept Reject d-1. What is the NPV of the offer if the appropriate discount rate is 13 percent? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV d-2. What is the NPV of the offer if the appropriate discount rate is 24 percent? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPVExplanation / Answer
The best way to find the NPV of all cash flows after t=0 is by using the NPV Function in Microsoft Excel = NPV(rate, values)
d-1) NPV of the offer when the discount rate is 13% =
(PV of t=0) + NPV(13%,-5100,-3800,-2900,-1900)
= 9,700 - 10,664.38
-> NPV of offer = - $964.38
d-2) NPV of the offer when the discount rate is 24% =
(PV of t=0) + NPV(24%,-5100,-3800,-2900,-1900)
= 9,700 - 8,908.95
-> NPV of offer = $791.05