2. Compute the ratio of accumulated depreciation to gross property and equipment for each year. Assume all assets are depreciable.3. Prepare the following three charts in Excel.•Chart 1: A bar chart showing accumulated depreciation and gross property and equipment per year over the 10-year period.•Chart 2: A line chart showing property and equipment additions over the 10-year period, with the earliest year on the left hand side. Hint: To reverse the order of the years, right-click inside the horizontal axis. A Format Axis sidebar will appear. Open the bar chart icon tab. Click Categories in reverse order under Axis options.•
Chart 3: A line chart showing the ratio of accumulated depreciation to gross property and equipment over the 10-year period
. Chart 3: A line chart showing the ratio of accumulated depreciation to gross property and equipment over the 10-year period
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
