<!-- https://learnsql.cpetoday.com/functions/dax/rate -->
# RATE

Language: DAX
Category: Financial
Syntax: RATE(<nper>, <pmt>, <pv> [, <fv>] [, <type>] [, <guess>])
Summary: Returns the interest rate per period of a loan or annuity.
Returns: A decimal rate per period. Multiply by the number of periods in a year to get a nominal annual rate.
Level: Advanced
Related: NPER, PMT, PV, FV, XIRR

## 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
- nper: the number of periods. Required.
- pmt: the payment per period. Cash you pay is negative. Required.
- pv: the amount financed, received as a positive number. Required.
- fv: the balance after the last payment. Optional, and 0 is the default.
- type: 0 for end-of-period payments (the default), or 1 for start-of-period payments. Optional.
- guess: a starting estimate for the rate, such as 0.01. Optional. Supply it when the function does not converge.

## 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.

```dax
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.

```dax
Nominal Annual Rate = [Implied Monthly Rate] * 12
```

## Things to watch
- RATE returns a rate per period. Monthly payments give a monthly rate, and the annual figure needs the multiply-by-12 step, which is a nominal rate, not the effective annual rate.
- The function may not converge for some inputs. Give a guess close to the expected rate.
- Fees, points and deposits change the true cost. RATE uses only the payment, the amount financed and the number of payments.
- The sign convention matters. A payment you pay must be negative, and the amount financed must be positive, or the result is wrong.

## 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.
