Question: Can someone explain me step by step how to solve this on excel Please I need help! Instructions: prepare all four of the year-ending December

Can someone explain me step by step how to solve this on excel Please I need help!

Can someone explain me step by step how to solveCan someone explain me step by step how to solveCan someone explain me step by step how to solve
Instructions: prepare all four of the year-ending December 31, 2022 financial statements for ABC Enterprises, LLC. file submission only the following worksheets: . Dropbox instructions . Prior year's adjusted trial balance report Current year's adjusted trial balance report . Income statement . Statement of Owner's Equity . Balance Sheet . Cash flow worksheet. | _| . Statement of Cash Flows. Prepare the financial statements ONLY for the balances ending December 31, 2022. Meaning, DO NOT prepare comparative financial statements. The prior year's ending balances should NOT be presented in a separate column on the financial statements. At a minimum, you are required to enter the following "check your work" formulas: 1. On the Statement of Owner's Equity, total owner's equity must foot and cross foot. 2. On the Balance Sheet, total assets must equal total liabilities and owner's equity. 3. On the Cash Flow Worksheet, each total activity must equal the total reported on the Statement of Cash Flows. 4, On the Statement of Cash Flows, the cash ending balance must equal the cash ending balance reported on the adjusted trial balance. Data provided: The adjusted trial balance reports for years ending December 31, 2021 and 2022 are in this Excel file. Grading: These four financial statements are to contain NO ERRORS IN AMOUNTS (INCLUDING FORMULAS) AND PRESENTATION. P Dropbox Instructions [P IR IR P PR L: e | ABC ENTERPRISES LLC ADJUSTED TRIAL BALANCE DECEMBER 31, 2021 ACCOUNT NAME ACCOUNT TYPE DEBIT CREDIT CASH - BUSINESS ACCOUNT ASSET S 109,274.06 S - ACCOUNTS RECEIVABLE ASSET ) 1,452.00 EQUIPMENT ASSET $ 85,910.00 ACCUM. DEPRECIATION ASSET WD 00~ U W N $ 85,910.00 ACCOUNTS PAYABLE LIABILITY S 1,357.62 NOTES PAYABLE LIABILITY S 2,519.00 OWNER'S CAPITAL EQUITY ) 8,470.00 RETAINED EARNINGS EQUITY S 741.90 OWNER CONTRIBUTIONS (CURRENT YEAR) EQUITY $ 101,235.69 OWNER WITHDRAWALS (CURRENT YEAR) EQUITY $ 19,360.00 REVENUE REVENUE S 84,353.85 COST OF PRODUCT EXPENSE EXPENSE S 19,049.00 PAYROLL WAGES EXPENSE EXPENSE S 30,211.00 GAS AND UTILITIES EXPENSE EXPENSE S 1,930.00 OTHER OPERATING EXPENSES EXPENSE S 220.00 | _l DEPRECIATION EXPENSE EXPENSE S 17,182.00 MISCELLANEOUS INCOME REVENUE ) S 284,588.06 S 284,588.06 b Dropbox Instructions | RAYAREN 2022 TB + : A B D E F ABC ENTERPRISES LLC ADJUSTED TRIAL BALANCE 3 DECEMBER 31, 2022 5 ACCOUNT NAME ACCOUNT TYPE DEBIT CREDIT 6 CASH - BUSINESS ACCOUNT ASSET $ 99,444.20 $ ACCOUNTS RECEIVABLE ASSET 2,709.00 8 EQUIPMENT ASSET S 37,300.00 9 ACCUM. DEPRECIATION ASSET 7,491.54 10 ACCOUNTS PAYABLE LIABILITY 2,896.98 11 NOTES PAYABLE LIABILITY 519.00 12 OWNER'S CAPITAL EQUITY 90,345.69 13 RETAINED EARNINGS EQUITY 16,503.75 14 OWNER CONTRIBUTIONS (CURRENT YEAR) EQUITY S 24,014.91 15 OWNER WITHDRAWALS (CURRENT YEAR) EQUITY $ 26,892.22 16 REVENUE REVENUE $ 105,305.27 17 COST OF PRODUCT EXPENSE EXPENSE $ 22,981.09 18 PAYROLL WAGES EXPENSE EXPENSE $ 47,908.21 GAS AND UTILITIES EXPENSE EXPENSE 2,245.88 20 OTHER OPERATING EXPENSES EXPENSE 105.00 21 DEPRECIATION EXPENSE EXPENSE 7,491.54 22 MISCELLANEOUS INCOME REVENUE $ 23 $ 247,077.14 $ 247,077.14 24 25 Current year fixed asset changes: 26 Original cost of equipment disposed of in current year $ 85,910.00 27 Cost of new equipment purchased in current year 37,300.00 87 29 Dropbox Instructions 2021 TB 2022 TB +

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!