Excel Project. Accountants should help managers understand trends in revenue cycle activities. One important issue concerns granting credit to customers. Trends in bad debt expense (BDE) to write-offs (WO) provide insights into the accuracy of credit granting policies. It is also important to monitor how long it will take to write off the current balance in the allowance for doubtful accounts (BADA Exhaustion Rate).

REQUIRED

a. Create a spreadsheet that contains the following data:

YEAR 2010 2011 2012 2013 2014 BDE/WO