8 HOURS DELIVERY: PLAGIARISM FREE AND QUALITY WORK GUARANTEED.

Morningstar has an extensive ranking system for mutual funds, including a screen

Morningstar has an extensive ranking system for mutual funds, including a screening
program that allows you to select funds based on a number of factors. Open the
Morningstar Web site at www.morningstar.com and click on the Mutual Funds link.
Select the Fund Quickrank link in the Performance section. (Free registration is
required to access the site.) You could use the Quickrank screener for several
purposes such as to find a list of large growth stock funds with the highest 1-year and
3-year returns.
For this assignment, you are required to select three of the funds that appear on both
lists of the highest 1-year and 3-year returns. For each fund, you are advised to check
their relevant Morningstar report and look in the Ratings & Risk section to perform the
following tasks
1- Find and explain the funds’ standard deviations.
(10 marks)
2- Find and explain the funds’ Sharpe ratios.
(10 marks)
3- Find and explain the funds’ Treynor ratio.
(10 marks)
4- Find and explain (i) the standard index and (ii) the best-fit index.
(10 marks)
for each 10 marks with 300 words , thanks

The only thing I need is to fill out the spreadsheet. All the green parts from E

The only thing I need is to fill out the spreadsheet. All the green parts from E5 to I18 and E22 to I22. In cells E22 to I22, you must enter the formula for the Sharpe ratio. Use cells C22 and D22 as guides.
I have already finished the question from scenario 1-4 and scenario 5. Thank you. I also will upload all the informations.

Please answer the following questions for the discussion board. 1. Why is it so

Please answer the following questions for the discussion board.
1. Why is it so common to use historical financial data to estimate future market betas?
2. Assume that you have invested half of your wealth in a risk-free asset A and half in a risky portfolio B. Is it theoretically possible to lower your portfolio risk if you move your risk-free asset holdings (A) into another risky portfolio C? In other words, can you ever reduce your risk more by buying a risky security than by buying a risk-free asset?
3. Describe the key assumptions underlying the Capital Asset Pricing Model (CAPM).

In the next five weeks, you will be working on building a well-diversified portf

In the next five weeks, you will be working on building a well-diversified portfolio. Your initial investment stake will be $50,000 (the portfolio should use at least 95% of the initial investment amount, but do not use more than $50,000). Each week, you will use a portion of this money to make investments. You will use the closing prices from the first day of class to determine the price of each issue. Only whole lots of any issues may be acquired: that is no less than 100 shares of common or preferred stock with a maximum dollar purchase amount of $10,000, no less than five corporate bonds and U.S Treasury bonds with a maximum value of $10,000 (par or face value $1000). For mutual funds, your maximum amount of dollar investment is $20,000. Your options, future contracts, and any other related investment instrument cannot exceed $10,000. Take into consideration that transaction costs are a flat 6% of the gross purchase.
In this assignment, you will make an initial purchase of publicly traded stocks in order to build your portfolio. You will have a spending budget of $10,000 to be purchased in units of a 100 shares (include commission cost). Before you purchase and record your purchased stock, you will need to complete the following steps:
Create your personal investment objectives and financial goals, using the portfolio spending amounts and allocation of the various types of investment alternatives in the Final Project (key areas to consider may be risk and safety of principal, current income versus capital appreciation, liquidity considerations, and managing and evaluating the portfolio over a short-term or long-term).
Discuss the types of stocks or categories of stocks that you will take ownership of and why?
Discuss the types of stocks or categories of stocks that you will take ownership of and why?
Develop a company profile sheet or fact sheet for each stock company you have selected.
Analyze your selected stock companies’ fundamentals, which should include a summary of the companies’ qualitative and quantitative data. Also include supporting data justifying why you selected the companies. Additionally,
Create a tracking spreadsheet or table for your purchases.
Develop a holding return calculations table for your purchases.
Summarize the companies’ peer-group analysis, year-end comparison, annual financial highlights, news events of the companies, and ratio analysis.
The Building your Stock Portfolio paper,
Must be three double-spaced pages in length (not including title and references pages) and formatted according to APA style as outlined in the Writing Center’s APA Style (Links to an external site.) resource.
Must include a separate title page with the following:
Title of paper
Student’s name
Course name and number
Instructor’s name
Date submitted
For further assistance with the formatting and the title page, refer to APA Formatting for Microsoft Word (Links to an external site.).
Must utilize academic voice. See the Academic Voice (Links to an external site.) resource for additional guidance.
Must include an introduction and conclusion paragraph. Your introduction paragraph needs to end with a clear thesis statement that indicates the purpose of your paper.
For assistance on writing Introductions & Conclusions (Links to an external site.) as well as Writing a Thesis Statement (Links to an external site.), refer to the Writing Center resources.
Must use at least two credible sources in addition to the course text, including a minimum of two from the University of Arizona Global Campus Library.
The Scholarly, Peer Reviewed, and Other Credible Sources (Links to an external site.) table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.
Must document any information used from sources in APA style as outlined in the Writing Center’s Citing Within Your Paper (Links to an external site.) guide.
Must include a separate references page that is formatted according to APA style as outlined in the Writing Center. See the Formatting Your References List (Links to an external site.) resource in the Writing Center for specifications.
Carefully review the Grading Rubric (Links to an external site.) for the criteria that will be used to evaluate your assignment.