Rotorua Products, Limited, of New Zealand markets agricultural products for the burgeoning Asian consumer market. The company'scurrent assets, current liabilities, and sales over the last five years (Year 5 is the most recent year) are as follows:SalesCashAccounts receivable, netInventoryTotal current assetsCurrent liabilities.Year 1Year 2$4,639,470 $4,900,560$ 94,874407,463814,040Year 3$4,966,640$ 98,489425,592879,576$ 88,269441,540827,323$1,316,377 $ 1,403,657 $ 1,357,132$ 306,930 $333,191 $ 333,107Year 4Year 5$5,589,280 $ 5,687,010$ 74,298574,073$ 81,177499,839887,027900, 720$1,468,043 $ 1,549,091$ 331,411 $ 398,662 Required:1. Express all of the asset, liability, and sales data in trend percentages. Use Year 1 as the base year. (Round your percentage answersto 1 decimal place (i.e., 0.1234 should be entered as 12.3).)SalesCurrent assets:CashAccounts receivable, netInventoryTotal current assetsCurrent liabilitiesYear 1%%%%%%Year 2%%%%%%Year 3%%%%%%Year 4%%%%%Year 5%%%%%

Trend Analysis is a computation of trends for more than one financial year. Under this analysis…

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. Year 4 Year 5. $5,589,280 $5,687,010 Year 11 $4,639,470 $ 94,874 407,463 814,040 Year 2 Year 3 $4,900,560 $4,966,640 $ 98,489 $ 88,269 425,592 879,576 $ 74,298 $ 81,177 499,839 887,027 441,540 827,323 574,073 900,720 $1,316,377 $1,403,657 $ 1,357,132 $ 1,468,043 $ 1,549,091 $ 306,930 $ 333,191 $333,107 $ 331,411 $ 398,662

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. Year 4 Year 5. $5,589,280 $5,687,010 Year 11 $4,639,470 $ 94,874 407,463 814,040 Year 2 Year 3 $4,900,560 $4,966,640 $ 98,489 $ 88,269 425,592 879,576 $ 74,298 $ 81,177 499,839 887,027 441,540 827,323 574,073 900,720 $1,316,377 $1,403,657 $ 1,357,132 $ 1,468,043 $ 1,549,091 $ 306,930 $ 333,191 $333,107 $ 331,411 $ 398,662

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter12: Fainancial Statement Analysis

Section: Chapter Questions

Problem 81E

See similar textbooks

Similar questions

Required: Compute the following: (For Requirements 1 to 4, enter your percentage answers rounded to 2 decimal places (i.e., 0.1234 should be entered as 12.34).) 1. Gross margin percentage. 2. Net profit margin percentage. 3. Return on total assets. 4. Return on equity. 5. Was financial leverage positive or negative for the year? 1. Gross margin percentage % 2. Net profit margin percentage % 3. Return on total assets % 4. Return on equity % 5. Financial Leverage
= The current year financial statements for Blue Water Company and Prime Fish Company are presented below. Prime Fish Balance sheet Cash Accounts receivable (net) Inventory Property & equipment (net) Other assets Total assets Current liabilities Long-term debt (interest rate: 15%) Capital stock ($10 par value) Additional paid-in capital Retained earnings Total liabilities and stockholders' equity Income statement Sales revenue (1/2 on credit) Cost of goods sold Operating expenses Net income Other data Per share stock price at end of current year Blue Water $ 42,300 44,500 92,500 159,500 85,300 $ 424,100 $ 92,500 74,100 157,100 30,300 70,100 $ 424,100 $ 427,500 (234,500) (163,600) $ 29,400 $ 23.3 45% $ 19,700 34,900 47,800 416,600 318,000 $ 34,300 $ 837,000 $ 68,500 62,600 525,000 107,300 73,600 $ 837,000 $ 789,000 (401,300) (312,300) $ 75,400 $28 45% Average income tax rate Dividends declared and paid in current year Both companies are in the fish catching and manufacturing business.…
19. Using the following information, calculate the return on assets. Net income for November Total assets, November 1 5,000 76,000 Total assets, November 30 80,250 ... Identify the formula and then solve for return on assets (ROA). (Round the ROA to the nearest tenth percent, X.X%.) ÷ ROA %
2) Ratios Based on the information given in picture #1, complete the following ratios for the last TWO years and indicate whether the trend is favorable or unfavorable. Note percentages and times should be to one decimal place (e.g. 14.8%; 5.8x) Liq./Solv. Ratios Current Yr. Prior Yr. Fav/Unfav. Current Ratio (X) {Total. Current Assets/ Total Current Liabilities} Quick Ratio (X) {Cash + Short term Investments + Current Receivables/ Current Liabilities} Day's Sales Uncollected (days) {Total Accounts Receivables / Sales x 365}
Help me please
I Current ratioli. Times interest earnedjli. Inventory turnover¡v. Total asset turnoverv. Operating profit marginVi. Debt ratiovi. Average collection periodVii Fixed asset turnoverixReturn on equity
17) Based on the balance sheet given for Just Dew It, calculate the following financial ratios for each year: current ratio quick ration cash ratio NWC to total assets ratio debt-equity ratio and equity multiplier Total debt ratio and long-term debt ration
Problem 17-2A (Algo) Ratios, common-size statements, and trend percer [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income Assets Current assets Long-term investments Plant assets, net Total assets Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity 2021 $546,242 328,838 217,404 77,566 49,162 126,728 90,676 16,866 $ 73,810 Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income KORBIN COMPANY Comparative Balance Sheets December 31 2020 $ 418,466 263,634 2021 % 154,832 57,748 36,825 94,573 60, 259 12,353 $ 47,906 % $61,141 0 113,547…
Find the following using the data bellow Accounts receivable = 111,100,000 Current assets = 316,500,000 Total assets = 600,000,000 A. Return on assets B. Common equity C .Quick ratio
How to Compute the following ratios i. Gross Profit % ii. Operating profit % iii. Net Profit % iv. Current Ratio v. Acid Test Ratio vi. Cash Ratio vii. Cash Operating Cycle in days viii. Average Debt collection Period in days ix. Average Creditor Payment Period in days x. Average Stock Holding Period in days xi. Total liabilities to Total Equity Ratio xii. Interest Cover Ratio xiii. Return on Total Assets xiv. Return on Equity
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
PLASMA SCREENS CORPORATION Balance Sheets December 31, 2021 and 2020 2021 2020 Assets Current assets: Cash Accounts receivable Inventory Investments $242,000 98,000 105,000 5,000 $ 130,000 102,000 90,000 3,000 Long-term assets: Land Equipment Less: Accumulated depreciation 580,000 890,000 (528,000) $1,392,000 580,000 770,000 (368,000) $1,307,000 Total assets Liabilities and Stockholders' Equity Current liabilities: Accounts payable Interest payab le Income tax payable Long-term liabilities: Notes payable Stockholders' equity: Common stock Retained earnings $ 109,000 7,000 9,000 95,000 13,000 6,000 2$ 110,000 220,000 800,000 357,000 $1,392,000 $1,307,000 800,000 173,000 Total liabilities and stockholders' equity Additional information for 2021: 1. Net income is $184,000. 2. Sales on account are $1,890,000. 3. Cost of goods sold is $1,394,250.