Question Using the information below to answer the question, Choose the best option from the given answers to answer each question. 1 SOLVING FOR i in an annuity 2 present value -12600 3 future value 0 4 Annual payment 1800 5 number of years 11 6 Annual rate 8.41%

Which one of the following formulas is correct when calculating the annuity rate in B6 using an Excel worksheet?

a.

=RATE(B3;B4;B2;B3;0;0,1)

b.

=RATE(B4;B4;B2;B3;0;0,1)

c.

=RATE(B5;B4;B2;B3;0;0,1)

d.

=RATE(B6;B4;B2;B3;0;0,1)