Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

Discuss all branches of science

Answered: 1 week ago