Formuladrill

Level 5: Finance Exercise 90 of 118

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.

Functions used: RATE

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 exercise

More exercises in Finance