File attached
FIN-5853 Course Project
Every investor has different objectives and constraints. Plus, investors vary in their understanding of the various stock exchanges around the world. The goal of this project is to help you better understand how to construct an investment portfolio and some of the similarities and differences in the various stock exchanges. For this project you will study three different stock exchanges, one in the U.S. and two from other parts of the world that must be from different continents. You will also create 4 investment portfolios and study the differences between them.
The course project begins during Week One and is completed and submitted during Week Seven. You will create and analyze your portfolios using Microsoft Excel. You will also write a report following the instructions below using Word.
The complete project is described in this document for your convenience:
You should create your investment portfolios during the first week. Follow the instructions in the Excel template.
Report Requirements:
The final project for this course is the creation of a market & investment analysis report.
Whether you are a trader, a research analyst, or a portfolio manager, understanding how domestic and international markets behave and are regulated, along with the strengths and weaknesses of various financial instruments is key to determining where, how, and whether to invest. Such decisions, in turn, affect individual clients' choices and collectively can influence how companies are valued and contribute to the overall economic climate.
For the summative assessment in this course, you will produce a market & investment analysis report that analyzes various organized global and domestic markets and compares performance for different investment products. Your analysis report will give an overview of three different markets available, (including one U.S. market and two non U.S. markets from two different continents; discuss the factors that affect market performance (including interest, inflation, and other macroeconomic, social, and political factors); lay out relevant rules, regulations, and governing bodies for the different markets; analyze the performance of various instruments you choose to purchase for your portfolios to assess risks and benefits; and draw conclusions based on your analysis.
In this assignment, you will demonstrate your mastery of the following course outcomes:
Explain the concept of portfolio diversification.
Evaluate expected return and risk of an investment and compare against alternatives.
Interpret value at risk under various assumptions regarding the underlying distribution of returns.
Measure performance of a portfolio using Sharpe ratio and Jensen’s alpha.
Analyze portfolio performance against a benchmark portfolio.
Prompt
Imagine you are a financial analyst at a major investment bank and will soon be working with clients to construct investment portfolios. To prepare for this work and provide coaching for your continued career growth, your supervisor has asked you to create four investment portfolios with securities purchased from three different continents. Specifically, your supervisor has requested that you prepare a report that describes your reasoning for selecting each security in the four portfolios, from which exchange you purchased the security, and why, and how each security performed in the short time you have for this project.
You will use the FIN-5853 Course Project Template to create four investment portfolios, analyze the portfolios, and compare their characteristics and performance. You will have one opportunity to buy and sell some of the securities in each fund to improve performance. Each portfolio must contain between 15 and 20 securities and the initial value must be between $98,000 and $102,000.
Specifically, the following elements must be included in your report:
Section 1: Market Overview: This section should identify the three continents where you purchased securities, and the reasoning for choosing the continents. It will also include an overview of the markets. In particular, you should briefly:
Identify the main features, similarities, and differences in the organized exchanges from which you purchased securities. For example, what instruments or securities are traded in the different markets? Are some markets more focused on certain industries or commodities?
Assess recent performance for the markets you are buying securities from. Support your response with specific indicators and examples. For example, which markets are performing well? Which are highly volatile?
Select two exchanges from your list of exchanges to discuss:
Discuss the rules, regulations, and oversight bodies for both exchanges.
Discuss the rules and regulations for companies wishing to list on those exchanges.
Section 2: Securities Purchased: This section should discuss your reasoning for purchasing each security in each portfolio. One or two sentences will be enough. You will also explain why you sold securities and the reasoning for the replacement purchase. Organize your discussion by portfolio.
Section 3: Portfolio Performance: You will use data from the Excel template to discuss the performance of each portfolio and compare portfolios and discuss the differences. You will also determine the risk of each portfolio and discuss the risk in relationship to the return. In particular, you should briefly:
Discuss the historical average return for each portfolio for the last three years using date from the Expected Return-Risk sheet of the template.
Discuss the standard deviation for each portfolio and the relationship between risk and return.
Discuss the actual performance of each portfolio and discuss the differences in terms of the relationship between risk and return.
Discuss the asset allocation of each fund and how asset allocation affect portfolio performance.
Discuss any other reasons why one portfolio performed better than the others.
Discuss the same information (A, B, C, & D) after you make changes to the securities held in each fund.
Cut and paste sections of your Excel template into your report as needed and as is helpful.
Section 4: Macroeconomic Environment: This section should focus on external factors that can cause markets to move, and how and why those factors influence performance. Specifically, you should:
Assess how different economic environments, such as boom and bust cycles, affect markets both individually and collectively. In other words, consider how economic growth or scarcity affects individual markets and how the economic environment for one market affects others. Support your answer with examples from different markets and economic periods.
Explain how social and political climates can affect market performance, risks, and returns. Use real-world examples from different markets to support your answer.
Discuss how interest rates and inflation affect market performance, using real-world examples from different economic periods to support your answer. For example, how do interest rates affect business borrowing personal investment, and lending?
Compare how different types of financial instruments, such as stocks, bonds, mutual funds, and commodities, respond to different macroeconomic environments.
Conclusions: Use this section to draw conclusions based on your analysis. Specifically:
Explain the factors that caused one portfolio to perform better than others. Give specific examples.
What changes will you make to your personal investment portfolio based on what you learned from this project?
Final Project Rubric
Criteria | Exemplary (100%) | Proficient (85%) | Needs Improvement (55%) | Not Evident or Not Submitted (0%) | Points | |
Excel Template | Meets "Proficient" criteria and spreadsheet is 100% complete, accurate, and includes notes for the course project paper. | The spreadsheet is 100% complete and accurate. | The spreadsheet is not 100%. complete, nor is it accurate. | The spreadsheet was either not submitted or was submitted with most of the items incomplete. | 30 | |
Section 1: Market Overview | Meets "Proficient" criteria and response is particularly insightful or nuanced in reflecting the diversity of the markets. | Identifies the main features, similarities, and differences in the various exchanges from where you purchased securities. | Identifies the main features, similarities, and differences in the various exchanges from where you purchased securities, but response contains inaccuracies or omits key details. | Does not identify the main features, similarities, and differences in the various exchanges from where you purchased securities, but response contains inaccuracies or omits key details. | 20 | |
Section 2: Securities Purchased | Meets "Proficient" criteria and explains reasoning that demonstrates keep insight into diverse elements of the various exchanges and investment securities. | Explains the reasoning for each investment security purchased in each portfolio. | Explains the reasoning for investment purchases, but response is incomplete, inaccurate, omits key details, or indicators. | Does not explain the reasoning for purchasing the investment securities in each portfolio. | 20 | |
Section 3: Portfolio Performance | Meets "Proficient" criteria and assessment, indicators, or examples demonstrate keen insight into diverse elements of investment performance. | Assesses average performance of the portfolio, recent performance, the relationship between risk and return, and the relationship between asset allocation and return in broad terms, focusing on factors important to investors and supporting response with specific indicators and examples. | Assesses average performance of the portfolio, recent performance, the relationship between risk and return, and the relationship between asset allocation and return in broad terms, focusing on factors important to investors, but response contains inaccuracies, omits key details, or indicators and examples are not relevant. | Does not assess average performance of the portfolio, recent performance, the relationship between risk and return, and the relationship between asset allocation and return in broad terms. | 20 | |
Section 4: Macroeconomic Environment | Meets "Proficient" criteria and response is particularly insightful, nuanced, or comprehensive. | Assesses how different economic environments affect markets both individually and collectively, supporting answer with concrete examples from different markets and economic periods. | Assesses how different economic environments affect markets individually and collectively, supported by examples, but response contains inaccuracies, omits key details, or examples are irrelevant or do not cover different markets and economic periods. | Does not assess how different economic environments affect markets both individually and collectively, supported by examples. | 20 | |
Conclusion | Meets "Proficient" criteria and response is particularly insightful, nuanced or well supported by analysis. | Assesses investment decisions in the context of the investment markets, performance, risk, and asset allocation, and explained the differences in portfolio performance. | Assesses investment decisions in the context of the investment markets, performance, risk, and asset allocation, and explained the differences in portfolio performance, but response is cursory, contains inaccuracies, or is inconsistent with analysis presented. | Does not assess investment decisions in the context of the investment markets, performance, risk, and asset allocation, and explained the differences in portfolio performance. | 10 | |
Total | 120 |