IPMT Function

[bg15407]

Hello Everyone


I'm Currently Developing a Loans Module and There are two types of loans EMI and Reducing Balance.

For EMI Loans Pmt Function works fine and gives me the Monthly Instalment and then i can Multiply Installment by term and subtract Loan Amount this way I can get the Total Interest That the customer is paying for That given Period

In Reducing Balance Method Ipmt only gives given Payment Interest only but what i need is Total Interest that customer will be paying for the Loan Term


Rate is Interest Rate (Double)
TermMonths is Term of the Loan Hence 36 in mycase
Amount is Loan (currency)
A1 has Value 1 and A10 has Value 10(in Excell)

in Excell----Sum(IPmt(Rate/12,(row(indirect A1&":"&A10)),TermMonths,-Amount0,0)) ----- This formula works fine and gives me the Total Interset for the 36 months

i need this to work in VBA Access 2013
Pls. Help

[ranman256]

give me some example data (and the answer), and I can convert it to Access.

[ssanfu]

You might check out this site:
IPmt Function
https://support.office.com/en-nz/art...a-de683454b320
(Applies To: Access 2007, Access 2010 Developer, Access 2013 Developer, Access 2007 Developer, Access 2013, Access 2010, Access)