27 September 2008
There is no clarity in question.
Generally, one wants to know what is the EMI for a particular amount of loan with details of rate of interest and duration.
Visit http://www.apnaloan.com/loan-advice-india/calculator.html or website of any Bank which provide you Calculators to make calculations in different ways
27 September 2008
You have a present value calculation facility in the excel. All you have to do is list the instalments monthwise and apply the formula.
28 September 2008
Add up the present value of each monthly payment using the present value formula in MS Excel annually and you will get the aggregate present value.