VBA coding assignment
Write a Monte Carlo estimator for the WACC rate. You will use a Sub() instead of a Function() for this step. We want the user to input an upper and lower bound, and the number of draws. Output the followng data to the usre using a message box:
1) The number of draws
2) The average valuation
3) The best-case valuation
4) The number of times the Black-Scholes model had to be used to value equity