Learn how to calculate the discount rate in Microsoft Excel, what the discount factor is, ... Alternatively, you can use the What-If analysis tool, a built-in calculator in Excel, ...

Credit utilization is the percentage of your total credit you're using. CNBC Select explains how you can calculate your credit utilization rate.

Excel 2013 provides the DATE and XIRR functions, which derive the final annual interest rate from a series of payments on known dates. Enter your list of payment amounts in column A.

Excel and Google Sheets have three functions to calculate the internal rate of return: IRR, XIRR, and MIRR. Learn how these functions can calculate investment returns.