RATIO ASSIGNMENT ACCTG 231 Spring 2021 Due Sunday, May 2, 2021, no later than 11:59 pm 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 companys 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). 4. 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 5. 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. 6. 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. REQUIREMENTS: 1. Role and Ratios (18 points) 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 (i.e. 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. Analysis (4 points) Write a paragraph (no longer than page) explaining which company you prefer. Your paragraph should include: o Whether you are evaluating as a potential investor or creditor. o A brief summary of why you chose the specific ratios you did (i.e. why did you believe these were the most important ratios to evaluate based on the role you have selected). o 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. o 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. o DO NOT COPY OR PARAPHRASE from the text or from anyone else or the assignment will receive a zero. Grading - based on the clarity and cohesiveness of your summary. (4 points) TARGET CORPORATION Consolidated Statements of Operations For the years ended February 1, 2020, 2019, 2018 (millions, except per share data) 2019 2018 2017 Sales $ 77,130 $ 74,433 $ 71,786 Other revenue 982 923 928 Total revenue 78,112 75,356 72,714 Cost of sales 54,864 53,299 51,125 Selling, general and administrative expenses 16,233 15,723 15,140 Depreciation and amortization (exclusive of depreciation included in cost of sales) 2,357 2,224 2,225 Operating income 4,658 4,110 4,224 Net interest expense 477 461 653 Net other (income) / expense (9) (27) (59) Earnings from continuing operations before income taxes 4,190 3,676 3,630 Provision for income taxes 921 746 722 Net earnings from continuing operations 3,269 2,930 2,908 Discontinued operations, net of tax 12 7 6 Net earnings $ 3,281 $ 2,937 $ 2,914 Basic earnings per share Continuing operations $ 6.39 $ 5.54 $ 5.32 Discontinued operations 0.02 0.01 0.01 Net earnings per share $ 6.42 $ 5.55 $ 5.32 Diluted earnings per share Continuing operations $ 6.34 $ 5.50 $ 5.29 Discontinued operations 0.02 0.01 0.01 Net earnings per share $ 6.36 $ 5.51 $ 5.29 Weighted average common shares outstanding Basic 510.9 528.6 546.8 Diluted 515.6 533.2 550.3 Antidilutive shares 4.1 Note: Per share amounts may not foot due to rounding. See accompanying Notes to Consolidated Financial Statements. TARGET CORPORATION Consolidated Statements of Financial Position As of February 1, 2020 and February 2, 2019 (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 Total current liabilities 14,487 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 paid-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, $0.0833 par value; 504,198,962 shares issued and outstanding as 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 any period presented. See accompanying Notes to Consolidated Financial Statements. DOLLAR TREE CONSOLIDATED BALANCE SHEETS AS OF FEBRUARY 1, 2020 AND FEBRUARY 2, 2019 (in millions, except share and per share data) 2020 2019 ASSETS Current assets: Cash and cash equivalents $ 539.2 $ 422.1 Merchandise inventories 3,522.0 3,536.0 Other current assets 208.2 335.2 Total current assets Property, plant and equipment, net of accumulated depreciation of $4,194.1 and $3,690.6, 4,269.4 4,293.3 respectively 3,881.8 3,445.3 Restricted cash 46.8 24.6 Operating lease right-of-use assets 6,225.0 Goodwill 1,983.3 2,296.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 $ 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,265.3 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 409.9 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,642.9 Total liabilities and shareholders equity $ 19,574.6 $ 13,501.2 DOLLAR TREE, INC. CONSOLIDATED STATEMENTS OF OPERATIONS FOR THE YEARS ENDED FEBRUARY 1, 2020 AND FEBRUARY 2, 2019 Year Ended February 1, February 2, February 3, (in millions, except per share data) 2020 2019 2018 Net sales $ 23,610.8 $ 22,823.3 $ 22,245.5 Cost of sales 16,570.1 15,875.8 15,223.6 Gross profit 7,040.7 6,947.5 7,021.9 Selling, general and administrative expenses, excluding Goodwill impairment and Receivable impairment 5,465.5 5,160.0 5,004.3 Goodwill impairment 313.0 2,727.0 Receivable impairment 18.5 Selling, general and administrative expenses 5,778.5 7,887.0 5,022.8 Operating income (loss) 1,262.2 (939.5) 1,999.1 Interest expense, net 162.1 370.0 301.8 Other expense (income), net 1.4 (0.5) (6.7) Income (loss) before income taxes 1,098.7 (1,309.0) 1,704.0 Provision for income taxes 271.7 281.8 (10.3) Net income (loss) $ 827.0 $ (1,590.8) $ 1,714.3 Basic net income (loss) per share $ 3.49 $ (6.69) $ 7.24 Diluted net income (loss) per share $ 3.47 $ (6.69) $ 7.21 See accompanying Notes to Consolidated Financial Statements