CA Lokesh Pokharna (CA (Ahmedabad Bhilwara Chittorgarh)) (4128 Points)
10 October 2012Hello friends&, members
How to calculated Future value & Present value in Excel 2007???
How to calculated Future value annuity & Present value annuity in Excel 2007???
CA Saroj Kumar
(Keen to learn something new every moments)
(2588 Points)
Replied 10 October 2012
Follow this link here usefull formulla's for calculating the same problems.
https://www.tvmcalcs.com/calculators/excel_tvm_functions/excel_tvm_functions_page2
CA CS CIMA Prakash Somani
(Landmark Group)
(23502 Points)
Replied 12 October 2012
Also refer:
| Present Value of an Annuity |
This page covers the following topics regarding the calculation of the present value of an annuity:
Agili Ron
(Student Others)
(46 Points)
Replied 12 October 2012
Hello Friends,
The most common financial functions in Excel 2007 — PV (Present Value) and FV (Future Value) — use the same arguments. The key to using these financial functions is to understand the terminology used by their arguments:
Calculating the Present Value (PV):
The PV function returns the present value of an investment, which is the total amount that a series of future payments is worth presently. The syntax of the PV function is as follows:
=PV(rate,nper,pmt,[fv],[type])
Determining the Future Value (FV):
The FV function calculates the future value of an investment. The syntax of this function is
=FV(rate,nper,pmt,[pv],[type])
Thanks And Regards.
Agili Ron
CAclubindia
