The Rate function in Excel (RATE) calculates the interest rate for a financial transaction, such as for an annuity or lump sum. An annuity is simply an equal series of payments. You tell the RATE function the payments that are made, for how long they are made, and the present value and this function will give you the interest rate for that equati ...
Added: Oct 26, 2015