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
Step: 1
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started