lezawang
Wellknown Member
 Joined
 Mar 27, 2016
 Messages
 1,805
 Office Version

 2016
 Platform

 Windows
Hello
I am trying to use whatif to calculate the rate if the payment is known. In this example if the interest rate is 4% then the payment is 736.66. Now I want to know what is the interest rate if the payment is 1000, WhatIf gave me the answer which is 17%. I thought if the payment is higher then the interest rate should be low. Am I right?
<tbody>
</tbody>
Any help would be very much appreciated.
I am trying to use whatif to calculate the rate if the payment is known. In this example if the interest rate is 4% then the payment is 736.66. Now I want to know what is the interest rate if the payment is 1000, WhatIf gave me the answer which is 17%. I thought if the payment is higher then the interest rate should be low. Am I right?
loan  40000 
term  60 
rate  4% 
payment  =pmt(A3/12,A2,A1) 
<tbody>
</tbody>
Any help would be very much appreciated.