Help me fill in the missing documents and report any errors I made. Thanks!
Account t. Unadjusted Trial Balance data locose stateset data: \begin{tabular}{|c|c|} \hline Advertising expense & 150,000 \\ \hline Bsd Debr Expense & - \\ \hline Cost of qoods sold & 3,500,000 \\ \hline Delivery expense & 30,000 \\ \hline Depescistion expense-offise buildinas snd squipment & 30,000 \\ \hline Depesciation expense-store buildings atrd squipment & 100,000 \\ \hline Gsis (Loss) on saset disposal & 1,935 \\ \hline Income tax expense & 140,500 \\ \hline Insurance expenge & - \\ \hline Interest expense & 21000 \\ \hline Interest revenue & 30.000 \\ \hline Miscellaneous administrative expense & 7,500 \\ \hline Miscelloneous selling expense & 15,500 \\ \hline Office tent expense & 50,000 \\ \hline Office salaries expense & 170,000 \\ \hline Office supplies expense & 10,000 \\ \hline Soles & 5,313,000 \\ \hline Soles sommissions & 185,000 \\ \hline \$oles salaries expense & 305,000 \\ \hline Store supplies expense & 21,000 \\ \hline \end{tabular} Balance shett data: \begin{tabular}{|c|c|} \hline Accounts payable & 194,300 \\ \hline Accounte receivable & 545,000 \\ \hline Aceumulsked deprecistion-offi buildinge and squipment & 1,580,000 \\ \hline Accumulated deprecistion-store buildings and equipment & 4,126,000 \\ \hline Allowsace for doubtful accounts & 8,450 \\ \hline Bondz paysble & 500,000 \\ \hline Cash & 2,650 \\ \hline \begin{tabular}{l} Conmon stock, $20 par (400,000 shores avthoriaed; 85,000 \\ shares issued, $4,600 oukstanding \end{tabular} & 1,700,000 \\ \hline Cvah dividends - comnon stock & 90,000 \\ \hline Cvah dividends-preferred skock & 40,000 \\ \hline \end{tabular} Diwidends Psusble-conmon stock 40,000 Diwidendz Paysble - preferred ztock Goodwill 675,000 \begin{tabular}{ll} Income tax payable & 44,000 \end{tabular} \begin{tabular}{ll} Intersot r
& Account \& Unadjusted TB data & Journ & al Entry data & Journal & \\ \hline \end{tabular} 2 Trial Balances Vorksheel Points Earned Step 4 XYZ Co, Trial Balancts Vorkstet. \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow[b]{3}{*}{ Arrest } & & \\ \hline & & & \multicolumn{2}{|c|}{ Adiverieg Entrier } & \multicolumn{2}{|c|}{ Adjurted 7 rial Elabace } \\ \hline & Dehit & Credit & Debit & Credit & Dehit & Credit \\ \hline Cask & 7217,650 & & & 813,053 & 205,15001010 & \\ \hline Assounte rscsinabis & 545000 & & 545,000 & & 545,000 & \\ \hline Allowarse for dosbetiul ascounts & & 8.450 & & 44680 & & 53,130 \\ \hline lestestrestionble & 1200 & & 131 & & 1231 & \\ \hline Merchasdite lewestery & 773000 & & 778,000 & & 778,000 & \\ \hline Prepaidlourese & 3000010000 & & 10,000 & & 20,000110,000 & \\ \hline Nete Bestizates & \begin{tabular}{l} 7 \\ - \end{tabular} & & & & & \\ \hline Latd & +2,000,000 & & 2,000,000 & & 2,000,000 & \\ \hline Orfice byldieg: & +4,000000 & & +4,000,000 & & 4,000,000 & \\ \hline Oticesationent & 33320000 & & 33,000,000 & & 320,0004,00,000 & \\ \hline Sers builJnas & 13,000,000 & & 3,000,000 & & 3,000,000 & \\ \hline Stort equipmetst & +3,560000 & & tt3,560,000 & & 3560,000 & \\ \hline & & 1580000 & & 80.000 & & 1680,000 \\ \hline & & 4,126,000 & & 30,000 & & 4,215,000 \\ \hline Gesedvil & 375000 & & 675,000 & & 65,000 & \\ \hline Ascounte panste & & 194,300 & & 194,300 & & 194,800 \\ \hline Thens tos payble & & 44,000 & & 44,000 & & 44,000 \\ \hline Unearesd Feronas & & +12,000 & & 22,000 & & 3000044000 \\ \hline Nete Peyable & & s. & & & & s. \\ \hline & & + & & & & . \\ \hline & & + & & & & \\ \hline & & & & 50000 & & \\ \hline Prenism entende peybis. & & 19000 & & 10,000 & & 10000 \\ \hline & anding & 1700000 & & & & 1700000 \\ \hline & & 100000 & & & & \\ \hline & & & & & & \\ \hline & & 70000 & & 10,000 & & 10000 \\ \hline & & 13000 & & & & 13000 \\ \hline Cath disidsndi - semese stesi & 5000 & & 50,000 & & 50,900 & \\ \hline & 40000 & & 40,000 & & 40.000 & \\ \hline & & & & & & \\ \hline Tresarestock & 116.200 & & 118,200 & & 176,200 & \\ \hline Saks & & 5.23 .000 & & 22.000 & & 5035000 \\ \hline Interctet reveres & & 30,000100000 & & & & 30,91 \\ \hline Coat of orods sold & 3500000 & & 3500000 & & 3500,000 & \\ \hline Salke idecises sxestes & 8305000 & & 305,000 & & 2000205,000 & \\ \hline Sakz sonnitaions & +185000 & & 165,000 & & 155,000 & \\ \hline & 150000 & & 150,000105000 & & kng,00015,000 & \\ \hline & 170000 & & 170,000 & & 0,000 & \\ \hline Orfice aepplies expense & 0,000 & & 10,000 & & 10,000 & \\ \hline Coflice renteredace & 5000 & & 50,000 & & 5000010,000 & \\ \hline & & & 10,000 & & 10,00030,000 & \\ \hline Delivery expenas & 30,000 & & & & 30,000 & \\ \hline Dopreciatich expense - office buildisge end equipnent & 30000 & & 40,000 & & 70,000 & \\ \hline & 100000 & & 30,000 & & 100,000 & \\ \hline EadDebe Exposts & = & & 44,660 & & 44,600 & \\ \hline SRore aspolise expenze & 21000 & & 21,000 & & 21,000 & \\ \hline & 140,500 & & 140,500 & & 40,500 & \\ \hline Instest espestis & 21000 & & 11,500140,1000 & & 32,500+10,50 & \\ \hline Gin flooston ares dispocal & 183321933 & & 1,93311,203 & & 1,933 & \\ \hline & 1,5001,500 & & 1,500500 & & 75001,500 & \\ \hline & 15,5001,500 & & 15,5001,100 & & 5,5001,00 & \\ \hline Total & 136,312.483 & 26,212483 & 135,968.444 & 15,365,903 & 36,366,344 & \\ \hline & & & & & & \\ \hline \end{tabular} Account \& Unadjusted TB data Journal Entry data Journal Trial Balances Work Step 5b: Prepare a Statement of Stockholders Equity for the year ending December 31, 2021, in proper form. Use the data from the Journal an Income Statement tabs to complete. All ending balance should equal the Adjusted Trial Balance amounts except for Retained Earnings. Opening balances have been provided. 2 Balance Sheet Step Sc: Using the data in the Adfusted Trial Balance columns on the Trial Balances Worksheet and the Statement of Stockholders' Equity prepare a Balance Sheet as of December 31, 2021, in proper form. Accounts Receivable and Bonds Payable should be reported as net figures with their related contra-accounts. XYZ Co. Balance Sheet December 31. 2021 Assets Current Assets: hint: net the Accaunts Receivabie and Alowance \begin{tabular}{|c|c|} \hline \\ \hline & for Doubtful a \\ \hline & "Accounts Hec \\ \hline & \\ \hline & \\ \hline Total Current Assets & \\ \hline Non-Current Assets: & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline Total Long-Term Assets & \\ \hline Total Assets & \\ \hline \end{tabular} Liabilities Current Liabilities: Liabilities \begin{tabular}{|l|l|l|} \hline & & \\ \hline & & \\ \hline & & \\ \hline Total Current Liabilities & & \\ \hline Non-Current Liabilities: & & \\ \hline \multicolumn{2}{|l|}{} & \\ \hline Total Liabilities & & \\ \hline \end{tabular} hint: combine Bonds Payatile and Premium on Sonds Payable account balances into one for "Band Payable, Net Carring Value" Additional Questions - enter formulas to compute What is XYZ's current ratio on December 31, 2021? What is X'YZ's Accounts Receivables Turnover for 2021? 56 Tecemter.it % What is XYZ's Asset Turnover for 2021? /ascume roto \begin{tabular}{|l|} \hline \\ \hline \\ \hline \end{tabular}