1. The following transactions occurred during the year. Record these transactions. Need help filling out the provided spreadsheet

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

a. HHL took out a long-term loan for $3 million.

b. HHL purchased $1 million in inventory with cash.

c. HHL purchased equipment that cost $150,000 on the account. The equipment is expected to last 15 years and has no salvage value.

d. $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.

e. $875,000 of inventory was used.

f. Donations of $400,000 were received in cash.

g. 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.

h. HHL pays $12,560,000 in accounts payable.

i. HHL workers earned $259,000,000 in wages for the year. The hospital paid out $282,000,000 in cash. It also paid out $60 million in benefits, all in cash.

j. The equipment purchased in transaction c was paid for in cash.

k. $370,500,000 from bills sent to patients was received in cash. l. HHL collected $25 million in outstanding patient bills in cash.

m. The board is concerned that too much debt outstanding is bad for the organization. The board chooses to accelerate its debt payments for the year. HHL paid out $51 million in long-term debt principal and $3 million of interest in cash.

n. 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.

o. The contract with the IT company chosen is signed. The initial contract cost is paid, as well as the first-year payment.

\begin{tabular}{r|r|r|r|r|r|r|r|} 15534 & 51250 & 29183 & 5396 & 117686 & 55462 & 86109 & 8703 \\ \hline \end{tabular}