Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The income statement and balance sheet for GATA, Inc. are provided below. (Note that the reported figures are expressed in thousands of dollars). 2019 GATA,

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
The income statement and balance sheet for GATA, Inc. are provided below. (Note that the reported figures are expressed in thousands of dollars). 2019 GATA, INC. Balance Sheets as of December 31, 2018 and 2019 (in 000s) 2018 2019 2018 Assets Liabilities and Owners' Equity Current assets Current liabilities Cash $ 500 $1,000 Accounts payable $ 500 $ Accounts receivable 500 400 Notes payable 900 Inventory 900 600 700 700 Total $ 1,900 $2,000 Total $ 1,400 $ 1,400 $ 400 $ 600 Long-term debt Owners' equity Common stock Accumulated retained earnings $ 600 $ Fixed assets 621 579 500 Net plant and equipment $ 1,000 $ 1,200 Total Equity $ 1,100 $ 1,200 Total assets $2,900 $3,200 Total liabilities and owners' equity $2,900 $ 3,200 GATA, INC. 2019 Income Statement (in 000s) Sales $ Cost of goods sold Depreciation 1,700 1,030 100 ta $ EBIT Interest paid 570 70 Taxable income Taxes $ 500 105 Net income TA 395 $ 316 Dividends Retained earnings 79 Requirement #1: Calculate each of the following ratios for GATA Inc. for 2019 only and complete the table below. (Do not round intermediate calculations. Round your answers to 4 decimal places (e.g., 0.9173 or 2.1648). Input profit margin, return on assets, and return on equity as percentages (e.g., if the Profit Margin = 0.1576, input your answer as 15.76). a. Current ratio b. Quick ratio C. Total asset turnover d. Inventory turnover e. Total debt ratio f. Equity Multiplier g. Times interest earned ratio h. Profit margin i. Return on assets j. Return on equity 2019 1.4286 times 1.0000 times 0.5574 times 1.3733 times 0.6250 times 2.6667 8.1429 times 17.65% 9.84 % 26.09% Industry Average 1.2031 0.7814 0.5875 2.2791 0.3654 1.5757 6.9117 27.01% 15.87% 25.00% Requirement #2: Use the ratios you calculated in Requirement #1 and the industry averages given in the table above to determine if GATA, Inc. is "above average" or "below average" in each of the following areas of financial performance. Financial Leverage Asset Use Efficiency Operating Efficiency Liquidity Shareholder Return above average below average below average above average above average Requirement #3: Based on DuPont analysis, how would you explain the difference in the return on equity (ROE) for GATA, Inc. vs. the industry as a whole in 2019 (i.e., why is the ROE for GATA higher/lower than the ROE for the average firm in the industry)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

1119563097, 9781119563099

Students also viewed these Finance questions