Carefully write an excel spread-sheet to calculate the B.S. formula for a put and a call. Implement (a), (b) and ( c). Setup your spread-sheet so that can be varied σ easily. Report results for and discuss what might be an appropriate value to match the .2σ = 0 binomial model (of course, one would usually choose parameters of a multi-period binomial model to match a B.S. model).

Answer rating: 100% (QA)

There is no need to use an Excel spreadsheet for this problem The BlackScholes formula for a call op... View the full answer