How To Calculate Interest On Personal Loan In Excel

Type ipmt b2 1 b3 b1 into cell b4 and press enter doing so will calculate the amount that you ll have to pay in interest for each period.

How to calculate interest on personal loan in excel. After one year you have 100 in principal and 10 in interest for a total base of 110. The the formula in f5 is. A loan payment calculator is a must have tool if you re planning on taking out a loan.

Enter the interest payment formula. Conclusion reducing balance method is a more borrower friendly approach of interest calculation on loans. To calculate the periodic interest rate for a loan given the loan amount the number of payment periods and the payment amount you can use the rate function.

Though the visible interest rate of fixed interest loan is small but over a period of time total payable by the borrower principal interest is high. In the example shown the total interest paid in year 1 is calculated by using 1 for start period and 12 for end period. Now you can calculate the total interest you will pay on the load easily as follows.

Cumipmt 5 12 60 30000 1 12 0. End period this too is a period number not a date for when we want to stop calculating interest. In the example shown the formula in c10 is.

Select 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. For example let s take a 100 loan which carries a 10 compounded interest. If you want to make your own the pmt function in excel coupled with other functions can be used to create a loan payment calculator.

This number will be the same as the term argument if you want interest for the length of. This doesn t give you the compounded interest which generally gets lower as the amount you pay decreases. To calculate the total interest for a loan in a given year you can use the cumipmt function.