Concept introduction:
Profit Margin:
The profit margin for a company is calculated as the percentage of net income to sales. Thus, it is a ratio to compute profitability against net sales.
Requirement 1:
To compute profit margin percentage for Apple and Google company respectively.
Concept introduction:
Investment Turnover:
The investment turnover for a company is calculated as the ratio of net sales to average investments during the period. The average investments calculated as the sum average of opening and closing balance of invested assets in the company respectively.
Requirement 2:
To compute investment turnover ratio for Apple and Google company respectively.
Concept introduction:
Ratio Analysis:
The comparison of ratios such as profit margin and investment turnover to evaluate the performance during the period for the given companies is known as ratio analysis.
Requirement 3:
To explain:
To enumerate the reasons for better performance based on the information provided for fiscal year 2017 for Apple and Google company.
Want to see the full answer?
Check out a sample textbook solutionChapter 9 Solutions
Managerial Accounting
- The following revenue data were taken from the December 31, 2017, General Electric annual report (10-K): For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales. Using Microsoft Excel or another spreadsheet application, create a clustered column graph to show the 2016 and 2017 percentages for each division. Comment on your observations of this data. How might a division sales manager use this data?arrow_forwardThe following revenue data were taken from the December 31, 2017, Coca-Cola annual report (10-K): For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales, Using Microsoft Excel or another spreadsheet application, create a clustered column graph to show the 2016 and 2017 percentages for each division. Comment on your observations of this data. How might a division sales manager use this data?arrow_forwardComparing Two Companies in the Same Industry: Chipotle and Panera Bread This case should be completed after responding to the requirements in Decision Case 13-2. Refer to the financial statement information of Chipotle and Panera Bread reprinted at the back of the book. Required Using the format in Example 13-5, prepare common-size comparative income statements for 2014 and 2013, for Panera Bread. Use total revenues as the base (i.e., 100%). Round all percentages to the nearest one-tenth of a percent. The common-size comparative income statements indicate the relative importance of items on the statement. Compare the common-size income statements of Panera Bread and Chipotle. What are the most important differences between the two companies income statements? Using the format in Example 13-4, prepare common-size comparative balance sheets at the end of 2014 and 2013, for Panera Bread. Round all percentages to the nearest one-tenth of a percent. The common-size comparative balance sheets indicate the relative importance of items on the statement. Compare the common-size balance sheets of Panera Bread and Chipotle. What are the most important differences between the two companies balance sheets?arrow_forward
- VII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Securities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 245,000 220,000 Operating Expenses: Fixed Assets 200,000 160,000 Selling Expenses 22,000 25,000 Total Assets P445,000…arrow_forwardIndustry, Delete any companies with missing data for AT, SALE, IB Using Your industry (from question title), please answer these questions using Fiscal year 2015 data, use Total Assets (AT) for average investment, Income Before Extraordinary Items (IB) for income, and Sales/Turnover (Net) (SALE) for Sales Revenue What is the average Sales Margin for your industry? Answer in percentage, to the nearest hundredth of a percent, without the % sign, example 3.45 for 3.45%, 0.45 for 0.45% What is the average Turnover for your industry Answer to the nearest hundredth What is the average Return on Investment for your industry Answer in percentage, to the nearest hundredth of a percent, without the % sign, example 3.45 for 3.45% Which company (use Global Company Key) has the highest ROI in your Industry? Answer with no leading zeros using the appropriate number of digitsarrow_forwardProblem 1: Viance Queen Company Required: Compute for the company’s profitability and operating efficiency ratios for 2019 Compute for the financial health ratios of the company for 2019 A.Profitability ratio a.Gross Profit Ratio b. Operating income margin c. Net profit margin d. Return on Assets: ROA (NI/Total Assets) ROA (NI/Average Assets) ROA (EBIT/Total Assets) ROA (EBIT/Average Assets) ROE (NI/Capital) ROE (NI/Average Capital B.Operating Efficiency a. Asset Turnover b. Fixed Asset Turnover c. Inventory Turnover d. Days in Inventory e. AR Turnover f. Days in AR C.Financial Health/ (Solvency and Liquidity) Solvency ratio: a. Debt to equity ratio b. Debt Ratio c. Equity Ratio d. Interest Coverage Ratio Liquidity ratio: a. Current Ratio b. Quick Ratioarrow_forward
- Use the following selected data from Business Solutions's income statement for the three months ended March 31, 2022, and from its Complete this question by entering your answers in the tabs below. March 31, 2022, balance sheet to complete the requirements. Computer services revenue Net sales (of goods) Total sales and revenue Cost of goods sold. Net income Quick assets Current assets Total assets Current liabilities Total liabilities. Total equity Required 1 Required: 1. Compute the gross margin ratio (both with and without services revenue) and net profit margin ratio. 2. Compute the current ratio and acid-test ratio. 3. Compute the debt ratio and equity ratio. 4. What percent of its assets are current? What percent are long term? Required 2 Complete this question by entering your answers in the tabs below. $ 25,307 18,693 44,000 Required 3 Gross margin ratio Net profit margin ratio 14,052 18,833 90,924 95,568 120,268 875 875 119,393 % Compute the gross margin ratio (both with and…arrow_forwardProblem 1: Viance Queen Company Required: Compute for the company’s profitability and operating efficiency ratios for 2019 Compute for the financial health ratios of the company for 2019 B.Operating Efficiency Days in Inventory AR Turnover Days in ARarrow_forwardMia is comparing income statements from the previous three years in order to assess changes and trends in the company's revenue. What type of business analysis is being performed by Mia? Select one: O a. Production O b. Sales O C. Financial O d. Information management Clear my choicearrow_forward
- A company’s comparative statements are given below. Please conduct the following analyses: c. Calculate the three profitability ratios for year 2017 and show how ROE can be derived from the DuPont formula for this company. d. What do the analyses tell you about the company’s financial performance?arrow_forwardFollowing are 2017 and 2018 revenue data for Honeywell International's four segments. Use these data to forecast its 2019 revenue. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Honeywell International Segment Sales and Business-Unit Sales by Segment $ millions 2018 2017 Aerospace sales Commercial aviation original equipment Commercial aviation aftermarket Defense and space Transportation systems Total aerospace sales Honeywell building technologies sales Homes Buildings Total Honeywell building technologies sales Performance materials and technologies sales UOP Russell LLP Process solutions Advanced materials Total performance materials and technologies sales $3,591 $2,475 5,373 5,861 5,423 4,053 2,622 3,906 $17,009 $16,295 $4,686 $4,482 5,370 6,053 $10,056 $10,535 $3,603 $2,753 4,981 5,553 3,606 2,791 $12,190 $11,097 Safety and productivity solutions sales Safety…arrow_forwardAccess the February 21, 2017, filing of the December 31, 2016, 10-K report of The Hershey Company (ticker: HSY) at SEC.gov and complete the following requirements. Required Compute or identify the following profitability ratios of Hershey for its years ending December 31, 2016, and December 31, 2015. Interpret its profitability using the results obtained for these two years. 1. Profit margin ratio (round the percent to one decimal). 2. Gross profit ratio (round the percent to one decimal). 3. Return on total assets (round the percent to one decimal). (Total assets at year-end 2014 were $5,622,870 in thousands.) 4. Return on common stockholders’ equity (round the percent to one decimal). (Total shareholders’ equity at year-end 2014 was $1,519,530 in thousands.) 5. Basic net income per common share (round to the nearest cent).arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning