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

The compound interest formula is similar to the Compounded Annual Growth Rate (CAGR ... the loan is repaid. Excel can be a helpful and powerful partner when you need to calculate compound ...