How to Calculate an Interest Payment Using Microsoft Excel?

1. Open Microsoft excel. 2. Type principal,interest,period and payment. 3. Type principal amount. 4. Interest rate for each period. 5. Type period in B3 cell. 6. In B4 cell type formula =IPMT(B2, 1, B3, B1) and press enter.