ACC561 ACC/561 Wiley Week 3 (E 13-4, 13-5, 13-8, 13-9, 13-10,13-13, 13-15)

Brief Exercise 13-4

Using these data from the comparative balance sheet of Rosalez Company, perform horizontal analysis. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 0 decimal places, e.g. 12%.)

Brief Exercise 13-5

Using these data from the comparative balance sheet of Rosalez Company, perform vertical analysis. (Round percentages to 1 decimal place, e.g. 12.5%.)

Brief Exercise 13-8 (Essay)

Vertical analysis (common-size) percentages for Vallejo Company’s sales, cost of goods sold, and expenses are listed here.

Did Vallejo’s net income as a percent of sales increase, decrease, or remain unchanged over the 3-year period? Provide numerical support for your answer.

Brief Exercise 13-9 (Essay)

Horizontal analysis (trend analysis) percentages for Spartan Company’s sales, cost of goods sold, and expenses are listed here.

Explain whether Spartan’s net income increased, decreased, or remained unchanged over the 3-year period.

Brief Exercise 13-10 

These selected condensed data are taken from recent balance sheets of Bob Evans Farms (in thousands).

Brief Exercise 13-13

Staples, Inc. is one of the largest suppliers of office products in the United States. It had net income of $738.7 million and sales of $24,275.5 million in 2009. Its total assets were $13,073.1 million at the beginning of the year and $13,717.3 million at the end of the year. What is Staples, Inc.’s asset turnover ratio and profit margin ratio? (Round answers to 2 decimal places, e.g. 1.25 or 2.05%.)

Brief Exercise 13-15

Selected data taken from a recent year’s financial statements of trading card company Topps Company, Inc. are as follows (in millions).