The discount rate refers to the interest rate used when calculating the net present value (NPV ... capital equals the return of capital. The Excel formula for calculating the discount rate ...

Here’s how you’d set up the formula: In Google Sheets and Excel, you can type this directly or reference cell values for each component. Remember, the negative sign for present value is ...