The IRR is the rate of growth that an investment must generate ... cost of capital equals the return of capital. The Excel formula for calculating the discount rate is =RATE (nper, pmt, pv ...

Read on to learn more about compound interest and how to calculate it using Excel. Let's say that you ... is similar to the Compounded Annual Growth Rate (CAGR). For CAGR, you are computing ...