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 Sales Revenues $34,500 Expenses: Rent Expense 2,600 Wages Expense Utilities Expense 4,800 Income Tax Expense 800 Net income $4,100 MARTA COMMUNICATIONS Company Statement of Owners' Equity For the Month Ended March 31 Marta, Capital, March 1 Add: Net income $0 Subtract: Owner Withdrawals (500)| Marta, Capital, March 31 A Graded Worksheet + ulation Mode: Automatic Workbook Statistics

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question
100%

Marta Communications, Inc. has provided incomplete financial statements for the month ended March 31.The Controller has asked you to help calculate the missing amounts in the incomplete financial statements.

show me the formulas. 

Excel
McGraw Hill Excel Question - Saved
O Search (Option + Q)
File
Home
Draw
Formulas
Data
Review
View
Help
O Editing v
Insert
Calibri
V 11
В
A v
General
...
G34
fx
A
В
C
Presented below are incomplete financial statements for Marta Communications Company.
3
4 Required:
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
Utilities Expense
18
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
A Graded Worksheet
+
Calculation Mode: Automatic
Workbook Statistics
Transcribed Image Text:Excel McGraw Hill Excel Question - Saved O Search (Option + Q) File Home Draw Formulas Data Review View Help O Editing v Insert Calibri V 11 В A v General ... G34 fx A В C Presented below are incomplete financial statements for Marta Communications Company. 3 4 Required: 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 Utilities Expense 18 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 A Graded Worksheet + Calculation Mode: Automatic Workbook Statistics
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
40
Transcribed Image Text: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 40
Expert Solution
Introduction :

Net Income = Revenue - Expenses

Capital , Ending balance = Capital , Beginning balance + Net Income - Withdrawals

Total Assets = Total liabilities + Owner's Equity

The financial statement is completed below with proper format.

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education