FINANCE 522
DR. DENIS BOUDREAUX
FALL 2014
DUNHAM COSMETICS CASE
QUESTIONS
Calculate Dunham's 1995 financial ratios and prepare common size statements.
Do a comparative and trend analysis. Organize the analysis/ presentation by the four ratio groups.
Is the bank justified concerned? Justify your answer.
Nineteen ninety-four was a "down" year for Dunham. Do you think that GCB had a responsibility to express concern in 1994, especially since the current ratio was close to 1.85, the number that could trigger a call of the loan? Explain.
Suppose Dunham had followed Jensen's 1993 recommendation to lower its payout ratio. Recalculate the firm's debt and current ratios for 1995 assuming that the dividend payout ratio was 20 percent from
…show more content…
ACTIVITY: Dunham Cosmetics inventory appears to be decreasing each year. Its inventory management seems to have declined and drops below the industry average. The average collection period looks like it has crept up well above that of the industry. This means that Dunham is taking longer to collect payments than its competitors which means less cash for the firm. Dunham will have to improve this in order to have more cash in hand. The overall liquidity appears to be poor and the management of the receivables needs to be examined. The fixed asset turnover and the total asset turnover have been declining each year standing below the industry average. This means for every 1.00 of assets Dunham owns, Dunham makes 1.64 in sales. The industry average for this ratio is 2.1, which shows that Dunham is still behind.
PROFITABILITY: Dunham's profitability relative to sales in 1995 was worse than the average company in the industry, although it did not match the firm's 1993 and 1994 performance which was above the industry average. Although the gross profit margin was 32 for 1994 and 1995, it has dropped to 29.54 causing it to be below the industry average which is 30.5. The net profit margin is also decreasing each year. Dunham's net profit margin in 1993 was 4.4 and fell to 3.7 in 1994 but was still above the industry average. Then in 1995 it dropped tremendously to 1.41 falling way below the industry average. Furthermore, the return on
Prepare common-sized financial statements for Leslie Fay for the period 1987–1991. For that same period, compute for Leslie Fay the ratios shown in Exhibit 2. Given these data, which financial statement items do you believe should have been of particular interest to BDO Seidman during that firm’s 1991 audit of Leslie Fay? Explain.
The gross profit margin for CC is right around the industry average. Although the numbers seems to be decent, the costs of goods sold are too high. Next, looking at the operating profit margin, the numbers don’t look as great as they should. The numbers are low compared to the industry average in years 2001, 2004, and 2005. This may indicate that CC should look into their prices and costs. In 2001 the net profit margin was very low compared to the industry average. I am assuming this is due to the major expansion. It is also important to look more deeply into the numbers though because the net profit margin is lower compared to the industry average in all of the years. Once again CC should look into their costs and how efficient they are converting sales into actual profit.
- Merlo, Inc. maintains a debt-equity ratio of 0.25 and follows a residual dividend policy. The company has after-tax earnings of $3,800 for the year and needs $3,200 for new investments. What is the total amount Merlo will pay out in dividends this year?If debt = 0.25 and equity = 1, then debt + equity = 1.25. Equity portion of new investments = $3,200 × (1 / 1.25) = $2,560.00
Dividends were assumed to grow at the geometric average of the last 6 years, 20.28%. P0 = D2 Dn Pn D1 + + ··· + + 1 2 n (1 + Ke ) (1 + Ke ) (1 + Ke ) (1 + Ke )n $1.58 $2.28 $87.31 $1.31 + + ··· + + = 1 2 4 (1 + 7.0%) (1 + 7.0%) (1 + 7.0%) (1 + 7.0%)4 = $72.53
In the Table __ and Fig __, you can see how the company has been performing. The overall profitability of the company has increased. Profitability ratios have increased since 2010. In particular, Harvey Norman’s Gross Profit Margin saw a significant growth, it grew 44.7% since 2010. Operating Profit Margin saw a similar result, finishing with a ratio of 10.5 in Financial Year 2015. Harvey Norman’s Net Profit Margin (when positive), have been at best maximum and are further illustrative of the paper-thin margins typically associated with the retail sector. Investments of Return on Assets (ROA) and Return on Equity (ROE) were also substantial, comparing 2010 and 2015 there was a relative decrease in ROA and ROE which doesn’t make much of a difference if the Gross Profit Margin has a strong game. Thus, on the basis of the financial results over the last 6 years, shareholders would definitely be confident about investing in Harvey Norman, unless there is a decline in current asset and equity returns.
So while the company increased its net income, it has done so with diminishing profit margins.
• Pe = D1/(re – g) = 700 / (0.11 – 0.05) = $11,667 • price per share = $11,667 / 1,000 = $11.67 3. Same facts as (2) above, except the 5% income growth rate (and beginning of year common equity to support it) are only expected for years 2 and 3. Then growth is expected to be zero and all income is expected to be distributed to shareholders for all future years. a. Compute D1, D2, D3, and Dt for all future years. • Keeping in mind that income is $1,100 in year 1, increases by 5% in years 2 and 3, and then remains constant for all future years; and keeping in mind that beginning of year 1 common equity is $8,000, increases by 5% at the beginning of year 2 and at the beginning of year 3, but does not increase at the beginning of year 4 and remains constant from that point forward, you should be able to compute: D1 = $700, D2 = $735, and Dt = 1,212.75 for D3 and all future years. b. Use the dividend discount (i.e., free cash flow to equity investors) valuation model to estimate the company’s current stock price. Pe = 700/(1+ 0.11) + 735/(1+ 0.11)2 + [1,212.75/0.11]/(1+ 0.11)2 = $10,175.31 and the price per share of common stock = $10,175.31 / 1,000 = $10.18. 4. Same facts as (3) above, except the growth rates are 5% for years 2 and 3 and then 3% perpetually for all future years. a. Compute D1, D2, D3 and the growth in D for all future years. • Keeping in mind that income is $1,100 in year 1, increases by 5% in years 2
Ratio analysis: Perform trend and ratio analysis on current and fixed assets, current and long term liabilities, owner’s equity, sales revenues, EBIT, net income, and earnings per share. Project these trends
Profitability ratios decreasing from 2005 to 2006 although the sales has increased substantially and the net income as well but not in the same percentage of increase due to the high reliance on debt as the interest expense increased as mentioned before.
The company’s debt ratios are 54.5% in 1988, 58.69% in 1989, 62.7% in 1990, and 67.37% in 1991. What this means is that the company is increasing its financial risk by taking on more leverage. The company has been taking an extensive amount of purchasing over the past couple of years, which could be the reason as to why net income has not grown much beyond several thousands of dollars. One could argue that the company is trying to expand its inventory to help accumulate future sales. But another problem is that the company’s
The purpose of the report is to measure the performance, financial position and liquidity of the general retailer, Debenhams plc. Its operation would be compared to that of the prior year as well as that of a rival company in the same industry.
The following analysis is written for Dakota Office Products to evaluate current business operations and recommend future actions necessary to ensure company success. In our analysis of the company we will identify inefficient business practices that have led to the companies first profit loss in its history. We will evaluate the company’s current pricing structure, ordering methods, shipping and delivery process, and deficiencies in cash flows.
Operating profit margin figures in the table above show the return from net sales[13]. However profit margin ratios are high enough for the 3 years, there is a fall from 12.86% to 11.26% during 2011-12. Sales revenue increases with a higher rate than gross profit so there is a poor
The company’s creams inventory remains constant because it does not follow a trend in innovation and changes so often as the other products. The surplus in inventory is a big disadvantage since; last year’s products may not be in style this year in addition to the cost of storage. For all these reasons their cash flow is less in comparison with previous years causing that Luxor Cosmetics keeps increasing their bank loans, creating more debt, making it harder to pay out as 2011. In this particular situation the company could have either decrease its budgeted sales (productions) or increase its actual sales by improving more effective marketing strategy and research and development of its products in the markets. This way their inventory would decrease and their cash flow would increase. (Hopkins, 2009)
In 2009, the operating profit was 3.56% which was slightly above than the previous year. After deducting all the expenses, the left amount is the net profit and the proportion of net profit in respect to total revenue is the net profit margin. Sainsbury’s net profit margin for the years 2009, 2008 and 2007 were 1.53%, 1.84% and 1.89% respectively. The management thinks that the tough market condition and the other competitors with very cheap pricing have pushed them to squeeze their profit margin ratio. The graph below shows the Return on Capital Employed as well. The ROCE gives the idea about how much return a company is making on its used capital. (investorwords.com) The ROCE for the company was 9.46%, 7.10% and 7.59% for the years 2009, 2008 and 2007 respectively. The year 2009 proved to be a little bit more in context of return on capital employed.