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!
You will need to collect the stock price data for any 2 companies of your choice and the S&P 400 index. Choose companies that are in different industries. Collect the end-of-month prices for the last 21 months of your chosen stocks and the S&P 400 and set them on the spreadsheet. Taking this raw data, compute the monthly returns for all (there should be 20 returns). Make sure that I am able to see the cell formulas for each computation.
Next, compute the mean rate of return and the standard deviation of returns for both your stocks and the stock market. Compute the beta value for each stock and plot the characteristic lines on 2 graphs. Compute the correlation coefficient for the 2 stocks. Plot the returns of your stocks against each other on a graph within the spreadsheet.
Next, assume that you construct a portfolio where you put equal money in each of your 2 stocks. Compute the 20 monthly rates of return for the portfolio and the standard deviation of returns of the portfolio. Finally, within the spreadsheet discuss in DETAIL your findings regarding risk/return of your portfolio as compared to the risk/return characteristics of the 2 individual stocks. These comments must be detailed with a complete analysis.
What is the cash flow that is settled at the three-year point? Is it a cash inflow or a cash outflow to you?
Suppose a firm is projected to have $4.2 in annual earnings per share next year, and similar firms have a P/E ratio of 20.1.
Joe's Lawn Service has asked you to develop many financial spreadsheets and a written memo to help him understand his finances for his business.
Why are U.S. Treasury bond futures contracts designed with conversion factors? Identify and discuss four non-traded delivery options related to U.S. Treasury bond futures contracts.
The bonds have an 3.4% coupon rate, payable semiannually, and a par value of $1,000. They mature exactly 10 years from today. The yield to maturity is 12%, so the bonds now sell below par. What is the current market value of the firm's debt?
If a "typical" firm reports $20 million of retained earnings on its balance sheet, could its directors declare a $20 million cash dividend without having any qualms about what they were doing? Explain your answer.
an investment project provides cash inflows of 925 per year for eight years. what is the project payback period if the
Write a script that calculates the gross pay for each of three employees. The company pays "one and a half times" for all hours worked in excess of 40 hours. You're entered the name of each employee, the number of hours each employee worked last w..
Public school systems are not noted for providing student education at minimum cost.
the authorized share capital of the alfred cake company is 150000 shares. the equity is currently shown in the
Financial Leverage Frusciante, Inc., has 290,000 bonds outstanding. The bonds have a par value of $1,000, a coupon rate of 7 percent paid semiannually.
Follies Bookstore, the only bookstore close to campus, had net income in 2005 of $90,000.Here are some of the financial ratios from the annual report. Using these ratios, calculate the following for Follies Bookstore.
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd