I need to create a program on visual basic in excel. It needs to calculate the price of options. The methods used need to be monte carlo method and binomial method. The inputs in the userform must be: Strike price, Time to maturity, initial price of stock, Desired number of simulations, Annual Volatility of underlying stock return, Annual risk of rate return, option type. The program should implement European Call and Put Options, American call and put options and Bermudan options. I also need clear explanations in the code of what exactly was done.
12 freelancers are bidding on average £118 for this job
I am an Economist graduaded from Athens University of Business and Economics with experience in financial markets and excelent skills in excel and vba.I would be glad to have a cooperation on this project.Thanks