Excel Project.
REQUIRED
a. Create a spreadsheet that contains the following data:
Year
2010
2011
2012
2013
2014
BDE/WO
1.81
0.98
1.08
1.27
0.94
BADA/WO
1.42
1.73
1.89
1.48
1.26
BADA Exhaustion Rate (years)
1.33
1.81
1.67
1.35
1.2
b. Create a two-dimensional columnar chart that displays the data values for each variable for the five years 2010–2014.
c. Create a new chart that will display a two-dimensional columnar chart that shows a rolling five-year window of the variables. Add the following data for 2015 and 2016 to your spreadsheet to demonstrate that the new chart shows only 2012–2016 values:
Year
2015
2016
BDE/WO
1.1
1.3
BADA/WO
1.3
1.1
BADA Exhaustion Rate (years)
1.5
1.6
(Hint: Read the article “Simplify Your Future with Rolling Charts,” by James A. Weisel in the July 2012 issue of the Journal of Accountancy for an explanation of the how to create a rolling chart (step c)—and take care to follow Excel’s rules for naming ranges. Read the article “Assessing the Allowance for Doubtful Accounts: Using historical data to evaluate the estimation process,” by Mark E. Riley and William R. Pasewark in the September 2009 issue of the Journal of Accountancy for an explanation of how the variables used in this problem can help you evaluate a company’s process for estimating the allowance for doubtful accounts. The Journal of Accountancy is available either in print or online at www.aicpa.org.)*
* Life-long learning opportunity: see p. xxii in preface.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.