NPV helps determine whether a proposed project will add value, i.e., generate a profit. ... a built-in calculator in Excel, to solve for the discount rate that equals zero.

Learn how to calculate the discount rate in Microsoft Excel, what the discount factor is, ... NPV helps determine whether a proposed project will add value, i.e., generate a profit.