Transcribed image text: $ . % Merge & Center - .000 Formatting Table SIU. . . A. Number Styles Alignment Font Prepare financial statements for the month ending January 31, 2019. (Income Statement, Statement of Retained Earnings, Classified Balance Sheet). Formatting is important and will be graded so be sure you use dollar signs and underlines as appropriate. Also be sure you have headings and proper column usage for all statements. There is a tab for these statements. Heading are PARTIALLY completed for the 3 statements. Prepare closing entries for the end of the period Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab and the Financial Statements from the Financial Statements tab to the Financial Statements tab. Highlight the entire worksheet/financial statements area respecively and press the "ctrl" key and the "_" key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed. Each student must submit an ORIGINAL excel file that is their own work. While students are encouraged to work together, each student must process and format his/her own set of excel worksheets. Duplicate submissions (format, not numbers) will result in the students receiving a 0 for the assignment. And possibly other consequesces as stated inthe University Integrity policies. Submissions will NOT be accepted via email attachment. Submission to other than the correct El Aud.. info E ADJUSTING JE CLOSING JE Worksheet statements worksheet formulas financ ... 4 AugFig Consulting Inc Income Statement AugFig Consulting Inc Balance Sheet ADJUSTING CLOSING JE Worksheet statements worksheet formulas financ ... + 2 Merge & Center - $ - % 8-8 Conditional Format as Cell Formatting Table Styles - Insert Delete Format - . Sort & & Fiter-se Editing Alignment Number Cells H ADJUSTMENTS CREDIT 5,480 f =+'ADJUSTING JE ID24 D ETAIF G Worksheet - AugFig Consulting Inc BEGINNING NUMBERS JANUARY UNADJUSTED TRIAL ENTRIES BALANCE ACCOUNT CREDIT DEBIT CREDIT DEBIT CREDIT Cash 49,200 64.380 36,725 76.835 Accounts Receivable 18.950 16.850 2.100 5 Supplies 8,650 6 850 15.500 7 Prepaid Rent 8 100 8100 8 Land 28.000 28,000 9 Computer Equipment 42 800 42 800 10 Accumulated Depreciation Comp Equip 11 Office Furniture 11,260 12 Accumulated Depreciation Off Furn 13 Accounts Payable 8.650 .00 6850 6,850 14 Salaries Payable 15 Interest Payable 16 Unearned Revenue 11760 11.700 17 Long-term Notes Payable 28 000 26.000 4 ) . CLOSING JE Worksheet statements worksheet formulas financial statement formulas Tri ADJUSTED TRIAL BALANCE DEBIT CREDIT 78,835 7.580 4380 7.425 28.000 42 800 11.120 11.260 135 135 6.850 1.750 1.750 980 5 480 10 200 26.000 Type here to search WWWWWWU12121/1/ AAAAAAA Sort & hinc CA E Merge & Contor. $ . % *88 Conditional Formatas Cell Formatting - Table Styles Insert Delete Format - Edring Alignment > fx =+'ADJUSTING JE ID24 BEGINNING NUMBERS Worksheet - AugFig Consulting Inc UNADJUSTED TRIAL JANUARY ENTRIES BALANCE 120,000 ADJUSTMENTS ADJUSTED TRIAL BALANCE 120.000 120,000 2.000 2.000 2.000 28.700 28,700 29.680 4375 4 375 mon Stock ained Earnings idends rvice Revenue mlaries Expense ent Expere Bupplies Expense Jilities Expense Interest Expense Depreciation Expense Comp Equip Depreciation Expense Office Furniture 1.750 675 11,120 6,125 675 11. 120 2,340 2.340 185 135 128 650 128 650 193,310 20 390 20,390 200 025 200,925 126 885 126 -1 Total T... CLOSING JE Worksheet statements financial statement formulas worksheet formulas 2 A 41 Font Alignment Number lipboard col 420 Font V x fx CLOSING JOURNAL ENTRIES -AugFig Consulting Inc ACCOUNT DEBIT CREDIT DATE infoJE ADJUSTING JE CLOSING JE Worksheet statements worksheet formulas finan