Question: Preparing and Analyzing an Aging Schedule Using IDEA. For this exercise, your client, Bright IDEAs Inc., has provided you with a listing of sales invoices.

Preparing and Analyzing an Aging Schedule Using IDEA. 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 clients database of sales invoices (pp. 2845 of the IDEA Workbook). You may have already completed this step in Chapter 3. 2. Perform an aging analysis by following the instructions on pp. 5256 of the IDEA Workbook. Required Data available on McGraw-Hill Connect ACC_REC2015.ACCDB Required: Complete the preceding steps and answer the following questions: a. What percentage of customers have accounts that are aged greater than 90 days? b. What percentage of customer balances are aged greater than 90 days? c. What effects would the findings in parts (a) and (b) have on the auditors assessment of the risk of material misstatement? What accounts and assertions are most likely influenced by these findings?

Answer to A, through the IDEA software, 9.49% of accounts are aged greater than 90 days.

Answer to B, through the IDEA software, 14.95% of balances are aged greater than 90 days.

I've scoured the book for help on answering C but have came up short, any help would be appreciated.

Thank you

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!