Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need some help on retained earnings, income statement snd balamce sheet U the numbers. Save your file with the formulas displayed Prepare financial statements for
need some help on retained earnings, income statement snd balamce sheet
U the numbers. Save your file with the 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. 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 link on Canvas will result in a 10% point deduction. EXCEPT AS PROVIDED IN THE INSTRUCTIONS FOR THIS PROJECT, NO LATE SUBMISSIONS WILL BE ACCEPTED O Font pboard B 4 5 CLOSING JOURNAL ENTRIES -MatTor Consulting Inc ACCOUNT DEBIT DATE CREDIT 31-Jan Service Revenue 36,145 Income Summary 36,145 31-Jan Income Summary 49,881 Salaries Expense 36,145 Rent Expense 920 Supplies Expense 10,557 1,986 13 Deprecartion Exp Computer Equip Deprecartion Exp Office Furniture 165 95 7 8 10 Utilities Expense Interest Expense 12 13 14 31-Jan Income Summary Retained Earnings 15 -13,736 -13,736 31-Jan Retained Earning Dividends 1500 1 500 DISCLOSING Worksheet statements worksheet formulas financial statement for ESC F3 1 F4 Ne 55 ta F6 04 JANUARY ENTRES 19 UNADJUSTED TRIAL BALANCE DEBIT CREDIT ADJUSTMENTS ADJUSTED TRIAL BALANCE DEBIT CREDIT DEBIT DEBIT CREDIT CREDIT 34621 13500 76.529 76 529 61,950 17860 3790 11040 6985 11.345 4,360 12,440 11 040 54,000 42,800 9,880 920 2560 10.120 54,000 42.800 165 165 9580 9,580 9,580 BEGINNING NUMBERS 2 3 ACCOUNT DEBIT CREDIT 4 Cash 49,200 5 Accounts Receivable & Supplies 8 650 7 Prepaid Rent 8 Land 54,000 Computer Equipment 42,800 10 Accumulated Depreciation Comp Equip 11 Office Furniture 12 Accumulated Depreciation Off Furn 13 Accounts Payable 4 650 14 Salaries Payable 15 Interest Payable 16 Unearned Revenue 17 Long term Notes Payable 18 Common Stock 150.000 19 Retained Earnings 20 Dividends 21 Service Revenue 22 Salanes Expense 23 Rent Expense 24 Supplies Expense ADIUSTINGIE CLOSING JE Worksheet statements 95 95 4650 3790 3.790 4692 125 7800 30000 650 7 800 30.000 150,000 3.790 4692 125 7.150 30,000 150 000 1500 1,500 1,500 20510 28,510 7635 5865 36,145 5.865 4692 920 9.880 10,557 920 9,830 worksheet formulas financial statement formulas ... Type here to search O i / Prisen Home End Poup % 2 3 4 6 & 7 E R. T NUMBERS JANUAR ENTRIES BALANCE ADJUSTMENTS 650 7800 30000 E 15 Unearned Revenue 17 Long-term Notes Payable 18 Common Stock 19 Retained Earnings 20 Dividends 7.800 30 000 150 000 BALANCE 7 150 30 000 150.000 150,000 1500 1,500 1,500 28510 28,510 7635 36,145 5865 5,865 21 Service Revenue 22 Salaries Expense 23 Rent Expense 24 Supplies Expense 25 Utilities Expense 25 Interest Expense 27 Depreciation Expense Comp Equip 28 Depreciation Expense Office Furniture 29 4692 920 9,880 1986 1986 10,557 920 9,880 1.986 12.5 165 95 12.5 165 95 30 154 650 154 650 118.221 118221 31 220,100 220,100 23399.5 23 400 232,050 232049.5 35 36 37 33 39 40 ADJUSTING JE CLOSING JE Worksheet statements worksheet formulas Ready financial statement formula Type here to search O BI A Prisen Home End 2 $ 4 96 5 & 7 6 8 9 2 W E R T Y U 0 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started