banner_ad

How to compute future value & present value in excel 2007?

Excel for Finance 2393 views 4 replies

Hello friends&, members

 

How to calculated  Future value & Present value in Excel 2007???

How to calculated  Future value annuity & Present value annuity in Excel 2007???


 

Replies (4)

Follow this link here usefull formulla's for calculating the same problems.

 

https://www.tvmcalcs.com/calculators/excel_tvm_functions/excel_tvm_functions_page2

 

Financial Functions Using Microsoft Excel

 

FV
PV
RATE
NPV
IRR
PMT

 

Also refer:

 

 

 

This page covers the following topics regarding the calculation of the present value of an annuity:

  1. Formula and Definition
  2. PV of Annuity Illustrated
  3. Solving for Other Variables in the PV Equation
  4. Compounding Frequency
  5. Payment and Compounding Periods Do Not Coincide
  6. Excel
  7. HP-12C
  8. Programming Languages

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
 


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Related Topics
Loading
Company
16 May 2026
Audit clerk

mgirt & co

Bengaluru

CA Inter

View Details
Company
18 May 2026
MIS Executive

Primarc Pecan Retail Limited

Mumbai

B.Com

View Details
Company
24 May 2026
Accounts & Tax Executive

PARAS KHURANA AND CO

New Delhi

B.Com

View Details
Company
ARTICLESHIP 09 June 2026
Article Trainee

Numbertree LLP

Mumbai

CA Inter

View Details
Company
19 May 2026
Accountant

ca kunjan

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 17 May 2026
CA Article /Trainee

Malik Sunil & co

New Delhi

CA Foundation

View Details
Company
ARTICLESHIP 08 June 2026
Internal & Taxation Article

O P Bagla & Co LLP

New Delhi

CA Inter

View Details
Company
04 June 2026
Semi Qualified CA

Goyal Puneet & Associates

New Delhi

CA Final

View Details