The following information pertains to Alan Marshall's personal finances as at March 1, 2019. Opening Balances - March 1, 2019 Cash $14,700 Contents of Home $2,500 Automobile $17,700 House $168,200 Unpaid Accounts $6,600 Bank Loan $62,800 Transactions for the month of March 2019. 1. Deposited $5,400 salary earned during the month. 2. Paid maintenance expenses with $400 cash. 3. Purchased a new TV worth $2,100 with cash. 4. Paid credit card liability of $6,600 (Unpaid Accounts) in full. 5. Paid travel expenses for March with $1,100 cash. 6. Purchased $2,400 of groceries and goods for personal consumption with cash. Do not enter dollar signs or commas in the input boxes. Use the negative sign for a deficit. The T-Account fields are labeled by transaction number. Record each transaction by entering the value into the corresponding T- Account field. Required a) Using the information provided, record the opening balances in the Backup MP [Design] - Microsoft SQL Server Management Studio Assets (what we OWN) Increase Cash Opening: $ 14700 Transaction # 1 Decrease As at March 31, 2019 Liabilities (what we OWE) Decrease Increase Unpaid Accounts Opening: $ 6600 Transaction # 1 6600 5400 Transaction # 2 Transaction #2 400 Transaction #3 Transaction #4 Transaction #5 Transaction #3 Transaction #4 Transaction #5 Transaction # 6 Transaction #6 2400 Ending: $ 5400 Ending: $ 6600 Increase Decrease Decrease Increase Contents of Home Bank Loan Opening: $ 2500 Opening: $ 62800 Transaction # 1 Transaction # 1 Transaction #2 Transaction # 2 Transaction #3 Transaction # 3 2100 Transaction #4 Transaction #5 Transaction #6 Ending: $ 400 Transaction # 4 Transaction #5 Transaction #6 Ending: $ 62800 Increase Automobile Opening: $ 17700 Transaction # 1 Transaction #2 Transaction #3 Transaction #4 Transaction # 5 Transaction # 6 Ending: $ 17700 Decrease Increase Opening: $168200 Transaction #1 Transaction #2 Decrease House crease Net Worth Transaction #1 Transaction #2 Transaction #3 Transaction #3 Transaction #4 Transaction #4 Transaction #5 Transaction #5 Transaction #6 Transaction # 6 Ending: $ Total Assets $ Total Liabilities $ m Net Worth $ Opening: $ Ending: $ increase Personal Income Statement For the Month Ended March 31, 2019 REVENUE Decrease - Increase + Revenue Transaction # 1 Transaction #2 Transaction #3 Transaction # 4 Transaction # 5 Transaction # 6 5400 Ending: $ 5400 Expenses Increase Decrease Increase Decrease Entertainment Food Transaction #1 Transaction #1 Transaction #2 Transaction #3 Transaction #2 Transaction #3 Transaction #4 Transaction #4 Transaction #5 Transaction # 5 Transaction # 6 Transaction # 6 Ending: $ Ending: $ 2400 2400 Increase Decrease Maintenance Transaction #1 Transaction #2 Transaction #3 Increase Decrease Travel Transaction #1 Transaction #2 Transaction # 3 Transaction # 4 Transaction # 4 Transaction # 5 Transaction # 5 Transaction # 6 Transaction # 6 Ending: $ Ending: $ Total Revenue Total Expenses Surplus (Deficit) 1100