Introduction To Managerial Accounting
8th Edition
ISBN: 9781259917066
Author: BREWER, Peter C., Garrison, Ray H., Noreen, Eric W.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Question
Chapter 14, Problem 7E
To determine
Determination of year on year trend of sales and operating assets and liabilities describes the computation sheet showing the year on year trend of change in sales and operating assets and liabilities of the company. The Trend computation is based on the Year-1 as base year.
Requirement1:
Computation of Year on year trend of the sales and current assets and liabilities.
Requirement2:
To determine
The Analysis of the result as computed above shall be made.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Rotorua Products, Ltd., of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company’s current assets, current liabilities, and sales have been reported as follows over the last five years (Year 5 is the most recent year):
image
$NZ stands for New Zealand dollars.
Required:
Express all of the asset, liability, and sales data in trend percentages. (Show percentages for each item.) Use Year I as the base year and carry computations to one decimal place.
Comment on the results of your analysis.
Payton Company has the following segment revenues for the two most recent fiscal years.
Segment
China
Canada
Other countries
Total revenues
Segment
Prepare a vertical analysis of the segment data. Calculate the percentage to four decimal places, then round your answer to one decimal place.
China
Canada
Other countries
Current Year (in millions)
$750
338
214
$1,302
Total revenues
Payton Company
Vertical Analysis
Current Year
Amount
(in millions)
$750
338
214
$1,302
Current Year
Percent
%
Prior Year (in millions)
$650
245
165
$1,060
%
Prior Year
Amount
(in millions)
$650
245
165
$1,060
Prior Year
Percent
%
%
Payton Company has the following segment revenues for the two most recent fiscal years.
Segment
Current Year (in millions)
Prior Year (in millions)
China
$770
$650
Canada
326
240
Other countries
212
168
Total revenues
$1,308
$1,058
Prepare a vertical analysis of the segment data. Calculate the percentage to four decimal places, then round your answer to one decimal
place.
Payton Company
Vertical Analysis
Current Year
Prior Year
Current Year
Percent
Prior Year
Segment
Amount
Amount
Percent
(in millions)
(in millions)
China
$770
$650
%
Canada
326
240
Other countries
212
168
Total revenues
$1,308
$1,058
Previous
Next
Chapter 14 Solutions
Introduction To Managerial Accounting
Ch. 14 - Prob. 1QCh. 14 - What is the basic purpose for examining trends in...Ch. 14 - Prob. 3QCh. 14 - Prob. 4QCh. 14 - What is meant by the dividend yield on a common...Ch. 14 - What is meant by the term financial leverage?Ch. 14 - Prob. 7QCh. 14 - Prob. 8QCh. 14 - Prob. 9QCh. 14 - Markus Company’s common stock sold for $2.75 per...
Ch. 14 - Markus Company’s common stock sold for $2.75 per...Ch. 14 - Markus Company’s common stock sold for $2.75 per...Ch. 14 - Markus Company’s common stock sold for $2.75 per...Ch. 14 - Markus Company’s common stock sold for $2.75 per...Ch. 14 - Markus Company’s common stock sold for $2.75 per...Ch. 14 - Markus Company’s common stock sold for $2.75 per...Ch. 14 - Markus Company’s common stock sold for $2.75 per...Ch. 14 - Markus Company’s common stock sold for $2.75 per...Ch. 14 - Markus Company’s common stock sold for $2.75 per...Ch. 14 - Prob. 11F15Ch. 14 - Prob. 12F15Ch. 14 - Prob. 13F15Ch. 14 - Prob. 14F15Ch. 14 - Prob. 15F15Ch. 14 - Common-Size Income Statement A comparative income...Ch. 14 - Prob. 2ECh. 14 - Prob. 3ECh. 14 - Financial Ratios for Debt Management Refer to the...Ch. 14 - Prob. 5ECh. 14 - Prob. 6ECh. 14 - Prob. 7ECh. 14 - Prob. 8ECh. 14 - Financial Ratios for Assessing Profitability and...Ch. 14 - Prob. 10ECh. 14 - Prob. 11ECh. 14 - Selected Financial Measures for Assessing...Ch. 14 - Effects of Transactions on Various Financial...Ch. 14 - Effects of Transactions on Various Ratios Denna...Ch. 14 - Prob. 15PCh. 14 - Common-Size Financial StatementsRefer to the...Ch. 14 - Interpretation of Financial Ratios Pecunious...Ch. 14 - Common-Size Statements and Financial Ratios for a...Ch. 14 - Financial Ratios for Assessing Profitability and...
Knowledge Booster
Similar questions
- 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_forwardJuroe 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_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_forward
- Sundahl Companys income statements for the past 2 years are as follows: Refer to the information for Sundahl 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.)arrow_forwardGrammatico Company has just completed its third year of operations. The income statement is as follows: Selected information from the balance sheet is as follows: Required: Note: Round answers to two decimal places. 1. Compute the times-interest-earned ratio. 2. Compute the debt ratio. 3. CONCEPTUAL CONNECTION Assume that the lower quartile, median, and upper quartile values for debt and times-interest-earned ratios in Grammaticos industry are as follows: How does Grammatico compare with the industrial norms? Does it have too much debt?arrow_forwardRotorua Products, Limited, of New Zealand markets agricultural products for the burgeoning Asian consumer market The company's current assets, current liabilities, and sales over the last five years (Year 5 is the most recent year) are as follows: Year 1 Year 2 Year 3 Year 4 Yeae S Sales $ 4,600, 790e $4,921,690 5 96,916 426, 158 70, 711 $1.393,785 $5,015,37e $ 5,543,20 S 17,60 $5,650,520 Cash Accounts receivable, net Inventory Total current assets $.95,408 407,016 507,300 451,111 833, 392 $1,371,80) 5 78,245 562,006 B4, 150 $1,479,622 $1,311,000 $1,549,3 Current 1labilities 5 302,390 5 327,119 $ 328,044 Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year (Round your percentage answers to 1 decimal plece (ie., 0.1234 should be entered as 12.3).) Year 1 Year 2 Year 3 Year 4 Year 5 Sales Current assets Cash Accounts receivable, net Inventory Total current assets Current labilitiesarrow_forward
- FINANCIAL RATIO: Requirement: Compute for the following financial ratios for the year 2021 (round-off answers to two decimal places) a. Current ratio b. Quick (Acid-test) ratio c. Working capital d. Inventory turnover e. Days of inventory (use 365 days) f. Accounts receivable turnover (assume all sales are on credit) g. Days of receivable (use 365 days) h. Debt ratio i. Equity ratio j. Debt-to-equity ratio k. Gross profit ratio 1. Net profit ratio m. Return on assets n. Return on equityarrow_forwardPayton Company has the following segment revenues for the two most recent fiscal years. Segment Current Year (in millions) Prior Year (in millions) China $790 $640 Canada 330 242 Other countries 213 167 Total revenues $1,333 $1,049 Prepare a vertical analysis of the segment data. Calculate the percentage to four decimal places, then round your answer to one decimal place. For percentages, do not enter the percent sign. Payton Company Vertical Analysis Segment Current Year Amount (in millions) Current Year Percent Prior Year Amount (in millions) Prior Year Percent China $790 % $640 % Canada 330 242 Other countries 213 167 Total revenues $1333 % $1049 %arrow_forwardHello! look at the attached images and answer: (a) Calculate ratios for the year ended 31 December 2021 (showing your workings) for Primrose Plc, equivalent to those provided above. i. Return on year-end capital employed ii. Net asset turnover iii. Gross profit margin iv. Net profit margin v. Current ratio vi. Closing inventory holding period vii. Trade receivables’ collection period viii. Trade payables’ payment period ix. Dividend yield x. 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. Thanks a lot!arrow_forward
- Examine the selected data over the 5-year period as shown in the table below for Dumbledore Ltd. Item Sales Cost of sales EBIT Interest NPAT Current assets Total assets current liabilities Total liabilities Equity Gross margin Interest coverage Current ratio 2021 $m 286.41 180.03 51.18 37.07 35.13 43.85 226.18 55.99 98.99 127.19 0.37 1.38 0.78 Year 2020 $m 280.80 166.69 51.08 33.70 35.10 43.20 221.75 53.58 91.66 130.09 0.41 1.52 0.81 2019 $m 275.29 154.35 50.98 30.64 35.06 42.56 217.40 51.27 84.87 132.53 0.44 1.66 0.89 2018 $m 269.89 142.91 50.88 27.85 35.03 41.93 213.13 49.06 78.58 134.56 0.47 1.83 U.OJ 2017 $m 264.60 134.19 49.88 25.32 34.51 41.31 206.93 47.40 74.48 132.44 0.49 1.97 0.87 2016 $m 252.00 126.00 48.90 24.00 34.00 40.70 200.90 45.80 70.60 130.30 0.50 2.04 0.89arrow_forwardRotorua Products, Limited, of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company's current assets, current liabilities, and sales over the last five years (Year 5 is the most recent year) are as follows: Sales Cash Accounts receivable, net Inventory Total current assets Current liabilities Sales Current assets: Cash Accounts receivable, net Inventory Total current assets Current liabilities Year 1 $4,593,830 $ 87,529 404,278 801,291 $ 1,293,098 $ 304,544 Year 1 Year 2 $4,780,780 $93,256 426,549 868,050 $ 1,387,855 $ 338,428 % % % % % % % % % % Year 3 $4,986,700 Required: 1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. (Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) ered as 12 Year 2 Year 3 $ 86,310 433,877 819,354 $ 1,339,541 $ 334,294 % % % % Year 4 $ 5,563,020 Year 4 $ 77,754 496,981 899,709 $1,474,444 $ 322,187 % % % % Year 5 $ 5,640,450…arrow_forwardVertical analysis of income statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: A. Prepare an income statement in comparative form, stating eachitem for both years as a percent of sales. (Round to the nearestwhole percentage.)B. Comment on the significant changes disclosed by thecomparative income statement.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,