Variance is a little tricky, but for this assignment, assume the following: Let’s say the inputs to your model are ???? = 10%, sd = 20%. As per above, the mean of your normal distribution will be the natural log of 1.10 ≈ 0.095. For this model, if the standard deviation is 20%, use 0.2 as the standard deviation of your normal distribut
Assignment Task Your assignment is to develop an Excel model which takes the parameters of a normal distribution of the logarithm of asset returns…