WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Present Value Factor (PV)

Present Value Factor (PV)

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What is Present Value Factor (PV)

Present value factor is factor which is used to indicate the present value of cash to be received in future and is based on time value of money. This PV factor is a number which is always less than one and is calculated by one divided by one plus the rate of interest to the power, i.e. number of periods over which payments are to be made.

Present Value Factor Formula

Present-Value-Factor-Formula

  • r = rate of return
  • n = number of periods

This formula is centered on the idea of assessing if an ongoing investment can be encashed and utilized better to enhance the final outcome as compared to an original outcome that can be had with the current investment. With a view to estimating what would be the current value of a certain sum to be received on a future date, we need two factors, namely, the time interval after which the sum is to be received and the rate of return for the same. These two factors can then be used to calculate the present value factors for any given sum to be received on any given future date.

This PV factor would help calculate the current equivalent amount for the future sum in terms of time value for money, and then it is used to calculate how better returns can be achieved by reinvesting this current equivalent in a relatively better avenue.

Examples

Suppose, if someone were to receive $1000 after 2 years, calculated with a rate of return of 5%. Now, the term or number of periods and the rate of return can be used to calculate the PV factor for this sum of money with the help of the formula described above.

PV factor = 1 / (1+r)n = 1/(1+0.05)2  = 0.907

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Now, multiplying the sum of $1000 to be received in the future by this PV factor, we get:

$1000 x 0.907 = $907

This means that $907 is the current equivalent of the sum of $1000 to be received after 2 years with a rate of return of 5%, and it could be possible to reinvest this sum of $907 somewhere else to receive greater returns.

Uses

This concept of PV factor can be of great use in estimating if a current investment would be worth continuing with, or a portion of it can be received today and reinvested to receive greater returns. If one finds that the present value of the sum to be received in the future can yield higher returns in an alternative investment, it shed further light on the value of the current investment and any viable alternatives. This would potentially be of great help in making better-informed investment decisions.

Present Value Factor Calculator

You can use the following calculator.

r
n
Present Value Formula =
 

Present Value Formula =
1
=
(1 + r)n
1
= 0
(1 + 0)0

Present Value Factor in Excel (with excel template)

Let us now do the same example above in Excel. This is very simple. You need to provide the two inputs of Rate of Returns and Number of Periods.

You can download this Present Value Factor Excel Template here – Present Value Factor Excel Template

You can easily calculate this factor in the template provided.

Present Value Factor in Excel

Recommended Articles

This has been a guide to the Present Value Factor and its meaning. Here we calculate the PV factor along with its examples and uses. Here we also provide you with a Present Value Calculator with a downloadable excel template.

  • Geometric Mean Return Calculator
  • Continuous Compounding Calculator
  • Perpetuity Calculator
  • Future Value Formula
  • Rule of 69
15 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Present Value Factor Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More