Reference no: EM131115250
TRANSNATIONAL INVESTMENTS, INC.-
In your report to your supervisor please include answers to the following five questions:
Q. 1. Your data indicates that the stock market indices of all the countries studied increased between 2005 and 2006. Unexpectedly, interest rates for all but one country also increased during that period. Perhaps this is partially due to the positive inflation rates in all of these countries. You would like to find out more information. However, there are variations in the direction and in the size of these changes for each country and this complicates your analysis.
a. The stock prices.xls Excel spreadsheetshows the change in stock market indices between 2005 and 2006 as a percentage of the 2005 indices. It also shows the change in interest rates between 2005 and 2006 as a percentage of 2005 interest rates. Use Excel to calculate the mean and standard deviation for the percent changes in market indices. Perform the same calculations for the percent changes in interest rates. What do these numbers indicate?
b. Conduct a hypothesis test to see if the mean percent change in stock market indices between 2005 and 2006 is significantly different from zero. Do this without Excel. Conduct the same test for the mean percent change in interest rates. Use a significance of .05. How do you interpret your findings?
Q. 2. The results of your answer to question 1 will allow you to compare the mean percent change in stock market indices and mean percent change in interest rates for the countries studied. However, they will not show how changes in market indices are related to changes in interest rates.
a. Use Excel to create a scatter plot for these two variables. Comment on whether you believe there is a relationship between percent changes in market indices and percent changes in interest rates. If you see a relationship, is it a positive or a negative one? As the change in interest rates increases, do you believe the change in stock market indices increases or decreases? How can you explain this? Do you see an unusual observation (i.e., outlier), which might be excluded from this sample of data?If so, what country is it?
b. Use Excel to conduct a regression analysis of these two variables. Use the data from all eighteen counties. Let percent changes in the interest rate be the independent or explanatory variable (X) and percent changes in stock market indices be the dependent variable (Y). (The dependent variable is what you are trying to predict.) Interpret your regression findings by discussing the coefficient of determination (i.e., R-squared), correlation coefficient, the regression coefficient of interest rate change, and the p-value. Is the regression coefficient of X significantly different than zero? What does this mean? Use a significance of .035
c. Did you identify an outlier in part a? If so, discard the outlier and run the regression again. Do your results change?
Q. 3. Now use Excel to do a regression of the inflation rate(X) on the percent changes in stock market indices (Y). Include the data from all eighteen countries, including the outlier. Use a significance of .03. Interpret your results (R-squared, R, regression coefficient, and p-value).How would inflation in a foreign country affect the value of foreign profits for a U.S. investor? Explain your answer.
Q. 4. Would you recommend that national interest rates and/or inflation rates be considered when making global investment decisions? Support your answer with your regression findings.
Q. 5. What additional macroeconomic variables should an investor consider when comparing foreign versus domestic investments?Discuss other factors that you would consider to be relevant when making global investment decisions.
|
Determining the commercial accounting
: Accounting theory refers to the financial reporting that may be adopted by the organisation. It is necessary to note that fund accounting is the representation of the entity accounting theory as used in commercial accounting.
|
|
Examine the crisis components related to the case
: Examine the crisis components related to the case. Examine what intervention strategies should be provided. Recommend a strategy that could be implemented to promote change.
|
|
Part of an entity contributing
: In government accounting the emphasis is based on the fund as a part of an entity contributing to the overall objectives of the organisation.
|
|
Compute the roi for each company
: Compute the ROI for each company. Which company has higher profit margin? Does it make sense, based on what you know about Apple and Dell
|
|
Calculate mean and standard deviation for the percent change
: Use Excel to calculate the mean and standard deviation for the percent changes in market indices. Perform the same calculations for the percent changes in interest rates. What do these numbers indicate?
|
|
Accounting for pollution expenditure counting crows company
: Accounting for Pollution Expenditure Counting Crows Company operates several plants at which limestone is processed into quicklime and hydrated lime.
|
|
Linear programming model for the make
: Formulate a linear programming model for the make-or-buy decision for Cleveland Stapler that will meet the 5,000-unit demand at a minimum total cost.
|
|
Is he considering the alternative hedging strategies outline
: calculates interest due based on 90-day LIBOR (the London Interbank Offered Rate). Bower wishes to hedge his remaining interest payments against changes in interest rates. Bower has correctly calculated that he needs to sell (short) 300 Eurodollar fu..
|
|
How much or how little their life is mcdonaldized
: In the final journal entry, they will reflect upon the first three entries to decide, overall, how much or how little their life is McDonaldized, and state how this impacts their relationships, their sense of identity, and their choices in life. S..
|