Question

Suppose the comparative balance sheets of Windsor, Inc. are presented here. WINDSOR, INC. Condensed Balance Sheet May 31 ($ in millions) 2017 2016 Assets Current Assets Property, plant, and equipment (net) Other assets Total assets Liabilities and Stockholders' Equity Current Liabilities Long-term liabilities Stockholders' equity Total liabilities and stockholders' equity $9,520 $8,720 2,010 1,870 1,610 $13,080 $12,200 1,550 3,210 $3,320 1,210 1,290 7,590 $13,080 $12,200 8,660 (a) Prepare a horizontal analysis of the balance sheet data for Windsor, using 2016 as a base. (if amount and percentage are a decrease show the numbers as negative, e.g.-55,000 -20% or (55,000), (20%). Round percentages to 1 decimal place, e.g. 12.1%.) WINDSOR, INC. Condensed Balance Sheet May 31 ($ in millions) 2017 2016 (Decrease) Change from 2016 $9,520 $8,720 2,010 1,870 1,610 Current Assets Property, plant, and equipment (net) Other assets 1,550 Total assets $13,080$12,200 $ Liabilities and Stockholders' Equity $3,210 $3,320 1,210 1,290 7,590 $13,080 $12,200 Current Liabiiies Long-term liabities Stockholders equity Total liabilities and stockholders' equity 8,660

Answer 1

Answer:

since there is not enough room here, I prepared the comparative balance sheets on an excel spreadsheet.  

Explanation:

WINDSOR, INC.

May 31  2017 2016

($ in millions)

Assets

Current Assets $9,520 $8,720

Property, plant, and equipment (net) $2,010 $1,870

Other assets $1,550 $1,610

Total assets $13,080 $12,200

Liabilities and Stockholders' Equity

Current Liabilities $3,210 $3,320

Long-term liabilities 1,210 1,290

Stockholders' equity 8,660 7,590

Total liabilities and stockholders' equity $13,080 $12,200

Download pdf