Export to Excel

Target Corp. (TGT) | Short-term (Operating) Activity Analysis

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.


Ratios (Summary)

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Target Corp., short-term (operating) activity ratios

Export to Excel
    Jan 29, 2011 Jan 30, 2010 Jan 31, 2009 Feb 2, 2008 Feb 3, 2007 Jan 28, 2006
  Turnover Ratios
Inventory turnover
Receivables turnover
Payables turnover
Working capital turnover
  Average No. of Days
Average inventory processing period
Add: Average receivable collection period
Operating cycle
Less: Average payables payment period
Cash conversion cycle

Source: Based on data from Target Corp. Annual Reports

Ratio Description The company
Inventory turnover An activity ratio calculated as revenue divided by inventory. Target Corp.'s inventory turnover deteriorated from 2009 to 2010 and from 2010 to 2011.
Receivables turnover An activity ratio equal to revenue divided by receivables. Target Corp.'s receivables turnover improved from 2009 to 2010 and from 2010 to 2011.
Payables turnover An activity ratio calculated as revenue divided by payables. Target Corp.'s payables turnover declined from 2009 to 2010 but then increased from 2010 to 2011 not reaching 2009 level.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Target Corp.'s working capital turnover improved from 2009 to 2010 and from 2010 to 2011.
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Target Corp.'s average inventory processing period deteriorated from 2009 to 2010 and from 2010 to 2011.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnoverd. Target Corp.'s average receivable collection period improved from 2009 to 2010 and from 2010 to 2011.
Operating cycle Equal to average inventory processing period plus average receivables collection period. Target Corp.'s operating cycle improved from 2009 to 2010 and from 2010 to 2011.
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. Target Corp.'s average payables payment period increased from 2009 to 2010 but then slightly declined from 2010 to 2011 not reaching 2009 level.
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. Target Corp.'s cash conversion cycle improved from 2009 to 2010 and from 2010 to 2011.

Inventory Turnover

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel
    Jan 29, 2011 Jan 30, 2010 Jan 31, 2009 Feb 2, 2008 Feb 3, 2007 Jan 28, 2006
  Selected Financial Data (USD $ in millions)
Revenues
Inventory
  Inventory Turnover, Comparison to Industry
Target Corp.1
  Industry, Consumer Services

Source: Based on data from Target Corp. Annual Reports

2011 Calculations

1 Inventory turnover = Revenues ÷ Inventory
= ÷ =

Ratio Description The company
Inventory turnover An activity ratio calculated as revenue divided by inventory. Target Corp.'s inventory turnover deteriorated from 2009 to 2010 and from 2010 to 2011.

Receivables Turnover

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel
    Jan 29, 2011 Jan 30, 2010 Jan 31, 2009 Feb 2, 2008 Feb 3, 2007 Jan 28, 2006
  Selected Financial Data (USD $ in millions)
Revenues
Credit card receivables, net of allowance
  Receivables Turnover, Comparison to Industry
Target Corp.1
  Industry, Consumer Services

Source: Based on data from Target Corp. Annual Reports

2011 Calculations

1 Receivables turnover = Revenues ÷ Credit card receivables, net of allowance
= ÷ =

Ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Target Corp.'s receivables turnover improved from 2009 to 2010 and from 2010 to 2011.

Payables Turnover

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel
    Jan 29, 2011 Jan 30, 2010 Jan 31, 2009 Feb 2, 2008 Feb 3, 2007 Jan 28, 2006
  Selected Financial Data (USD $ in millions)
Revenues
Accounts payable
  Payables Turnover, Comparison to Industry
Target Corp.1
  Industry, Consumer Services

Source: Based on data from Target Corp. Annual Reports

2011 Calculations

1 Payables turnover = Revenues ÷ Accounts payable
= ÷ =

Ratio Description The company
Payables turnover An activity ratio calculated as revenue divided by payables. Target Corp.'s payables turnover declined from 2009 to 2010 but then increased from 2010 to 2011 not reaching 2009 level.

Working Capital Turnover

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel
    Jan 29, 2011 Jan 30, 2010 Jan 31, 2009 Feb 2, 2008 Feb 3, 2007 Jan 28, 2006
  Selected Financial Data (USD $ in millions)
Revenues
Working capital
  Working Capital Turnover, Comparison to Industry
Target Corp.1
  Industry, Consumer Services

Source: Based on data from Target Corp. Annual Reports

2011 Calculations

1 Working capital turnover = Revenues ÷ Working capital
= ÷ =

Ratio Description The company
Working capital turnover An activity ratio calculated as revenue divided by working capital. Target Corp.'s working capital turnover improved from 2009 to 2010 and from 2010 to 2011.

Average Inventory Processing Period

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel
    Jan 29, 2011 Jan 30, 2010 Jan 31, 2009 Feb 2, 2008 Feb 3, 2007 Jan 28, 2006
  Selected Financial Data
Inventory turnover
  Average Inventory Processing Period (no. of days), Comparison to Industry
Target Corp.1
  Industry, Consumer Services

Source: Based on data from Target Corp. Annual Reports

2011 Calculations

1 Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ =

Ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Target Corp.'s average inventory processing period deteriorated from 2009 to 2010 and from 2010 to 2011.

Average Receivable Collection Period

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel
    Jan 29, 2011 Jan 30, 2010 Jan 31, 2009 Feb 2, 2008 Feb 3, 2007 Jan 28, 2006
  Selected Financial Data
Receivables turnover
  Average Receivable Collection Period (no. of days), Comparison to Industry
Target Corp.1
  Industry, Consumer Services

Source: Based on data from Target Corp. Annual Reports

2011 Calculations

1 Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ =

Ratio Description The company
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnoverd. Target Corp.'s average receivable collection period improved from 2009 to 2010 and from 2010 to 2011.

Operating Cycle

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

No. of days

Export to Excel
    Jan 29, 2011 Jan 30, 2010 Jan 31, 2009 Feb 2, 2008 Feb 3, 2007 Jan 28, 2006
  Selected Financial Data
Average inventory processing period
Average receivable collection period
  Operating Cycle, Comparison to Industry
Target Corp.1
  Industry, Consumer Services

Source: Based on data from Target Corp. Annual Reports

2011 Calculations

1 Operating cycle = Average inventory processing period + Average receivable collection period
= + =

Ratio Description The company
Operating cycle Equal to average inventory processing period plus average receivables collection period. Target Corp.'s operating cycle improved from 2009 to 2010 and from 2010 to 2011.

Average Payables Payment Period

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel
    Jan 29, 2011 Jan 30, 2010 Jan 31, 2009 Feb 2, 2008 Feb 3, 2007 Jan 28, 2006
  Selected Financial Data
Payables turnover
  Average Payables Payment Period (no. of days), Comparison to Industry
Target Corp.1
  Industry, Consumer Services

Source: Based on data from Target Corp. Annual Reports

2011 Calculations

1 Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ =

Ratio Description The company
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. Target Corp.'s average payables payment period increased from 2009 to 2010 but then slightly declined from 2010 to 2011 not reaching 2009 level.

Cash Conversion Cycle

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

No. of days

Export to Excel
    Jan 29, 2011 Jan 30, 2010 Jan 31, 2009 Feb 2, 2008 Feb 3, 2007 Jan 28, 2006
  Selected Financial Data
Average inventory processing period
Average receivable collection period
Average payables payment period
  Cash Conversion Cycle, Comparison to Industry
Target Corp.1
  Industry, Consumer Services

Source: Based on data from Target Corp. Annual Reports

2011 Calculations

1 Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= + =

Ratio Description The company
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. Target Corp.'s cash conversion cycle improved from 2009 to 2010 and from 2010 to 2011.

February 8, 2012

Existing users sign in

Forgot your password?