Ok i have managed to create the covariance matrix on excel. Unfortunately my next problem is to use the EXPONENTIAL UTILITY u(w)=1-e^-.05w to estimate the portfolio giving maximum expected utility. My spend is £1000.
How would i used the exponential utility to maximise the expected utility??
Also i need to justify the method chosen? what method?
Any help would be greatly appreciated. I have attached my new excel file.