HW of Corporate Bond's Analysis

I chose 3M company’s  Fixed Rate Notes, Ser F 2s 2002 Corporation Bond

EVALUATION OF THE CORPORATE BOND’S INVESTMENT RETURN AND

          SYSTEMATIC RISK

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. (Note:  These publications are in the Marymount University Ballston Library.)

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 (r²).  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 duration.  (Include                           the spreadsheet output in your report.)

38) Case 19: Palms Hospital Traditional Project Analysis 9$

Is anyone familiar with Case 19: Palms Hospital Traditional Project Analysis from Cases in Healthcare Finance 4th edition by Louis C. Gapenski? Pages 143-148... 

Additional Requirements 



Min Pages: 1 

Level of Detail: Show all work 

Other Requirements: I need all of the input data to help me complete this case:



Land initial cost

Land opportunity cost (and salvage value)

Building/equipment cost

Build/equipment salvage value

Procedures per day

Average net revenue per procedure

Labor costs

Utilities costs

Incremental overhead

Supply cost ($/procedure)

Inflation rate on charges

Inflation rate on costs

Tax rate

Revenues lost from inpatient surgeries

Reduction in inpatient surgery costs

Cost of capital



I have some of the data, but not sure how much I am on track.