Calculating the internal rate of return, or IRR, of an investment is a powerful tool for businesses. When a manager is faced with a capital intensive decision, IRR can quickly compare the financial ...

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 on investments in collectibles, commodities, ...

Q. I have prepared projections for a proposed project, and I want to calculate the internal rate of return. Instead of using Excel’s IRR function, should I use simple math formulas so others can ...

Linda Grayson has 20+ years of experience in proprietary trading and index futures. She began writing for Investopedia in 2018. David Kindness is a Certified Public Accountant (CPA) and an expert in ...

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

Excel percentage formulas can get you through problems large and small every day—from determining sales tax (and tips) to calculating increases and decreases. We’ll walk through several examples below ...