Utilization of linear programming in the portfolio optimization

Many people are thinking about where to invest their funds, however, they have only limited information and are unable to optimize their portfolio. A large proportion of them would like to invest in bonds, but almost no one has complete information about all states bonds. This bachelor thesis provides an overview of bonds of particular states. Within the bachelor thesis a model was created that focuses on optimization of bonds purchase. The model takes into account the profitability, risk and preferences of the investor. An application was created as a part of this bachelor thesis and can be found at the enclosed CD. It allows the investor to use the model without the knowledge of MPL and deeper knowledge of MS Excel. The application have been developed using MS Excel and system to support MPL