Step 1 – Calculate the EMI Amount of Home Loan Calculator with Prepayment Option in Excel Sheet The EMI, or Equated Monthly Instalment, is one of the equally divided monthly payments that must be settled in order to pay off an outstanding loan within a predetermined period of time. Select ...
Read More: Create Home Loan EMI Calculator in Excel Sheet with Prepayment Option Step 3 – Use a Subtraction Formula to Calculate the Principal Select cell E11 and insert the following: =C11-D11 C11 is the EMI of the loan, and D11 is the interest of the first month. Press Enter. Au...