The discount factor is used by Excel to shed added light on the NPV formula and the impact that discounting can have. Here’s a comparison of the discount rate and the discount factor.