i really just need assistance with the statements tab and the equations I might use for some of them.

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 Work Meet 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 Insert Draw Page Layout Formulas Dale 12 Times New Roman = = General 2 Wrap Text lo Merge & Center w A $ % ) Condi Formal Paste 118 2 DATE 31 Jan 31 Jan 7 D CLOSING JOURNAL ENTRIES-ZETZ Consulting Inc ACCOUNT DEBIT CREDIT Service Revue $31.965.00 Income Summary $ 31,965.00 To close revenue sunt Income Summary $23,910.00 Salaries Expanse $9,11400 Rent expense $ 750.00 Supplies expense S 11.560.00 Utilities expense $ 1.986.00 Intereste $ 50.00 Depreciation expense compquip $ 295.00 Depreciation expense office furniture s 85.00 To close expenses Income Summary $ 8,055.00 Retained earnings S8.055.00 To close income my accounts Retained earnings $ 500.00 Dividends $ 500.00 To close dividends counts 10 12 13 14 15 31 Jan 16 17 18 31 Jan 19 20 21 22 23 24 25 26 27 28 30 33 34 35 BE info JE ADJUSTING JE CLOSING JE Worksheet statements worksheet formulas statement formula Ready MacBook Pro AA ve General wie Test art Dell Farm 27-0. EMU WOO $%% le or Idem Merge & Cente kr Conditional Formal Cel Farmaning Table Styles F Select IR A e 2 UNAUSTDAL BALANCE COUNT ASTMENTS DENI CREO CA ADRUSTED TRIAL BALANCE 74314 16 2.510 160 10.50 3510 10110 3000 0006 DOWS 18.100 ET 509 67.500 JE 11 8110 BS 12 de 5.610 5560 Teatret DO DE 10.000 175.000 10.000 125.000 1750 100 500 500 20.000 750 20 51 50 SR 18 246.410 ADJUSTINO JE CLOSING statement for Trans Analysis NOT REQUIED T Account NOT REARED 100% E ZXTZ Consulting Inc Balance Sheet Assets $ Current Assets $ $ Cash ZKTZ Consulting in Income Statement For the month ending January 31, 2019 ice Revenue berating Expenses Naries Expense ont Expense upplies Expense ities Expense Merest Expense eprication Expense: Como. Equip Deprication Experie: Otheum Total Operating Expenses et Income Accounts Recievable Supplies Prepardent Total Current Assets Property, plant and Equipment Land Computer Equipment Lass: Accumulated Deprication Computer Equipment Office Furniture Lass: Accumulated Deprication Office Purniture Tot Part Assets Liabilities Current Liabilities Accounts Payable Sales Payable interest Payable Urared Revenue Total Current Long Term Liabilities Long-Term Notes Payable Total Usb Stockholders' Equity Common Stock Retained unge Total Stockholders' Equity Total abilities and Stockholders fody XTZ Corting the Statement of Retained tags For the month ended Januay 31, 2019 Nance January et income earned during the month : Dividends cary 31 no ADJUSTINO JE CLOSING JE Worksheet statements worksheet formulas statement formules Trans Analysis NOT REQUIRED T ACCOUNT Ready