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.

Name: Exercise 1Creates a table in MS Excel with each of the following acco
Uploaded: 2024-03-04T10:43:15.000Z
Channel: Bartleby
Description: Exercise 1Creates a table in MS Excel with each of the following accounts and indicates its effect onthe accounting equation.On February 1, 2020, Mike Lammar established a house rental business called Miguel'sRentals. During the month of March, the

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Can you show me what the general ledgers would look like. I have them done just want to double check my work
The following is the business transaction for August 2020: August 1 Invested cash of RM15000 as a capital to start the business. 1 Rented office and dark room fittings for RM800 in cash for 2 months, August and September. 2 Purchased photography supplies on credit worth RM1920 from Moonlight Enterprise with a credit term of 3/10, n/30. 5 Finished a few job for customers and collected payment of RM150. 6 Received a credit memo amounting to RM120 form Moonlight Enterprise for photography supplies returned due to damage. 8 Finished a photography assignment for Asher's wedding worth RM500 on credit with credit terms of 2/10, n/30. 11 Settled debt to Moonlight Enterprise in full. 16 Withdrew cash of RM200 for personal use. 17 Received full payment from Asher. 20 Completed a photography assignment for Haby Nursery worth RM700 with cash. 25 Received a deposit of RM500 from Women's Club for a booking of photography assignment, which will be held on 20 October 2020 30 Paid wages to the shop…
You are a trainee accountant working for a small firm of accountants. You have been asked to work on a new client, John Oteng. John recently opened a small shop through rented premises. John has supplied you with the following transactions which have taken place during January 2017, his first month of trading. 1st January John opened a business bank account with GH¢10,000 of his own money. 2nd January GH¢20,000 bank loan is paid directly into his bank account. 3rd January John bought office equipment GH¢17,500 and paid by cheque. 4th January GH¢2,000 rent paid by cheque. 5th January Inventory is purchased on credit from Gyato Limited for GH¢5,000. 6th January Inventory is purchased by cheque from Don-Bortey Limited for GH¢3,000. 13th January Cash sales deposited at the bank was GH¢500. 15th January GH¢100 cheque paid for an advert in the local newspaper. 19th January Cash sales deposited at bank was GH¢1,200. 20th January…
Mr. Tristan Siy III established Siy Bookkeeping Services and had the following transactions for the month of February: 4 19 15 18 19 Received P35,000 cash from customers in payment of their account. Paid in cash and received an official receipt 20 from the supplier for payment of accounts, 21 28 28 Investment of P150,000 cash fund by Mr. Siy into the business. 28 Received a Charge Invoice from a supplier for the purchase of a desktop computer amounting to P32,500. The computer is estimated to be useful for five years and have a salvage value of P2,500 thereafter. Purchased supplies amounting to P18,000 in cash. Paid P6,000 insurance for six months. Issued a Service Invoice for an amount of P50,000 to a customer for services rendered on account. P20,000. Rendered services to customers billed for P30,000. Cash payment of P15,000 for the salary of an employee. Mr. Siy withdrew P12,000 cash from the business. Paid the telephone bill for February amounting to P3,000.
Vaibhav
hey I need help figuring out the numbers for these accounting homework assignments. Clint M. Invests $30,000. Into Merle company. The effect to Liabilities would be: ( Type your numeric number) Clint M. Invests $30,000 into Merle Company. The effect to Equity would be: (Type your numeric number) Merle company purchases s piece of equipment for $5,000 on account. The effect to Assets would be: (Type your numeric answer) Merle company purchases a piece of equipment for $5,000. The effect to Liabilities would be: (Type your numeric answer) Merle Company purchases a piece of equipment for $5,000 on account. The effect to Equit would be: (type your numeric answer)
In this activity, you are going to record a comprehensive transactions involving merchandising concern. Prepare the journal entries, T-accounts and trial balance of a merchandising concern. Cielo Bonita is engaged in buying and selling of novelty items. The following transactions have transpired for the month of Sept. 2020. Sept. 1 – She invested P100,500 cash and an old office equipment presently valued at P33,200 which she bought 2 years ago for P50,000. Sept. 2- Purchased MDSE from ABC Enterprise for P20,000. Terms: n/30, FOB destination. ABC paid P1,500 for the freight cost. Sept. 3- Sold MDSE for cash amounted to P10,600. Sept. 6- Purchased MDSE from Ali Commercial for P26,500. Terms: 50% down payment, balance 2/10, n/30. Sept. 7 – Sold MDSE to Jay Cesar for P12,500. Terms: 2/10, n/30, FOB Shipping point. Sept. 8 – Purchased from COVID Furniture a display counted for P6,000. Terms : 50% down payment, balance 1/10, n/30.92 Sept. 9 – Sold MDSE to Giles Anthony for P14,000. Terms:…
Can you make sure everything lines up with the t chart please
*Required: Record the transactions using a general journal. Create your own account titles that will appropriately describe the exchanges of values. Post in T-accounts and compute the total assets, liabilities, and equity.
Give its general ledgers and financial statements
Can you help me create a trial balance and balance sheet please for the following information