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

Calculate the weighted average of interest rates in Microsoft Excel to compute the most accurate average interest rate among a group of lenders who received different rates.

The Gordon growth model, also known as the dividend discount model, is often applied in Microsoft Excel to determine the intrinsic value of a stock.

Excel offers three functions for calculating the internal rate of return, and I recommend you use all three.