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
Get step-by-step solutions from verified subject matter experts
