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

Deffendant managed a building in NY that is leased to the Administration of Children’s Services (ADS). Plaintiff was a peace officer employed by ADS. While changing in one of the building’s locker roo

Deffendant managed a building in NY that is leased to the Administration of Children’s Services (ADS). Plaintiff was a peace officer employed by ADS. While changing in one of the building’s locker rooms, Plaintiff opened a window to cool off. When Plaintiff closed the window, the whole window structure came

no AI WRITER Topic: Ethical Leadership in Nonprofit Organizations Serving Vulnerable Youth Scope: My paper will examine how ethical leadership practices influence making decisions, accountability, an

no AI WRITER Topic: Ethical Leadership in Nonprofit Organizations Serving Vulnerable Youth Scope: My paper will examine how ethical leadership practices influence making decisions, accountability, and trust in nonprofit organizations that serve vulnerable youth populations. The paper will analyze ethical challenges such as resource allocation, transparency, and power imbalance, having

Deffendant managed a building in NY that is leased to the Administration of Children’s Services (ADS). Plaintiff was a peace officer employed by ADS. While changing in one of the building’s locker roo

NO AI NO AI NO AI NO AI Comprehensive Marketing Plan Final SubmissionDirections: Please complete the remaining sections of the global marketing plan paper, including: Marketing mix (the seve

NO AI NO AI NO AI NO AI Comprehensive Marketing Plan Final SubmissionDirections: Please complete the remaining sections of the global marketing plan paper, including: Marketing mix (the seven Ps – product, place, promotion, price, people, process, physical evidence). – Product: Specifications, types, customer service, packaging, branding. Place: Distribution methods,

QUESTION SEVEN Hollender Company is a South African based manufacturer of kitchen fumiture. The company’s senior management has believed for several years that there is little opportunity to increase

QUESTION SEVEN Hollender Company is a South African based manufacturer of kitchen fumiture. The company’s senior management has believed for several years that there is little opportunity to increase sales in the domestic market and wish to set up a manufacturing subsidiary in Tanzania. Because of high transportation costs, exporting

LITERATURE REVIEW: FINAL ASSIGNMENT OVERVIEW A critical skill at the doctoral level is the ability to conduct scholarly research guided by clearly articulated research questions that address a specifi

LITERATURE REVIEW: FINAL ASSIGNMENT OVERVIEW A critical skill at the doctoral level is the ability to conduct scholarly research guided by clearly articulated research questions that address a specific issue or problem. It is important that you include and address the research questions provided. Changing the research question changes the

LITERATURE REVIEW: FINAL ASSIGNMENT OVERVIEW A critical skill at the doctoral level is the ability to conduct scholarly research guided by clearly articulated research questions that address a specifi

Greetings I am looking for someone to do my discussion post. Please see details below: Topic: Explain the importance of ethical behavior in a contracting environment. a. Read DCCH Chapt

Greetings I am looking for someone to do my discussion post. Please see details below: Topic: Explain the importance of ethical behavior in a contracting environment. a. Read DCCH Chapter 1 Instructions: Annotate two points of interest from your readings this week in the form of an initial post

Greetings, I am looking for someone to do my discussion post. Please see details below: Describe how you think contracting fits into the acquisition process. Feel free to use some of your own experien

Greetings, I am looking for someone to do my discussion post. Please see details below: Describe how you think contracting fits into the acquisition process. Feel free to use some of your own experiences and examples. Remember that we are only discussion contracting and acquisitions as related to government contracting. Do

Your goal in this assignment is to develop a case study utilizing scholarly resources and the theories presented in the unit. This will help you develop a deeper understanding of the practical applica

Your goal in this assignment is to develop a case study utilizing scholarly resources and the theories presented in the unit. This will help you develop a deeper understanding of the practical applications of the theories discussed throughout our course and encourage critical thinking. Your submission should be at least

Magazine Article This assignment measures your mastery of ULO 4.3. How do individuals learn to lead? That is the question your magazine editor has asked you to answer in your first assignment as a ne

Magazine Article This assignment measures your mastery of ULO 4.3. How do individuals learn to lead? That is the question your magazine editor has asked you to answer in your first assignment as a new reporter for a national magazine. Leadership is a subject you are not completely familiar with,

Infographic This infographic measures your mastery of ULOs 1.2, 4.2, and 5.1. Creating, building, and sustaining a team is central to the role and task of a leader. Assume you are newly appointed man

Infographic This infographic measures your mastery of ULOs 1.2, 4.2, and 5.1. Creating, building, and sustaining a team is central to the role and task of a leader. Assume you are newly appointed manager of a department combining the Marketing and Advertising departments into the newly formed Marketing division. This

LITERATURE REVIEW: FINAL ASSIGNMENT OVERVIEW A critical skill at this level is the ability to conduct scholarly research guided by clearly articulated research questions that address a specific issue

LITERATURE REVIEW: FINAL ASSIGNMENT OVERVIEW A critical skill at this level is the ability to conduct scholarly research guided by clearly articulated research questions that address a specific issue or problem. It is important that you include and address the research questions provided. Changing the research question changes the focus

Discussion Reply: You will reply to one of your classmates’ threads. Minimum of 250 words in the body. Minimum of 2 sources from the literature in addition to course texts. Use bolded headings below i

Discussion Reply: You will reply to one of your classmates’ threads. Minimum of 250 words in the body. Minimum of 2 sources from the literature in addition to course texts. Use bolded headings below in the reply. Current APA format must be used. Use the following Outline: • Summary –

Rewrite graduate research paper. Make sure the reference link is valid.

LITERATURE REVIEW: FINAL ASSIGNMENT OVERVIEW A critical skill at the doctoral level is the ability to conduct scholarly research guided by clearly articulated research questions that address a specifi

Discussion Reply: You will reply to one of your classmates’ threads. Minimum of 250 words in the body. Minimum of 2 sources from the literature in addition to course texts. Use bolded headings below i

LITERATURE REVIEW: FINAL ASSIGNMENT OVERVIEW A critical skill at the doctoral level is the ability to conduct scholarly research guided by clearly articulated research questions that address a specifi