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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Topic Video
Question
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: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
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Accounting Equation
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