Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
6th Edition
ISBN: 9780134486857
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter D, Problem 1FSC
1.
To determine
Compute trend analysis for sales and Net earnings/ (loss) and identify the most important trend.
2.
To determine
Prepare a vertical analysis of Corporation T for 2016 and 2015.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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.08
2.7
Quick Ratio
1.8
1.32
1.75
Inventory Turnover
4.5
6
4.7
Average Collection Period
40days
9.125
42 days
Total Asset Turnover
1.2
1.69
1
Debt Ratio
20%
28.2%
21%
Times Interest Earned
9
5.9%
8.9
Gross Profit Margin
43%
42.8%
44%
Operating Profit Margin
30%
25.5%
32%
Net Profit Margin
20%
17%
21%
Return on total assets
12%
4.11%
13%
Return on Equity
Price/Earnings Ratio
15%
7.3
19%
4.4
16%
8…
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,…
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?
Chapter D Solutions
Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
Ch. D - Prob. 1TICh. D - Prob. 2TICh. D - Prob. 3TICh. D - Prob. 4TICh. D - Prob. 5TICh. D - Prob. 6TICh. D - Prob. 7TICh. D - Prob. 8TICh. D - Prob. 9TICh. D - Prob. 10TI
Ch. D - Prob. 1QCCh. D - Prob. 2QCCh. D - Vertical analysis of Libertys balance sheet for...Ch. D - Prob. 4QCCh. D - Libertys inventory turnover during 2019 was...Ch. D - Prob. 6QCCh. D - Prob. 7QCCh. D - Prob. 8QCCh. D - Prob. 9QCCh. D - Prob. 10QCCh. D - Prob. 1RQCh. D - Prob. 2RQCh. D - Prob. 3RQCh. D - Prob. 4RQCh. D - Prob. 5RQCh. D - Prob. 6RQCh. D - Prob. 7RQCh. D - Prob. 8RQCh. D - Prob. 9RQCh. D - Prob. 10RQCh. D - Prob. 11RQCh. D - Prob. 12RQCh. D - Prob. 13RQCh. D - Prob. 1SECh. D - Verifine Corp. reported the following on its...Ch. D - Prob. 3SECh. D - Prob. 4SECh. D - Prob. 5SECh. D - Prob. 6SECh. D - Prob. 7SECh. D - Accels Companies, a home improvement store chain,...Ch. D - Prob. 9SECh. D - Prob. 10SECh. D - Prob. 11SECh. D - Prob. 12SECh. D - Prob. 13ECh. D - Prob. 14ECh. D - Prob. 15ECh. D - Refer to the data presented for Mulberry Designs,...Ch. D - Prob. 17ECh. D - Prob. 18ECh. D - Prob. 19ECh. D - Micatin, Inc.s comparative income statement...Ch. D - Prob. 21ECh. D - Prob. 22ECh. D - Prob. 23APCh. D - Prob. 24APCh. D - Prob. 25APCh. D - Prob. 26APCh. D - Comparative financial statement data of Sanfield,...Ch. D - Prob. 28APCh. D - Prob. 29APCh. D - Prob. 30BPCh. D - Prob. 31BPCh. D - Prob. 32BPCh. D - Prob. 33BPCh. D - Prob. 34BPCh. D - Prob. 35BPCh. D - In its annual report, XYZ Athletic Supply, Inc....Ch. D - Prob. 38PCh. D - Lance Berkman is the controller of Saturn, a dance...Ch. D - Prob. 1EICh. D - Prob. 1FSC
Knowledge Booster
Similar questions
- A firm’s Balance Sheet and Income Statement for FY 2021 is displayed below and in the in the attached excel file. Answer the following questions. NOTE: For this question, use the end-of-the year approach (and not the mid-year convention). For example, this means that days receivables = end of FY receivables/daily sales; similarly for the remaining relevant ratios. You may use the tables below BALANCE SHEET 2021 Cash and cash equivalents 280 Receivables 2588 Inventory 2516 Other 189 TOTAL CA 5573 Fixed assets 5024 TOTAL ASSETS 10597 Accounts payable 4713 Short term debt 78 TOTAL CL 4790 LT debt 921 Shareh. Equity 4886 TOTAL LIAB. AND SHARH. EQUITY 10597 INCOME STATEMENT 2021 Sales 19418 COGS 13136 Depreciation 354 SG&A 4952 EBIT 976 Interest Expenses 52 Tax 268 Net income 656 Decompose the return on equity for the FY 2021…arrow_forwardA firm’s Balance Sheet and Income Statement for FY 2021 is displayed below and in the in the attached excel file. Answer the following questions. NOTE: For this question, use the end-of-the year approach (and not the mid-year convention). For example, this means that days receivables = end of FY receivables/daily sales; similarly for the remaining relevant ratios. You may use the tables below BALANCE SHEET 2021 Cash and cash equivalents 280 Receivables 2588 Inventory 2516 Other 189 TOTAL CA 5573 Fixed assets 5024 TOTAL ASSETS 10597 Accounts payable 4713 Short term debt 78 TOTAL CL 4790 LT debt 921 Shareh. Equity 4886 TOTAL LIAB. AND SHARH. EQUITY 10597 INCOME STATEMENT 2021 Sales 19418 COGS 13136 Depreciation 354 SG&A 4952 EBIT 976 Interest Expenses 52 Tax 268 Net income 656 Determine the NLF, NSF and the liquidity ratio…arrow_forwardYou are provided with the Income Statement and the Balance Sheet of HTS software, Inc. for 2011. Required: (a) Calculate the ratios stated in the table below for HTS Software, Inc. for 2011 (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…arrow_forward
- Access 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_forwardUse information from the balance sheet and income statement to calculate the following financial ratios and the market value added (MVA). (Whenever balance sheet numbers are used to calculate financial ratios, please ensure that you use the average of the 2019 and 2020 numbers in your calculation. To calculate MVA, you can assume that the average book value number for common stock and paid-in-surplus is the amount that the shareholders initially invested in the company.)arrow_forwardHello! look at the attached images and answee the following points: (a) Calculate ratios for the year ended 31 December 2021 (showing your workings) for Primrose Plc, equivalent to those provided above. Return on year-end capital employed Net asset turnover Gross profit margin Net profit margin Current ratio Closing inventory holding period Trade receivables’ collection period viii. Trade payables’ payment period Dividend yield Dividend cover (b) Analyse the financial performance and position of Primrose Plc for the year ended 31 December 2021 compared to 31 December 2020. (c) Explain the uses and the general limitations of ratio analysis. Thank you a lot!arrow_forward
- Required: Analyse Delima’s financial statement. Include the following ratios for 2020 and discuss your findings (2019 values are provided for comparison): Current ratio (year 2019 – 92:1) Inventory turnover (year 2019 – 7.2 times) Debt to assets ratio (year 2019 – 82%) Return on assets (year 2019 – 10.8%) Profit margin (year 2019 – 10.0%)arrow_forwardRequired: Use an Excel file to answer the following questions. Compute the following ratios for the companies’ 2014 fiscal years. (Use formulas): Current ratio Average days to sell inventory. (Use average inventory.) Debt to assets ratio. Return on investment. (Use average assets and use “earnings from continuing operations” rather than “net earnings.”) Gross margin percentage. Asset turnover. (Use average assets.) Net margin. (Use “earnings from continuing operations” rather than “net earnings.”) Plant assets to long-term debt ratio. Which company appears to be more profitable? Explain your answer and identify which ratio(s) from Requirement a you used to reach your conclusion. Which company appears to have the higher level of financial risk? Explain your answer and identify which ratio(s) from Requirement a you used to reach your conclusion. Which company appears to be charging higher prices for its goods? Explain your answer and identify which ratio(s) from Requirement a you…arrow_forwardA 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_forward
- You are provided with the Income Statement and the Balance Sheet of HTS software, Inc. for 2011.Required: (a) Calculate the ratios stated in the table below for HTS Software, Inc. for 2011 (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.arrow_forwardUsing the fiscal year end 2020 annual report for General Mills, Inc. and the figures from the 2020 annual report as noted below, calculate the financial ratios for 2020 and 2019 indicated using the EXCEL template provided:1. Gross profit percentage2. Return on sales3. Asset turnover 4. Return on assets5. Return on common stockholders’ equity6. Current ratio7. Quick ratio8. Operating-cash-flow-to-current-liabilities ratio9. Accounts receivable turnoverTotal assets 2020 = $30,806.7Total stockholders’ equity 2020 = $8,349.5Total current liabilities 2020 = $7,491.5Accounts receivable 2020 = $1,615.1Inventory 2020 = $1,426.3Year-end closing stock price May 2020 = $58.80Year-end closing stock price May 2019 = $53.56 To calculate averages use (current year balance + poor year balance) / 2) Round percentages to 1 decimal place; round other answers to 2 decimal places.arrow_forwardSelect 2017 Year From The Given Data In Image And Find The Following thing:1) Balance Sheet Growth - (TOTAL ASSETS CURRENT YEAR- TOTAL ASSETS CURRENT YEAR) / TOTAL ASSETS PREVIOUS YEAR.2) Sales.3) Financial Exp as a % of Sales4) EBIT5) Financial Cost / Interest Expensearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning