The following transactions occurred during the year. Record these transactions.

• HHL took out a long-term loan for $3 million.
• HHL purchased $1 million in inventory with cash.
• HHL purchased equipment that cost $150,000 on account. The equipment is expected to last 15 years and has no salvage value.
• $540,865,000 (net of allowances and charity care) was billed for patient services. The hospital estimates that 5% of these bills will be bad debt.
• $875,000 of inventory was used.
• Donations of $400,000 were received in cash.
• HHL pays in cash for a 2-year malpractice insurance premium at a cost of $5 million. One-half of the premium is for next year, and the other is for the following year.
• HHL pays $12,560,000 in accounts payable.
• HHL workers earned $259 million in wages for the year. The hospital paid out $282 million in cash. It also paid out $60 million in benefits, all in cash.
• The equipment purchased in transaction c was paid for in cash.
• $370,500,000 from bills sent to patients was received in cash.
• HHL collected $25 million in outstanding patient bills in cash.
• The board is concerned that too much debt outstanding is bad for the organization. The board chooses to accelerate their debt payments for the year. HHL paid out $51 million in long-term debt principal and $3 million of interest in cash.
• Depreciation for the year was recorded$23 million for existing fixed assets. Also, calculate the new depreciation necessary for the new equipment purchased this year, assuming straight-line depreciation.
• The contract with the IT company chosen is signed. The initial contract cost is paid, as well as the first-year payment.

3. Using these transactions, create financial statements for HHL for 2019 on the excel spreadsheet provided.

4. Calculate ratios for HHL to assess its financial strengths and weaknesses. Show your final results on the excel spreadsheet provided.