8-1 Activity: Trend Analysis

ACC 692 Module Eight Activity Guidelines and Rubric

Scenario

You are an internal auditor at Streaming Entertainment Corporation. The Training and Development department in your organization is developing training materials on how to use financial analysis to identify fraud within the organization. The material will be presented to senior managers of the company at a management retreat. You have been asked to assist in developing materials by preparing content that can be used to discuss how to identify red flags of fraudulent activity by using financial statement analysis.

Directions

For this activity, there are two deliverables. Use the case study spreadsheet linked in

What to Submit

to perform a financial analysis and then write a memo to describe your findings.

Part One: Financial Analysis

Use the spreadsheet in the Supporting Materials section to perform trend analysis and vertical analysis of financial statements. Specifically, you must address the following rubric criterion:

1. Perform a financial analysis to identify potential red flags for fraud.

Part Two:

Save Time On Research and Writing

Hire a Pro to Write You a 100% Plagiarism-Free Paper.

Get My Paper

Memo

Write a memo addressing red flags identified in your analysis. Specifically, you must address the following rubric criteria:

1. Describe how a financial analysis can be used to identify red flags of fraud.
2. Interpret why the red flags found in the specific case are indicators of fraud.
3. Discuss the importance of collecting supporting evidence to form conclusions about fraud identified in this specific case.

What to Submit

Excel Spreadsheet

Your submission should include the completed

Module Eight Activity Case Study Spreadsheet

showing the calculations for the trend analysis and vertical analysis. This Excel spreadsheet also provides the financial data needed to complete the trend analysis and vertical analysis.

Memo

Your submission should include a 1- to 2-page Word document with 12-point Times New Roman font, double spacing, and one-inch margins. Sources should be cited according to APA style.

Module Eight Activity Rubric

)

Part One: Financial Analysis

Part Two: Red Flags

Does not attempt criterion

Part Two: Indicators of FraudExceeds proficiency in an exceptionally clear, insightful, or sophisticated manner

Does not attempt criterion20

Part Two: Supporting EvidenceExceeds proficiency in an exceptionally clear, insightful, or sophisticated manner

Does not attempt criterion20

Clear Communication

Citations and Attributions

5

100%

Criteria	Exemplary (	100%	Proficient (90%)	Needs Improvement (70%)	Not Evident (0%)	Value
Performs a financial analysis to identify potential red flags for fraud with no errors	Performs a financial analysis to identify potential red flags for fraud with minimal errors	Performs a financial analysis to identify potential red flags for fraud with significant errors				Does not attempt criterion	30
		Exceeds proficiency in an exceptionally clear, insightful, or sophisticated manner	Describes how a financial analysis can be used to identify red flags of fraud	Shows progress toward proficiency, but with errors or omissions; areas for improvement may include adding details related to describing how a financial analysis can be used to identify red flags of fraud			20
Interprets why the red flags found in the specific case are indicators of fraud	Shows progress toward proficiency, but with errors or omissions; areas for improvement may include adding details related to interpreting why the red flags found in the specific case are indicators of fraud
Discusses the importance of collecting supporting evidence to form conclusions about fraud identified in this specific case	Shows progress toward proficiency, but with errors or omissions; areas for improvement may include adding details related to discussing the importance of collecting supporting evidence to form
Exceeds proficiency with an intentional use of language that promotes a thorough understanding	Consistently and effectively communicates in an organized way to a specific audience	Shows progress towards proficiency, but communication is inconsistent or ineffective in a way that negatively impacts understanding	Shows no evidence of consistent, effective, or organized communication		5
Uses citations for ideas requiring attribution, with few or no minor errors	Uses citations for ideas requiring attribution, with consistent minor errors	Uses citations for ideas requiring attribution, with major errors	Does not use citations for ideas requiring attribution
Total:

Streaming Entertainment Corportation
Balance Sheet
Balance Sheet
For year ended Dec 31,
Assets
Current Assets
Cash
Accounts Receivable
Inventory
Prepaid Expenses
Total Current Assets
Year 3
$
$
$
$
$
Property, Plant, and Equipment
– Net Book Value
$
Total Assets
$
752,988.00
586,726.00
819,663.85
409,831.92
2,569,209.77
Year 2
$
$
$
$
$
651,322.50
499,148.10
780,632.24
390,316.12
2,321,418.95
Year 1
$
$
$
$
$
618,982.65
374,734.20
481,871.75
265,029.46
1,740,618.06
1,061,713.08 $
3,630,922.85 $
918,364.73 $
3,239,783.68 $
872,765.54
2,613,383.60
417,855.41
421,171.88
48,596.76
887,624.04
$
$
$
$
548,810.56
339,739.87
39,200.75
927,751.18
Liabilities
Current Liabilities
Accounts Payable
Accrued Liabilities
Income Tax Payable
Total Current Liabilities
$
$
$
$
401,402.00
310,225.00
38,500.00
750,127.00
Long-Term Debt
Total Liabilities
$
$
705,050.00 $
1,455,177.00 $
615,558.90 $
1,503,182.94 $
417,748.34
1,345,499.51
$
$
$
$
275,000.00
500,000.00
1,400,746.00
2,175,746.00
275,000.00
500,000.00
961,601.00
1,736,601.00
$
$
$
$
275,000.00
500,000.00
492,884.00
1,267,884.00
$
3,630,923.00 $
3,239,783.94 $
2,613,383.51
Stockholders’ Equity
Common Stock
Additional Paid-In Capital
Retained Earnings
Total Stockholder’s Equity
Total Liabilities and
Stockholders’ Equity
$
$
$
$
$
$
$
$
ing Entertainment Corportation
Balance Sheet
Balance Sheet Horizontal Analysis
Years 1-2
Years 2-3
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
Balance Sheet Vertical Analysis
Year 1
Year 2
Year 3
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.] [Insert value.]
[Insert value.] [Insert value.]
[Insert value.] [Insert value.]
[Insert value.] [Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.] [Insert value.]
[Insert value.] [Insert value.]
[Insert value.] [Insert value.]
[Insert value.] [Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.] [Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.] [Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
[Insert value.]
Streaming Entertainment Corporation
Income Statement
Income Statement
For year ended Dec 31,
Net Sales
Cost of Goods Sold
Gross Profit
Expenses
Advertising Expense
Depreciation Expense
Bad Debt Expenses
Insurance Expense
Interest Expense
Legal Fees Expense
Miscellaneous Expense
Repairs and Maintenance Expense
Salaries and Wages Expense
Utilities Expense
Total Expenses
Net Income Before Income Taxes
Income Tax Expense
Net Income
$
$
$
Year 3
2,573,134.00 $
694,746.18 $
1,878,387.82 $
Year 2
2,414,581.00 $
724,374.30 $
1,690,206.70 $
$
$
$
$
$
$
$
$
$
$
$
$
$
$
78,250.00
42,442.00
58,250.00
72,025.00
45,025.00
37,567.76
65,743.57
30,054.21
109,520.00
33,810.98
572,688.52
1,305,699.30
456,994.76
848,704.55
77,153.00
42,442.00
47,850.00
69,075.00
51,045.00
33,804.13
57,025.00
27,250.00
103,250.00
30,423.72
539,317.85
1,150,888.85
368,284.43
782,604.41
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
Year 1
2,210,075.00
861,929.25
1,348,145.75
75,531.00
44,442.00
32,615.00
67,505.00
55,025.00
26,962.92
47,185.10
21,570.33
98,250.00
26,055.00
495,141.35
853,004.40
255,901.32
597,103.08
nment Corporation
atement
Income Statement
Horizontal Analysis
Income Statement Vertical Analysis
Years 1-2
Years 2-3
Year 1
Year 2
Year 3
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]
[Insert value.] [Insert value.] [Insert value.] [Insert value.] [Insert value.]