Finance Analysis Project Walgreens is the company that I considered invest and/or lend money Sinuncial expert, you prefer to the see 10 annual filing to answer the following questions: 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. b) Compute for 2019 and 2018 the (1) profit margin, (2) asset turnover, (3) return on assets and (1) return on common stockholders' equity. How would you evaluate the company's profitability? c) Compute for 2019 and 2018 the (1) current ratio and (2) working capital. How would you evaluate the company's liquidity? 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? c) Compute for 2019 and 2018 the (1) DuPont Analysis. How would you evaluate the company's expense control, asset utilization and debt utilization? 1) What information outside the annual report may also be useful to you decision to invest in or lend money to this company? 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? h) Statement of Cash Flows - Does the ending balance of cash and cash equivalents agree with the amount reported on the balance sheet? 1) Statement of Cash Flows - For 2019, list the amount of cash provided (or used) for Operating, Investing and Financing Activities. 1) Stockholder's Equity - For 2019, list all components of the Stockholder's Equity section of the Balance Sheet (including and Preferred Stock or Treasury Stock) k) Does the company mention the valuation of financial instruments? If so, provide the comment in the disclosure notes. D From the disclosure notes, how does your company classify financial assets? m) Does the company disclose any Contingencies in their 2019 disclosure notes? n) What were the earnings per share (basic and fully diluted) for the fiscal years ended 2019, 2018, 2017? o) In 2019, were the company's assets funded more with debt or equity? p) What countries does your company operate within? What is the primary country of its operations? What issues related to international accounting (Non-US GAAP) are mentioned in the annual report? 4) How does your company address Corporate Social Responsibility? What is your company's primary focus in regards to Corporate Social Responsibility? Please provide three examples of how your company participates in Corporate Social Responsibility. 1) Would you invest in or lend money to this company? Why or why not? (this answer should be a minimum of one paragraph in length) Finance Analysis Project Walgreens is the company that I considered invest and/or lend money Sinuncial expert, you prefer to the see 10 annual filing to answer the following questions: 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. b) Compute for 2019 and 2018 the (1) profit margin, (2) asset turnover, (3) return on assets and (1) return on common stockholders' equity. How would you evaluate the company's profitability? c) Compute for 2019 and 2018 the (1) current ratio and (2) working capital. How would you evaluate the company's liquidity? 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? c) Compute for 2019 and 2018 the (1) DuPont Analysis. How would you evaluate the company's expense control, asset utilization and debt utilization? 1) What information outside the annual report may also be useful to you decision to invest in or lend money to this company? 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? h) Statement of Cash Flows - Does the ending balance of cash and cash equivalents agree with the amount reported on the balance sheet? 1) Statement of Cash Flows - For 2019, list the amount of cash provided (or used) for Operating, Investing and Financing Activities. 1) Stockholder's Equity - For 2019, list all components of the Stockholder's Equity section of the Balance Sheet (including and Preferred Stock or Treasury Stock) k) Does the company mention the valuation of financial instruments? If so, provide the comment in the disclosure notes. D From the disclosure notes, how does your company classify financial assets? m) Does the company disclose any Contingencies in their 2019 disclosure notes? n) What were the earnings per share (basic and fully diluted) for the fiscal years ended 2019, 2018, 2017? o) In 2019, were the company's assets funded more with debt or equity? p) What countries does your company operate within? What is the primary country of its operations? What issues related to international accounting (Non-US GAAP) are mentioned in the annual report? 4) How does your company address Corporate Social Responsibility? What is your company's primary focus in regards to Corporate Social Responsibility? Please provide three examples of how your company participates in Corporate Social Responsibility. 1) Would you invest in or lend money to this company? Why or why not? (this answer should be a minimum of one paragraph in length)
