Question

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 . - - - - - --

Answer 1

Aug Fig consecuting Inc Income statment for the men the ending Tanuary 31 2019 is as follows! - IB 18 @ Sales Revenue 135, 160 less operating expenses salary lapenses 6,125 Rent- eepenses .675 supplies lapenses chilities expenses 2340 Deprecaton expenso - comp. 185 Depreciation Expenses - office fenilen 135 Interest expenses 65 Total operating expenses 20645 operating proht 1 Net Income 14 sis 6 Aug Fig consulting INC. statment of Rel-caining Earning. Retaining Earning (begining) Add. Met Income lessoividends Retouned Earning (Ending 14. SISI 2000 12515

ug fig consulting INC. classified Balance sheet as as January 3, 2019 liability B Assets cament liabilities current Assets Account payable 6,850 cash 76,835 salary payable 1,750 A Clour Receivable 7.580 Interest payable 65 supplies 4380 unearned 10,780 Prepaid Rent 7425 Revenue LElved Assets Long term Mole 26000 Land 28000 payable comp. Equipment 42,800 Hess: Accumulated 18542615 Shareholdens Depreciation of Equity office furniture 11,260 comma stock 120,000 less. Accumulated 135 11,125 Depreciation ! Retained 12s15 Earning 177,960