Answered step by step
Verified Expert Solution
Link Copied!

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

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_2

Step: 3

blur-text-image_3

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

Case And Problem Materials In Management Accounting

Authors: Tony Brabazon And Tony ODea

2nd Edition

1412024315, 978-1412024310

More Books

Students also viewed these Accounting questions