Incorporate an eso plan into a company valuation

Question

Problem:

Incorporate an ESO plan into a company's valuation. (Costco wholesale corporation).

Using Costco wholesale corporation, incorporate the effect of the Employee Stock Option (ESO) plan into the common equity valuation. Be sure to consider both the forecasted ESO grants and outstanding ESOs. Perform your valuation in Excel; use appropriate formulas/equations.