Complete assignment in Excel. Please keep it organized and highlight final answers.

P5-3The Kelly Services, Inc., and Subsidiaries balance sheets from its 2010 annual report are presented inExhibit 5-4.

Required

• a.Using the balance sheets, prepare a vertical common-size analysis for 2010 and 2009. Use total assets as a base.
• b.Using the balance sheets, prepare a horizontal common-size analysis for 2010 and 2009. Use 2009 as the base.
• c.Commentonsignificanttrendsthatappearin(a)and(b).

P 5-7

Rapid Retail Comparative Statements of Income
December 31	Increase (Decrease)
(In thousands of dollars)	2011	2010	Dollars	Percent
Net sales	$30,000	$28,000
Cost of goods sold	20,000	19,500
Gross profit	10,000	8,500
Selling, general and
administrative expense	3,000	2,900
Operating income	7,000	5,600
Interest expense	100	80
Income before taxes	6,900	5,520
Income tax expense	2,000	1,600
Net income	$ 4,900	$ 3,920

Required

• a.Complete the increase (decrease) in dollars and percent.
• b.Commentontrends.

Net#2Go to the SEC site (www.sec.gov). Under ?Filings & Forms? click on ?Search for Company Filings.? Click on ?Company or fund, etc.? Under Company Name, enter ?Best Buy Co? (or under Ticker Symbol, enter ?BBT?). Select the 10-K filed April 25, 2011. For the following partial consolidated statements of earnings, compute horizontal and vertical common-size analysis. Use February 28, 2009 as the base in the horizontal common-size analysis. Use revenue for the vertical common-size analysis. Comment on the results.

Consolidated Statements of Earnings
February 26,	February 27,	February 28,
2011	2010	2009
Revenue
Cost of goods sold
Restructuring charges ? cost of goods sold
Gross profit
Selling, general and administrative expenses
Restructuring charges
Goodwill and tradename impairment
Operating income

Also included a copy in Word in case it does not come out properly. The book is Financial Reporting and Analysis 13th ed

Complete assignment in Excel. Please keep it organized and highlight final answers. P 5-3 The Kelly Services, Inc., and Subsidiaries balance sheets from its 2010 annual report are presented in Exhibit 5-4. Required a.Using the balance sheets, prepare a vertical common-size analysis for 2010 and 2009. Use total assets as a base. b.Using the balance sheets, prepare a horizontal common-size analysis for 2010 and 2009. Use 2009 as the base. c.Comment on significant trends that appear in (a) and (b). P 5-7 Rapid Retail Comparative Statements of Income December 31 Increase (Decrease) (In thousands of dollars) 2011 2010 Net sales $30,000 $28,000 Cost of goods sold 20,000 19,500 Gross profit 10,000 8,500 3,000 2,900 Operating income 7,000 5,600 Interest expense 100 80 Income before 6,900 5,520 Selling, general and administrative expense Dollars Percen t taxes Income tax expense 2,000 1,600 Net income $ 4,900 $ 3,920 Required a.Complete the increase (decrease) in dollars and percent. b.Comment on trends. Net#2 Go to the SEC site (www.sec.gov). Under \"Filings & Forms\" click on \"Search for Company Filings.\" Click on \"Company or fund, etc.\" Under Company Name, enter \"Best Buy Co\" (or under Ticker Symbol, enter \"BBT\"). Select the 10-K filed April 25, 2011. For the following partial consolidated statements of earnings, compute horizontal and vertical common-size analysis. Use February 28, 2009 as the base in the horizontal common-size analysis. Use revenue for the vertical commonsize analysis. Comment on the results. Consolidated Statements of Earnings February 26, February 27, February 28, 2011 2010 2009 Revenue Cost of goods sold Restructuring charges cost of goods sold Gross profit Selling, general and administrative expenses Restructuring charges Goodwill and tradename impairment Operating income