Matches in SemOpenAlex for { <https://semopenalex.org/work/W2891598286> ?p ?o ?g. }
Showing items 1 to 87 of
87
with 100 items per page.
- W2891598286 abstract "Portfolio managers and investors strive to achieve the best possible trade-off between risk and return, and one of the tools they use is constructing mean-variance efficient portfolios. Finance students learn about optimal portfolios and efficient frontiers, though it is difficult to replicate them unless they have access to sophisticated software. This paper develops a teaching module that uses Microsoft Excel® to create mean-variance portfolios and traces out the efficient frontier using real-world data. In the process, the students learn to determine optimal investment allocations in a portfolio, select the optimum investment portfolio given investor’s objectives and preferences and learn about factors that influence different asset allocations. For multiple assets (N>3), the paper uses Matrix algebra in Excel®. The paper enables students and investors to learn how to construct real-world mean-variance efficient portfolios using Excel®." @default.
- W2891598286 created "2018-09-27" @default.
- W2891598286 creator A5004819892 @default.
- W2891598286 date "2018-08-01" @default.
- W2891598286 modified "2023-09-23" @default.
- W2891598286 title "Creating Optimal Portfolio and the Efficient Frontier Using Microsoft Excel ®" @default.
- W2891598286 doi "https://doi.org/10.29145/2018/jqm/020207" @default.
- W2891598286 hasPublicationYear "2018" @default.
- W2891598286 type Work @default.
- W2891598286 sameAs 2891598286 @default.
- W2891598286 citedByCount "0" @default.
- W2891598286 crossrefType "journal-article" @default.
- W2891598286 hasAuthorship W2891598286A5004819892 @default.
- W2891598286 hasBestOaLocation W28915982861 @default.
- W2891598286 hasConcept C10138342 @default.
- W2891598286 hasConcept C105795698 @default.
- W2891598286 hasConcept C111919701 @default.
- W2891598286 hasConcept C121955636 @default.
- W2891598286 hasConcept C149782125 @default.
- W2891598286 hasConcept C15952604 @default.
- W2891598286 hasConcept C162324750 @default.
- W2891598286 hasConcept C17744445 @default.
- W2891598286 hasConcept C187736073 @default.
- W2891598286 hasConcept C196083921 @default.
- W2891598286 hasConcept C199360897 @default.
- W2891598286 hasConcept C199539241 @default.
- W2891598286 hasConcept C202655437 @default.
- W2891598286 hasConcept C27548731 @default.
- W2891598286 hasConcept C2780801425 @default.
- W2891598286 hasConcept C2780821815 @default.
- W2891598286 hasConcept C2781162219 @default.
- W2891598286 hasConcept C3019730874 @default.
- W2891598286 hasConcept C33923547 @default.
- W2891598286 hasConcept C38652104 @default.
- W2891598286 hasConcept C41008148 @default.
- W2891598286 hasConcept C51485801 @default.
- W2891598286 hasConcept C73938075 @default.
- W2891598286 hasConcept C74510933 @default.
- W2891598286 hasConcept C76178495 @default.
- W2891598286 hasConcept C94625758 @default.
- W2891598286 hasConcept C9725762 @default.
- W2891598286 hasConcept C98045186 @default.
- W2891598286 hasConceptScore W2891598286C10138342 @default.
- W2891598286 hasConceptScore W2891598286C105795698 @default.
- W2891598286 hasConceptScore W2891598286C111919701 @default.
- W2891598286 hasConceptScore W2891598286C121955636 @default.
- W2891598286 hasConceptScore W2891598286C149782125 @default.
- W2891598286 hasConceptScore W2891598286C15952604 @default.
- W2891598286 hasConceptScore W2891598286C162324750 @default.
- W2891598286 hasConceptScore W2891598286C17744445 @default.
- W2891598286 hasConceptScore W2891598286C187736073 @default.
- W2891598286 hasConceptScore W2891598286C196083921 @default.
- W2891598286 hasConceptScore W2891598286C199360897 @default.
- W2891598286 hasConceptScore W2891598286C199539241 @default.
- W2891598286 hasConceptScore W2891598286C202655437 @default.
- W2891598286 hasConceptScore W2891598286C27548731 @default.
- W2891598286 hasConceptScore W2891598286C2780801425 @default.
- W2891598286 hasConceptScore W2891598286C2780821815 @default.
- W2891598286 hasConceptScore W2891598286C2781162219 @default.
- W2891598286 hasConceptScore W2891598286C3019730874 @default.
- W2891598286 hasConceptScore W2891598286C33923547 @default.
- W2891598286 hasConceptScore W2891598286C38652104 @default.
- W2891598286 hasConceptScore W2891598286C41008148 @default.
- W2891598286 hasConceptScore W2891598286C51485801 @default.
- W2891598286 hasConceptScore W2891598286C73938075 @default.
- W2891598286 hasConceptScore W2891598286C74510933 @default.
- W2891598286 hasConceptScore W2891598286C76178495 @default.
- W2891598286 hasConceptScore W2891598286C94625758 @default.
- W2891598286 hasConceptScore W2891598286C9725762 @default.
- W2891598286 hasConceptScore W2891598286C98045186 @default.
- W2891598286 hasLocation W28915982861 @default.
- W2891598286 hasOpenAccess W2891598286 @default.
- W2891598286 hasPrimaryLocation W28915982861 @default.
- W2891598286 hasRelatedWork W1956628845 @default.
- W2891598286 hasRelatedWork W1976678831 @default.
- W2891598286 hasRelatedWork W1996313475 @default.
- W2891598286 hasRelatedWork W2281686764 @default.
- W2891598286 hasRelatedWork W2349597793 @default.
- W2891598286 hasRelatedWork W2361030062 @default.
- W2891598286 hasRelatedWork W2392157072 @default.
- W2891598286 hasRelatedWork W2606405425 @default.
- W2891598286 hasRelatedWork W2891598286 @default.
- W2891598286 hasRelatedWork W3123419582 @default.
- W2891598286 isParatext "false" @default.
- W2891598286 isRetracted "false" @default.
- W2891598286 magId "2891598286" @default.
- W2891598286 workType "article" @default.