For this exercise, your client, Bright IDEAS Inc., has provided you with a listing of sales...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
For this exercise, your client, Bright IDEAS Inc., has provided you with a listing of sales invoices. To test whether the client appears to have a receivables collectability problem, the auditor must complete a series of related steps: 1. Import the client's database of sales invoices (pp. 28-45 of the IDEA Workbook). 2. Perform an aging analysis by following the instructions on pp. 52-56 of the IDEA Workbook. Required Data Files: IDEA Data Analysis Workbook ACC REC2015.ACCDB Required: Complete all of the related steps shown above using IDEA. After completing each step, answer the following questions. (Enter your answers exactly as they appear in IDEA.) a. Upon importing the ACC_REC2015.ACCDB data file, what is the total Number of Records shown by IDEA? what is the Control Total for the GROSS_AMT Field shown by IDEA? b. What percentage of customers have accounts that are aged greater than 90 days? c. What percentage of customer balances (net value) are aged greater than 90 days? d-1. Determine the effect that your findings in parts (b) and (c) would have on the auditor's assessment of the risk of material misstatement. d-2. Determine which of the given accounts and assertions are most likely influenced by your findings. Complete this question by entering your answers in the tabs below. Required A Reqs B and C Required D1 Required D2 a. Upon importing the ACC_REC2015.ACCDB data file, what is the total Number of Records shown by IDEA? what is the Control Total for the GROSS_AMT Field shown by IDEA? (Enter your answer for "GROSS_AMT" to 2 decimal places.) Total Number of Records shown by IDEA Control Total for the GROSS_AMT Field shown by IDEA Required A Reqs B and C > For this exercise, your client, Bright IDEAS Inc., has provided you with a listing of sales invoices. To test whether the client appears to have a receivables collectability problem, the auditor must complete a series of related steps: 1. Import the client's database of sales invoices (pp. 28-45 of the IDEA Workbook). 2. Perform an aging analysis by following the instructions on pp. 52-56 of the IDEA Workbook. Required Data Files: IDEA Data Analysis Workbook ACC REC2015.ACCDB Required: Complete all of the related steps shown above using IDEA. After completing each step, answer the following questions. (Enter your answers exactly as they appear in IDEA.) a. Upon importing the ACC_REC2015.ACCDB data file, what is the total Number of Records shown by IDEA? what is the Control Total for the GROSS_AMT Field shown by IDEA? b. What percentage of customers have accounts that are aged greater than 90 days? c. What percentage of customer balances (net value) are aged greater than 90 days? d-1. Determine the effect that your findings in parts (b) and (c) would have on the auditor's assessment of the risk of material misstatement. d-2. Determine which of the given accounts and assertions are most likely influenced by your findings. Complete this question by entering your answers in the tabs below. Required A Reqs B and C Required D1 Required D2 a. Upon importing the ACC_REC2015.ACCDB data file, what is the total Number of Records shown by IDEA? what is the Control Total for the GROSS_AMT Field shown by IDEA? (Enter your answer for "GROSS_AMT" to 2 decimal places.) Total Number of Records shown by IDEA Control Total for the GROSS_AMT Field shown by IDEA Required A Reqs B and C >
Expert Answer:
Answer rating: 100% (QA)
Question Answer Explanation A Total Number of records shown by IDEA is 900 ... View the full answer
Related Book For
Accounting
ISBN: 978-1118608227
9th edition
Authors: Lew Edwards, John Medlin, Keryn Chalmers, Andreas Hellmann, Claire Beattie, Jodie Maxfield, John Hoggett
Posted Date:
Students also viewed these accounting questions
-
Kegler Bowling buys scorekeeping equipment with an invoice cost of $185,000. The electrical work required for the installation costs $19,425. Additional costs are $3,885 for delivery and $13,330 for...
-
What is the total number of gates required to build a 4-bit adder? Assuming two transistors per NOT gate (as in Figure 16.8) and four transistors per AND and OR gate (as in Figures 16.9 and 16.10,...
-
What is the total number of electrons that can be held in all orbitals having the same principal quantum number n?
-
Suppose you have a consumer that calls the lion() method within a Lion service. You have four distinct modules: consumer, service locator, service provider, and service provider interface. If you add...
-
For a given level of earnings (E), net new investment (I), and dividends (D), explain why a firm must issue new stock if E < D + I and it desires to maintain a constant debt-equity ratio. Why must it...
-
What is data mining? Discuss.
-
Figure 2.86 shows a scatterplot illustrating three different variables from the dataset HappyPlanetIndex. The variable Happiness is a measure of the well-being of a country, with larger numbers...
-
Return on investment ( ROI) is computed in the fol-lowing manner: ROI is equal to turnover multiplied by earnings as a percent of sales. Turnover is sales divided by total investment. Total...
-
World Fossil Fuel Regulation At the continued rate of extraction, in how many years is the UK Coal Energy coal from the Folen Mine likely to run out?
-
Jerry Stevenson is the manager of a medical clinic in Scottsdale, AZ. He wants to analyze patient data to identify high-risk patients for cardiovascular diseases. From medical literature, he learned...
-
Explain what a quadratic relationship is: Tony Keonte owns a factory that manufactures Eye-Games. His weekly profit (in thousands of dollars) is given by the following function: P(x) = -4x 2 + 80x-...
-
How has the global village contributed to the need for diversity awareness in our organizations?
-
Which groups will comprise the greatest influx into the U.S. workforce over the next ten years? How will these groups affect HRM?
-
For an organization that you know well, what changes will it have to face up to in the near future? What is the organization's capacity for change and how would you recommend it approaches the...
-
What are the benefits of using approaches such as appreciative inquiry to stimulate change?
-
Discuss the importance of the common-size financial statements in strategic evaluation and control process.
-
Explain and justify how you would calculate planning materiality for lululemon. Calculate an appropriate $ amount for the planning materiality. I identified some accounts that may be at risk of...
-
With your classmates, form small teams of skunkworks. Your task is to identify an innovation that you think would benefit your school, college, or university, and to outline an action plan for...
-
Jaensch Ltd reported the following non-current assets at 30 June 2016: Land Buildings Less: Accumulated Depreciation Buildings $42000000 19 400000 $ 4 800000 22600000 Equipment Less: Accumulated...
-
It has been argued that many companies profits are overstated because they fail to take into account the full cost of their operating activities. This is particularly relevant when considering the...
-
ABC acquired a piece of open land for speculation purposes. It is expected that the value of the land will increase so that it can be sold in the future at a profit. Where should this land be...
-
Based upon the information in Exhibit 1, the market value added of the hypothetical firm is closest to: A. R 65 million. B. R 113 million. C. R 168 million. Mangoba Nkomo, CFA, a senior equity...
-
The most appropriate response to Nkomos Question 1 would be that the present value of future residual earnings is expected to be: A. zero. B. positive. C. negative. Mangoba Nkomo, CFA, a senior...
-
The most appropriate response to Nkomos Question 2 would be that the firms return on equity (ROE ) is: A. equal to the firms cost of equity. B. lower than the firms cost of equity. C. higher than the...
Study smarter with the SolutionInn App