Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please calculate the Altman Z-score as of the 2018 balance sheet date. To calculate the market value of equity uses the year-end stock price provided

Please calculate the Altman Z-score as of the 2018 balance sheet date. To calculate the market value of equity uses the year-end stock price provided in the 2nd image. The year-end stock price is 68.97 per share. Does the calculated Z-score suggest a high level of bankruptcy risk? PLEASE ZOOM INTO THE IMAGE IF anything is unclear. The images are clear on my end.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

2. Bankruptcy Risk. Calculate the Altman Z-Score as of the 2018 balance sheet date. To calculate the market value of equity, use the year-end stock price provided in the in-class Target exercise on February 3rd. Does the Z-score suggest a high level of bankruptcy risk? 12. Calculate the market-to-book ratio of the company as of Feb 2, 2019. This is the Feb 2, 2019 market capitalization of the stock divided by the latest book value of shareholders' equity. Target's stock closed at $68.97 per share on the last trading day of the fiscal year, which was Feb 1, 2019. Shane price X share Consolidated Statements of Operations 2017 $ 2018 74,433 $ 923 75,356 53,299 15,723 2,224 4,110 461 (27) 3,676 746 2,930 71.786 928 72,714 51,125 15.140 2,225 4,224 653 (59) 3.630 722 2,908 2016 As Agusted 69,414 857 70,271 49,145 14,217 2,045 4,864 991 (88) 3,961 1.295 2,666 6 2,937 $ 2,914 $ 2,734 (millions, except per share data) Sales Other revenue Total revenue Cost of sales Selling, general and administrative expenses Depreciation and amortization (exclusive of depreciation included in cost of sales) Operating income Net interest expense Net other (income) / expense Earnings from continuing operations before income taxes Provision for Income taxes Net earnings from continuing operations Discontinued operations, net of tax Net earnings Basic earnings per share Continuing operations Discontinued operations Net earnings per share Diluted earnings per share Continuing operations Discontinued operations Net earnings per share Weighted average common shares outstanding Basic Diluted Antidilutive shares Note: Per share amounts may not foot due to rounding. See accompanying Notes to Consolidated Financial Statements. 13 Refer to Note 2 regarding the adoption of new accounting standards for revenue recognition, leases, and pensions. $ $ 5.54 0.01 5.55 5.32 0.01 5.32 4.61 0.12 4.73 $ $ $ 5.50 $ 0.01 5.51 $ 5.29 0.01 5.29 4.55 0.12 $ 4.69 528.6 533.2 546.8 550.3 4.1 577.6 582.5 0.1 Consolidated Statements of Comprehensive Income 2018 2,937 2017 As Adjusted (a) 2,914 2016 As Adjusted (a) 2,734 $ $ (millions) Net earnings Other comprehensive (loss)/income, net of tax Pension and other benefit liabilities, net of tax Currency translation adjustment and cash flow hedges, net of tax Other comprehensive (loss)/income Comprehensive income 2 (52) (6) (58) 2,879 8 2,922 (13) 4 (9) 2,725 $ $ $ See accompanying Notes to Consolidated Financial Statements. (a) Refer to Note 2 regarding the adoption of new accounting standards for revenue recognition, leases, and pensions. Consolidated Statements of Financial Position February 3, 2018 Ae Adivated $ 2.643 8,597 1,300 12,540 6.095 28,131 5,623 2,645 440 (18.398) 24,536 1,884 1,343 40.303 $ February 2, (millions, except footnotes) 2019 Assets Cash and cash equivalents 1,556 Inventory 9,497 Other current assets 1,466 Total current assets 12,519 Property and equipment Land 6,084 Buildings and improvements 29,240 Fixtures and equipment 5,912 Computer hardware and software 2,544 Construction-in-progress 460 Accumulated depreciation (18,687) Property and equipment, net 25,533 Operating lease assets 1,965 Other noncurrent assets 1,273 Total assets 41.290 Liabilities and shareholders' investment Accounts payable 9,761 Accrued and other current liabilities 4,201 Current portion of long-term debt and other borrowings 1,052 Total current liabilities 15,014 Long-term debt and other borrowings 10,223 Noncurrent operating lease liabilities 2,004 Deferred income taxes 972 Other noncurrent liabilities 1,780 Total noncurrent liabilities 14,979 Shareholders' investment Common stock Additional paid-in capital 6,042 Retained earings 6,017 Accumulated other comprehensive loss (805) Total shareholders' investment 11,297 Total liabilities and shareholders' investment 41,290 Common Stock Authorized 6,000,000,000 shares. $0.0833 par value; 517,761,600 shares issued and outstanding at February 2, 2019, 541,681,670 shares issued and outstanding at February 3, 2018 Proforrod Stock Authorized 5,000,000 shares, $0.01 par value; no shares were issued or outstanding at February 2, 2019 or February 3, 2018 See accompanying Notes to Consolidated Financial Statements. $ 8,677 4,094 281 13.052 11, 117 1.924 693 1,866 15.600 5.858 6,495 (747) 11,651 40,303 $ in Refer to Note 2 renarding the adontion of new accounting standards for revenue recognition legges and pensions 2. Bankruptcy Risk. Calculate the Altman Z-Score as of the 2018 balance sheet date. To calculate the market value of equity, use the year-end stock price provided in the in-class Target exercise on February 3rd. Does the Z-score suggest a high level of bankruptcy risk? 12. Calculate the market-to-book ratio of the company as of Feb 2, 2019. This is the Feb 2, 2019 market capitalization of the stock divided by the latest book value of shareholders' equity. Target's stock closed at $68.97 per share on the last trading day of the fiscal year, which was Feb 1, 2019. Shane price X share Consolidated Statements of Operations 2017 $ 2018 74,433 $ 923 75,356 53,299 15,723 2,224 4,110 461 (27) 3,676 746 2,930 71.786 928 72,714 51,125 15.140 2,225 4,224 653 (59) 3.630 722 2,908 2016 As Agusted 69,414 857 70,271 49,145 14,217 2,045 4,864 991 (88) 3,961 1.295 2,666 6 2,937 $ 2,914 $ 2,734 (millions, except per share data) Sales Other revenue Total revenue Cost of sales Selling, general and administrative expenses Depreciation and amortization (exclusive of depreciation included in cost of sales) Operating income Net interest expense Net other (income) / expense Earnings from continuing operations before income taxes Provision for Income taxes Net earnings from continuing operations Discontinued operations, net of tax Net earnings Basic earnings per share Continuing operations Discontinued operations Net earnings per share Diluted earnings per share Continuing operations Discontinued operations Net earnings per share Weighted average common shares outstanding Basic Diluted Antidilutive shares Note: Per share amounts may not foot due to rounding. See accompanying Notes to Consolidated Financial Statements. 13 Refer to Note 2 regarding the adoption of new accounting standards for revenue recognition, leases, and pensions. $ $ 5.54 0.01 5.55 5.32 0.01 5.32 4.61 0.12 4.73 $ $ $ 5.50 $ 0.01 5.51 $ 5.29 0.01 5.29 4.55 0.12 $ 4.69 528.6 533.2 546.8 550.3 4.1 577.6 582.5 0.1 Consolidated Statements of Comprehensive Income 2018 2,937 2017 As Adjusted (a) 2,914 2016 As Adjusted (a) 2,734 $ $ (millions) Net earnings Other comprehensive (loss)/income, net of tax Pension and other benefit liabilities, net of tax Currency translation adjustment and cash flow hedges, net of tax Other comprehensive (loss)/income Comprehensive income 2 (52) (6) (58) 2,879 8 2,922 (13) 4 (9) 2,725 $ $ $ See accompanying Notes to Consolidated Financial Statements. (a) Refer to Note 2 regarding the adoption of new accounting standards for revenue recognition, leases, and pensions. Consolidated Statements of Financial Position February 3, 2018 Ae Adivated $ 2.643 8,597 1,300 12,540 6.095 28,131 5,623 2,645 440 (18.398) 24,536 1,884 1,343 40.303 $ February 2, (millions, except footnotes) 2019 Assets Cash and cash equivalents 1,556 Inventory 9,497 Other current assets 1,466 Total current assets 12,519 Property and equipment Land 6,084 Buildings and improvements 29,240 Fixtures and equipment 5,912 Computer hardware and software 2,544 Construction-in-progress 460 Accumulated depreciation (18,687) Property and equipment, net 25,533 Operating lease assets 1,965 Other noncurrent assets 1,273 Total assets 41.290 Liabilities and shareholders' investment Accounts payable 9,761 Accrued and other current liabilities 4,201 Current portion of long-term debt and other borrowings 1,052 Total current liabilities 15,014 Long-term debt and other borrowings 10,223 Noncurrent operating lease liabilities 2,004 Deferred income taxes 972 Other noncurrent liabilities 1,780 Total noncurrent liabilities 14,979 Shareholders' investment Common stock Additional paid-in capital 6,042 Retained earings 6,017 Accumulated other comprehensive loss (805) Total shareholders' investment 11,297 Total liabilities and shareholders' investment 41,290 Common Stock Authorized 6,000,000,000 shares. $0.0833 par value; 517,761,600 shares issued and outstanding at February 2, 2019, 541,681,670 shares issued and outstanding at February 3, 2018 Proforrod Stock Authorized 5,000,000 shares, $0.01 par value; no shares were issued or outstanding at February 2, 2019 or February 3, 2018 See accompanying Notes to Consolidated Financial Statements. $ 8,677 4,094 281 13.052 11, 117 1.924 693 1,866 15.600 5.858 6,495 (747) 11,651 40,303 $ in Refer to Note 2 renarding the adontion of new accounting standards for revenue recognition legges and pensions

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Guide To Investing In Rental Properties

Authors: Dennis Mulongo

1st Edition

979-8424909191

More Books

Students also viewed these Finance questions