VBA code

1.  Input data using single input boxes 

a. Userform 

2. Calculating the portfolio return

a. Using look-up function 

3. Calculating the portfolio risk 

a. Calculating the portfolio risk within the subroutine 

4. Providing a range of low to high returns 

a. Using a simulation, reading results into an array 

5. Providing the ending investment value, single estimate. Use a MsgBox to display results. 

a. Providing high and low range based on simulation