Financial Statement Case 17-1 Requirements: Please note for this assignment you must use spreadsheet software (Excel, Google Shots, etc) 1. Compute trend analyses for Sales and it earnings / (los). Uue 2013 as the base year. What is the most notable aspect of these dat? 2 Perform a vertical analysis for Target Corporations balance sheet as of January 31, 2016 fiscal year 2015), and January 31, 2015 year 2014 Include only these main categories Assets Total current assets Property and equipment.net Noncurrent assets of discontinued operations Other noncurrent assets Total assets Libilities and shareholders investment: Total current liabilities Total noncurrent liabilities Total shareholders Investment Totalities and shareholders investment 2016 2015 (millions, except footnotes) Assets Cosh and cash equivalents, including short-term investments of $3.008 and $1.520 4,046 $ 2.210 Inventory 8,601 8,282 Assets of discontinued operations 322 1,058 Other current assets 1,161 2,074 Total current assets 14,130 13,624 Property and equipment Land 6,125 6,127 Buildings and improvements 27,059 26,613 Fixtures and equipment 5,347 5,329 Computer hardware and software 2,617 2,552 Construction-in-progress 315 424 Accumulated depreciation (16,246) (15,093) Property and equipment, net 25,217 25,952 Noncurrent assets of discontinued operations 75 717 Other noncurrent assets 840 879 Total assets 40,262 $ 41,172 Liabilities and shareholders' investment Accounts payable 7,418 $ 7,759 Accrued and other current liabilities 4,236 3,783 Current portion of long-term debt and other borrowings 815 91 Liabilities of discontinued operations 153 103 Total current liabilities 12,622 11.736 Long-term debt and other borrowings 11,945 12,634 Deferred income taxes W 823 1,160 Noncurrent liabilities of discontinued operations 18 193 Other noncurrent liabilities 1,897 1,452 Total noncurrent liabilities 14,683 15,439 Shareholders' investment Common stock 50 53 Additional paid-in capital 5,348 4,899 Retained earnings 8,188 9,644 Accumulated other comprehensive loss Pension and other benefit liabilities (588) (561) Currency translation adjustment and cash flow hedges (41) (38) Total shareholders' Investment 12.957 Total liabilities and shareholders' investment 13,997 S 40,262 $ 41.172 Common Stock Authod 5.000.000.000 shares, 30 Spar valu, 62.226,517 shrindandoutstanding at January 30, 2016,640.213,87 war and outstanding Jacary 11 2015 Financial Statement Case 17-1 Requirements: Please note for this assignment you must use spreadsheet software (Excel, Google Shots, etc) 1. Compute trend analyses for Sales and it earnings / (los). Uue 2013 as the base year. What is the most notable aspect of these dat? 2 Perform a vertical analysis for Target Corporations balance sheet as of January 31, 2016 fiscal year 2015), and January 31, 2015 year 2014 Include only these main categories Assets Total current assets Property and equipment.net Noncurrent assets of discontinued operations Other noncurrent assets Total assets Libilities and shareholders investment: Total current liabilities Total noncurrent liabilities Total shareholders Investment Totalities and shareholders investment 2016 2015 (millions, except footnotes) Assets Cosh and cash equivalents, including short-term investments of $3.008 and $1.520 4,046 $ 2.210 Inventory 8,601 8,282 Assets of discontinued operations 322 1,058 Other current assets 1,161 2,074 Total current assets 14,130 13,624 Property and equipment Land 6,125 6,127 Buildings and improvements 27,059 26,613 Fixtures and equipment 5,347 5,329 Computer hardware and software 2,617 2,552 Construction-in-progress 315 424 Accumulated depreciation (16,246) (15,093) Property and equipment, net 25,217 25,952 Noncurrent assets of discontinued operations 75 717 Other noncurrent assets 840 879 Total assets 40,262 $ 41,172 Liabilities and shareholders' investment Accounts payable 7,418 $ 7,759 Accrued and other current liabilities 4,236 3,783 Current portion of long-term debt and other borrowings 815 91 Liabilities of discontinued operations 153 103 Total current liabilities 12,622 11.736 Long-term debt and other borrowings 11,945 12,634 Deferred income taxes W 823 1,160 Noncurrent liabilities of discontinued operations 18 193 Other noncurrent liabilities 1,897 1,452 Total noncurrent liabilities 14,683 15,439 Shareholders' investment Common stock 50 53 Additional paid-in capital 5,348 4,899 Retained earnings 8,188 9,644 Accumulated other comprehensive loss Pension and other benefit liabilities (588) (561) Currency translation adjustment and cash flow hedges (41) (38) Total shareholders' Investment 12.957 Total liabilities and shareholders' investment 13,997 S 40,262 $ 41.172 Common Stock Authod 5.000.000.000 shares, 30 Spar valu, 62.226,517 shrindandoutstanding at January 30, 2016,640.213,87 war and outstanding Jacary 11 2015