The article How to Calculate IRR with Unequal Timing of Cash Flows originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days.

Thankfully your handy spreadsheet program can make quick work of this problem. Using Excel to calculate IRR with unequal timing of cash flows ...

Using Excel to calculate IRR with unequal timing of cash flows In the chart below, we have management's estimation for the initial cost and cash flow returns for both the expansion and new ...

Using Excel to calculate IRR with unequal timing of cash flows In the chart below, we have management's estimation for the initial cost and cash flow returns for both the expansion and new ...

Find out more about free cash flow, the formula for calculating free cash flow, and how to calculate a company's free cash flow using Microsoft Excel.

For multiple, uneven cash flow events, the starting point is an estimated rate of return, with the NPV calculated for each cash flow event and the total compared to the initial investment amount.

Calculating the IRR for a project with an initial outlay and single cash flow is very easy to do. It's also very practical for measuring the returns.

Add together all the cash flows you have put in the spreadsheet to calculate a total. Divide the total by the number of historical entries to calculate the mean average cash flow.

3. Excel’s MIRR function. Excel’s MIRR function (modified internal rate of return) works similarly to the IRR function, except that it also considers the cost of borrowing the initial investment funds ...

Learn how to calculate the discount rate in Microsoft Excel, what the discount factor is, and how the discount rate and discount factor compare.