Bond interest rates-excel formulas

Reference no: EM1390562

Corporate triple A bond interest rates for 12 consecutive months follow.

Month Bond Interest
1 9.5
2 9.3
3 9.4
4 9.6
5 9.8
6 9.7
7 9.8
8 10.5
9 9.9
10 9.7
11 9.6
12 9.6

a. Make three-month and four-month moving averages for this time series. Does the three-month or four month moving average provide the better forecast? Explain.

b. What is the moving average forecast for the next month?

Reference no: EM1390562

Questions Cloud

What is the tension in the nearer cable : What is the tension in (a) the nearer (relative to the person) cable and (b) the farther (relative to the person) cable.

Decision tree and finding expected value : Rob Johnson is a product manager at Diamond Chemicals, which is considering whether to launch a new product line that will require it to build a new facility.

List the null and alternate hypotheses : One airport had 28% late arrivals. After a new directing system was installed, a sample of 1200 flights had 322 late arrivals. At the .01 level, did the new system lower the rate of late arrivals? List the null and alternate hypotheses.

Discuss the best way to link your job performance : discuss the best way to link your job performance to training strategies. Provide specific examples to support your response.

Bond interest rates-excel formulas : Make three-month and four-month moving averages for this time series. Does the three-month or four month moving average provide the better forecast? Explain.

How many penguins of mass can stand on the ice block : A rectangular block of ice 12 m on each side and 1.3 m thick floats in sea water. The density of the sea water is 1025-kg/m3. The density of ice is 917 kg/m3. How many penguins of mass 26 kg each can stand on the ice block before they get their fe..

What is the work completed by the force of gravity : What is the work completed by the force of gravity.

Average stock price for a company : The average stock price for companies making up the S&P 500 is $40, and the standard deviation is $10. Assume the stock prices are normally distributed. What is the probability a company will have a stock price less than $33.

How many centimeters of remaining ice would extend : Two objects attract each other gravitationally with a force of 3.0×10-10 N when they are 0.60 m apart. Their total mass is 4.0 kg. Determine their individual masses.

User Account

All Pages