Microsoft Excel offers four inherent functions for calculating the monthly payments, present value, number of payments and the interest rate of an annuity.

Find out more about the price-to-earnings, or P/E, ratio, the P/E ratio formula and how to calculate the P/E ratio in Microsoft Excel.