Reference no: EM132573365
Question a) Make a 5-year trend analysis in Excel, using 2015 as the base year, of total revenues, operating expenses, and net income. Comment on the significance of the trend results.
Question b) Compute for 2019 and 2018 the (1) profit margin, (2) asset turnover, (3) return on assets and (4) return on common stockholders' equity. How would you evaluate the company's profitability?
Question c) Compute for 2019 and 2018 the (1) current ratio and (2) working capital. How would you evaluate the company's liquidity?
Question d) Compute for 2019 and 2018 the (1) debt to total assets and (2) times interest earned ratio. How would you evaluate the company's long-term solvency?
Question e) Compute for 2019 and 2018 the (1) DuPont Analysis. How would you evaluate the company's expense control, asset utilization and debt utilization?
Question f) What information outside the annual report may also be useful to you decision to invest in or lend money to this company?
Question g) Statement of Cash Flows - What was the dollar amount of the increase or decrease in cash and cash equivalents for the fiscal years ended 2019, 2018, 2017?