Principal Interest Calculation

An Excel file that teaches how to perform Principal Interest Calculation operation.

Excel Principal Interest Calculation

The term and interest rate are entered. Calculations are based on the interest period. The day count is determined using the 30/360 method. The monthly payment schedule is printed on the table. The total cost is reported.

Hope it is useful.