You can easily Calculate interest for a given period of time in MS Excel. This can be achieved with the help of IPMT function. This function is majorly used to calculate the interest factor on loans and hire purchases.
FORMULA AND EXAMPLE
The general formula used in the IMPT function is
Figure.1: Calculate interest for a given period
In the above example, the IMPT function is used to determine the interest on a loan amount. The formula used to calculate the interest is:
The formula works in a manner that it first divide the interest rate by 12 since the interest rate is for the whole year. So the equation becomes C6 divided by 12.
The PAR value and PV which is present value are two important aspects of the IMPT function on the basis of which the interest is calculated. Also, the excel sheet gives the answers in $ since the data was fed in using $ as its currency.