Question

In: Accounting

Document and Entity Information - USD ($) 12 Months Ended Feb. 03, 2018 Mar. 08, 2018...

Document and Entity Information - USD ($)

12 Months Ended

Feb. 03, 2018

Mar. 08, 2018

Jul. 29, 2017

Document and Entity Information
Entity Registrant Name TARGET CORP
Entity Central Index Key 0000027419
Document Type 10-K
Document Period End Date Feb. 03, 2018
Amendment Flag false
Current Fiscal Year End Date --02-03
Entity Well-known Seasoned Issuer Yes
Entity Voluntary Filers No
Entity Current Reporting Status Yes
Entity Filer Category Large Accelerated Filer
Entity Public Float $ 30,595,914,184
Entity Common Stock, Shares Outstanding 538,796,010
Document Fiscal Year Focus 2017
Document Fiscal Period Focus FY

Mailing Address 1000 NICOLLET MALL MINNEAPOLIS MN 55403

Business Address 1000 NICOLLET MALL MINNEAPOLIS MN 55403 6123046073

TARGET CORP (Filer) CIK: 0000027419 (see all company filings)

IRS No.: 410215170 | State of Incorp.: MN | Fiscal Year End: 0131
Type: 10-K | Act: 34 | File No.: 001-06049 | Film No.: 18689122
SIC: 5331 Retail-Variety Stores
Assistant Director 2

Use Target Corporation’s most recent annual report, to calculate:

  1. Current ratio
  2. Times interest earned
  3. Liabilities-to-equity ratio
  4. Return on equity
  5. Return on assets
  6. Financial leverage

Show calculations for each of the ratios.

Solutions

Expert Solution

Calculations are made using the annual report for the year 2017

Amounts are in millions

Calculation of current ratio:-

Total Current assets = $12,564

Total current liabilities = $13,201

Current ratio = Current assets / Current liabilities

= $12,564 / $13,201

= 0.95

Calculation of Times Interest earned ratio:-

EBIT = $4,312

Interest expense = $666

Times interest earned ratio = EBIT / Interest expense

= $4,312 / $666

= 6.47 times

Calculation of Liabilities to equity ratio:-

Total liabilities = Total current liabilities + Total non current liabilities

= $13,201 + $14,089

= $27,290

Total Shareholder Equity = $11,709

Liabilities to Equity ratio = $27,290 / $11,709

= 2.33

Calculation of return on equity:-

Net income = $2,934

Average Shareholders' Equity = ($10,953 + $11,709) / 2

= $16,806

Return on Equity = (Net income / Average Shareholders' Equity) * 100

= ($2,934 / $16,806) * 100

= 17.46%

Calculation of return on assets:-

Net income = $2,934

Total assets = $38,999

Return on assets = (Net income / Total assets) * 100

= ($2,934 / $38,999) * 100

= 7.52%

Calculation of financial leverage:-

Financial Leverage for 2017

Total Debt = Current portion of long term debt and other borrowings + Long term debt and other borrowings

= $270 + $11,317 = $11,587

Total Shareholders' Equity = $11,709

Total debt / Total Shareholders' Equity for 2017 = ($11,587 / $11,709) * 100

= 98.96%

Financial Leverage for 2016

Total Debt = Current portion of long term debt and other borrowings + Long term debt and other borrowings

= $1,718 + $11,031 = $12,749

Total Shareholders' Equity = $10,953

Total debt / Total Shareholders' Equity for 2016 = ($12,749 / $10,953) * 100

= 116.40%

Leverage has decreased from 116.40% in 2016 to 98.96%.


Related Solutions

Southwest Airlines Company Consolidated Statement of Income - USD ($) $ in Millions 12 Months Ended...
Southwest Airlines Company Consolidated Statement of Income - USD ($) $ in Millions 12 Months Ended 12/31/15 12/31/2014 12/31/2013 Please tell me Excel formula for %s in column below in BOLD!!!! OPERATING REVENUES: Passenger $ 18,299 $ 17,658 $ 16,721 103.6% 105.6% Freight 179 175 164 102.3% Special revenue adjustment 172 0 0 Other 1,170 772 814 151.6% Total operating revenues 19,820 18,605 17,699 106.5% OPERATING EXPENSES: Salaries, wages, and benefits 6,383 5,434 5,035 117.5% Fuel and oil 3,616 5,293...
need the vertical and horizontal analysis Consolidated Statements of Earnings (USD $) 12 Months Ended In...
need the vertical and horizontal analysis Consolidated Statements of Earnings (USD $) 12 Months Ended In Millions, except Per Share data, unless otherwise specified Feb. 01, 2015 Vertical Analysis Feb. 02, 2014 Vertical Analysis Horizontal Analysis Income Statement [Abstract] NET SALES $83,176 $78,812 Cost of Sales 54,222 51,422 GROSS PROFIT 28,954 27,390 Operating Expenses: Selling, General and Administrative 16,834 16,597 Depreciation and Amortization 1,651 1,627 Total Operating Expenses 18,485 18,224 OPERATING INCOME 10,469 9,166 Interest and Other (Income) Expense: Interest...
Consider the following data: Monthly Profit of a Gym Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12...
Consider the following data: Monthly Profit of a Gym Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Profit ($) 6,150 5,903 5,304 5,077 5,320 5,998 7,419 6,299 6,012 Step 1 of 5: Determine the three-period moving average for the next time period. If necessary, round your answer to one decimal place.\ Step 2 of 5: What are the MAD, MSE and MAPE scores for the three-period moving average? Round any intermediate calculations, if necessary, to no less than...
Consider the following data: Monthly Profit of a Gym Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12...
Consider the following data: Monthly Profit of a Gym Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Profit ($) 5,650 5,403 5,004 4,677 5,170 5,598 6,419 6,169 5,903 Step 2 of 5: What are the MAD, MSE and MAPE scores for the three-period moving average? Round any intermediate calculations, if necessary, to no less than six decimal places, and round your final answer to one decimal place.
Consider the following data: Monthly Profit of a Gym Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12...
Consider the following data: Monthly Profit of a Gym Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Profit ($) 6,500 6,253 5,514 5,357 5,425 6,278 8,119 6,390 6,090 Step 1 of 5: Determine the three-period moving average for the next time period. If necessary, round your answer to one decimal place. Step 2 of 5: What are the MAD, MSE and MAPE scores for the three-period moving average? Round any intermediate calculations, if necessary, to no less than...
Cash Budget - The following information applies to Company A: Jan. Feb. Mar. Apr. Miscellanous cash...
Cash Budget - The following information applies to Company A: Jan. Feb. Mar. Apr. Miscellanous cash payments $25,000 $30,000 $22,000 $32,000 Nov. Dec. Jan. Feb. Mar. Apr. Sales $200,000 $325,000 $250,000 $240,000 $260,000 $270,000 Assume Company A collects 20% of its sales in the month of the sale, 50% the next month, 25% the following month, and 5% is never collected. Dec. Jan. Feb. Mar. Apr. Purchases $210,000 $150,000 $170,000 $180,000 $190,000 Assume Company A makes cash payments of 40%...
Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Profit ($) 5,700 5,453 5,034 4,717...
Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Profit ($) 5,700 5,453 5,034 4,717 5,185 5,638 6,519 6,182 5,913 Step 2 of 5: What are the MAD, MSE and MAPE scores for the three-period moving average? Round any intermediate calculations, if necessary, to no less than six decimal places, and round your final answer to one decimal place.
Consumer price indices in 2018 in RK were: Feb. 722.7 Mar. 726.5 Apr. 729.3 May 730.8...
Consumer price indices in 2018 in RK were: Feb. 722.7 Mar. 726.5 Apr. 729.3 May 730.8 Jun. 732.2 Jul. 733.1 Aug. 734.2 Sep. 736.9 Oct. 739.9 Nov. 746.4 Dec. 751.5 a)      Produce the simple linear regression analysis. Present the fitted line analytically. Is there a significant linear dependence of СPI on time? Explain. b)      Construct the 95% confidence predicted interval for the expected in the mean CPI for Jan. 2019 . c)      How much is r squared and what is its meaning? d)      What...
Presented below is information related to Bridgeport Enterprises. Jan. 31 Feb. 28 Mar. 31 Apr. 30...
Presented below is information related to Bridgeport Enterprises. Jan. 31 Feb. 28 Mar. 31 Apr. 30 Inventory at cost $17,550 $17,667 $19,890 $16,380 Inventory at LCNRV 16,965 14,742 18,252 15,561 Purchases for the month 19,890 28,080 31,005 Sales for the month 33,930 40,950 46,800 Partially correct answer. Your answer is partially correct. Try again. From the information, prepare (as far as the data permit) monthly income statements in columnar form for February, March, and April. The inventory is to be...
Presented below is information related to Vaughn Enterprises. Jan. 31 Feb. 28 Mar. 31 Apr. 30...
Presented below is information related to Vaughn Enterprises. Jan. 31 Feb. 28 Mar. 31 Apr. 30 Inventory at cost $17,250 $17,365 $19,550 $16,100 Inventory at LCNRV 16,675 14,490 17,940 15,295 Purchases for the month 19,550 27,600 30,475 Sales for the month 33,350 40,250 46,000 (a) New attempt is in progress. Some of the new entries may impact the last attempt grading.Your answer is partially correct. From the information, prepare (as far as the data permit) monthly income statements in columnar...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT