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!
Using the Southwest Data Excel File (Links to an external site.), complete the following integrative practical exercises and submit for grading.
The purpose of this exercise is to provide experience in locating, understanding, and analyzing basic stock price data. The ultimate objective is to translate this data into standard measures of risk and return.
The accompanying Excel file provides you with monthly price and dividend data for Southwest (Ticker symbol: LUV) from Yahoo Finance. (If you want to see where the data came from, go to Yahoo Finance. Type in the ticker, LUV. Then, select historical prices.)
Date
Close
Dividend
HPR
HPR +1
Apr-15
40.56
0
May-15
37.05
Jun-15
33.09
0.075
Jul-15
36.2
Aug-15
36.7
Sep-15
38.04
Oct-15
46.29
Nov-15
45.88
Dec-15
43.06
Jan-16
37.62
Feb-16
41.95
Mar-16
44.8
Apr-16
44.61
May-16
42.48
Jun-16
39.21
0.1
Jul-16
37.01
Aug-16
36.88
Sep-16
38.89
Oct-16
40.05
Nov-16
46.61
Dec-16
49.84
Jan-17
52.31
Feb-17
57.8
Mar-17
53.76
Apr-17
56.22
Report your final results in the cells below
Arithmetic mean of monthly HPRs:
Geometric mean of monthly HPRs:
Standard deviation of monthly HPRs:
5% VaR
Annualized HPR (arithmetic):
Annualized HPR (geometric):
Annualized standard deviation:
The after-tax profit margin is forecasted to be 6%, and the forecasted payout ratio is 55%. Forecast the additional funds needed for the coming year.
How are interest rate risks in the banking book treated from a regulatory capital perspective and how is a banks respective
You are considering making a movie. The movie is expected to cost $10.9 million upfront and take a year to make. After? that, it is expected to make $4.2.
Prepare his marked-to-market position by showing the variation gains and losses of the position held based on the information below:
The spot rate is USD 0.1639 = RMB1. The tax rate for Bay Area is 39%. Inflation is expected to be 6.5% in China and 3.2% in the United States.
Calculate the coefficient of determination and the coefficient of correlation between X and Y. Interpret the coefficient of Determination.
Better Mousetraps has developed a new trap. It can go into production for an initial investment in equipment of $5.7 million. The equipment will be depreciated
Think reallocating the portfolio is a good idea?
What are some key topics that new employee orientations should include?
Explain the principle of subrogation. Provide a mathematical example of its use.
capital co. has a capital structure based on current market values that consists of 24 percent debt 16 percent
However, because of the competition from the plastic alternatives, it sees no scope for increasing the price per unit from its current level of $42. Based on these forecasts, the nominal net cash flow, four years from now, is forecast to be closes..
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