Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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**
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started