Could you please show me how to calculate the following using the attached consolidated income statement:
Debt-to-Assets Ratio (total debt/total assets) |
|
Debt-to-Equity Ratio (total debt/total shareholders equity) |
|
Debt-to-Capital Ratio (total debt/total capital) |
|
Leverage Ratio |
Target Corp. Consolidated Income Statement US$ in millions 12 months ended: Jan 30, 2016 $ 73,785 (51,997) 21,788 Jan 28, 2017 $ 69,495 (48,872) 20,623 Feb 3, 2018 $ 71,879 (51,125) 20,754 Feb 2, 2019 $ 74,433 (53,299) 21,134 923 (15,723) (2,224) Feb 1, 2020 $ 77,130 (54,864) 22,266 982 (16,233) (2,357) (13,356) (2,298) (14,248) (2,194) Sales Cost of sales Gross margin Other revenue Selling, general and administrative expenses Depreciation and amortization, not in cost of sales Gain on sale Operating income (EBIT) 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 (loss) Based on: (14,665) (2,213) 620 5,530 (607) 4,969 (1,004) 4,312 (666) 4,658 (477) 9 4,923 (1,602) 3,321 42 3,363 3,965 (1,296) 2,669 68 2,737 3,646 (718) 2,928 6 2,934 4,110 (461) 27 3,676 (746) 2,930 7 2,937 4,190 (921) 3,269 12 3,281 Consolidated Balance Sheet: Assets US$ in millions Jan 30, 2016 $ 4,046 Jan 28, 2017 $ 2,512 Feb 3, 2018 $ 2,643 Feb 2, 2019 $ 1,556 Feb 1, 2020 $ 2,577 384 8,601 416 8,657 513 Cash and cash equivalents Marketable Securities Accounts receivable Inventory Income tax and other receivables Prepaid expenses Other current assets Current assets Property and equipment, net Operating lease assets Other noncurrent assets Noncurrent assets Total assets 352 214 533 14,130 25,217 385 8,309 364 207 213 11,990 24,658 181 154 12,564 25,018 468 9,497 632 157 209 12,519 25,533 1,965 1,273 28,771 41,290 464 8,992 498 154 217 12,902 26,283 2,236 1,358 915 783 1,417 26,132 40,262 25,441 37,431 26,435 38,999 29,877 42,779 Jan 30, 2016 Jan 28, 2017 Feb 2, 2019 7,418 884 644 Feb 3, 2018 8,677 1,209 727 670 Feb 1, 2020 9,920 1,158 7,252 812 693 571 334 9,761 1,229 840 601 497 166 935 601 574 337 336 Accounts payable Wages and benefits Gift card liability, net of estimated breakage Real estate, sales, and other taxes payable Dividends payable Current portion of operating lease liabilities Interest payable Income tax payable Other Accrued and other current liabilities 533 200 69 76 71 67 62 502 1,372 4,389 158 1,099 3,738 26 1,219 806 4,201 910 4,406 4,254 815 12,622 11,945 823 1,718 12,708 11,031 861 270 13,201 11,317 713 1,052 15,014 10,223 972 2,004 1,042 281 1,114 353 1,103 306 125 1,103 278 332 312 46 41 305 40 105 1,780 Current portion of long-term debt and other borrowings Current liabilities Long-term debt and other borrowings, excluding current portion Deferred income taxes Noncurrent operating lease liabilities Deferred occupancy income Workers' compensation and general liability Income tax Pension benefits Other Other noncurrent liabilities Noncurrent liabilities Total liabilities Common stock Additional paid-in-capital Retained earnings Accumulated other comprehensive loss Treasury Stock Shareholders' Equity Total liabilities and shareholders' Equity Based on: 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-08), 10-K (filing date: 2017-02-09), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-13). Balance Check 14,979 161 14,487 11,338 1,122 2,275 1,032 310 180 107 95 1,724 16,459 30,946 42 6,226 6,433 (868) 122 54 272 1,915 14,683 27,305 50 5,348 8,188 (629) 298 1,878 13,770 26,478 46 5,661 5,884 (638) 2,059 14,089 27,290 45 5,858 6,553 (747) 29,993 43 6,042 6,017 (805) 12,957 40,262 10,953 37,431 11,709 38,999 11,297 41,290 11,833 42,779 OK OK OK OK OK - Consolidated Cash Flow Statement US$ in millions 12 months ended: Jan 30, 2016 $ 3,363 (42) 3,321 2,213 115 (322) (620) Jan 28, 2017 $ 2,737 (68) 2,669 2,298 113 Feb 1, 2020 $ 3,281 (12) Feb 3, 2018 $ 2,934 (6) 2,928 2,445 112 (192) Feb 2, 2019 $ 2,937 (7) 2,930 2,474 132 322 3,269 2,604 147 178 41 123 10 (12) (316) 227 422 (21) 293 29 505 30 192 (348) (168) 1,307 450 1,241 95 (900) (299) 1,127 89 18 140 534 (166) (350) (193) 199 862 445 17 Net earnings (loss) (Earnings) losses from discontinued operations, net of tax Net earnings from continuing operations Depreciation and amortization Share-based compensation expense Deferred income taxes Gain on sale Loss on debt extinguishment Noncash (gains) losses and other, net Inventory Other assets Accounts payable Accrued and other liabilities Changes in operating accounts Adjustments to reconcile net earnings (loss) to cash provided by operations Cash provided by operations Expenditures for property and equipment Proceeds from disposal of property and equipment Proceeds from sale of businesses Cash paid for acquisitions, net of cash assumed Other investments Cash (required for) provided by investing activities Change in commercial paper, net Additions to long-term debt Reductions of long-term debt Dividends paid Repurchase of stock Stock option exercises 1,819 5,140 (1,438) 28 1,875 2,660 5,329 (1,547) 46 3,921 6,849 (2,533) 31 3,040 5,970 (3,516) 85 3,830 7,099 (3,027) 63 24 28 (518) (55) (3,075) 15 20 489 (1,473) (3,416) (2,944) (85) (1,362) (3,438) 369 1,977 (2,641) (1,348) (3,706) 221 739 (2,180) (1,338) (1,046) 108 (281) (1,335) (2,124) 96 1,739 (2,069) (1,330) (1,565) 73 12 months ended: Jan 30, 2016 $ 3,363 (42) 3,321 2,213 115 (322) (620) Jan 28, 2017 $ 2,737 (68) 2,669 2,298 113 Feb 1, 2020 $ 3,281 (12) Feb 3, 2018 $ 2,934 (6) 2,928 2,445 112 (192) Feb 2, 2019 $ 2,937 (7) 2,930 2,474 132 322 3,269 2,604 147 178 41 123 10 (12) (316) 227 422 (21) 293 29 505 30 192 (348) (168) 1,307 450 1,241 95 (900) (299) 1,127 89 18 140 534 (166) (350) (193) 199 862 445 17 Net earnings (loss) (Earnings) losses from discontinued operations, net of tax Net earnings from continuing operations Depreciation and amortization Share-based compensation expense Deferred income taxes Gain on sale Loss on debt extinguishment Noncash (gains) losses and other, net Inventory Other assets Accounts payable Accrued and other liabilities Changes in operating accounts Adjustments to reconcile net earnings (loss) to cash provided by operations Cash provided by operations Expenditures for property and equipment Proceeds from disposal of property and equipment Proceeds from sale of businesses Cash paid for acquisitions, net of cash assumed Other investments Cash (required for) provided by investing activities Change in commercial paper, net Additions to long-term debt Reductions of long-term debt Dividends paid Repurchase of stock Stock option exercises 1,819 5,140 (1,438) 28 1,875 2,660 5,329 (1,547) 46 3,921 6,849 (2,533) 31 3,040 5,970 (3,516) 85 3,830 7,099 (3,027) 63 24 28 (518) (55) (3,075) 15 20 489 (1,473) (3,416) (2,944) (85) (1,362) (3,438) 369 1,977 (2,641) (1,348) (3,706) 221 739 (2,180) (1,338) (1,046) 108 (281) (1,335) (2,124) 96 1,739 (2,069) (1,330) (1,565) 73