You can use excel formulas PMT, PPMT and IPMT to calculate the EMI, Principle portion of EMI and Interest portion of EMI. PMT gives one value. PPMT changes based on the installment number (month).
You can write correct formulas once you know the pre-payment conditions and terms.