Is it possible to create a workflow that sends an email with a report to
management with all opportunities where the closing date is in the past...?

MS CRM using Reporting Services (SSRS) and SSRS have this functionality
build-in.

How to configure SSRS:
http://msdn2.microsoft.com/en-us/library/ms345234.aspx

Regards.
pflis