Chapter 4, Problem 7TCL

Conducting a Financial Ratio Analysis on HP INC.

Use online resources to work on this chapter's questions. Please note that website information changes over time, and these changes may limit your ability to answer some of these questions.

In Chapter 3, we looked at Dunkin' Brands' financial statements. In this chapter, we will use financial Internet websites (specifically, www.morningstar.com and wnvcv.google.com/finance) to analyze HP Inc., a computer hardware company. Once on either website, you simply enter HP Inc.'s ticker symbol (HPQ) to obtain the financial information needed.

The text mentions that financial statement analysis has two major components: a trend analysis, where we evaluate changes in key ratios over time, and a peer analysis, where we compare financial ratios with firms that are in the same industry and/or line of business. We will do both of these types of analysis in this problem.

Through the Morningstar website, you can find the firm's financials (Income Statement, Balance Sheet, and Cash Flow) on an annual or quarterly basis for the five most recent time periods. In addition, the site contains Key Ratios (Profitability, Growth, Cash Flow, Financial Health, and Efficiency) for 10 years. We will use the Key Ratios on this site to conduct the firm's trend analysis. (At the bottom of the screen you will see that you can click "Glossary” to find definitions for the different ratios For example, Morningstar's Financial Leverage ratio is the same as the Equity multiplier that we use in the textbook.)

On the Google Finance site, you can find the firm’s financial statements for the four most recent years or the five most recent quarters and key financial data for related companies for the most recent year or quarter. We will use the related companies' annual data to conduct the firm’s peer analysis. Notice that when you go to the "Related Companies" screen, you can “add or remove columns.” Click on that phrase, and you can check which peer data items you'd like to show on tire computer screen. Also, once you have chosen the data, you can click on a term, and the companies will be ranked in either ascending or descending order for the specific term selected.

7. From the Google Finance site, use the DuPont analysis to determine the total assets turnover ratio for each of tire peer companies. (Hint ROA = Profit margin × Total assets turnover.) Once you've calculated each peer 's total assets turnover ratio, then you can use the DuPont analysis to calculate each peer's equity multiplier.