Complete general journal, T accounts and trail balance

ember, the companredrnprated the following traniactiems. 7 ti.00 of defective mechandie wet returned fren a November je. deax me en accoven is Purchesed rupplies farcaihniage 20 Pa-d 1aleneb and wages 13,990 . 21. Paid 13,009 in adyance for heot years annual ivustanse 3) Paid Hecht Co in ful, lass disedunt. 21 Receved coliections in full less dacounts, fram tuatamers billed on Decembes an as Recrived sy doo from customers for services to be preformad in the furve a9 Purchase Equpment on account for taz,oos During December, the cempany completed the touewing uransactoons Dec: 6 Paid s3.500 for salanes and wages due employees, of which 11,500 is fer December and s3, 0os was accrued a November to salaties and wages parable 7. 5400 of defective merchandise was retumed from a Nove mber 30,2022 sal t on asceunt 8 Recened s2, Eoo cash from custemets in payment of account (no ditsount allowed). 1o Seld merchandise for cash 57,409 . The eest of the merchand se sold was 31, s4e (2 entries required) 13. Purchased meschandise on account from Hecht C0,46,200, termit 2/40,0/30 15 Purchased supplits for caah 12,250 18 5old merchandise on account 514,500 terms 3/20,5/30. The cest of the merchandise sold was 54,750 ao Paid salaries and woges 43,400 21 Paid 53,000 in advance for next year's annualinuvance 23 Paid Hecht Co in full less drscount 27 Peceived collections in full, 4 iss dikcounts, from customers bilied on December a 8 . 2B Received 51 , ogo from customess for services to be preformed in the future 29 Purchase flquigment on account for 112,000. Requiredi Complete each tab of this Excel Worktheet. General Joumal (all transactiont in December). Mup into T Accountu (add any if necesaryh prepare Triai Galance prepare the adjuating entries (a.6 above), Prepare Financial Statementa in good form (multirstepuncome itatement, otatenent of retained eamings balante iheot) prepare the closing entries, prepare the required ratio computations Part 1, complete the following tabs: Ceneral joumal, Adjusting Entries and T.Accounts. Part 2, complete the fellowing tabs: Trial Ealance, Financial Statements, Post Closing Entries, Ratio Camp AN Calits that are highilighted in Yelioe contein a formule and are the concect side of the T accsunt (left Deb, nght Credit belapce) 196=0 Eicel Project Spring 2023(1) File Horne Insert Draw Pagetayout Formulas Data Revien A 6 \begin{tabular}{|l|l|l|} \hline \multicolumn{2}{|c|}{ Equipment } \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} 12/31/2a21 \begin{tabular}{|l|r|r|} \hline \multicolumn{3}{|c|}{ Accumulated Depreciation-Equipment } \\ \hline & & \\ \hline & 12/31 & \\ \hline & & \\ \hline & \\ \hline \end{tabular} After Adj. 12/31/2021 \begin{tabular}{|l|c|c|} \hline \multicolumn{3}{|c|}{ Accounts Payable } \\ \hline & & \\ \hline & 12/31 & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} Before Adj Trial Balance Adjusting Enti Ready Befocmetility imersigigite Type here to search File Home Insert Draw Pagelayout Formulas Data Review View Automate Help \begin{tabular}{|l|c|c|} \hline \multicolumn{4}{|c|}{ Service Revenue } \\ \hline & & \\ \hline & 12/31 & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} After Adj. 12/31/2021 \begin{tabular}{|l|r|l|} \hline \multicolumn{3}{|c|}{ Sales Revenue } \\ \hline & & \\ \hline & 12/31 & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} After Adj. 155 12/31/2021 \begin{tabular}{l|l|l|l} Trial Balance & Adjusting Entries & Financial Statements & Post Clo; \\ \hline \end{tabular} After Adj. 12/31/2021 \begin{tabular}{|c|c|c|} \hline \multicolumn{2}{|c|}{ Depreciation Expense } \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} Rent Expense A 209 After Adj. 12/31/2021 210 211 Divine Distributing Company Trial Balances Divine Distribuing Company Income Statement (Multi-Step format) For the Month Ended December 31, 2022 Income From Operations Totat Operating Expenses Oeher Aevenues/thains Divine Distribuing Company Retained Earnings Statement For the Month Ended December 31, 2022 Retained Farnings as of December 31, 2022 0.00 0000.00 Divine Distribuing Company Balance Sheet December 31,2022 Current Assets General Journal Post Closing Entries