Exercise 3 Creates a table in MS Excel with each of the following accounts and indicates its effect on the accounting equation. Creates a table in MS Excel with each of the following accounts and indicates its effect on the accounting equation. To open the business, he deposited $45,000 of his personal funds as an investment. He bought office supplies for $1,000 on credit. He received income from giving a service of $2,000 in cash. Paid for utilities expenses for $400.00. He paid $300 of the materials (supplies) purchased on credit. He received income from service provided for $4,000 in cash. He provided a $3,000 customer service on credit. He paid $1,800 wages to an employee. He made a $200.00 withdrawal for his personal use.

Exercise 3 Creates a table in MS Excel with each of the following accounts and indicates its effect on the accounting equation. Creates a table in MS Excel with each of the following accounts and indicates its effect on the accounting equation. To open the business, he deposited $45,000 of his personal funds as an investment. He bought office supplies for $1,000 on credit. He received income from giving a service of $2,000 in cash. Paid for utilities expenses for $400.00. He paid $300 of the materials (supplies) purchased on credit. He received income from service provided for $4,000 in cash. He provided a $3,000 customer service on credit. He paid $1,800 wages to an employee. He made a $200.00 withdrawal for his personal use.

Name: Exercise 3Creates a table in MS Excel with each of the following acco
Uploaded: 2024-03-04T10:43:15.000Z
Channel: Bartleby
Description: Exercise 3Creates a table in MS Excel with each of the following accounts and indicates its effect onthe accounting equation.Creates a table in MS Excel with each of the following accounts and indicates its effect onthe accounting equation.To open t

College Accounting, Chapters 1-27

23rd Edition

ISBN:9781337794756

Author:HEINTZ, James A.

Publisher:HEINTZ, James A.

Chapter3: The Double-entry Framework

Section: Chapter Questions

Problem 7SEA: ANALYSIS OF TRANSACTIONS Charles Chadwick opened a business called Charlies Detective Service in...

See similar textbooks

Similar questions

Kelly Pitney began her consulting business, Kelly Consulting, on April 1, 2016. The accounting cycle for Kelly Consulting for April, including financial statements, was illustrated in this chapter. During May, Kelly Consulting entered into the following transactions: May 3. Received cash from clients as an advance payment for services to be provided and recorded it as unearned fees, 4,500. 5. Received cash from clients on account, 2,450. 9. Paid cash for a newspaper advertisement, 225. 13. Paid Office Station Co. for part of the debt incurred on April 5, 640. 15. Recorded services provided on account for the period May 115, 9,180. 16. Paid part-time receptionist for two weeks' salary including the amount owed on April 30, 750. 17. Recorded cash from cash clients for fees earned during the period May 116, 8,360. Record the following transactions on Page 6 of the journal: 20. Purchased supplies on account, 735. 21. Recorded services provided on account for the period May 1620, 4,820. 25. Recorded cash from cash clients for fees earned for the period May 1723, 7,900. 27. Received cash from clients on account, 9,520. 28. Paid part-time receptionist for two weeks' salary, 750. 30. Paid telephone bill for May, 260. 31. Paid electricity bill for May, 810. 31. Recorded cash from cash clients for fees earned for the period May 2631, 3,300. 31. Recorded services provided on account for the remainder of May, 2,650. 31. Kelly withdrew 10,500 for personal use. Instructions 1. The chart of accounts for Kelly Consulting is shown in Exhibit 9, and the post-closing trial balance as of April 30, 2016, is shown in Exhibit 17. For each account in the post-closing trial balance, enter the balance in the appropriate Balance column of a four-column account. Date the balances May 1, 2016, and place a check mark () in the Posting Reference column. Journalize each of the May transactions in a two-column journal starting on Page 5 of the journal and using Kelly Consultings chart of accounts. (Do not insert the account numbers in the journal at this time.) 2. Post the journal to a ledger of four-column accounts. 3. Prepare an unadjusted trial balance. 4. At the end of May, the following adjustment data were assembled. Analyze and use these data to complete parts (5) and (6). a. Insurance expired during May is 275. b. Supplies on hand on May 31 are 715. c. Depreciation of office equipment for May is 330. d. Accrued receptionist salary on May 31 is 325. e. Rent expired during May is 1,600. f. Unearned fees on May 31 are 3,210. 5. (Optional) Enter the unadjusted trial balance on an end-of-period spreadsheet and complete the spreadsheet. 6. Journalize and post the adjusting entries. Record the adjusting entries on Page 7 of the journal. 7. Prepare an adjusted trial balance. 8. Prepare an income statement, a statement of owners equity, and a balance sheet. 9. Prepare and post the closing entries. Record the closing entries on Page 8 of the journal. (Income Summary is account #33 in the chart of accounts.) Indicate closed accounts by inserting a line in both the Balance columns opposite the closing entry. 10. Prepare a post-closing trial balance.
Comprehensive problem 1 Kelly Pitney began her consulting business, Kelly Consulting, on April 1, 2016. The accounting cycle for Kelly Consulting for April, including financial statements, was illustrated in this chapter. During May, Kelly Consulting entered into the following transactions: May 3. Received cash from clients as an advance payment for services to be provided and recorded it as unearned fees, 4,500. 5. Received cash from clients on account, 2,450. 9. Paid cash for a newspaper advertisement. 225. 13. Paid Office Station Co. for part of the debt incurred on April 5, 640. 15. Recorded services provided on account for the period May 1-15; 9,180. 16. Paid part-time receptionist for two weeks salary including the amount owed on April 30, 750. 17. Recorded cash from cash clients for fees earned during the period May 1-16, 8,360. Record the following transactions on Page 6 of the journal: 20. Purchased supplies on account, 735. 21. Recorded services provided on account for the period May 16-20, 4,820. 25. Recorded cash from cash clients for fees earned for the period May 17-23, 7,900. 27. Received cash from clients on account, 9,520. 28. Paid part-time receptionist for two weeks salary, 750. 30. Paid telephone bill for May, 260. 31. Paid electricity bill for May, 810. 31. Recorded cash from cash clients for fees earned for the period May 26-31, 3,300. 31. Recorded services provided on account for the remainder of May, 2,650. 31. Paid dividends, 10,500. Instructions 1. The chart of accounts for Kelly Consulting is shown in Exhibit 9, and the post-closing trial balance as of April 30, 2016, is shown in Exhibit 17. For each account in the post-closing trial balance, enter the balance in the appropriate Balance column of a four-column account. Date the balances May 1, 2016, and place a check mark () in the Posting Reference column. Journalize each of the May transactions in a two- column journal starting on Page 5 of the journal and using Kelly Consultings chart of accounts. (Do not insert the account numbers in the journal at this time.) 2. Post the journal to a ledger of four-column accounts. 3. Prepare an unadjusted trial balance. 4. At the end of May, the following adjustment data were assembled. Analyze and use these data to complete parts (5) and (6). a. Insurance expired during May is 275. b. Supplies on hand on May 31 are 715. c. Depreciation of office equipment for May is 330. d. Accrued receptionist salary on May 31 is 325. e. Rent expired during May is 1,600. f. Unearned fees on May 31 are 3,210. 5. (Optional) Enter the unadjusted trial balance on an end-of-period spreadsheet and complete the spreadsheet. 6. Journalize and post the adjusting entries. Record the adjusting entries on Page 7 of the journal. 7. Prepare an adjusted trial balance. 8. Prepare an income statement, a retained earnings statement, and a balance sheet. 9. Prepare and post the closing entries. Record the closing entries on Page 8 of the journal. (Income Summary is account 34 in the chart of accounts.) Indicate closed accounts by inserting a line in both the Balance columns opposite the closing entry. 10. Prepare a post-closing trial balance.
Transactions; financial statements 2. Net income: 10,850 On April 1, 20Y8, Maria Adams established Custom Realty. Maria completed the following transactions during the month of April: a. Opened a business bank account with a deposit of 24,000 in exchange for common stock. b. Paid rent on office and equipment for the month, 3,600. c. Paid automobile expenses for month, 1,350, and miscellaneous expenses, 600. d. Purchased supplies on account, 1,200. e. Earned sales commissions, receiving cash, 19,800. f. Paid creditor on account, 750. g. Paid office salaries, 2,500. h. Paid dividends, 3,500. i. Determined that the cost of supplies on hand was 300; therefore, the cost of supplies used was 900. Instructions 1. Indicate the effect of each transaction and the balances after each transaction, using the following tabular headings: 2. Prepare an income statement for April, a statement of stockholders equity for April, and a balance sheet as of April 30.
EFFECTS OF TRANSACTIONS (BALANCE SHEET ACCOUNTS) Jon Wallace started a business. During the first month (March 20--), the following transactions occurred. Show the effect of each transaction on the accounting equation: Assets= Liabilities + Owners Equity. After each transaction, show the new account totals. (a) Invested cash in the business, 30,000. (b) Bought office equipment on account, 4,500. (c) Bought office equipment for cash, 1,600. (d) Paid cash on account to supplier in transaction (b), 2,000. EFFECTS OF TRANSACTIONS (REVENUE, EXPENSE, WITHDRAWALS) This exercise is an extension of Exercise 2-3B. Lets assume Jon Wallace completed the following additional transactions during March. Show the effect of each transaction on the basic elements of the expanded accounting equation: Assets = Liabilities + Owners Equity (Capital Drawing + Revenues Expenses). After transaction (k), report the totals for each element. Demonstrate that the accounting equation has remained in balance. (e) Performed services and received cash, 3,000. (f) Paid rent for March, 1,000. (g) Paid March phone bill, 68. (h) Jon Wallace withdrew cash for personal use, 800. (i) Performed services for clients on account, 900. (j) Paid wages to part-time employee, 500. (k) Received cash for services performed on account in transaction (i), 500.
J. Carrie established Carries Photo Tours during June of this year. The accountant prepared the following chart of accounts: The following transactions occurred during the month of June: a. Carrie deposited 30,000 cash in a bank account in the name of the business. b. Bought office equipment for cash, 1,850, Ck. No. 1001 c. Bought computer software from Moreys Computer Center, 640, paying 350 in cash and placing the balance on account, Ck. No. 1002. d. Paid current months rent, 950, Ck. No. 1003. e. Sold services for cash, 1,575. f. Bought a neon sign from The Sign Company, 1,335, paying 435 in cash and placing the balance on account, Ck. No. 1004. g. Received bill from The Gossiper for advertising, 445. h. Bought supplies on account from City Supply, 460. i. Received and paid the electric bill, 380, Ck. No. 1005. j. Paid on account to The Gossiper, 245, Ck. No. 1006. k. Sold services for cash, 3,474. l. Paid wages to an employee, 930, Ck. No. 1007. m. Carrie invested his personal computer with a fair market value of 1,000 in the business. n. Carrie withdrew cash for personal use, 800, Ck. No. 1008. o. Received and paid the bill for city business license, 75, Ck. No. 1009. Required 1. Record the owners name in the Capital and Drawing T accounts. 2. Correctly place the plus and minus signs for each T account and label the debit and credit sides of the accounts. 3. Record the transactions in the T accounts. Write the letter of each entry to identify the transaction. 4. Foot the T accounts and show the balances. 5. Prepare a trial balance, with a three-line heading, dated June 30, 20--.
ANALYSIS OF T ACCOUNTS Richard Gibbs began a business called Richards Shoe Repair. 1. Create T accounts for Cash; Supplies; Richard Gibbs, Capital; and Utilities Expense. Identify the following transactions by letter and place them on the proper side of the T accounts: (a) Invested cash in the business, 6,500. (b) Purchased supplies for cash, 700. (c) Paid utility bill, 2,700. 2. Foot the T account for cash and enter the ending balance.
ANALYSIS OF TRANSACTIONS Nicole Lawrence opened a business called Nickies Neat Ideas in January 20--. Set up T accounts for the following accounts: Cash; Accounts Receivable; Office Supplies; Computer Equipment; Office Furniture; Accounts Payable; Nicole Lawrence, Capital; Nicole Lawrence, Drawing; Professional Fees; Rent Expense; and Utilities Expense. The following transactions occurred during the first month of business. Record these transactions in T accounts. After all transactions have been recorded, foot and balance the accounts if necessary. (a) Invested cash in the business, 8,000. (b) Purchased office supplies for cash, 500. (c) Purchased office furniture for cash, 8,000. (d) Purchased computer and printer on account, 5,000. (e) Received cash from clients for services, 4,000. (f) Paid cash on account for computer and printer purchased in transaction (d), 2,000. (g) Earned professional fees on account during the month, 7,000. (h) Paid office rent for January, 900. (i) Paid utility bills for the month, 600. (j) Received cash from clients that were billed previously in transaction (g), 3,000. (k) Withdrew cash for personal use, 4,000. TRIAL BALANCE Based on the transactions recorded in Exercise 3-7B, prepare a trial balance for Nickies Neat Ideas as of January 31, 20--.
Problem 2-56A Analyzing Transactions Luis Madero, after working for several years with a large public accounting firm decided to open his own accounting service. The business is operated as a corporation under the name Madero Accounting Services. The following captions and amounts summarize Maderos balance sheet at July 31, 2019. The following events occurred during August 2019. Issued common stock to Ms. Garriz in exchange for $15,000 cash. Paid $850 for first months rent on office space. Purchased supplies of $2,250 on credit. Borrowed $8,000 from the bank. Paid $1,080 on account for supplies purchased earlier on credit. Paid secretarys salary for August of $2,150. Performed amounting services for clients who paid cash upon completion of the service in the total amount of $4,700. Used $3,180 of the supplies on hand. Perfumed accounting services for clients on credit in the total amount of $1,920. Purchased $500 in supplies for cash. Collected $1,290 cash from clients for whom services were performed on credit. Paid $1,000 dividend to stockholders. Required: Record the effects of the transactions listed above on the accounting equation. Use the format given in the problem, starting with the totals at July 31, 20l9. Prepare the trial balance at August 31, 2019.
ANALYSIS OF TRANSACTIONS Nicole Lawrence opened a business called Nickies Neat Ideas in January 20--. Set up T accounts for the following accounts: Cash; Accounts Receivable; Office Supplies; Computer Equipment; Office Furniture; Accounts Payable; Nicole Lawrence, Capital; Nicole Lawrence, Drawing; Professional Fees; Rent Expense; and Utilities Expense. The following transactions occurred during the first month of business. Record these transactions in T accounts. After all transactions have been recorded, foot and balance the accounts if necessary. (a) Invested cash in the business, 18,000. (b) Purchased office supplies for cash, 500. (c) Purchased office furniture for cash, 8,000. (d) Purchased computer and printer on account, 5,000. (e) Received cash from clients for services, 4,000. (f) Paid cash on account for computer and printer purchased in transaction (d), 2,000. (g) Earned professional fees on account during the month, 7,000. (h) Paid office rent for January, 900. (i) Paid utility bills for the month, 600. (j) Received cash from clients that were billed previously in transaction (g), 3,000. (k) Withdrew cash for personal use, 4,000.
TRANSACTION ANALYSIS George Atlas started a business on June 1,20--. Analyze the following transactions for the first month of business using T accounts. Label each T account with the title of the account affected and then place the transaction letter and the dollar amount on the debit or credit side. (a ) Invested cash in the business, 7,000. (b) Purchased equipment for cash, 900. (c) Purchased equipment on account, 1,500. (d) Paid cash on account for equipment purchased in transaction (c), 800. (e) Withdrew cash for personal use, 1,100. FOOT AND BALANCE T ACCOUNTS Foot and balance the T accounts prepared in Exercise 3-5B if necessary.
ANALYSIS OF TRANSACTIONS Charles Chadwick opened a business called Charlies Detective Service in January 20--. Set up T accounts for the following accounts: Cash; Accounts Receivable; Office Supplies; Computer Equipment; Office Furniture; Accounts Payable; Charles Chadwick, Capital; Charles Chadwick, Drawing; Professional Fees; Rent Expense; and Utilities Expense. The following transactions occurred during the first month of business. Record these transactions in T accounts. After all transactions are recorded, foot and balance the accounts if necessary. (a) Invested cash in the business, 30,000. (b) Bought office supplies for cash, 300. (c) Bought office furniture for cash, 5,000. (d) Purchased computer and printer on account, 8,000. (e) Received cash from clients for services, 3,000. (f) Paid cash on account for computer and printer purchased in transaction (d), 4,000. (g) Earned professional fees on account during the month, 9,000. (h) Paid cash for office rent for January, 1,500. (i) Paid utility bills for the month, 800. (j) Received cash from clients billed in transaction (g), 6,000. (k) Withdrew cash for personal use, 3,000.