Question: plot the average debt ratios for all firms over time. Plot average debt ratios ( in the lastrow of the table ) ?on Y axis

plot the average debt ratios for all firms over time. Plot average debt ratios (in the lastrow of the table) ?on Y axis and year on X axis. Compared to the average debt ratio for SP 500 ?which is 0.6, ?do these responsible firms use lessdebt (less resources constrained) ?or more debt(more resource constrained) ? ?Why do you thinkthat these highly responsible firms are more/less resource-constrained?
Average of Debt Ratio Column Labels Row Labels 2009 2010 2011 2012

Average of Debt Ratio Column Labels Row Labels 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 (blank) Grand Total ABBOTT LABORATORIES 0.62 0.59 0.60 0.41 0.48 0.48 0.61 0.59 0.54 0.54 0.55 ADVANCED MICRO DEVICES 0.80 0.68 0.87 0.87 0.95 1.13 0.87 0.83 0.72 0.53 0.83 ANALOG DEVICES INC 0.26 0.28 0.26 0.26 0.31 0.28 0.35 0.52 0.46 0.45 0.34 APPLIED MATERIALS INC 0.31 0.37 0.40 0.41 0.40 0.50 0.51 0.52 0.62 0.57 0.46 APTARGROUP INC 0.37 0.40 0.41 0.41 0.55 0.53 0.55 0.58 0.58 0.56 0.49 AVIENT CORP 0.69 0.72 0.70 0.67 0.71 0.73 0.73 0.78 0.80 0.68 0.72 BERRY GLOBAL GROUP INC 1.02 1.09 1.09 1.04 1.02 1.01 0.97 0.88 0.84 0.90 0.99 BOSTON PROPERTIES INC 0.62 0.63 0.62 0.64 0.60 0.57 0.58 0.58 0.59 0.62 0.61 BROADCOM INC 0.30 0.18 0.15 0.15 0.69 0.55 0.56 0.57 0.47 0.63 0.43 CAMPBELL SOUP CO 0.85 0.84 0.86 0.85 0.80 0.83 0.80 0.79 0.91 0.92 0.85 CISCO SYSTEMS INC CLOROX CO/DE COMERICA INC CORTEVA INC CUMMINS INC DISNEY (WALT) CO 0.45 0.46 0.44 0.42 0.46 0.47 0.48 0.49 0.60 0.66 0.49 0.98 1.02 1.03 0.97 0.96 0.97 0.93 0.88 0.86 0.89 0.95 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.90 0.89 #DIV/0! #DIV/0! 0.34 0.31 0.42 #DIV/0! 0.35 0.52 0.50 0.44 0.47 0.49 0.49 0.52 0.55 0.57 0.57 0.51 0.43 0.45 0.44 0.41 0.43 0.45 0.49 0.52 0.45 0.47 0.45 ECOLAB INC EDGEWELL PERSONAL CARE CO ESTEE LAUDER COMPANIES INC EVERSOURCE ENERGY GENERAL MILLS INC HELMERICH & PAYNE HEWLETT PACKARD ENTERPRISE HNI CORP ILLUMINA INC 0.56 0.69 0.65 0.62 0.62 0.63 0.62 0.61 0.60 0.58 0.62 0.67 0.68 0.69 0.63 0.64 0.63 0.62 0.58 0.56 0.62 0.63 0.63 0.58 0.58 0.54 0.51 0.56 0.61 0.62 0.63 0.66 0.59 0.73 0.74 0.67 0.65 0.66 0.66 0.66 0.69 0.70 0.69 0.68 0.68 0.65 0.63 0.64 0.65 0.72 0.72 0.74 0.76 0.74 0.69 0.34 0.35 0.33 0.29 0.27 0.32 0.33 0.35 0.29 0.31 0.32 0.44 0.43 0.58 0.60 0.62 0.62 0.67 0.57 0.59 0.60 0.61 0.62 0.67 0.62 0.62 0.63 0.60 0.60 0.62 0.35 0.51 0.49 0.49 0.56 0.49 0.46 0.44 0.44 0.37 0.46 INTEL CORP 0.22 0.35 0.39 0.37 0.38 0.40 0.41 0.43 0.41 0.43 0.38 IRON MOUNTAIN INC 0.69 0.79 0.82 0.84 0.87 0.92 0.79 0.78 0.83 0.89 0.82 JACOBS SOLUTIONS INC 0.39 0.45 0.45 0.42 0.47 0.44 0.41 0.39 0.53 0.50 0.44 KEYSIGHT TECHNOLOGIES INC 0.39 0.39 0.75 0.63 0.60 0.61 0.58 0.55 0.56 LEAR CORP 0.61 0.63 0.56 0.62 0.67 0.68 0.68 0.63 0.61 0.64 0.63 LUMENTUM HOLDINGS INC 0.31 0.32 0.26 0.27 0.47 0.39 0.45 0.35 MASTERCARD INC 0.00 0.00 0.00 0.47 0.55 0.63 0.70 0.74 0.78 0.80 0.47 MAXIM INTEGRATED PRODUCTS 0.32 0.29 0.32 0.36 0.45 0.46 0.50 0.52 0.57 0.51 0.43 MERCK & CO 0.46 0.46 0.48 0.50 0.50 0.56 0.58 0.61 0.67 0.69 0.55 MICROSOFT CORP 0.46 0.47 0.45 0.45 0.48 0.55 0.63 0.70 0.68 0.64 0.55 NEWMONT CORP 0.39 0.43 0.43 0.47 0.47 0.43 0.44 0.43 0.44 0.44 0.44 NVIDIA CORP 0.26 0.29 0.25 0.25 0.39 0.39 0.39 0.41 0.34 0.30 0.30 0.32 OWENS CORNING 0.49 0.50 0.53 0.50 0.51 0.49 0.50 0.51 0.56 0.53 0.51 PAYPAL HOLDINGS INC 0.61 0.62 0.52 0.56 0.61 0.64 0.67 0.61 QUALCOMM INC 0.32 0.26 0.22 0.21 0.19 0.38 0.39 0.53 0.97 0.85 0.43 REGENERON PHARMACEUTICALS 0.52 0.63 0.40 0.34 0.34 0.35 0.36 0.30 0.25 0.25 0.37 S&P GLOBAL INC 0.67 0.75 0.77 0.64 0.80 0.86 0.79 0.78 0.76 0.75 0.76 SENSATA TECHNOLOGES HLDG PLC 0.70 0.70 0.66 0.67 0.75 0.74 0.69 0.65 0.62 0.62 0.68 SUN COMMUNITIES INC 1.11 1.07 0.88 0.80 0.68 0.61 0.59 0.56 0.52 0.49 0.73 TAPESTRY INC 0.39 0.39 0.36 0.32 0.34 0.47 0.45 0.49 0.51 0.49 0.42 TEXAS INSTRUMENTS INC 0.22 0.47 0.45 0.43 0.41 0.39 0.36 0.41 0.48 0.51 0.41 UNITED RENTALS INC 1.01 0.98 0.86 0.84 0.86 0.88 0.86 0.79 0.81 0.80 0.87 VERTEX PHARMACEUTICALS INC 0.71 0.56 0.55 0.42 0.53 0.56 0.54 0.42 0.29 0.27 0.49 WHIRLPOOL CORP 0.72 0.72 0.72 0.68 0.71 0.70 0.70 0.74 0.83 0.78 0.73 XYLEM INC 0.27 0.58 0.56 0.54 0.56 0.55 0.66 0.63 0.61 0.62 0.56 Grand Total 0.47 0.55 0.57 0.55 0.54 0.58 0.59 0.59 0.59 0.60 0.60 #DIV/0! 0.58

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!