Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Accounting

03/10/2020 Client: sarah Deadline: 10 Days

  


Analytics in Action Assignment


Chapter 7- Variations in Estimates: The Allowance for Doubtful Accounts


Kieso Intermediate Accounting 17e


Directions: You can find the dataset needed for this assignment in your WileyPLUS course on the explore tab for chapter 7 under the “Analytics in Action” icon. 


The dataset provided with this chapter includes data for the allowance for doubtful account receivable accounts of six members of the Dow 30 from 2016 to 2018.  For each company and year, the data starts with the beginning balance in the allowance for doubtful accounts, adds bad debt expense, subtracts write-offs, and then adjusts for amounts charged to other accounts. 


William R. Pasewark and Mark E. Riley (Journal of Accountancy, September 2009, pages 40-44) discuss three techniques for analyzing estimates of uncollectible receivables. Pasewark and Riley note that all of the benchmarks (referenced below) are based on their opinions and might differ based on specific circumstances. You will use these techniques to assess estimates made by Chevron, Cisco, Coca-Cola, Dow, Microsoft, and Verizon during the period 2016 to 2018.


1. The first technique compares cumulative bad debt expense recorded over a multi-year period to write-offs over that same period. Pasewark and Riley state that 1.0 is a general benchmark for this ratio. Compute this ratio for the 2016-2018 period for each company. Plot the ratios using a histogram. Comment on any differences you note among the companies’ ratios and on what they might reflect about the companies’ estimation processes. Why might a company record negative bad debt expense (i.e. a credit to expense)?


2. The second technique compares each year’s beginning allowance for doubtful accounts balance to write-offs for the same years. Pasewark and Riley note that a figure between 1.0 and 2.0 is a benchmark for a typical year. Compute this ratio for each company and year. In other words, you will compute three ratios for each company. Again, use a histogram to represent the data and comment on any differences you note among the companies’ ratios. Are there patterns emerging that are consistent between the two techniques employed thus far? What do the patterns indicate about the companies’ tendencies in estimating their allowances for doubtful accounts?


3. The third technique employs the allowance exhaustion rate. Pasewark and Riley suggest a company should typically exhaust its beginning allowance within one to two years. You will slightly modify the method recommended by Pasewark and Riley. Using 2017 as year t, adopt the same method Pasewark and Riley recommend if the entire 2017 beginning allowance is used in the form of write-offs by the end of 2017 or 2018. 


· If the entire 2017 beginning balance is used in the form of write-offs by the end of 2017, compute the exhaustion rate by dividing the beginning allowance by total 2017 write-offs. 


o For example, if a company’s beginning 2017 allowance balance was 100 and write-offs during 2017 totaled 150, the exhaustion rate would equal 100 / 150 = 0.67. This calculation would indicate that it would take two-thirds of a year to use the allowance in the form of write-offs.


· If the entire 2017 beginning balance is not used in the form of write offs by the end of 2017, but is used by the end of 2018, compute the unused portion of the allowance at the end of 2017 and divide that unused amount by 2018 write-offs. Add one to the result. 


o For example, assume a company had a beginning allowance for doubtful accounts of 100 in 2017, with write-offs of 75 in 2017 and 50 in 2018. At the end of 2017, 25 (100 beginning balance – 75 write-offs) of the company’s beginning allowance had not yet been utilized. Therefore, you would take the remaining allowance of 25 and divide that amount by the 50 written off in 2018, to obtain a result of 0.50. Adding that to 1, provides a result of 1.50. In other words, it took one-and-a-half years for the company to utilize its beginning 2017 allowance in the form of write-offs. 


· If a company does not utilize its beginning 2017 allowance in the form of write-offs by the end of 2018, you will modify Pasewark and Riley’s method. You will assume the write-off pattern for 2017 and 2018 is indicative the pattern for future years. You will, therefore, divide the beginning 2017 allowance for doubtful accounts by average write-offs for 2017 and 2018 to compute a projected allowance exhaustion rate.


o For example, if a company’s beginning 2017 allowance balance totaled 100 and its write-offs for 2017 and 2018 were 22 and 18, respectively, you would perform the following calculation of its exhaustion rate: 100 / average(22,18) = 5. In other words, based on average write-offs of 20 per year, this company’s projected allowance exhaustion rate for its 2017 beginning allowance for doubtful accounts is 5 years. This is, of course, an imperfect method, as it is a projection based on only two years of write-off data. There might be other methods that are preferable.


HINT: In order to efficiently calculate the exhaustion rates for all six companies, using a formula that you can copy and paste from company to company, you should use nested if statements that consider all three possible scenarios discussed above.


REQUIREMENT: As with questions 1 and 2, use histograms to graphically represent the exhaustion rates you computed for each company.


Are the exhaustion rates for any of the companies surprising? What incentives might drive some of the more extreme rates? 


4. Compare the ratios you computed above for each company. Do you notice trends in specific companies’ estimation patterns? Do some companies seem to be closer to Pasewark and Riley’s benchmarks than others? Could a company have legitimate reasons for falling well outside these benchmarks? Based on the data you have encountered and evaluated, which company’s estimation process would you deem least accurate? Why? Which company’s estimation process would you deem most accurate? Why?

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Instant Assignments
Financial Hub
Top Academic Guru
Smart Tutor
Top Grade Tutor
Study Master
Writer Writer Name Offer Chat
Instant Assignments

ONLINE

Instant Assignments

Good day dear client, I am a full-time freelance writer with years of experience. My strongest strengths are strong dedication to duty, reliability, quality and excellence. I am going to do an outstanding job for you, kindly PM me and let us commence. Thank you so much in anticipation of your positive response. Thank you very much.

$225 Chat With Writer
Financial Hub

ONLINE

Financial Hub

Hey, I have gone through your job posting and become very much interested in working with you.I can deliver professional content as per your requirements. I am a multi-skilled person with sound proficiency in the English language for being a native writer who worked on several similar projects of content writing and can deliver quality content to tight deadlines. I am available for both online and offline writing jobs with the promise of offering an incredibly responsive and supreme level of customer service. Thanks!

$225 Chat With Writer
Top Academic Guru

ONLINE

Top Academic Guru

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$205 Chat With Writer
Smart Tutor

ONLINE

Smart Tutor

Hi, After reviewing your project description, I understand well. I am a highly-skilled writer who has strong visual awareness, exemplary grammar and spelling knowledge, and the ability to analyze and modify. When it comes to missing links and correcting errors, look no farther. Without the need of any online rewriting tool I can turn your old content into a new and exciting piece of plagiarism free writing. Remember, your content could be a first impression. If you send out material that is riddled with misspellings, grammatical errors, and wrong information, you aren’t going to be presenting a good image of your business. Let’s get that content in tip-top shape today.

$230 Chat With Writer
Top Grade Tutor

ONLINE

Top Grade Tutor

I am highly qualified expert, working from 2008-9 in this industry. I have all relevant skills and expertise related to your project. To ensure my potential must visit my profile to check my ratings and uploaded samples. Thanks :--)

$210 Chat With Writer
Study Master

ONLINE

Study Master

I can manage this work as per your requirements. Lets discuss on chat about more details. I am an MBA writer with 5 years of experience and can deliver quality content even too Short Deadlines. I can write 3000 to 4000 words in a day. I will deliver A+ quality work without Plagiarism at less price and time. Lets discuss more over the chat. Thanks

$205 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Bp oil spill pr case study - Objective section of soap note - Mrs watanabe and the japanese yen carry trade mini case - Qusetion - Class 1b building requirements qld - Chlorsig how to use - The Fog of War - Esure car insurance vandalism - Example of a 4 mat review paper - The twa corbies analysis - Stevenson the emotive meaning of ethical terms summary - Essay about using phones in school - Iris peabody vanderbilt edu module udl - Which of the following statements regarding standard test marketing is correct? - Breakfast on pluto sparknotes - 10000000 in scientific notation - Ethical issues in group counseling pdf - Discussion - Ji - Enlightenment salon party answer key - Master mason questions and answers - Nhs scotland jobs ayrshire and arran - Rough Draft Literature Review - Causality and stability in laplace transform - Stelrad radiator cover removal - The healthcare quality book pdf - Convergent marketing tools and techniques - What is the implication of moore's law for managers - 120 pearl river road - What i see in lincoln's eyes - Vector equation of a line - Bmw case study solution - Solar Energy - Growing up asian in america analyzing the text - Design for disassembly examples - 2011 hsc economics answers - Myitlab access chapter 6 grader project - Pgem t vector sequence - Are pigs color blind - Why does morrie want to be cremated - Using an epinephrine auto injector ati - Nutrition and drugs - 63mm grey corrugated conduit - Sydney train network map - 4 pages due by 10 hours - Manual card entry eftpos - Moodle koi edu au - Alka seltzer rocket race - Www nihe gov uk - Compare the market simples lab - Copper sheet thickness tolerance - Information system - Gender role in negotiation and conflict management - Essays guru - Words with a double consonant - Disadvantages of enterprise application integration - Minimum 150 words The Romantic period was all about emotion and individual expression. How are the popular, social and political trends of that time similar to the trends of today? - Robyn tomorrow when the war began - Internal auditing assurance and consulting services multiple choice questions - Does a grasshopper have an open or closed circulatory system - List gods of egypt - Deliverable 1 - Defining and Categorizing Various Forms of Risk - Aro risk management - PRESIDENT REPORT PRESENTATIONS (BARACK OBAMA) - Chemical equilibrium and le chatelier's principle lab report answers - Portsmouth arms pub quiz - Al ghazali deliverance from error - How to make a daisy head mayzie headband - Tim burton writing style - Theory of chronic sorrow in nursing - Community Nursing DQ 1 Student repply Vivian Guillen - Dr youssef hazimah toledo oh - Dulux white on white 30gy 88/014 - Pricing strategy of nestle chocolates - Activity summary sheet the anthropocene human impact on environments - Research Question - HIST CA 12 - 2 examples of neolithic myths - Windshield survey summary and reflection - 6 strip h method - Assignment Part 1 Submit Assignment - What is bonding molecular orbital - History of smart cards in healthcare - Telstra apply for phone - Close reader mother tongue answers - Psychotherapy With group - Budget and Profit Loss Statement due in 60 hours - Klasemen Liga Champions 2022/2023 Terbaru - Week 14 - Dr jean alligator song - Product life cycle powerpoint presentation - Bangladesh agricultural university subjects - Allied bank payment tracking - Macbeth themes and quotes - Inspector de aduanas ¿tiene usted (1) que declarar? - Responsibilities, Duties, and the Operational and Management Challenges Confronting Security Directors - Module 01 Project – Planning - Case Study - Asynchronous remote procedure call - What are fungus like protists