12.5 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: Call the spreadsheet Part A b. Create Totals for the 5 years 2015-2019 c. Identify which has the highest BDE or BADA on average for the 5 years. Show each year averages. d. Prepare a forecast for 202019 of 5% for BDE/WO 10% BADA/WO and 8% BADA Exhaustion rate