Guide To Excel For Finance: PV And FV Functions
  1. Guide To Excel For Finance: Introduction
  2. Guide To Excel For Finance: Goal Seek
  3. Guide To Excel For Finance: PV And FV Functions
  4. Guide To Excel For Finance: HLookup And VLookup
  5. Guide To Excel For Finance: Linking Yahoo! Finance and Other Outside Financial Data To Excel
  6. Guide To Excel For Finance: Ratios
  7. Guide To Excel For Finance: Technical Indicators
  8. Guide To Excel For Finance: Valuation Methods
  9. Guide To Excel For Finance: Advanced Calculations
  10. Guide To Excel For Finance: Conclusion

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

  1. Guide To Excel For Finance: Introduction
  2. Guide To Excel For Finance: Goal Seek
  3. Guide To Excel For Finance: PV And FV Functions
  4. Guide To Excel For Finance: HLookup And VLookup
  5. Guide To Excel For Finance: Linking Yahoo! Finance and Other Outside Financial Data To Excel
  6. Guide To Excel For Finance: Ratios
  7. Guide To Excel For Finance: Technical Indicators
  8. Guide To Excel For Finance: Valuation Methods
  9. Guide To Excel For Finance: Advanced Calculations
  10. Guide To Excel For Finance: Conclusion
RELATED TERMS
  1. Present Value - PV

    The current worth of a future sum of money or stream of cash ...
  2. Future Value - FV

    The value of an asset or cash at a specified date in the future ...
  3. Discounted Future Earnings

    A method of valuation to estimate the value of a firm.
  4. Adjusted Present Value - APV

    The Net Present Value (NPV) of a project if financed solely by ...
  5. Return on Market Value of Equity - ROME

    Return on market value of equity (ROME) is a comparative measure ...
  6. Value Investing

    The strategy of selecting stocks that trade for less than their ...
RELATED FAQS
  1. 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 >>
  2. 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 >>
  3. 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 >>
  4. 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 >>
  5. When does a growth stock turn into a value opportunity?

    Learn how fundamental analysts use valuation measures, such as the price-to-earnings ratio, to identify when a growth stock ... Read Answer >>
  6. 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 >>
Hot Definitions
  1. White Squire

    Very similar to a "white knight", but instead of purchasing a majority interest, the squire purchases a lesser interest in ...
  2. MACD Technical Indicator

    Moving Average Convergence Divergence (or MACD) is a trend-following momentum indicator that shows the relationship between ...
  3. Over-The-Counter - OTC

    Over-The-Counter (or OTC) is a security traded in some context other than on a formal exchange such as the NYSE, TSX, AMEX, ...
  4. Quarter - Q1, Q2, Q3, Q4

    A three-month period on a financial calendar that acts as a basis for the reporting of earnings and the paying of dividends.
  5. Weighted Average Cost Of Capital - WACC

    Weighted average cost of capital (WACC) is a calculation of a firm's cost of capital in which each category of capital is ...
  6. Basis Point (BPS)

    A unit that is equal to 1/100th of 1%, and is used to denote the change in a financial instrument. The basis point is commonly ...
Trading Center