I need help understanding where I am going wrong with the following questions. I sent it off to another tutor and most of my answers differed but the tutor didn't provide a thorough explanation or explain where their figures came from. Please solve and explain the formula and where you pulled the figures from. I have provided all the Financial Statements below and all 16 questions. I have a limited amount of time and a clear response not later than 8 am on 2/14. Thank you!!!

		Riverside Memorial
		Year Ended As of December 31, 2019
		Cash Flows
Cash Flows From Operating Activities
Operating Income	$ 6,474
Adjustments:
	Depreciation	$ 4,130
	Increase in Accounts Receivable	$ (1,102)
	Increase in Inventories	$ (195)
	Decrease in Accounts Payable	$ (438)
	Increase in Accrued Expenses	$ 229
		Net Cash Flow from Operations	$ 9,098
Cash Flow From Investing Activities
	Investment in Property and Equipment	$ (4,293)
	Investment in Short-Term Securities	$ (2,000)
		Net Cash Flow from Investing	$ (6,293)
Cash Flows From Financing Activities:
	Nonoperating Income	$ 2,098
	Repayment of Long-Term Debt	$ (2,150)
	Repayment of Notes Payable	$ (3,262)
	Capital Lease Principal Repayment	$ (323)
		Net Cash Flow From Investing	$ (3,637)
Net Increase (Decrease) in Cash and Equivalents	$ (832)
Beginning Cash and Equivalents	$ 3,095
Ending Cash and Equivalents	$ 2,263

		Riverside Memorial
		Year Ended As of December 31, 2019 and 2018
		Income Statement
Revenues:	2019	2018
	Patient Service Revenue	$ 106,502	$ 95,398
	Less: Provision for Bad Debts	$ 3,428	$ 3,519
		Net Patient Service Revenue	$ 103,074	$ 91,879
	Premium Revenue	$ 5,232	$ 5,622
	Other Revenue	$ 3,644	$ 6,014
		Net Operating Revenues	$ 111,950	$ 103,515
Expenses
	Nursing Services	$ 58,285	$ 56,752
	Dietary Services	$ 5,424	$ 4,718
	General Services	$ 13,198	$ 11,655
	Administrative Services	$ 11,427	$ 11,585
	Employee Health and Welfare	$ 10,250	$ 10,705
	Malpractice Insurance	$ 1,420	$ 1,304
	Depreciation	$ 4,130	$ 4,025
	Interest Expense	$ 1,564	$ 1,543
		Total Expenses	$ 105,698	$ 102,287
	Operating Income	$ 6,252	$ 1,228
	Non-operating Income	$ 2,098	$ 1,995
	Net Income	$ 8,350	$ 3,223

	Riverside Memorial
	As of December 31, 2019 and 2018
	Balance Sheet
		2019	2018
Cash and Equivalents	$ 2,163	$ 2,895
Short-Term Investments	$ 4,000	$ 3,022
Net Patient Accounts Receivable	$ 21,840	$ 20,701
Inventories	$ 3,177	$ 2,982
	Total Current Assets	$ 31,180	$ 29,600
Gross Property and Equipment	$ 145,158	$ 140,865
Accumulated Depreciation	$ 25,160	$ 21,030
	Net Property and Equipment	$ 119,998	$ 119,835
Total Assets	$ 151,178	$ 149,435
Accounts Payable	$ 4,607	$ 4,945
Accrued Expenses	$ 5,650	$ 5,421
Notes Payable	$ 2,975	$ 6,200
	Total Current Liabilities	$ 13,232	$ 16,566
Long-Term Debt	$ 28,750	$ 30,900
Capital Lease Obligations	$ 1,832	$ 3,177
	Total Long-Term Liabilities	$ 30,582	$ 34,077
Net Assets (Equity)	$ 107,364	$ 98,792
Total Liabilities and Net Assets	$ 151,178	$ 149,435

For Questions #1-8, in the Excel document provided - use the numbers for Riverside Memorial 2018

#1. Using "Chapter 17 - Financials in Excel," what is the Return on Assets Ratio for Riverside Memorial in 2018? ROA=Return on Assets = Net Income / Total Assets= 5.5% #2. Using "Chapter 17 - Financials in Excel," what is the Current Ratio for Riverside Memorial in 2018?

Current Ratio= Current Assets / Current Liabilities= 1.8 #3. Using "Chapter 17 - Financials in Excel," what is the Days Cash on Hand for Riverside Memorial in 2018?

Days Cash on Hand = (Cash + Short-Term Investments)/(Expenses-Depreciation)/365

=2,895 + 3,022/ ((102,287- 4,025)/365)

=5,917/269.21

=21. 98 days #4. Using "Chapter 17 - Financials in Excel," what is the Average Collection Period / Days in Accounts Receivable for Riverside Memorial in 2018? I guessed on this question.

Days in Patient A/R = Net Patient AR / (Net Patient Service Revenue/ 365)

=82.2 Days #5. Using "Chapter 17 - Financials in Excel," what is the Debt Ratio for Riverside Memorial in 2018?

Debt Ratio = Total Debt / Total Assets

= (Total Currentl Liability + Total Long-Term Liability)/ Total Assets

= ( 16,566 + 34,077)/ 29,600

=1.71 #6. Using "Chapter 17 - Financials in Excel," what is the Debt to Equity Ratio for Riverside Memorial in 2018? Debt to Equity Ratio = Total Debt / Total Equity

= Total Current Liabilty + Totoal Long-Term Liability/ Total Equity

= 34,077 +16,566 / 98,792

=0.51 #7. Using "Chapter 17 - Financials in Excel," what is the Times Interest Earned Ratio for Riverside Memorial in 2018? I guessed on this question.

Times Interest Earned Ratio = (EBIT) / Interest Expense

=Net Income + Interest + Taxes (if a for-profit)/Interest Exp.

=3,223+1543/1543=4766/1543=3.1 #8. Using "Chapter 17 - Financials in Excel," what is the Fixed Assets Turnover Ratio for Riverside Memorial in 2018?

Fixed Asset Turnover = Total Revenue / Net Fixed Assets

= Net Operating Revs + Non-operating Income/ Net Fixed Assets

= 103,515 + 1995/ 119,835

=0.89

For Questions #9-16, in the Excel document provided - use the numbers for Heart Hospital

	The Heart Hospital
	As of September 30, 2019 (in thousands)
		2019
Current Assets
	Cash	$ 15,500
	Accounts Receivable, Net	$ 5,941
	Medical Supplies Inventory	$ 1,111
	Prepaid Expense and Other Current Assets	$ 1,429
Total Current Assets	$ 23,981
	Property, Plant and Equipment, Net	$ 34,200
	Other Assets	$ 901
Total Assets	$ 59,082	C11+C12+C13
Current Liabilities
	Accounts Payable	$ 2,231
	Accrued Compensation and Benefits	$ 2,443
	Other Accrued Liabilities	$ 2,843
	Current Portion of Long-Term Debt	$ 2,064
Total Current Liabilities	$ 9,581	SUM(C17:C20)
	Long-Term Debt	$ 22,071
Total Liabilities	$ 31,652	C22+C21
	Owners' Equity	$ 27,430
Total Liabilities and Owners' Equity	$ 59,082	C24+C23

The Heart Hospital
Statement of Operations
Year Ended September, 30, 2019 (in thousands)
Revenues:
	Patient Service Revenue net of Discounts and Allowances	$ 80,550
	Provision for Bad Debt	$ (2,300)
	Net Patient Service Revenue	$ 78,250
Operating Expenses:
	Personnel Expense	$ 21,707
	Medical Supplies Expense	$ 16,047
	Other Operating Expense	$ 9,721
	Depreciation Expense	$ 2,625
	Interest Expense	$ 1,322
	Total Operating Expense	$ 51,422
Income from Operations	$ 26,828
Non-Operating Income	$ 650
Net Income	$ 27,478

#9. Using "Chapter 17 - Financials in Excel," what is the Return on Assets Ratio for The Heart Hospital? Return on Assets = Net Income / Total Assets

=27,478/ 59,082

= 46.5%

#10. Using "Chapter 17 - Financials in Excel," what is the Current Ratio for The Heart Hospital?

Current Ratio = Current Assets / Current Liabilities

=23,981/ 9,581 = 2.50

#11. Using "Chapter 17 - Financials in Excel," what is the Days Cash on Handfor The Heart Hospital?

Days Cash on Hand = (Cash + Short-Term Investments) / ((Expenses - Depreciation) / 365)

=15,500/((51,422-2625)/365)

=15,550/133.69

=115.939 Days

*** This answer differs from the other tutor and I have not recalculated it several times and have come up tieh the same answer. #12. Using "Chapter 17 - Financials in Excel," what is the Average Collection Period/Days in Accounts Receivablefor The Heart Hospital?

I have no clue how to solve it.

#13. Using "Chapter 17 - Financials in Excel," what is the Debt Ratio for The Heart Hospital?

Debt Ratio = Total Debt / Total Assets

= Total Liabilities: 31,652/ Total Assets: 59,082

= 0.54

#14.Using "Chapter 17 - Financials in Excel," what is the Debt to Equity Ratio for The Heart Hospital? Debt to Equity Ratio = Total Debt / Total Equity

= 31,652/ 27,430(Owner's Equity)

=1.15

#15. Using "Chapter 17 - Financials in Excel," what is the Times Interest Earned Ratio for The Heart Hospital? I am confused about how to solve it.

Times Interest Earned Ratio = Earnings Before Interest and Taxes (EBIT) / Interest Expense

#16. Using "Chapter 17 - Financials in Excel," what is the Fixed Assets Turnover Ratio for The Heart Hospital?

Fixed Asset Turnover = Total Revenue / Net Fixed Assets

=(Net Operating Rev. + Non-operating Income)/ Net P& Equip.

= 78,250+650/ 34,200

=2.307