1. Create a pivot table to summarize the long-term portion of the (a) capital lease liability, (b) the finance lease liability, and (c) the operating lease liability over the 10-year period 2012-2021 on a separate worksheet. Label the worksheet LeaseLiability.
2. On the Lease Liability worksheet create a bar chart of the trends for long-term portion of each lease liability classification over the 10-year period classification. Is Fishbone pattern of leasing facilities as evidenced by its capital lease liability (a) increasing, (b) decreasing, or (c) remaining relatively the same of the period 2012-2021. Place your answer in the cell below the bar chart.
3. Create a pivot table to summarize the total assets, total liabilities, and total stockholders equity over the 10-year period 2012-2021 (Hint: Need to calculate total liabilities and total stockholders equity for each year) on a separate worksheet. Add calculated field to calculate the debt to equity ratio for the company (carried two decimal places) over the 10-year period 2012-2021. Label the worksheet DebtToEquity.
4. On the DebtToEquity worksheet display the trend of the debt to equity ratio over the 10-year period 2012-2021 using a bar chart with line graph. Is Fishbones debt to equity ratio over the 10-year period (a) generally increasing, (b) roughly the same, or (c) generally decreasing from year to year? Place your answer in the cell below the bar chart.
5. Is Fishbone Corp. technically in violation of its debt covenant during the period

2019-2021? Place your answer in cell below your response to #4.

6. The worksheets should be formatted with appropriate numeric values using accounting format with zero decimals unless indicated otherwise.