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

DISCUSSION: EFFECTIVE EXECUTION, DESIGN/FOCUS, AND DECISION TRAPS ASSIGNMENT INSTRUCTIONS This discussion will focus on a series of questions in the areas of Process (steps to be taken), Strategic Thi

DISCUSSION: EFFECTIVE EXECUTION, DESIGN/FOCUS, AND DECISION TRAPS ASSIGNMENT INSTRUCTIONS This discussion will focus on a series of questions in the areas of Process (steps to be taken), Strategic Thinking (current theory), Decision Traps (decision making methodology), and Biblical Integration. The student should organize their main thread by using the bolded

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 –

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

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

DISCUSSION: INTERNAL ENVIRONMENT, POWER/WEAKNESS, AND DECISION MODELS ASSIGNMENT INSTRUCTIONS This discussion will focus on a series of questions in the areas of Process (steps to be taken), Strategic

DISCUSSION: INTERNAL ENVIRONMENT, POWER/WEAKNESS, AND DECISION MODELS ASSIGNMENT INSTRUCTIONS This discussion will focus on a series of questions in the areas of Process (steps to be taken), Strategic Thinking (current theory), Decision Models (decision making methodology), and Biblical Integration. The student should organize their main thread by using the bolded

DISCUSSION: EFFECTIVE EXECUTION, DESIGN/FOCUS, AND DECISION TRAPS ASSIGNMENT INSTRUCTIONS This discussion will focus on a series of questions in the areas of Process (steps to be taken), Strategic Thi

DISCUSSION: COMPETITIVE APPROACH, COMPETITIVE SCOPE, AND DECISION MODELS ASSIGNMENT INSTRUCTIONS This discussion will focus on a series of questions in the areas of Process (steps to be taken), Strate

DISCUSSION: COMPETITIVE APPROACH, COMPETITIVE SCOPE, AND DECISION MODELS ASSIGNMENT INSTRUCTIONS This discussion will focus on a series of questions in the areas of Process (steps to be taken), Strategic Thinking (current theory), Decision Models (decision making methodology), and Biblical Integration. The student should organize their main thread by using the

Develop an Entrepreneurship Due Diligence Report on Maydm’s technology education non-profit, using the articles found in the following links. https://maydm.org/(Review information found in the links o

Develop an Entrepreneurship Due Diligence Report on Maydm’s technology education non-profit, using the articles found in the following links. information found in the links of Maydm’s website) https://www.ibmadison.com/In-Business-Madison/May-2019/Maydm-awarded-50K-grant-from-CUNA-Mutual-Foundation/ https://www.maydm.org/newsLinks to an external site. to an external site. Consider the following questions. Note that because this is a general outline, not

IDS 150 Project Guidelines and RubricCompetencies In this project, you will demonstrate your mastery of the following competencies: Explain how human and environmental systems are interconnectedExplai

IDS 150 Project Guidelines and RubricCompetencies In this project, you will demonstrate your mastery of the following competencies: Explain how human and environmental systems are interconnected Explain how sustainable systems balance social, economic, and environmental needs Analyze approaches to address a sustainability issue Overview Throughout this course, you have explored

SHEILA- EVENT PLANNING- UP TO 2/16/2025- *** IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!* **** THIS

SHEILA- EVENT PLANNING- UP TO 2/16/2025- ***** IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!***** ****** THIS ****** THIS ASSIGNMENT HAS 2 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** ****

Prepare a research paper on the topic – Innovative Funding Prospects. (Note that traditional debt funding and traditional equity funding are not considered to be innovative.) Submission Instruc Goal:

Prepare a research paper on the topic – Innovative Funding Prospects. (Note that traditional debt funding and traditional equity funding are not considered to be innovative.) Submission Instruc Goal: Prepare a research paper on the topic – Innovative Funding Prospects. (Note that traditional debt funding and traditional equity funding are not considered to

LITERATURE REVIEW ASSIGNMENT INSTRUCTIONS LITERATURE REVIEW: OUTLINE ASSIGNMENT OVERVIEW A critical skill at the doctoral level is the ability to conduct scholarly research guided by clearly articulat

LITERATURE REVIEW ASSIGNMENT INSTRUCTIONS LITERATURE REVIEW: OUTLINE 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. For this literature review, your research will be guided by the following three Research

6-2 Journal: The Role of Human Consumption in Sustainability IDS 150 Module Six Journal Guidelines and Rubric Overview In this module, we have learned that human consumption significantly impacts sust

6-2 Journal: The Role of Human Consumption in SustainabilityIDS 150 Module Six Journal Guidelines and Rubric Overview In this module, we have learned that human consumption significantly impacts sustainable development by overusing resources and generating waste. To support sustainability, consumption must become more efficient and minimize environmental harm. Considering personal consumption

DISCUSSION: INTERNAL ENVIRONMENT, POWER/WEAKNESS, AND DECISION MODELS ASSIGNMENT INSTRUCTIONS This discussion will focus on a series of questions in the areas of Process (steps to be taken), Strategic

Goal: Prepare a research paper on the topic – Innovative Funding Prospects. (Note that traditional debt funding and traditional equity funding are not considered to be innovative.) Submission Instruc

Goal: Prepare a research paper on the topic – Innovative Funding Prospects. (Note that traditional debt funding and traditional equity funding are not considered to be innovative.) Submission Instructions: The paper is to be clear and concise and students will lose points for improper grammar, punctuation, and misspelling. The paper is to a

A Note to Fellow Academic Writers Hi everyone, I want to share my experience for those working on Studydaddy.com. During my time there, I faced consistent challenges with payment timelines, deductions

A Note to Fellow Academic Writers Hi everyone, I want to share my experience for those working on Studydaddy.com. During my time there, I faced consistent challenges with payment timelines, deductions, and transparency. Often, only part of my earnings was available for withdrawal, with waiting periods extending up to 60