Please help me Complete this question by entering your answers in the tabs below.Required 1Required 2Required 3Compute common-size percents for each company using the data given. (Input all the values as positive numbers. Enter youranswers in millions. Round your percentage answers to 1 decimal place.)S millionsApple%GoogleCash and equivalentsAccounts receivable, netInventoriesRetained earnings%%Cost of salesRevenues%Total assetsComplete this question by entering your answers in the tabs below.Required 1Required 2Required 3If Google paid a dividend, would retained earnings as a percent of total assets increase or decrease?If Google paid a dividend, would retained earnings as a percent of total assets increase or decrease?Complete this question by entering your answers in the tabs below.Required 1Required 2Required 3Which company has the better gross margin ratio on sales?Which company has the better gross margin ratio on sales? AA 17-2 Comparative Analysis LO C1, P2Key figures for Apple and Google follow.$ millionsCash and equivalentsAccounts receivable, netInventoriesRetained carningsCost of salesApple$ 48,84422,9264,10645,898161,782260,174338,516Google$ 18,49825,326999152,12271,896161,857275,909RevenuesTotal assetsRequired:1. Compute common-size percents for each company using the data given.2. If Google paid a dividend, would retained earnings as a percent of total assets increase or decrease?3. Which company has the better gross margin ratio on sales?Complete this question by entering your answers in the tabs below.Required 1Required 2Required 3Compute cormmon-size percents for each company using the data given. (Input all the values as positive numbers. Enter youranswers in millions. Round your percentage answers to 1 decimal place.)S millionsAppleGoogle

Common size percentage is where each amount of balance sheet is expressed as percent of total assets…

Rey figures för Apple and Google follow. S millions Cash and equivalents Accounts receivable, net Inventories Retained carnings Cost of sales Revenues Total assets Apple $ 48,844 22,926 4,106 45,898 161,782 260, 174 338,516 Google $ 18,498 25,326 999 152,122 71,896 161,857 275,909 Required: 1. Compute common-size percents for each company using the data given. 2. If Google paid a dividend, would retained earnings as a percent of total assets increase or decrease? 3. Which company has the better gross margin ratio on sales?

Rey figures för Apple and Google follow. S millions Cash and equivalents Accounts receivable, net Inventories Retained carnings Cost of sales Revenues Total assets Apple $ 48,844 22,926 4,106 45,898 161,782 260, 174 338,516 Google $ 18,498 25,326 999 152,122 71,896 161,857 275,909 Required: 1. Compute common-size percents for each company using the data given. 2. If Google paid a dividend, would retained earnings as a percent of total assets increase or decrease? 3. Which company has the better gross margin ratio on sales?

Accounting (Text Only)

26th Edition

ISBN:9781285743615

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter17: Financial Statement Analysis

Section: Chapter Questions

Problem 17.3CP: Vertical analysis The condensed income statements through income from operations for Dell Inc. and...

See similar textbooks

Similar questions

Vertical analysis The condensed income statements through income from operations for Dell Inc. and Apple Inc. for recent fiscal years follow (numbers in millions of dollars): Prepare comparative common-sized statements, rounding percents to one decimal place. Interpret the analyses.
Hw.131. Sheridan Corporation reported net sales of $284,700, cost of goods sold of $156,585, operating expenses of $43,800, net income of $28,470, beginning total assets of $537,100 and ending total assets of $604,200 (a1) Calculate profit margin and gross profit rate. (Round answers to 1 decimal place, eg10.2%)
Analyze and compare Amazon.com and Wal-Mart Amazon.com, Inc. (AMZN) is one of the largest Internet retailers in (lie world. Wal-Mart Stores, Inc. (WMT) is the largest retailer in the United States. Amazon and Wal-Mart compete in similar markets; however, Wal-Mart sells through both traditional retail stores and the Internet, while Amazon sells only through the Internet. Interest expense and income before income tax expense from the financial statements of both companies for two recent years follow (in millions): a.Compute the times interest earned ratio for both companies for the two years. Round to one decimal place. b. Interpret Amazons interest coverage from Year 1 to Year 2. c. Does a times interest earned ratio less than 1.0 mean that creditors will not get paid interest? d. Interpret Wal-Marts interest coverage from Year 1 to Year 2. e. Which company appears to have the greater protection for creditors?
Nineteen measures of solvency and profitability The comparative financial statements of Stargel Inc. are as follows. The market price of Stargel Inc. common stock was 119.70 on December 31, 2016. Stargel Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 2016 and 2015 2016 2015 Retained earnings, January 1................ 5,375,000 4,545,000 Add net income for year......................... 900,000 925,000 Total..................................... 6,275,000 5,470,000 Deduct dividends: On preferred stock............................................. 45,000 45,000 On common stock.............................................. 50,000 50,000 Total........................................................ 95,0000 95,000 Retained earnings, December 3................................... 6,180,000 5,375,000 Stargel Inc. Comparative Income Statement For the Year Ended December 31, 2016 and 2015 2016 2015 Sales..................... 10,000,000 9,400,000 Cost of goods sold......... 5,350,000 4,950,000 Gross profit............... 4,650,000 4,450,000 Selling expenses.......... 2,000,000 1,080,000 Administrative expenses... 1,500.000 1,410,000 Total operating expenses 3,500,000 3,290,000 Income from operations ... 1,150,000 1,160,000 Other income............. 150,000 140,000 1,300,000 1,300,000 Other expense (interest). 170,000 150,000 Income before income tax 1,130,000 1,150,000 Income tax expense....... 230,000 225,000 Net income............... 900,000 925,000 Stargel Inc. Comparative Income Statement For the Year Ended December 31, 2016 and 2015 Dec.31, 2016 Dec. 31, 2015 Assets Current Assets: Cash.................................... 500,000 400,000 Marketable securities.................... 1,010,000 1,000,000 Accounts receivable (net)................. 740,000 510,000 Inventories.............................. 1,190000 950,000 Prepaid expenses........................ 250,000 229,000 Total current assets..................... 3,690,000 3,089,000 Long-term investments.................... 2,350,000 2,300,000 Property, plant and equipment (net)....... 3,740,000 3,366,000 Total assets............................... 9,780,000 8,755,000 Liabilities Current liabilities.......................... 900,000 880,000 Long-term liabilities: Mortgage note payable, 8.8%, due 2021... 200,000 0 Bonds payable, 9%, due 2017............. 1,500,000 1,500,000 Total long term liabilities............... 1,700,000 1,500,000 Total liabilities............................ 2,600,000 2,380,000 Stockholders' equity Preferred stock 0.90, 10 par.. 500,000 500,000 Common stock. 5 par..................... 500,000 500,000 Retained earnings......................... 6,180,000 5,375,000 Total stockholders' equity............... 7,180,000 6,375,000 Total liabilities and stockholders' equity..... 9,780,000 8,755,000 Instructions Determine the following measures for 2016, rounding to one decimal place, except per share amounts, which should be rounded to the nearest penny: 1. Working capital 2. Current ratio 3. Quick ratio 4. Accounts receivable turnover 5. Number of days salts in receivables 6. Inventory turnover 7. Number of days sales in inventory 8. Ratio of fixed assets to long-term liabilities 9. Ratio of liabilities to .stockholders' equity 10. Number of times interest charges are earned 11. Number of times preferred dividends are earned 12. Ratio of sales to assets 13. Rate earned on total assets 14. Rate earned on stockholders' equity 15. Rate earned on common stockholders' equity 16. Earnings per share on common stock 17. Price-earnings ratio 18. Dividends per share of common stock 19. Dividend yield
Changes in current operating assets and liabilities-indirect method Alpenrose Corporations comparative balance sheet for current assets and liabilities was as follows: Dec. 31, 2016 Dec. 31, 2015 Accounts receivable 27,000 32,400 Inventory 18,000 15,480 Accounts payable 16,200 14,220 Dividends payable 49,500 53,100 Adjust net income of 207,000 for changes in operating assets and liabilities to arrive at net cash flow from operating activities.
Changes in current operating assets and liabilities-indirect method Huluduey Corporations comparative balance sheet for current assets and liabilities was as follows: Dec. 31, 2016 Dec. 31, 2015 Accounts receivable 18,000 14,400 Inventory 34,800 29,700 Accounts payable 27,600 20,700 Dividends payable 8,400 10,800 Adjust net income of 160,000 for changes in operating assets and liabilities to arrive at net cash flow from operating activities.
Nineteen measures of solvency and profitability The comparative financial statements of Bettancort Inc. are as follows. The market price of Bettancort Inc. common stock was 71.25 on December 31, 2016. Bettancort Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 2016 and 2015 2016 2015 Retained earnings. January 1......................................... 2,655,000 2,400,000 Add net income for year............................................. 300,000 280,000 Total............................................................... 2,955,000 2,680,000 Deduct dividends: On preferred stock................................................ 15,000 15,000 On common stock................................................. 10,000 10,000 Total........................................................... 25,000 25,000 Retained earnings. December 31..................................... 2,930,000 2,655,000 Bettancort Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 2016 and 2015 2016 2015 Sales...................... 1,200,000 1,000,000 Cost of goods sold............ 500,000 475,000 Gross profit............... 700,000 525,000 Selling expenses.......... 240,000 200,000 Administrative expenses...... 180,000 150,000 Total operating expenses.. 420,000 350,000 Income from operations.. 280,000 175,000 Other income............. 166,000 225,000 446,000 400,000 Other expense (Interest)... 66,000 60,000 Income before income tax 380,000 340,000 Income tax expense....... 80,000 60,000 Net income............... 300,000 280,000 Bettancort Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 2016 and 2015 Dec.31, 2016 Dec. 31, 2015 Assets Current Assets: Cash.................................... 450,000 400,000 Marketable securities.................... 300,000 260,000 Accounts receivable (net)................. 130,000 110,000 Inventories.............................. 67,000 58,000 Prepaid expenses........................ 153,000 139,000 Total current assets..................... 1,100,000 967,000 Long-term investments.................... 2,350,000 2,200,000 Property, plant and equipment (net)....... 1,320,000 1,118,000 Total assets............................... 4,770,000 4,355,000 Liabilities Current liabilities.......................... 440,000 400,000 Long-term liabilities: Mortgage note payable, 8.8%, due 2021... 100,000 0 Bonds payable, 9%, due 2017............. 1,000,000 1,000,000 Total long term liabilities............... 1,100,000 1,000,000 Total liabilities............................ 1,540,000 1,400,000 Stockholders' equity Preferred stock 0.90, 10 par.. 200,000 200,000 Common stock. 5 par..................... 100,000 100,000 Retained earnings......................... 2,930,000 2,665,000 Total stockholders equity............... 3,230,000 2,955,000 Total liabilities and stockholders' equity..... 4,770,000 4,355,000 Instructions Determine the following measures for 2016, rounding to one decimal place: 1. Working capital 2. Current ratio 3. Quick ratio 4. Accounts receivable turnover 5. Number of days' sales in receivables 6. Inventory turnover 7. Number of days' sales in inventory 8. Ratio of fixed assets to long-term liabilities 9. Ratio of liabilities to stockholders equity 10. Number of times interest charges are earned 11. Number of times preferred dividends are earned 12. Ratio of sales to assets 13. Rate earned on total assets 14. Rate earned on stockholders' equity 15. Rate earned on common stockholders' equity 16. Earnings per share on common stock 17. Price-earnings ratio 18. Dividends per share of common stock 19. Dividend yield