Creates a table in MS Excel with each of the following accounts and indicates their effect...

 

Transcribed Image Text:

Creates a table in MS Excel with each of the following accounts and indicates their effect on the expanded accounting equation . The 1. in February 2020, Miguel Toro established a home rental business under the name Miguel's Rentals. During the month of March, the following transactions were recorded: o To open the business, he deposited $70,000 of his personal funds as an investment. He bought equipment for $5,000 in cash. o Purchased office supplies for $1,500 on credit. O He received income from renting a property for $3,500 in cash. o He paid for utilities for $800.00. O He paid $1,200 of the equipment purchased on credit from the third transaction. He received income from managing the rent of a building for $4,000 in cash. He provided a rental counseling service to a client for $3,000 on credit. He paid salaries of $1,500 to his secretary. He made a withdrawal of $500.00 for his personal use. O O O O Creates a table in MS Excel with each of the following accounts and indicates their effect on the expanded accounting equation . The 1. in February 2020, Miguel Toro established a home rental business under the name Miguel's Rentals. During the month of March, the following transactions were recorded: o To open the business, he deposited $70,000 of his personal funds as an investment. He bought equipment for $5,000 in cash. o Purchased office supplies for $1,500 on credit. O He received income from renting a property for $3,500 in cash. o He paid for utilities for $800.00. O He paid $1,200 of the equipment purchased on credit from the third transaction. He received income from managing the rent of a building for $4,000 in cash. He provided a rental counseling service to a client for $3,000 on credit. He paid salaries of $1,500 to his secretary. He made a withdrawal of $500.00 for his personal use. O O O O

Answer rating: 100% (QA)

The expanded accounting equation is a modification of the traditional accounting equation which states that Assets Liabilities Owners Equity The expanded accounting equation is shown below Assets Liab... View the full answer