emi

Hi I am trying to make a EMI calculator with the PMT formula Lets say I have the following variables A1= Loan Amount B1= Duration C1= Rate of Interest I need to make a table with the projections based on the following parameters 1) Let say there is a loan of Rs 1,000,000 and the EMI for a...

When we give a loan to a friend, the payments are at most erratic, some months they repay the exact emi, some months they skip all together and some months the pay excess. now most of the loan amortisation tables show the month of payment, emi amount, principal deducted, interest deducted and...

Hello I am trying below VB code to execute PMT formula to calculate EMI but getting error "Unable to get pmt property of the worksheetFunction class" Sub EMI() Dim Loan_Amount As Double Dim EMI As Double Dim Rate As Double Dim Payment_Per_Year As Double Dim Tenure As Double monthly_rate =...

Hi, We use =PMT() to find out the value of EMI for given principal, period and rate of Interest. Principal Months Interest EMI 100000 246 11% 1,025.30 (Formula used for EMI =PMT(C2/12,B2,-A2)) What formula can we use to find out Principal if period, rate of Interest and EMI is...