Category Archives: Finance

Fun With Math: Deferred Income Taxes

The file below was created to support my Seeking Alpha Article “$100 Billion Reasons You Need To Understand How Tax Cuts Will Impact Deferred Taxes
The data itself was kind of a pain to get…I had to find the latest 10K (most of them were from 2015…I pulled most of this together last month before most companies had released 2016) and dig into the notes for a breakdown of deferred tax assets and liabilities….don’t worry…it was great fun!!…but you can understand why I didn’t do the S&P500 🙂

For the best usability, download the excel file here:DOW-30-Deferred Tax Worksheet (Excel-Data-Junkies)

If you don’t have Excel you can use the Excel Web App with the embedded copy below. You will likely want to click the icon in the bottom right corner for full screen, then adjust your browser zoom to fit.

 

Ford US Sales Report-Dashboard (July 2011+)

I pulled this together hoping to do a write up, but haven’t got around to it. No sense letting it go unused…so enjoy!!

Basically I have compiled Ford’s monthly sales report going back to July/2011, added the YOY variance and trailing twelve month totals…then dropped it into a nice little excel dashboard.

For the best usability, download the excel file here: FORD_US_Sales_Report

If you don’t have Excel or are running an older version, you can view the dashboard using the Excel Web App with the embedded copy below. You will likely want to click the icon in the bottom right corner for full screen, then adjust your browser zoom to fit.