The article analyzes the main strategies for constructing an investment portfolio and provides recommendations for optimizing the risk-return ratio of the portfolio by selecting the appropriate investment proportions for each asset based on the theory of G. Markowitz using Excel. The author of the article examined in detail the main advantages and disadvantages of strategies for allocating investor funds within the investment portfolio. Based on the analysis carried out, the author of the article gave recommendations on the selection of financial assets for the of investment portfolio design depending on the cycle of economic activity.
