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

The next step in the Capstone Project process is to create an outline and description of the business proposal or business plan you will submit for your final project. It must expand on the Capstone P

The next step in the Capstone Project process is to create an outline and description of the business proposal or business plan you will submit for your final project. It must expand on the Capstone Project Proposal completed in Unit 1. Instructions: Please follow the following outline. Your Topic Statement

The next step in the Capstone Project process is to create an outline and description of the business proposal or business plan you will submit for your final project. It must expand on the Capstone P

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

Case Study 2: Identifying Behavioral Biases in Investment Decisions Objective: The goal of this activity is to help you identify different behavioral biases that influence decision-making in financial

Case Study 2: Identifying Behavioral Biases in Investment Decisions Objective: The goal of this activity is to help you identify different behavioral biases that influence decision-making in financial markets. Work in a group to analyze the case assigned and identify the bias involved. Assignment Instructions: Read the PowerPoints: Read Page

Locate any report or periodical article that contains at least two different graphical representations of data or use one of the supplied articles. Interpret the graphs and present your findings in a

Locate any report or periodical article that contains at least two different graphical representations of data or use one of the supplied articles. Interpret the graphs and present your findings in a brief PowerPoint presentation (6-10 slides). Expand AllIntroduction Business administrators and managers are often called upon to interpret data

SHEILA- UP TO 3/6/2025- *** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED* **** THIS ASSIGNMENT HAS 2 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES

SHEILA- UP TO 3/6/2025- ***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED***** ****** THIS ASSIGNMENT HAS 2 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES SHEILA- UP TO 3/6/2025- ***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT

VAL- UP TO 3/6/2025- *** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED* **** THIS ASSIGNMENT HAS 3PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN

VAL- UP TO 3/6/2025- ***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED***** ****** THIS ASSIGNMENT HAS 3PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** PART 1- Module 4- DISCUSSION- (VAL)- Bankruptcy Why do businesses file for bankruptcy and

You will create two concept maps housed in one PowerPoint presentation. Your two-page concept map PowerPoint presentation will consist of the two infographics you create and slide notes. There is no s

You will create two concept maps housed in one PowerPoint presentation. Your two-page concept map PowerPoint presentation will consist of the two infographics you create and slide notes. There is no standard format for a concept map, so you may create yours however you choose. The goal is simply to

This is the first step in creating your Capstone Project. You will select and describe your topic and address all guidelines listed below as it pertains to your topic. In order to gain approval from t

This is the first step in creating your Capstone Project. You will select and describe your topic and address all guidelines listed below as it pertains to your topic. In order to gain approval from t This is the first step in creating your Capstone Project. You will select and

Scenario You are an HR consultant, contracted by the VP of an LLC in Wilmington, Delaware, to solve their internal challenges. This U.S. office is a branch of a larger Singaporean software solutions o

Scenario You are an HR consultant, contracted by the VP of an LLC in Wilmington, Delaware, to solve their internal challenges. This U.S. office is a branch of a larger Singaporean software solutions organization that has a total of 140 employees and generates $20M in revenue per year. The CEO

Hello, I am in need of assistance with the attached assignment. I need the assignment to be checked for plagiarism prior to sharing it back with me. Thanks in advance.

Length: Your submission should be at least two (2) pages in length, not including the title page and references (if used). References: APA Style will not be required for this assignment, and no outsid

Length: Your submission should be at least two (2) pages in length, not including the title page and references (if used). References: APA Style will not be required for this assignment, and no outside resources are required. Details: Using the Unit III Assignment Template, write a dialogue (short conversation) between two people. Keys to

Length: Your submission should be at least two (2) pages in length, not including the title page and references (if used). References: APA Style will not be required for this assignment, and no outsid

Details: This assignment has two parts. Both parts will be completed in the same attached Unit VII Homework Template. Part 1: Choose one of the three topics from the table below. Write an argument

Details: This assignment has two parts. Both parts will be completed in the same attached Unit VII Homework Template. Part 1: Choose one of the three topics from the table below. Write an argument with a clear conclusion (thesis) that you have created about this topic. Your conclusion must be a straightforward one-sentence

This is the first step in creating your Capstone Project. You will select and describe your topic and address all guidelines listed below as it pertains to your topic. In order to gain approval from t

This is the first step in creating your Capstone Project. You will select and describe your topic and address all guidelines listed below as it pertains to your topic. In order to gain approval from the instructor, you will need to choose one of the topic focuses below, address the

For this essay assignment, you are tasked with locating a company or business that has experienced an ethical issue within the last 5 years. In your essay, you will include the following information:

For this essay assignment, you are tasked with locating a company or business that has experienced an ethical issue within the last 5 years. In your essay, you will include the following information: the name of the company or business and a description of the ethical issue that took place,