Finance Assignment Help 20


Q1.Calculate the returns requested in i) and ii) below for all 15 of the funds?
i) The net holding period return for an investor who bought the fund on January 1,2011 and sold it on December 31,2015.

ii) The annualized return (also known as the geometric average annual return)
over the 5 year period from January 2011 to December 2015.
Q2. Complete this exercise for only one fund of your choice and for the Vanguard Index 500 (on the same graph):
You purchased $10,000 worth of the fund on January 1, 2011. Calculate and plot the dollar value of your investment over the period. (Don’t just calculate the annual return for the five years and plot five points. You should basically have a continuous line connecting 60 data points. For an example see the graph “Growth of Hypothetical $10,000” available at:

How it Works

How It works ?

Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention product code mentioned in end of every Q&A Page. You can also send us your details through our email id with product code in the email body. Product code is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.
Step 2:- While filling submit your quotes form please fill all details like deadline date, expected budget, topic , your comments in addition to product code . The date is asked to provide deadline.
Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id and must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.
Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.
Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.
Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.


Features for Assignment Help

Zero Plagiarism
We believe in providing no plagiarism work to the students. All are our works are unique and we provide Free Plagiarism report too on requests.


We believe in providing perfect, relevant and 100% accurate solutions to the student as per questions asked. All our experts are perfect in providing that so as to give unique experience to the students.


Three Stage Quality Check
We are the only service providers boasting of providing original, relevant and accurate solutions. Our three stage quality process help students to get perfect solutions.



100% Confidential
All our works are kept as confidential as we respect the integrity and privacy of our clients.

Related Services

Q3. Calculate and report the annualized sample mean return and sample standard deviation over the 5 year sample period. In this case you should annualize the mean and standard deviation of the monthly returns by multiplying the monthly mean return by 12 and the monthly standard deviation by the square root of 12. Again label your answers with the Index or portfolio name.
Q4. Calculate and report the pairwise correlations for all 15 of the funds. Include labels. (This can all be done in one step using all the monthly returns. Go to Tools/Data Analysis/Correlation and choose all the data. If Data Analysis does not appear under the Tools menu, this means that you must add it in under “Add Ins.” It is called “Analysis Toolpack”. Then you need to copy over the fund labels to replace the generic labels.)
Q5. Using the historical annualized mean and standard deviation in number 3, and the pairwise correlation from number 4, graph the investment opportunity set of portfolios combining the Vanguard Short Term Bond index and the Vanguard Small Cap Stock index on an expected return-standard deviation graph like the one on in Figure 6.4 in the text (in this example the relevant opportunity set curve is the one associated with the correlation equal to 0.2). You should be using Excel to make this graph. Note that you will be using historical data on these two portfolios to obtain estimates of expected return, expected standard deviation, and correlation.
Q6. Assume that monthly returns on these 15 portfolios are drawn from normal distributions. What is the worst return you’re likely to see in a one year holding period with 95% confidence for each index and actively managed fund?
Q7. Although I have not told you what type of actively managed fund portfolio A through E in the spreadsheet are, you should be able to tell with all the statistics you generated. Determine what type of fund (e.g., large cap domestic stocks…) they are and briefly describe how you arrived at your answer. What do you suspect about Portfolio E and how did you arrive at this?
Q8. Compare statistics for the Vanguard 500 Index (e.g., using estimates produced for questions above) from other historical periods listed in your text page 138 in Table 5.4. List out all the statistics in Table 5.4 and include estimates from 2011 to 2015. Note that the return on t-bills over this period is effectively 0. Does 2011 to 2015 look like a typical period? Why or why not?

Product Code :Fin20

To get answer for this question, kindly click here (Note: Don’t forget to write the product code in comment section)

You can also email us at but please mentioned product code in the mail body while sending emails.You can browse more questions to get answer in our Q&A sections here.