Please provide the answers in excel with formulas and explanation. Revenues: 2019 2020 Net Patient Service Revenue

Please provide the answers in excel with formulas and explanation.

Transcribed Image Text:

Revenues: 2019 2020 Net Patient Service Revenue $1,400 $1,200 Other Revenue 200 200 Total Revenues 1,600 1,400 Expenses: Nursing Services 1,320 11,150 Administrative Services 110 100 Depreciation 20 15 General Services 50 35 1,500 Total Expenses 1,300 Operating Income 100 100 Excess of Revenues over Expenses 100 100 1. Compute Silverlake Nursing Home's current ratio and compare it with standard. 2. Compute acid (or acid-test) ratio and compare it with standard. 3. Compute days in accounts receivable and compare it with standard. 4. Compute average payment period and compare it with standard. 5. Compute long-term debt to net assets ratio and compare it with standard. 6. Compute net assets to total assets ratio and compare it with standard. 7. Compute total asset turnover ratio and compare it with standard. 8. Compute fixed asset turnover ratio and compare it with standard/ 9. Compute return on total assets and compare it with standard/ 10. Compute operating margin and compare it with standard. Revenues: 2019 2020 Net Patient Service Revenue $1,400 $1,200 Other Revenue 200 200 Total Revenues 1,600 1,400 Expenses: Nursing Services 1,320 11,150 Administrative Services 110 100 Depreciation 20 15 General Services 50 35 1,500 Total Expenses 1,300 Operating Income 100 100 Excess of Revenues over Expenses 100 100 1. Compute Silverlake Nursing Home's current ratio and compare it with standard. 2. Compute acid (or acid-test) ratio and compare it with standard. 3. Compute days in accounts receivable and compare it with standard. 4. Compute average payment period and compare it with standard. 5. Compute long-term debt to net assets ratio and compare it with standard. 6. Compute net assets to total assets ratio and compare it with standard. 7. Compute total asset turnover ratio and compare it with standard. 8. Compute fixed asset turnover ratio and compare it with standard/ 9. Compute return on total assets and compare it with standard/ 10. Compute operating margin and compare it with standard.

Answer rating: 100% (QA)

As per the require... View the full answer