How to calculate total interest paid on a loan in Excel?How to Find the Total Amount Paid in an Interest Rate Equationfinance - Formula for calculating the total interest TOTAL LOAN COST FORMULA and CALCULATORSelect the cell you will place the calculated result in, type the formula =CUMIPMT (B2/12,B3 12,B1,B4,B5,1), and press the Enter key. See screenshot: Note: In the formula, B2 is the annual loan interest rate, B2/12 will get the monthly rate; B3 is the years of the loan, B3 12 will get the total number of periods (months) during the loan; B1 is the Now you need to repay it monthly in half year. You can figure out the total interest paid as follows: 1. List your loan data in Excel as below screenshot shown: 2. In Cell F3, type in the formula, and drag the formula cell’s AutoFill handle down the range as you need. =IPMT($C$3/$C$4,E3,$C$4 $C$5, $C$2) ;· If you take out a five-year loan for $20,000 and the interest rate on the loan is 5 percent, the simple interest formula works as follows: $20,000 x 5 = $5,000 in interest09/11/2010 · Calculate your total interest paid. This is done by subtracting your principal from the total value of your payments. To get your total value of payments, multiply your number of payments, "n," by the value of your monthly payment, ", Then, subtract your principal, "P," from this number. The result is your total interest paid on your car loan.

Tags: