Tuesday, January 8, 2019
A Look at Climate Change Disclosures

Wednesday, January 2, 2019
Quants: Point-in-Time Data for Backtesting

Friday, December 28, 2018
Now Showing: Controls & Procedures

Thursday, December 27, 2018
A Reminder on Non-GAAP Reporting Rules

Monday, December 17, 2018
Researching PG&E’s Wildfire Risk

Wednesday, December 12, 2018
Tracking Brexit Disclosures

Thursday, December 6, 2018
Campbell Soup: Looking Behind the Label

Sunday, December 2, 2018
SEC Comment Letters: The Amazon Example

Wednesday, November 28, 2018
Measuring Big Pharma’s Chemical Dependency

Monday, November 26, 2018
Analysts, Can You Relate? A True Story

Monday, November 19, 2018
Digging Up Historical Trend Data: Quest Example

Sunday, November 11, 2018
Cost of Revenue, SG&A: Q3 Update

Monday, November 5, 2018
Lease Accounting: FedEx vs. UPS

Saturday, November 3, 2018
New Email Alerting Powers

Wednesday, October 31, 2018
PTC and Two Tales of Revenue

Tuesday, October 30, 2018
10-K/Q Section Text Change Detection

Sunday, October 28, 2018
Finding Purchase Price Allocation

Sunday, October 21, 2018
Charting Netflix Growth in Three Ways

Wednesday, October 17, 2018
Interesting Data on Interest Income

Thursday, October 11, 2018
The Decline of Sears in Three Charts

Archive  |  Search:

A certain presidential candidate has been in the news lately for the $916 million business loss he recorded in 1995, allowing him to avoid paying federal taxes potentially for another 18 years thanks to net operating loss carryforwards.

While Calcbench takes no official view on the merits of Donald Trump’s candidacy, this particular episode of the campaign led us to wonder what other companies have claimed for NOLs lately, and how large their tax benefits might be. As always, the Calcbench databases made answering that question a breeze. Let’s take a look.

We begin at the Data Query page, and we’ll set our peer group to be the S&P 500, looking at NOLs for calendar year 2015. To set that as our search parameter, we scroll halfway down the page to the Footnotes section, and press “Tax” to show our footnote choices there. Under the tax category another checklist of choices appears, and the 12th one down is “Deferred Tax Assets, Net.” Immediately under that choice is “Deferred Tax Assets Operating Loss Carryforwards.”

That’s our box. Check it, then jump to the bottom of the page to export the findings to Excel.

In total, the S&P 500 claimed $277.4 billion in NOLs last year. More than 80 percent of the companies (406 of 498) claimed at least some NOL, and the Top 10 by dollar amount are as follows:

We can also put Trump’s $915 million loss into more context. Adjusted for inflation, that loss in 1995 would equal about $1.44 billion today. A loss that large would rank him No. 52 on our list of 2015 losses, right between Baxter International ($1.489 billion) and Cisco Systems ($1.437 billion).

We’ve also seen several media reports that Trump’s $915 million loss accounted for 1.9 percent of all net operating losses in Corporate America that year. Our databases don’t go back that far, so we can’t confirm that number. But again, for context: AIG’s $12.2 billion loss last year accounts for 4.4 percent of all losses in the S&P 500, Micron Technology’s $11.2 billion loss accounts for 4 percent.

A loss equal to 1.9 percent of all $277.4 billion claimed last year would be roughly $5.27 billion, and only squeak into the 10th spot on our Top 10 list—large, yes, but not yuuuuge.

FREE Calcbench Premium
Two Week Trial

Research Financial & Accounting Data Like Never Before. More features and try our Excel add-in. Sign up now to try the Premium Suite.