Scribd Logo
Upload

Welcome to Scribd!

  • 3K views

    Stock Intrinsic Value

    Uploaded by

    aazmi23
    The document calculates the intrinsic value of MMC Corporation stock using the discounted earnings per share method over 10 years. It provides the stock symbol, current EPS of $2.80 in 2014, an EPS growth rate of 12%, and discount rate of 3%. A chart displays the projected EPS over 10 years and discounted value. The intrinsic value is the total of the discounted future EPS amounts.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd

    Stock Intrinsic Value

    Uploaded by

    aazmi23
    3K views6 pages
    The document calculates the intrinsic value of MMC Corporation stock using the discounted earnings per share method over 10 years. It provides the stock symbol, current EPS of $2.80 in 2014, an EPS growth rate of 12%, and discount rate of 3%. A chart displays the projected EPS over 10 years and discounted value. The intrinsic value is the total of the discounted future EPS amounts.

    Original Title

    stock intrinsic value.xls

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document calculates the intrinsic value of MMC Corporation stock using the discounted earnings per share method over 10 years. It provides the stock symbol, current EPS of $2.80 in 2014, an EPS growth rate of 12%, and discount rate of 3%. A chart displays the projected EPS over 10 years and discounted value. The intrinsic value is the total of the discounted future EPS amounts.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    3K views6 pages

    Stock Intrinsic Value

    Uploaded by

    aazmi23
    The document calculates the intrinsic value of MMC Corporation stock using the discounted earnings per share method over 10 years. It provides the stock symbol, current EPS of $2.80 in 2014, an EPS growth rate of 12%, and discount rate of 3%. A chart displays the projected EPS over 10 years and discounted value. The intrinsic value is the total of the discounted future EPS amounts.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    You are on page 1of 6

    Intrinsic Value Calculator (Discounted Earnings Per Share Method 10 years

    (Be consistent with the denominations used. Usually Millions $)

    KEY IN THE VALUES IN WHITE BOX

    Name of Stock mmc corporation


    Stock Symbol MMCCORP

    Current EPS $2.80 Current Year 2014 NB: Take the last Fiscal Year as the Current Y

    EPS Growth Rate 12% Discount Rate 3% NB: Use the 3 months US Treasury Rate

    Intrinsic Value Calculator


    (Discounted Earnings Per Share Method 10 years)
    $10.00
    $9.00 EPS(Projected)
    $8.00 Discounted
    Value

    Value
    $7.00
    $6.00
    $5.00
    $4.00
    $3.00
    $2.00
    $1.00
    $0.00
    2015 2016 2017 2018 2019 2020 2021 2022 2023 2024
    Year
    ted Earnings Per Share Method 10 years)
    nominations used. Usually Millions $)

    NB: Take the last Fiscal Year as the Current Year

    NB: Use the 3 months US Treasury Rate

    sic Value Calculator


    ngs Per Share Method 10 years)

    2020 2021 2022 2023 2024


    Year
    Intrinsic Value Calculator (Discounted Cash Flow Method 10 years)
    (Be consistent with the denominations used. Usually Millions $)

    KEY IN THE VALUES IN WHITE BOX

    Name of Stock Nike


    Stock Symbol NKE

    Operating Cash Flow (current) $1,514.00 millions

    Cash flow growth rate 9.51% Current Year 2006 NB: Take the last Fiscal Year as t

    No. of Shares Outstanding 262.0 millions Discount Rate 5% NB: Use the 3 months US Treasu

    Intrinsic Value Calculator


    (Discounted Cash Flow Method 10 years)
    $4,000.00
    Value

    $3,500.00 Cash
    Flow(Projected)
    $3,000.00
    Discounted Value
    $2,500.00
    $2,000.00
    $1,500.00
    $1,000.00
    $500.00
    $0.00
    2007 2008 2009 2010 2011 2012 2013 2014 2015 2016
    Year
    counted Cash Flow Method 10 years)
    enominations used. Usually Millions $)

    NB: Take the last Fiscal Year as the Current Year

    NB: Use the 3 months US Treasury Rate

    You might also like