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 ...

Daniel Jassy, CFA, is an Investopedia Academy instructor and the founder of SPYderCRusher Research. He contributes to Excel and Algorithmic Trading. David Kindness is a Certified Public Accountant ...

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

Earlier, we had seen how the RATE function can be used to calculate the return on investments, whether lump-sum or periodic. This can come in handy in the calculation of SIP returns, too.