TITLE

FORENSIC ACCOUNTING TOOL

Chapter 20

ANALYSIS

The worksheet contains the fiscal year 2012 journal entries for Royal Imports. The list was downloaded from the corporation's computer system. Transaction amounts are contained in debit and credit columns. Unused cells are filled with 0.00.

STEPS

1

Read all steps before working with the worksheet.

2

Click the Analysis worksheet tab to view the journal entries.

3

Key your name in cell C2.

The first step in the analysis is to add a single column containing the amount for each line of each transaction.

4

In cell I4, enter the label "Amount."

5

In cell I5, add a formula to compute the sum of the debit and credit amounts for row 5.

6

Copy the formula for each transaction.

The MOD function determines the remainder of a number divided by a divisor. The function can be used to identify amounts having a remainder of 0.

7

In cell J4, enter the label "Remainder."

8

In cell J5, enter the function =MOD(I5,1000).

9

Copy the function for each transaction.

The function =MOD(I5,1000) divides the amount in cell I5 by 1,000. The amount 3,877.64 divided by 1,000 yields 3 with a remainder of 877.64. Any amount ending in 000.00, when divided by 1,000, will have a remainder of zero.

A filter is used to identify transactions containing an amount greater than $25,000.00 ending in 000.00.

10

Click on any single cell within the list of transactions.

11

On the Home tab in theStyles group, selectFormat as Table, select any of the table formats, and click OK.

12

Click on the arrow in the Amount column header (cell I4).

13

Select Number Filters andGreater Than.

14

Enter 25000 in the upper right box.

15

Click OK.

16

Click on the arrow in the Remainder column header (cell J4).

17

Click the Select All box to unselect each selection.

18

Click the box for 0.00.

19

Click OK.

20

Print the worksheet solution, as instructed by your teacher.

21

Save your work.