Question
table {mso-displayed-decimal-separator:.; mso-displayed-thousand-separator:,;} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;}
table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;} .xl90 {border-top:none; border-right:none; border-bottom:none; border-left:.5pt solid windowtext; white-space:normal;} .xl91 {white-space:normal;} .xl92 {border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:none;} .xl94 {text-align:center; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:none; white-space:normal;} .xl95 {text-align:left; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:none; background:#FFFFAA; mso-pattern:black none; white-space:normal; padding-left:9px; mso-char-indent-count:1;} .xl97 {text-align:left; white-space:normal;} .xl108 {font-weight:700; text-align:center; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:.5pt solid windowtext; background:#79ADE5; mso-pattern:black none; white-space:normal;} .xl110 {font-weight:700; text-align:center; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:none; background:#79ADE5; mso-pattern:black none; white-space:normal;} .xl115 {text-align:left; border-top:none; border-right:none; border-bottom:none; border-left:.5pt solid windowtext; white-space:normal;} .xl118 {font-weight:700; text-align:center; border-top:none; border-right:none; border-bottom:none; border-left:.5pt solid windowtext; background:#79ADE5; mso-pattern:black none; white-space:normal;} .xl120 {font-weight:700; text-align:center; background:#79ADE5; mso-pattern:black none; white-space:normal;} .xl141 {font-weight:700; text-align:left; border-top:none; border-right:none; border-bottom:none; border-left:.5pt solid windowtext; background:#79ADE5; mso-pattern:black none; white-space:normal;} .xl145 {text-align:left; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:none; white-space:normal;} .xl150 {border-top:2.0pt double windowtext; border-right:none; border-bottom:none; border-left:none;} .xl156 {text-align:center; white-space:normal;} .xl435 {text-align:left; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:#FFFFAA; mso-pattern:black none; white-space:normal; padding-left:9px; mso-char-indent-count:1;}
Enter your name in cell B2: | AJAY RANA | |||
The trial balance of AJAY RANA Company as of December 31, 2023 is presented below. | ||||
AJAY RANA Company | ||||
Trial Balance | ||||
December 31, 2023 | ||||
Debit | Credit | |||
Cash | $70,500 | |||
Accounts receivable, net | 140,000 | |||
Merchandise inventory | 123,500 | |||
Store supplies | 14,200 | |||
Store equipment | 300,000 | |||
Accumulated depreciation | $90,000 | |||
Accounts payable | 112,000 | |||
Salaries payable | 45,000 | |||
Common stock | 207,000 | |||
Retained earnings | 310,400 | |||
Dividends | 264,000 | |||
Sales | 731,000 | |||
Sales discounts | 12,000 | |||
Sales returns and allowances | 36,600 | |||
Cost of goods sold | 256,000 | |||
Depreciation expense - Store equipment | 45,000 | |||
Sales salaries expense | 51,200 | |||
Office salaries expense | 46,700 | |||
Insurance expense | 23,700 | |||
Rent expense - Store | 29,700 | |||
Rent expense - Office | 19,700 | |||
Store supplies expense | 18,500 | |||
Advertising expense | 44,100 | |||
Totals | $1,495,400 | $1,495,400 | ||
REQUIRED: | ||||
1) Prepare a multiple step income statement for the year ended December 31, 2023. | ||||
2) Prepare a statement of retained earnings for the year ended December 31, 2023. The Retained earnings balance on January 1 was $310,400. | ||||
3) Prepare a classified balance sheet at December 31, 2023. | ||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started