The rate behind a financing offer
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
A dealer finances the amount in B1 against the monthly payment in B2 for the number of payments in B3. Work out the yearly interest rate behind the offer, as the monthly rate times 12, in B4.
What this exercise teaches
RATE is PMT turned around: the payment is known and the interest rate is the unknown. It returns the rate per period, so monthly payments give a monthly rate.
A hint if you get stuck
RATE(number of periods, payment, present value) returns the rate per period. Give the payment as a negative number, then multiply the monthly rate by 12.
Try it now, free, no account needed
Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.
Open this exerciseMore exercises in Finance
- Loan installment
- Is the project worth it?
- Growth over time
- Portfolio return
- Internal rate of return
- Value of an annuity
- Total interest on a loan
- Compound annual growth
- Break-even units
- Straight-line depreciation
- Monthly deposit for a goal
- Effective annual rate
- Months to clear a balance
- Interest and principal in one payment
- NPV on irregular dates
- Average price paid