Enter the cash flow values in a single column or row, with the initial investment as a negative number
Include all expected inflows and outflows for each period in order
Select an empty cell where you want the IRR result to appear
Type `=IRR(range)` replacing `range` with the cells containing your cash flows
Press Enter to calculate the IRR
Format the result cell as a percentage if needed
Use `=IRR(range, guess)` if Excel needs an initial estimate
Make sure the cash flows contain at least one negative and one positive value
Use `=XIRR(values, dates)` if cash flows occur on irregular dates
Use `=MIRR(values, finance_rate, reinvest_rate)` if you need a modified IRR calculation