Search for project
More than 2000 projects issued through our platform and this
amount increases very fast.
financial optimsation using excel 2007 (ID:3721)
| Project Creator: |
creesi
FC Member For 6257 Days
Credits 20 Completed Proj. Num. 0 / 5 Total payment USD 500.00 Avg Daily Online 0.00 h (From 21/5/2007) Available on MSN/Skype Yes Last Login 4/17/2008 Peers Rating 0.00% 
|
|---|---|
| Budget: | 250 - 500 |
| Created: | 1/10/2008 10:34:32 AM EST |
| Bidding Ends: | 1/17/2008 10:34:32 AM EST ( Expired ) |
| Development Cycle: | 10 Days |
| Bid Count: | 0
|
| Average Bid: | |
| Project Description:
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. |
|
| Job Type | |
| Attached Files: | 20080110103355.xlsx |
