For this assignment you will choose to take the role of either a potential investor or creditor and perform a limited ratio analysis of two retail stores; Target and Dollar Tree. Additional details related to requirements are discussed on page two. Other relevant information that will assist you in computing ratios: 1. Since neither company has accounts receivable, you will not be able to compute A/R turnover or average collection period ratios (i.e. all sales must have been for cash). 2. If one of your selected ratios is earnings per share, do not compute the ratio. Instead, use the amounts given for Basic Earnings per Share on each company's Income Statement. 3. If computing Book Value per Share: . for Target, use the weighted average number of shares outstanding reported on its income statement for Basic earnings per share. For Dollar Tree, use 237 (this is presented in millions to be consistent with the other financial statement numbers). . If computing the price earnings or dividend payout ratios: For Target, use a market price of $206.10 per share For Dollar Tree, use a market price of $115.56 . . . If computing the dividend payout and/or dividend yield ratios: For Target, annual dividends are $2.72 Dollar Tree does not pay a dividend. This does not mean you cannot compare the companies on this measure. Some investors prefer dividend paying stocks and some prefer stocks that do not pay a dividend - you can address this in your written comments For Target, do not be confused by their dates. The balance sheet year 2019 and the income statement year 2020 are BOTH related to the date February 1, 2020. Use the most recent numbers (leftmost column) for all computations, for both companies. . . Decide whether you are analyzing these companies as a potential investor or potential creditor, and select EIGHT of the ratios presented in this chapter that you believe would be of interest to an individual in this role. Compute these (SAME) ratios for each of the companies). Additionally- As mentioned above, neither company has A/R so you cannot select the A/T turnover or average collection period ratios. You must use at least one ratio from each of the five categories identified in the text book: Liquidity Asset Management Debt Management Profitability Market Performance Do not count the Inventory Turnover and the Average Sale Period as two separate ratios as they measure the same thing (the first in times per year and the second in number of days) A summary of the ratio categories and ratio formulas is presented on pages 678-679 of the text. Be aware that computations of some ratios might vary slightly from source to source (le, if you were to Google a specific ratio the formula might be slightly different) For this assignment, ALL ratios will be graded using the formulas in the text (regardless of alternate computations you might find elsewhere). You must show your formula for reach ratio computed. . . . . Grading. 1 point per ratio, per company (for the most recent year only), with formula shown, using formulas as presented in the textbook. (16 points) 2 O O Analysis Write a paragraph (no longer than X page) explaining which company you prefer. Your paragraph should include: Whether you are evaluating as a potential investor or creditor. A brief summary of why you chose the specific ratios you did (le, why did you believe these were the most important ratios to evaluate based on the role you have selected). A brief summary of how you arrived at your preference. Do not do a ratio by ratio comparison stating which company performs better on each ratio, but an overall summary, discussing important points that influenced your decision When doing this assignment, your selection of role and ratios and your analysis should be completely your own. While there will logically be some overlap among students with regard to ratios selected, this section is open-ended enough that there should be no notable similarities in writing DO NOT COPY OR PARAPHRASE from the text or from anyone else or the assignment will receive a zero. 0 (4 points) Grading - based on the clarity and cohesiveness of your summary. CONSOLIDATED BALANCE SHEETS AS OF FEBRUARY 1, 2020 AND FEBRUARY 2, 2019 2020 2019 fin millions, except share and per share data) ASSETS Current assets: 539.25 Cash and cash equivalents 422.1 Merchandise inventories 3,522.0 3,536.0 208.2 3352 Other current assets 4,269.4 Total current assets 4,293.3 Property, plant and equipment, net of accumulated depredation of 54,194.1 and $3,690.6, respectively 3,8818 3,4453 Restricted cash 46.8 24.6 Operating lease right-of-use assets 6,225.0 Goodwill 1,983.3 2,295.6 Favorable lease rights, net of accumulated amortization of $287.8 at February 2, 2019 288.7 Trade name intangible asset 3,100.0 3,100.0 Deferred tax asset 24.4 Other assets 43.9 52.7 Total assets $19,574.6 $ 13,501.2 LIABILITIES AND SHAREHOLDERS' EQUITY Current liabilities: Current portion of long-term debt $ 250.0 S Current portion of operating lease liabilities 1,279.3 Accounts payable 1,336.5 1,416.4 Income taxes payable 62.7 60.0 Other current liabilities 618.0 619.3 Total current liabilities 3,546,5 2,095.7 Long-term debt, net, excluding current portion 3.522.2 4,2653 Operating lease liabilities, long-term 4,979.5 Unfavorable lease rights, net of accumulated amortization of $76.9 at February 2, 2019 78.8 Deferred income taxes, net 984.7 973.2 Income taxes payable, long-term 28.9 35.4 Other liabilities 258.0 4099 Total liabilities 13,319.8 7,858.3 Commitments and contingencies Shareholders' equity Common stock, par value $0.01,600,000,000 shares authorized, 236,726,563 and 238,081,664 shares issued and outstanding at February 1, 2020 and February 2, 2019, respectively 2.4 2.4 Additional paid in capital 2,454.4 2,602.7 Accumulated other comprehensive loss (39.8) (38.3) Retained earnings 3,837.8 3,076.1 Total shareholders' equity 6,254.8 5,6429 Total liabilities and shareholders' equity S 19,574.6 5 13,5012 CONSOLIDATED STATEMENTS OF OPERATIONS FOR THE YEARS ENDED FEBRUARY 1, 2020 AND FEBRUARY 2, 2019 Year Ended February 1, February 2, February 3, 2020 2019 2018 $ 23,610.8 $ 22,823.3 $ 22,245.5 16,570.1 15,875.8 15,223.6 7.040.7 6,9475 7,021.9 5,465.5 313,0 5,0043 5.160.0 2,727.0 (in millions, except per share data) Net sales Cost of sales Gross profit Selling, general and administrative expenses, excluding Goodwill impairment and Receivable impairment Goodwill impairment Receivable impairment Selling, general and administrative expenses Operating income (los) Interest expense, net Other expense (income), net Income (loss) before income taxes Provision for income taxes Net income (loss) Basic net income (loss) per share Diluted net income toss) per share 5,778.5 1,262.2 162.1 1.4 1.098.7 271.7 8270 S 3.49 $ 7,887.0 (939.5) 370.0 (0.5) (1,309,0) 281.8 (1.590.8) S (669) S 6.3 18.5 5,022.8 1.999.1 301.8 (6,7) 1,704,0 $ $ > (10.3) 1.714.3 7.24 VET See accompanying Notes to Consolidated Financial Statements TARGET CORPORATION $ 2019 77,130 $ 982 78,112 54,864 16,233 2018 74,433 $ 923 75,356 53,299 15,723 2017 71.786 928 72,714 51,125 15,140 Consolidated Statements of Operations For the years ended February 1, 2020, 2019, 2018 (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 2,357 4,658 477 (9) 4,190 921 3,269 12 3,281 $ 2,224 4,110 461 (27) 3,676 746 2,930 7 2,937 $ 2.225 4,224 653 (59) 3,630 722 2,908 6 2,914 $ $ 6.39 $ 0.02 6.42 $ 5.54 $ 0.01 5.55 $ 5.32 0.01 5.32 $ I 6.34 $ 0.02 6.36 5.50 $ 0.01 5.51 $ 5.29 0.01 5.29 510.9 515,6 528.6 533.2 546.8 550.3 4.1 See accompanying Notes to Consolidated Financial Statements Consolidated Statements of Financial Position As of February 1, 2020 and be (millions, except footnotes) 2020 2019 Assets Cash and cash equivalents $ 2,577 $ 1,556 Inventory 8,992 9.497 Other current assets 1,333 1,466 Total current assets 12,902 12,519 Property and equipment Land 6,036 6,064 Buildings and improvements 30,603 29,240 Fixtures and equipment 6,083 5,912 Computer hardware and software 2,692 2,544 Construction-in-progress 533 460 Accumulated depreciation (19,664) (18,687) Property and equipment, net 26,283 25,533 Operating lease assets 2,236 1,965 Other noncurrent assets 1.358 1,273 Total assets $ 42,779 $ 41,290 Liabilities and shareholders' investment Accounts payable $ 9,920 $ 9,761 Accrued and other current liabilities 4.406 4,201 Current portion of long-term debt and other borrowings 161 1,052 Totat current liabilities 14487 15,014 Long-term debt and other borrowings 11,338 10,223 Noncurrent operating lease liabilities 2,275 2,004 Deferred income taxes 1,122 972 Other noncurrent liabilities 1.724 1.780 Total noncurrent liabilities 16,459 14,979 Shareholders' investment Common stock 42 43 Additional pald-in capital 6,226 6,042 Retained earnings 6,433 6,017 Accumulated other comprehensive loss (868) (805) Total shareholders' investment 11,833 11.297 Total liabilities and shareholders'investment $ 42,779 $ 41.290 Common Stock Authorized 6,000,000,000 shares, 50.0833 par value: 504,198,962 shares issued and outstandingas of February 1, 2020, 517,761,600 shares issued and outstanding as of February 2, 2019 Preferred Stock Authorized 5.000.000 shares. $0.01 par value; no shares were issued or outstanding during anyperiod presented For this assignment you will choose to take the role of either a potential investor or creditor and perform a limited ratio analysis of two retail stores; Target and Dollar Tree. Additional details related to requirements are discussed on page two. Other relevant information that will assist you in computing ratios: 1. Since neither company has accounts receivable, you will not be able to compute A/R turnover or average collection period ratios (i.e. all sales must have been for cash). 2. If one of your selected ratios is earnings per share, do not compute the ratio. Instead, use the amounts given for Basic Earnings per Share on each company's Income Statement. 3. If computing Book Value per Share: . for Target, use the weighted average number of shares outstanding reported on its income statement for Basic earnings per share. For Dollar Tree, use 237 (this is presented in millions to be consistent with the other financial statement numbers). . If computing the price earnings or dividend payout ratios: For Target, use a market price of $206.10 per share For Dollar Tree, use a market price of $115.56 . . . If computing the dividend payout and/or dividend yield ratios: For Target, annual dividends are $2.72 Dollar Tree does not pay a dividend. This does not mean you cannot compare the companies on this measure. Some investors prefer dividend paying stocks and some prefer stocks that do not pay a dividend - you can address this in your written comments For Target, do not be confused by their dates. The balance sheet year 2019 and the income statement year 2020 are BOTH related to the date February 1, 2020. Use the most recent numbers (leftmost column) for all computations, for both companies. . . Decide whether you are analyzing these companies as a potential investor or potential creditor, and select EIGHT of the ratios presented in this chapter that you believe would be of interest to an individual in this role. Compute these (SAME) ratios for each of the companies). Additionally- As mentioned above, neither company has A/R so you cannot select the A/T turnover or average collection period ratios. You must use at least one ratio from each of the five categories identified in the text book: Liquidity Asset Management Debt Management Profitability Market Performance Do not count the Inventory Turnover and the Average Sale Period as two separate ratios as they measure the same thing (the first in times per year and the second in number of days) A summary of the ratio categories and ratio formulas is presented on pages 678-679 of the text. Be aware that computations of some ratios might vary slightly from source to source (le, if you were to Google a specific ratio the formula might be slightly different) For this assignment, ALL ratios will be graded using the formulas in the text (regardless of alternate computations you might find elsewhere). You must show your formula for reach ratio computed. . . . . Grading. 1 point per ratio, per company (for the most recent year only), with formula shown, using formulas as presented in the textbook. (16 points) 2 O O Analysis Write a paragraph (no longer than X page) explaining which company you prefer. Your paragraph should include: Whether you are evaluating as a potential investor or creditor. A brief summary of why you chose the specific ratios you did (le, why did you believe these were the most important ratios to evaluate based on the role you have selected). A brief summary of how you arrived at your preference. Do not do a ratio by ratio comparison stating which company performs better on each ratio, but an overall summary, discussing important points that influenced your decision When doing this assignment, your selection of role and ratios and your analysis should be completely your own. While there will logically be some overlap among students with regard to ratios selected, this section is open-ended enough that there should be no notable similarities in writing DO NOT COPY OR PARAPHRASE from the text or from anyone else or the assignment will receive a zero. 0 (4 points) Grading - based on the clarity and cohesiveness of your summary. CONSOLIDATED BALANCE SHEETS AS OF FEBRUARY 1, 2020 AND FEBRUARY 2, 2019 2020 2019 fin millions, except share and per share data) ASSETS Current assets: 539.25 Cash and cash equivalents 422.1 Merchandise inventories 3,522.0 3,536.0 208.2 3352 Other current assets 4,269.4 Total current assets 4,293.3 Property, plant and equipment, net of accumulated depredation of 54,194.1 and $3,690.6, respectively 3,8818 3,4453 Restricted cash 46.8 24.6 Operating lease right-of-use assets 6,225.0 Goodwill 1,983.3 2,295.6 Favorable lease rights, net of accumulated amortization of $287.8 at February 2, 2019 288.7 Trade name intangible asset 3,100.0 3,100.0 Deferred tax asset 24.4 Other assets 43.9 52.7 Total assets $19,574.6 $ 13,501.2 LIABILITIES AND SHAREHOLDERS' EQUITY Current liabilities: Current portion of long-term debt $ 250.0 S Current portion of operating lease liabilities 1,279.3 Accounts payable 1,336.5 1,416.4 Income taxes payable 62.7 60.0 Other current liabilities 618.0 619.3 Total current liabilities 3,546,5 2,095.7 Long-term debt, net, excluding current portion 3.522.2 4,2653 Operating lease liabilities, long-term 4,979.5 Unfavorable lease rights, net of accumulated amortization of $76.9 at February 2, 2019 78.8 Deferred income taxes, net 984.7 973.2 Income taxes payable, long-term 28.9 35.4 Other liabilities 258.0 4099 Total liabilities 13,319.8 7,858.3 Commitments and contingencies Shareholders' equity Common stock, par value $0.01,600,000,000 shares authorized, 236,726,563 and 238,081,664 shares issued and outstanding at February 1, 2020 and February 2, 2019, respectively 2.4 2.4 Additional paid in capital 2,454.4 2,602.7 Accumulated other comprehensive loss (39.8) (38.3) Retained earnings 3,837.8 3,076.1 Total shareholders' equity 6,254.8 5,6429 Total liabilities and shareholders' equity S 19,574.6 5 13,5012 CONSOLIDATED STATEMENTS OF OPERATIONS FOR THE YEARS ENDED FEBRUARY 1, 2020 AND FEBRUARY 2, 2019 Year Ended February 1, February 2, February 3, 2020 2019 2018 $ 23,610.8 $ 22,823.3 $ 22,245.5 16,570.1 15,875.8 15,223.6 7.040.7 6,9475 7,021.9 5,465.5 313,0 5,0043 5.160.0 2,727.0 (in millions, except per share data) Net sales Cost of sales Gross profit Selling, general and administrative expenses, excluding Goodwill impairment and Receivable impairment Goodwill impairment Receivable impairment Selling, general and administrative expenses Operating income (los) Interest expense, net Other expense (income), net Income (loss) before income taxes Provision for income taxes Net income (loss) Basic net income (loss) per share Diluted net income toss) per share 5,778.5 1,262.2 162.1 1.4 1.098.7 271.7 8270 S 3.49 $ 7,887.0 (939.5) 370.0 (0.5) (1,309,0) 281.8 (1.590.8) S (669) S 6.3 18.5 5,022.8 1.999.1 301.8 (6,7) 1,704,0 $ $ > (10.3) 1.714.3 7.24 VET See accompanying Notes to Consolidated Financial Statements TARGET CORPORATION $ 2019 77,130 $ 982 78,112 54,864 16,233 2018 74,433 $ 923 75,356 53,299 15,723 2017 71.786 928 72,714 51,125 15,140 Consolidated Statements of Operations For the years ended February 1, 2020, 2019, 2018 (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 2,357 4,658 477 (9) 4,190 921 3,269 12 3,281 $ 2,224 4,110 461 (27) 3,676 746 2,930 7 2,937 $ 2.225 4,224 653 (59) 3,630 722 2,908 6 2,914 $ $ 6.39 $ 0.02 6.42 $ 5.54 $ 0.01 5.55 $ 5.32 0.01 5.32 $ I 6.34 $ 0.02 6.36 5.50 $ 0.01 5.51 $ 5.29 0.01 5.29 510.9 515,6 528.6 533.2 546.8 550.3 4.1 See accompanying Notes to Consolidated Financial Statements Consolidated Statements of Financial Position As of February 1, 2020 and be (millions, except footnotes) 2020 2019 Assets Cash and cash equivalents $ 2,577 $ 1,556 Inventory 8,992 9.497 Other current assets 1,333 1,466 Total current assets 12,902 12,519 Property and equipment Land 6,036 6,064 Buildings and improvements 30,603 29,240 Fixtures and equipment 6,083 5,912 Computer hardware and software 2,692 2,544 Construction-in-progress 533 460 Accumulated depreciation (19,664) (18,687) Property and equipment, net 26,283 25,533 Operating lease assets 2,236 1,965 Other noncurrent assets 1.358 1,273 Total assets $ 42,779 $ 41,290 Liabilities and shareholders' investment Accounts payable $ 9,920 $ 9,761 Accrued and other current liabilities 4.406 4,201 Current portion of long-term debt and other borrowings 161 1,052 Totat current liabilities 14487 15,014 Long-term debt and other borrowings 11,338 10,223 Noncurrent operating lease liabilities 2,275 2,004 Deferred income taxes 1,122 972 Other noncurrent liabilities 1.724 1.780 Total noncurrent liabilities 16,459 14,979 Shareholders' investment Common stock 42 43 Additional pald-in capital 6,226 6,042 Retained earnings 6,433 6,017 Accumulated other comprehensive loss (868) (805) Total shareholders' investment 11,833 11.297 Total liabilities and shareholders'investment $ 42,779 $ 41.290 Common Stock Authorized 6,000,000,000 shares, 50.0833 par value: 504,198,962 shares issued and outstandingas of February 1, 2020, 517,761,600 shares issued and outstanding as of February 2, 2019 Preferred Stock Authorized 5.000.000 shares. $0.01 par value; no shares were issued or outstanding during anyperiod presented