Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

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: 

  1. 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. 

  1. 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

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Jayhawk CAPITAL ADVISORS Mid-Term Assignment Background: You work as an analyst for Jayhawk Capital Advisors (“JCA”), a leading middle- market investment bank. JCA has been engaged by the shareholders

Jayhawk CAPITAL ADVISORS Mid-Term Assignment Background: You work as an analyst for Jayhawk Capital Advisors (“JCA”), a leading middle- market investment bank. JCA has been engaged by the shareholders of ABC Auto Parts (“ABC” or the “Company”) to evaluate an unsolicited takeover bid for $175 million from the Company’s largest

Ridgecrest Electric manufactures electric motors. It competes and plans to grow by selling high-quality motors at a low price and by delivering them to customers quickly after receiving customers’ ord

Ridgecrest Electric manufactures electric motors. It competes and plans to grow by selling high-quality motors at a low price and by delivering them to customers quickly after receiving customers’ orders. There are many other manufacturers who produce similar motors. Ridgecrest believes that continuously improving its manufacturing processes and having satisfied

Company: Apple Using the APUS library and other sources, complete a presentation that includes a balanced score card for a public corporation of your choosing. Unlike other weekly assignments, this as

Company: Apple Using the APUS library and other sources, complete a presentation that includes a balanced score card for a public corporation of your choosing. Unlike other weekly assignments, this assignment does not have a standard template. Complete the balanced score card in presentation format to present to management your

Write 200-250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200-250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.  For this Discussion Board, please complete the following: Gross domestic product (GDP) is a measurement of how much people produce of goods and services. What

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.  For this Discussion Board, please complete the following: You have recently been promoted to the position of controller for M&K Industries. You have partnered

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Please complete the following:

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.  Please complete the following: You have completed several assignments in the online learning platform. Everyone is challenged by different parts. Learning how to successfully

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.  For this Discussion Board, please complete the following: You have learned about supply and demand. You know that when prices go up, people buy

Topic: Appraise the role of fraud through the auditing process In this discussion, please reflect on the previous weeks’ topics. Choose a topic you found to be difficult or hard to understand. Researc

Topic: Appraise the role of fraud through the auditing process In this discussion, please reflect on the previous weeks’ topics. Choose a topic you found to be difficult or hard to understand. Research this topic and present your findings. Include a summary of the topic, why you found the topic

Paula Beane owns a restaurant franchise that is part of a chain of “Southern Homestyle” restaurants. One of the chain’s popular breakfast items is biscuits and gravy. Central Warehouse makes and freez

Paula Beane owns a restaurant franchise that is part of a chain of “Southern Homestyle” restaurants. One of the chain’s popular breakfast items is biscuits and gravy. Central Warehouse makes and freezes the biscuit dough, which it then sells to the franchise stores where it is thawed and baked in

Topic: You are an auditor at a prestigious CPA firm. After several years of hard work, your boss informs you that you will be in charge of this year’s audit of the firm’s most important client, Bullse

Topic: You are an auditor at a prestigious CPA firm. After several years of hard work, your boss informs you that you will be in charge of this year’s audit of the firm’s most important client, Bullseye, a general merchandise retailer with hundreds of stores throughout the United States. Bullseye is

Studydaddy Critics You all noticed that the site’s support team has basically ghosted everyone. No replies to tickets, no fixing complaints, no refunds, no dispatching payments straight radio silence.

Studydaddy Critics You all noticed that the site’s support team has basically ghosted everyone. No replies to tickets, no fixing complaints, no refunds, no dispatching payments straight radio silence. So yeah, we got fed up and threw this dumb little script. It just keeps posting this same question after approximately

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.  For this Discussion Board, please complete the following: Tax code changes in the United States occur for several reasons, reflecting both economic and social

Description: Professionals increase their awareness of current research related to the teaching of young children by reading professional journal articles. Review one journal article written in the l

Description: Professionals increase their awareness of current research related to the teaching of young children by reading professional journal articles.  Review one journal article written in the last 5 years concerning individualizing instruction in early childhood classrooms. Please use Google Scholars from Miami Dade College for the article. Directions: Read

Topic: Assess the key elements of the audit report, auditor responsibilities, audit objectives, audit evidence, audit planning, audit strategy, audit program, materiality, risk, and analytical procedu

Topic: Assess the key elements of the audit report, auditor responsibilities, audit objectives, auditevidence, audit planning, audit strategy, audit program, materiality, risk, and analytical procedures. In this discussion, please reflect on the previous weeks’ topics. Choose a topic you found to be difficult or hard to understand. Research this topic

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.  For this Discussion Board, please complete the following: Tax planning involves strategic decision making to minimize tax liability within the bounds of the law.

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Understanding tax concepts, po

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.  Understanding tax concepts, policies, and effective tax planning strategies is essential for individuals. Explore the rationale behind two of the tax concepts, policies, or

Corporation: Walmart In this discussion, please reflect on changes in accounting principles and error corrections. How can you determine the difference between error correction and fraud? Add an exa

Corporation: Walmart  In this discussion, please reflect on changes in accounting principles and error corrections.  How can you determine the difference between error correction and fraud? Add an example from a public corporation. Include a copy of the corporation’s disclosure note and explain the effect the change or error correction