Home /Presidential Analytics: Profit and Loss

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.


About the author



Othniel Denis is currently Principal of Excellent Ones Consulting LLC. He brings with him a background in finance, training, and information management systems. Prior to opening his own firm, Othniel spent the last 13 years in finance as an Analyst at organizations like New York University, Nassau County Government and Brookhaven National Laboratory to name a few...

Read More

Comments (0)

New Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Latest Tweet