Kumar Parik March 22, 2016. Hi Naveen, This EMI_. Calculator _with_Adhoc_Payments excel template is very useful. But if you annual total of repayment of Actual. Principal amount and Annual payment of, interest, that is much useful for all your user and if possible please provide month in front column. Project Management Dashboard Template, microsoft Word Templates High Quality Custom, labels General Handyman Business Estimate Form Form Mobile App In this article, I will show you how to calculate monthly payment. Excel with some examples and criteria. Here are the criteria: You have third party letter got 50,000 loan on June 05, 2018 Yearly interest rate of the loan is 12 You will get 5 years time to pay off the loan The set interest rate. In the original amortization schedule tutorial I left out a feature that is of interest to a lot of people: adding extra principal payments in order to pay off the loan earlier than the loan contract calls for. Enter the interest payment formula. Type ipmt(B2, 1, B3, B1) into cell B4 and press ing so will calculate the amount that you ll have to pay in interest for each period.