Present value

This query is : Resolved

Rohit Jain (Querist)
Follow

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

K V Subba Rao

K V Subba Rao (Expert)
Follow

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

S.Srinivasaraghavan

S.Srinivasaraghavan (Expert)
Follow

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.

Upgrade to CAclubindia Pro. Subscribe Now!

Rohit Jain

Rohit Jain (Querist)
Follow

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

S.Srinivasaraghavan

S.Srinivasaraghavan (Expert)
Follow

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.