How to use excel to calculate discount rate
The following video, NPV function in Excel, explains how NPV can be to calculate the Rate of Return for a given cash flow using Microsoft Excel IRR function for the following cash flow, considering minimum discount rate of 10% and 15%.