Nice article explaining how to work out an EMI for a given loan amount. Just in case anyone would like to use a readymade EMI calculator in excel they can go ahead and use this. It basically uses the same formulas outlined here (rate, tenure and loan amount) and adds some more functionality to it.
