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 solution
Students 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
- Conduct a vertical analysis (common-size financial statements). Comment on the components of the financial statements by year and its trend for the last three years. (Note: please see second picture as example for vertical analysis. The first picture is the given.)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_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 Decompose the return on equity for the FY 2021…arrow_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_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_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
- Please discuss the findings. Thank you.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_forwardMust solve it please.arrow_forward
- - Please refer to the following Income Statement and Balance Sheet (see attached picture): Prepare a vertical analysis for both the income statement and balance sheet. Write a paragraph comparing the company’s performance with the industry average. Compute the following ratios and comment on what the results mean when evaluating the company: Current ratio Gross profit percentage ratio Debt ratio Profit margin ratioarrow_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_forwardConsidering 2012 as the base year, you are required to compute the trend index for the following items: Revenue, cost of goods sold, total expenses and net earnings. Comment on the trends of each of the items. Total assets, total liabilities and shareholders’ equity. Comment on the trends of each of the items. Cash flow from operation, cash flow from investing, cash flow from financing and closing cash balances. Comment on the trends of each of the items.arrow_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