19 20 21 MARTA COMMUNICATIONS, INC. Statement of Retained Earnings For the Month Ended March 31, 20X1 22 23 Retained Earnings, March 1, 20X1 24 Add: Net income 25 Subtract: Dividends 26 Retained Earnings, March 31, 20X1 27 28 29 30 31 32 Assets 33 Cash 34 35 Office supplies 36 Land 37 Total Assets 38 39 40 41 Accounts receivable Sheet1 $0 (500) MARTA COMMUNICATIONS, INC. Balance Sheet At March 31, 20X1 Liabilities $3,400 2,300 12,000 Retained earnings Accounts payable Stockholders' Equity Common stock Total Liabilities and Stockholders' Equity $6,800 14,000 DI

Financial And Managerial Accounting
15th Edition
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:WARREN, Carl S.
Chapter3: The Adjusting Process
Section: Chapter Questions
Problem 6MAD
icon
Related questions
icon
Concept explainers
Topic Video
Question
I need help.
FILE
Paste
Clipboard
A1
HOME
Calibri
+A
BIU
INSERT PAGE LAYOUT
1
- 11
HH
10
11 Sales Revenues
12 Expenses:
13
14
Wages Expense
15
Utilities Expense
16 Income Tax Expense
17 Net income
Font
Rent Expense
Relationships among Financial Statements - Excel
FORMULAS
-A
A
B
1 Presented below are incomplete financial statements for Marta Communications, Inc.
2
%
Alignment Number
6 indicating the relationship between the two statements.
7
8
MARTA COMMUNICATIONS, INC.
Income Statement
For the Month Ended March 31, 20X1
Cell
Conditional Format as
Formatting Table Styles
Styles
fx Presented below are incomplete financial statements for Marta Communications,
3 Required:
4 Solve for the missing amounts. NOTE: When an amount on one financial statement is again shown on
5 another statement, you MUST reference the cell from the earlier statement rather than calculate the amount, thus
DATA REVIEW VIEW
$34,500
2,600
4,800
800
$4,100
?
с
Cells Editing
D
5 X
Sign In
Transcribed Image Text:FILE Paste Clipboard A1 HOME Calibri +A BIU INSERT PAGE LAYOUT 1 - 11 HH 10 11 Sales Revenues 12 Expenses: 13 14 Wages Expense 15 Utilities Expense 16 Income Tax Expense 17 Net income Font Rent Expense Relationships among Financial Statements - Excel FORMULAS -A A B 1 Presented below are incomplete financial statements for Marta Communications, Inc. 2 % Alignment Number 6 indicating the relationship between the two statements. 7 8 MARTA COMMUNICATIONS, INC. Income Statement For the Month Ended March 31, 20X1 Cell Conditional Format as Formatting Table Styles Styles fx Presented below are incomplete financial statements for Marta Communications, 3 Required: 4 Solve for the missing amounts. NOTE: When an amount on one financial statement is again shown on 5 another statement, you MUST reference the cell from the earlier statement rather than calculate the amount, thus DATA REVIEW VIEW $34,500 2,600 4,800 800 $4,100 ? с Cells Editing D 5 X Sign In
Paste
Clipboard
A1
18
19
20
Calibri
B I U +
V 1
40
41
A
29
30
31
32 Assets
33 Cash
34 Accounts receivable
35
36 Land
37 Total Assets
38
39
Font
21
22
23 Retained Earnings, March 1, 20X1
24 Add: Net income
Office supplies
X
MARTA COMMUNICATIONS, INC.
Statement of Retained Earnings
For the Month Ended March 31, 20X1
25 Subtract: Dividends
26 Retained Earnings, March 31, 20X1
27
28
Sheet1
11
...
I
%
Alignment Number Conditional Format as Cell Cells
Formatting Table Styles
Styles
fx Presented below are incomplete financial statements for Marta Communications,
B
$0
(500)
MARTA COMMUNICATIONS, INC.
Balance Sheet
At March 31, 20X1
Liabilities
$3,400 Accounts payable
Stockholders' Equity
Common stock
2,300
12,000 Retained earnings
с
Beep
Total Liabilities and Stockholders' Equity
Editing
D
$6,800
14,000
A
Transcribed Image Text:Paste Clipboard A1 18 19 20 Calibri B I U + V 1 40 41 A 29 30 31 32 Assets 33 Cash 34 Accounts receivable 35 36 Land 37 Total Assets 38 39 Font 21 22 23 Retained Earnings, March 1, 20X1 24 Add: Net income Office supplies X MARTA COMMUNICATIONS, INC. Statement of Retained Earnings For the Month Ended March 31, 20X1 25 Subtract: Dividends 26 Retained Earnings, March 31, 20X1 27 28 Sheet1 11 ... I % Alignment Number Conditional Format as Cell Cells Formatting Table Styles Styles fx Presented below are incomplete financial statements for Marta Communications, B $0 (500) MARTA COMMUNICATIONS, INC. Balance Sheet At March 31, 20X1 Liabilities $3,400 Accounts payable Stockholders' Equity Common stock 2,300 12,000 Retained earnings с Beep Total Liabilities and Stockholders' Equity Editing D $6,800 14,000 A
Expert Solution
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Corporate Financial Accounting
Corporate Financial Accounting
Accounting
ISBN:
9781305653535
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning