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