Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Help me fill in the missing documents and report any errors I made. Thanks! image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: John Wild

1st Edition

0073403989, 978-0073403984

More Books

Students also viewed these Accounting questions

Question

WHAT IS AUTOMATION TESTING?

Answered: 1 week ago

Question

What is Selenium? What are the advantages of Selenium?

Answered: 1 week ago

Question

Explain the various collection policies in receivables management.

Answered: 1 week ago

Question

4. Identify cultural variations in communication style.

Answered: 1 week ago

Question

9. Understand the phenomenon of code switching and interlanguage.

Answered: 1 week ago

Question

8. Explain the difference between translation and interpretation.

Answered: 1 week ago