資源描述:
《portfolio analysis using excel》由會員上傳分享,免費在線閱讀,更多相關(guān)內(nèi)容在工程資料-天天文庫。
1、9PortfolioAnalysisUsingExcelJASONLAWSABSTRACTThischapteranalysesthefamiliarMarkovitzmodelusingExcel.Thistopicistaughton?nancedegreesandMastersprogrammesatUniversitiesallovertheworldincreasinglythroughtheuseofExcel.Wetaketimeouttoexplainhowthespreadsheetissetu
2、pandhowsimpleshortcutscanmakeanalysisofthistypeofproblemquickandstraightforward.Inthe?rstsectionofthechapterweusea2variableexampletoshowhowportfolioriskandreturnvarywiththeinputweightsthenhegoesontoshowhowtodeterminetheoptimalweights,inariskminimisationsense,
3、usingbothlinearexpressionsandalsousingmatrixalgebra.InthesecondpartofthechapterweextendthenumberofassetstosevenandillustrateusingmatrixalgebrawithinExcelthatMarkovitzanalysisofann-assetportfolioisasstraightforwardastheanalysisofatwoassetportfolio.Wetakespecia
4、lcareinshowinghowthecorrelationmatrixcanbegeneratedmostef?cientlyandhowwithinthesameframeworktheoptimisationobjectivecanbemodi?edwithoutfuss.9.1INTRODUCTIONThemotivationforthischapteristoshowhowtheMarkovitzmodelofportfolioriskcanbemodelledinExcel.Thegoalofthi
5、spaperisnottoprovideanin-depthdiscussionofthismodelbutinsteadtoshowhowitcanbeimplementedwithinExcel.Excellentdiscussionsofthismodelcanbefoundinawiderangeofcorporate?nanceorinvestmenttextbooks,includingCuthbertsonandNitzsche(2001).However,itisworthwhiletoprovi
6、deabriefoverviewofthistheory.Inessencetheunderlyingrationaleisbasedonthetwinfacetsofexpectedriskandreturn,withriskbeingmeasuredbythevarianceorstandarddeviationofexpectedreturns.Theef?cientfrontieroftheportfolioisgivenby:1.Thoseassetswhichofferahigherreturnfor
7、thesamerisk,orequivalently2.Thoseassetswhichofferalowerriskforthesamereturn.Theprecisepositionaninvestortakesontheef?cientfrontierdependsonhis/herutilityfunctionbasedonthetwomotivesofexpectedreturnandrisk;inotherwordstheutil-ityfunctionispositivelyslopedinthe
8、return/riskdomain.InitiallyIassumethatthisutilityfunctionisverysteep(i.e.theindividualishighlyriskaverse)sohis/herdesiredpositionisacornermaximumwhereriskisminimisedwithrespecttojusttwoas