At the end of Year 5, your consulting firm has been hired by a local service...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
At the end of Year 5, your consulting firm has been hired by a local service firm to help forecast future uncollectible accounts. For each of the prior five years, you ask the service firm to provide data on the age categories of year-end accounts receivable and the percentage of those accounts that eventually proved uncollectible. With these historical percentages, you estimate a trend line (dashed line) to predict the percentage of uncollectible accounts for Year 6, the upcoming year. Graphs were provided to management from your analysis of each of the three age categories, as well as balances of accounts receivable by age category at the end of Year 5 as follows: 8% 6% 4% 2% 0% 4% Not Yet Past Due --5% Year 1 2 3% 3 4 5% 5 Percentage of Uncollectible Accounts: 1-30 Days Past Due 6% 6 $140,000 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $0 Click here to open the graphs in a new tab. 18% 16% 14% 12% 10% 16% 14% Year 1 2 $128,000 17% Not Yet Past Due 3 14% Accounts Receivable by Age: End of Year 5 4 5 6 15% $84,000 1-30 Days Past Due 46% 44% 42% 40% 38% $35,000 Over 30 Days Past Due 42% Year 1 Over 30 Days Past Due 40% 2 41% 3 4 42% 43% 5 6 Required: 1. Which age categories predicts the lowest percentage of uncollectible accounts for Year 6? 2. Which age categories predicts the highest percentage of uncollectible accounts for Year 6? 3. What is the dollar amount of accounts receivable that are 1-30 days past due at the end of year 5 (bottom graph)? 4. Calculate the total amount of estimated uncollectible accounts for Year 6 (Hint: Use all three age categories)? 5. Assume the balance of Allowance for Uncollectible Accounts is $4,850 (credit) at the end of Year 5 (before any adjustment). Prepare the adjusting entry at the end of Year 5. 6. Determine the amount of net accounts receivable the company would report at the end of Year 5. At the end of Year 5, your consulting firm has been hired by a local service firm to help forecast future uncollectible accounts. For each of the prior five years, you ask the service firm to provide data on the age categories of year-end accounts receivable and the percentage of those accounts that eventually proved uncollectible. With these historical percentages, you estimate a trend line (dashed line) to predict the percentage of uncollectible accounts for Year 6, the upcoming year. Graphs were provided to management from your analysis of each of the three age categories, as well as balances of accounts receivable by age category at the end of Year 5 as follows: 8% 6% 4% 2% 0% 4% Not Yet Past Due --5% Year 1 2 3% 3 4 5% 5 Percentage of Uncollectible Accounts: 1-30 Days Past Due 6% 6 $140,000 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $0 Click here to open the graphs in a new tab. 18% 16% 14% 12% 10% 16% 14% Year 1 2 $128,000 17% Not Yet Past Due 3 14% Accounts Receivable by Age: End of Year 5 4 5 6 15% $84,000 1-30 Days Past Due 46% 44% 42% 40% 38% $35,000 Over 30 Days Past Due 42% Year 1 Over 30 Days Past Due 40% 2 41% 3 4 42% 43% 5 6 Required: 1. Which age categories predicts the lowest percentage of uncollectible accounts for Year 6? 2. Which age categories predicts the highest percentage of uncollectible accounts for Year 6? 3. What is the dollar amount of accounts receivable that are 1-30 days past due at the end of year 5 (bottom graph)? 4. Calculate the total amount of estimated uncollectible accounts for Year 6 (Hint: Use all three age categories)? 5. Assume the balance of Allowance for Uncollectible Accounts is $4,850 (credit) at the end of Year 5 (before any adjustment). Prepare the adjusting entry at the end of Year 5. 6. Determine the amount of net accounts receivable the company would report at the end of Year 5.
Expert Answer:
Answer rating: 100% (QA)
1 Year 6 Not yet past due 6 130 past due 15 Over 30days past due 43 For year 6 The Lowest percentage ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A perpetuity pays $50,000 at the end of Year 1 and then grows at a rate of 6 percent per year indefinitely. What is the present value if the rate of interest used to discount the cash flows is 10...
-
In taking a physical inventory at the end of year 2011, Nadir Company forgot to count certain units. Explain how this error affects the following: (a) 2011 cost of goods sold, (b) 2011 gross profit,...
-
At the end of Year 1, Framber Company received $8,000 as a prepayment for renting a building to a tenant during Year 2. The company erroneously recorded the transaction by debiting Cash and crediting...
-
There are two major producers of corncob pipes in the world. Suppose that the inverse demand function for corncob pipes is described by p = 120 - 4g where g is total industry output and suppose that...
-
Jeter, Inc. has net income (30% tax rate) of $1,400,000 for 2008, and an average number of shares outstanding during the year of 500,000 shares. The corporation issued $2,000,000 par value of...
-
If a high-speed spaceship appears shrunken to half its normal length, how does its momentum compare with the classical formula p 5 mv?
-
Name and explain two allocation rules and two allocation keys. Why are allocation rules and keys important to lower-level management? If you were a site manager in a chemical company, with a single...
-
On October 5, 2014, Diamond in the Rough Recruiting Group Inc.'s board of directors decided to dispose of the Blue Division. A formal plan was approved. Diamond derives approximately 7 5% of its...
-
Describe differing types of currency exchange rate financial risk exposures. Discuss the methods a company may use to reduce the potentially significant negative impact of these different types of...
-
Loblaw Manufacturing has asked you to create a cash budget in order to determine its borrowing needs for the June to October period. You have gathered the following information. April and May sales...
-
(a) In order to prepare to send his child to a medical school in future, Encik Ishak wants to accumulate RM1.5 million at the end of 15 years. Assuming that his savings account will pay 4.5%...
-
1.Consequentialists have a strong hold on public decision-making in the US and its moral grounding. Describe the key elements of consequentialism, or utilitarianism more narrowly, as a form of moral...
-
Blue Deals sells household furniture and appliances. The manager decided to sell a couch to a customer at a 75% discount with 9 months to pay, no interest and no deposit, because the couch was no...
-
1. Explain the difference between molecular formulas andempirical formulas. Give an example of a substance whose empiricalformula is different from its molecular formula. Give an example ofa...
-
A company began January with 7 , 0 0 0 units of its principal product. The cost of each unit is $ 6 . Inventory transactions for the month of January are as follows: Date of Purchase January 1 0-...
-
What were the goals and most important aspects fo the startbuks transformation? elaborate on schultz;s comments aobut redefinding t erole of a forprofit companym, and what you think he means by thi...
-
In a snowball fight, you need to hit two targets that are crawling on the ground with a height of 0 . 5 meters that are 2 . 5 meters and 4 meters directly in front of you. If you always throw your...
-
What did Lennox gain by integrating their WMS, TMS, and labor management systems?
-
Explain the reporting implication of losing significant influence over an affiliate due to a conflict with the other shareholders.
-
Discuss the importance of identifying the acquisition date.
-
The Roger family lost everything in a fire in their home at the beginning of December 2012. On December 23, 2012, a fundraiser was held and an anonymous donation was made to the Sunworld charity to...
-
Why is the thermodynamic process also called cyclic process? Explain with suitable example.
-
A mercury manometer reads \(40 \mathrm{~cm}\) at \(30^{\circ} \mathrm{C}\) and \(1 \mathrm{~atm}\). Determine the absolute pressure, given that \(ho_{\mathrm{Hg}}=14.02 \mathrm{~g} /...
-
Define isothermal, isochoric and isobaric processes with suitable examples.
Study smarter with the SolutionInn App