Reference no: EM13799709
1. Determine the Yield-To-Maturity (YTM) based on quarterly periods (March, June, September, December) for the past nineteen periods. (March 2010 through September 2014). [If September 2014 is not available, use data through June 2014.]
2. Look-up Bond Yield Averages for the corresponding nineteen quarterly periods (available in either Standard & Poor's Bond Guide or MERGENT's Bond Record as per handout example) by the same bond rating classification.
3. Utilizing EXCEL, (this is also available at our Computer Lab) complete the following statistical analysis: (Note: The best and most succinct discussion on using and interpreting EXCEL is the statistics text STATISTICS for BUSINESS and ECONOMICS, authored by Anderson, Sweeney, Williams, 2012, SOUTH-WESTERN CENGAGE Learning. ISBN 13: 978-0-538-48165-6)
a. Enter the two sets of data.
b. Evaluate your data by using EXCEL to compute:
1) DESCRIPTIVE STATISTICS
2) SCATTERPLOTS
3) REGRESSION ANALYSIS
Note: Make certain that the regression coefficients (a and b in the equation y = a + bx) in C.3.b.2) and C.3.b.3) are equal, frequently errors are made in these EXCEL applications which result in switching the dependent variable and independent variable.
4. Analyze the output for both sets of data, be certain to evaluate and discuss the statistical significance of the slope (b in the equation y = a + bx) and the coefficient of determination (r2). Use a 10% (.10) level of significance for each variable. (Include all statistical computer output in your report.)
5. Calculate and interpret, for your bond, the current and modified duratn.
|
Payday loans and returns located
: First Cash Financial Services: Payday Loans and Returns located in Chapter 9 of your text. Do you think that the interest charged for payday loans is fair? Relate the potential risks faced by companies such as First Cash as it pertains to investors c..
|
|
What is the moment of inertia of the pulley
: Two masses m1 = 7 kg and m2 = 4 kg are connected via a string that runs over a massive pulley of mass M = 20 kg and radius R = 0.1 m (treat the pulley as filled cylinder). The mass m2 is on an incline with a coefficient of friction µk = 0.3, What i..
|
|
Write a user manual for student website tool
: Write a user manual for Student website tool. Provide effective, clear, concise, accurate, and coherent written communication that introduces first-time students to your tool.
|
|
The discussion board forum
: Before you answer the questions below,see the Discussion Board Forum 2 Case Study; the Discussion Board Forum -Thread and Discussion Board Forum - RepliesGrading Rubrics; and the specific requirements of the post, including length, scholarly sources,..
|
|
The yield-to-maturity (ytm) based on quarterly periods
: Calculate and interpret, for your bond, the current and modified duratn.
|
|
Determine two critical elements a public leader faces
: From the weekly readings and second e-Activity, determine two critical elements a public leader faces to achieve overall success in any agency. Provide a rationale for your response.
|
|
Describe the structure and function of the electoral college
: Describe the structure and function of the electoral college. How and when was it created in the U.S.
|
|
How appropriate are each types of affirmative action
: What is affirmative action? What exactly do you think of when you hear this term? How appropriate are each of the following types of affirmative action?
|
|
Feel about the recent changes in countries
: How do you think people in the Balkans feel about the recent changes in their countries?
|