Rotorua 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 % Year 1 $ 4,535,280 $ 92,821 403,397 804,295 $ 1,300,513 $ 305,913 % % % % % Year 2 % 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).) % % % % % Year 2 $ 4,911,560 . $ 107,723 421,454 875,720 $ 1,404,897 $ 349,246 Year 3 % % % % % % Year 3 $ 5,038,380 Year 4 $ 95,502 443,136 819,690 $ 1,358,328 $ 332,194 % % % % % % Year 4 $ 5,555,710 Year 5 $ 76,431 506,560 885,207 $ 1,468,198 "$ 331,180 % Year 5 $ 5,672,890 % % % % % $ 80,959 564,021 906,720 $ 1,551,700 $ 392,338

Rotorua 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 % Year 1 $ 4,535,280 $ 92,821 403,397 804,295 $ 1,300,513 $ 305,913 % % % % % Year 2 % 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).) % % % % % Year 2 $ 4,911,560 . $ 107,723 421,454 875,720 $ 1,404,897 $ 349,246 Year 3 % % % % % % Year 3 $ 5,038,380 Year 4 $ 95,502 443,136 819,690 $ 1,358,328 $ 332,194 % % % % % % Year 4 $ 5,555,710 Year 5 $ 76,431 506,560 885,207 $ 1,468,198 "$ 331,180 % Year 5 $ 5,672,890 % % % % % $ 80,959 564,021 906,720 $ 1,551,700 $ 392,338

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter15: Financial Statement Analysis

Section: Chapter Questions

Problem 39E: Cuneo Companys income statements for the last 3 years are as follows: Refer to the information for...

See similar textbooks

Similar questions

Subject : Accounting'
From the following information for BlueInks Corporation, compute the rate of return on assets. Hint: The numerator is income before interest expense and taxes. Net income $40,878 Total assets at beginning of year $250,100 Total assets at end of year $158,680 a. 15% b. 25% c. 16% d. 20%
Hello! 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!
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.89
Compare the following for the year 2019, 2020 and 2021 for the Acer Company: analysis in words incl. total assets, short term assets, long-term assets, non-current assets, return on assets, equity, equity growth or decrease over the years, Price-Earning ratio, liabilities.
Hello! 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!
Grammatico 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?
Calculate Forterra's cumulative translated gain/loss for 20X3 using the functional currency method.
Financial Statement Analysis Compute for Activity Ratios/Asset Management Ratios with Analysis for year 2018 - 2020: Average Age of Inventory Operating Cycle Fixed-Asset Turnover Ratio Total Asset Turnover
Mirabel Corporation's financial statements for 2020 follow: Sales...... Cost of goods sold. Gross profit.... Operating expenses. Income before taxes. Income taxes.. Net income.. MIRABELCORPORATION Statement of Income For the Year Ended July 31, 2020 Cash. Receivables. Inventory...... MIRABEL CORPORATION Statement of Financial Position July 31, 2020 Property, plant and equipment (net). Total assets. Current liabilities. Non-current liabilities. Common shares. Retained earnings.. Total liabilities and shareholders' equity. Calculate the current ratio (use up to two decimal places) $1,575,000 (976,500) 598,500 (236,250) 362,250 (144,900) $217,350 49,000 143,900 167,800 682,800 $1,043,500 $ 131,000 450,000 250,000 212,500 $1,043,500
Based on the financial statement information of Monster Inc. in the following table, answer the following questions: Unit in Million US$ accounts receivable annual sales Cost of goods depreciation fixed assets inventory 2019 150 71 31 Start of 2019 52 222 91 End of 2019 59 275 106 1) Calculate the Fixed-asset turnover, Inventory turnover ratio and Days receivable of Monster Inc 0.87 0.63 72 2) Compare the above results with the following industry average information, comment on their implications in terms of efficiency of asset utilisation. Industry average (Unit 2019 in Million US$) Fixed-asset turnover Inventory turnover ratio Days receivable
The balance sheet and income statement for the J. P. Robard Mfg. Company are as follows: LOADING... . Calculate the following ratios: Current ratio Times interest earned Inventory turnover Total asset turnover Operating profit margin Operating return on assets Debt ratio Average collection period Fixed asset turnover Return on equity J. P. Robard Mfg., Inc. Balance Sheet ($000) Cash $500 Accounts receivable 1,900 Inventories 1,020 Current assets $3,420 Net fixed assets 4,540 Total assets $7,960 Accounts payable $1,150 Accrued expenses 570 Short-term notes payable 260 Current liabilities $1,980 Long-term debt 1,910 Owners' equity 4,070 Total liabilities and owners' equity $7,960 (Click on the icon in order to copy its contents into a spreadsheet.) J. P. Robard Mfg., Inc. Income Statement ($000) Net sales (all credit) $8,040 Cost of goods…