It is indeed nice to see this forum very fruitful and worth following. As understanding the exact tactics behind EMI, I may also want to know the FORMULA (mathematical) with which we calculate the EMI. I really find the excel sheet very usefull, at the same time very keen to know the physical calculation.
How do you arrive at the first basic principal amount and the interest rate>?