Downloads
DAXFinancialAdvanced

RATE

Returns the interest rate per period of a loan or annuity.

Syntax
RATE(<nper>, <pmt>, <pv> [, <fv>] [, <type>] [, <guess>])

Returns: A decimal rate per period. Multiply by the number of periods in a year to get a nominal annual rate.

What it does

RATE works backward from the payments to the interest rate. If a vendor offers equipment at a monthly payment, RATE shows the monthly rate that is built into the offer, so the team can compare two financing offers on the same basis. It also helps check the rate on a loan statement when the contract does not state it clearly.

Syntax and arguments

Example

A vendor finances 10,000 of equipment with 24 monthly payments of 470.73. The team wants the monthly rate hidden in the offer.

Implied Monthly Rate = RATE(24, -470.73, 10000)

The result is about 0.01, which is 1 percent a month. The nominal annual rate is 12 percent, found by multiplying the monthly rate by 12. The effective annual rate is higher, because interest compounds each month.

Example: a second, different use

A quick check on the annual rate of a financing offer, shown as a percentage on a comparison sheet.

Nominal Annual Rate = [Implied Monthly Rate] * 12

Things to watch

In business terms

RATE supports comparison of financing offers, the implied rate on leases and vendor financing, the check of an interest rate stated in a loan agreement and the rate used in a debt covenant calculation. It answers "what rate am I really paying?" in one line.

Related functions

All DAX functions · View as Markdown · DAX fundamentals