Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have to use reference cells & excel funtions for the answers aisde from the single number value Presented below are incomplete financial statements for
I have to use reference cells & excel funtions for the answers aisde from the single number value
Presented below are incomplete financial statements for Marta Communications Company. Required: Solve for the missing amounts Note: When an amount on one financial statement is again shown on another statement, you MUST reference the cell from the earlier statement rather than calculate the amount, thus indicating the relationship between the two statements. (All formulas must return positive values.) MARTA COMMUNICATIONS Company Income Statement For the Month Ended March 31 14 Sales Revenues $34,500 5 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 SO 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 35 Accounts receivable 36 Office Supplies 2,300 Owners' Equity 37 Land 12,000 Marta, Capital 38 Total Assets Total Uabilities and Owners' Equity 39 26 $20,800 B Graded Worksheet 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