Paying users zone. Data is covered by hidden.

  • Get to Home Depot Inc. for $19.99, or

  • get to entire website for at least 3 months from $49.99.

Microsoft Excel LibreOffice Calc


Financial Reporting Quality: Aggregate Accruals

Difficulty: Advanced

Earnings can be decomposed into cash and accrual components. The accrual component (aggregate accruals) has been found to have less persistence than the cash component, and therefore (1) earnings with higher accrual component are less persistent than earnings with smaller accrual component, all else equal; and (2) the cash component of earnings should receive a higher weighting evaluating company performance.


Balance-Sheet-Based Accruals Ratio

Home Depot Inc., balance sheet computation of aggregate accruals

USD $ in millions

Microsoft Excel LibreOffice Calc
Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014 Feb 3, 2013
Operating Assets
Total assets hidden hidden hidden hidden hidden hidden
Less: Cash and cash equivalents hidden hidden hidden hidden hidden hidden
Operating assets hidden hidden hidden hidden hidden hidden
Operating Liabilities
Total liabilities hidden hidden hidden hidden hidden hidden
Less: Short-term debt hidden hidden hidden hidden hidden hidden
Less: Current installments of long-term debt hidden hidden hidden hidden hidden hidden
Less: Long-term debt, excluding current installments hidden hidden hidden hidden hidden hidden
Operating liabilities hidden hidden hidden hidden hidden hidden
Net operating assets1 hidden hidden hidden hidden hidden hidden
Balance-sheet-based aggregate accruals2 hidden hidden hidden hidden hidden hidden
Ratio
Balance-sheet-based accruals ratio3 hidden hidden hidden hidden hidden hidden
Benchmarks
Balance-Sheet-Based Accruals Ratio, Competitors
Amazon.com Inc. hidden hidden hidden hidden hidden hidden
Costco Wholesale Corp. hidden hidden hidden hidden hidden hidden
eBay Inc. hidden hidden hidden hidden hidden hidden
Lowe’s Cos. Inc. hidden hidden hidden hidden hidden hidden
Netflix Inc. hidden hidden hidden hidden hidden hidden
Target Corp. hidden hidden hidden hidden hidden hidden
TJX Cos. Inc. hidden hidden hidden hidden hidden hidden
Walmart Inc. hidden hidden hidden hidden hidden hidden
Balance-Sheet-Based Accruals Ratio, Sector
General Retailers hidden hidden hidden hidden hidden hidden
Balance-Sheet-Based Accruals Ratio, Industry
Consumer Services hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-03-22), 10-K (filing date: 2017-03-23), 10-K (filing date: 2016-03-24), 10-K (filing date: 2015-03-26), 10-K (filing date: 2014-03-27), 10-K (filing date: 2013-03-28).

2018 Calculations

1 Net operating assets = Operating assets – Operating liabilities
= hiddenhidden = hidden

2 Balance-sheet-based aggregate accruals = Net operating assets 2018 – Net operating assets 2017
= hiddenhidden = hidden

3 Balance-sheet-based accruals ratio = 100 × Balance-sheet-based aggregate accruals ÷ Avg. net operating assets
= 100 × hidden ÷ [(hidden + hidden) ÷ 2] = hidden

Ratio Description The company
Balance-sheet-based accruals ratio Ratio is found by dividing balance-sheet-based aggregate accruals by average net operating assets. Using the balance-sheet-based accruals ratio, Home Depot Inc. deteriorated earnings quality from 2017 to 2018.

Cash-Flow-Statement-Based Accruals Ratio

Home Depot Inc., cash flow statement computation of aggregate accruals

USD $ in millions

Microsoft Excel LibreOffice Calc
Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014 Feb 3, 2013
Net earnings hidden hidden hidden hidden hidden hidden
Less: Net cash provided by operating activities hidden hidden hidden hidden hidden hidden
Less: Net cash used in investing activities hidden hidden hidden hidden hidden hidden
Cash-flow-statement-based aggregate accruals hidden hidden hidden hidden hidden hidden
Ratio
Cash-flow-statement-based accruals ratio1 hidden hidden hidden hidden hidden hidden
Benchmarks
Cash-Flow-Statement-Based Accruals Ratio, Competitors
Amazon.com Inc. hidden hidden hidden hidden hidden hidden
Costco Wholesale Corp. hidden hidden hidden hidden hidden hidden
eBay Inc. hidden hidden hidden hidden hidden hidden
Lowe’s Cos. Inc. hidden hidden hidden hidden hidden hidden
Netflix Inc. hidden hidden hidden hidden hidden hidden
Target Corp. hidden hidden hidden hidden hidden hidden
TJX Cos. Inc. hidden hidden hidden hidden hidden hidden
Walmart Inc. hidden hidden hidden hidden hidden hidden
Cash-Flow-Statement-Based Accruals Ratio, Sector
General Retailers hidden hidden hidden hidden hidden hidden
Cash-Flow-Statement-Based Accruals Ratio, Industry
Consumer Services hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-03-22), 10-K (filing date: 2017-03-23), 10-K (filing date: 2016-03-24), 10-K (filing date: 2015-03-26), 10-K (filing date: 2014-03-27), 10-K (filing date: 2013-03-28).

2018 Calculations

1 Cash-flow-statement-based accruals ratio = 100 × Cash-flow-statement-based aggregate accruals ÷ Avg. net operating assets
= 100 × hidden ÷ [(hidden + hidden) ÷ 2] = hidden

Ratio Description The company
Cash-flow-statement-based accruals ratio Ratio is found by dividing cash-flow-statement-based aggregate accruals by average net operating assets. Using the cash-flow-statement-based accruals ratio, Home Depot Inc. deteriorated earnings quality from 2017 to 2018.