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.
展开▼
机译：期权代表在预定时间段内以给定价格买卖特定数量的基础资产（股票，指数，商品等）的权利。为了分析期权的价值，将介绍Black and Scholes模型，并且将仅使用“普通香草” Excel（即其基本财务功能）开发特殊电子表格，以用于在有偿或无偿股票情况下的看涨期权和看跌期权红利。仅使用“普通香草” Excel的原因是，这样的电子表格可以更好地为经济系和公共部门的学生在不同平台或具有各种操作系统的计算机上提供可移植性。
展开▼
