Loan Payment Amount Calculator - EasyCalculationExcel formula: Calculate original loan amount | ExceljetWhat Is Loan Amortization Formula? Calculation & Example?Loan Payment Formula (with Calculator)To calculate the original loan amount, given the loan term, the interest rate, and a periodic payment amount, you can use the PV function. In the example shown, the formula in C10 = PV(C5 12, C7, C6)To solve the equation, you'll need to find the numbers for these values: A = Payment amount per period. P = Initial principal or loan amount (in this example, $10,000) r = Interest rate per period (in our example, that's divided by 12 months) n = Total number of payments or periods The formula for calculating your monthly payment is:Formula Used: A = ( P r ) [ 1 - (1+r) -N ] Where, A = Loan Amount P = Payment Amount r = Rate of Interest (compounded) N = Number of Payments Rate of Interest Compounded is, If Monthly, r = i 1200 and N = n 12 If Quarterly, r = i 400 and N = n 4 If Half yearly, r = i 200 and N = n …So, if your principal loan amount is INR 20000, Interest Rate is 5 percent, and the repayment tenure is 3 years, then you can calculate it as follows: 20000 x 3 = INR 3000 Here, INR 3000 will be the Interest cost that you will have to pay as an extra amount in addition to your loan amount over a period of 3 years.

Tags: Loan amount calculation formula in excel, Loan to value calculation formula, Home loan interest amount calculation formula,