i need help with the financial statement, balance sheet, statement of retained earnings. here are the numbers used.

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 l etrl"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 studente paraleln. Afhaa l . - - - - - -- me Insert Draw Page Layout Formulas Data Review View Taste Times New Roman 12 AA EEE aby BIUDAEEEE X v fx =Worksheet|J24 C D CLOSING JOURNAL ENTRIES -AugFig Consulting Inc DATE ACCOUNT DEBIT CREDIT 31-Jan Service Revenue 35,160 Income Summary 35,160 31-Jan Income Summary 20,645 Salaries Expense 6,125 Rent Expense Supplies Expense 11,120 Utilities Expense 2,340 Interest Expense 65 Depreciation Expense - Comp 185 Depreciation Expense - Office Furniture 135 31-Jan Income Summary 14,515 Retained Earnings 31-Jan Retained Earnings 2.000 Dividends 2,000 675 Home Insert Draw Page Layout Formulas Data Review View Geneva 10 AA EEE 2 Wrap Text Custom BIU AEE20Merge & Center S% 22.23 v fx =11120 Paste Conditional Form Formatting as Tal X ACCOUNT Cash Accounts Receivable Supplies repaid Rent Worksheet - AugFig Consulting Inc JANUARY ENTRIES UNADJUSTED TRIAL BALANCE DEBIT CREDIT DERIT CREDIT 64,360 36,725 76,835 18.950 16.850 2,100 6,850 15.500 8,100 8,100 28,000 42,800 6 ind ADJUSTMENTS ADJUSTED TRIAL BALANCE DEBIT CREDIT DEBT CREDIT 76835 5.480 7.580 11.120 4,380 6757,425 28.000 42.800 185 185 11,260 135 6.850 1,750 1.750 6565 9 80 10.780 26,000 120,000 11.260 11,260 135 8,650 6850 6 ,850 11,760 26.000 11,760 26,000 120,000 mputer Equipment cumulated Depreciation, Como Equip ce Furniture cumulated Depreciation Off Furn 13 Accounts Payable 14 Salaries Payable 15 Interest Payable 16 Unearned Revenue 17 Long term Notes Payable 18 Common Stock 19 Retained Earnings 20 Dividends 21 Service Revenue 22 Salaries Expense 23 Rent Expense 24 Supplies Expense 25 Utilities Expense 26 Interest Expense 27 Depreciation Expense. Comp Equip 28 Depreciation Expense, Office Furniture 2,000 2.000 2.000 35,160 6,460 28.700 28,700 4,375 4,375 1.750 675 4,380 6,125 675 11.120 2.340 65 185 135 2,340 2,340 200.925 20,390 2 00.925 13,650 193,310 193,310 126,885 126,885 14 WA A = P Geneva B IUB Paste Wrap Text 139 Merge & Center A R9 EE General $ % 98 -99 Conditional Format Formatting as Table Cel Styles AugFig Consulting Inc Income Statement AugFig Consulting Inc Balance Sheet $ 35,160 Revenues Service Revenue Expenses Salaries Expense Re ense Su Expense U ponse Inte pense Dep on Expense Total Excuses $ 6,125.0 675.0 $ 11,120.0 $ 2,340.0 65.0 $ 320.0 $ 20,645.0 Aug Fig Consulting Inc Statement of Retained Earnings