Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Ratios (Summary)
Procter & Gamble Co., short-term (operating) activity ratios
Source: Based on data from Procter & Gamble Co. Annual Reports
| Ratio |
Description |
The company |
| Inventory turnover |
An activity ratio calculated as revenue divided by inventory. |
Procter & Gamble Co.'s inventory turnover improved from 2009 to 2010 but then deteriorated significantly from 2010 to 2011.
|
| Receivables turnover |
An activity ratio equal to revenue divided by receivables. |
Procter & Gamble Co.'s receivables turnover improved from 2009 to 2010 but then deteriorated significantly from 2010 to 2011.
|
| Payables turnover |
An activity ratio calculated as revenue divided by payables. |
Procter & Gamble Co.'s payables turnover declined from 2009 to 2010 and from 2010 to 2011.
|
| Working capital turnover |
An activity ratio calculated as revenue divided by working capital. |
Procter & Gamble Co.'s working capital turnover improved from 2009 to 2010 but then slightly deteriorated from 2010 to 2011 not reaching 2009 level.
|
| Average inventory processing period |
An activity ratio equal to the number of days in the period divided by inventory turnover over the period. |
Procter & Gamble Co.'s average inventory processing period improved from 2009 to 2010 but then deteriorated significantly from 2010 to 2011.
|
| Average receivable collection period |
An activity ratio equal to the number of days in the period divided by receivables turnoverd. |
Procter & Gamble Co.'s average receivable collection period improved from 2009 to 2010 but then deteriorated significantly from 2010 to 2011.
|
| Operating cycle |
Equal to average inventory processing period plus average receivables collection period. |
Procter & Gamble Co.'s operating cycle improved from 2009 to 2010 but then deteriorated significantly 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. |
Procter & Gamble Co.'s average payables payment period increased from 2009 to 2010 and from 2010 to 2011.
|
| 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. |
Procter & Gamble Co.'s cash conversion cycle improved from 2009 to 2010 but then slightly deteriorated from 2010 to 2011.
|
Inventory Turnover
Source: Based on data from Procter & Gamble Co. Annual Reports
2011 Calculations
1 Inventory turnover = Net sales ÷ Inventories
= 82,559 ÷ 7,379 = 11.19
| Ratio |
Description |
The company |
| Inventory turnover |
An activity ratio calculated as revenue divided by inventory. |
Procter & Gamble Co.'s inventory turnover improved from 2009 to 2010 but then deteriorated significantly from 2010 to 2011.
|
Receivables Turnover
Source: Based on data from Procter & Gamble Co. Annual Reports
2011 Calculations
1 Receivables turnover = Net sales ÷ Accounts receivable
= 82,559 ÷ 6,275 = 13.16
| Ratio |
Description |
The company |
| Receivables turnover |
An activity ratio equal to revenue divided by receivables. |
Procter & Gamble Co.'s receivables turnover improved from 2009 to 2010 but then deteriorated significantly from 2010 to 2011.
|
Payables Turnover
Source: Based on data from Procter & Gamble Co. Annual Reports
2011 Calculations
1 Payables turnover = Net sales ÷ Accounts payable
= 82,559 ÷ 8,022 = 10.29
| Ratio |
Description |
The company |
| Payables turnover |
An activity ratio calculated as revenue divided by payables. |
Procter & Gamble Co.'s payables turnover declined from 2009 to 2010 and from 2010 to 2011.
|
Working Capital Turnover
Source: Based on data from Procter & Gamble Co. Annual Reports
2011 Calculations
1 Working capital turnover = Net sales ÷ Working capital
= 82,559 ÷ 5,632 = 14.66
| Ratio |
Description |
The company |
| Working capital turnover |
An activity ratio calculated as revenue divided by working capital. |
Procter & Gamble Co.'s working capital turnover improved from 2009 to 2010 but then slightly deteriorated from 2010 to 2011 not reaching 2009 level.
|
Average Inventory Processing Period
Source: Based on data from Procter & Gamble Co. Annual Reports
2011 Calculations
1 Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 11.19 = 33
| 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. |
Procter & Gamble Co.'s average inventory processing period improved from 2009 to 2010 but then deteriorated significantly from 2010 to 2011.
|
Average Receivable Collection Period
Source: Based on data from Procter & Gamble Co. Annual Reports
2011 Calculations
1 Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 13.16 = 28
| Ratio |
Description |
The company |
| Average receivable collection period |
An activity ratio equal to the number of days in the period divided by receivables turnoverd. |
Procter & Gamble Co.'s average receivable collection period improved from 2009 to 2010 but then deteriorated significantly from 2010 to 2011.
|
Operating Cycle
Source: Based on data from Procter & Gamble Co. Annual Reports
2011 Calculations
1 Operating cycle = Average inventory processing period + Average receivable collection period
= 33 + 28 = 60
| Ratio |
Description |
The company |
| Operating cycle |
Equal to average inventory processing period plus average receivables collection period. |
Procter & Gamble Co.'s operating cycle improved from 2009 to 2010 but then deteriorated significantly from 2010 to 2011.
|
Average Payables Payment Period
Source: Based on data from Procter & Gamble Co. Annual Reports
2011 Calculations
1 Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 10.29 = 35
| 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. |
Procter & Gamble Co.'s average payables payment period increased from 2009 to 2010 and from 2010 to 2011.
|
Cash Conversion Cycle
Source: Based on data from Procter & Gamble Co. Annual Reports
2011 Calculations
1 Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 33 + 28 – 35 = 25
| 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. |
Procter & Gamble Co.'s cash conversion cycle improved from 2009 to 2010 but then slightly deteriorated from 2010 to 2011.
|