To determine: All of listed ratios of Company ECY.
Financial ratios:
It refers to the measures of comparing and investing the relationships between various aspects of financial information.
Explanation of Solution
Given,
Company ECY has recently employed Person DE to provide assistance in the short-term financial planning and financial performance of the company. Person LW the founder of Company ECY has provided the below information to Person DE in order to start his analyses:
Inventory of the company is $6,627,300.
Current assets of the company are $15,823,700.
Current liabilities of the company care $21,320,300.
Sales of the company are $210,900,000.
Total assets of the company are $117,304,900.
Cost of goods sold is $148,600,000.
Accounts receivables of the company are $5,910,800.
Total debt of the company is
EBIT of the company is $30,229,000.
Interest of the company is $3,791,000.
Net income of the company is $$15,862,800.
Total equity of the company is $59,584,600.
The formula to calculate current ratio is,
Substitute $15,823,700 for current assets and $21,320,300 for current liabilities in the above formula.
Current ratio of the company is 0.74.
The formula to calculate quick ratio is,
Substitute $15,823,700 for current assets, $6,627,300 for inventory and $21,320,300 for current liabilities.
Quick ratio of the company is 0.43.
The formula to calculate asset turnover ratio is,
Substitute $210,900,000 for sales and $117,304,900 for total assets in the above formula.
Asset turnover ratio is 1.80.
The formula to calculate inventory turnover ratio is,
Substitute $148,600,000 for cost of goods sold and $6,627,300 in the above formula.
Inventory turnover ratio is 22.42.
The formula to calculate receivable turnover ratio is,
Substitute $210,900,000 for sales and $5,910,800 for accounts receivable in the above formula.
Receivable turnover ratio is 35.68.
The formula to calculate debt ratio is,
Substitute $57,720,300 for total debt and $117,304,900 for total assets in the above formula.
Debt ratio of the company is 0.49.
The formula to calculate debt equity ratio is,
Substitute $57,720,300 for total debt and $59,584,600 for total equity in the above formula.
Debt equity ratio of the company is 0.97.
The formula to calculate equity multiplier is,
Substitute $117,304,900 for total asset and $59,584,600 for total equity in the above formula.
Equity multiplier is 1.97.
The formula to calculate interest coverage ratio is,
Substitute $30,229,000 for EBIT and $3,791,000 for interest in the above formula.
Interest coverage ratio of the company is 7.97.
The formula to calculate profit margin is,
Substitute $15,862,800 for net income and $210,900,000 in the above formula.
Profit margin is 7.52%
The formula to calculate
Substitute $15,862,800 for net income and $117,304,900 for total asset.
Return on asset is 13.52%.
The formula to calculate
Substitute $15,862,800 for net income and $59,584,600 for total equity in the above formula.
Return on equity of the company is 26.62%.
Thus, the financial ratios help in comparing and investing the relationships between various aspects of financial information.
Want to see more full solutions like this?
Chapter 3 Solutions
Corporate Finance (The Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
- You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex CompanyComparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,010,000 $ 1,250,000 Marketable securities 0 300,000 Accounts receivable, net 2,900,000 2,000,000 Inventory 3,650,000 2,000,000 Prepaid expenses 270,000 210,000 Total current assets 7,830,000 5,760,000 Plant and equipment, net 9,620,000 9,100,000 Total assets $ 17,450,000 $ 14,860,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,060,000 $ 3,080,000 Note payable, 10% 3,700,000 3,100,000 Total liabilities 7,760,000 6,180,000…arrow_forwardYou have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex CompanyComparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,010,000 $ 1,250,000 Marketable securities 0 300,000 Accounts receivable, net 2,900,000 2,000,000 Inventory 3,650,000 2,000,000 Prepaid expenses 270,000 210,000 Total current assets 7,830,000 5,760,000 Plant and equipment, net 9,620,000 9,100,000 Total assets $ 17,450,000 $ 14,860,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,060,000 $ 3,080,000 Note payable, 10% 3,700,000 3,100,000 Total liabilities 7,760,000 6,180,000…arrow_forwardYou have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex CompanyComparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,010,000 $ 1,250,000 Marketable securities 0 300,000 Accounts receivable, net 2,900,000 2,000,000 Inventory 3,650,000 2,000,000 Prepaid expenses 270,000 210,000 Total current assets 7,830,000 5,760,000 Plant and equipment, net 9,620,000 9,100,000 Total assets $ 17,450,000 $ 14,860,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,060,000 $ 3,080,000 Note payable, 10% 3,700,000 3,100,000 Total liabilities 7,760,000 6,180,000…arrow_forward
- You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex CompanyComparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,010,000 $ 1,250,000 Marketable securities 0 300,000 Accounts receivable, net 2,900,000 2,000,000 Inventory 3,650,000 2,000,000 Prepaid expenses 270,000 210,000 Total current assets 7,830,000 5,760,000 Plant and equipment, net 9,620,000 9,100,000 Total assets $ 17,450,000 $ 14,860,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,060,000 $ 3,080,000 Note payable, 10% 3,700,000 3,100,000 Total liabilities 7,760,000 6,180,000…arrow_forwardYou have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex CompanyComparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,020,000 $ 1,260,000 Marketable securities 0 300,000 Accounts receivable, net 2,940,000 2,040,000 Inventory 3,660,000 2,100,000 Prepaid expenses 270,000 210,000 Total current assets 7,890,000 5,910,000 Plant and equipment, net 9,640,000 9,110,000 Total assets $ 17,530,000 $ 15,020,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,070,000 $ 3,100,000 Note payable, 10% 3,700,000 3,100,000 Total liabilities 7,770,000 6,200,000…arrow_forwardYou have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex CompanyComparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,020,000 $ 1,260,000 Marketable securities 0 300,000 Accounts receivable, net 2,940,000 2,040,000 Inventory 3,660,000 2,100,000 Prepaid expenses 270,000 210,000 Total current assets 7,890,000 5,910,000 Plant and equipment, net 9,640,000 9,110,000 Total assets $ 17,530,000 $ 15,020,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,070,000 $ 3,100,000 Note payable, 10% 3,700,000 3,100,000 Total liabilities 7,770,000 6,200,000…arrow_forward
- You have received $1,000,000 from an insurance policy that matured. You would like to invest some of that money in either Sagicor investments or Accesss limited- two companies that you believe are doing well financially. You decided to analyze the financial statements of the companies to help you decide which one is performing better. You discovered the following Sagicor Access Current ratio 3:1 2:3:1 Quick ratio 1:5:1 1:1:2 Debtor collection period 35 days 30 days Creditors payment period 40 days 25 days Inventory turnover 8 times 9 times Net income percentage 15% 11% Prepare a report comparing the performance of the companies and determine which one is better to invest.arrow_forwardAssignment 1 : Select a company. It is advised to choose the organization ( if it is listed ) where you are employed for this assignment. If your organization is not listed you may choose any other listed company from your industry or related industry. · Download last 3 years annual report. · Compute the financial ratios for last 3 years and see the trend [ Profitability ratios, Liquidity ratios, Activity Ratios, Financing Ratios, and Market Ratios ] . You need to do this exercise on an excel file. · Provide explanation on the strategic implications of these ratios on your company ’ s financial standing and strategy. You may explain in 2 - 3 lines for each category of ratios. [ Profitability ratios, Liquidity ratios, Activity Ratios, Financing Ratios, and Market Ratios ] . Use the same company as the one mentioned in Assignment 1 . • Part A: Strategic Analysis • Conduct a strategic analysis using PESTLE and Porter ’ s 5 forces tools for understanding the…arrow_forwardPhilip Spencer, the owner of Wholesome Foods, has hired you to evaluate his firm's financial performance. The firm's financial data is provided below, along with an average for the financial ratios that Spencer collected on several competing peer firms. Assets 2016 2017 2018 $ 21,000 $ 20,200 $ 25,000 Cash Accounts receivable 42,000 33,000 46,000 51,000 1.200 $ 115,200 650,000 (364,000) $ 286,000 $ 401,200 84,000 1,100 $ 138,300 664,000 (394,000) $ 270,000 $ 408,300 Inventory Prepaid rent 96,000 2,000 $ 169,000 740,000 (434,000| $ 306,000 $ 475,000 Total current assets Gross property, plant, and equipment Accumulated depreciation Net property, plant, and equipment TOTAL ASSETS Debt (Liabilities) and Equity Accounts payable 2016 $ 48,000 9,500 2017 2018 $ 52,400 12,000 $ 57,000 Accrued expenses 9,000 11.500 S 69,000 $ 160,000 $ 22,200 Short-term notes 9,000 $ 75,000 $ 150,000 $ 22,200 20,000 $ 84,400 $ 185,000 $ 34,500 Total current liabilities Long-tem debt Common stock Retained…arrow_forward
- You have recently been employed as a young Finance Director of Cloud 9 Ltd which is in the production of farm equipment and as part of the company's annual exercise to review the growth of the company, you are expected to write a recommendation letter to advise Managing Director and entire management on the future of the business operations. The financials below are to assist you in the best possible way with critical analytical tools to make an informed suggestion to the team. CLOUD 9 LTD STATEMENT OF COMPREHENSIVE INCOME FOR THE YEAR ENDED DECEMBER 31 2020 2019 2018 Turnover 373,578 424,486 456,300 Cost of sales (253,604) (254,210) (198,900) Gross profit 119,974 170,276 257,400 Impairment of financial assets (2,477) (1,800) Distribution costs (87,036) (91,309) Administrative expenses (32,556) (50,656) Other operating income 2,369 10,039 Operating profit 274 36,550 Finance income 2,594 4,949 Finance costs (2,069) (2,765) Profit before income tax 799 38,734 Income tax expense (285)…arrow_forwardYou have been asked by your CEO to evaluate, analyze and calculate commonly used ratios relating to a company’s profitability, liquidity, solvency and management efficiency. Requirement: Complete the balance sheet and sales data (fill in the blanks), using the following financial data: Debt/net worth 60% x 37,000 = 22,200 (debt) = AP Acid test ratio 1.2 x 22,200 = 26,640 Asset turnover 1.5 times Day sales outstanding in accounts receivable 40 days Gross profit margin 30% Inventory turnover 6 times Balance sheet Cash…arrow_forwardCompute Liquidity and Solvency Ratios for Competing Firms Halliburton and Schlumberger compete in the oil field services sector. Refer to the following 2018 financial data for the two companies to answer the requirements. $ millions Cash and equivalents Short-term investments Accounts receivable Current assets Current liabilities Total liabilities Total equity Earnings before interest and tax (EBIT) Interest expense, gross a. Compute the following measures for both companies. Note: Round your final answers to two decimal places (for example, enter 6.78 for 6.77555). 1. Current ratio 2. Quick ratio 3. Times interest earned 4. Liabilities-to-equity HAL SLB $2,008 $1,433 1,344 5,077 7,645 11,151 15,731 4,658 13,081 16,438 33,921 9,258 35,488 2,393 2,959 554 537 HAL 2.28 x 1.5 x 4.54 x 1.69 * SLB 1.114 x 0.79 x 5.79 * 0.91 x b. Which company appears more liquid? HAL c. Which company appears more solvent? SLB =arrow_forward
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning