Finance Homework-- Need in 3 hrs
tritia1Assume you are considering a portfolio containing two assets, L and M. Asset L will represent 40% of the dollar value of the portfolio, and asset M will account for the other 60%. The projected returns over the next six years, 2018–2023, for each of these assets are summarized in the following table.
| Projected Return (%) | |
Year | Asset L | Asset M |
2018 | 14% | 20% |
2019 | 14% | 18% |
2020 | 16% | 16% |
2021 | 17% | 14% |
2022 | 17% | 12% |
2023 | 19% | 10% |
- Use an Excel spreadsheet to calculate the projected portfolio return, rp, for each of the six years.
- Use an Excel spreadsheet to calculate the average portfolio return, rp, over the six-year period.
- Use an Excel spreadsheet to calculate the standard deviation of expected portfolio returns, sp, over the six-year period.
- How would you characterize the correlation of returns of the assets L and M?
- Discuss any benefits of diversification achieved through creation of the portfolio.
10 years ago
50
Answer(3)![blurred-text]()
![blurred-text]()
![blurred-text]()
Purchase the answer to view it
NOT RATED
finance_homework.xlsx
Purchase the answer to view it
NOT RATED
- trtia_1.xlsx
Purchase the answer to view it
NOT RATED
- finance_excel_hwr.xlsx
Bids(1)
other Questions(10)
- stereotypes about chicano community
- IRIS Module
- Political Since Homework
- ACCT 504 Accounting and Finance Managerial Use and Analysis Complete Course Week 1-7 Devry
- pos420 linux
- 7-10 slides excluding Title and Reference slides (minimum of 2 references); Speaker notes 200-250 words: Competitive Advantage
- Statistics help
- Post a paragraph (approx. 10-15 lines) in response to ONE of the questions in which i will give you the source.
- Statistic homework
- you will read "Why Won't Anyone Give Me a Credit Card?" on pages 523 - 525 in Dialogues: An Argument Rhetoric and Reader. Then, write a paragraph response for questions 1 and 2 on page 525, resulting in two total paragraphs.
