Excel project: using benfords law to detect potential disbursements fraud.* Required Read the article using spreadsheets and
Question:
Excel project: using benford’s law to detect potential disbursements fraud.*
Required
Read the article “using spreadsheets and benford’s law to test accounting data,†By mark g. Simkin in the isaca journal, vol. 1, 2010, available at www.isaca.org.
Follow the steps in the article to analyze the following set of supplierinvoices:
Transcribed Image Text:
t635-90598705419 6 7 2 9 5 2 3 8 6 9 4 2 1 1 u283274985 2 8 9 7 37 813611721277194 , 123 5678901234 e 6 6 6 6 cb333333) 3 3 3 3 3 3 3 3 3 oi n 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 t5755359323-0250 4 7 9 5 3 5 3 7 6 3 3 0 220 893474 2 5 8 9 5 4 891 , 69 69 69 69 GA 69 $ $ 69 69 69 $ 567890123456789 ee444445555555555 b 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 oi n 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 62% (16 reviews)
To apply Benfords law we need to write a formula that extracts the leftmost digit from an invoice number Excel has a number of builtin functions that ...View the full answer
Answered By
PALASH JHANWAR
I am a Chartered Accountant with AIR 45 in CA - IPCC. I am a Merit Holder ( B.Com ). The following is my educational details.
PLEASE ACCESS MY RESUME FROM THE FOLLOWING LINK: https://drive.google.com/file/d/1hYR1uch-ff6MRC_cDB07K6VqY9kQ3SFL/view?usp=sharing
3.80+
3+ Reviews
10+ Question Solved
Related Book For
Accounting Information Systems
ISBN: 978-0133428537
13th edition
Authors: Marshall B. Romney, Paul J. Steinbart
Question Posted:
Students also viewed these Accounting questions
-
In problem, follow Steps 1 through 8 to analyze the graph of each function. %3D (x 1)(x + 2) |R(x)
-
In problem, follow Steps 1 through 8 to analyze the graph of each function. (x 1)(x + 2)(x 3) x(x 4)2 R(x)
-
Required (a) Using the data given in the table above, use MS Excel to: (i) Prepare a schedule to be presented to management. The schedule must show the following for 5000, 10000, 15000, 20000, 25000...
-
ME-1" Ltd. acquired 80% equity shares of You-2nd Ltd. on 30/04/2020 for a cost of GHS60,000. At that time the general reserves were GHe6,000 respectively.
-
Why are audit tests more likely to be conducted at or after year end for high-risk clients than for low-risk clients? Explain.
-
Corporate Insider Trading The cumulative abnormal returns pattern for British insider trading (Figure 13.7) suggests that executives have private information that they exploit to their advantage. Is...
-
Web-based exercise. Find an example of one of the following. Explain in detail the statistical shortcomings of your example. Leaving out essential information Lack of consistency Implausible numbers...
-
The following amounts were taken from the weekly payroll register for the Wu Vale Company on August 9, 201X. Please prepare the general journal entry to record the payroll for the Wu Vale Company for...
-
What is procedural justice? Faimess of a decision outcome O Faimess in interpersonal interactions, treating others with dignity and respect Fairness in the method used to communicate the decision...
-
Match the following and select the correct option. Prims's algorithm Dynamic programming 1 a Binary search algorithm 2 b Divide and conquer programming Quick sort algorithm Greedy programming ...
-
Match the terms in the left column with their appropriate definition in the rightcolumn. Terms Definitions 1. Economic order quantity a. A document that creates a legal ob EOO) ligation to buy and...
-
Match threats in the first column to appropriate control procedures in the second column. More than one control may be applicable. Threat Control 1. Failing to take available purchase discounts for...
-
For the system shown in Figure P5.13, find the poles of the closed-loop transfer function, T(s) = C(s)/R(s). 3 C(s) 5s R(s) 4 FIGURE P5.13
-
Construct a 90% confidence interval for the population standard deviation o at Bank B. Bank B 4.2 5.4 5.9 6.1 6.6 7.7 7.7 8.6 9.3 10.0
-
Jamila Traders has a head office in Nanyuki and an autonomous branch in Thika. The trial balances of the head office and the branch as at 30 September 2014 were as follows: Head office Sh. Sh. Thika...
-
Poll Results in the Media USA Today provided results from a survey of 1144 Americans who were asked if they approve of Brett Kavanaugh as the choice for Supreme Court justice. 51% of the respondents...
-
ROI analysis using the DuPont model a. Firm A has a margin of 7%, sales of $980,000, and ROI of 19.6%. Calculate the firm's average total assets. b. Firm B has net income of $259,200, turnover of...
-
The test statistic of z = - 2.93 is obtained when testing the claim that p < 2/ 3. This is a left-tailed test. Using a 0.01 significance level, complete parts (a) and (b). a. Find the critical...
-
On January 1, 2020, the following debt was authorized and issued by Anderson Company. 1. \(\$ 50,000,5\)-year, \(9 \%\) convertible bonds payable, cash interest payable semiannually to yield \(10...
-
Which should drive action planning more, strengths or weaknesses? That is, is it more important to build on your strengths or to reduce your weaknesses? Explain.
-
Here's a great everyday use of the physics described in this chapter. If you are trying to get ketchup out of the bottle, the best way to do it is to turn the bottle upside down and give the bottle a...
-
With the help of your instructor, identify a particular information system that is not working very well and perform a preliminary investigation of it. In your work, be sure to talk to (1) At least...
-
Wright Company employs a computer-based data processing system for maintaining all company records. The current system was developed in stages over the past five years and has been fully operational...
-
The managers at Kenbart Company have decided that increased emphasis must be placed on profit planning and comparing results to plans. A new profit planning system has been implemented to help with...
-
"faithful respresentation" is the overriding principle that should be followed in ones prepaparation of IFRS-based financial statement. what is it? explain it fully quoting IAS. how this this...
-
A stock is expected to pay a dividend of $1.50 at the end of the year (i.e., D 1 = $1.50), and it should continue to grow at a constant rate of 10% a year. If its required return is 14%, what is the...
-
The Hobby Shop has a checking account with a ledger balance of $1,700. The firm has $2,400 in uncollected deposits and $4,200 in outstanding checks. What is the amount of the disbursement float on...
Study smarter with the SolutionInn App