Cash Flow and Recapitalization Model

We need a challenging case study to give to Analysts and Associates seeking employment at our firm. We have put together a general description of the case and the steps necessary to complete the case study. Attached is the case study. This project incorporates many of the skills we require of our bankers, and the project is intended to be challenging. We have a template of the Excel model as well. However, we are seeking outside input from others to see if the case is challenging enough or if there are other aspects that we should add to the study. The model has not been updated for several years so we would like it refreshed.