Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Place the information described in this stage in the worksheet titled "Analysis".
Step 1) Calculate the arithmetic average periodic return and standard deviation of periodic returns for all four stocks, the S&P 500, your two "combined asset portfolios, and the T-bill. Use the "average" function for the arithmetic average and the "stdev" function for standard deviation. Also compute the geometric average as
=((endingcumul ret/beginning cumul ret)^(1/# of returns)) - 1
Step 2) Calculate the arithmetic averages and standard deviations separately for the sub-periods listed in the 2nd table in the Analysis worksheet.
Step 3)Build a table of correlations similar to the table below for the correlations among ALL of the INDIVIDUAL stock returns and the S&P 500 returns (the following table is an example for several stocks; however, the data is old so don't expect to get these answers). IGNORE YOUR 2 "COMBINED-ASSET" PORTFOLIO FOR THIS STEP.
The formula for calculating the correlations is the "Correl" function. To use this function, open the function box and then choose the correlation function. When the dialog box opens, select the data in pairs with the asset appearing in the left column being the "y's" and the assets appearing across the top being your "x's." Alternatively, just type "=correl(" and follow Excel's prompts. You will need to do this for each asset pair; however, you do not need to complete the top half since it is a mirror image of the bottom half. Use the available data for each pair of stocks.
Having investment in both Proctor and Gamble (PG), and Research in Motion (RIMM) from September 2010 upto now. Write a four-page analysis. To compare their performance to that of t
Weighted average cost 13% cash flows: 1st Year = $20 million 2nd Year = $30 million 3rd Year = $40 million FCF grows at 7% after year 3 No of shares - 10 million Marketable securi
You learn taht the Wilshire 5000 market value weighted index increased by 16% during a specific period, whereas a Wilshire 5000 equal-weighted index increased by 23% during the sam
#question characteristics of an investment
How might an investor’s choice of valuation model (e.g., DDM, DCF, or AE) be influenced by the type of corporation (e.g., young, mature, high-tech, consumer staples, etc.)? That is
you have to study case and than you have to fill the table that teacher had given.
how systematic risk and market risk denoted
In the category of multi-class mutual funds, this is the class that is generally characterized by a loaded fee structure. Class A mutual fund units will normally have a front- or r
It is an option that can be applied anytime in its lifetime. American options permit option holders to implement the option at any time previous to and including its maturity date,
Question 1 An investor would like to buy a futures contract on the ALCOA share. Today's price of the ALCOA share is $17. The maturity of the futures contract is in 6 months and
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd