Fredonia Repair Inc. was started on May 1. A summary of May transactions is presented below. 1. Stockholders invested $10,000 cash in the business in exchange for common stock. 2. Purchased equipment for $5,000 cash. 3. Paid $400 cash for May office rent. 4. Paid $300 cash for supplies. 5. Incurred $250 of advertising costs in the Beacon News on account. 6. Received $4,700 in cash from customers for repair service. 7. Declared and paid a $700 cash dividend. 8. Paid part-time employee salaries $1,000. 9. Paid utility bills $140 10. Performed repair services worth $1,100 on account. 11. Collected cash of $120 for services billed in transaction (10). Instructions (a) Prepare a tabular analysis of the transactions, using the following column headings: Cash, Accounts Receivable, Supplies, Equipment, Accounts Payable, Common Stock, and Retained Earnings (with separate columns for Revenues, and Expenses and Dividends.) Include margin explanations for any changes in Retained Earnings. Revenue is called Service Revenue. (b) From an analysis of the Retained Earnings columns, compute the net income or net loss for May.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter1: Business Transactions (ptrans)
Section: Chapter Questions
Problem 3R: On June 1 of the current year, Wilson Wood opened Woodys Web Services. This sole proprietorship had...
icon
Related questions
icon
Concept explainers
Question
Question
Fredonia Repair Inc. was started on May 1. A summary of May transactions is presented below.
1.
Stockholders invested $10,000 cash in the business in exchange for common stock.
2.
Purchased equipment for $5,000 cash.
3.
Paid $400 cash for May office rent.
4.
Paid $300 cash for supplies.
s.
Incurred $250 of advertising costs in the Beacon News on account.
6.
Received $4,700 in cash from customers for repair service.
7.
Declared and paid a $700 cash dividend.
8.
Paid part-time employee salaries $1,000.
9.
Paid utility bills $140
10. Performed repair services worth $1,100 on account.
11. Collected cash of $120 for services billed in transaction (10).
Instructions
(a) Prepare a tabular analysis of the transactions, using the following column headings:
Cash, Accounts Receivable, Supplies, Equipment, Accounts Payable, Common Stock,
and Retained Earnings (with separate columns for Revenues, and Expenses and Dividends.)
Include margin explanations for any changes in Retained Earnings. Revenue is called Service
Revenue.
(b) From an analysis of the Retained Earnings columns, compute the net income or net loss
for May.
NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?".
Answer
|(a)
FREDONIA REPAIR INC.
Stockholders' Equity
Retained Earnings
Accounts
Accounts
Common
Cash
Receivable
Supplies
Equipment =
Payable
Stock
Revenues
Expenses
Dividends
1.
2.
3.
4.
s.
6.
7.
8.
9.
10
11
10,000
5,000
-5,000
-400
400
-300
300
-250
250
4,700
-700
700
-1,100
-1,100
140
1,100
120
$1,950
$120
$0
$5,000
$250
$5,000
$0
$840
$700
+
Does it balance?
$7,070
$6,790
(b) Service Revenue
$120
Expenses:
Salaries and wages expense
$1,000
Rent expense
400
Transcribed Image Text:Question Fredonia Repair Inc. was started on May 1. A summary of May transactions is presented below. 1. Stockholders invested $10,000 cash in the business in exchange for common stock. 2. Purchased equipment for $5,000 cash. 3. Paid $400 cash for May office rent. 4. Paid $300 cash for supplies. s. Incurred $250 of advertising costs in the Beacon News on account. 6. Received $4,700 in cash from customers for repair service. 7. Declared and paid a $700 cash dividend. 8. Paid part-time employee salaries $1,000. 9. Paid utility bills $140 10. Performed repair services worth $1,100 on account. 11. Collected cash of $120 for services billed in transaction (10). Instructions (a) Prepare a tabular analysis of the transactions, using the following column headings: Cash, Accounts Receivable, Supplies, Equipment, Accounts Payable, Common Stock, and Retained Earnings (with separate columns for Revenues, and Expenses and Dividends.) Include margin explanations for any changes in Retained Earnings. Revenue is called Service Revenue. (b) From an analysis of the Retained Earnings columns, compute the net income or net loss for May. NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". Answer |(a) FREDONIA REPAIR INC. Stockholders' Equity Retained Earnings Accounts Accounts Common Cash Receivable Supplies Equipment = Payable Stock Revenues Expenses Dividends 1. 2. 3. 4. s. 6. 7. 8. 9. 10 11 10,000 5,000 -5,000 -400 400 -300 300 -250 250 4,700 -700 700 -1,100 -1,100 140 1,100 120 $1,950 $120 $0 $5,000 $250 $5,000 $0 $840 $700 + Does it balance? $7,070 $6,790 (b) Service Revenue $120 Expenses: Salaries and wages expense $1,000 Rent expense 400
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
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
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Financial Reporting, Financial Statement Analysis…
Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781305084087
Author:
Cathy J. Scott
Publisher:
Cengage Learning