Affordable Care Act Toolkit

The Patient Protection and Affordable Care Act (PPACA, Affordable Care Act or Obama Care) includes complicated calculations for determining who is a "large employer" and for calculating potential penalties for these employers. Under the shared responsibility provisions, employers may be subject to penalties in a variety of circumstances including:

  • Not offering insurance to employees;
  • Not offering minimum value insurance;
  • Not offering affordable insurance (Requiring employees to pay greater than nine point five percent (9.5%) of their gross annual wages towards the costs of employee only insurance.

The method of counting employee hours of service is different for the large-employer calculation and the penalty assessments.  Therefore, OSBA is providing the following models to assist education organizations in these calculations. The models are designed using Microsoft Excel 2013 and contain macros.  You will need to enable macros on your local installation of Excel.  Your organization's technical support may block the downloading of files which contain macros.  If you get a message that you are not allowed to download the files, please contact your local technical support.

These tools are a “work in progress” and will be updated/refined as further questions arise, as further guidance becomes available, and as further regulations are implemented.


We share this information with our members and clients for general informational purposes only. It does not necessarily address all of your specific issues. It should not be construed as, nor is it intended to provide, legal advice. Questions regarding specific issues and application of these rules to your plans should be addressed by your legal counsel.

Affordable Care Act information center