Question

In: Statistics and Probability

Investment analysts generally believe the interest rate on bonds is related to the prime interest rate...

Investment analysts generally believe the interest rate on bonds is related to the prime interest rate for loans. a) Use the following data to construct a scatter graph and then fit a regression line to the data. Report the regression formula and the r-squared value from the chart (right click on the data points, select Add Trend line and select Options to show these metrics). b) Do you think the bond rate can be predicted by the prime interest rate? Justify your answer using the relevant metrics. Prime interest rate Bond rate 0.05 0.28 0.12 0.38 0.09 0.22 0.015 0.14 0.004 0.05 0.11 0.44 0.06 0.28 0.02 0.105

Solutions

Expert Solution

a)

b)

Yes, it can be predicted. We need to apply the linear regression here.

We will be applying the Linear regression model here, it can be done by using the function LINEST(y_value, x_value, TRUE, TRUE) where y_values contain values of Bond rate here and x_values have Prime interest rate values.

Select 5 rows and 2 columns and then write the formula in the first cell and after that, press Shift + Ctrl + Enter.    

The equation comes out to be -
Bond rate = 0.08 + 2.74*Prime interest rate  


Related Solutions

Investment analysts generally believe the interest rate on bonds is related to the prime interest rate...
Investment analysts generally believe the interest rate on bonds is related to the prime interest rate for loans. Use the following data to construct a scatter graph and then fit a regression line to the data. Report the regression formula and the r-squared values from the chart (right click on the data points, select Add Trendline, and select options to show these metrics). Do you think the bond rate can be predicted by the prime interest rate? Justify your answer...
Investment analysts generally believe the interest rate on bonds is inversely related to the prime interest...
Investment analysts generally believe the interest rate on bonds is inversely related to the prime interest rate for loans; that is, bonds perform well when lending rates are down and perform poorly when interest rates are up. Can the bond rate be predicted by the prime interest rate? Use the following data to construct a least squares regression line to predict bond rates by the prime interest rate. Bond Rate Prime Interest Rate 5% 13% 11 6 9 8 15...
Investment is ________ related to the interest rate, while net capital outflow (NCO) is ________ related...
Investment is ________ related to the interest rate, while net capital outflow (NCO) is ________ related to the interest rate. positively; negatively positively; positively negatively; negatively negatively; positively Using the information in the table shown, what is the inflation rate in 2014? Year CPI 2012 121.7 2013 122.8 2014 125.2 2015 126.6 2016 128.4 - 1 % None of the above It cannot be calculated without knowing the base year.    0.9 % As new goods and services become available: the...
Interest rate on an investment
Ken Francis is offered the possibility of investing $2,745 today; in return, he would receive $10,000 after 15 years. What is the annual rate of interest for this investment? (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided. Round your "PV of a single amount" to 4 decimal places and percentage answer to the nearest whole number.)Present Value/Future Value=p (PV of a Single Amount)Interest Rate/
15. The Fed directly sets a. the prime interest rate but not the federal funds rate....
15. The Fed directly sets a. the prime interest rate but not the federal funds rate. b. both the federal funds rate and the prime interest rate. c. neither the federal funds rate nor the prime interest rate. d. the discount rate and the prime interest rate. 20. Since the financial crisis of 2007-2009, borrowing at the federal funds rate a. has dropped significantly because the rate has increased. b. has replaced open-market operations as the most frequently used tool...
Define the nominal interest rate. How is the nominal interest related to the real interest rate?...
Define the nominal interest rate. How is the nominal interest related to the real interest rate? Why can we think of 1+ rt , where rt is the real interest rate, as the relative price of consumption today in terms of consumption in the future?
Question 1 options: The “prime” interest rate is the rate that banks charge their best customers....
Question 1 options: The “prime” interest rate is the rate that banks charge their best customers. Nominal interest rates and inflation rates are given in the following table. Year Prime Interest Rate Inflation Rate 1970 7.9% 5.7% 1974 10.8% 11.0% 1978 9.1% 7.6% 1981 18.9% 10.3% Question 1 options: The “prime” interest rate is the rate that banks charge their best customers. Nominal interest rates and inflation rates are given in the following table. Year Prime Interest Rate Inflation Rate...
Investment A has a quarterly interest rate of 5%. Investment B has a monthly interest rate...
Investment A has a quarterly interest rate of 5%. Investment B has a monthly interest rate of 2%. Which investment has the lower EAR? A B A=B Private mortgage insurance (PMI) benefits borrowers because it helps them make mortgage payments when they are having financial difficulty. True False Bond A is a par bond and Bond B is a premium bond. All else equal, which bond has the higher coupon rate? A B A=B
For a corporation that can borrow freely at the current prime interest rate and seeks to...
For a corporation that can borrow freely at the current prime interest rate and seeks to maximize its expected profit over the next several years, how does the reduction in the marginal corporate income tax from 35% to 21% in the TCAJ act affect the amount it would choose to spend on new equipment, financed by new borrowing? Ignore other reforms in the TCAJ act that affect the corporation’s tax liability. Justify your answer.
Determinants of Interest Rate for Individual Securities You are considering an investment in 30-year bonds issued...
Determinants of Interest Rate for Individual Securities You are considering an investment in 30-year bonds issued by a corporation. The bonds have no special covenants. The Wall Street Journal reports that 1-year T-bills are currently earning 3.60 percent. Your broker has determined the following information about economic activity and the corporation bonds: Real interest rate = 3.05% Default risk premium = 2.85% Liquidity risk premium = 1.25% Maturity risk premium = 2.60% What is the inflation premium? What is the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT