Answered

Find the best answers to your questions at Westonci.ca, where experts and enthusiasts provide accurate, reliable information. Discover detailed answers to your questions from a wide network of experts on our comprehensive Q&A platform. Connect with a community of professionals ready to help you find accurate solutions to your questions quickly and efficiently.

What is the IRR for the following project if its initial after tax cost is $5,000,000 and it is expected to provide after-tax operating cash inflows of $1,800,000 in year 1, $1,900,000 in year 2, $1,700,000 in year 3 and $1,300,000 in year 4

Sagot :

fichoh

Answer:

13.57%

Explanation:

Given the data :

Initial after tax cost = 5,000,000

Cash inflows:

Year 1 : $1,800,000

Year 2 : $1,900,000

Year 3 : $1,700,000

Year 4 : $1,300,000

The Internal rate of return can be obtained using the excel ;

IRR(Series of cash flow)

If the data above were inputed in an excel sheet from cell A1 to cell A4 ;

IRR(A1:A4)

Internal rate of return value obtained is 13.57%

We hope our answers were helpful. Return anytime for more information and answers to any other questions you may have. We hope you found this helpful. Feel free to come back anytime for more accurate answers and updated information. Stay curious and keep coming back to Westonci.ca for answers to all your burning questions.