FINANCIAL ACCT.FUND.(LOOSELEAF)
7th Edition
ISBN: 9781260482867
Author: Wild
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Chapter 13, Problem 1PSA
To determine
Trend Percents:
A horizontal form of analysis which reveals a pattern in data across successive period is known as trend percents. In this analysis items are expressed as a percentage of a base year and items are taken line by line.
1.
To compute: Trend percents for income statement and
2.
To determine
To explain: Analyze financial statement and trend percents from part 1.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Not Graded
Using 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
Calculating trend analysis
Muscateer Corp reported the following revenues and net income amounts:
Requirements
Calculate Muscateer’s trend analysis for revenues and net income Use 2016 as the base year and round to the nearest percent.
Which measure increased at a higher rate during 2017-2019?
Calculate the Sales Growth of the most recent year. Enter answer as decimal (not percent. Example: .1234 is ok, 12.34% is not ok).
Chapter 13 Solutions
FINANCIAL ACCT.FUND.(LOOSELEAF)
Ch. 13 - Prob. 1MCQCh. 13 - Prob. 2MCQCh. 13 - Prob. 3MCQCh. 13 - Prob. 4MCQCh. 13 - Prob. 5MCQCh. 13 - Prob. 1DQCh. 13 - Prob. 2DQCh. 13 - Prob. 3DQCh. 13 - Prob. 4DQCh. 13 - Prob. 5DQ
Ch. 13 - Why is working capital given special attention in...Ch. 13 - Prob. 7DQCh. 13 - Prob. 8DQCh. 13 - Prob. 9DQCh. 13 - Prob. 10DQCh. 13 - What ratios would you compute to evaluate...Ch. 13 - Prob. 12DQCh. 13 - Prob. 13DQCh. 13 - Prob. 14DQCh. 13 - Prob. 15DQCh. 13 - Prob. 16DQCh. 13 - Prob. 17DQCh. 13 - Prob. 1QSCh. 13 - Prob. 2QSCh. 13 - Prob. 3QSCh. 13 - Prob. 4QSCh. 13 - Prob. 5QSCh. 13 - Prob. 6QSCh. 13 - Prob. 7QSCh. 13 - Prob. 8QSCh. 13 - Prob. 9QSCh. 13 - Prob. 10QSCh. 13 - Prob. 11QSCh. 13 - Prob. 12QSCh. 13 - Prob. 13QSCh. 13 - Prob. 14QSCh. 13 - Prob. 15QSCh. 13 - Prob. 1ECh. 13 - Prob. 2ECh. 13 - Prob. 3ECh. 13 - Prob. 4ECh. 13 - Prob. 5ECh. 13 - Prob. 6ECh. 13 - Prob. 7ECh. 13 - Prob. 8ECh. 13 - Prob. 9ECh. 13 - Prob. 10ECh. 13 - Analyzing profitability P3 Refer to Simon...Ch. 13 - Prob. 12ECh. 13 - Prob. 13ECh. 13 - Prob. 14ECh. 13 - Prob. 16ECh. 13 - Prob. 17ECh. 13 - Prob. 18ECh. 13 - Prob. 1PSACh. 13 - Prob. 2PSACh. 13 - Prob. 3PSACh. 13 - Prob. 4PSACh. 13 - Prob. 5PSACh. 13 - Prob. 6PSACh. 13 - Prob. 1PSBCh. 13 - Prob. 2PSBCh. 13 - Prob. 3PSBCh. 13 - Prob. 4PSBCh. 13 - Prob. 5PSBCh. 13 - Prob. 6PSBCh. 13 - Use the following selected data from Business...Ch. 13 - Use Apple’s financial statements in Appendix A to...Ch. 13 - Prob. 2AACh. 13 - Prob. 3AACh. 13 - Prob. 1BTNCh. 13 - Prob. 2BTNCh. 13 - Prob. 3BTNCh. 13 - Prob. 4BTNCh. 13 - Prob. 5BTNCh. 13 - Prob. 6BTN
Knowledge Booster
Similar questions
- Juroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: 1. Calculate the return on sales. (Note: Round the percent to two decimal places.) 2. CONCEPTUAL CONNECTION Briefly explain the meaning of the return on sales ratio, and comment on whether Juroes return on sales ratio appears appropriate.arrow_forwardThe 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.arrow_forwardFinancial statement data for years ending December 31 for Latchkey Company follows: a. Determine the ratio of sales to assets for 2016 and 2015. b. Does the change in the ratio of sales to assets from 2015 to 2016 indicate a favorable or an unfavorable trend?arrow_forward
- Ratio Analysis Consider the following information taken from the stockholders equity section: How do you interpret the companys payout and profitability performance? Required: 1. Calculate the following for 2020. (Note. Round answers to two decimal places.) 2. CONCEPTUAL CONNECTION Assume 2019 ratios were: and the current year industry averages are: How do you interpret the companys payout and profitability performance?arrow_forwardCuneo Companys income statements for the last 3 years are as follows: Refer to the information for Cuneo Company above. Required: 1. Prepare a common-size income statement for Year 1 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 2 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 3. Prepare a common-size income statement for Year 3 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.)arrow_forwardFinancial statement data for years ending December 31 for Holland Company follow: a. Determine the inventory turnover for 20Y4 and 20Y3. b. Determine the days sales in inventory for 20Y4 and 20Y3. Use 365 days and round to one decimal place. c. Does the change in inventory turnover and the days sales in inventory from 20Y3 to 20Y4 indicate a favorable or an unfavorable trend?arrow_forward
- Cuneo Companys income statements for the last 3 years are as follows: Refer to the information for Cuneo Company above. Required: 1. Prepare a common-size income statement for Year 2 by expressing each line item for Year 2 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 3 by expressing each line item for Year 3 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.)arrow_forwardRate of Change Analyses and Ratios Analyses The following are Cohen Companys comparative financial statements for 2020, 2019, and 2018: Additional information: Credit sales were 65% of net sales in 2019 and 60% in 2020. At the beginning of 2020, 400 shares of common stock were issued, the first sale of stock in several years. Cohen is concerned. Although it increased the dividends paid per share by 5% in 2020 and its 2020 net income is higher than 2019 net income, the market price of its common stock dropped from 22 per share at the beginning of 2020 to 21 per share at year-end. Required: 1. For 2019 and 2020, prepare rate of change analyses for the income statements and balance sheets of Cohen using a year-to-year approach. 2. For 2019 and 2020, compute the following ratios; (a) current, (b) inventory turnover, (c) receivables turnover, (d) net profit margin, (e) earnings per share, (f) return on total assets, (g) return on shareholders equity, and (h) debt-to-assets. 3. Next Level Based on your results, discuss the possible reasons for the decrease in the market price per share in 2020.arrow_forwardInventory Analysis Singleton Inc. reported the following information for the current year: Required: Compute Singletons (a) gross profit ratio, (b) inventory turnover ratio, and (c) average days to sell inventory. (Note: Round all answers to two decimal places.)arrow_forward
- Measures of liquidity, solvency, and profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was 82.60 on December 31, 20Y2. Instructions Determine the following measures for 20Y2, rounding to one decimal place, including percentages, except for per-share amounts: 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. Times interest earned 11. Asset turnover 12. Return on total assets 13. Return on stockholders equity 14. Return on common stockholders equity 15. Earnings per share on common stock 16. Price-earnings ratio 17. Dividends per share of common stock 18. Dividend yieldarrow_forwardRatio proficiency McDougal Printing, Inc., had sales totaling $35,000,000 in fiscal year 2019. Some ratios for the company are listed below. Use this information to determine the dollar values of various income statement and balance sheet accounts as requested. Assume a 365-day year. Calculate values for the following: a. Gross profits b. Cost of goods sold c. Operating profits d. Operating expenses e. Earnings available for common stockholders f. Total assets g. Total common stock equity h. Accounts receivable a. The gross profits are $ (Round to the nearest dollar.) McDougal Printing, Inc. Year Ended December 31, 2019 Sales Gross profit margin Operating profit margin Net profit margin Return on total assets Return on common equity Total asset turnover Average collection period C $35,000,000 84% 37% 8% 16.8% 19% 2.1 59.1 daysarrow_forwardSelected ratios of Company X are shown below: Inventory turnover Days' sales uncollected Days' purchases in accounts payable Total asset turnover Equity ratio Times interest earned 2021 5.3 32.4 21.0 2.6 0.8 N.A. 2020 7.1 18.3 20.0 2.5 0.8 N.A. Using the financial ratios provided, analyse the performance of Company X in 2021 compared to the previous year.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning