Periodic Rate Functions in Excel. Microsoft Excel 2010 can be a huge help for a business when it comes to crunching the businesses numbers. Excel has a number of financial functions revolving ...

The PMT function is designed to calculate the periodic payment for a loan (assuming constant payments and interest rates). It's a fundamental tool for financial calculations in Excel.

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.

Excel Financial functions are used to assist Financial Analysts and Investment Brokers to make calculations and create graphs. Here are the useful ones!

Learn what present value (PV) and future value (FV) are and how to calculate present value in Excel given the future value, interest rate, and period.

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.