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

IRR calculates a project's average expected return by setting NPV to zero. Excel's XIRR function can compute project IRRs to help select profitable options. IRR overlooks cash flow accuracy and other ...

Calculating returns from your stock portfolio can be a tricky matter, especially if some of your holdings pay dividends, or you make frequent deposits and withdrawals from your account. With Excel and ...