Financial Modeling Tutorials
 Excel Modeling
 Financial Functions in Excel
 Sensitivity Analysis in Excel
 Sensitivity Analysis
 Capital Budgeting Techniques
 Time Value of Money
 Future Value Formula
 Present Value Factor
 Perpetuity Formula
 Present Value vs Future Value
 Annuity vs Pension
 Present Value of an Annuity
 Doubling Time Formula
 Annuity Formula
 Present Value of an Annuity Formula
 Future Value of Annuity Due Formula
 Maturity Value
 Annuity vs Perpetuity
 Annuity vs Lump Sum
 Deferred Annuity Formula
 Internal Rate of Return (IRR)
 IRR Examples (Internal Rate of Return)
 NPV vs XNPV
 NPV vs IRR
 NPV Formula
 NPV Profile
 NPV Examples
 Advantages and Disadvantages of NPV
 Mutually Exclusive Projects
 PV vs NPV
 IRR vs ROI
 Break Even Point
 Break Even Analysis
 Breakeven Analysis Examples
 Break Even Chart
 Benefit Cost Ratio
 Payback Period & Discounted Payback Period
 Payback period Formula
 Discounted Payback Period Formula
 Payback Period Advantages and Disadvantages
 Profitability Index
 Feasibility Study Examples
 Cash Burn Rate
 Interest Formula
 Simple Interest
 Simple Interest vs Compound Interest
 Simple Interest Formula
 CAGR Formula (Compounded Annual Growth Rate)
 Growth Rate Formula
 Effective Interest Rate
 Loan Amortization Schedule
 Mortgage Formula
 Loan Principal Amount
 Interest Rate Formula
 Rate of Return Formula
 Effective Annual Rate
 Effective Annual Rate Formula (EAR)
 Compounding
 Compounding Formula
 Compound Interest
 Compound Interest Examples
 Daily Compound Interest
 Monthly Compound Interest Formula
 Discount Rate vs Interest Rate
 Discounting Formula
 Rule of 72
 Geometric Mean Return
 Geometric Mean vs Arithmetic Mean
 Real Rate of Return Formula
 Continuous compounding Formula
 Weighted average Formula
 Average Formula
 EWMA (Exponentially Weighted Moving Average)
 Average Rate of Return Formula
 Mean Formula
 Mean Examples
 Population Mean Formula
 Weighted Mean Formula
 Harmonic Mean Formula
 Median Formula in Statistics
 Range Formula
 Outlier Formula
 Decile Formula
 Midrange Formula
 Quartile Deviation
 Expected Value Formula
 Exponential Growth Formula
 Margin of Error Formula
 Decrease Percentage Formula
 Relative Change
 Percent Error Formula
 Holding Period Return Formula
 Cost Benefit Analysis
 Cost Benefit Analysis Examples
 Cost Volume Profit Analysis
 Opportunity Cost Formula
 Opportunity Cost Examples
 APR vs APY
 Mortgage APR vs Interest Rate
 Normal Distribution Formula
 Standard Normal Distribution Formula
 Normalization Formula
 Bell Curve
 T Distribution Formula
 Regression Formula
 Regression Analysis Formula
 Multiple Regression Formula
 Correlation Coefficient Formula
 Correlation Formula
 Correlation Examples
 Coefficient of Determination
 Population Variance Formula
 Covariance Formula
 Coefficient of Variation Formula
 Sample Standard Deviation Formula
 Relative Standard Deviation Formula
 Standard Deviation Formula
 Standard Deviation Examples
 Effect Size
 Sample Size Formula
 Volatility Formula
 Binomial Distribution Formula
 Multicollinearity
 Hypergeometric Distribution
 Exponential Distribution
 Central Limit Theorem
 Poisson Distribution
 Central Tendency
 Hypothesis Testing
 Gini Coefficient
 Quartile Formula
 P Value Formula
 Skewness Formula
 R Squared Formula
 Adjusted R Squared
 Regression vs ANOVA
 Z Test Formula
 Z Score Formula
 Z Test vs T Test
 FTest Formula
 Quantitative Research
 Histogram Examples
Related Courses
Present value factor deals with the idea of time value for money by trying to estimate the current value per dollar to be received at a future date. The underlying idea is that any amount received today is of greater value than if that same amount were to be received on a future date since it can be reinvested to increase the overall earnings.
Present Value factor Formula
 r = rate of return
 n = number of periods
Derivation of Present Value Factor Formula
This is the original formula for PV factor from which the formula we have presented above is derived.
 Here, FV = Future Value
 r = rate of return
 n = number of periods
Recommended Courses
Examples of Present Value Factor Formula
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
Now, multiplying the sum of $1000 to be received in future by this PV factor, we get:
4.9 (1,067 ratings)
$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.
Explanation of PV factor Formula
Present value factor 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 which 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 present value factor 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.
Use of Present Value Factor Formula
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 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 a current investment and any viable alternatives. This would potentially be of great help in making betterinformed investment decisions.
Present Value Factor Calculator
You can use the following Present Value Factor Calculator.
r  
n  
Present Value Formula =  
Present Value Formula = 
 

Present Value Factor Formula 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 easily calculate the Present Value Factor in the template provided.
You can download this PV factor template here – Present Value Factor Excel Template
Recommended Articles
This has been a guide to Present Value Factor formula, its uses along with practical examples. Here we also provide you with Present Value Calculator with downloadable excel template.
 Geometric Mean Return Calculator
 Continuous Compounding Calculator
 Perpetuity Calculator
 Future Value Calculator
 250+ Courses
 40+ Projects
 1000+ Hours
 Full Lifetime Access
 Certificate of Completion