Data computer systems is considering a project that has the following cash flow data. what is the project's irr? note that a project's irr can be less than the wacc (and even negative), in which case it will be rejected. year 0 1 2 3 cash flows -$1,100 $450 $470 $490

13%

Explanation:

To solve for the IRR we first need the formula

where NPV is the net present value, is the cash flow in period t, and r is the IRR (internal rate of return)

Solving this polynomial can be quite cumbersome. Thankfully excel has a built in function that we can take advantage of call IRR

As shown in the screen shot we write the cash flow, with the first one with the negative sign. Then we call the IRR function selecting the cells with our Cash Flow values and excel will return the IRR. In this case is 13%

if it is for a job, then you should learn everything you can about the job, like what does it involve, what qualification is required and how you are the right person for that job. dress appropriately for the interview. get plenty of rest the night before. good luck!