In-class lectures in a computer lab and/or on-line
1. Using DuPont Model and ratio analysis in order to analyze financial statements
· Reading financial statements properly
· Adjusting financial statements
· Apply ratio calculation and DuPont Model
2. Learn Caseware IDEA
· Accessing different data files
· Understanding data
· Analyzing data:
- Basic commands: aging, summarization, stratification, pivot tables, gaps, duplicates, sorting, indexing, extracting
- Using the equation editor for recalculation
- Redefining source data using functions
- Correlation and trend analysis
· Working with multiple files:
- Joining two files looking for matched or unmatched records
- Searching for fields in multiple files
- Using visual connector to check for limits
- Automating the process and reporting
- History log, use of macros
3. Financial Modeling
· Designing and creating an interactive financial model using Excel
· Designing the layout of the model clearly and logically
· Creating clearly defined inputs and assumption sections
· Building powerful scenarios
· Incorporating all related schedules
4. Designing and creating a Dashboard using Excel
· Evaluating existing data
· Defining Key Performance Indicators (KPI)
· Calculating KPI
· Designing charts and graphs for KPI
· Presenting dashboard
- Analyze financial statements using DuPont Model
- Compare and adjust financial statements
- Demonstrate proficiency in using CaseWare IDEA software
- Access and examine different data files
- Analyze data patterns, identify discrepancies and extract unusual items
- Create audit samples
- Analyze data used in accounts receivable and/or payable aging reports, emphasizing data correlation and trend analysis
- Analyze inventory for accuracy and risk exposure
- Examine financial data for existence of misrepresentations in areas such as matched or unmatched records, duplication and limit violation
- Design and construct financial models
- Create dashboards
Projects: A minimum of two separate group data analytics projects 40% - 50%
A minimum of two separate individual data analytics projects 30%
(a mininum of 10% should be assigned to each project, no project should be assigned more than 40%)
Final Exam 20%-30%
CaseWare IDEA Software and IDEA Workbook,
and/or
other textbook(s) and/or material approved by the department
(ACCT 1210 OR ACCT 1235) and CSIS 1190
Or currently active in the
- PDD Accounting
- PDD Data Analytics
Or (ACCT 1210 OR ACCT 1235) and currently active in the
- PBD Accounting and Finance
- PDD Accounting Studies
- PBD Accounting
A minimum grade of C is required in all courses
Or permission of the instructor