1 2 Presented below are incomplete financial statements for Marta Communications Company. 3 4 Required: 5 Solve for the missing amounts. 6 Note: When an amount on one financial statement is again shown on another statement, you MUST reference the cell from the 7 earlier statement rather than calculate the amount, thus indicating the relationship between the two statements. 8 9 (All formulas must return positive values.) MARTA COMMUNICATIONS Company Income Statement For the Month Ended March 31 10 11 12 13 14 Service Revenue 15 Expenses: 16 Rent Expense 17 Salaries Expense 18 Utilities Expense 19 Income Tax Expense 20 Net income 21 $34,500 2,600 4,800 800 $4,100 2222222 23 24 MARTA COMMUNICATIONS Company Statement of Stockholders' Equity For the Month Ended March 31 25 Beginning balance, March 1 26 Add: Net income 27 Subtract: Dividends 28 Ending balance, March 31 $0 (500) MARTA COMMUNICATIONS Company Balance Sheet At March 31 Liabilities $3,400 Accounts payable 29 30 31 32 33 Assets 34 Cash 35 Accounts receivable 36 Supplies 37 Land 12,000 38 Total Assets 39 40 2,300 Stockholders' Equity Stockholders' equity Total Liabilities and Stockholders' Equity 41 $20,800