Instructions Statement of Retained Eamings: Row 11-cell M Balance Sheet Row 19-cells O and P: Row 14-cells Q and R Row 18-cels Q and R Ending balance, December 31 759,770 Total Assets 2.214,080 Total Liabilities 1.352.950 Total Stockholders Equity 661.130 2.214,080 Row 19-cells Q and R Total Liablities & Stockholders Equity 2. Copy the Porter Co worksheet from Excel Project 1 to the Porter Co worksheet in Excel Project 2 This copies all of the first assignment into the second assignment 3. Copy the data from the Porter Co worksheet into the Pale Ale Inc worksheet At this point, you will have worksheets with two different names but IDENTICAL data 4. Update the Pale Ale Inc worksheet as follows: a. Update tiles to reflect Pale Ale Inc instead of Porter Co b. Change the amounts in Column B for each account to: Pale Ale Inc. Scenario #1 Amounts Service Revenue 41,023,720 Usities Expense 4,271,080 Cash 5,146,240 Accounts receivable 5,440,000 Common stock 3,446,240 Payroll Expense 23,950,280 Buildings Other liabilities 23,120,000 216,240 39,100 Interest payable Land 26,220,240 Retained eamings 20,117,120 Supplies expense 593,640 Rert 5,615,780 Dividends 677,580 Accounts payable 6,892,450 Equipment 9,180,000 Supplies 6,166,240 Salaries payable 4,806,240 34,046,240 Notes payable Confirm each statement updated with the new amounts Trial Balance Row 28-cells E and F Income Statement: Row 16-cells H and J Statement of Retained Eamings: Row 11-cell M Balance Sheet Row 19-cells O and P: Row 14-cells Q and R Row 18-cells Q and R Row 19 cells Q and R This is the end of Part 1 Net Income 110.587.380 110,587.350 6,502.940 Ending balance, December 31 25.832,160 Total Assets 75.278.720 Total Liabilities 46.000,300 Total Stockholders Equity 29.278.420 75.278.720 Total Liabilities & Stockholders Equity