Assignment: 1- Read chapter 14 in your text. 2- View the Panopto lecture on Ratio Analysis. 3- Complete the deliverables below and submit via Canvas no later than Thursday, March 1 by 6:00pm. Deliverables: 1- To complete this module, use the financial statements found in the back of your text on pages 196- 198 (table 18-1 Statement of Financial Position; table 18-2 Statement of Operations; table 18-3 Statement of Cash Flows). 2- In this module are templates for Profitability ratios, Efficiency ratios and Liquidity ratios. All these templates are in excel format. You will populate the areas in red and the ratios will automatically be formatted for you. Please populate all three ratio analysis templates for the information displayed in the year 2013. 3- Some of the terms used in the templates may vary from the terms you are used to or the terms used in your text. Here are some hints: a. Marketable securities- not all organizations have marketable securities- if this hospital does not, you enter 0. b. Operating expenses in Happy Hospital = total expenses. c. Bad debt and uncollectible are used interchangeably in many organizations. d. Total net income is the Operating Income or loss. If the organization incurred a net loss, you would enter the number as a negative (for example: - 222,222). 4- Please answer the following questions. Each question can be answered in 1-2 sentences of bullets. a. Liquidity ratios i. To calculate, Days cash on hand, bad debts and depreciation are removed from the denominator? Why? ii. What do liquidity ratios tell us? iii. Why would too much liquidity be a problem for an organization? iv. Why would too little liquidity be a problem for an organization? v. What can you say about Happy Hospitals liquidity in 2013? Please substantiate your opinion. b. Profitability ratio i. Discuss when and why different profitability ratios might be used? ii. What does the return on asset ratio tell us? iii. What can you say about Happy Hospitals profitability in 2013? Please substantiate your opinion. c. Efficiency ratio i. Why is the timely collection of Accounts Receivable an issue for healthcare organizations? ii. Why should the days in accounts payable be longer than the days in accounts receivable? iii. What can you say about Happy Hospitals efficiency in 2013? Please substantiate your opinion. d. Overall evaluation i. Based on your ratio analysis of Happy Hospitals 2013 financial position, what is your overall impression of the financial health of this organization? Please substantiate your opinion with facts from the ratio analysis. Text book: Accounting fundamentals for health care management. 2nd e. by Finkler Chapter 14