Investment analysts commonly use Microsoft Excel for financial modeling ... Once this is done, use your spreadsheet's NPV (net present value) function to process your cash flow estimates and ...
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 ...