Guide To Excel For Finance: PV And FV Functions
The Present Value or "PV Function" in Excel helps the user determine the current value of a financial asset. For instance, analysts can value a stock by forecasting its future profits, or cash flows, and discounting them back to today to get a current, or present value, for the stock. If it differs much from the value listed in the stock market, it may be either a buy or a sell.
Let's look at an example. Assume a company earns a profit of $100,000 annually over a period of 10 years. The "Type" is a "1" or "0" and details whether the earnings would occur at the beginning of each year, or end of each year, respectively. If an analyst has a price target of $100 per share, or a $1 million firm value assuming 10,000 shares outstanding, then the estimated present value of the stock is $29.04. If the current market price is above this level, the stock would not be worth buying. If it traded at less than $29 per share, then it would be worth an investment, based off of the inputs the analysts used in his analysis.
FV Function
You may have already noticed that the Future Value or "FV Function" in Excel was part of the discussion for the analyst valuing the stock, above. If we keep all of the variables the same, but assume we know the current firm value is $350,000, or $35 per share, then the future value of the stock in 10 years would be $84.53 per share. Here is what the inputs would look like:
Guide To Excel For Finance: HLookup And VLookup

Present Value  PV
The current worth of a future sum of money or stream of cash ... 
Future Value  FV
The value of an asset or cash at a specified date in the future ... 
Discounted Future Earnings
A method of valuation to estimate the value of a firm. 
Adjusted Present Value  APV
The Net Present Value (NPV) of a project if financed solely by ... 
Return on Market Value of Equity  ROME
Return on market value of equity (ROME) is a comparative measure ... 
Value Investing
The strategy of selecting stocks that trade for less than their ...

Why is the time value of money (TVM) an important concept to investors?
Understand why the time value of money is an important concept for investors. Learn when present value and future value calculations ... Read Answer >> 
How do you use a financial calculator to determine present value?
Learn how to utilize a financial calculator to calculate present value. Understand the necessary data, why it is important ... Read Answer >> 
What is the difference between a company's book value per share and its intrinsic ...
Book value and intrinsic value are two ways to measure the value of a company.In simple terms, book value is based on the ... Read Answer >> 
What is the difference between economic value and market value?
Learn about the differences between economic value and market value. Discover how they serve different purposes for businesses ... Read Answer >> 
When does a growth stock turn into a value opportunity?
Learn how fundamental analysts use valuation measures, such as the pricetoearnings ratio, to identify when a growth stock ... Read Answer >> 
How is perpetuity used in determining the intrinsic value of a stock?
Learn about the basics of a perpetuity, its valuation, how it is calculated and how it is used when evaluating the intrinsic ... Read Answer >>