Valuation of options by using Excel

Options represent the right to buy or to sell a specific number of underlying assets (stocks, indexes, commodities etc.) at a given price in a predetermined period of time. To analyze the value of options the Black and Scholes model will be presented and special spreadsheets will be developed using only “plain vanilla” Excel, i.e. its basic financial functions, for call and put options in the case of stocks which are paying or not paying dividends. The reason for using only “plain vanilla” Excel is a better portability of such spreadsheets for students at faculties of economics and in the public sector on different platforms or computers with various operating systems.