please include formulas for excel. Thanks!

2. Recording and Reporting Liabilitics Excel Case Problem Applejack Company is the world's largest wholesale distributor of swimming pool supplies and equipment. It is a publicly traded corporation that trades on the NASDAQ exchange. It sells these products to swimming pool repair and service businesses, swimming pool builders, and retail swimming pool stores. The majority of these customers are small, family-owned businesses. Applejack Company completed the following transactions during 2021. The annual accounting period ends December 31, 2021. \begin{tabular}{|l|l|} \hline Sept 15 & Purchased and paid for merchandise for resale at an invoice cost of $100,000 \\ \hline Oot. 1 & Borrowed$800,000fromSouthwestBankforgeneraluse;signedan11-month,5%interest-bearingnotepayable. \\ \hline Oct. 5 & Receiveda$35,000customerdepositfromJoeJonesforservicestobeperformedinthefuture \\ \hline Oct 15 & Performed $18,000 of the services paid for by Mr. Jones \\ \hline Dec 12 & Received electric bill for $12,000. Smith will pay it in early January. \\ \hline Dec 31 & Determinedwagesof$50,000earmedbutnotyetpaidonDecember31st(disregardpayrolltaxes) \\ \hline \end{tabular} Required: Submit your answers below in an Ereel spreadsheet. Include formulas. 1. Prepare joumal entries for each of these transactions. 2. Prepare any adjusting entries required on December 31,2021