DATA ANALYTICS FOR ACCOUNTING 2E

Deskripsi Buku

xxiv Detailed TOC Lab 8 2 Create Dynamic Common Size Financial Statements 349 Lab 8 3 Analyze Financial Statement Ratios 352 Lab 8 4 Use PivotTables to Analyze Data from an XBRL Database 355 Chapter 9 Tax Analytics 360 Introduction to Tax Analytics 362 Mastering the Data through Tax Data Management 363 Tax Data Analytics Visualizations 364 Tax Data Analytics Visualizations and Tax Compliance 364 Evaluating Sales Tax Liability 365 Evaluating Income Tax Liability 365 Tax Data Analytics for Tax Planning 367 What If Scenarios 368 What If Scenarios for Potential Legislation Deductions and Credits 369 Summary 370 Key Words 370 Answers to Progress Checks 371 Multiple Choice Questions 371 Discussion Questions 373 Problems 373 Lab 9 1 State Sales Taxes and Create a Data Visualization 375 Lab 9 2 Comprehensive Case 1 Dillards Store Data Calculate Sales Tax for Dillards States 379 Lab 9 3 Comprehensive Case 2 Dillards Store Data Calculate Sales Tax for Dillards States Part 2Compare Year over Year 381 Lab 9 4 Comprehensive Case 3 Dillards Store Data Calculate Sales Tax for Dillards States Part 3Calculate City Tax and Compare Tax Owed Year over Year 386 Lab 9 5 Comprehensive Case 4 Dillards Store Data Does a States Tax Rate Affect Dillards Decision to Open Stores There 387 Question 1 2 Is the Delivery Process Following the Expected Procedure 396 Question 1 3 What Is the Total Revenue and Balance in Accounts Receivable 398 Question 1 4 What Else Can You Determine about the O2C Process 400 Question Set 2 Procure to Pay 400 Question 2 1 How Long Are We Taking to Pay Our Invoices 400 Question 2 2 Are There Any Erroneous Payments 404 Question 2 3 Are We Missing Out on Discounts by Paying Late 405 Question 2 4 What Else Can You Determine about the P2P Process 406 Chapter 11 Project Chapter Advanced Analyzing Dillards Data to Predict Sales Returns 408 Estimating Sales Returns 410 Question Set 1 Descriptive and Exploratory Analysis 410 Question 1 1 Which Attributes Could Help Predict Percentage of Returned Sales 410 Question 1 2 How Can We Explore the Product Hierarchy Through Data Visualization 412 Question Set 2 Diagnostic AnalyticsHypothesis Testing 422 Question 2 1 Is the Percentage of Sales Returned Significantly Higher in January After the Holiday Season 422 Question 2 2 Is the Percentage of Sales Returned Significantly Different in Arkansas Than the Rest of the Country 426 Question Set 3 Predictive Analytics 427 Question 3 1 By Looking at Line Charts for 2014 and 2015 Does the Average Percentage of Sales Returned in 2014 Seem to Be Predictive of Returns in 2015 427 Question 3 2 Using Regression What Can We Predict for Returns as a Percentage of Sales Based on Historical Transactions 429 Appendix A Basic Statistics Tutorial 434 Chapter 10 Project Chapter Basic 390 Appendix B Accessing the Excel Data Analysis Toolpak 440 Evaluating Business Processes 392 Question Set 1 Order to Cash 392 Question 1 1 How Efficiently Are We Collecting Our Cash 392 Appendix C Excel Formatting Sorting Filtering and PivotTables 442xxiv Detailed TOC Lab 8 2 Create Dynamic Common Size Financial Statements 349 Lab 8 3 Analyze Financial Statement Ratios 352 Lab 8 4 Use PivotTables to Analyze Data from an XBRL Database 355 Chapter 9 Tax Analytics 360 Introduction to Tax Analytics 362 Mastering the Data through Tax Data Management ...363 Tax Data Analytics Visualizations 364 Tax Data Analytics Visualizations and Tax Compliance 364 Evaluating Sales Tax Liability 365 Evaluating Income Tax Liability 365 Tax Data Analytics for Tax Planning 367 What If Scenarios 368 What If Scenarios for Potential Legislation Deductions and Credits 369 Summary 370 Key Words 370 Answers to Progress Checks 371 Multiple Choice Questions 371 Discussion Questions 373 Problems 373 Lab 9 1 State Sales Taxes and Create a Data Visualization 375 Lab 9 2 Comprehensive Case 1 Dillards Store Data Calculate Sales Tax for Dillards States 379 Lab 9 3 Comprehensive Case 2 Dillards Store Data Calculate Sales Tax for Dillards States Part 2Compare Year over Year 381 Lab 9 4 Comprehensive Case 3 Dillards Store Data Calculate Sales Tax for Dillards States Part 3Calculate City Tax and Compare Tax Owed Year over Year 386 Lab 9 5 Comprehensive Case 4 Dillards Store Data Does a States Tax Rate Affect Dillards Decision to Open Stores There 387 Question 1 2 Is the Delivery Process Following the Expected Procedure 396 Question 1 3 What Is the Total Revenue and Balance in Accounts Receivable 398 Question 1 4 What Else Can You Determine about the O2C Process 400 Question Set 2 Procure to Pay 400 Question 2 1 How Long Are We Taking to Pay Our Invoices 400 Question 2 2 Are There Any Erroneous Payments 404 Question 2 3 Are We Missing Out on Discounts by Paying Late 405 Question 2 4 What Else Can You Determine about the P2P Process 406 Chapter 11 Project Chapter Advanced Analyzing Dillards Data to Predict Sales Returns 408 Estimating Sales Returns 410 Question Set 1 Descriptive and Exploratory Analysis 410 Question 1 1 Which Attributes Could Help Predict Percentage of Returned Sales 410 Question 1 2 How Can We Explore the Product Hierarchy Through Data Visualization 412 Question Set 2 Diagnostic AnalyticsHypothesis Testing 422 Question 2 1 Is the Percentage of Sales Returned Significantly Higher in January After the Holiday Season 422 Question 2 2 Is the Percentage of Sales Returned Significantly Different in Arkansas Than the Rest of the Country 426 Question Set 3 Predictive Analytics 427 Question 3 1 By Looking at Line Charts for 2014 and 2015 Does the Average Percentage of Sales Returned in 2014 Seem to Be Predictive of Returns in 2015 427 Question 3 2 Using Regression What Can We Predict for Returns as a Percentage of Sales Based on Historical Transactions 429 Appendix A Basic Statistics Tutorial 434 Chapter 10 Project Chapter Basic 390 Appendix B Accessing the Excel Data Analysis Toolpak 440 Evaluating Business Processes 392 Question Set 1 Order to Cash 392 Question 1 1 How Efficiently Are We Collecting Our Cash 392 Appendix C Excel Formatting Sorting Filtering and PivotTables 442

Style

Detail Buku