Excel Tools

This page contains a number of Excel spreadsheets and other tools developed by Ed Hauder to assist companies with different aspects of their equity compensation plans — from understanding their burn rates and dilution to figuring out share usage projections and how long a share pool might last.  If you use these tools and find them helpful, please let Ed know.  Additionally, if you can think of any way that these tools can be improved or you would like to see a new type of tool, let Ed know too.

NOTE: Best technique is to Right Click on the link to the document you’d like, then select SAVE AS and save the file to your local drive before opening.

This is especially important if you are using Internet Explorer since it doesn’t recognize the extenstions for the 2007 file versions quite right.  Using FireFox, you shouldn’t have an issue just clicking on the link and opening.

Project Plans/Timelines

Burn Rate/Run Rate Calculators

  • Exequity_Burn_Rate_Calculator_2017 – this spreadsheet allows you to calculate your ISS burn rate and traditional run rate with the input of a few variables using the ISS 2017 Burn Rate Industry Benchmarks, which apply to meetings after February 1, 2017.
  • 2015 Burn Rate Calculator – this spreadsheet allows you to calculate your ISS burn rate and traditional run rate with the input of a few variables using the ISS 2015 Burn Rate Industry Benchmarks, which apply to meetings between February 1, 2015 and February 1, 2016.
  • 2014 Burn Rate Calculator – this spreadsheet allows you to calculate your ISS burn rate and traditional run rate with the input of a few variables using the ISS 2014 Burn Rate Caps, which apply to meetings between February 1, 2014 and February 1, 2015.
  • 2013 Burn Rate Calculator-this spreadsheet allows you to calculate your ISS burn rate and traditional run rate with your input of a few variables. Includes the ISS 2013 Burn Rate Caps which apply to companies having meetings between February 1, 2013 and January 31, 2014.
  • 2011 Burn Rate Calculator-this spreadsheet allows you to calculate your ISS burn rate and traditional/Fidelity run rate with your input of a few variables. Includes the ISS 2011 Burn Rate Caps.
  • 2010 Burn Rate Calculator-this spreadsheet allows you to calculate your ISS burn rate and traditional run rates with your input of a few variables.
Print Friendly

Leave a Reply