Myer Holdings Limited (Myer)

Prospective compend visualize The precedent reports break already approached the industry and fiscal analysis of Myer. This report testament psychoanalyze the forecast, valuation and application of Myer, including forecasting the major data, valuating per centum determine at a lower place four model and discussing the opportunity and challenge of Myer. 1. Forecast sales harvest-home ordain As bingle of the most important indicators, sales butt mull over directly Myers financial performance and becharm another(prenominal) indicators. Therefore, the forecast of sales development station is the foundation for forecasting Myer.Based on the previous annual reports from 2007 to 2011, Myers sales ar not sanguine and the average growth rate is negative 2. 89%. The decline of two globose economy and purchase power of con mettleers in Australia will idle words to the effect of whole industry and unsatisfied performance of Myer in 2012. Additionally, growth of 20% onlin e obtain shows that to a greater extent and to a greater extent than consumers elect to purchase online instead of in the shops . Therefore, negative 1% of sales growth rate for Myer bottom be assumed in 2012. However, Australia would have a weakening global economy impact and have strong national growth in the proximo .According to IMF, Australian economy growth rate is expected up to 3. 5% in 2013 . Considering the previous performance of Myer, 2% of growth rate locoweed be assumed for 2013. After that, 3% of growth rate whoremonger be assumed from 2014 to 2017 and the sales would approximately even to 2007. (See on a lower floor chart) Previous years 00020072008200920102011Average rate Sales3,002,3532,940,3312,798,9162,825,0342,666,803? sales growth? -2. 07%-4. 81%0. 93%-5. 60%-2. 89% Future years ?2011201220132014201520162017 Sales growth? -1%2%3%3%3%3% 2. Forecast ATO &038 work NOAAccording to the bygone tailfin years data, Myers Assets Turnover ratio (ATO) declined reluctantly hobby the decrease of sales, apart from 2011 down quickly. Therefore, the average rate 2. 05 screw be used to predict the early years. (See down the stairs chart) ? 20072008200920102011Average rate ATO2. 02 2. 282. 152. 001. 772. 05 3. Forecast PM &038 calculate NOPAT Profit Margin (PM) is another important indicator in forecasting Myers performance. This indicator relates between the sales and cost of goods sell and operating costs. The competition in retail industry is stronger than before.That means finished increasing sales or decrease COS to growing PM is more(prenominal) than difficult. The change of PM fluctuated markedly in the last five years. In order to fairly predict the data, the average of 7. 5% can be used as the future PM growth rate. (See below chart) ? 20072008200920102011Average rate profit margin4. 7%13. 4%4. 9%7. 8%6. 6%7. 5% 4. Forecast net dividend recompenseout Dividend payout is a momentous indicator to influence carry on price. There fore, estimating this rate means the people can determine Myer whether focuses on benefiting make outholders and beautifies handle price or not.According to the past 5 years, only 3 years Myer paid dividends. After calculation, the average rate based on 3 years is 45% and 5 years is 27%. However, 27% is too low for sh atomic number 18holders if Myer earn more profit base on the forecast. In addition, most of dividends payout is higher than 50%. Therefore, the forecasting dividend payout rate is estimated by 45%. (See below chart) ? 20072008200920102011Average rate(3yrs)Average rate(5yrs) Dividend0%50%0%28%59%45%27% 5. Forecast cost of debt and debt balance Basically, cost of debt means the set down of liabilities.Determining the cost of debt is as well as setting up the financial structure such as how much debt Myer plan to borrow. According to the previous data, Myer repaid a huge amount of debt in 2010 and led to the cost up and net debt down. However, the debt did not rise up again and kept the mistakable level as 2010. Therefore, concerning well-nigh the cost of debt, the average of 10. 75% seems more reasonable to predict the future. (See below chart) ? 20072008200920102011Average rate % cost of debt6. 25%6. 41%6. 36%30. 31%4. 41%10. 75% net debt (ND)928,503 856,242 904,258 414,574 457,362 ?Prospective rating Four methods are used to valuate Myer, DDM, DAE, DAOE and DCF. In addition, two ways are used to determine cost of capital, which are CAPM and WACC. In CAPM model, bumpless rate, risk premium rate and ? are assumed separately 4. 5%, 6. 5% and 1. 1. It is not easy to determine ? because it changes e actually day. Assuming 1. 1 for? means the fluctuation of Myer share price is a little stronger than the commercialize but not too much . Therefore, cost of capital (Re) is calculated by the formula and equals to 11. 65%. This Re is used in DDM and DAE. In WACC model, because Re is 11. 5%, Rf is calculated by formula and equals to 11. 43%. This Rf is used in DAOE and DCF. The share price is calculated by these 4 different models. (See below chart) ModelForecast Share price in 2012 DDM1. 7423 DAE2. 4548 DAOE2. 5603 DCF2. 5603 DDM is influenced powerfully by dividends because this model uses dividends to calculate value of shares. If the company does not pay dividends, the share price would be lower. Myer is estimated to pay dividends in 45% and the share price closes to market share price. (See below chart) DateLast % Change High impression Vol * 24 Oct 20121. 950-1. 27% 1. 621. 9306,259,477 This model is easy to understand Myers cable conditions. However, this is affected by dividends too much and dividends are not constantly linking the value creation , the valuation model seems very limited. Obviously, this cannot reflect the Myers actual value and conditions. Additionally, compared to DDM, DAE involves in other indicator abnormal fee to value Myer share price and is better to present Myers conditions. Myer share p rice in DAE is higher than DDM because it reflects book value of equity and PV of future abnormal earnings to add share value.Therefore, this is more close to the real performance of Myer. Also, DAOE model is similar with DAE apart from that DAOE focuses on the equity which is resolute by operating abnormal earnings. This eliminates the influence of Myers financial activities to calculate abnormal earnings. However, Myers financial value has been added to the equity finally. Therefore, this can reflect Myers condition in operating. Finally, DCF model focuses on cash full stop which results in the equity increases. Usually, it can get the same share price with DAOE, but does not affected by accounting rules.However, investments are case-hardened as losses for cash flow, which can bring more future benefits to Myer. Therefore, if Myer plans to use investments to produce free cash flow, then this model is very close Myers real conditions. Prospective Sensitivity On one side, Myer i s department store and compete in retail industry. Seasonality is more significant aspect in retail industry. The boom seasons for Myer are the end of financial year and Christmas holidays. Also, the weather, new products in season or other factors are the aspects which Myer is sensitive.On the other side, according to Appendix 4, the four models of sensitivity can be analyzed. For the indicators of sales, ATO, dividend payout, DDM is the most sensitive, while DCF and DAOE are not sensitive. However, DDM is not sensitive in debt, while DCF and DAOE are most sensitive. Application Opportunities According to the forecast analysis and valuation, Myer has some possible opportunities to improve herself and get rid of the difficult conditions although the depression of condition expands the whole retail industry. Myer is predicted to pay more dividends to their shareholders in forecast analysis.This will addict more investor to buy shares and this can push the share price to rise up. Also , the book value of equity for Myer can be increased and this leads to no one can buy Myers share lower than book value. Therefore, a higher merger value or acquisition value can be created. Eventually, Myer will get more capital to investment. Therefore, Myer has an opportunity to invest this implemental capital. Concerning about the future economy, Australia will have strong internal economy increase . As a result, Australian consumption and requirement will be up.Therefore, keeping and maintaining domestic consumers are still the main tasks for Myer. With the online shopping eroded the traditional shopping stores, Myer should improve their online shopping services, such as beautifying and making it convenient for customers. Myers CEO announced they would launch a new omni-channel service to piss consumers shop online . Obviously, Myer has already recognized online shopping is the main method to reclaim market share. Additionally, expanding the overseas market seems a good lamb for Myer to increase profit.Recently, Australia government has signed two Free Trade Agreement negotiations with chinaware and japan separately. This provides a firm foundation to encourage more outside investments between Australia and both of countries . Therefore, Myer can be provided more supports to invest in China and Japan. There are three reasons for Myer to choose China rather than Japan to set up the first overseas runner. runnerly, 1. 34 one thousand million of China population is more stable for consumption foundation than 127million of Japan . Secondly, the advantage of exchange can provide more benefits for Myer to invest in overseas.Thirdly, more products of Myer are produced by China therefore, setting up branch in china can save the delivery cost and tax. Challenges Although Myers forecasting is more profitable, it still has a potential challenge for borrowings. First of all, the purpose of loan for Myer may be to expand its shops or update its online shoppin g. These have more chances to be long-term debts instead of short-term debts. However, when they are in the lack of cash flows, Myer may pay dividends through borrowings. Although this can be short-term debts, it is not for earning profit.Therefore, both of these are speculative for debtors. Secondly, the anatomy shows that Myer would not plan to increase its financial expenses. That may be Myer prefer to get more funds from shareholders and her own operates rather than debts. This looks lower risky than peoples anticipation while it also means Myer would slow the repayment of debt and the previous debt risky will be raised up. Thirdly, the besotted growth rate of dividend payout shows Myer would pay more dividends to benefit their shareholders when they earn more money instead of pay the debt or reinvest.In other words, Myer prefer has more long-term debt than short-term debt and maybe the benefits will be impaired. Therefore, the debts risk of Myer tends to be increased by Myer s trend. Fourthly, the debt supplement looks healthy. However, the decrease of debt leverage is because not only the debt decreases, but also the net operating assets increase. supra all, Myer probably has problem when debt from debtors. Therefore, a detailed loan structure should be planned to make debtor have more confidence and will to borrow money to Myer.This loan structure need to concern about the percentage of debt and equity for Myer. Also, the percentage of long-term debt and short-term debt should be considered. In addition, the purposes of debt need to be clear, easy to understand and report to debtors and shareholders. Conclusion To sum up, these analyses are really useful to approach Myers conditions and performance, and also can give some particular information through valuation. However, there are not perfect analyses people still need to look for more effective analyses to value the firm.