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: Year 1 Year 2 Year 3 Year 4 Year 5 Sales $ 4,629,850 $ 4,882,820 $ 5,051,360 $ 5,561,430 $ 5,779,850 Cash $ 92,281 $ 100,754 $ 100,089 $ 88,760 $ 74,387 Accounts receivable, net 400,699 434,827 445,236 507,424 568,470 Inventory 805,036 874,663 822,264 897,114 903,388 Total current assets $ 1,298,016 $ 1,410,244 $ 1,367,589 $ 1,493,298 $ 1,546,245 Current liabilities $ 317,424 $ 340,337 $ 332,468 $ 321,672 $ 391,861 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).)

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: Year 1 Year 2 Year 3 Year 4 Year 5 Sales $ 4,629,850 $ 4,882,820 $ 5,051,360 $ 5,561,430 $ 5,779,850 Cash $ 92,281 $ 100,754 $ 100,089 $ 88,760 $ 74,387 Accounts receivable, net 400,699 434,827 445,236 507,424 568,470 Inventory 805,036 874,663 822,264 897,114 903,388 Total current assets $ 1,298,016 $ 1,410,244 $ 1,367,589 $ 1,493,298 $ 1,546,245 Current liabilities $ 317,424 $ 340,337 $ 332,468 $ 321,672 $ 391,861 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).)

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 11MCQ

See similar textbooks

	Year 1	Year 2	Year 3	Year 4	Year 5
Sales	$ 4,629,850	$ 4,882,820	$ 5,051,360	$ 5,561,430	$ 5,779,850
Cash	$ 92,281	$ 100,754	$ 100,089	$ 88,760	$ 74,387
Accounts receivable, net	400,699	434,827	445,236	507,424	568,470
Inventory	805,036	874,663	822,264	897,114	903,388
Total current assets	$ 1,298,016	$ 1,410,244	$ 1,367,589	$ 1,493,298	$ 1,546,245
Current liabilities	$ 317,424	$ 340,337	$ 332,468	$ 321,672	$ 391,861

Similar questions

= 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.…
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
a. Compute the current ratio for the current year. (Abbreviations used: STI = Short-term investments. Round your answer to two decimal places, X.XX.) Current ratio More Info a. Current ratio b. Cash ratio c. Acid-test ratio d. Inventory turnover e. Days' sales in inventory f. Days' sales in receivables g. Gross profit percentage Print Done Choose from any list or enter any number in the input fields a Financial Statements Balance Sheet: Cash Short-term Investments Net Accounts Receivables Merchandise Inventory Prepaid Expenses Total Current Assets Total Current Liabilities Income Statement: Net Credit Sales Cost of Goods Sold $ Current Year Preceding Year 15,000 $ 11,000 56,000 64,000 13,000 159,000 132,000 465,000 317,000 29,000 27,000 94,000 82,000 7,000 239,000 89,000
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.
Required: (a) You are required to calculate the following ratios:(i) Gross profit margin(ii) Operating profit margin(iii) Expenses to sales(iv) Return on Capital Employed(v) Asset turnover(vi) Non-current asset turnover(vii) Current Ratio(viii) Quick Ratio(ix) Inventory days(x) Receivables days(xi) Payable days(xii) Interest cover (b) In light of your calculations comment on the performance of the company over thelast two years.
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}
Compute the Quick ratio if Current Assets: 10.354; Current Liabilities: 6.615; Inventory: 5.767; Cash: 1.013.a) 0.69 timesb) 0.75 timesc) 0.72 timesd) 0.15 times
Compute the following ratiosat December 31, 2019: i.Current ratio ii.Acid-test Ratio iii.Account Receivables Turnover iv.Average collection period v.Inventory Turnover vi.Days in inventory vii.Profit margin viii.Debts to Asset ratio ix.Return on Assets x.Times Interest Earned
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 %
How do you calculate net sales? Also... Do you only look at current year data or do you factor previous year data and current year? Thx
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
The formula for current ratio is Select one: a. Current Assets plus current liablities b. Current assets less current liablities c. Current assets divided by current liablities d. Current assets divided by current liablities x 100