• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About

Excel PV Function

The Excel PV function is used to return the present value of an investment based on a constant interest rate and payments.

The syntax for the PV function is:

=PV(rate, nper, pmt, [fv], [type])

ArgumentPurpose
rateThe interest rate per period of the investment
nperThe number of payments for the investment
pmtThe payment made each period
fvThe future value, or total remaining after the last payment has been made.This argument is optional, and if omitted the total is assumed to be 0
typeWhen the payments are due. It can be entered as 1 or 0 and is optional. If omitted the value is assumed to be 00 – Payments are made at the end of the period1 – Payments are made at the beginning of the period

The examples below show the PV function being used to return the present value dependent upon different parameters.

Excel PV function to return the present value of an investment
FunctionResult
=PV(C4/12,B4*12,A4)£10,100Present value returned on an investment paid in £200 monthly payments for 5 years. Payments are made at the end of each period
=PV(C4/12,B4*12,A4,,1)£10,159Present value returned on an investment paid in £200 monthly payments for 5 years. Payments are made at the beginning of each period
=PV(C4/52,B4*52,A4)£43,850Present value returned on an investment paid in £200 weekly payments for 5 years. Payments are made at the end of each period

Primary Sidebar

Popular Posts

  • Excel Fixtures and League Table Generator
  • 5 Reasons Why your Excel Formula is Not Calculating
  • Excel IF Function Contains Text – A Partial Match in a Cell
  • Excel Formula to Display the Sheet Name in a Cell
  • 4 Alternatives to Nested IF Formulas
  • How to Hyperlink to a Hidden Worksheet in Excel
  • How to Create a Reverse FIND Formula
  • Check if a Value is an Even Number
  • Conditional Formatting Multiple Columns – 3 Examples
  • IF Function in Power Query Including Nested IFS

Recent Posts

  • SEQUENCE Function in Excel
  • Sort by Drop Down List in Excel
  • Advanced SUM Function Examples – The Power of SUM
  • Display Negative Time in Excel
  • Lookup Multiple Values in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2020 Computergaga · All Rights Reserved ·