Present value

This query is : Resolved 

27 September 2008 How to calcualte Present value of EMI
Suppose
EMI amount is 2000/month
Duration is 5 years

Then how to calculate PV of these EMIs

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.


27 September 2008 Dear Srinivas/ Subba rao
My question is very simple

such as Present value is calculated on yerly basis,
what is the basis to calculate PV of Monthly Payments

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.



You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Join CCI Pro
CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries