Present value


This query is : Resolved 

(Querist)
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 https://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.

Rohit Jain (Querist)
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



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 17 November 2026
Vacancy for Articleship

Promptitude Accounting Services Private limited

Bengaluru

B.Com

View Details
Company
ARTICLESHIP 29 October 2026
Article Assistant (CA Inter / CMA Inter) - Thrissur

Varma Raja & Associates

Thrissur

CA Inter

View Details