A newly formed company provides the following list of transactions. Transaction 1 2 3 4 5 6 Description Started the company by issuing common stock Borrow cash by signing a note Provided services to customers on account Purchased supplies on account Paid employees' salaries for the current month Paid dividends to stockholders Amount Required: 1. Determine the impact of each transaction on the accounting equation. Note: Not every cell will require a formula or cell reference. If neither is needed, then leave the cell blank. (Use cells A2 to C10 from the given information above to complete this question.) $45,000 $9,000 $12,000 $3,000 $6,000 $4,000
A newly formed company provides the following list of transactions. Transaction 1 2 3 4 5 6 Description Started the company by issuing common stock Borrow cash by signing a note Provided services to customers on account Purchased supplies on account Paid employees' salaries for the current month Paid dividends to stockholders Amount Required: 1. Determine the impact of each transaction on the accounting equation. Note: Not every cell will require a formula or cell reference. If neither is needed, then leave the cell blank. (Use cells A2 to C10 from the given information above to complete this question.) $45,000 $9,000 $12,000 $3,000 $6,000 $4,000
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Topic Video
Question

Transcribed Image Text:1
2
A newly formed company provides the following list of transactions.
3
4
5
6
7
8
9
17
18
19
Transaction
1
20
21
2
3
4
5
6
Transaction
1
2
B
10
11
12 Required:
13 1. Determine the impact of each transaction on the accounting equation.
14
Note: Not every cell will require a formula or cell reference. If neither is needed, then leave the cell blank.
15 (Use cells A2 to C10 from the given information above to complete this question.)
16
3
4
Description
Started the company by issuing common stock
Borrow cash by signing a note
Provided services to customers on account
Purchased supplies on account
Paid employees' salaries for the current month
Paid dividends to stockholders
Assets
$45,000✔
$9,000
$12,000
Amount
$3,000✔
The oooLA
$45,000
$9,000
$12,000
$3,000
$6,000
$4,000
=
D
Liabilities
$9,000✔
$3,000✔
E
F
+ Stockholders' Equity
$45,000
$12,000
Tê Goo! ▲
G

Transcribed Image Text:17
18
19
20
21
22
23
24
25
26
Transaction
30
31
32
2
3
4
5
6
Does the accounting equation balance?
Assets
Yes
$45,000
$9,000✔
$12,000
$3,000
($6,000)
($4,000)
$44,000
2. Use a conditional statement to evaluate whether the accounting equation balances.
27
(Use cells A2 to C10 from the given information above to complete this question. Construct a conditional IF
statement to return the word "Yes" if the accounting equation is in balance or "No" if it is not. In your formula, use
28 cell B24 for total assets, cell D24 for total liabilities, and cell F24 for total stockholders' equity.)
29
=
=
Liabilities
$9,000✔
$3,000
$3,000 X
+
+
Stockholders' Equity
$45,000
$12,000
($6,000)
($4,000)
$47,000 X
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images

Knowledge Booster
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.Recommended textbooks for you


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education