Student Name: Date: Q1 Use the information below for .C. Penney and Intel to answer the following questions 1.C Penney Corp (CP) $ 17,759 Intel (INTO $ FYE 2010 ($ in millions) Sales revenue Expense Net income ROS 32.159 11.464 5 389 $ a. Calculate the values for (A) and (x9. Revenue for INTC is more than 2 times / 10 times) greater than revenue for whereas net Income for INTC approximately (2 times / 10 times 30 times greater than net inco for SCP b. Examine the relationship between Sales Revenue and Net Income. 1. (CP/INTC) corporation is generating the most net income from each dollar of revenue. 2. This relationship is measured by the (ROS/Asset Turnover / ROA) ratio 3. Calculate ROS and record in the space provided above. 4. ROS of UCP / INTC) is clearly much higher, revealing that ICP / INTC) has a greater ability to translate revenue Into profits; keep expenses under control. But does the higher ROSmean that one company is better than the other company? [Yes/Nol, because these companies are from different industries, and RoS averages are the same / differ) among Industries Let's examine three companies within the Personal Computer Systems Industry. Use the chart below to answer the following questions. Stock symbols are shown in parentheses Q2 Personal Computer Systems Industry FE 2011 Return on Sales (ROS) Asset Turnover (Asset TO) Return on Assets (ROA) Gross Profit Margin (GP) industry Average 12.196 1.00 24.2% 37.3% Apple Computer (AAPL) 29.5496 0.87 25.75% 39.30% DELL (DELL) 5.6744 1.60 9.07 1884 Hewlett Packard (HPC) 7614 1.03 78496 2234 a.For AAPL profits were cents of each revenue dollar, while cents of each revenue dollar were used to pay for the costs of running the business b. One measure of sales volume is the (ROS/Asset Turnover / ROA) ratio c. Companies invest in assets to generate additional revenue to increase net income. AAPL earned cent() in profit from each dollar invested in assets. is a company with a greater ROA ratio using assets more efficiently to generate profits than a company with a lower ROA ratio? (Yes/No / Can't tell because ROA is is not comparable among Industries. Student Name: Date: d. It was shown in Activity & that Wal-Mart makes profits by generating a large volume of sales on items with low profitability. ROS for Wal-Mart is relatively low/high), whereas Asset Turnover is relatively low /high/can't tell). ROS X Asset T/O - (ROA/GPX/debt ratio), which is considered the (least/most) comprehensive measure of profitability e. During 2010, it cost AAPL cents of each revenue dollar to produce Mac computers, iPod, iPhones, iPads, ITunes, and other related products and services leavingcents of each revenue dollar to cover all remaining operating expenses, nonoperating expenses, and profits. The Gross Profit Margin (GPx) is the first second / last) indication of profitability shown on the income statement. The Information for both the numerator and denominator of the GP% ratio come from the balance sheet /income statement / statement of cash flows). 1. For profitability ratios (high / low) ratio indicates greater profitability and an increasing trend is considered (favorable / unfavorable). On the previous page, for each ratio, circle the strongest among the three companies in the Personal Computer Systems Industry. B. Meaning is added to a ratio by comparing that ratio to industry norms because success may vary by industry. On the previous page, cross out each ratio that is weaker than the Personal Computer Systems Industry average h. Review the ratios that were circled as the strongest and those ratios that were crossed out for being lower than the industry average to answer the following questions. 1. Which company has the greatest markup on products sold? (AAPL/DELL/HP Which ratio reveals this information? (ROS / Asset TO / ROA/GPX) 2 Which company appears to sell at a low markup to generate a greater volume of sales? (AAPL/DELL/HPQ) Which two ratios reveal this information? (ROS / Asset TO / ROA/GPX) 3. According to the most comprehensive measure of profitability, which company is the most profitable? (AAPL / DELL/HP) Which ratio reveals this information? (ROS/Asset TO/ROA/GPX) 4. Which company has the lowest product costs compared to sales revenue? (AAPL/DELL / HPG) Which ratio reveals this information? (ROS / Asset TO/ROA/GPX) 5. Which company has the strongest profitability? (AAPL / DELL/HPQ) Why? (AAPL/DELL/HPQJ 6. Which company has the weakest profitability? Why