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 ...

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.

You need to have the zero-coupon yield curve information to calculate forward rates, even in Microsoft Excel.