financial optimsation using excel 2007 (ID:3721)
FC Member For 1960 Days
Completed Proj. Num. 0 / 5
Total payment USD 500.00
Avg Daily Online
0.01 h (From 21/5/2007)
Available on MSN/Skype Yes
Last Login 4/17/2008
Peers Rating 0.00%
|Budget:||250 - 500|
|Created:||2008-1-10 10:34:32 EST|
|Bidding Ends:||2008-1-17 10:34:32 EST
( Expired )
|Development Cycle:||10 Days|
this will involve the use of random number from the file attached.the use of excel 2007 (no macros).
the spreadsheet should allow the user to randomly select any 20 of the stocks and paste it into the spreadsheet.
from this data using excel 2007 and no macros. construct the unconstrained efficient frontier.
of the portfolios generated on this frontier,could you pls explain which would you choose to invest in and why? (in depth description). how well does your selected portfolio do in the second year?
using just the fierst year of your selected data construct the cardinality constrained efficient frontiers k=2,k=3,k=4,k=5 stocks. for each value of k, of the portfolios you have generated on these frontiers, which would you choose to invest in and why? (in depth). as a result how does your portfolio do in the second year?
a written report needed as well as calulations.
needs to be done to the highest standard. equivalent of an a if this were an academic situation to show you the standard required.