FIN 2984 Lecture 8: Class 8
Document Summary
Get access
Related Documents
Related Questions
International Research Journal of Applied Finance ISSN 2229 â 6891
Vol. VI Issue â 8 August, 2015 Case Study Series
A Stock Valuation Case: An Application of the âMethod of Comparablesâ for Macyâs Shares
Halil D. Kaya* ,Julia S. Kwok
Abstract
The primary focus of this case is the application of the âMethod of Comparablesâ in the estimation of the value of a security. An investment decision will be made based on the comparison of the selling price and the estimated value. A security will be good for purchase if the estimated value is higher than the market price. This method utilizes basic financial ratios that are commonly provided by financial web sites. First, using Yahoo Finance website, the pricing, sales, book value of equity and shares outstanding data are collected for both the target firm and the competitor firms. Then, the pricing multiples (i.e. price earnings ratio, price to sales ratio and price to book ratio) of the competitors are calculated. After that, those multiples along with the target firmâs earnings, sales, book value and shares outstanding data are used to estimate target firmâs share value. The case also examines the impact of treating ânegativesâ in the data. Students will learn that replacing negative earnings with zeros tend to induce less bias in target firmâs value estimation than excluding the ânegativeâ data altogether.
Introduction
March 14, 2015 was a sunny day. Mary took advantage of the nice weather to have lunch at the Mall. On her way back to work, she walked by Susanâs investment office. Susan was Maryâs college roommate. They both liked shopping together to find new fashionable clothes. Looking at her watch, Mary realized she had half an hour to spend. She thought she would drop by and say hello to Susan.
The Performance of Macyâs
âHi, Susan, how are you?â How is your business?â said Mary. Susan was a recent finance graduate. Susan replied, âI am doing fine. Thank you. After so many years, the market is still recovering from the mortgage crisis; many investors have been buying back stocks that they have sold during the crisis. What are you up to?â âI want to start my investment in securities, too. I have a couple thousand dollars, would Macyâs be a good stock to invest in now? That was our favorite store to shop among all of the department stores,â Mary exclaimed. She added, âAlso, I read from Motleyâs Foolâs article on Macyâs today about its earnings per share growth for the last 16 quartersâ (Zahid Waheed, 2014).
In response to Maryâs questions, Susan checked the monthly adjusted returns of Macyâs in Yahoo Finance. She found that, since March 2010, Macyâs stock price had an average annual increase of 23.5% over the last 5 years. The stock rose from $19.98 to $57.38. Susan then told Mary that Macyâs was indeed a growing stock. She added that its success could be attributed to the omni-channel integration, e-commerce and magic selling strategies which allowed merging of sales channels, online shopping and better customer care. Since investment strategy 101 is to buy low, and sell high, given Macyâs stock price had been going up, Susan was not sure whether Macyâs was currently overvalued or undervalued by the market.
The Method of Comparables
Susan remembered her class lecture on the two types of valuation of stocks, namely absolute and relative evaluation. The absolute evaluation focuses on finding the intrinsic value of the security based on fundamentals. That involves more complicated models of discounting cash flows from dividends, operations and residual income.
On the other hand, relative evaluation is quick and easy to use. It assumes two similar securities should sell for one price in an efficient market, i.e. âLaw of One Price.â So an analyst can estimate its stock price by multiplying target companyâs specific earnings, sales and equity value data by the earning, sales and equity âper shareâ financial multiples of its competitors.
Since Mary was not familiarized with financial models, Susan decided to use the easy-toperform-and-analyze âComparables Methodâ to estimate the relative value of Macyâs stock.
The Financial Data
Dillards, JC Penney and Nordstrom were selected as competitors of Macyâs as they were all in retail department store business. Susan would need some financial data regarding these companies. She went to SECâs (i.e. Securities and Exchange Commission) website and downloaded these companiesâ most recent balance sheet and income statement data. Out of those statements, she knew that she would need the EPS (i.e. earnings per share), the sales number, the number of outstanding shares, and the book value of equity. She also knew that she would need the current share price for each company. After some work, she had found all the necessary information to run the analysis. Below were the data that she had gathered:
All data are in US$ except for the number of outstanding shares. The share price as of March 15, 2014 is shown in the first column. The âEarnings per shareâ is shown in the second column. The third column reports the book value of equity. The last column shows the number of outstanding shares.
Firm | P ($) | EPS ($) | Sales ($) | BV of equity ($) | # of shares |
Macy's | 58.58 | 3.93 | 27,931 mil. | 6,249 mil. | 378.3 mil. |
Dillard's | 90.61 | 7.10 | 6,532 mil. | 1,992 mil. | 45.6 mil. |
JC Penney | 8.71 | -5.57 | 11,859 mil. | 3,087 mil. | 249.3 mil. |
Nordstrom | 61.33 | 3.77 | 12,166 mil. | 2,080 mil. | 194.5 mil. |
The Decision
Susan thinks that the following steps would be necessary to perform the analysis:
1.Based on the data above, calculate Sales per share, BV of equity/share values of all firms. Note that EPS is directly given.
2.Calculate P/E, P/Sales, and P/B for all of Macyâs competitors based on the data obtained.
3.Find the average of the P/E, P/Sales, and P/B multiples for the three competitors.
4.Multiply those averages calculated in step 3 with Macyâs EPS, Sales per share, and BV of equity/share values, respectively to get three value estimates for Macyâs shares.
5.The average of the three estimates would then be Susanâs best estimate of Macyâs value per share.
answer # 1-5 please
I need help find the Weighted Average Cost of Capital as well as the Weighted Average Flotation Costs
COST OF CAPITAL EXERCISE
The Stone Meat Corporation is a mediumâsized agricultural products company headquartered in Ogden, Utah. Its primary products are beef, pork and poultry and include packaged deli meats to half animals sold directly to in-store butcher markets in the retail grocery stores. They also supply their own butcher packs to various retail outlets including grocery stores, big box stores, and restaurants. In addition, they have their own factory store. The firm's products are well recognized within the markets in terms of quality and food safety.
During the 2000's and the early 2010's sales and earnings had grown rapidly. Sales in 2002 were approximately $60 million, but had reached $180 million by 2012. Per share earnings and dividends more than kept pace. The relevant figures are contained in Exhibit 1.
In order to support the firm's expansion, substantial expenditures on plant and equipment were required during the period indicated. The majority of funds came from retained earnings and the private placement of debentures with insurance companies. In 2004, however, the company was forced to sell additional common stock because it felt that the debt level, which would ensue from trying to borrow the money to keep up its expansion program, would be excessive. In particular, possible adverse effects in its stock price were feared since, at the time, the firm's ratio of debt to total capitalization was already somewhat above the industry average of 30 percent. The firm's balance sheet as of December 31, 2012 is shown in Exhibit 1.
Originally, the company's Board of Directors had established a policy of paying out half its annual earnings as dividends. The actual percentage varied from year to year because an attempt was made to stabilize the dividends despite fluctuating profit. By the late 2000's, this policy had been revised to set oneâthird of earnings as the target payâout ratio due to the continuing need for capital. At their last annual meeting, the Directors announced that the 2012 dividend would be 60 cents per share, payable quarterly in 15 cent installments. The company's stock is listed on the AMEX and trades actively. The range of yearly stock prices is included in Exhibit 1. The closing price on June 30, 2012 was $24.
Market data indicated that Stone was somewhat less risky than the market as a whole with a beta of .80. Returns on the market were averaging approximately 12% and risk free borrowing was still low following the financial meltdown of 2008. These rates averaged 3.5%. Preferred stock, which had been issued many years ago as a part of a financial deal, was selling at $90 per share. Tax rates had averaged 30% over the last few years.
Early in 2012, the treasurer of Stone was reviewing its investment and financing strategies with an eye toward improving both. The question as to an appropriate cutâoff ratio of return on new investments was of special concern. The treasurer was of the opinion that many capital expenditures had been made in the past without proper analysis. He wanted a figure he could justify to the firm's managers as a cost of capital in order to achieve a more accurate capital budgeting procedure throughout the organization. He felt this was an especially timely move in view of an article he had just read in the WSJ and which is reproduced in Exhibit Ill. Stone's own longârange planning group had earlier forecast a trend not unlike that indicated in the Journal.
The treasurer was well aware that financing did not come free and that the costs of issuance of preferred stock would cost 8%, bonds would cost 4% and equity 12%. He thought it important to determine how such costs would inflate the costs of any proposed projects the company might pursue in the futures. Thus he wanted to determine what the total cost of a $1,000,000 investment would be after considering any financing costs.
Year | Sales in MillionsOf Dollars | EPS | DPS | Stock Price Range |
2002 | 60 | 0.560 | 0.30 | 6-10 |
2003 | 63 | 0.500 | 0.30 | 5-9 |
2004 | 68 | 0.710 | 0.35 | 5-10 |
2005 | 85 | 0.880 | 0.40 | 8-12 |
2006 | 97 | 0.820 | 0.45 | 9-14 |
2007 | 119 | 0.940 | 0.45 | 12-20 |
2008 | 130 | 1.110 | 0.45 | 11-18 |
2009 | 145 | 1.350 | 0.45 | 15-24 |
2010 | 164 | 1.300 | 0.50 | 17-27 |
2011 | 173 | 1.600 | 0.50 | 20-30 |
2012 | 180 | 1.750 | 0.60 | 24-32 |
Exhibit II | |
Balance Sheet As of 12/31/2012 (figures in millions) | |
Cash | 20 |
Accounts Receivable | 10 |
Inventories | 30 |
Plant and Equipment, net | 60 |
Total Assets | 120 |
Accounts Payable | 20 |
Misc Accruals | 10 |
Preferred Stock (5%) | 10 |
Long term Debt | 24 |
Common Stock (2.5 million shares) | 12 |
Capital Surplus | 4 |
Retained Earnings | 40 |
Total Liabilities and Equity | 120 |
The firm's bonds carried a 6% coupon, (paid semi- | |
annually) a 12/31/2022 maturity and were selling for | |
$960 as of 6/30/2012. |
EXHIBIT III
Article taken form the February 7, 2012 issue of the Wall Street Journal.
Meat Processing Industry To Be Hurt by Increasing Prices?
Decimated Life stock Herds Also Contribute to Price Increases.
Kansas (AP) â The ConAgra Corporation, in a recent annual meeting announcement, forecast a trailing off of sales in its meat processing division. That division, which had been growing at a rate equivalent to three times the CPI growth rate throughout the 2000's and early 2010's, may be hit by decreases in household expenditures as the effects of the most recent financial crisis are still lingering for the decimated middle class. Retail outlets such as restaurants and grocery stores are reporting that sales of beef and pork products are declining in response to price pressures. Disease that swept through beef and pork herds, are also having a telling effect. Other sources close to the industry confirm the ConAgra prognosis. They estimate the best forecasts that their economists can come up with indicate a decline of about five percent in the growth rate which had been experienced in the last 12 to 15 years. ConAgra is curtailing several plant expansions in its meat processing division which were on the drawing board for the midâ2010's." We are moderately pessimistic," a company spokesman indicated, "and are going to adopt a wait and see attitude for the next year or so."
Hints
Create the Cost of Capital
Number of shares can be determined by taking the book value and dividing by the par value of the securities.
Market value is shares X price.
Average the two possible ways to calculate the cost of equity
Remember the tax rate.
Assume the bonds are semi - annual
The term to maturity is from 6/30/2012 to 12/31/2022 or 10.5 years. This info is in the footnote to Exhibit II
The growth rate should be determined from the EPS data and the adjustment to the growth rate is in Exhibit III
Create the Weighted Average Flotation Cost
What is the cost of equity using the dividend growth model? (Decimal answer to the fourth decimal place)
Given the $1,000,000 cost of the investment, what is the total cost of the investment including flotation costs? (Round to whole numbers)