Internal rate of return (IRR) is one of several well-known formulas used to evaluate prospective investments. It allows you to calculate an investment's potential gains over a certain period of ...

Excel can find the internal rate of return (IRR ... an NPV of zero if the cost of capital equals the return of capital. The Excel formula for calculating the discount rate is =RATE (nper, pmt ...

You'd likely need financial calculator or a spreadsheet to calculate the internal rate of return, yield to maturity, or common risk metrics like beta or standard deviation. The beauty of the Rule ...