Question: I used the =IRR function in excel and got 4%, but it was marked wrong on my quiz. What am I doing wrong? a 14.

 I used the =IRR function in excel and got 4%, but

I used the =IRR function in excel and got 4%, but it was marked wrong on my quiz. What am I doing wrong?

a 14. You are offered a chance to buy an asset for $8,000 that is expected to produce cash flows of $1000 at the end of Year 1, $1,000 at the end of Year 2, $2000 at the end of Year 3, and $5,000 at the end of Year 4. What rate of return would you earn if you bought this asset? a. 4.00% b. 3.80% C. 3.75% d. 2.85%

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!