Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 4, Problem 3R
To determine
Complete the worksheet with correct balance on the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
This project will give you an opportunity to apply your knowledge of accounting principles and procedures by handling all the accounting work of Eli’s Consulting Services for the month of January 20X2.
Assume that you are the chief accountant for Eli’s Consulting Services. During January, the business will use the same types of records and procedures that you learned about in Chapters 1 through 6. The chart of accounts for Eli’s Consulting Services has been expanded to include a few new accounts. Follow the instructions on the Requirements tab to complete the accounting records for the month of January.
DATE
TRANSACTIONS
Jan.
2
Purchased supplies for $14,000; issued Check 1015.
2
Purchased a one-year insurance policy for $16,800.
7
Sold services for $30,000 in cash and $20,000 on credit during the first week of January.
12
Collected a total of $8,000 on account from credit customers during the first week of January.
12
Issued Check 1017 for $7,200 to pay for…
Make first a proper Chart of Accounts. Then make a proper Trial Balance from the following accounts and balances listed in alphabetical order for MN Company for August 31 of the current year. Put them in the correct order along with their debit and credit balances on your Trial Balance. Total the DR and CR column and make sure they balance. Make sure you have a heading. We will work on this in class. Upload here on D2L if you are not yet finished in class.
Accounts Payable $2300, Accounts Receivable $1200, Accumulated Depreciation-Equipment $800, Advertising Expense $200, Cash $3400, Equipment $12,500, Furniture and Fixtures $6700, MN, Capital, $6500, MN, Drawing $500, Notes Payable $8000, Prepaid Insurance $1200, Professional Fees $10,000, Rent Expense $500, Supplies $100, Utilities Expense $300, Wages Expense $1000.
On March 1, a designer received a check for $7,500 from a customer for services to be provided after the customer chooses a color scheme for the first floor of her house. On July 31, the designer completed the design work for this customer.
Prepare the July 31 journal entry by selecting the account names from the drop-down menus and entering the dollar amounts in the debit or credit columns.
Chapter 4 Solutions
Excel Applications for Accounting Principles
Knowledge Booster
Similar questions
- The general ledger of Jay Consulting shows the following balances at July 31: Jay has asked you to develop a worksheet that will serve as a trial balance (file name PTB). Use the data provided as input for your model. Review the Model-Building Problem Checklist on page 154 to ensure that your worksheet is complete. Print the worksheet when done. Check figure: Total debits, 17,731. To test your model, use the following balances at August 31: Print the worksheet when done. Check figure: Total debits, 18,810. CHART (optional) Using the test data worksheet, prepare a pie chart showing the percentage of each asset to total assets. Print the chart when done.arrow_forwardThe following information is from Dessert Dynasty. The company runs three stores and the December Income Statement for all stores is shown. A. Find the missing values for retail revenue, ingredients, and operating income. B. Comment on the financial performance of each store. C. Identify a limitation of analyzing the information provided. You may want to consider using Microsoft Excel or another spreadsheet application for the numerical data. This information will be used in a subsequent question.arrow_forwardLaras Landscaping Service has the following chart of accounts: The following transactions were completed by Laras Landscaping Service: Required 1. Journalize the transactions in the general journal. Provide a brief explanation for each entry. 2. If you are using working papers, write the name of the owner on the Capital and Drawing accounts. (Skip this step if you are using CLGL.) 3. Post the journal entries to the general ledger accounts. (Skip this step if you are using CLGL.) 4. Prepare a trial balance dated March 31, 20. If you are using CLGL, use the year 2020 when recording transaction! and preparing reports.arrow_forward
- The following information is for Bonnies Buds, a nursery and floral shop, for the month ended May 31, 2012: Click the Chart sheet tab on the FMERCH3 file. You will see a chart depicting the five-month trend in sales, gross profit, and net income. What favorable and unfavorable trends do you see in this month-to-month comparison? Comment on any unusual changes. When the assignment is complete, close the file without saving it again. Worksheet. Your boss would prefer to have the balance sheet shown before the income statement and the statement of retained earnings. Please make this change on the FMERCH3 file. Preview the printout to make sure that the worksheet will print neatly on two or three pages, and then print the worksheet. Save the completed file as FMERCHT. Chart. Using the FMERCH3 file, prepare a 3-D pie chart that shows the amount of each of the selling expenses in June. No Chart Data Table is needed. Select A57 to A62 as one range on the worksheet to be charted and then hold down the CTRL key and select E57 to E62 as the second range. Enter your name somewhere on the chart. Save the file again as FMERCH3. Select the chart and then print it out.arrow_forwardThis problem is designed to enable you to apply the knowledge you have acquired in the preceding chapters. In accounting, the ultimate test is being able to handle data in real life situations. This problem will give you valuable experience. CHART OF ACCOUNTS You are to record transactions in a two-column general journal. Assume that the fiscal period is one month. You will then be able to complete all of the steps in the accounting cycle. When you are analyzing the transactions, think them through by visualizing the T accounts or by writing them down on scratch paper. For unfamiliar types of transactions, specific instructions for recording them are included. However, reason them out for yourself as well. Check off each transaction as it is recorded. Required 1. Journalize the transactions. (Start on page 1 of the general journal if using Excel or Working Papers.) 2. Post the transactions to the ledger accounts. (Skip this step if using CLGL.) 3. Prepare a trial balance. (If using a work sheet, use the first two columns.) 4. Data for the adjustments are as follows: a. Insurance expired during the month, 1,000. b. Depreciation of pool structure for the month, 715. c. Depreciation of fan system for the month, 260. d. Depreciation of sailboats for the month, 900. e. Wages accrued at June 30, 810. Your instructor may want you to use a work sheet for these adjustments. 5. Journalize adjusting entries. 6. Post adjusting entries to the ledger accounts. (Skip this step if using CLGL.) 7. Prepare an adjusted trial balance 8. Prepare the income statement 9. Prepare the statement of owners equity. 10. Prepare the balance sheet. 11. Journalize closing entries. 12. Post closing entries to the ledger accounts. (Skip this step if using CLGL.) 13. Prepare a post-dosing trial balance. Check Figure Trial balance total, 281,858; net income, 7,143; post-dosing trial balance total, 263,341arrow_forwardThis problem is designed to enable you to apply the knowledge you have acquired in the preceding chapters. In accounting, the ultimate test is being able to handle data in real-life situations. This problem will give you valuable experience. CHART OF ACCOUNTS You are to record transactions in a two-column general journal. Assume that the fiscal period is one month. You will then be able to complete all of the steps in the accounting cycle. When you are analyzing the transactions, think them through by visualizing the T accounts or by writing them down on scratch paper. For unfamiliar types of transactions, specific instructions for recording them are included. However, reason them out for yourself as well. Check off each transaction as it is recorded. Required 1. Journalize the transactions. (Start on page 1 of the general journal if using Excel or Working Papers.) 2. Post the transactions to the ledger accounts. (Skip this step if using CLGL.) 3. Prepare a trial balance. (If using a work sheet, use the first two columns.) 4. Data for the adjustments are as follows: a. Insurance expired during the month, 1,020. b. Depreciation of building for the month, 480. c. Depreciation of pool/slide facility for the month, 675. d. Depreciation of pool furniture for the month, 220. e. Wages accrued at July 31, 920. Your instructor may want you to use a work sheet for these adjustments. 5. Journalize adjusting entries. 6. Post adjusting entries to the ledger accounts. (Skip this step if using CLGL.) 7. Prepare an adjusted trial balance. 8. Prepare the income statement. 9. Prepare the statement of owners equity. 10. Prepare the balance sheet. 11. Journalize closing entries. 12. Post closing entries to the ledger accounts. (Skip this step if using CLGL.) 13. Prepare a post-closing trial balance. Check Figure Trial balance total, 601,941; net income, 16,293; post-closing trial balance total, 569,614arrow_forward
- Leanders Landscaping Service maintains the following chart of accounts: The following transactions were completed by Leander: Required 1. Journalize the transactions in the general journal. Prepare a brief explanation for each entry. 2. If you are using working papers, write the name of the owner on the Capital and Drawing accounts. 3. Post the journal entries to the general ledger accounts. (Skip this step if you are using CLGL.) 4. Prepare a trial balance dated April 30, 20. If you are using CLGL, use the year 2020 when recording transactions and preparing reports.arrow_forwardSage Learning Centers was established on July 20, 2016, to provide educational services. The services provided during the remainder of the month are as follows: Instructions 1. Journalize the transactions for July, using a single-column revenue journal and a two-column general journal. Post to the following customer accounts in the accounts receivable ledger, and insert the balance immediately after recording each entry: D. Chase; J. Dunlop; F. Mintz; T. Quinn; K. Tisdale. 2. Post the revenue journal and the general journal to the following accounts in the general ledger, inserting the account balances only after the last postings: 3. a. What is the sum of the balances of the customer accounts in the subsidiary ledger at July 31? b. What is the balance of the accounts receivable controlling account at July 31? 4. Assume Sage Learning Centers began using a computerized accounting system to record the sales transactions on August 1. What are some of the benefits of the computerized system over the manual system?arrow_forwardThis project will give you an opportunity to apply your knowledge of accounting principles and procedures by handling all the accounting work of Eli’s Consulting Services for the month of January 2020. Assume that you are the chief accountant for Eli’s Consulting Services. During January, the business will use the same types of records and procedures that you learned about in Chapters 1 through 6. The chart of accounts for Eli’s Consulting Services has been expanded to include a few new accounts. Follow the instructions on the Requirements tab to complete the accounting records for the month of January. DATE TRANSACTIONS Jan. 2 Purchased supplies for $14,000; issued Check 1015. 2 Purchased a one-year insurance policy for $16,800. 7 Sold services for $30,000 in cash and $20,000 on credit during the first week of January. 12 Collected a total of $8,000 on account from credit customers during the first week of January. 12 Issued Check 1017 for $7,200 to pay for…arrow_forward
- CREATE A TRIAL BALANCE AND FINANCIAL STATEMENTS WITH THE FOLLOWING INFORMATION. EVERYTHING IS BELOW INCLUDING PICTURES OF THE PREVIOUS MONTHS FINANCIAL STATEMENTS The following events occur during September: a. Webworks purchases supplies worth $120 on account. b. At the beginning of September, Webworks had 19 keyboards costing $100 each and 110 flash drives costing $10 each. Webworks has decided to use perpetual FIFO to cost its inventory. c. On account, Webworks purchases thirty keyboards for $105 each and fifty flash drives for $11 each. d. Webworks starts and completes five more Web sites and bills clients for $3,000. e. Webworks pays Nancy $500 for her work during the first three weeks of September. f. Webworks sells 40 keyboards for $6,000 and 120 flash drives for $2,400 cash. g. Webworks collects $2,500 in accounts receivable. h. Webworks pays off its salaries payable from August. i. Webworks pays off $5,500 of its accounts payable. j. Webworks pays off $5,000 of its outstanding…arrow_forwardBelow are accounts & balances of TechnoSupport, a sole proprietorship that installs and repairs home computers for customers, as of November 2020. During the month, the owner, Sandy Pearson, invested additional cash of Php 20,000. For the month ended of November 30, 2020, prepare an (1) income statement, (2) a statement of owner’s equity, and a (3) balance sheet all in proper form. Answers should be handwritten. Take a picture of it and attached the file to this problem. Rename the file bearing your last name. ACCOUNT/TRANSACTION BALANCE Cash 36,000 Accounts Receivable 112,600 Supplies 18,000 Equipment 191,400 Accounts Payable 60,800 Sandy Pearson Capital, 11/1/2020 93,600 Sandy Pearson, Drawing 17,000 Fees Earned 682,000 Salaries Expense 396,800 Advertising Expense 73,000 Miscellaneous Expense 11,600arrow_forwardPlease format the answers in the exact location as you will seen in the image provided below. QUESTION 2 On December 31, 2020, the balances of the accounts appearing in the ledger of Home City Furnishings Company, a furniture wholesaler, are as follows: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 LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCollege Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
- Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning