Financial Ratio Analysis of Garfield, Inc.

Comparative financial statement data of Garfield, Inc. follow:

GARFIELD INC.
Comparative Income Statement
Years Ended December 31, 2018 and 2017
2018 2017
Net Sales Revenue $461,000 $424,000
Cost of Goods Sold 241,000 211,000
Gross Profit 220,000 213,000
Operating expenses 137,000 135,000
Income from Operations 83,000 78,000
Interest Expense 9,000 13,000
Income Before Income Tax 74,000 65,000
Income Tax Expense 18,000 24,000
Net Income $56,000 $41,000

GARFIELD INC.
CompararativeBalance Sheet
December 31 2018 and 2017
Assets 2018 2017 Liabilities 2018 2017
Current Assets: Total Current Liabilities $227,000 $246,000
Cash 99,000 98,000 Long-term Liabilities 117,000 100,000
Accounts Receivable, Net 108,000 114,000 Total Liabilities 344,000 346,000
Merchandise Inventory 146,000 164,000
Prepaid Expenses 20,000 9,000
Total Current Assets 373,000 385,000 Stockholders' Equity
Property, Plant, and Equip 211,000 181,000
Total Assets $584,000 566,000 Preferred Stock 3% 98,000 98,000
Common Stockholders' Equity, no par 142,000 122,000
Total Liabilities and Stockholders' Equity $584,000 $566,000

  1. Market price of Garfield's common stock: $69.36 at December 31, 2018, and $38.04 at December 31, 2017
  2. Common shares outstanding 14,000 on December 31, 2018, and 12,000 on December 31, 2017 and 2016
  3. All sales are on credit

Requirements:
Compute the following ratios below for Year 2018 and 2017 (round to two places)
A. Compute the Current Ratio for year 2018
B. Compute the Cash Ratio for year 2018
C. Compute the Times-interest-earned ratio for year 2018
D. Compute the Inventory turnover for year 2018
E. Compute the Gross Profit Percentage for year 2018
F. Compute the Debt to Equity Ratio for year 2018
G. Compute the Rate of return on common stockholders' equity for year 2018
H. Compute the Earnings per share for year 2018
I. Compute the Price/Earnings Ratio for year 2018

Compute the following ratios below for Year 2018 and 2017 (round to two places)
A. Compute the Current Ratio for year 2017
B. Compute the Cash Ratio for year 2017
C. Compute the Times-interest-earned ratio for year 2017
D. Compute the Inventory turnover for year 2017
E. Compute the Gross Profit Percentage for year 2017
F. Compute the Debt to Equity Ratio for year 2017
G. Compute the Rate of return on common stockholders' equity for year 2017
H. Compute the Earnings per share for year 2017
I. Compute the Price/Earnings Ratio for year 2017

  Financial Ratio Analysis of Garfield, Inc. Introduction Financial ratios are essential tools for analyzing a company's performance and financial health. By comparing ratios over different periods, stakeholders can identify trends, strengths, and weaknesses within the organization. This essay will compute and analyze several financial ratios for Garfield, Inc. for the years ended December 31, 2018, and 2017. The calculated ratios will provide insights into the company's liquidity, profitability, leverage, and market performance. Financial Ratios Computation Year 2018 1. Current Ratio [ \text{Current Ratio} = \frac{\text{Total Current Assets}}{\text{Total Current Liabilities}} = \frac{373,000}{227,000} \approx 1.64 ] 2. Cash Ratio [ \text{Cash Ratio} = \frac{\text{Cash}}{\text{Total Current Liabilities}} = \frac{99,000}{227,000} \approx 0.44 ] 3. Times-interest-earned Ratio [ \text{Times-Interest-Earned} = \frac{\text{Income Before Income Tax} + \text{Interest Expense}}{\text{Interest Expense}} = \frac{74,000 + 9,000}{9,000} \approx 9.22 ] 4. Inventory Turnover [ \text{Inventory Turnover} = \frac{\text{Cost of Goods Sold}}{\text{Average Inventory}} = \frac{241,000}{\frac{146,000 + 164,000}{2}} \approx 1.67 ] 5. Gross Profit Percentage [ \text{Gross Profit Percentage} = \frac{\text{Gross Profit}}{\text{Net Sales Revenue}} \times 100 = \frac{220,000}{461,000} \approx 47.7% ] 6. Debt to Equity Ratio [ \text{Debt to Equity Ratio} = \frac{\text{Total Liabilities}}{\text{Total Stockholders' Equity}} = \frac{344,000}{142,000} \approx 2.43 ] 7. Rate of Return on Common Stockholders' Equity [ \text{Rate of Return} = \frac{\text{Net Income}}{\text{Common Stockholders' Equity}} \times 100 = \frac{56,000}{142,000} \approx 39.44% ] 8. Earnings per Share (EPS) [ \text{EPS} = \frac{\text{Net Income}}{\text{Common Shares Outstanding}} = \frac{56,000}{14,000} = 4.00 ] 9. Price/Earnings Ratio [ \text{Price/Earnings Ratio} = \frac{\text{Market Price per Share}}{\text{EPS}} = \frac{69.36}{4.00} \approx 17.34 ] Year 2017 1. Current Ratio [ \text{Current Ratio} = \frac{\text{Total Current Assets}}{\text{Total Current Liabilities}} = \frac{385,000}{246,000} \approx 1.56 ] 2. Cash Ratio [ \text{Cash Ratio} = \frac{\text{Cash}}{\text{Total Current Liabilities}} = \frac{98,000}{246,000} \approx 0.40 ] 3. Times-interest-earned Ratio [ \text{Times-Interest-Earned} = \frac{\text{Income Before Income Tax} + \text{Interest Expense}}{\text{Interest Expense}} = \frac{65,000 + 13,000}{13,000} \approx 6.00 ] 4. Inventory Turnover [ \text{Inventory Turnover} = \frac{\text{Cost of Goods Sold}}{\text{Average Inventory}} = \frac{211,000}{\frac{164,000 + 146,000}{2}} \approx 1.30 ] 5. Gross Profit Percentage [ \text{Gross Profit Percentage} = \frac{\text{Gross Profit}}{\text{Net Sales Revenue}} \times 100 = \frac{213,000}{424,000} \approx 50.24% ] 6. Debt to Equity Ratio [ \text{Debt to Equity Ratio} = \frac{\text{Total Liabilities}}{\text{Total Stockholders' Equity}} = \frac{346,000}{122,000} \approx 2.84 ] 7. Rate of Return on Common Stockholders' Equity [ \text{Rate of Return} = \frac{\text{Net Income}}{\text{Common Stockholders' Equity}} \times 100 = \frac{41,000}{122,000} \approx 33.61% ] 8. Earnings per Share (EPS) [ \text{EPS} = \frac{\text{Net Income}}{\text{Common Shares Outstanding}} = \frac{41,000}{12,000} = 3.42 ] 9. Price/Earnings Ratio (Assuming the market price for 2017 is the same as the market price for December 31): ( P/E Ratio = 38.04 / EPS (3.42) ≈ 11.12 (Note: The actual market price may vary) \ Conclusion Analyzing the financial ratios of Garfield Inc. for the years 2018 and 2017 reveals significant insights about the company's performance over time. An increase in the current ratio suggests improved liquidity in 2018 compared to 2017. Furthermore, the reduction in interest expense has positively affected the times-interest-earned ratio, indicating a stronger ability to cover interest obligations. The gross profit percentage indicates a decline from 50.24% in 2017 to approximately 47.7% in 2018; however, the net income increased significantly from $41,000 to $56,000 during this period. The debt-to-equity ratio indicates that Garfield is becoming more leveraged but remains manageable. Overall, Garfield Inc.'s financial health shows positive trends in profitability and liquidity from 2017 to 2018 while reflecting areas that require monitoring and improvement in operational efficiency and cost management strategies moving forward.

Sample Answer