Using the data, calculate on the following ratios Balance Sheet Assets Current Assets Cash AR Inventory Fixed
Fantastic news! We've Found the answer you've been seeking!
Question:
Using the data, calculate on the following ratios
Transcribed Image Text:
Balance Sheet Assets Current Assets Cash AR Inventory Fixed assets (net) Total AP Long-term debt Stockholder's Equity Common stock Paid-in Capital Retained Earnings Income statement Net sales Cost of goods sold Gross Margin Operating expenses Seling expenses Administrative expenses Net income Additional Information Average net receivables Average inventory Average assets Year 1 Current ratio Quick ratio A/R turnover Vertical Analysis 45.000 150,000 75.000 60.000 330,000 95,000 60,000 25,000 75,000 75.000 $330.000 50,000 60,000 15.000 155,000 65,000 330,000 14% 45% 23% 18% 100% 250,000 100% 125,000 50% 125,000 50% Collection ratio Inventory turnover Average number of days inventory is in stock Debt-to-Equity ratio Profit margin Asset turnover 8% 23% 29% 215,000 18% 60,000 Year 2 15,000 200,000 150,000 60,000 425,000 20% 24% 6% 23% 100% $425.000 25,000 75,000 50.000 450,000 300,000 150,000 4% 47% 210,000 130,000 425,000 35% 14% 100% 51% 14% 6% 18% 12% 100% 67% 33% 75,000 17% 100,000 22% (25.000) -6% Horizontal Analysis Change (30,000) 50,000 75,000 95,000 120,000 (25.000) 95.000 200,000 175,000 25,000 From the balance sheet and income statement shown above calculate and comment on the following ratios 25,000 40,000 (40,000) % Change -67% 33% 100% 0% 29% 126% 0% 0% 0% -33% 29% 80% 140% 20% 50% 67% -267% Balance Sheet Assets Current Assets Cash AR Inventory Fixed assets (net) Total AP Long-term debt Stockholder's Equity Common stock Paid-in Capital Retained Earnings Income statement Net sales Cost of goods sold Gross Margin Operating expenses Seling expenses Administrative expenses Net income Additional Information Average net receivables Average inventory Average assets Year 1 Current ratio Quick ratio A/R turnover Vertical Analysis 45.000 150,000 75.000 60.000 330,000 95,000 60,000 25,000 75,000 75.000 $330.000 50,000 60,000 15.000 155,000 65,000 330,000 14% 45% 23% 18% 100% 250,000 100% 125,000 50% 125,000 50% Collection ratio Inventory turnover Average number of days inventory is in stock Debt-to-Equity ratio Profit margin Asset turnover 8% 23% 29% 215,000 18% 60,000 Year 2 15,000 200,000 150,000 60,000 425,000 20% 24% 6% 23% 100% $425.000 25,000 75,000 50.000 450,000 300,000 150,000 4% 47% 210,000 130,000 425,000 35% 14% 100% 51% 14% 6% 18% 12% 100% 67% 33% 75,000 17% 100,000 22% (25.000) -6% Horizontal Analysis Change (30,000) 50,000 75,000 95,000 120,000 (25.000) 95.000 200,000 175,000 25,000 From the balance sheet and income statement shown above calculate and comment on the following ratios 25,000 40,000 (40,000) % Change -67% 33% 100% 0% 29% 126% 0% 0% 0% -33% 29% 80% 140% 20% 50% 67% -267%
Expert Answer:
Answer rating: 100% (QA)
Return on Assets ROA Year 1 Net Income Average Assets 40000 210000 19 Return on Assets ROA Year 2 Ne... View the full answer
Related Book For
Cornerstones of Financial and Managerial Accounting
ISBN: 978-1111879044
2nd edition
Authors: Rich, Jeff Jones, Dan Heitger, Maryanne Mowen, Don Hansen
Posted Date:
Students also viewed these accounting questions
-
Data for Obras Corporation in 2014 and 2013 follow. These data should be used in conjunction with the data in P1. In P1, Obras Corporations condensed comparative income statements and comparative...
-
The condensed comparative income statements and balance sheets of Basie Corporation appear on the next page. All figures are given in thousands of dollars, except earnings per share. Additional data...
-
Cash flow from operations was $700,000 for 2011 and $863,000 for 2012. Does this suggest that management of Great Oaks Furniture has manipulated earnings upward in these years? The following...
-
Suppose the weight of pieces of passenger luggage for domestic airline flights follows a normal distribution with u = 28 pounds and o = 5.7 pounds. (a) Calculate the probability that a piece of...
-
Derive the expression for the resonant frequency of a two-pole filter with poles at p1 = rel? And p2 = p1*. Given by +r? Cos wO cos w, COs-1 2r
-
Short circuits can cause severe damage when not interrupted promptly. In some cases, high-impedance fault currents may be insufficient to operate protective relays or blow fuses. Standard overcurrent...
-
In a laboratory test of a new automobile engine design carried out at the Colorado School of Mines, the emission rate (in milligrams per second) of oxides of nitrogen was measured for 32 engines at...
-
The village of Fay was recently incorporated and began financial operations on July 1, 2018, the beginning of its fiscal year. The following transactions occurred during this first fiscal year from...
-
a)Discuss whether it would be reasonable to assume positive or negative return spreads will be maintained forever". b) Discuss the advantages and disadvantages of shareholder value analysis (SVA). c)...
-
A division of your company purchased a large quantity of new desktop computers during the current fiscal year. An internal audit manager has asked you to audit the process used to acquire the...
-
What course of action should be taken for if there is assignable causes?
-
assume that the one year interest rate is 4 . 0 % in the united states ; the spot exchange rate is $ 1 . 2 5 / euro and the one year forward rate is $ 1 . 1 6 / euro . what must the one year interest...
-
Ureaseis an enzyme used by plants to break down (a nitrogen-containing compound) into carbon dioxide and ammonia. Plants need nitrogen to grow and can obtain it from ammonia, but not from urea. In...
-
The investments of Charger Inc. include an investment of trading securities of Raiders Inc. purchased on February 2 4 , 2 0 Y 7 , for $ 4 0 7 , 0 0 0 . The fair value of the securities on December 3...
-
Shrewd Corp. just paid a $ 1 . 2 5 per share dividend. Dividends will grow at a rate of 2 8 % for the next 8 years and then grow at a rate of 6 % in perpetuity. What is the current share price if the...
-
1. What is the average speed in mm / s through a 4 . 0 - mm - diameter tube of 2 0 C motor oil if the pressure gradient is 1 7 0 0 Pa / m ? 2. What is the average speed in mm / s through a 4 . 0 -...
-
The most important refactoring in object-oriented design is "Replacing conditional with polymorphism." Explain what you understand by this concept. (b) Describe three situations we have encountered...
-
Subtract the polynomials. (-x+x-5) - (x-x + 5)
-
What happens during the accounting cycle?
-
Fermi Company decided to look more closely at the materials receiving activity in its factory. The driver for receiving is the number of receiving orders. The following information for a year was...
-
Refer to the information for Filimonov Inc. and assume that the company uses a perpetual inventory system. Required: Calculate the cost of goods sold and the cost of ending inventory using the...
-
Why are most larger businesses not managed as a single unit by one manager?
-
What are the main advantages and disadvantages that should be considered when deciding between a partnership business and a limited liability company?
-
Suppose an item of information is capable of being provided. It is relevant to a particular decision, it is also reliable, comparable, can be understood by the decision maker concerned and is...
Study smarter with the SolutionInn App