Please complete in excel

P14-30A Journalizing liability transactions and reporting them on the balance sheet The following transactions of Emergency Pharmacies occurred during 2014 and 2015 2014 Borrowed $360,000 from Lessburg Bank. The six-year, 10% note requires payments due annually, on March 1. Each payment consists of $60,000 principal plus one year's interest Mar 1 Dec. 1 Mortgaged the warehouse for $200,000 cash with Saputo Bank. The mortgage requires monthly payments of $4,000. The interest rate on the note is 9% and accrues monthly. The first payment is due on January 1, 2015 31 Recorded interest accrued on the Saputo Bank note. Recorded interest accrued on the Lessburg Bank note 31 2015 Paid Saputo Bank monthly mortgage payment Paid Saputo Bank monthly mortgage payment. Jan. 1 Feb. 1 Mar. Paid Saputo Bank monthly mortgage payment. Paid first installment on note due to Lessburg Bank. Requirements 1. Journalize the transactions in the Emergency Pharmacies general journal Round all answers to the nearest dollar. Explanations are not required. 2. Prepare the liabilities section of the balance sheet for Emergency Pharmacies on March 1, 2015