Horngren's Financial & Managerial Accounting, The Financial Chapters (Book & Access Card)
5th Edition
ISBN: 9780134078939
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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?
A company’s comparative statements are given below. Please conduct the following analyses
(hint: use of a spreadsheet is recommended for ease of computation):a. Horizontal analysis (trend analysis) on the income statement
b. Vertical analysis (common size financial statement analysis) on the income statement
c. Calculate the three profitability ratios for the 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?
Given the income statement below, Mega Trade Inc. wants to find the resulting net income for the year 2016 (in million). What is the right amount?
Income Statement ($ Million)
YEAR END
YEAR END
YEAR END
YEAR END
2015
2016
2017
2018
Sales
1,234.90
1,251.70
1,300.40
1,334.40
Cost Sales
-679.1
-659
-681.3
-667
Gross Operating Income
Selling & Administration
-339.7
-348.6
-351.2
-373.3
Depreciation
-47.5
-52
-55.9
-75.2
Other Income/Expenses
11.8
7.6
7
8.2
Earnings Before Interest and Taxes
Interest Income
1.3
1.4
1.7
2
Interest Expense
-16.2
-15.1
-20.5
-23.7
Pre Tax Income
Income Taxes
-56.8
-64.2
-67.5
-72.6
Net Income
Dividends
-38.3
-38.7
-39.8
-40.1
Chapter 15 Solutions
Horngren's Financial & Managerial Accounting, The Financial Chapters (Book & Access Card)
Ch. 15 - What part of the Libertys annual report is written...Ch. 15 - Horizontal analysis of Liberty's balance sheet for...Ch. 15 - Vertical analysis of Liberty's balance sheet for...Ch. 15 - Which statement best describes Liberty's acid-test...Ch. 15 - Liberty's inventory turnover during 2017 was...Ch. 15 - Prob. 6QCCh. 15 - Prob. 7QCCh. 15 - Liberty's rate of return on common stockholders'...Ch. 15 - The company has 2,500 shares of common stock...Ch. 15 - Prob. 10AQC
Ch. 15 - What ate the three main ways to analyze financial...Ch. 15 - What is an annual report? Briefly describe the key...Ch. 15 - Prob. 3RQCh. 15 - What is trend analysis, and how does it differ...Ch. 15 - Prob. 5RQCh. 15 - Prob. 6RQCh. 15 - Prob. 7RQCh. 15 - Briefly describe the ratios that can be used to...Ch. 15 - Prob. 9RQCh. 15 - Briefly describe the ratios that can be used to...Ch. 15 - Briefly describe the ratios that can be used to...Ch. 15 - Prob. 12RQCh. 15 - Prob. 13RQCh. 15 - Prob. 14RQCh. 15 - Prob. 15RQCh. 15 - Prob. 15.1SECh. 15 - Performing horizontal analysis McDonald Corp....Ch. 15 - Calculating trend analysis Variline Corp. reported...Ch. 15 - Performing vertical analysis Hoosier Optical...Ch. 15 - Preparing common-size income statement Data for...Ch. 15 - Shine's Companies, a home improvement store chain,...Ch. 15 - Shine's Companies, a home improvement store chain,...Ch. 15 - Shine's Companies, a home improvement store chain,...Ch. 15 - Prob. 15.9SECh. 15 - Prob. 15.10SECh. 15 - Prob. 15.11SECh. 15 - Using ratios to reconstruct a balance sheet...Ch. 15 - Prob. 15.13SECh. 15 - Prob. 15.14SECh. 15 - Prob. 15.15ECh. 15 - Computing trend analysis Grand Oaks Realty's net...Ch. 15 - Prob. 15.17ECh. 15 - Prob. 15.18ECh. 15 - Prob. 15.19ECh. 15 - Prob. 15.20ECh. 15 - Analyzing the ability to pay liabilities Big Bend...Ch. 15 - Analyzing profitability Varsity, Inc.s comparative...Ch. 15 - Prob. 15.23ECh. 15 - Using ratios to reconstruct a balance sheet The...Ch. 15 - Prob. 15.25ECh. 15 - Computing earnings per share Falconi Academy...Ch. 15 - Prob. 15.27APCh. 15 - Prob. 15.28APCh. 15 - Prob. 15.29APCh. 15 - Prob. 15.30APCh. 15 - Using ratios to evaluate a stock investment...Ch. 15 - Prob. 15.32APCh. 15 - Preparing an income statement The following...Ch. 15 - Computing trend analysis and return on common...Ch. 15 - Prob. 15.35BPCh. 15 - Prob. 15.36BPCh. 15 - Determining the effects of business transactions...Ch. 15 - Prob. 15.38BPCh. 15 - Prob. 15.39BPCh. 15 - Prob. 15.40BPCh. 15 - Prob. 15.41CPCh. 15 - Lance Berkman is the controller of Saturn, a dance...Ch. 15 - Prob. 15.1CTEI
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Given the income statement below, Mega Trade Inc. wants to find the resulting net income for the year 2018 (in million). What is the right amount? Income Statement ($ Million) Year End 2015 2016 2017 2018 Sales 1,234.90 1,251.70 1,300.40 1,334.40 Cost of Sales -679.1 -659 -681.3 -667 Selling & Administration -339.7 -348.6 -351.2 -373.3 Depreciation -47.5 -52 -55.9 -75.2 Other Income/Expenses 11.8 7.6 7 8.2 Interest Income 1.3 1.4 1.7 2 Interest Expense -16.2 -15.1 -20.5 -23.7 Income Taxes -56.8 -64.2 -67.5 -72.6 Dividends -38.3 -38.7 -39.8 -40.1 CHOICES: A. 108.7B. 132.7C. No choice givenD. 132.8E. 121.8arrow_forwardFINANCIAL RATIOS Required: a. Compute for the company's profitability and operating efficiency ratios in 2014. b. Compute for the financial health ratios of the company in 2014 and 2013. Very Berry Company Very Berry Company Statement of Comprehensive Income Statement of financial Position For the year ended December 31 For the year ended December 31 2014 2013 400,000 5,600,000 2014 2013 Cash 180,000 Short-term Investments 1,800,000 Sales 10,040,000 8,760,000 Accounts Receivable 1,480,000 1,060,000 Cost of Goods Sold 5,680,000 5,860,000 Inventory 1,380,000 1,640,000 4,360,000 1,160,000 Gross Profit 2,800,000 8,860,000 10,860,000 Other Current Assets 4,680,000 Operating Expenses Operating Income Interest Expense 1,680,000 Total Current Assets 5,040,000 1,20,000 28,000 3,200,000 Equipment 6,800,000 5,200,000 100,000 Total Assets 17,660,000 10,240,000 3,100,000 Accounts Payable Notes Payable - long term Owner, Capital Total Liabilities and Capital 2,620,000 2,120,000 Net Income 1,192,000…arrow_forwardIn the income statement below, ABC Trade Inc. wants to find the resulting net income for the year 2018 (in million). What is the right amount? Income Statement ($ Million) Year End 2015 2016 2017 2018 Sales 1,234.90 1,251.70 1,300.40 1,334.40 Cost of Sales (679.10) (659.00) (681.30) (667.00) Gross Operating Income Selling & Administration (339.70) (348.60) (351.20) (373.30) Depreciation (47.50) (52.00) (55.90) (75.20) Other Income/Expenses 11.80 7.60 7.00 8.20 Earnings Before Interest and Taxes Interest Income 1.30 1.40 1.70 2.00 Interest Expense (16.20) (15.10) (20.50) (23.70) Pre Tax Income Income Taxes (56.80) (64.20) (67.50) (72.60) Net Income Dividends (38.30) (38.70) (39.80) (40.10) Addition to Retained Earnings Group of answer choices 121.8 108.7 132.7 132.8 No choice givenarrow_forward
- Given the income statement below, Mega Trade Inc. wants to find the resulting net income for the year 2018 (in million). What is the right amount? Income Statement ($ Million) YEAR END YEAR END YEAR END YEAR END 2015 2016 2017 2018 Sales 1,234.90 1,251.70 1,300.40 1,334.40 Cost Sales -679.1 -659 -681.3 -667 Gross Operating Income Selling & Administration -339.7 -348.6 -351.2 -373.3 Depreciation -47.5 -52 -55.9 -75.2 Other Income/Expenses 11.8 7.6 7 8.2 Earnings Before Interest and Taxes Interest Income 1.3 1.4 1.7 2 Interest Expense -16.2 -15.1 -20.5 -23.7 Pre Tax Income Income Taxes -56.8 -64.2 -67.5 -72.6 Net Income Dividends -38.3 -38.7 -39.8 -40.1 Addition to Retained Earningsarrow_forwardAnalyze the financials for Wal-Mart and its competitor(s) in the online market in 2012 and 2016. What do you conclude from analyzing financial ratios about the companies strategies and Walmart's competitive advantage? Revenue Cost of goods sold Gross profit SG&A and other expenses Operating income Net income Total assets Total liabilities Total equity Total assets end Total assets beginning Total liabilities end Total liabilities beginning Total equity end Total equity beginning Cost of goods sold as % of sales Gross margin SG&A as % of sales Operating income margin Net profit margin Asset turnover ROA ROE Walmart 2012 in $ millions 443,854 335,127 108,727 85,265 23,462 15,699 186,931 113,021 73,910 193,406 180,455 117,241 108,800 76,165 71,655 75.5% 24.5% 19.2% 5.3% 3.5% 2.4 8.4% 21.2% Walmart 2016 in $ millions 478,614 360,984 117,630 97,041 20,589 14,694 201,536 116,762 84,774 199,581 203,490 115,970 117,553 83,611 85,937 75.4% 24.6% 20.3% 4.3% 3.1% 2.4 7.3% 17.3% Amazon 2012 in $…arrow_forwardBased on your Ratio Analysis, what steps would you advise your new client to take due to their company's current performance? Please give as detailed an answer as possible. Gross Profit Margin EBIT to Percentage of Sales Net Profit Margin Return on equity Return on Assets Asset Turnover S. Canada Inc. Financial Ratios *Refer to Brightspace for the Ratio Formulas 2016 2015 Working Capital Current Ratio Quick Ratio Days Sales Outstanding (DSO) Accounts Receivable Turnover (ART) Inventory Days on Hand Inventory Turnover Time Interest Earned Debt to Equity ratio Debt to Assets Show Transcribed Text 31.78 -1.99 -2.16 -0.86 -0.51 0.24 $6,423,000.00 2.50 0.87 76.81 4.75 1,110.87 0.33 -6.46 68.18 40.54 32.60 -10.51 -9.89 -3.42 -2.08 0.21 $5,313,000.00 2.13 0.71 83.30 4.38 1,119.67 0.33 -360.00 67.98 40.47 2014 36.17 12.28 13.39 4.49 2.78 0.21 $7,634,000.00 2.21 0.94 73.61 4.96 1.164.57 0.31 45.37 62.34 38.40arrow_forward
- You are provided with the Income Statement and the Balance Sheet of HTS software, Inc. for 2011. Required: (b) Analyze the current financial position for the company from a time series and cross section viewpoint. (c) Break your analysis into an evaluation of the firm’s liquidity, activity, debt, profitability and market ratios. Historical and Industry Average Ratios HTS Software , Inc. Ratio 2010 2011 Industry2011 Current Ratio 2.6 — 2.7 Quick Ratio 1.8 — 1.75 Inventory Turnover 4.5 — 4.7 Average Collection Period 40days — 42 days Total Asset Turnover 1.2 — 1 Debt Ratio 20% — 21% Times Interest Earned 9 — 8.9 Gross Profit Margin 43% — 44% Operating Profit Margin 30% — 32% Net Profit Margin 20% — 21% Return on total assets 12% — 13% Return on Equity Price/Earnings Ratio 15% 7.3 — — 16% 8 Balance SheetHTS Software, Inc.December 31,…arrow_forwardFor fiscal year 2018, Walmart Inc. (WMT) had total revenues of $500.34 billion, net income of $9.86 billion, total assets of $204.52 billion, and total shareholders' equity of $77.87 billion. a. Calculate Walmart's ROE directly, and using the DuPont Identity. b. Comparing with the data for Costco, use the DuPont Identity to understand the difference between the two firms' ROES. Data table For fiscal year 2018, Costco Wholesale Corporation (COST) had a net profit margin of 2.08%, asset turnover of 3.55, and a book equity multiplier of 3.37. Costco's ROE (DuPont) is 24.88%.arrow_forwardDefine profitability raitos return on assets and return on equity. According to the following metrics: ROA Return on Assets: 14%; ROE Return on Equity: 305%. What is the profitability the of example company? Why or why not is this company profitable?arrow_forward
- In fiscal year 2018, Wal-Mart Stores (WMT) had revenue of $514.41 billion, gross profit of $129.10 billion, and net income of $6.67 billion. Costco Wholesale Corporation (COST) had revenue of $141.6 billion, gross profit of $18.42 billion, and net income of $3.13 billion. a. Compare the gross margins for Walmart and Costco. b. Compare the net profit margins for Walmart and Costco. c. Which firm was more profitable in 2018? a. Compare the gross margins for Walmart and Costco. The gross margin for Walmart is enter your response here %. (Round to two decimal places.) The gross margin for Costco is enter your response here %. (Round to two decimal places.) Part 3 b. Compare the net profit margins for Walmart and Costco. The net profit margin for Walmart is enter your response here %. (Round to two decimal places.) Part 4 The net profit margin for Costco is enter your response here %. (Round to two decimal places.) c. Which firm was more profitable in 2018? (Select from the…arrow_forward5. Profitability ratios Profitability ratios help in the analysis of the combined impact of liquidity ratios, asset management ratios, and debt management ratios on the operating performance of a firm. Your boss has asked you to calculate the profitability ratios of Diusitech Inc. and make comments on its second-year performance as compared with its first-year performance. The following shows Diusitech Inc.'s income statement for the last two years. The company had assets of $4,700 million in the first year and $7,518 million in the second year. Common equity was equal to $2,500 million in the first year, and the company distributed 100% of its earnings out as dividends during the first and the second years. In addition, the firm did not issue new stock during either year. Diusitech Inc. Income Statement For the Year Ending on December 31 (Millions of dollars) Year 2 Year 1 2,540 2,000 1,610 1,495 127 80 1,737 803 80 723 181 542 Net Sales Operating costs except depreciation and…arrow_forwardThe following condensed information is reported by Beany Baby Collectibles. Income Statement Information Sales revenue Cost of goods sold Net income Balance Sheet Information Current assets Long-term assets Total assets Current liabilities Long-term liabilities Common stock Retained earnings Total liabilities and stockholders' equity Required: 1. Calculate the following profitability ratios for 2024: 2. Determine the amount of dividends paid to shareholders in 2024. 2024 $10,440,000 6,827,760 360,000 $1,200,000 1,500,000 2023 $1,600,000 $1,500,000 2,200,000 1,900,000 $3,800,000 $3,400,000 800,000 300,000 $3,800,000 $8,400,000 5,900,000 248,000 $900,000 1,500,000 800,000 200,000 $3,400,000arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License