Question: I have to use excel functions / formulas for the answers** 2 Presented below are incomplete financial statements for Marta Communications Company 3 4 Required:

I have to use excel functions / formulas for the answers**
I have to use excel functions / formulas for the answers** 2

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 7 the earlier statement rather than calculate the amount, thus indicating the relationship between the two statements. 8 9 (All formulas must return positive values.) 10 11 MARTA COMMUNICATIONS Company 12 Income Statement 13 For the Month Ended March 31 14 Sales Revenues $34,500 15 Expenses: 16 Rent Expense 2,600 17 Wages Expense 18 Utilities Expense 4,800 19 Income Tax Expense 800 20 Net Income $4,100 21 22 MARTA COMMUNICATIONS Company 23 Statement of Owners' Equity 24 For the Month Ended March 31 25 Marta, Capital, March 1 $0 26 Add: Net income 27 Subtract: Owner Withdrawals (500) 28 Marta, Capital, March 31 29 30 MARTA COMMUNICATIONS Company 31 Balance Sheet 32 At March 31 33 Assets Liabilities 34 Cash $3,400 Accounts payable $20,800 35 Accounts receivable 36 Office Supplies 2,300 Owners' Equity 37 Land 12,000 Marta, Capital 38 Total Assets Total Liabilities and Owners' Equity 39

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!