FUND. OF FINANCIAL ACCT. (LL) W/CONNECT
6th Edition
ISBN: 9781260725254
Author: PHILLIPS
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 8, Problem 2COP
1.
To determine
Calculate the proportion of allowance for doubtful accounts in gross accounts receivable for the Year 5, Year 4, and Year 3.
2.
To determine
Calculate the proportion of bad debt expense in net sales revenue for the Year 5, Year 4, and Year 3.
3.
To determine
Describe whether E Divisions customers take advantage of sales discount in Year 5 than the previous year.
4.
To determine
Calculate and compare the average days to collect the receivables in Year 5 and Year 4.
5.
To determine
Indicate whether it is required to direct an internal audit staff to investigate the receivables management practices of E Divisions.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Your client has requested that you assist them in setting up their accounting system and asks that you provide a brief description of what key systems and controls are required to ensure that they produce an accurate set of monthly reports. The client has specifically requested that you include in your comments: the accrual system of accounts preperation, the bank reconciliation, the use of accounting journals, the double entry system and the type of reports to be produced.
Required information
[The following information applies to the questions displayed below.]
Required:
1. Create a calculated field to calculate the Days Past Due for each invoice.
2. Summarize the accounts receivable by customer.
3. Get the detailed receivables for the customer "Taste of Thai".
Ask the Question: How can we use Tableau on the total detailed late accounts receivables balance to get specific detail
on invoices due by customer?
Master the Data: To begin, we have a list of 200 receivables that are all past their due date as of today's date of
12/31/2021. This is shown in the Excel file Lab 2-2 Data.xlsx, which will be imported into Tableau.
Software needed
⚫ Tableau
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)
Data: Excel File Lab 2-2 Alt Data.xlsx.
Perform the Analysis: Refer to Lab 2-2 Alternative in the text for instructions and Lab 2-2 steps for each of the lab parts.
Share the Story:
Required:
1. What is the grand total amount owed in past due…
You are auditing a client that supplies electrical products to retail stores and electrical contractors throughout the country.The client keeps its accounts receivable records on a computer system, which is updated at the end of each business day.You plan to audit accounts receivable balance as at the end of the financial year, and you have a generalised audit software (GAS) package available to help in this task.Required:Identify ten (10) substantive audit procedures that you could perform using generalised audit software (GAS) in relation to auditing the accounts receivable account.
Chapter 8 Solutions
FUND. OF FINANCIAL ACCT. (LL) W/CONNECT
Ch. 8 - What are the advantages and disadvantages of...Ch. 8 - Prob. 2QCh. 8 - Which basic accounting principles does the...Ch. 8 - Using the allowance method, is Bad Debt Expense...Ch. 8 - What is the effect of the write-off of...Ch. 8 - How does the use of calculated estimates differ...Ch. 8 - A local phone company had a customer who rang up...Ch. 8 - What is the primary difference between accounts...Ch. 8 - What are the three components of the interest...Ch. 8 - As of May 1, 2016, Krispy Kreme Doughnuts had...
Ch. 8 - Does an increase in the receivables turnover ratio...Ch. 8 - What two approaches can managers take to speed up...Ch. 8 - When customers experience economic difficulties,...Ch. 8 - (Supplement 8A) Describe how (and when) the direct...Ch. 8 - (Supplement 8A) Refer to question 7. What amounts...Ch. 8 - 1. When a company using the allowance method...Ch. 8 - 2. When using the allowance method, as Bad Debt...Ch. 8 - 3. For many years, Carefree Company has estimated...Ch. 8 - 4. Which of the following best describes the...Ch. 8 - 5. If the Allowance for Doubtful Accounts opened...Ch. 8 - 6. When an account receivable is recovered a....Ch. 8 - Prob. 7MCCh. 8 - 8. If the receivables turnover ratio decreased...Ch. 8 - Prob. 9MCCh. 8 - Prob. 10MCCh. 8 - Prob. 1MECh. 8 - Evaluating the Decision to Extend Credit Last...Ch. 8 - Reporting Accounts Receivable and Recording...Ch. 8 - Recording Recoveries Using the Allowance Method...Ch. 8 - Recording Write-Offs and Bad Debt Expense Using...Ch. 8 - Determining Financial Statement Effects of...Ch. 8 - Estimating Bad Debts Using the Percentage of...Ch. 8 - Estimating Bad Debts Using the Aging Method Assume...Ch. 8 - Recording Bad Debt Estimates Using the Two...Ch. 8 - Prob. 10MECh. 8 - Prob. 11MECh. 8 - Recording Note Receivable Transactions RecRoom...Ch. 8 - Prob. 13MECh. 8 - Determining the Effects of Credit Policy Changes...Ch. 8 - Prob. 15MECh. 8 - (Supplement 8A) Recording Write-Offs and Reporting...Ch. 8 - Recording Bad Debt Expense Estimates and...Ch. 8 - Determining Financial Statement Effects of Bad...Ch. 8 - Prob. 3ECh. 8 - Recording Write-Offs and Recoveries Prior to...Ch. 8 - Prob. 5ECh. 8 - Computing Bad Debt Expense Using Aging of Accounts...Ch. 8 - Computing Bad Debt Expense Using Aging of Accounts...Ch. 8 - Recording and Reporting Allowance for Doubtful...Ch. 8 - Recording and Determining the Effects of Write-Off...Ch. 8 - Recording Note Receivable Transactions, Including...Ch. 8 - Recording Note Receivable Transactions, Including...Ch. 8 - Recording Note Receivable Transactions, Including...Ch. 8 - Using Financial Statement Disclosures to Infer...Ch. 8 - Using Financial Statement Disclosures to Infer Bad...Ch. 8 - Prob. 15ECh. 8 - Analyzing and Interpreting Receivables Turnover...Ch. 8 - (Supplement 8A) Recording Write-Offs and Reporting...Ch. 8 - Recording Accounts Receivable Transactions Using...Ch. 8 - Interpreting Disclosure of Allowance for Doubtful...Ch. 8 - Recording Notes Receivable Transactions Jung ...Ch. 8 - Accounting for Accounts and Notes Receivable...Ch. 8 - Analyzing Allowance for Doubtful Accounts,...Ch. 8 - Recording Accounts Receivable Transactions Using...Ch. 8 - Interpreting Disclosure of Allowance for Doubtful...Ch. 8 - Recording Notes Receivable Transactions CS...Ch. 8 - Accounting for Accounts and Notes Receivable...Ch. 8 - Analyzing Allowance for Doubtful Accounts,...Ch. 8 - Recording Accounts Receivable Transactions Using...Ch. 8 - Prob. 2PBCh. 8 - Prob. 3PBCh. 8 - Accounting for Accounts and Notes Receivable...Ch. 8 - Analyzing Allowance for Doubtful Accounts,...Ch. 8 - Recording and Reporting Credit Sales and Bad Debts...Ch. 8 - Prob. 2COPCh. 8 - Recording Daily and Adjusting Entries Using FIFO...Ch. 8 - Prob. 1SDCCh. 8 - Prob. 2SDCCh. 8 - Ethical Decision Making: A Real-Life Example You...Ch. 8 - Critical Thinking: Analyzing the Impact of Credit...Ch. 8 - Using an Aging Schedule to Estimate Bad Debts and...Ch. 8 - Accounting for Receivables and Uncollectible...
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
- You are auditing Hawthorne Industries. The preliminary risk assessment resulted in a high potential for fraud given the number of offices it has across Canada and the high volume of travel-related expenses, as well as the weak controls around expense management. The travel expense account has been assigned to you for substantive testing and you would like to design an ADA to perform the testing. The data you have available include:• The general ledger• Corporate credit card data (in aggregate, as well as employee daily totals, location of charges, and vendor category, e.g., restaurant, fuel, hotel)• Payroll records that include start/end date, vacation and absenteeism data, and roleWhat are the main assertions related to the travel expense account? (Several choices may be correct.) Completeness Cut-off Classification Accuracy Occurrence Existencearrow_forwardV4. Hayden Corporation uses an enterprise resource planning (ERP) system. In their audit of receivables and revenues, the auditors have identified the following data elements in the corporation’s database that may be used for data analytics applications: Customer balance Customer credit limit and credit rating Customer total annual sales Customer purchases by date Customer returns by date Customer name Customer shipping address Required: a. Describe two data analytic applications that might be used to audit the existence of receivables and occurrence of sales. b. Describe one data analytic application that might be used to audit the valuation of receivables.arrow_forwardCAATs Application—Receivables Confirmation. You are using computer audit software to prepare accounts receivable confirmations during the annual audit of the Eastern Sunrise Services Club. The company has the following data files:Master file—debtor credit record.Master file—debtor name and address.Master file—account detail:Ledger number.Sales code.Customer account number.Date of last billing.Balance (gross).Discount available to customer (memo account only).Date of last purchase.The discount field represents the amount of discount available to the customer if the customer pays within 30 days of the invoicing date. The discount field is cleared for expired amounts during the daily updating. You have determined that this is properly executed.Required:From the data files shown, list the information that you would include on the confirmation requests. Identify the file from which the information can be obtained.arrow_forward
- 1. You are tasked to perform cut-off procedures for expenses and its related payable. In testing the completeness/cut-off assertion, what document would you most likely inspect? Group of answer choices a. Accounts payable subsidiary ledger. b. Vendor invoice register 15 days before and 15 days after report date. c. Purchase journal 15 days before and 15 days after report date. d. Cash disbursement journal 15 days before and 15 days after report date. 2. During the review of loan contracts and agreements, the auditor would most likely figure out the following, except: Group of answer choices a. The existence of loans. b. The completeness of loans. c. The accuracy of interest expense recorded by the entity. d. Related disclosures pertaining to assets pledged as collateral.arrow_forwardAssume that an organization asserts that it has $35 million in net accounts receivable. Describe specifically what management is asserting with respect to net accounts receivable.arrow_forwardYour Audit team is preparing to audit a new client in the electronic retail industry. The client imports items from manufacturers in several Asian countries and retails in a chain of shops located throughout the country. You and your team members have access to the client's following information. · Prior period financial reports · Anticipated results for the current year · Industry Averages Required: Explain how you would use the information to understand your new client.arrow_forward
- draw the system flow chart for the following narrative? Cornick, Inc. sells office products to businesses in the eastern region of the United States. Each month, the IT division at Cornick prints monthly statements and sends them to the accounts receivable (AR) department, where a clerk mails them to the customers. Cornick’s custo- mers mail their payments back to Cornick, where a clerk in AR batches the checks and sends them to the cashier. The AR clerk then uses the payment stub to enter the payments into the computer, where the AR master data are updated to record the paymentarrow_forwardYou are working as an Accounts Receivable Officer in Super Mart Store. Your Store manager asked you to make a data flow context diagram of the following transaction: A customer made a payment on account of purchases made last month. The customer payment was processed by receipt department and deposited in the bank. The remittance advice is forwarded to Account receivable department of updating of record. The credit manager is informed about the receivable information from the customerarrow_forwardPROBLEM 2 You are revisiting the audit working paper presented to you by your audit staff in line with his audit procedures done in auditing T-ara Corporation’s accounts receivable. The following were lifted from the said working papers: Audit notes: T-ara Corporation’s accounts receivable subsidiary ledger had the following details: Customers Invoice Date Invoice Amount Balance Park Ji-yeon Inc. 12/06/22 127,000 10/29/22 84,000 211,000 Hyomin Company 12/30/22 42,000 09/27/22 30,000 08/20/22 53,520 125,520 Hahn Eunjung Inc. 12/30/22 40,000 12/08/22 80,000 11/25/22 63,600 183,600 Park So-yeon Company 11/17/22 138,840 10/09/22 132,000 08/20/22 74,400 345,240 Jeon Boram Corporation 12/10/22 250,000 250,000 Qri Incorporated 09/12/22 104,400 104,400 Total 1,219,760 The…arrow_forward
- 3. In the audit of loans payable, which of the following audit procedure would be most likely performed to validate the existence assertion? Group of answer choices a. Review loan contracts b. Sending loan confirmations c. Vouching of subsequent payments of loans d. Performing analytical procedures 4. You are auditing the December 31, 2021, accounts payable balance of one of your firm’s divisions. The division controller’s office has provided you with a schedule listing the creditors and the amount owed to each at December 31, 2021. Which of the following audit procedures would be your best choice for determining that no individual account payable has been omitted from the schedule? Group of answer choices a. Send confirmation requests to a randomly selected sample of creditors listed on the schedule b. Examine support for selected 2022 payments to creditors, ascertaining that those relating to 2022 are not on the schedule. c. Send confirmation requests to creditors that…arrow_forwardProblem Solving. Required: 1. Prepare a properly classified bank reconciliation statement for each of the problems given below.2. Prepare the necessary adjusting journal entries on the company’s book for book reconciling items.arrow_forwardWhich of the following provides the highest-quality evidence regarding the Valuation of recorded accounts payable? Question 5 options: Inspecting invoices for all cash disbursements during the year. Performing analytical procedures. Confirming balances with creditors and suppliers. Recalculating the balance of accounts payable.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College