*We need to performa a monte carlo of the two variables (Cell D38 and D39). We...

Transcribed Image Text:

*We need to performa a monte carlo of the two variables (Cell D38 and D39). We need to do it in Excel. 1) Upper Band Weight 2) Lower Band Weight *We will optimize for "MAR Ratio" (cell K8) *Run a 500 iteration test of random values between 1-1,15 for upper band and 0,85-1,0 for lower band. *Step should be 0,05 *We need to performa a monte carlo of the two variables (Cell D38 and D39). We need to do it in Excel. 1) Upper Band Weight 2) Lower Band Weight *We will optimize for "MAR Ratio" (cell K8) *Run a 500 iteration test of random values between 1-1,15 for upper band and 0,85-1,0 for lower band. *Step should be 0,05