Use Microsoft Excel to assess the internal rate of return for an IT initiative. Suppose the initial

Question:

Use Microsoft Excel to assess the internal rate of return for an IT initiative. Suppose the initial investment is $70,000. The returns on investment in dollars for the following 5 years are

(a) $12,000,

(b) $15,000,

(d) $21,000, and

(e) $26,000.

Use the IRR function to compute the internal rate of return after 2, 3, and 5 years. Next, assume that the loan for the initial $70,000 is at 8 percent and you are earning 15 percent on the annual returns. Use the MIRR function to calculate the internal rate of return. Is the annual rate of return higher when using the MIRR function than the IRR function? Under what circumstances would it be lower?

Internal Rate of Return
Internal Rate of Return of IRR is a capital budgeting tool that is used to assess the viability of an investment opportunity. IRR is the true rate of return that a project is capable of generating. It is a metric that tells you about the investment...