Hart, Attorney at Law, experienced the following transactions in Year 1, the first year of operations: 1. Accepted $17,500 on April 1, Year 1, as a retainer for services to be performed evenly over the next 12 months. 2. Performed legal services for cash of $69,500. 3. Purchased $1,150 of office supplies on account. 4. Paid $1,035 of the amount due on accounts payable. 5. Paid a cash dividend to the stockholders of $5,600. 6. Paid cash for operating expenses of $20,100. 7. Determined that at the end of the accounting period $120 of office supplies remained on hand. 8. On December 31, Year 1, recognized the revenue that had been earned for services performed in accordance with Transaction 1. Required: Show the effects of the events on the financial statements using a horizontal statements model. The first event has been recorded as an example. Note: In the Statement of Cash Flows column, use the initials OA to designate operating activity, IA for investing activity, FA for financing activity, and NC for net change in cash. Do not round intermediate calculations. Enter any decreases to account

Hart, Attorney at Law, experienced the following transactions in Year 1, the first year of operations: 1. Accepted $17,500 on April 1, Year 1, as a retainer for services to be performed evenly over the next 12 months. 2. Performed legal services for cash of $69,500. 3. Purchased $1,150 of office supplies on account. 4. Paid $1,035 of the amount due on accounts payable. 5. Paid a cash dividend to the stockholders of $5,600. 6. Paid cash for operating expenses of $20,100. 7. Determined that at the end of the accounting period $120 of office supplies remained on hand. 8. On December 31, Year 1, recognized the revenue that had been earned for services performed in accordance with Transaction 1. Required: Show the effects of the events on the financial statements using a horizontal statements model. The first event has been recorded as an example. Note: In the Statement of Cash Flows column, use the initials OA to designate operating activity, IA for investing activity, FA for financing activity, and NC for net change in cash. Do not round intermediate calculations. Enter any decreases to account

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter1: Business Transactions (ptrans)

Section: Chapter Questions

Problem 6R: On June 1 of the current year, Wilson Wood opened Woodys Web Services. This sole proprietorship had...

See similar textbooks

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.
P. 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.
On 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.
On October 1, 2019, Jay Pryor established an interior decorating business, Pioneer Designs. During the month, Jay completed the following transactions related to the business: Oct. 1. Jay transferred cash from a personal bank account to an account to be used for the business, 18,000. 4.Paid rent for period of October 4 to end of month, 3,000. 10.Purchased a used truck for 23,750, paying 3,750 cash and giving a note payable for the remainder. 13.Purchased equipment on account, 10,500. 14.Purchased supplies for cash, 2,100. 15.Paid annual premiums on property and casualty insurance, 3,600. 15.Received cash for job completed, 8,950. Enter the following transactions on Page 2 of the two-column journal: 21.Paid creditor a portion of the amount owed for equipment purchased on October 13, 2,000. 24.Recorded jobs completed on account and sent invoices to customers, 14,150. 26.Received an invoice for truck expenses, to be paid in November, 700. 27.Paid utilities expense, 2,240. 27.Paid miscellaneous expenses, 1,100. Oct. 29. Received cash from customers on account, 7,600. 30.Paid wages of employees, 4,800. 31.Withdrew cash for personal use, 3,500. Instructions 1. Journalize each transaction in a two-column journal beginning on Page 1, referring to the following chart of accounts in selecting the accounts to be debited and credited. (Do not insert the account numbers in the journal at this time.) Journal entry explanations may be omitted. 2. Post the journal to a ledger of four-column accounts, inserting appropriate posting references as each item is posted. Extend the balances to the appropriate balance columns after each transaction is posted. 3. Prepare an unadjusted trial balance for Pioneer Designs as of October 31, 2019. 4. Determine the excess of revenues over expenses for October. 5. Can you think of any reason why the amount determined in (4) might not be the net income for October?
On 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.
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, 6
On 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.
On 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.
In March, T. Carter established Carter Delivery Service. The account headings are presented below. Transactions completed during the month of March follow. a. Carter deposited 25,000 in a bank account in the name of the business. b. Bought a used truck from Degroot Motors for 15,140, paying 5,140 in cash and placing the remainder on account. c. Bought equipment on account from Flemming Company, 3,450. d. Paid the rent for the month, 1,000, Ck. No. 3001. e. Sold services for cash for the first half of the month, 6,927. f. Bought supplies for cash, 301, Ck. No. 3002. g. Bought insurance for the truck for the year, 1,200, Ck. No. 3003. h. Received and paid the bill for utilities, 349, Ck. No. 3004. i. Received a bill for gas and oil for the truck, 218. j. Sold services on account, 3,603. k. Sold services for cash for the remainder of the month, 4,612. l. Paid wages to the employees, 3,958, Ck. Nos. 30053007. m. Carter withdrew cash for personal use, 1,250, Ck. No. 3008. 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.
On 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. 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. g. Paid on account to Rehab Equipment Company, 700, Ck. No. 2004. h. Received and paid the bill for utilities, 367, Ck. No. 2005. i. Paid the salary of the assistant, 1,150, Ck. No. 2006. j. Sold professional services for cash, 3,868. k. Green withdrew cash for personal use, 1,800, 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.
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--.