Background: As a result of your preliminary findings, TechWear’s audit committee has asked that you postpone the issuance of your audit report until at least 80% of the accounts receivable balance out

Background:

As a result of your preliminary findings, TechWear’s audit committee has asked that you postpone the issuance of your audit report until at least 80% of the accounts receivable balance outstanding at December 31, 2016, has been resolved (e.g., collected, written off or returned).

As of May 31, 2017, approximately 80% of the accounts receivable balance has been settled, so it is time to perform your procedures. The client has provided you with the data that you requested (in the module: ACT558_Module_06_P5_Data.xls Download ACT558_Module_06_P5_Data.xls). Procedures already have been performed by your team to ensure that the data you received is complete and accurate.

The data file includes two tabs — 2017 AR data and 2016 Unapplied cash.

2017 AR data tab

This data includes January through May 2017 cash received, write-offs and returns for 2016 account balances. The data fields are the same as what you received for 2016, with the exclusion of the invoice date. Additionally, the “Type” field includes transaction information for write offs (Write-off) and returns (Returns).

2016 Unapplied cash tab

This data includes the same fields as what you received for the 2016 accounts receivable data. This data represents the unapplied cash at the end of 2016 updated now to reflect a “type” of “CashReceipt” and also includes the transaction number, applied to transaction number and invoice date information.

Required:

Submit in one Word document with a cover page the answers to the following questions:

Prepare a December 31, 2016, runoff analysis as of May 31, 2017 (demonstrating how the December 31, 2016, balance has “run off,” meaning explain what happened to the beginning balance to get to the ending balance, between January 1 and May 31, 2017). Display this at the customer level with the ability to drill down to the transaction (invoice) level. Document your findings by completing the following table:Adjusted accounts receivable as of December 31, 2016$15,118,973.57RunoffNet returnsNet bad debt write-offsNet cash receiptsRemaining accounts receivable as of May 31, 2017

Calculate the 2017 cash receipts on the December 31, 2016, balance by month and provide a visualization of the trend.

Determine what amount of the December 31, 2016, accounts receivable balance you believe is collectible. Prepare a summary report as part of your Word document for the audit committee that includes your audit findings and audit adjustments (continue using the previous summary of audit findings document from question #1). Your Word document should be 2-3 pages in length, double-spaced, and take you less than 10 minutes to present as a guide. Use the previous template to present your audit adjustments for the accounts receivable balance, only as provided below (note that you can add or delete items from the table below if you have more/fewer findings and adjustments than listed). Also, use the visualizations that you have prepared to support your report.

Summary of audit findings Accounts receivableAs of December 31, 2016$18,114,802.50Audit finding/adjustment Audit finding/adjustment Audit finding/adjustment Audit-adjusted balance as of December 31, 2016

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

CASE STUDY METHODOLOGY ASSIGNMENT INSTRUCTIONS OVERVIEW Researchers describe the background of the problem to define the root problem and explain the organizational consequences – this is where you wi

CASE STUDY METHODOLOGY ASSIGNMENT INSTRUCTIONSOVERVIEWResearchers describe the background of the problem to define the root problem and explain theorganizational consequences – this is where you will ‘well-define’ your case study. The problemstatement is a foundational component of the research study. In this assignment, you will beginto craft a single case

Discussion Thread: Problem Statements and Research Questions Business Problem Information A bank is experiencing a decrease in productivity. Employees appear to be stressed as a result of unmitigated

Discussion Thread: Problem Statements and Research Questions Business Problem Information A bank is experiencing a decrease in productivity. Employees appear to be stressed as a result of unmitigated job demands. Bank leaders have tried to address the issues but their efforts have had minimal positive impact. Leaders at the bank,

This is a journal entry that must be written in your own words, no ai or plagiarism included please! Instructions below: Strategic management includes an analysis of a business’s current state. Contin

This is a journal entry that must be written in your own words, no ai or plagiarism included please! Instructions below: Strategic management includes an analysis of a business’s current state. Continuing with your research of Alphabet, you will leverage the business SWOT tool to identify and drive organizational strategic

OVERVIEW OF CASE STUDIES ASSIGNMENT INSTRUCTIONS OVERVIEW Each case study type and its design are slightly different. These differences are important for researchers to consider when selecting a case

OVERVIEW OF CASE STUDIES ASSIGNMENT INSTRUCTIONSOVERVIEWEach case study type and its design are slightly different. These differences are important forresearchers to consider when selecting a case study type most appropriate for their research.Regardless of the type or design, each case study centers around its subject and object.Researchers typically build their

In a two page Word document, summarize the concepts learned in this course. Be sure to include: The role of forecasting in decision makingRisks associated with capital budgetingHow financial ratios (

In a two page Word document, summarize the concepts learned in this course. Be sure to include: The role of forecasting in decision making Risks associated with capital budgeting How financial ratios (analysis) assist in forecasting and budgeting Challenges in budgeting and forecasting Your paper should be in APA format

You will be using the “Repairing Customer Satisfaction” Download “Repairing Customer Satisfaction”case study for all of the assignments in this course. To complete the first assignment, you will need

You will be using the “Repairing Customer Satisfaction” Download “Repairing Customer Satisfaction”case study for all of the assignments in this course. To complete the first assignment, you will need to read the case study to develop the first progress report on your findings for the CEO. You will access the case study

Hello I need a short paper written in your own words, no AI or plagiarism please Write a 525- to 875-word response to the following prompts as your journal entry: Justify the guiding principles requ

Hello I need a short paper written in your own words, no AI or plagiarism please Write a 525- to 875-word response to the following prompts as your journal entry: Justify the guiding principles required for preparing effective statements that describe the mission, vision, and the core values of an organization.

Read “Case 5.1: In Need of a Sales Rep” at the end of Chapter 5 in your eTextbook. For this assignment, answer the questions below. In your response, make specific references to concepts that you lea

Read “Case 5.1: In Need of a Sales Rep” at the end of Chapter 5 in your eTextbook. For this assignment, answer the questions below. In your response, make specific references to concepts that you learned in Chapter 5 and any other sources that support your analysis of the questions.

Module 4 – SLPBusiness Analytics & Intelligence ReportingAssignment Overview Final Analysis Complete Module 4 SLP before Module 4 Case We have been working with survey data throughout class. C

Module 4 – SLPBusiness Analytics & Intelligence ReportingAssignment Overview Final Analysis **Complete Module 4 SLP before Module 4 Case** We have been working with survey data throughout class. Create a final report that can be used by industry leaders. Data analysis is transformed to business intelligence. This is where you

Milestone 3 is worth 60 points and is due at the end of Week 7. Milestone 3 provides a 5-year forecasted Income Statement and a 5-year forecasted Balance Sheet from which you will analyze your financi

Milestone 3 is worth 60 points and is due at the end of Week 7. Milestone 3 provides a 5-year forecasted Income Statement and a 5-year forecasted Balance Sheet from which you will analyze your financials using CVP analysis to determine breakeven and other metrics. You will also apply capital

You will be using the “Repairing Customer Satisfaction” Download “Repairing Customer Satisfaction”case study for all of the activities in this course. In week 3 you will develop the first progress rep

You will be using the “Repairing Customer Satisfaction” Download “Repairing Customer Satisfaction”case study for all of the activities in this course. In week 3 you will develop the first progress report where you will outline the root cause(s) and create a problem statement. For this activity, you will start the process by

Module 3 – CaseCorrelation Regression AnalysisAssignment Overview Regression Analysis Complete Module 3 SLP before Module 3 Case This is your final data analysis project in class. You have become

Module 3 – CaseCorrelation Regression AnalysisAssignment Overview Regression Analysis **Complete Module 3 SLP before Module 3 Case** This is your final data analysis project in class. You have become very familiar with the data and have a number of findings that may assist in managerial decision-making. The goal is to

Module 3 – SLPCorrelation Regression AnalysisAssignment Overview Correlation and Scatterplots Complete Module 3 SLP before Module 3 Case Let us delve into Organizational Commitment. In your earlie

Module 3 – SLPCorrelation Regression AnalysisAssignment Overview Correlation and Scatterplots **Complete Module 3 SLP before Module 3 Case** Let us delve into Organizational Commitment. In your earlier research, you discovered how important this is to a company. Now, we will investigate what types of correlations exist between Organizational Commitment and

Course Project Milestone 2 Milestone 2 of your Course Project is due this week. Please upload your required work using the Excel template by the end of the week. For more details, review to the Course

Course Project Milestone 2 Milestone 2 of your Course Project is due this week. Please upload your required work using the Excel template by the end of the week. For more details, review to the Course Project Overview page located in the Introduction and Resources module.

QUANTITATIVE ANALYSIS: COMPARING GROUPS WITH T TESTS, ANALYSIS OF VARIANCE (ANOVA) AND SIMILAR NON-PARAMETRIC TESTS SPSS Questions Chapter 9 Using the CollegeStudentData.sav file, do the following pro

QUANTITATIVE ANALYSIS: COMPARING GROUPS WITH T TESTS, ANALYSIS OFVARIANCE (ANOVA) AND SIMILAR NON-PARAMETRIC TESTSSPSS QuestionsChapter 9Using the CollegeStudentData.sav file, do the following problems. Print your outputs aftertyping your interpretations on them. Please circle the key parts of the output that you use foryour interpretation.Identify an example of a variable measured

Read “Case 5.1: In Need of a Sales Rep” at the end of Chapter 5 in your eTextbook. For this assignment, answer the questions below. In your response, make specific references to concepts that yo

The student must then post 1 reply to another student’s post. The reply must summarize the student’s findings and indicate areas of agreement, disagreement, and improvement. It must be supported with

The student must then post 1 reply to another student’s post. The reply must summarize thestudent’s findings and indicate areas of agreement, disagreement, and improvement. It must besupported with scholarly citations in the latest APA format and corresponding list of references.The minimum word count for Integrating Faith and Learning discussion

The student must then post 1 reply to another student’s post. The reply must summarize the student’s findings and indicate areas of agreement, disagreement, and improvement. It must be supported with