Guide To Excel For Finance: PV And FV Functions
AAA
  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

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
Guide To Excel For Finance: PV And FV Functions
RELATED TERMS
  1. Earnings Per Share - EPS

    The portion of a company's profit allocated to each outstanding ...
  2. Return On Investment - ROI

    A performance measure used to evaluate the efficiency of an investment ...
  3. Mass Index

    A form of technical analysis that looks at the range between ...
  4. Money Flow Index - MFI

    A momentum indicator that uses a stock’s price and volume to ...
  5. On-Balance Volume (OBV)

    A momentum indicator that uses volume flow to predict changes ...
  6. Negative Volume Index - NVI

    A technical indicator that relies on changes in a security’s ...
  1. Which leverage ratios are most useful for analyzing manufacturing companies?

    See which leverage ratios investors and creditors are likely to use when analyzing the debt burdens for manufacturing companies.
  2. How is accumulation area calculated?

    Explore the use of accumulation areas in the analysis of traded securities. Learn about on-balance volume and its role in ...
  3. How is the Accumulative Swing Index calculated?

    Learn how the accumulative swing index is calculated using swing index. Explore absolute value and how it is used in the ...
  4. What are the differences between a bar chart and candle sticks?

    Explore the difference between bar and candlestick charts. Learn how technical analysts use charts in the analysis of supply ...
Related Tutorials
  1. Industry Handbook
    Investing Basics

    Industry Handbook

  2. Discounted Cash Flow Analysis
    Fundamental Analysis

    Discounted Cash Flow Analysis

  3. Ratio Analysis Tutorial
    Fundamental Analysis

    Ratio Analysis Tutorial

  4. Introduction to Stock Trader Types
    Active Trading Fundamentals

    Introduction to Stock Trader Types

  5. Guide to Pairs Trading
    Trading Strategies

    Guide to Pairs Trading

Trading Center