Reviewed by Thomas J. Catalano Fact checked by Vikki Velasquez The discount rate refers to the interest rate used when calculating the net present value (NPV) of an investment. It represents the ...

Learn how to calculate the discount rate in Microsoft Excel, what the discount factor is, and how the discount rate and discount factor compare.

Scientific and mathematical formulas frequently use exponents and square roots, and you can create a function to compute the square, cube, or square root of a value by using the formula creator.