option pricing by vba programming in excel

NOTE this is an assignment that need certain level of knowledge of Excel VBA and option pricing.

Please follow the instruction for Homework 3.pdf , and complete 2 project in Excel by using VBA program.

Please upload the an Excel file with VBA code in it and complete the 2 project in separate Sheet in an Excel.

An example of option pricing is attached here as the excel file, but it is a much more simple version which can only be a reference.

The entire assignment instruction is also uploaded as pdf, which I also copy and paste the details here:

Project 1:

Write a program that will test a self-financed delta hedge strategy on an European Style option based on a simulated stock path. Assume the stock price follow Geometric Brownian Motion.

Your program should allow user to change all parameters regarding the underlying stock/option and rebalance frequency (i.e., how many times you rebalance before maturity, assume equal intervals), as well as the trade direction (buy or sell) and the option type (call or put).

Output should include the stock path, the stock position at each rebalance point, the cash balance at each period and the final P&L.

Project 2: Write a program for option pricing that allow user input for all the parameters of the underlying stock. In addition, the program should allow user to choose: 1) Option Type: Put or Call, 2) Option Style: European or American and 3)Pricing method: Black Scholes Formula (for European Style Only), Monte Carlo Simulation (for European Style Only), and Binomial Tree. Print out both your results and your simulation paths (for Monte Carlo and Binomial Tree) Hint: Write Black Scholes formula, Monte Carlo Simulation and Binomial Tree separately. Then use a main program to call each sub based on user’s choice of pricing method.