Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel format please Paste El copy BI U MA . 40 00 Insert Delete Format == = $ ~ %) V Merge & Center Format
Excel format please
Paste El copy BI U MA . 40 00 Insert Delete Format == = $ ~ %) V Merge & Center Format Painter Clear Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells Edit F10 X fx B C E G . J K M. N A D F I L 1 The Trial Balance section of the worksheet for Skateboard Haven for the period ended December 31, 20X1, appears below. Adjustments data are also given. 2 3 ADJUSTMENTS a. Rent Expense, $2,500, 5 b. Insurance Expense, $,2,400, 6 c. Depreciation expense for machinery, $1,225 7 4. 8 9 Required: 10 1. Complete the worksheet. 11 2. Accumulated Depreciation is a 12 account. 13 14 15 16 Trial Balance 17 Income Statement Balance Sheet Adjusted Trial Balance Debit Credit Account Name Adjustments Debit Credit 18 Credit Debit Credit Debit Credit Debit $81,6001 19 Cash Accounts receivable 18,000 20 Prepaid AutoSave CH 2 Mid-Term Exam O Search (Alti YUQI ZHENG YZ ca File Home Insert Page Layout Formulas Data Review View Help Comments Share Calibri AutoSum 14 ~AA - PR 29 Wrap Text General SRI 47 O Fah) Paste X Out [Copy Format Painter Clipboard BIU OA Merge & Center $ % 68 Insert Delete Format Conditional Formalas Cell Formatting Table Styles Styles Clear Sort & Find & Filter Select Editing Analyze Data Font Aignment Number Cels Analysis F10 D E F G H J K M N 0 o 27.000 55,666 3,542 122,580 A B Accounts 25 payable Jacob C 26 Capital Jacob C 27 Drawing Fees 28 Lincome Rent 29 expense Insurance 30 expense Salaries 31 expense Depreciatio in expense- 32 Machinery Utilities 33 expense 34 Totals 35 Net income 123 + Reacy1 Accesibity: Good to go 5.896 1,456 100% MENG 2:31 PM 3/21/2022 Clipboard Font Alignment Number Styles Cells Editing F10 fx A B D E F G . J K L M N 16 Trial Balance Income Statement Balance Sheet 17 Account Name Adjustments Debit Credit Adjusted Trial Balance Debit Credit 18 Credit Debit Credit Debit Credit Debit $81,600 19 Cash Accounts receivable 18,000 20 14,400 21 Prepaid Rent Prepaid insurance 21,600 22 23 58,752 Machinery Accumulate d depreciatio n-Machine 24 27,000 25 Accounts payable Jacob C, Capital 55,666 26 Jacob C,Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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