How to Excel at calculating the Internal Rate of Return A blonde wanting to earn some money decided to hire herself out as a handyman-type and started canvassing a wealthy neighbourhood.

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

How to Calculate Internal Rate of Return Over a 10-Year Period. Making good investments in projects and long-term assets is an important part of growing a small business.

The internal rate of return, or IRR, allows investors to analyze the profitability of investments and companies to analyze the profitability of capital outlays.

If your business makes investments in equipment and employee benefit contributions, you may need to track the average annual rate of return over a span of time for financial reporting obligations.

Discover how to calculate the modified Macaulay duration of a bond or other fixed-income security using Microsoft Excel.

Calculating the return One of the best methods for calculating an average return for a stock investment is the XIRR function in Excel.

A variation of this metric, called the modified internal rate of return (MIRR), compensates for this flaw and gives managers more control over the assumed reinvestment rate from future cash flows.

What is the internal rate of return (IRR)? This article explains the concept of IRR, how to calculate it, why it’s used and its importance.

In this article, we are looking for the discount rate that results in the NPV equaling zero. Doing so allows us to determine the internal rate of return (IRR) of a project or an asset.