Old MathJax webview

on this part I need to find a number with my name which I don't understand well, my name is Johanan. prof said you need to find a unique number.

Second picture are the requirements. please try to do it on excel. thank you!

D E F G H K 1 2 3 + CZS Medical Center Work Sheet For Year Ended December 31, 2020 No. Account Title Unadjusted Trial Balance DR > Adjustments DR 2 CR Adjusted Trial Balance CR DR 34.300 20,000 CR 3 (d) 65,000 95.000 0 21.000 140,000 (d) 5,000 1 2 200,000 3 43.000 350,000 4 (a) (c) (d) 5 13,000 20,000 4,300 6. 37.000 7 201 Accounts payable 168 Accumulated depreciation - Medical equipment 633 Advertising expenses 101 Cash 301 Common Stock 187 Copyrights - Medical 501 Cost of Goods Sold 612 Depreciation expense 637 Insurance expense 203 Interest payable 131 Inventory 150 Land 251 Long-term notes payable 167 Medical equipment 451 Other Revenue 186 Patents - Medical Licenses 126 Patient Receivables 640 Rent expense 686 Repairs expense 305 Retained Earnings 683 Salaries expense Your name CZS 4,300 (b) 29.000 70,000 8 9 136.000 670,000 1 287.000 2 15,000 3 287.000 21.000 32,000 (d) 1,000 5 436,000 22 280.000 e 31,000 39 Due date: Upload financial statements to Blackboard by Monday, July 5, 2021. Please do not email files. A B D H K 4.300 F G 1 305 Retained Earnings 436,000 683 Salaries expense 280,000 (c) 31,000 401 Sales 760,000 (6) 127 Short-term Securities 40.000 (a) 13.000 140 Supplies 6,000 652 Supplies expense (d) 3,000 690 Utilities expense 12.000 (d) 21.000 210 Wages payable (e) 31,000 Totals 2.131.213,231.232 2,131,213,231,232 102,600 102,600 Requirements: 1) Complete adjusted trial balance of worksheet 2) Use your completed worksheet to prepare a single-step or multi-step net income, (b) Statement of Owner's Equity and (c) Classified balance sheet as of December 31, 2020. 3) HINT: (aSort the data by chart of account number, then (6) review totals for reasonableness. Due date: Upload financial statements to Blackboard by Monday, July 5, 2021. Please do not email files. E . 1 J 7 Letter F Johanan G 287000 30 4 h 5 a 6 n 7 a 8 n B D Code Number APPLY 106 64 42000 111 64 47000 104 64 40000 97 64 33000 110 64 46000 97 64 33000 110 64 46000 110 64 46000 73 64 9000 74 64 10000 75 64 11000 76 12000 77 64 13000 78 64 14000 79 64 15000 80 64 16000 81 64 17000 64 18000 83 64 19000 84 64 20000 85 64 21000 86 22000 87 64 23000 88 64 24000 89 64 25000 90 64 26000 9n 101 11 ) 12 K 13 L 14 M 15 N 16 O 17 P 18 Q 19 R 20 S 21 T 22 U 23 V 24 W 25 X 26 Y 27 2 28 29 64 82 64 Your name CZS 721 X D F E G C H Unadjusted Trial Balance DR Adjusted Trial Balance DR Adjustments DR 21.000 CR CR CR (d) 12,000 32,000 280,000 21.000 4 A B 1 CZS Medical Center 2 Work Sheet 3 For Year Ended December 31, 2020 4 5 No. Account Title 6 7 690 Utilities expense 686 8 Repairs expense 9 683 Salaries expense 10 652 Supplies expense 11 640 Rent expense 12 637 Insurance expense 13 633 Advertising expenses 14 612 Depreciation expense 15 501 Cost of Goods Sold 16 451 Other Revenue 17 401 Sales 18 305 Retained Earnings 19 301 Common Stock 20 251 Long-term notes payable 21 210 Wages payable 22 203 Interest payable 23 201 Accounts payable 24 187 Copyrights - Medical 25 186 Patents - Medical Licenses 26 168 Accumulated depreciation - Medical equipment 27 167 Medical equipment Your name CZS + Ready (e) (d) (d) (d) (d) (C) (a) 31.000 3,000 1,000 4,300 5.000 20,000 13,000 21.000 350,000 (b) 4,300 288,183 760000 436,000 200.000 136.000 (C) 31,000 37,000 65,000 (d) 34.300 43,000 15,000 95,000 (c) 20,000 670.000 Adjustments DR 2 CR Adjusted Trial Balance CR DR 34.300 20,000 CR 3 (d) 65,000 95.000 0 21.000 140,000 (d) 5,000 1 2 200,000 3 43.000 350,000 4 (a) (c) (d) 5 13,000 20,000 4,300 6. 37.000 7 201 Accounts payable 168 Accumulated depreciation - Medical equipment 633 Advertising expenses 101 Cash 301 Common Stock 187 Copyrights - Medical 501 Cost of Goods Sold 612 Depreciation expense 637 Insurance expense 203 Interest payable 131 Inventory 150 Land 251 Long-term notes payable 167 Medical equipment 451 Other Revenue 186 Patents - Medical Licenses 126 Patient Receivables 640 Rent expense 686 Repairs expense 305 Retained Earnings 683 Salaries expense Your name CZS 4,300 (b) 29.000 70,000 8 9 136.000 670,000 1 287.000 2 15,000 3 287.000 21.000 32,000 (d) 1,000 5 436,000 22 280.000 e 31,000 39 Due date: Upload financial statements to Blackboard by Monday, July 5, 2021. Please do not email files. A B D H K 4.300 F G 1 305 Retained Earnings 436,000 683 Salaries expense 280,000 (c) 31,000 401 Sales 760,000 (6) 127 Short-term Securities 40.000 (a) 13.000 140 Supplies 6,000 652 Supplies expense (d) 3,000 690 Utilities expense 12.000 (d) 21.000 210 Wages payable (e) 31,000 Totals 2.131.213,231.232 2,131,213,231,232 102,600 102,600 Requirements: 1) Complete adjusted trial balance of worksheet 2) Use your completed worksheet to prepare a single-step or multi-step net income, (b) Statement of Owner's Equity and (c) Classified balance sheet as of December 31, 2020. 3) HINT: (aSort the data by chart of account number, then (6) review totals for reasonableness. Due date: Upload financial statements to Blackboard by Monday, July 5, 2021. Please do not email files. E . 1 J 7 Letter F Johanan G 287000 30 4 h 5 a 6 n 7 a 8 n B D Code Number APPLY 106 64 42000 111 64 47000 104 64 40000 97 64 33000 110 64 46000 97 64 33000 110 64 46000 110 64 46000 73 64 9000 74 64 10000 75 64 11000 76 12000 77 64 13000 78 64 14000 79 64 15000 80 64 16000 81 64 17000 64 18000 83 64 19000 84 64 20000 85 64 21000 86 22000 87 64 23000 88 64 24000 89 64 25000 90 64 26000 9n 101 11 ) 12 K 13 L 14 M 15 N 16 O 17 P 18 Q 19 R 20 S 21 T 22 U 23 V 24 W 25 X 26 Y 27 2 28 29 64 82 64 Your name CZS 721 X D F E G C H Unadjusted Trial Balance DR Adjusted Trial Balance DR Adjustments DR 21.000 CR CR CR (d) 12,000 32,000 280,000 21.000 4 A B 1 CZS Medical Center 2 Work Sheet 3 For Year Ended December 31, 2020 4 5 No. Account Title 6 7 690 Utilities expense 686 8 Repairs expense 9 683 Salaries expense 10 652 Supplies expense 11 640 Rent expense 12 637 Insurance expense 13 633 Advertising expenses 14 612 Depreciation expense 15 501 Cost of Goods Sold 16 451 Other Revenue 17 401 Sales 18 305 Retained Earnings 19 301 Common Stock 20 251 Long-term notes payable 21 210 Wages payable 22 203 Interest payable 23 201 Accounts payable 24 187 Copyrights - Medical 25 186 Patents - Medical Licenses 26 168 Accumulated depreciation - Medical equipment 27 167 Medical equipment Your name CZS + Ready (e) (d) (d) (d) (d) (C) (a) 31.000 3,000 1,000 4,300 5.000 20,000 13,000 21.000 350,000 (b) 4,300 288,183 760000 436,000 200.000 136.000 (C) 31,000 37,000 65,000 (d) 34.300 43,000 15,000 95,000 (c) 20,000 670.000