Question

Suppose the comparative balance sheets of Tamarisk, Inc. are presented here.

TAMARISK, INC. Condensed Balance Sheet May 31 ($ in millions)
		2017		2016
Assets
Current Assets		$9,600		$8,830
Property, plant, and equipment (net)		2,000		1,900
Other assets		1,500		1,700
Total assets		$13,100		$12,430
Liabilities and Stockholders' Equity
Current Liabilities		$3,240		$3,320
Long-term liabilities		1,200		1,340
Stockholders’ equity		8,660		7,770
Total liabilities and stockholders' equity		$13,100		$12,430

(a) Prepare a horizontal analysis of the balance sheet data for Tamarisk, 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%.)

TAMARISK, INC. Condensed Balance Sheet May 31 ($ in millions)
		2017		2016		Increase (Decrease)		Percentage Change from 2013
Assets
Current Assets		$9,600		$8,830		$Enter a dollar amount		Enter percentages rounded to 1 decimal place	%
Property, plant, and equipment (net)		2,000		1,900		Enter a dollar amount		Enter percentages rounded to 1 decimal place	%
Other assets		1,500		1,700		Enter a dollar amount		Enter percentages rounded to 1 decimal place	%
Total assets		$13,100		$12,430		$Enter a total amount for this section		Enter percentages rounded to 1 decimal place	%
Liabilities and Stockholders' Equity
Current Liabilities		$3,240		$3,320		$Enter a dollar amount		Enter percentages rounded to 1 decimal place	%
Long-term liabilities		1,200		1,340		Enter a dollar amount		Enter percentages rounded to 1 decimal place	%
Stockholders’ equity		8,660		7,770		Enter a dollar amount		Enter percentages rounded to 1 decimal place	%
Total liabilities and stockholders' equity		$13,100		$12,430		$Enter a total amount for this section		Enter percentages rounded to 1 decimal place	%

(b) Prepare a vertical analysis of the balance sheet data for Tamarisk for 2017.

TAMARISK, INC. Condensed Balance Sheet Choose the accounting periodFor the Year Ended May 31, 2017May 31, 2017For the Month Ended May 31, 2017 May 31, 2017For the Year Ended May 31, 2017For the Month Ended May 31, 2017
		$ (in millions)		Percent
Assets
Current Assets		$9,600		Enter percentages	%
Property, plant, and equipment (net)		2,000		Enter percentages	%
Other assets		1,500		Enter percentages	%
Total assets		$13,100		Enter percentages	%
Liabilities and Stockholders' Equity
Current Liabilities		$3,240		Enter percentages	%
Long-term Liabilities		1,200		Enter percentages	%
Stockholders’ equity		8,660		Enter percentages	%
Total liabilities and stockholders' equity		$13,100		Enter percentages	%

Answer 1

TAMARISK, INC. Condensed Balance sheet May. 31 (S in millions a) Percentage Change Increase 2017 2016 (Decrease) From 2013 Assets Current assets Property, plant & equipment (net) Other assets 9,600 S 8,830 S 2,000 1,900 S 1,500 S 1,700 S 13,100 S 12,430 S 8.7% 5.3% -11.8% 5.4% 770 $ 100 (200) Total assets liabilities and stockholders' Equity Current liabilities Long Term liabilities stockholders' equity Total liabilities and stockholders' equity $ 670 3,240 3,320 S 1,200 S 1,340S 8,660 7,770 $ 13,100 12,430 S (80) (140) -2.4% -10.4% 11.5% 5.4% $ 890 670

TAMARISK, INC Condensed Balance sheets For the Year Ended May 31,2017 b) $ (in millions) Percent Assets 73.3% 15.3% 11.5% Current assets 9,600 2,000 S Property, plant & equipment (net) Other Assets $ $ 1,500 13,100 100.0% Total assets liabilities and stockholders' Equity Current liabilities Long Term liabilities stockholders' equity Total liabilities and stockholders' equity 24.7% 9.2% 66.1% 100.0% $ 3,240 S 1,200 8,660 $ 13,100