Bookshelf Home | Contents | Index | PDF |
Siebel VB Language Reference > Methods Reference for Siebel VB > Financial Methods > Calculate Interest Rate MethodThe Calculate Interest Rate method calculates, and then returns the interest rate for each period for an annuity or a loan. This method is iterative. It improves a guess over multiple iterations until the result is within 0.00001 percent. If it does not converge to a result in 20 iterations, then it displays a failure message. FormatRate(nper, pmt, pv, fv, due, guess) For more information, see Arguments You Can Use with Financial Methods. ExampleThe following example calculates the interest rate on a 10 year, $25,000 annuity that pays $100 for each month: Sub Button_Click |
Siebel VB Language Reference | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |