Homework Help is Here – Start Your Trial Now!
Business
Accounting
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.

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 (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
13th Edition
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:Scott, Cathy J.
Chapter2: T Accounts, Debits And Credits, Trial Balance, And Financial Statements
Section: Chapter Questions
Problem 2PA: B. Kelso established Computer Wizards during November of this year. The accountant prepared the...
See similar textbooks
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

SEE SOLUTIONCheck out a sample Q&A here
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 (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
PFIN (with PFIN Online, 1 term (6 months) Printed…
PFIN (with PFIN Online, 1 term (6 months) Printed…
Finance
ISBN:
9781337117005
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
SEE MORE TEXTBOOKS