Exercise 1 Creates a table in MS Excel with each of the following accounts and indicates its effect on the accounting equation. On February 1, 2020, Mike Lammar established a house rental business called Miguel's Rentals. During the month of March, the following transactions were recorded: To open the business, he deposited $60,000 of his personal funds as an investment. He bought equipment for $6,000 on credit. He bought office supplies for $1,500 in cash. He received income from renting a property for $3,500 in cash. He paid the utilities expenses for $800.00. He paid $1,200 of the equipment purchased on credit for the second transaction. He received income from managing renting a building for $4,000 in cash. He provided a $3,000 rental counseling service to a client on credit. He paid wages for $1,500 to his secretary. He made a $500.00 withdrawal for his personal use.

College Accounting, Chapters 1-27
23rd Edition
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:HEINTZ, James A.
Chapter2: Analyzing Transactions: The Accounting Equation
Section: Chapter Questions
Problem 4SEB: EFFECTS OF TRANSACTIONS (BALANCE SHEET ACCOUNTS) Jon Wallace started a business. During the first...
icon
Related questions
Topic Video
Question
Exercise 1
Creates a table in MS Excel with each of the following accounts and indicates its effect on
the accounting equation.
On February 1, 2020, Mike Lammar established a house rental business called Miguel's
Rentals. During the month of March, the following transactions were recorded:
To open the business, he deposited $60,000 of his personal funds as an investment.
He bought equipment for $6,000 on credit.
He bought office supplies for $1,500 in cash.
He received income from renting a property for $3,500 in cash.
He paid the utilities expenses for $800.00.
He paid $1,200 of the equipment purchased on credit for the second transaction.
He received income from managing renting a building for $4,000 in cash.
He provided a $3,000 rental counseling service to a client on credit.
He paid wages for $1,500 to his secretary.
He made a $500.00 withdrawal for his personal use.
Transcribed Image Text:Exercise 1 Creates a table in MS Excel with each of the following accounts and indicates its effect on the accounting equation. On February 1, 2020, Mike Lammar established a house rental business called Miguel's Rentals. During the month of March, the following transactions were recorded: To open the business, he deposited $60,000 of his personal funds as an investment. He bought equipment for $6,000 on credit. He bought office supplies for $1,500 in cash. He received income from renting a property for $3,500 in cash. He paid the utilities expenses for $800.00. He paid $1,200 of the equipment purchased on credit for the second transaction. He received income from managing renting a building for $4,000 in cash. He provided a $3,000 rental counseling service to a client on credit. He paid wages for $1,500 to his secretary. He made a $500.00 withdrawal for his personal use.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 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
  • SEE MORE QUESTIONS
Recommended textbooks for you
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
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
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning