formulas displayed 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 Home Insert Draw Page Layout Formulas View Tell me Data Review == Times New Roman A A General V 12 2. Wrap Text Paste BIU $ % ) Merge & Center Conditional Format Formatting as Table B10 G H A CLOSING JOURNAL ENTRIES -ZKTZ Consulting Inc ACCOUNT DEBIT CREDIT DATE 10 13 14 15 16 17 18 19 21 22 23 25 26 28 30 31 32 indo JE ADJUSTING JE CLOSINO JE Worksheet statements worksheet formulas statement formulas Trans A Home Insert Draw Page Layout Formulas Data Review View Telme Geneva * A A Ceneral We Y Peste $% Condition form Farming The Styles Farma Santa Filter E36 D ZKTZ Consulting Inc Income Statement ZKTZ Consulting Inc Balance Sheet 26 27 20 ZKTZ Consulting Inc Statement of Retained Earnings JE ADJUSTING JE CLOSINO JE Worksheet sprements workomulas Trans Analysis NOT REQUIRED TA MacBook Pro esc B / $ 4 C 2 3 - 5 6 7 8 W E R T Y U 0 S D F G H J Home Insert Draw Page Layout Formulas Data REVIEW View Tele Geneve 10 wwel 0 A A IA General $ % 9 WAS Peste B TV F3 DE Merge & Carter -3 Condom Formgerebes H4 f ADRUSTMENTS ACCOUNT CHE C AB 43,200 Worx Com ENTRES UNDESTED THE BALANCE DERT CREDIT 61,210 37,50 78820 11.500 BO 16240 3.000 000 6 10,590 5010 58,300 67.500 67 TEL 10.30 10 190 650 15 rest Payable 50 11 900 17 Las Payable 1176 10,000 175.000 175 175.000 500 500 24,000 6560 5.560 750 710 24 Sep 25 1,96 13 50 28 Depression permeture 35 35 39 165530 246.410 21.55 info JE ADJUSTING JE CLOSING JE Worksheet statements worksheet formes statement for Trans Analysis NOT REQUIRED Average 26215.80395 Court 43 MacBook Pro B / U 2 $ 4 3 9 5 6 7 8 9 w E R T Y S D F G H J A A Wrap Test Delete Sort Geneve $ % 9 Conditional Format Call Formatting as Table Styles Format CO Merge Center A. Paste L M11 NEGINNING NUMBERS CREDIT DEBIT 49,200 ACCOUNT Can Accounts Receivable Supplies Worksheet - XTZ Consulting Inc JANUARY ENTRES UNAD USTED THIAL BALANCE DET CREDIT DEBIT CREDIT 63.210 37,586 74824 11,500 8.950 5.659 16.240 9.000 58,300 67,500 10,590 58.300 67.500 ADJUSTMENTS ADJUSTED TRIAL BALANCE DEBIT CREDIT DENT CREDIT 74,824 6,895 9,445 5,910 10.330 750 8,250 58,300 67.500 295 299 8,950 85 5.650 6.560 6,560 50 50 980 10.780 30.000 175.000 8.950 8.950 10.590 10.590 5.650 5.650 11,760 30.000 11.760 30.000 175,000 175.000 3 Land Computer Equipment 10 Accumulated Depreciation Comp Equip 11 Office Furniture 12 Accumulated Depreciation Off Fur 13 Accounts Payable 14 Salaries Payable 15 Interest Payable 16 Urared Revenue 17 Long term Notes Payable 18 Common Stock 19 Retained Earrings 20 Dividends 21 Service Revenue 22 Salaries Expense 23 Rent Expense 24 Supplies Expense 25 ilities Experne 20 interest Expense 27 Depreciation Expense comproup 20 Depreciation Expense Office Furniture 500 500 500 24.000 24.000 7.875 6,560 6,560 750 5.910 13.120 750 5,910 1.986 1956 50 50 295 BS BS 260205 246,410 185,590 117.946 246410 117.955 30 statement formulas worksheet formulas Trans Analysis NOT REQUIRED ADJUSTING JE CLOSING JE Worksheet statements Ready