Mastering Financial Modeling: A Professional’s Guide to Building Financial Models in Excel

CHAPTER SEVENCASE STUDY 2:Options Appraisal

In this chapter, we will focus on an options appraisal case study. In this case study, you have been hired to advise the Department of Education on a pilot project. Across the country, getting young people between the ages of 16 and 18 to remain interested in attending school and preparing for college is a big challenge. The department is concerned that this limited interest in schooling on the part of 16- to 18-year-old youths will have a negative impact on the country’s long-term development prospects, including a shortage of the skills needed by industry that will lead to reduced economic growth and increased poverty. In an attempt to encourage learning among people in this age group, the department ...