Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

table [ [ Year , table [ [ Total Outstanding ] , [ Receivables ] ] , table [ [ Percent of

image text in transcribed
\table[[Year,\table[[Total Outstanding],[Receivables]],\table[[Percent of sales on],[account written off]],Percent of outstanding receivables written off by receivale age group],[,,,0-30,31-60,61-90,over 90],[2013,\table[[$],[33,584,855]],1.65%,0.00%,1.92%,3.26%,6.73%],[2014,\table[[$],[37,040,513]],3.37%,0.02%,0.00%,5.31%,14.86%],[2015,\table[[$],[34,048,875]],3.11%,0.02%,3.17%,4.67%,13.15%],[2016,\table[[$],[40,884,402]],1.57%,0.00%,0.00%,4.38%,5.95%],[2017,\table[[$],[40,902,344]],2.03%,0.01%,2.58%,4.30%,6.11%],[2018(predicted),\table[[$],[40,857,493]],2.34%,0.01%,1.53%,4.39%,9.36%]]
Based on your recommendation, calculate the amount of bad debt expense you should report for 2018. Assume beginning balance of Allowance for Doubtful Accounts is zero in 2018.
Your recommendations and the reasoning behind them - should you use percent of credit sales or aging of receivables? (Some questions you may want to consider are: is the aging method the right choice for the company given the historical data? Should all the years be included in the analysis? Should you use mean or median to calculate the percentages? Are there any extreme observations that should not be included in the analysis? Do the number of customers matter in a given year? Does the balance of total receivables vary significantly and what you conclude given these differences?)
Based on your recommendation, calculate the amount of bad debt expense you should report for 2018. Assume beginning balance of Allowance for Uncollectible Accounts is zero in 2018(Provide the analysis of the credit sales or outstanding receivables in each aging category for 2018 that led you to this number in the table above).
Anything else you would like to share with your CFO (can you think of different data you might be able to use to get a better sense of the write-offs)?
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Survey of Accounting

Authors: Thomas P. Edmonds, Frances M. McNair, Philip R. Olds, Bor Yi

3rd Edition

978-1259683794, 77490835, 1259683796, 9780077490836, 978-0078110856

Students also viewed these Accounting questions