Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 1, Problem 2R
On June 1 of the current year, Wilson Wood opened Woodyʼs Web Services. This sole proprietorship had the following transactions during June.
- a. Opened a business checking account and made a deposit, $9,000.
- b. Paid rent for June for office space and computer equipment, $3,000.
- c. Purchased office supplies (stamps, pens, etc.) on account, $1,980.
- d. Received cash for services rendered, $4,500.
- e. Paid creditor for office supplies purchased on account, $1,400.
- f. Purchased office supplies for cash, $420.
- g. Billed clients for consultations performed on account, $4,600.
- h. Paid monthly internet service bill of $360.
- i. Paid the secretaryʼs salary of $2,400.
- j. Returned $300 of office supplies purchased in transaction f. Received a full refund.
- k. Received cash from clients previously billed, $3,000.
- l. Cash was withdrawn for ownerʼs personal use, $2,000.
Open the file PTRANS from the website for this book at cengagebrain.com. Enter the formulas in the appropriate cells on the worksheet. Then enter the increases and decreases resulting from each transaction on the worksheet. For example, the first transaction increases the cash account by $9,000 and also increases the capital account by $9,000. This transaction has already been recorded on the worksheet. The worksheet will automatically total each column as values are entered in that column. Enter negative numbers with a minus sign (–). When you are finished, check row 26 to make sure that total assets equal total liabilities and equity.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Chapter 1 Solutions
Excel Applications for Accounting Principles
Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - Prob. 7R
Knowledge Booster
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
- In July of this year, M. Wallace established a business called Wallace Realty. The account headings are presented below. Transactions completed during the month follow. a. Wallace deposited 24,000 in a bank account in the name of the business. b. Paid the office rent for the current month, 650, Ck. No. 1000. c. Bought office supplies for cash, 375, Ck. No. 1001. d. Bought office equipment on account from Dellos Computers, 6,300. e. Received a bill from the City Crier for advertising, 455. f. Sold services for cash, 3,944. g. Paid on account to Dellos Computers, 1,500, Ck. No. 1002. h. Received and paid the bill for utilities, 340, Ck. No. 1003. i. Paid on account to the City Crier, 455, Ck. No. 1004. j. Paid truck expenses, 435, Ck. No. 1005. k. Wallace withdrew cash for personal use, 1,500, Ck. No. 1006. Required 1. Record the transactions and the balance after each transaction. 2. Total the left side of the accounting equation (left side of the equal sign), then total the right side of the accounting equation (right side of the equal sign). If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.arrow_forwardOn March 1 of this year, B. Gervais established Gervais Catering Service. The account headings are presented below. Transactions completed during the month follow. a. Gervais deposited 25,000 in a bank account in the name of the business. b. Bought a truck from Kelly Motors for 26,329, paying 8,000 in cash and placing the balance on account, Ck. No. 500. c. Bought catering equipment on account from Luigis Equipment, 3,795. d. Paid the rent for the month, 1,255, Ck. No. 501. e. Bought insurance for the truck for one year, 400, Ck. No. 502. f. Sold catering services for cash for the first half of the month, 3,012. g. Bought supplies for cash, 185, Ck. No. 503. h. Sold catering services on account, 4,307. i. Received and paid the heating bill, 248, Ck. No. 504. j. Received a bill from GC Gas and Lube for gas and oil for the truck, 128. k. Sold catering services for cash for the remainder of the month, 2,649. l. Gervais withdrew cash for personal use, 1,550, Ck. No. 505. m. Paid the salary of the assistant, 1,150, Ck. No. 506. Required 1. Record the transactions and the balance after each transaction. 2. Total the left side of the accounting equation (left side of the equal sign), then total the right side of the accounting equation (right side of the equal sign). If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.arrow_forwardP. Schwartz, Attorney at Law, opened his office on October 1. The account headings are presented below. Transactions completed during the month follow. a. Schwartz deposited 25,000 in a bank account in the name of the business. b. Bought office equipment on account from QuipCo, 9,670. c. Schwartz invested his personal law library, which cost 2,800. d. Paid the office rent for the month, 1,700, Ck. No. 2000. e. Bought office supplies for cash, 418, Ck. No. 2001. f. Bought insurance for two years, 944, Ck. No. 2002. g. Sold legal services for cash, 8,518. h. Paid the salary of the part-time receptionist, 1,820, Ck. No. 2003. i. Received and paid the telephone bill, 388, Ck. No. 2004. j. Received and paid the bill for utilities, 368, Ck. No. 2005. k. Sold legal services for cash, 9,260. l. Paid on account to QuipCo, 2,670, Ck. No. 2006. m. Schwartz withdrew cash for personal use, 2,500, Ck. No. 2007. Required 1. Record the transactions and the balance after each transaction. 2. Total the left side of the accounting equation (left side of the equal sign), then total the right side of the accounting equation (right side of the equal sign). If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.arrow_forward
- On July 1, K. Resser opened Ressers Business Services. Ressers accountant listed the following chart of accounts: The following transactions were completed during July: a. Resser deposited 25,000 in a bank account in the name of the business. b. Bought tables and chairs for cash, 725, Ck. No. 1200. c. Paid the rent for the current month, 1,750, Ck. No. 1201. d. Bought computers and copy machines from Ferber Equipment, 15,700, paying 4,000 in cash and placing the balance on account, Ck. No. 1202. e. Bought supplies on account from Wigginss Distributors, 535. f. Sold services for cash, 1,742. g. Bought insurance for one year, 1,375, Ck. No. 1203. h. Paid on account to Ferber Equipment, 700, Ck. No. 1204. i. Received and paid the electric bill, 438, Ck. No. 1205. j. Paid on account to Wigginss Distributors, 315, Ck. No. 1206. k. Sold services to customers for cash for the second half of the month, 820. l. Received and paid the bill for the business license, 75, Ck. No. 1207. m. Paid wages to an employee, 1,200, Ck. No. 1208. n. Resser withdrew cash for personal use, 700, Ck. No. 1209. 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 as of July 31, 20--. 6. Prepare an income statement for July 31, 20--. 7. Prepare a statement of owners equity for July 31, 20--. 8. Prepare a balance sheet as of July 31, 20--. LO 1, 2, 3, 4, 5, 6arrow_forwardOn March 1 of this year, B. Gervais established Gervais Catering Service. The account headings are presented below. Transactions completed during the month follow. a. Gervais deposited 25,000 in a bank account in the name of the business. b. Bought a truck from Kelly Motors for 26,329, paying 8,000 in cash and placing the balance on account, Ck. No. 500. c. Bought catering equipment on account from Luigis Equipment, 3,795. d. Paid the rent for the month, 1,255, Ck. No. 501 (Rent Expense). e. Bought insurance for the truck for one year, 400, Ck. No. 502. f. Sold catering services for cash for the first half of the month, 3,012 (Catering Income). g. Bought supplies for cash, 185, Ck. No. 503. h. Sold catering services on account, 4,307 (Catering Income). i. Received and paid the heating bill, 248, Ck. No. 504 (Utilities Expense). j. Received a bill from GC Gas and Lube for gas and oil for the truck, 128 (Gas and Oil Expense). k. Sold catering services for cash for the remainder of the month, 2,649 (Catering Income). l. Gervais withdrew cash for personal use, 1,550, Ck. No. 505. m. Paid the salary of the assistant, 1,150, Ck. No. 506 (Salary Expense). Required 1. In the equation, write the owners name above the terms Capital and Drawing. 2. Record the transactions and the balance after each transaction. Identify the account affected when the transaction involves revenues or expenses. 3. Write the account totals from the left side of the equals sign and add them. Write the account totals from the right side of the equals sign and add them. If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.arrow_forwardOn June 1 of this year, J. Larkin, Optometrist, established the Larkin Eye Clinic. The clinics account names are presented below. Transactions completed during the month follow. a. Larkin deposited 25,000 in a bank account in the name of the business. b. Paid the office rent for the month, 950, Ck. No. 1001 (Rent Expense). c. Bought supplies for cash, 357, Ck. No. 1002. d. Bought office equipment on account from NYC Office Equipment Store, 8,956. e. Bought a computer from Wardens Office Outfitters, 1,636, paying 750 in cash and placing the balance on account, Ck. No. 1003. f. Sold professional services for cash, 3,482 (Professional Fees). g. Paid on account to Wardens Office Outfitters, 886, Ck. No. 1004. h. Received and paid the bill for utilities, 382, Ck. No. 1005 (Utilities Expense). i. Paid the salary of the assistant, 1,050, Ck. No. 1006 (Salary Expense). j. Sold professional services for cash, 3,295 (Professional Fees). k. Larkin withdrew cash for personal use, 1,250, Ck. No. 1007. Required 1. In the equation, write the owners name above the terms Capital and Drawing. 2. Record the transactions and the balance after each transaction. Identify the account affected when the transaction involves revenues or expenses. 3. Write the account totals from the left side of the equals sign and add them. Write the account totals from the right side of the equals sign and add them. If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.arrow_forward
- During December of this year, G. Elden established Ginnys Gym. The following asset, liability, and owners equity accounts are included in the chart of accounts: During December, the following transactions occurred: a. Elden deposited 35,000 in a bank account in the name of the business. b. Bought exercise equipment for cash, 8,150, Ck. No. 1001. c. Bought advertising on account from Hazel Company, 105. d. Bought a display rack on account from Cyber Core, 790. e. Bought office equipment on account from Office Aids, 185. f. Elden invested her exercise equipment with a fair market value of 1,200 in the business. g. Made a payment to Cyber Core, 200, Ck. No. 1002. h. Sold services for the month of December for cash, 800. Required 1. Write the account classifications (Assets, Liabilities, Capital, Drawing, Revenue, Expense) in the fundamental accounting equation, as well as the plus and minus signs and Debit and Credit. 2. Write the account names on the T accounts under the classifications, place the plus and minus signs for each T account, and label the debit and credit sides of the T accounts 3. Record the amounts in the proper positions in the T accounts. Write the letter next to each entry to identify the transaction. 4. Foot and balance the accounts.arrow_forwardDuring February of this year, H. Rose established Rose Shoe Hospital. The following asset, liability, and owners equity accounts are included in the chart of accounts: The following transactions occurred during the month of February: a. Rose deposited 25,000 cash in a bank account in the name of the business. b. Bought shop equipment for cash, 1,525, Ck. No. 1000. c. Bought advertising on account from Milland Company, 325. d. Bought store shelving on account from Inger Hardware, 750. e. Bought office equipment from Sharas Office Supply, 625, paying 225 in cash and placing the balance on account, Ck. No. 1001. f. Paid on account to Inger Hardware, 750, Ck. No. 1002. g. Rose invested his personal leather working tools with a fair market value of 800 in the business h. Sold services for the month of February for cash, 250. PART 1: The Accounting Cycle for a Service Business: Analyzing Business Transactions Required 1. Write the account classifications (Assets, Liabilities, Capital, Drawing, Revenue, Expense) in the fundamental accounting equation, as well as the plus and minus signs and Debit and Credit. 2. Write the account names on the T accounts under the classifications, place the plus and minus signs for each T account, and label the debit and credit sides of the T accounts. 3. Record the amounts in the proper positions in the T accounts. Write the letter next to each entry to identify the transaction. 4. Foot and balance the accounts.arrow_forwardOn June 1 of this year, J. Larkin, Optometrist, established the Larkin Eye Clinic. The clinics account names are presented below. Transactions completed during the month follow. a. Larkin deposited 25,000 in a bank account in the name of the business. b. Paid the office rent for the month, 950, Ck. No. 1001. c. Bought supplies for cash, 357, Ck. No. 1002. d. Bought office equipment on account from NYC Office Equipment Store, 8,956. e. Bought a computer from Wardens Office Outfitters, 1,636, paying 750 in cash and placing the balance on account, Ck. No. 1003. f. f. Sold professional services for cash, 3,482. g. Paid on account to Wardens Office Outfitters, 886, Ck. No. 1004. h. Received and paid the bill for utilities, 382, Ck. No. 1005. i. Paid the salary of the assistant, 1,050, Ck. No. 1006. j. Sold professional services for cash, 3,295. k. Larkin withdrew cash for personal use, 1,250, Ck. No. 1007. Required 1. Record the transactions and the balance after each transaction. 2. Total the left side of the accounting equation (left side of the equal sign), then total the right side of the accounting equation (right side of the equal sign). If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.arrow_forward
- B. Kelso established Computer Wizards during November of this year. The accountant prepared the following chart of accounts: The following transactions occurred during the month: a. Kelso deposited 45,000 in a bank account in the name of the business. b. Paid the rent for the current month, 1,800, Ck. No. 2001. c. Bought office desks and filing cabinets for cash, 790, Ck. No. 2002. d. Bought a computer and printer from Cyber Center for use in the business, 2,700, paying 1,700 in cash and placing the balance on account, Ck. No. 2003. e. Bought a neon sign on account from Signage Co., 1,350. f. Kelso invested her personal computer software with a fair market value of 600 in the business. g. Received a bill from Country News for newspaper advertising, 365. h. Sold services for cash, 1,245. i. Received and paid the electric bill, 345, Ck. No. 2004. j. Paid on account to Country News, a creditor, 285, Ck. No. 2005. k. Sold services for cash, 1,450. l. Paid wages to an employee, 925, Ck. No. 2006. m. Received and paid the bill for the city business license, 75, Ck. No. 2007. n. Kelso withdrew cash for personal use, 850, Ck. No. 2008. o. Kelso withdrew cash for personal use, 850, Ck. No. 2008. 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 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 November 30, 20--.arrow_forwardOn July 1 of this year, R. Green established the Green Rehab Clinic. The organizations account headings are presented below. Transactions completed during the month of July follow. a. Green deposited 30,000 in a bank account in the name of the business. b. Paid the office rent for the month, 1,800, Ck. No. 2001 (Rent Expense). c. Bought supplies for cash, 362, Ck. No. 2002. d. Bought professional equipment on account from Rehab Equipment Company, 18,000. e. Bought office equipment from Hi-Tech Computers, 2,890, paying 890 in cash and placing the balance on account, Ck. No. 2003. f. Sold professional services for cash, 4,600 (Professional Fees). g. Paid on account to Rehab Equipment Company, 700, Ck. No. 2004. h. Received and paid the bill for utilities, 367, Ck. No. 2005 (Utilities Expense). i. Paid the salary of the assistant, 1,150, Ck. No. 2006 (Salary Expense). j. Sold professional services for cash, 3,868 (Professional Fees). k. Green withdrew cash for personal use, 1,800, Ck. No. 2007. Required 1. In the equation, write the owners name above the terms Capital and Drawing. 2. Record the transactions and the balance after each transaction. Identify the account affected when the transaction involves revenues or expenses. 3. Write the account totals from the left side of the equals sign and add them. Write the account totals from the right side of the equals sign and add them. If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.arrow_forwardJournal entries and trial balance On August 1, 20Y7, Rafael Masey established Planet Realty, which completed the following transactions during the month: a. Rafael Masey transferred cash from a personal bank account to an account to be used for the business in exchange for common stock, 17,500. b. Purchased supplies on account, 2,300. c. Earned sales commissions, receiving cash, 13,300. d. Paid rent on office and equipment for the month, 3,000. e. Paid creditor on account, 1,150. f. Paid dividends, 1,800. g. Paid automobile expenses (including rental charge) for month, 1,500, and miscellaneous expenses, 400. h. Paid office salaries, 2,800. i. Determined that the cost of supplies used was 1,050. Instructions 1. Journalize entries for transactions (a) through (i), using the following account titles: Cash, Supplies, Accounts Payable, Common Stock, Dividends, Sales Commissions, Rent Expense, Office Salaries Expense, Automobile Expense, Supplies Expense, Miscellaneous Expense. Journal entry explanations may be omitted. 2. Prepare T accounts, using the account titles in (1). Post the journal entries to these accounts, placing the appropriate letter to the left of each amount to identify the transactions. Determine the account balances, after all posting is complete. Accounts containing only a single entry do not need a balance. 3. Prepare an unadjusted trial balance as of August 31, 20Y7. 4. Determine the following: a. Amount of total revenue recorded in the ledger. b. Amount of total expenses recorded in the ledger. c. Amount of net income for August. 5. Determine the increase or decrease in retained earnings for August.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
College Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
College Accounting (Book Only): A Career ApproachAccountingISBN:9781305084087Author:Cathy J. ScottPublisher:Cengage Learning
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781305084087
Author:Cathy J. Scott
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
The accounting cycle; Author: Alanis Business academy;https://www.youtube.com/watch?v=XTspj8CtzPk;License: Standard YouTube License, CC-BY