Portafolio de inversión óptimo bajo teoría de markowitz y método var

Abstract

The purpose of the article is structure an investment portfolio under the Markowtiz theory (1952) and the Var method (Value at Risk) for measuring risk, in order to conceptualize the basic theory for the construction of a portfolio and its methods, detailing the structure to identify an efficient portfolio considering risk / return and demonstrate methodologies applied Markowitz and Var for choosing the optimal portfolio. A problem for the investor is to choose the assets that conform investment portfolios that provide higher returns at lower risk, then get the optimal portfolio. in this case the Excel tool was used, which allows to develop statistical operations, techniques, mathematics, among others applied in the methodology for the respective analyzes and results must take into account an investor when making decisions about investment. I was taken as basis information from the Colombia Stock Exchange, where some financial assets which were taken were chosen to apply the methodology described and which we find different combinations, plus the "Solver" application was used to find efficient portfolios, and and choose the portfolio that offers the best benefits for the investor.