Question

In: Accounting

At the end of Year 5, your consulting firm has been hired by a local service firm to help forecast future uncollectible accounts.

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: 

image.png

image.png

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. 



Solutions

Expert Solution

1)

Year 6
Not yet past due 6%
1-30 past due 15%
Over 30days past due 43%

For year 6 ,The Lowest percentage of Uncollectible accounts are "Not yet past due " which is 6%     (from all first three graphs)

2)For year 6 ,The Highest percentage of Uncollectible accounts are "over 30 days past due " which is 43%     (from all first three graphs)

3)Dollar Amount of Accounts receivable that are 1-30 days past due = $ 84000

4)

Amount of Receivable * % OF uncollectible account = Total amount of estimated Uncollectible accounts for year6
Not yet past due 128000 6% 7680
1-30 past due 84000 15% 12600
Over 30days past due 35000 43% 15050
Total amount of estimated Uncollectible accounts for year 6 35330

5)

Date Account title Debit credit
Year 5 Bad debt expense 30480
Allowance for Uncollectible account 30480
[Being bad debt expense recorded :35330 Total estimated Uncollectible account -4850 credit balance in allowance account )

6)

Accounts Receivable (128000+84000+35000) 247000
less:Allowance for Uncollectible account (35330)
Net Accounts receivable at year 5 211670

Related Solutions

At the end of the year, a company has a balance in Allowance for Uncollectible Accounts...
At the end of the year, a company has a balance in Allowance for Uncollectible Accounts of $2,000 (credit) before any year-end adjustment. The balance of Accounts Receivable is $180,000. The company estimates that 5% of accounts receivable will not be collected over the next year. Record the adjustment for uncollectible accounts. (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field.) 
Your consulting firm has been hired to evaluate a manufacturing process. In order to value the...
Your consulting firm has been hired to evaluate a manufacturing process. In order to value the process, you’ve decided to value each piece separately. You are currently evaluating the effect of inventory on the final value of the project. The process requires an initial amount of NWC of $500k. Each year, NWC will increase by $100k. The manufacturing process will be in operation for 10 years before shutting down. If the firm’s discount rate is 6%, what is the effect...
Brief Exercise 5-6 Record the adjusting for uncollectible accounts (LO5-5) At the end of the year,...
Brief Exercise 5-6 Record the adjusting for uncollectible accounts (LO5-5) At the end of the year, Mercy Cosmetics’ balance of Allowance for Uncollectible Accounts is $400 (credit) before adjustment. The balance of Accounts Receivable is $15,000. The company estimates that 10% of accounts will not be collected over the next year. What adjustment would Mercy Cosmetics record for Allowance for Uncollectible Accounts? (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account...
Marshall Inc. recently hired your consulting firm to improve thecompany's performance. It has been highly...
Marshall Inc. recently hired your consulting firm to improve the company's performance. It has been highly profitable but has been experiencing cash shortages due to its high growth rate. As one part of your analysis, you want to determine the firm's cash conversion cycle. Using the following information and a 365-day year, what is the firm's present cash conversion cycle?Average inventory = $75,000Annual sales = $600,000Annual cost of goods sold = $360,000Average accounts receivable = $180,000Average accounts payable = $54,000
Marshall Inc. recently hired your consulting firm to improve the company's performance. It has been highly...
Marshall Inc. recently hired your consulting firm to improve the company's performance. It has been highly profitable but has been experiencing cash shortages due to its high growth rate. As one part of your analysis, you want to determine the firm's cash conversion cycle. Using the following information and a 365 day year, what is the firm's present cash conversion cycle? Enter your answer rounded to two decimal places. For example, if your answer is 123.45% or 1.2345 then enter...
Your consulting firm has been hired by an important European-based multinational conglomerate, ' GKY Group'. The...
Your consulting firm has been hired by an important European-based multinational conglomerate, ' GKY Group'. The Group has required assistance for designing its long term global strategy. The CEO, Mr. Lundberg, is particularly interested in understanding the long term growth potential of the U.S economy. Until now his company has had an aggressive expansion strategy in the U.S. This strategy has been based on a combination of acquisitions of smaller competitions, as well as major investment in expanding the group's...
A company’s year-end balance in accounts receivable is $2,000,000. The allowance for uncollectible accounts had a...
A company’s year-end balance in accounts receivable is $2,000,000. The allowance for uncollectible accounts had a beginning-of-year credit balance of $30,000. An aging of accounts receivable at the end of the year indicates a required allowance of $38,000. If bad debt expense for the year was $40,000 and if credit sales for the year were $8,200,000 and $7,950,000 was collected from credit customers, what was the beginning-of-year balance in accounts receivable?
At the end of the year, Mercy Cosmetics' balance of Allowance for Uncollectible Accounts is $600...
At the end of the year, Mercy Cosmetics' balance of Allowance for Uncollectible Accounts is $600 (debit, before adjustment. The balance of Accounts Receivable is $25,000. The company estimates that 12% of accounts will not be collected over the next year. What is the adjustment Mercy Cosmetics would record for Allowance for Uncollectible Accounts? (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field.) 
At the end of the year, Mercy Cosmetics balance of Allowance for Uncollectible Accounts is $490
Brief Exercise 5-6 Record the adjusting for uncollectible accounts (L05-5) At the end of the year, Mercy Cosmetics balance of Allowance for Uncollectible Accounts is $490 (credid before adjustment. The balance of Accounts Receivable is $19,500. The company estimates that 10% of accounts will not be collected over the next year. What adjustment would Mercy Cosmetics record for Allowance for Uncollectible Accounts? (if no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field.) 
Uncollectible Accounts—Percentage of Sales and Percentage of Receivables At the end of the current year, the...
Uncollectible Accounts—Percentage of Sales and Percentage of Receivables At the end of the current year, the accounts receivable account of Glenn's Nursery Supplies has a debit balance of $390,000. Credit sales are $2,780,000. Record the end-of-period adjusting entry on December 31, in general journal form, for the estimated uncollectible accounts. Assume the following independent conditions existed prior to the adjustment: 1. Allowance for Doubtful Accounts has a credit balance of $1,860. a. The percentage of sales method is used and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT