Reference no: EM132465030
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 (Excel File - ACC 546 Wk. 2 Practice Case Assignment Values Tab A).
2. Perform an aging analysis (Excel File - ACC 546 Wk. 2 Practice Case Assignment Values Tab B
Required Data Files:
- In the Resources section of this question, you will see e-book, hints, and files. Select Files to download the Excel template to answer the questions below
Required:
Use the Excel File Template to answer the following questions.
Question a. Upon downloading the Wk. 2 Practice Case Assignment Data File Template Worksheet, what is the total Number of Records? What is the Control Total for the GROSS_AMT Field?
Question b. What percentage of customers have accounts that are aged greater than 90 days?
Question c. What percentage of customer balances (net value) are aged greater than 90 days?
Question 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.
Question d-2 Determine which of the given accounts and assertions are most likely influenced by your findings.
Calculate transoceans effective tax rate
: Calculate Transocean's effective tax rate for each of the four years (1998, 2000, 2009. 2015). Estimate the dollar amount of the annual reduction in taxes
|
Sat scores between the two groups
: Find a 95% confidence interval and decide if the SAT scores between the two groups is significantly different.
|
What is your expected win-loss
: Suppose you buy 1 ticket for $2 out of a lottery of 500 tickets where the prize for the one winning ticket is to be $100. What is your expected win/loss?
|
Confidence interval for the treatment means
: A consumer preference study compares the effects of three different bottle designs (A, B, and C) on sales of a popular fabric softener.
|
What percentage of customer balances are aged
: What percentage of customers have accounts that are aged greater than 90 days?What percentage of customer balances are aged greater than 90 days?
|
What is the relationship between the number of events
: What is the relationship between the number of events (causes), number of outcomes, and number of risk scenarios?
|
Confidence interval for the proportion of all people
: Based upon this, compute a 95% confidence interval for the proportion of all people in this city who are dissatisfied with their working conditions.
|
What benefits did the experience offer you
: Professional mentorship has been identified as an important component of professional engagement, professional growth, and advancement.
|
Compute earnings per share using the weighted-average
: Compute earnings per share for 2018, using the weighted-average number of shares determined.Determine the weighted-average number of shares outstanding
|