Question

In: Accounting

Reformulating Allowance for Doubtful Accounts and Bad Debt Expense Merck & Company reported the following from...

Reformulating Allowance for Doubtful Accounts and Bad Debt Expense

Merck & Company reported the following from its 2016 financial statements.

$ millions 2013 2014 2015 2016

Accounts receivable, net $7,185 $6,627 $6,485 $7,017

Allowance for doubtful accounts 153 160 172 201

a. Compute accounts receivable gross for each year.

$ millions 2013 2014 2015 2016

Accounts receivable, gross $Answer 7,338 $Answer 6,787 $Answer 6,657 $Answer 7,218

b. Determine the percentage of allowance to gross account receivables for each year.

Round answers to two decimal places (ex: 0.02345 = 2.35%).

2013 2014 2015 2016

% allowance Answer 2.09 % Answer 2.36 % Answer 2.58 % Answer 2.78 %

c. Assume that we want to reformulate the balance sheet and income statement to reflect a constant percentage of allowance to gross accounts receivables for each year.

Compute the four-year average and then reformulate the balance sheet and income statements for each of the four years. Follow the process shown in Analyst Adjustments 5.2 and assume a tax rate of 35%. Four- year average of percentage of allowance to gross accounts receivables.

Round answer to two decimal places (ex: 0.02345 = 2.35%) Answer 2.45 %

Reformulate the balance sheet and income statements. Use rounded answer above for computations, then round answers to one decimal place. Use negative signs with answers to indicate the adjustment decreases an account.

2013 2014 2015 2016

Adjusted allowance for doubtful accts. $Answer 179.8 $Answer 166.3 $Answer 163.1 $Answer 176.8

Balance Sheets

Adjustments Allowance for doubtful accounts Answer 26.8 Answer Answer Answer

Accounts receivable, net Answer (26.8) Answer 0 Answer 0 Answer 0 Deferred tax liabilities Answer

Retained Earnings Answer (17.4) Answer 0 Answer 0 Answer 0

Income Statements Adjustments

Bad debts expense Answer 26.8 Answer 0 Answer 0 Answer 0

Income tax expense at 35% Answer (9.4) Answer 0 Answer 0 Answer 0

Net Income Answer 17.4 Answer 0 Answer 0 Answer 0

Solutions

Expert Solution


Related Solutions

Reformulating Allowance for Doubtful Accounts and Bad Debt Expense Merck & Company reported the following from...
Reformulating Allowance for Doubtful Accounts and Bad Debt Expense Merck & Company reported the following from its 2016 financial statements. $ millions 2013 2014 2015 2016 Accounts receivable, net $7,666 $7,105 $6,965 $7,499 Allowance for doubtful accounts 170 179 191 225 a. Compute accounts receivable gross for each year. $ millions 2013 2014 2015 2016 Accounts receivable, gross $Answer $Answer $Answer $Answer b. Determine the percentage of allowance to gross account receivables for each year. Round answers to two decimal...
Question text Reformulating Allowance for Doubtful Accounts and Bad Debt Expense Merck & Company reported the...
Question text Reformulating Allowance for Doubtful Accounts and Bad Debt Expense Merck & Company reported the following from its 2016 financial statements. $ millions 2013 2014 2015 2016 Accounts receivable, net $7,189 $6,631 $6,489 $7,019 Allowance for doubtful accounts 149 156 168 199 a. Compute accounts receivable gross for each year. $ millions 2013 2014 2015 2016 Accounts receivable, gross $Answer Correct The correct answer is: 7338 Mark 1.00 out of 1.00 $Answer Correct The correct answer is: 6787 Mark...
Martin MFG company uses balance sheet approach to calculate allowance for doubtful accounts and bad debt...
Martin MFG company uses balance sheet approach to calculate allowance for doubtful accounts and bad debt expense. Current policy is to reserve 20% gross accounts receivable as an allowance for uncollectible accounts. Martin MFG company issued 10% stated rate bonds in 2020. Effective market rate of interest for these bonds is 8%. Select all statements that are true regarding the information above. Ignore taxes and any cost of goods sold. Reducing the percentage of gross accounts receivable reserved in the...
Ervin Company uses the allowance method to account for uncollectible accounts receivable. Bad debt expense is...
Ervin Company uses the allowance method to account for uncollectible accounts receivable. Bad debt expense is established as a percentage of credit sales. For 2021, net credit sales totaled $5,400,000, and the estimated bad debt percentage is 1.50%. No previously written-off accounts receivable were reinstated during 2021. The allowance for uncollectible accounts had a credit balance of $51,000 at the beginning of 2021 and $44,500, after adjusting entries, at the end of 2021. Required: 1. What is bad debt expense for 2021...
ABC Company reported accounts receivable of $225,000 and an allowance for doubtful accounts with a $28,000...
ABC Company reported accounts receivable of $225,000 and an allowance for doubtful accounts with a $28,000 credit balance on January 1, 2017. ABC Company records bad debt expense using the net credit sales method. The following information was available for ABC Company for the years 2017 and 2018: 2017 2018 Cash collections from customers ? 275,870 Recoveries 3,600 6,760 Net realizable value at December 31 127,180 154,240 Accounts receivable turnover ratio 2.4 1.80 Sales revenue 468,000 ? % of sales...
Mel's Hardware uses the allowance method to determine their bad debt expense. The allowance for bad...
Mel's Hardware uses the allowance method to determine their bad debt expense. The allowance for bad debts is based on the balance in the accounts receivable account. Mel's hardware uses the rate of 0.75% of accounts receivable to determine the appropriate balance in the allowance for doubtful accounts. The data collected from Mel's Hardware is as follows. A/R: $49,477.00 Allowance for doubtful accounts: debit $350.00 Credit sales: $144,554.00 Bad Debt Expense: -0-
Prepare the year-end adjusting entry to record bad debts expense under the assumption that the Allowance for Doubtful Accounts has
Mazie Supply Co. uses the percent of accounts receivable method. On December 31, it has outstanding accounts receivable of $148,000, and it estimates that 5% will be uncollectible. Prepare the year-end adjusting entry to record bad debts expense under the assumption that the Allowance for Doubtful Accounts has: (a) a $2,516 credit balance before the adjustment. (b) a $740 debit balance before the adjustment. 
if you have an allowance for doubtful accounts for 100 that you asign an expense to...
if you have an allowance for doubtful accounts for 100 that you asign an expense to at the beginning of the year also for 100 (Bad Debt Expense), what happens with expenses if you made a wrong calculation? supposedly you already debited Bad Debt Expense for 100, can you increase it if write offs amount to more than 100 over the year ? What is the whole process ?
The balance in Allowance for Doubtful Accounts will directly impact the end-of-period adjustment for the bad...
The balance in Allowance for Doubtful Accounts will directly impact the end-of-period adjustment for the bad debt expense when using which of the following methods? direct write-off method allowance method based on aging the receivables accrual method declining value method Indications that an account may be uncollectible include all of the following except the customer files for bankruptcy the customer is making small but regular payments the customer closes its business the customer cannot be located The operating expense recorded...
Entries for bad debt expense under the direct write-off and allowance methods Instructions Chart of Accounts...
Entries for bad debt expense under the direct write-off and allowance methods Instructions Chart of Accounts Journal Final Question Instructions Seaforth International wrote off the following accounts receivable as uncollectible for the year ending December 31: Customer Amount Kim Abel $ 24,300 Lee Drake 31,195 Jenny Green 29,715 Mike Lamb 17,890 Total $103,100 The company prepared the following aging schedule for its accounts receivable on December 31: Aging Class (Number of Days Past Due) Receivables Balance on December 31 Estimated...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT