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 1R
To determine
Show the printout of worksheet of FMERCH.
Expert Solution & Answer
Explanation of Solution
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
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.
Joanne is part of the accounts payable team at a local furniture store, responsible for recording invoices received by the business and payments made by the business. The furniture store receives an invoice for internet usage for the amount of $450. The invoice states that payment is due in 30 days, therefore Joanne records the transaction accordingly and sets a calendar reminder to pay on the due date. Based on this information, the journal entry in the furniture store's accounting system would include:
Calculate the net income for the year and post it on the Discussion Board, as well as all supporting documentation to arrive at the net income.- Each group will also advise Tyler Stasney whether to continue operating Swift Classified Ads and post their advice on the Discussion Board, writing a minimum of two to three sentences on the Discussion Board.
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
- 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…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_forwardIn November, Year 2, your accounting firm placed a one-time website advertisement with Today's CPA. This is your first ad with this vendor. You pay for the one-time advertising with your company's Citibank Visa credit card. Below is the transaction you completed for this purchase. If you run the report Transaction List by Vendor, for all dates, what dollar amount will appear under the vendor Today's CPA? Why? Teacher Feedback: was the expense form completed properly?arrow_forward
- Swift Company is a merchandising business organized in 2020. It is located in J. Hernandez Avenue, Naga City, with telephone number 1989-1213, and website tswiftmerchandising.com You were asked by the owner, Ms. T. Swift, to create a simple computerized accounting system for her business which they will use for records keeping, preparation of financial statements, and as substantiation for regulatory requirements. The December 31, 2021 post-closing trial balance for the Swift Company follows: Swift Company Post-Closing Trial Balance December 31, 2021 110 Cash ₱ 240,000 120 Accounts Receivable 210,000 130 Merchandise Inventory 730,000 140 Prepaid Rent 90,000 150 Office Supplies 160,000 160 Office Equipment 1,000,000 165 Accumulated Depreciation ₱…arrow_forwardThe 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_forwardSage Learning Centers was established on July 20 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_forward
- For each of the following, indicate if the statement reflects an input component, output component, or storage component of an accounting information system. A. A credit card scanner at a grocery store. B. A purchase order for 1,000 bottles of windshield washing fluid to be used as inventory by an auto parts store. C. A report of patients who missed appointments at a doctors office. D. A list of the days cash and credit sales. E. Electronic files containing a list of current customers.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_forwardOn November 1, 2016, Patty Cosgrove established an interior decorating business, Classic Designs. During the month, Patty completed the following transactions related to the business: 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.) 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 Classic Designs as of November 30, 2016. 4. Determine the excess of revenues over expenses for November. 5. Can you think of any reason why the amount determined in (4) might not be the net income for November?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
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
College Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College PubPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. 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
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning