plot the average debt ratios for all firms over time. Plot average debt ratios ( in the
No answer yet for this question.
Ask a Tutor
Question:
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 ?which is ?do these responsible firms use lessdebt less resources constrained ?or more debtmore resource constrained ?Why do you thinkthat these highly responsible firms are moreless resourceconstrained?
Transcribed Image Text:
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 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
Expert Answer:
Related Book For
Foundations of Financial Management
ISBN: 978-1259024979
10th Canadian edition
Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen, Doug Short, Michael Perretta
Posted Date:
Students also viewed these finance questions
-
What has been the evolution of direct involvement of family and friends in funeral arrangements? How has the role and expectations of the contemporary funeral director changed over time?
-
Financial statements for the ACTACTSTAT Company are given below: During 2021 the firm declared and paid cash dividends of P85,000. There were 50,000 shares of common stock outstanding throughout the...
-
Northwest Utility Corporation has a cost of capital of 11.5 percent, and it has a project with the following net cash flows: YEAR NET CASH FLOW 0 .......................................- $200 1...
-
One histogram shows the distribution of ages of all 638 used cars for sale in the Ventura County Star Sunday newspaper in 2013. The other three graphs show distributions of means from random samples...
-
Are the input specifiers for scanf() identical to the output specifiers for printf()?
-
On December 1, Tim Walker began an auto repair shop, Walkers Quality Automotive. The following transactions occurred during December: Dec. 1 Walker contributed $ 48,000 cash to the business in...
-
Describe issues of healthcare provision during economic downturns. Consider some of the ethical issues presented by government financing. Explain with at least three hundred words
-
You and your fellow team members are to assume that you have been assigned to the 2023 audit of Qantas Airways Limited. You have been asked by the audit partner, as preparation for your involvement...
-
What best practices could be instituted to manage HIPAA compliance while aligning with the organization's mission and ethical standards?
-
think about an organizational improvement initiative that you would like to make in an organization of your choice. This initiative might focus on improved profitability, better customer service, new...
-
in Pavan Sukhdev's video "Put Value on Nature", he calls for change in our accounting systems to truly account for the costs of production. Do you think this is realistic? What value would obtain...
-
An employee is given a $10,000 interest free loan from an employer on January 1 to purchase an automobile to be used for employment purposes. Due to a serious illness, the automobile is only used for...
-
Ally, the manager of a disability services agency in regional Queensland, is a qualified social worker with 10 years of managerial experience. The agency she manages provides accommodation and...
-
25% of employed women have never lived alone. In a random sample of 40 employed women, what is the probability that 5 or fewer have never been lived alone? A. 44.95% B. 5.05% C. 94.95% D. 4.35% Each...
-
Express mass density in kg/m3 and weight density in lb/ft3. 1. Find the mass density of a chunk of rock of mass 215 g that displaces a volume of 75.0 cm3 of water. 2. A block of wood is 55.9 in. x...
-
The Prince Albert Corporation has forecast the following sales for the first seven months of the year. Monthly material purchases are set equal to 30 percent of forecasted sales for the next month....
-
You are interested in receiving a true yield on a government bond investment of 8 percent. Your broker suggests a 20-year issue with 12 years to maturity, an original coupon rate of 10 percent,...
-
Suggest two forms of daily functions and two forms of occasional functions that the financial manager performs.
-
The system in Fig.12.21 consists of a homogeneous disk of mass \(M=300 \mathrm{~g}\) and radius \(R=40.0 \mathrm{~cm}\). At the disk, a slit has been produced along the entire length \(R\) of the...
-
Determine the energy flux on Earth from the Sun, which is \(150 \times 10^{6} \mathrm{~km}\) away, using (13.12). Taking into account that a photovoltaic panel can have an efficiency of \(20 \%\),...
-
Show that if you have a mass \(M\) distributed of on a spherical shell, that is, on a sphere of radius \(R\) hollow inside, and a point mass \(m\) at a distance \(h\) from the sphere, the...
Study smarter with the SolutionInn App