Question: Using the annexes provided (specially #5), compare financial ratios over the years. Prepare an analysis for each ratio working for the years 2014 to 2017.

Using the annexes provided (specially #5), compare financial ratios over the years. Prepare an analysis for each ratio working for the years 2014 to 2017.
a. How do the liquidity ratios compare for the years 2014 to 2017? Please compare one year to another.
b. How do the solvency ratios (debt) compare for the years 2014 to 2017? Please compare one year to another.
c. How do the operational ratios compare for the years 2014 to 2017? Please compare one year to another.
d. How do the profit ratios (profitability) compare for the years 2014 to 2017? Please compare one year to another.

1 P.9 Exhibits Section INDICATOR Exhibit 5. Financial indicators of Carbostar 1.LIQUIDITY

1.1. Currentratio Currentassets/ currentliabilities 1.2.Acid test (Current assets-stock)/ currentliabilites 1.3. Workcapital Currentassets-current

liabilities (USD) 2. DEBT 2.1. Debtlevel Total liabilities/total assets 2.2. Interest coverage

1 P.9 Exhibits Section INDICATOR Exhibit 5. Financial indicators of Carbostar 1.LIQUIDITY 1.1. Currentratio Currentassets/ currentliabilities 1.2.Acid test (Current assets-stock)/ currentliabilites 1.3. Workcapital Currentassets-current liabilities (USD) 2. DEBT 2.1. Debtlevel Total liabilities/total assets 2.2. Interest coverage Operating income/ interest paid (times) 2.3. Totalleverage Total liabilitities/estate 3.OPERATIONAL 3.1 Accounts receivable tumover 3.2 Accounts payable turnover 3.3 Inventory turnover 4. PROFITABILITY 4.1. Gross margin (Gross profits/sales) *100 (%) 4.2. Operating income/sales (Operating income/sales)*100 (%) 4.3.Netmargin (Netiname/ sales) 100 (96) 4-4. Return on investment ROI = (Net income/total assets)*100 (%) 4-5. Return on investment ROE=*** (%) 4.8. EBITDA 4.9. EBITDA/INTERESTS 2014 2.49 2.27 0.79 1.75 3.81 102.09 24.21 11.24 0.07 0.06 557,833-91 311,94748 201,316.38 320,477.64 0.02 0.03 2015 0.09 1.37 1.25 0.57 4.13 1.34 61.95 2147 8.99 0.13 0.11 0.06 0.14 0.22 2016 1.20 8.87 1.06 0.50 4.01 1.00 47.99 37.94 9.62 0.15 0.11 0.08 0.20 0.29 2017 7:73 1.30 ** Since the pre-tax income is negative, a tax advantage was generated in the first two years. *** ROE= (Net income after taxes/Netsales) (Net sales/Total assets) (Total assets/ Stockholder's equity) *** Since the equity is negative, the profitability is negative. 1.12 045 7-53 0.81 74-17 68.25 16.74 0.17 0.12 0.07 88070721 1,042,38635 7471792.84 0.13 0.17 4.08

Step by Step Solution

★★★★★

3.49 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

A Liquidity Ratios 2014 Current Ratio 151 Quick Ratio 082 2015 Current Ratio 163 Quick Ratio 093 2016 Current Ratio 164 Quick Ratio 093 2017 Current R... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Do traditional solvency ratios adequately address financial condition analysis concerns?

Ratio analysis Required Match each of the following ratios with the formula used to compute it. 1. Working capital a. Net income + Average total stockholders' equity b. Cost of goods sold + Average...

Ratio analysis Required Match each of the following ratios with the formula used to computeit. 1. Working capital 2. Current ratio a. Net income Average total stockholders' equity b. Cost of goods...

You must analyze a potential new producta caulking compound that Cory Materials R&D people developed for use in the residential construction industry. Corys marketing manager thinks the company can...

Excerpted financial information from the records of The Gap, Inc., a major clothing retailer, follows (dollar in million s)" a. Compute the current ratio for each year.b. Compute the gross margin for...

Each of the following items must be considered in preparing a statement of cash flows for Buddy Guy Fashions Inc. for the year ended December 31, 2008. 1. Fixed assets that had cost $20,000 612 years...

Julia Vanfleet is professor of mathematics. She has received a $225,000 inheritance from her fathers estate, and she is anxious to invest it between now and the time she retires in 12 years....

In this simulation, you are asked to address various requirements regarding the accounting for receivables. Prepare responses to allparts. KWW Professlonal Simulation E Accounting for Receivables...

Sim Corporation, a 90 percent-owned subsidiary of Pal Corporation, was acquired on January 1, 2011, at a price of $45,000 in excess of underlying book value. The excess was due to goodwill. Separate...

Comparing return on investment and residual income Wells Corporation operates three investment centers. The following financial statements apply to the investment center named Huber Division....

What is the difference between strategy and planning?

Assume an imputation tax system and show the values for A, B, C and D below. Show all workings and attach a minus sign ('-') to the value if it is a cash outflow. (4 marks) Marginal tax rate 45% 19%...

7. In this exercise, you learn how to display a tooltip. Open the ToolTip Solution (ToolTip Solution.sln) file contained in the VB2012\Chap01\ToolTip Solution folder. If necessary, open the designer...

A 1.50-m cylinder of radius 1.10 cm is made of a complicated mixture of materials. Its resistivity depends on the distance x from the left end and obeys the formula p(x) = a + bx2, where a and b are...

The region between two concentric conducting spheres with radii a and b is filled with a conducting material with resistivity p. (a) Show that the resistance between the spheres is given by (b)...

Compare and contrast the methodologies used by Interbrand (www.interbrand.com) and BrandZ (www.brandz.com) to determine brand value. Explain why there is a discrepancy in the rankings from these two...

Toledo Limited is trying to determine the value of its ending inventory at February 28, 2012, the companys year-end. The accountant counted everything that was in the warehouse as of February 28,...

As completely as possible, analyze the campaign according to the steps listed in the chapter for developing effective marketing communication. This year, PepsiCo did something that shocked the...

write 13 math report card comments 2 -3 sentence each for a group of boys in a summer program where six were exemplary and 6 were average

256 CHAPTER 5 The Analysis of Financial Statements CASES Case 5.1 Intel Case The 2013 Intel Annual Report can be found at the following Web site: www.pearsonhighered.com/fraser. Using the annual...

i am needing shirt term liquidity ratios including credit worthiness. To respond to the discussion topic: You must post to enter the discussion board. You must post by midnight, Friday to receive...

Caltron Ltd. is 100 per cent owned by Pulsar Computer, which is one of the leading computer makers in North America. Caltron was started in 1971 by Pulsar's founder, Jenny Jones, to supply electronic...

Please help answer just part f. (in red) for this problem. I will be re-working it before I submit, but I need full guidance to better learn the concepts and how you got to them through Excel....

Due - Mar 15, 2021 Financial Statement Analysis Problem-A Comparative Analysis of Walmart Inc. and Target Corporation Description You have been hired by a local investment bank to provide a financial...