MGAB02H3 Study Guide - Final Guide: Retained Earnings, Accounts Payable, Share Capital
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
Dont need whole case just answer to the question "Determine how the expected decrease in sales volatility next year will affect the companyâs business risk." that is all i need
Could you answer question 1
1. Determine how the expected decrease in sales volatility next year will affect the companyâs business risk.
Part 1:
GOODWEEK TIRES, INC.:
After extensive research and development, Goodweek Tires, Inc., has recently developed a new tire, the SuperTread, and must decide whether to make the investment necessary to produce and market it. The tire would be ideal for drivers doing a large amount of wet weather and off-road driving in addition to normal freeway usage. The research and development costs so far have totaled about $10 million. The SuperTread would be put on the market beginning this year, and Goodweek expects it to stay on the market for a total of four years. Test marketing costing $5 million has shown that there is a significant market for a SuperTread-type tire.
As a financial analyst at Goodweek Tires, you have been asked by your CFO, Adam Smith, to evaluate the SuperTread project and provide a recommendation on whether to go ahead with the investment. Except for the initial investment that will occur immediately, assume all cash flows will occur at year-end.
Goodweek must initially invest $160 million in production equipment to make the SuperTread. This equipment can be sold for $65 million at the end of four years. Goodweek intends to sell the SuperTread to two distinct markets:
The original equipment manufacturer (OEM) market: The OEM market consists primarily of the large automobile companies (like General Motors) that buy tires for new cars. In the OEM market, the SuperTread is expected to sell for $41 per tire. The variable cost to produce each tire is $29.
The replacement market: The replacement market consists of all tires purchased after the automobile has left the factory. This market allows higher margins; Goodweek expects to sell the SuperTread for $62 per tire there. Variable costs are the same as in the OEM market.
Goodweek Tires intends to raise prices at 1 percent above the inflation rate; variable costs will also increase at 1 percent above the inflation rate. In addition, the SuperTread project will incur $43 million in marketing and general administration costs the first year.
This cost is expected to increase at the inflation rate in the subsequent years. Goodweek's corporate tax rate is 40 percent. Annual inflation is expected to remain constant at 3.25 percent. The company uses a 13.4 percent discount rate to evaluate new product decisions. Automotive industry analysts expect automobile manufacturers to produce 6.2 million new cars this year and production to grow at 2.5 percent per year thereafter. Each new car needs four tires (the spare tires are undersized and are in a different category). Goodweek Tires expects the SuperTread to capture 11 percent of the OEM market.
Industry analysts estimate that the replacement tire market size will be 32 million tires this year and that it will grow at 2 percent annually. Goodweek expects the SuperTread to capture an 8 percent market share.
The appropriate depreciation schedule for the equipment is the seven-year MACRS depreciation schedule. The immediate initial working capital requirement is $9 million. Thereafter, the net working capital requirements will be 15 percent of sales. What are the NPV, payback period, discounted payback period, IRR, and PT on this project?
Part 2:
CASE DESCRIPTION:
Business risk and financial risk are among the most important concepts in corporate finance. The total risk of a corporation is the sum of its business risk and financial risk. Business risk is the risk of the corporation before the financing decision. It is the uncertainty inherent in the corporationâs future operating income. An important cause of business risk is sales volatility. Financial risk is the added risk caused by debt financing. Using financial leverage increases the total risk of the firm by increasing the volatility of a corporationâs net income and return on equity. The case provides an opportunity for students to understand the determinants of business risk, financial risk, and market value in a real-world setting. Kappa Television (KT) is a television retailer in California with a high sales volatility and business risk due to competition. The company is considering the effect of increasing financial leverage on its return on equity and common stock value.
CASE INFORMATION
Kappa Television (KT) Inc., is a midsize retailer of television sets in California with several stores in Los Angeles, San Francisco, and San Diego. Johnson is the founder and CEO of the company who has an electrical engineering degree from Princeton University. He always wanted to run a company. Soon after he received his degree from Princeton, he opened the first KT store in Los Angeles with some seed money from his parents and friends in 1990. The business was booming because there was an increasing demand for high definition television sets in the United States. Many people were getting rid of their old television sets and replacing them with new technology LCD or plasma television sets.
The company enjoyed a high growth rate during its first few years. Ian Johnson took the company public with a successful initial public offering in 1995. The company paid no dividends and reinvested all of its earnings during the high growth years in the 1990s. The investors were happy with the capital gain the companyâs stock was providing and they did not mind not receiving any dividends from the company. However, when the growth rate began to slow down at the turn of the century, the company had to start paying out some dividends with the pressure from the shareholders. The company has had no net growth during the last couple of years because many people have already replaced their old television sets with a new technology set. This has forced the company to start distributing all of its net income as dividends to shareholders. The business continues to be profitable, however, and the shareholders are happy to receive a substantial amount of dividend from the company every year.
Generous dividend payments have helped the market price of the companyâs stock to remain at a reasonably high level. However, an important problem causing volatility in KTâs sales and stock price has been television set imports with unknown brand names from phantom television set manufacturers in the Far East. These manufacturers would flood the market with cheap and low quality television sets from time to time causing KTâs sales and revenues to drop. Although many customers would prefer to buy quality television sets with well-known brand names, some people could not resist the low prices of the low quality television sets with unknown brand names. These phantom television set manufacturers would often stop their operations abruptly and they would disappear from the market for several years. In those years, KT would enjoy high levels of sales with good revenues.
Sales Volatility and Business Risk
Ian Johnson realized the volatility of KTâs sales was adversely affecting the companyâs business risk and stock price. Therefore, he decided the company should conduct a study to determine the effects. At the beginning of the year, KT hired Nancy Smart, who is a recent graduate of the Wharton MBA Program, as the head of the companyâs newly established Financial Analysis Department. Ian is familiar with the Wharton MBA Programâs course offerings. He had considered getting an MBA degree from the Wharton School himself when he graduated from Princeton before finally deciding to go into the television sales business in Los Angeles. Whartonâs MBA Program emphasizes case problems and Ian Johnson knew that sales volatility and business risk related problems are extensively studied in the MBA finance classes. Therefore, he was quite sure that Nancy Smart could do a good job for them in analyzing the impact of KTâs sales volatility on the companyâs business risk. The following conversation took place between Ian Johnson and Jamie Smart when they were discussing the issue:
Johnson: We have considerable volatility in our sales. Is there any effect of sales volatility on a companyâs business risk?
Smart: Business risk is defined as the volatility of a companyâs operating income (earnings before interest and taxes). Sales volatility is a major cause of business risk. A high business risk level can have a significant adverse effect on a companyâs market value. If we can reduce KTâs sales volatility, we can lower our business risk and improve our market value.
Johnson: The main cause of the volatility in our sales is the low price and low quality unknown brand name television set imports from phantom manufacturers in the Far East. These imports are mainly affecting the West Coast retailers. Our marketing department suggests that we could reduce the volatility in our sales significantly by having geographical diversification within the United States by opening new stores in several other states.
Smart: If we can reduce the volatility in our sales, it would lower our business risk and improve KTâs market value. With less competition from the phantom Far East manufacturers, our expected revenues are also likely to be positively affected. It would also have a favorable effect on KTâs market value.
Johnson: Our marketing department is expecting a large decrease in the volatility of our sales if we have geographical diversification next year. We are also expecting some improvement in our expected sales and revenue figures with less competition from the Far East phantom manufacturers. I will email you the probability distributions of our estimated sales for the current year and for next year. Please prepare a report analyzing the relationship between our sales volatility and business risk.
Smart: I can prepare the report within a week after I receive the statistics from you.
With the statistical data in Table 1, Nancy Smart prepared a report analyzing the impact of KTâs sales volatility on the companyâs business risk.
Table 1: Probability Distribution of Sales
| Variable Costs: | 50% of Sales | |
| Fixed Costs: | $9,000,000 | |
| Marginal Tax Rate: | 35% | |
| Probability Distribution of Current Yearâs Sales | ||
| Prob. | Sales | |
| Low | 0.2 | $20,000,000 |
| Below Average | 0.2 | 25,000,000 |
| Average | 0.2 | 30,000,000 |
| Above Average | 0.2 | 35,000,000 |
| High | 0.2 | 40,000,000 |
| Probability Distribution of Forecasted sales for Next Year | ||
| Prob. | Sales | |
| Low | 0.3 | $28,000,000 |
| Average | 0.4 | 33,000,000 |
| High | 0.3 | 38,000,000 |
This table provides the expected probability distribution of KTâs sales for the current year and next year. These statistics can be used to evaluate the effect of reducing sales volatility on the firmâs business risk.
Financial Leverage and Financial Risk
Ian Johnson was very pleased when he received Nancy Smartâs report analyzing the impact of KTâs sales volatility on the companyâs business risk. He thought that he had made a good decision by appointing Nancy Smart as the head of the companyâs newly established Financial Analysis Department.
Another issue that was bothering Ian Johnson was that KT was using only equity financing with no long-term debt. He knew that some competitors were using as much as 30 percent debt financing. The issue did not matter too much when the company was experiencing a high growth rate in the 1990s and the stockholders were enjoying large capital gains. However, because of the sluggish growth rates in recent years, it would be a good idea to boost the return on stockholdersâ equity by using financial leverage. Ian Johnson decided to discuss this issue with Nancy Smart.
Johnson: Do you think it would be a good idea for KT to use some financial leverage to boost its return on equity?
Smart: Definitely. The optimal debt ratio in our line of business is about 30 percent. Therefore, using up to 30 percent financial leverage would increase KTâs return on equity and improve our stock price. Because of the Fedâs easy money policy, interest rates are low currently. It would be a good idea for KT to have some debt financing in its capital structure.
Johnson: We already have a high business risk because of our sales volatility. Do you think the companyâs total risk would be too high if we use financial leverage?
Smart: True. It is recommended that business lines with an inherently high business risk should not use too much financial leverage. According to Dunn & Bradstreet statistics, most firms in our line of business have about 30 percent financial leverage. Therefore, it should be OK for KT to use up to 30 percent financial leverage. In some other lines of business with lower business risk, the debt ratio can be as high as 50 or 60 percent.
Johnson: What precisely is the effect of using debt financing on a companyâs total risk?
Smart: A companyâs total risk is measured by the volatility of its ROE (return on equity). For a firm that does not use any debt financing, the volatility of its operating income (EBIT) would be the same as the volatility of its ROE. Such a companyâs total risk would consist only of business risk. It is KTâs current position now. When a company starts using debt financing, the volatility of its ROE increases. The additional volatility in ROE caused by using financial leverage is called financial risk. The higher the debt ratio, the higher the financial risk. If the debt ratio is above the optimal level, it can adversely affect a companyâs market value.
Johnson: What is the effect of using debt financing on the shareholdersâ risk?
Smart: An increase in financial risk to the shareholders could be measured by the increase in the systematic risk. Currently, the beta of KT is 1.0, which is the unlevered beta since we have no debt. By increasing the leverage, we expect the beta to increase to 1.26.
Johnson: What about the change in the firm value if we issue new debt?
Smart: We expect the KT value to remain at $20 million after increasing the leverage from 0% debt to 30% debt.
Johnson: I would like to receive a report analyzing the possible effect of using 30% financial leverage on KTâs ROE and total risk. Investment bankers suggest that we should be able to sell long-term bonds with an interest rate of 8 percent. I would like to explain the advantages of our company using 30% financial leverage to our stockholders in the stockholders meeting two weeks from now. Would you be able to prepare the report within a week?
Smart: No problem! I should be able to prepare the report within a week. Ian Johnson was very pleased when he received the report, which clearly showed the effects of KT using 30% financial leverage on the stockholdersâ return on equity and on the companyâs total risk.
