Stock Valuation Term Paper

Download this Term Paper in word format (.doc)

Note: Sample below may appear distorted but all corresponding word document files contain proper formatting

Excerpt from Term Paper:

Valuation of Stock

Cisco Systems

The stock valuation project calls for the choosing of a stock, and I have chosen Cisco Systems. This company is traded on the NASDAQ under the ticker symbol of CSCO. I wanted to choose a stock that is an important part of the business environment. I wanted a growth stock, and looked to technology, but I also wanted to pick something that was a bit under the radar. Cisco fits that bill because it does not sell to consumers, but mainly to other tech companies. In that sense, Cisco is a bellwether stock for the entire technology business.

General Description of the Economy

The general economy is in a state of downturn. The downturn began in 2007-2008 when the financial crisis emerged. This caused a credit crunch, and then job losses. Unemployment and uncertainty saw the reduction of the overall health of the economy. Since that point, recovery has been slow, but it is an ongoing process. There are definitely those who feel that the recovery should have been faster. One thing, though, is that the technology industry is affected somewhat differently than the overall economy. The period that coincides with the economic slowdown also coincides with the mobile revolution and rapid deployment of smartphones. So some technology companies have gained tremendously in that period. Cisco's end users tend more to be businesses, either directly on via the products they sell that rely on Cisco technology. Therefore, Cisco struggled during the downturn because business spending was very low. The company did remain profitable during this period.

The industry in which Cisco operates is populated by large and powerful firms with high levels of technological innovation and finances. Conditions are either oligopoly or monopolistic competition. Firms often sign contracts for service with their customers to ensure more stable revenue streams. Firms do have individual sales as well. For a networking company, there is also competition in terms of how comprehensive the service that they offer is. Cisco occupies a niche within this industry that is heavily focused on networking.

In general, Cisco is a high growth company. It has strong products such as switches and routers, so it is connected with networking. This means that Cisco has been affected not only by business spending, but positively by the rise of mobile. Growth prospects for Cisco are strong. The company only started paying a dividend in 2011. The strengths of Cisco are with its products, its brands, its customer networks and its strong financial position. If it has any weaknesses, they are mostly with diversification, since Cisco has long been a specialized player in networking solutions rather than a more comprehensive technology company in the way that competitors like Hewlett Packard and IBM are (Duffy, 2010).

The Dividend Discount Model

For a high growth company like Cisco, a multistage dividend discount model can be used. In principle, the dividend discount model assumes that investors seek intrinsic value, that is the present value of expected future cash flows. For stocks, that means both dividends and capital gains. The multi-stage version of this model attempts to build in growth at multiple stages, where growth occurs at different rates. Cisco is not in the early stages of very high growth, but can expect to grow strongly for the next few years as networking becomes more common. Eventually, Cisco will start to mature. Dividends will be a bigger part of its returns at that point in time. For Cisco Systems, therefore, it is better to use a two-stage growth model, but a three-stage model allows for more refined calculation. The first step in this is to use the capital asset pricing model to derive the discount rate. The risk free rate is 0.15% according to the Treasury, for a six-month paper. The beta for Cisco Systems is 1.23. Plugged into the model spreadsheet this gives the following cost of capital K

Risk Free Rate


Market Risk Premium






Using the spreadsheet but changing the numbers to reflect the current circumstances of Cisco, the following value is derived:

3 Stage Growth Model

g (next 5 years)


g (years 6-15)


g (years 16 to infiniti)


Dividend payout, first stage


Dividend payout, 2nd stage


Dividend payout, last stage








Price at the end of stage 2

PV of all dividends in stage 1&2


PV of Stock price at the end of stage 2


Sum of B26 & B27= today's value


The assumptions were lower growth rates and the initial dividend that has just been introduced has been factored in. A standard maturation process of the networking business is assumed. This finding shows that Cisco is probably worth more than its current market valuation. The current valuation of the market is $25.50. Thus, Cisco appears to be undervalued.

The Residual Income Model

The residual income model is not the best model for this type of thing. This model is best used for companies that are not profitable, or do not have positive cash flow, or do not pay dividends. Cisco does not meet these criteria. As such, not much will be expected from the application of the residual income model in this instance.

The point of the residual income model is to take into account not the income of the company, but the income that is left over after financing costs have been taken into account. Interest expense for debt financing is already removed from net income, but the equity financing costs have not been removed. The equation needs the following inputs: equity value, book value, cost of equity. The cost of equity is k, 8.76%. The calculation of residual income is therefore:

Net Income

$8.041 billion

Cost of Equity


Total Equity Outstanding

$56.788 billion

Total Equity Cost

$4.974 billion

Residual Income

$3.067 billion

The residual income is $3.067 billion. This is added to the book value of the company, which is $56.788 billion to get $59.855 billion. Divide by 5.315 billion shares outstanding to get a value of $11.26 per share. By this valuation method, Cisco is overvalued at its current level. While this methodology has its weaknesses, it is an interesting exercise to see that it gives quite a different number.

P/E Model

The price/earnings ratio is simple the ratio of the price of a share divided by the earnings per share (EPS). This ratio is commonly used to help value stocks and companies. The current P/E ratio for Cisco is 14.19. The historical value of EPS for Cisco is 17.3, which means that the stock is trading a little lower than it has been relative to earnings. The historic level is what will be used to make this calculation. For this, the EPS needs to be projected into the future. This requires understanding the EPS growth rate. A regression shows the EPS growth rate over the past five years is 0.042, so this is added to the current EPS of $1.50 to get an expected EPS next year of $1.542. With the historic P/E, the stock price should be:

1.542 * 17.3 = $26.67

This is fairly close to the current value of Cisco, but shows that perhaps Cisco is slightly undervalued with respect to P/E. The reason for this is that the P/E multiple has normally been higher in the past than it is today. Thus, perhaps the market is not optimistic about Cisco's growth as it used to be.

P/CF Model

The price to cash flow model equates the price of the stock to the operating cash flows. The current operating cash flow is $11.491 billion. The regression of the past five years, however, shows that operating cash flow has been shrinking. As a result, the expected operating cash flow for next year is actually $11.39 billion. The historic price/cash flow ratio for Cisco is 21.1. This gives us the following calculation for the expected price of Cisco:

21.1 * (11.39/5.34) = $45.

By this estimate, Cisco is quite undervalued. The current price seems a bit out of whack with historic price/cash flow ratios, even with the expected slump in cash flow. The market perhaps expects cash flow to be quite a bit lower next year than the model suggests.

P/S Model

The price to sales model is the final model. This model equates the price of the stock to the sales. The current level of sales is $47.88 billion. The regression line shows that next year's expected sales are $50.784 billion. The historic average of price/sales is 2.8. So the expected stock price based on this method is:

2.8* (50.784/5.34) = $26.62

By this model, Cisco is slightly undervalued. It is interesting that this model gives virtually the same price as the P/E model, which suggests a close correlation between sales and earnings, since the figures move in a similar manner.


The following table shows the outcomes of the five different methodologies:

Table 3 Outcomes




Cite This Term Paper:

"Stock Valuation" (2013, July 27) Retrieved December 5, 2016, from

"Stock Valuation" 27 July 2013. Web.5 December. 2016. <>

"Stock Valuation", 27 July 2013, Accessed.5 December. 2016,

Other Documents Pertaining To This Topic

  • Stock Valuation

    Stock Valuation Scholastic Corporate (NASDAQ: SCHL) is an educational publishing firm based in the United States. In order to make an investment recommendation on this stock, a number of different techniques can be used to analyze its financial performance. These include ratio analysis, for which three ratios will be chosen, and trend analysis for the past three years. The stock is currently trading at $26.41, its lowest level since August of

  • Stock Valuation the Stock That I Chose

    Stock Valuation The stock that I chose is PepsiCo. I was drinking a Pepsi when I was thinking about a stock to do, and it just seemed like a good idea. That is why I picked the stock, but PepsiCo (PEP on the NYSE) is a major blue chip stock so there is no reason why I shouldn't pick it. The current stock price of PepsiCo is $85.31 PepsiCo is in the

  • Stock Valuation the Stock That I Have

    Stock Valuation The stock that I have chosen is Clorox (CLX), the bleach making company. I wanted to find a company that was about as classic a case of a no growth company as possible. Most of the high profile companies in the stock exchange are fast-growing companies, to the point where even those who have a flat domestic share are trying to grow internationally. I wanted to see if there

  • Stock Valuation Going Public Has

    Firms, even in the same industry, can only be evaluated on the basis of their ratios when their business characteristics are relatively similar. This includes products, markets, responses to economic stimulus, cost of capital and a variety of other attributes. The further Citrus Glow is from its competitors on any key measure the less useful Dan's method becomes. Furthermore, Dan's assumptions regarding the firm's growth prospects are arbitrary, rather

  • Walk Down Wall Street Stock Valuation From

    Walk Down Wall Street Stock Valuation from the Sixties through the Nineties Malkiel notes that there were a number of speculative trends from the 1960s to 1990s, and that they all mended up in the same way. Every few years, the stock market has another bubble or speculative mania which soon crashes and levels off, such as overvalued food stocks in the 1980s or the Nifty Fifty blue chips in the 1970s,

  • Valuation Report Identification of Subject Property the

    Valuation Report Identification of Subject Property The subject site is an office property in Oakville, Ontario. It can be sold either in parts or as whole, and this report will consider the whole. The size of the whole building is 4016 square feet. The property is located on the service road adjacent to the Queen Elizabeth Way (QEW), a major highway in the region that links Toronto with the cities of Hamilton

  • Valuation of Airthread Connection Fundamental Objective of

    Valuation of AirThread Connection Fundamental objective of this report is to present valuation of AirThread Connection. "American Cable Communication (ACC) was one the largest cable operators in the United States"(Stafford & Heilprin 2011P 36). In December, 2007, ACC cable systems reached approximately 48.5 millions homes with approximately 24.1 millions video subscribers. The company also enjoyed patronage of 4.6 million landline telephone subscribers and 13.2 millions high speed internet subscribers. The company

Read Full Term Paper
Copyright 2016 . All Rights Reserved