Question: Pls include calculations. Thanks in advance. EA2-A2 Create Financial Statements for Metropolitan Corp. In this exercise, you will create a monthly income statement, statement of
EA2-A2 Create Financial Statements for Metropolitan Corp. In this exercise, you will create a monthly income statement, statement of owner's equity, and balance sheet in Excel for Metropolitan Corp. With the exception of the Terry Mattingly, Capital account (the balance for which is from 5/1/2016), the company had the following account balances as of 5/31/2016 Accounts Payable Accounts Receivable Cash Land Maintenance Expense Notes Payable $27,000 $24,000 $57,000 $41,000 $17,000 $9,000 $11,000 Sales Revenue Service Revenue Supplies Expense Tax Expense Telephone Expense Terry Mattingly, Capital-5/1/2016 Terry Mattingly, Drawing $23,000 $4,000 $6,000 $13,000 $10,000 $118,000 $2,000 Printing Expense 1. Open a Blank Workbook and save the file in your Chapter 02 folder as EA2-A2-FinancialStatements-[YourNamel 2. Set the workbook to contain a total of three tabs, one for each financial statement and arranged in the order they will be completed
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
