Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have worked the Vertical Analysis, Horizontal Analysis, Liquidity Ratio, Solvency Ratio and Profitability Ratio for the company Gartner, Inc based on the companies website
I have worked the Vertical Analysis, Horizontal Analysis, Liquidity Ratio, Solvency Ratio and Profitability Ratio for the company Gartner, Inc based on the companies website http://www.gartner.com/ and financial statements. The work is attached and would like it to doubled checked for errors and corrected. Please let me know if you need further information. Thank you!
Revenue Cost of services Gross Profit Selling, general, and administrative expense (combined on the financial sheets) Costs and Expenses Net Income 2012 Amount Percentage $1,615,808,000.00 100% $659,067,000.00 41% $956,741,000.00 59% $678,800,000.00 $1,370,101,000.00 $165,903,000.00 42% 85% 10% 2011 Revenue Cost of services Gross Profit Selling, general, and administrative expense (combined on the financial sheets) Costs and Expenses Net Income Revenue Cost of services Gross Profit Selling, general, and administrative expense (combined on the financial sheets) Costs and Expenses Net Income Amount Percentage $1,468,588,000.00 100% $608,800,000.00 41% $859,788,000.00 59% $613,700,000.00 $1,254,526,000.00 $136,902,000.00 42% 85% 9% 2010 Amount Percentage $1,288,454,000.00 100% $552,200,000.00 43% $736,254,000.00 57% $543,200,000.00 $1,139,189,000.00 $96,285,000.00 42% 88% 7% 2009 Revenue Cost of services Gross Profit Selling, general, and administrative expense (combined on the financial sheets) Costs and Expenses Net Income Revenue Cost of services Gross Profit Selling, general, and administrative expense (combined on the financial sheets) Costs and Expenses Net Income Amount Percentage $1,139,800,000.00 100% $498,363,000.00 44% $641,437,000.00 56% $477,003,000.00 $1,005,323,000.00 $82,964,000.00 42% 88% 7% 2008 Amount Percentage $1,279,065,000.00 100% $554,800,000.00 43% $724,265,000.00 57% $532,400,000.00 $1,114,697,000.00 $103,871,000.00 42% 87% 8% 2012 Amount 2011 Amount Change in Dollars Percent Change 2012 2011 Difference Percentage Sales $1,615,808,000.00 $1,468,588,000.00 $147,220,000.00 9% Cost of Sales $659,067,000.00 $608,800,000.00 $50,267,000.00 8% Gross Profit $956,741,000.00 $859,788,000.00 $96,953,000.00 10% Selling, general, and administrative $678,800,000.00 $613,700,000.00 $65,100,000.00 expense (combined on the financial sheets) 10% Costs and Expenses $1,370,101,000.00 $1,254,526,000.00 $115,575,000.00 8% Net Income $165,903,000.00 $136,902,000.00 $29,001,000.00 17% 2011 Amount 2010 Amount Change in Dollars Percent Change 2011 2010 Difference Percentage Sales $1,468,588,000.00 $1,288,454,000.00 $180,134,000.00 12% Cost of Sales $608,800,000.00 $552,200,000.00 $56,600,000.00 9% Gross Profit $859,788,000.00 $736,254,000.00 $123,534,000.00 14% Selling, general, and administrative $613,700,000.00 $543,200,000.00 $70,500,000.00 expense (combined on the financial 11% sheets) Costs and Expenses $1,254,526,000.00 $1,139,189,000.00 $115,337,000.00 9% Net Income $136,902,000.00 $96,285,000.00 $40,617,000.00 30% 2010 Amount 2009 Amount Change in Dollars Percent Change 2010 2009 Difference Percentage Sales $1,288,454,000.00 $1,139,800,000.00 $148,654,000.00 12% Cost of Sales $552,200,000.00 $498,363,000.00 $53,837,000.00 10% Gross Profit $736,254,000.00 $641,437,000.00 $94,817,000.00 13% Selling, general, and administrative $543,200,000.00 $477,003,000.00 $66,197,000.00 expense (combined on the financial 12% sheets) Costs and Expenses $1,139,189,000.00 $1,005,323,000.00 $133,866,000.00 12% Net Income $96,285,000.00 $82,964,000.00 $13,321,000.00 14% 2009 Amount 2008 Amount Change in Dollars Percent Change 2009 2008 Difference Percentage Sales $1,139,800,000.00 $1,279,065,000.00 $(139,265,000.00) -12% Cost of Sales $498,363,000.00 $554,800,000.00 $(56,437,000.00) -11% Gross Profit $641,437,000.00 $724,265,000.00 $(82,828,000.00) -13% Selling, general, and administrative $477,003,000.00 $532,400,000.00 $(55,397,000.00) expense (combined on the financial -12% sheets) Costs and Expenses $1,005,323,000.00 $1,114,697,000.00 $(109,374,000.00) -11% Net Income $82,964,000.00 $103,871,000.00 $(20,907,000.00) -25% 2008 Amount 2007 Amount Change in Dollars Percent Change 2008 2007 Difference Percentage Sales $1,279,065,000.00 $1,189,198,000.00 $89,867,000.00 7% Cost of Sales $554,800,000.00 $545,300,000.00 $9,500,000.00 2% Gross Profit $724,265,000.00 $643,898,000.00 $80,367,000.00 11% Selling, general, and administrative $532,400,000.00 $475,300,000.00 $57,100,000.00 expense (combined on the financial 11% sheets) Costs and Expenses $1,114,697,000.00 $1,056,076,000.00 $58,621,000.00 5% Net Income $103,871,000.00 $73,553,000.00 $30,318,000.00 29% Current Assets Current Liabilities Current Ratio 2012 $927,466,000.00 $1,070,000,000.00 87% 2011 $142,739,000.00 $921,137,000.00 15% 2010 $120,181,000.00 $811,152,000.00 15% 2009 $116,574,000.00 $898,173,000.00 13% $299,852,000.00 $287,763,000.00 $587,615,000.00 55% $142,739,000.00 $259,490,000.00 $402,229,000.00 44% $120,181,000.00 $364,818,000.00 $484,999,000.00 60% $116,574,000.00 $317,598,000.00 $434,172,000.00 48% 2009 $140,929,000.00 $792,409,000.00 18% S Cash Accounts Receiveable Total Quick Ratio $140,929,000.00 $318,511,000.00 $459,440,000.00 58% 2012 $1,314,604,000.00 $1,621,277,000.00 81% 2011 $1,198,088,000.00 $1,399,872,000.00 86% 2010 $1,098,602,000.00 $1,285,658,000.00 85% 2009 $1,102,744,000.00 $1,215,279,000.00 91% 2008 $1,114,381,000.00 $1,093,065,000.00 102% Cash provided by operation Average current liabilites (over 2 years) Money to cover debt $279,813,000.00 $995,568,500.00 28% $255,566,000.00 $866,144,500.00 30% $205,499,000.00 $854,662,500.00 24% $161,937,000.00 $845,291,000.00 19% $184,350,000.00 $834,210,500.00 22% Capital Expenditures Cash Dividends Cash provided by operations Free Cash Flow $44,300,000.00 $$279,813,000.00 $235,513,000.00 $42,000,000.00 $$255,566,000.00 $213,566,000.00 $21,700,000.00 $$205,499,000.00 $183,799,000.00 $15,100,000.00 $$161,937,000.00 $146,837,000.00 $24,300,000.00 $$184,350,000.00 $160,050,000.00 Net income Interest Expense Tax expenses Total Times interest earned ratio $165,903,000.00 $8,859,000.00 $69,693,000.00 $244,455,000.00 2759% $136,902,000.00 $9,967,000.00 $65,282,000.00 $212,151,000.00 2129% $96,285,000.00 $15,616,000.00 $37,800,000.00 $149,701,000.00 959% $82,964,000.00 $16,032,000.00 $32,562,000.00 $131,558,000.00 821% $103,871,000.00 $19,269,000.00 $48,215,000.00 $171,355,000.00 889% Cash provided by operations Capital Expenditures Capital Expenditure ratio $279,813,000.00 $44,300,000.00 632% $255,566,000.00 $42,000,000.00 608% $205,499,000.00 $21,700,000.00 947% $161,937,000.00 $15,100,000.00 1072% $184,350,000.00 $24,300,000.00 759% Total Liabilities Total Assets debt to total assets ratio Net Income After Taxes Net Sales Profit Ratio 2012 $235,596,000.00 $1,615,808,000.00 15% 2011 $202,184,000.00 $1,468,588,000.00 14% 2010 $134,085,000.00 $1,288,454,000.00 10% 2009 $115,526,000.00 $1,139,800,000.00 10% 2008 $144,741,000.00 $1,279,065,000.00 11%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started