$1.$ Create a new column and compute the debt$-$to$-$income ratio for each hospital $($Total Liabilities divided by total assets$).$ Which hospital $($with necessary data available$)$ would be the least likely to be able to pay off its debts in the coming period?

$2.$ How many hospitals and hospital systems are operating at a reported loss for the fiscal year?

$3.$ In order to determine what type of patients a hospital is serving, hospital executives will examine the payer mix, which is often defined as the following: $($Medicare Reimbursement $+$ Medicaid Reimbursement$)/$Net Patient Revenue. Which hospital with the necessary data available serves the highest payer mix of government$-$funded patients? $($Note: The Medicaid program in California is known as Medi$-$Cal$)$

$4.$ Many states, including the state of California, evaluate hospitals$$ non$-$profit status by computing the ratio of charity care to net patient revenue. Hospital executives typically want to maintain this ratio anywhere from $1$ to $5$ percent. What is the charity care