capstone project

km0320
timer Asked: Dec 3rd, 2020

Question Description

This project required you to develop a strategy for investing a specific sum of money in a student managed portfolio of securities. You may select up to 10 securities. You will be asked to explain the recommendations for assets included in the portfolio. You must specify their intended investment objective and risk tolerance in their recommendations. You will be required to formulate in-depth analysis and calculations of the proposed portfolio performance’s over the last month, six months, one year, five years and ten years prior to the presentation based on data from such sources as Bloomberg, CRSP, COMPUSTAT and Yahoo! Finance while utilizing tools such as EXCEL. Portfolio performance should be based on such measures as average return, standard deviation of returns, beta from the Capital Asset Pricing Model, and Jensen’s alpha.

I have attached the requirement.

Please use simple words and language.

I need a 15-pages paper and an Excel.

Unformatted Attachment Preview

Assurance of Learning Validations (Linked to the Concentration-Specific Learning Goal(s))1: A1. Capstone Student Managed Portfolio Project: Each student will be required to develop a strategy for investing a specific sum of money in a student managed portfolio of securities. Students may select up to 10 securities. Student will be asked to explain the recommendations for assets included in the portfolio. Student must specify their intended investment objective and risk tolerance in their recommendations. The student team will be required to formulate in-depth analysis and calculations of the proposed portfolio performance’s over the last month, six months, one year, five years and ten years prior to the presentation based on data from such sources as Bloomberg, CRSP, COMPUSTAT and Yahoo! Finance while utilizing tools such as EXCEL. Portfolio performance should be based on such measures as average return, standard deviation of returns, beta from the Capital Asset Pricing Model, and Jensen’s alpha. Student Deliverables pertaining to the Capstone Project: 1 Select an arbitrary age group of a client of your choice. 2 Identify clients investment goals along with risks(short/long) 3 Identify existing liabilities such as loans , tuition fees / assets Car artifacts etc 4 Identify a risk aversion score 5 Come up with your advice / suggestions to the client as his Financial advisor 6 Based on Client preferences come up with asset distribution mix Cash Bond Equities proportions [ refer CAL CML CAPM notes] 7 Write your stock/ bond / T-securities picking / selection strategies. 8 Consider ETF , Index Funds , Mutual Funds 9 Write a portfolio review policy 10 Construct the portfolio using the data 2014-2016 and optimize using Shape ratio 11 Update the portfolio with 2017 2018 2019 data 12 Now compare portfolio performance of 204-2016 with 2017-2019 13 Suggest a reallocation of assets in the portfolio 14 Conclusion 1 Write A comprehensive written project analysis is due at the beginning of Week 15. Student must submit a 15-20 pages write-up supported by tables of data-analysis in the Appendix. The capstone project analysis encompass (but not limited to) the following areas, for which a score will be given. These 9 scores are for the purpose of validating assurance of learning: a. Score 1: The demonstration of the student’s ability to identify how the current financial environment affects the risk and return of the portfolio. (FINC-LO1-A); b. Score 2: The student’s ability to extract appropriate financial and accounting data from various sources in order to conduct and support the portfolio analysis (FINC-LO1-B); c. Score 3: The student’s ability to use and appraise the data collected in a meaningful way (FINC-LO1-C); d. Score 4: The student’s ability to estimate enterprise value creation and extract financial asset values from overall enterprise values (FINC-LO2-A); e. Score 5: The student’s ability to evaluate financial assets by reference to peer companies using relevant and appropriate benchmarks of risk and return (FINC-LO2-B); f. Score 6: The student’s demonstration of resulting business strategies that may be driven by secondary ramifications (FINC-LO2-C); g. Score 7: The student’s ability to assess risk (uncertainty) (FINC-L03-A); h. Score 8: The student’s ability to justify her/his recommendation(s) (FINLO3-B); i. Score 9: The student’s demonstration of understanding the impact of the global environment on portfolio returns and risk (FINC-LO3-C). https://www.investopedia.com/articles/investing/060515/example-investment-policystatement.asp https://ca.rbcwealthmanagement.com/web/bruce.mackay/investment-policy-statement-example https://chiefmomofficer.org/2017/02/06/writing-your-investment-policy-statement/ https://www.investor.gov/additional-resources/general-resources/publications-research/infosheets/beginners-guide-asset https://realmoney.thestreet.com/investing/how-stock-picking-beats-managing-a-portfolio14831539 https://www.fool.com/investing/2017/11/03/how-to-pick-the-best-asset-allocation-for-you.aspx https://www.fool.com/investing/stock-market/types-of-stocks/esg-investing/2020/11/12/is-nowa-good-time-to-build-an-esg-portfolio/
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Content

Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors