Reference no: EM132617168

Question - Preparing an Aging Schedule

M. Beall Inc. uses the aging method to estimate the company's bad debt expense. Mike Beall, the president of the company, collected information about the company's outstanding accounts receivable and their probability of collection:

Account Age Amount Probability of Non-Collection

0-30 days $750,000 0.5%

31-60 days 275,000 1.5%

61-90 days 170,000 2.5%

91-120 days 100,000 4.0%

Over 120 days 40,000 20.0%

Required -

a. Calculate the expected bad debt expense for M. Beall, Inc. Round to the nearest whole number.

b. Calculate the total balance in accounts receivable.

c. Calculate the net realizable value of the company's accounts receivable.