This worked for me using your initial example:
$PMT$ * (1-(1/((1+$r$)^$n$)))/$r$
Where PMT, r, and n were all defined from an input table. To make it a bit more readable using your second inputs:
$Proposed EMI$ * (1-(1/((1+0.015)^12)))/0.015
This worked for me using your initial example:
$PMT$ * (1-(1/((1+$r$)^$n$)))/$r$
Where PMT, r, and n were all defined from an input table. To make it a bit more readable using your second inputs:
$Proposed EMI$ * (1-(1/((1+0.015)^12)))/0.015