C8 C 1 2 3 4 5 UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. f Earnings and a Classified Balance Sheet. D ACC 120 - Principles of Financial Accounting Case #3-Version B Directions Update now E F GHIJ K ABC Corporation Income Statement M NO P X 6 Prepare financial statements for the year ended as of December 31, 20xx. You are 7 only responsible for preparing the Income Statement, Statement of Retained 8 Earnings and a Classified Balance Sheet. 9 Complete Case # 3 in this Excel workbook on template provided on the right. 10 11 12 13 14 ABC Corporation Adjusted Trial Balance December 31, 20xx For the year ended December 31, 20XX Additional Instructions Enter data in shaded cells only Do not reformat sheet (i.e. inserting row Accounting period is January - Decem Reporting period is January - Decem Show Negative numbers in brack Income Statement: (Multi-Step Presen Do not separate Selling and Administrati See Chapter 6 15 110 Cash 16 120 Accounts Receivable 17 125 Allowance for Doubtful Accounts 18 130 Inventory 19 140 Other Current Assets 20 150 Land 21 160 Equipment 22 161 Accumulated Depreciation Equipment 23 170 Intangible Assets 24 210 Accounts Payable 25 220 Unearned Revenue Directions & Templates Ready Debit 1,644,311 3,263,113 Credit 4 100,600 619,031 479,585 957,748 2,543,131 586,550 1,371,924 616,370 1.631 760 ABC Corporation Statement of Retained Earnings For the year ended December 31, 20XX Statement of Retaining Earning: See Chapter 13 B 8:33 PM APE Sunny