Hi Asif, Use the pmt function: =pmt(interest rate as decimal per period, # of instalments, present value, future value, type) Your present value is 110000, future value is 0, type may be taken as 0 or simply ignored, interest rate is 0.125/12 per month. Details of pmt can be found in excel help under financial functions. Thanks, Anil ----- Original Message ----- From: "Mohammed Asif Iqbal" <[EMAIL PROTECTED]> To: <[email protected]> Sent: 11 July, 2006 11:49 AM Subject: [AI] Seeking XL Solutions
> Dear all, > I was hoping to receive your guidance on how to solve this problem of finding Equally monthly installment by using xl? Let's say that I take a loan of Rs. 1lac (100000) at 12.5% and repayment period would be 36 EMI ? > How do I get this answer by using XL function? > Thanks and regards > Asif > To unsubscribe send a message to [EMAIL PROTECTED] with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.394 / Virus Database: 268.9.10/384 - Release Date: 10-07-06 > > To unsubscribe send a message to [EMAIL PROTECTED] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
