Best answer

=IRR (D2:D14,.1)*12

People also ask

  • How to calculate annual rate of return in Excel IRR?

  • In event of monthly cash flows, the IRR function produces a monthly rate of return. To get an annual rate of return for monthly cash flow, you can use the XIRR function. Example 2: Use guess in Excel IRR formula Optionally, you can put an expected internal rate of return, say 10 percent, in the guess argument:

  • What is the IRR function in Excel?

  • This tutorial explains the syntax of the Excel IRR function and shows how to use an IRR formula to calculate the internal rate of return for a series of annual or monthly cash flows.

  • How do I calculate IRR for cash flows?

  • If omitted, the default value of 0.1 (10%) is used. For example, to calculate IRR for cash flows in B2:B5, you’d use this formula: =IRR (B2:B5) For the result to display correctly, please make sure the Percentage format is set for the formula cell (usually Excel does this automatically).

  • How do I get more than one IRR in Excel?

  • When you get more than one IRR for the same cash flow, choose the one closest to your company’s cost of capital as the true IRR. Use the MIRR function to avoid the problem of multiple IRRs. The IRR function in Excel is designed to work with regular cash flow periods such as weekly, monthly, quarterly or annually.