I need help with the last few documents, please check out my other work and let me know what I may have got wrong. Thank you!

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} 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}