Monthly Archives: November 2016

Presidential Analytics: Profit and Loss

In a world where misinformation is common place it is truly an asset to be able to analyze data.  The table below was derived with data from the Federal Election Commission.  We used simple groupings to easily compare the Trump and Clinton campaigns.

2016-election-tableWe can quickly see that Clinton received more in the way of revenue.  This trend was primarily driven by individual donors.  We can also see that Trump self-funded his campaign at a greater rate then Clinton.  Overall both candidates spend a majority of the money collected.  This is demonstrated by the Net Margin’s of 15% and 13%.  This simply means that 15% and 13% of the money received was left at the end of the month.

At times it’s helpful to visualize data as well.  Pictures tend to capture the attention of audiences faster.  Below is an example of a visual way to display a Profit and Loss statement.


One thing you may notice right away is that the detail is omitted.  When we use charts and graphs we automatically have to summarize data.  To much data on a graph will create noise, a chart that doesn’t make any sense.  In this example we just focus on the major bucket items: revenue, expense and net income (difference between revenue and expense).

Sign-up for our free monthly enewsletter get 154 Excel Shortcuts.  Sign-up Here.