Corporate triple A bond interest rates for 12 consecutive months are as follows: 9.7 9.4 9.6...

Corporate triple A bond interest rates for 12 consecutive months are as follows: 9.7 9.4 9.6 9.8 9.6 9.9 9.9 10.5 9.8 9.5 9.4 9.4 If required, round your answer to two decimal places. (a) Choose the correct time series plot. (i) (ii) (iii) (iv) What type of pattern exists in the data? (b) Develop three-month and four-month moving averages for this time series. If required, round your answers to two decimal places. Week Sales 3 Month Moving Average 4 Month Moving Average 1 9.7 2 9.4 3 9.6 4 9.8 5 9.6 6 9.9 7 9.9 8 10.5 9 9.8 10 9.5 11 9.4 12 9.4 3-month moving average 4-month moving average MSE Does the three-month or the four-month moving average provide the better forecasts based on MSE? Explain. (c) What is the moving average forecast for the next month?

Solutions

Expert Solution

t	r	3 MONTH MA	4 mont MA		error ^2 in 3 month	error^2 in 4 month
1	9.7
2	9.4
3	9.6
4	9.8	9.566666667			0.054444444
5	9.6	9.6	9.625		0	0.000625
6	9.9	9.666666667	9.6		0.054444444	0.09
7	9.9	9.766666667	9.725		0.017777778	0.030625
8	10.5	9.8	9.8		0.49	0.49
9	9.8	10.1	9.975		0.09	0.030625
10	9.5	10.06666667	10.025		0.321111111	0.275625
11	9.4	9.933333333	9.925		0.284444444	0.275625
12	9.4	9.566666667	9.8		0.027777778	0.16

				MSE	0.148888889	0.169140625

t	r	3 MONTH MA	4 mont MA		error ^2 in 3 month	error^2 in 4 month
1	9.7
=1+A2	9.4
=1+A3	9.6
=1+A4	9.8	=AVERAGE(B2:B4)			=(B5-C5)^2
=1+A5	9.6	=AVERAGE(B3:B5)	=AVERAGE(B2:B5)		=(B6-C6)^2	=(B6-D6)^2
=1+A6	9.9	=AVERAGE(B4:B6)	=AVERAGE(B3:B6)		=(B7-C7)^2	=(B7-D7)^2
=1+A7	9.9	=AVERAGE(B5:B7)	=AVERAGE(B4:B7)		=(B8-C8)^2	=(B8-D8)^2
=1+A8	10.5	=AVERAGE(B6:B8)	=AVERAGE(B5:B8)		=(B9-C9)^2	=(B9-D9)^2
=1+A9	9.8	=AVERAGE(B7:B9)	=AVERAGE(B6:B9)		=(B10-C10)^2	=(B10-D10)^2
=1+A10	9.5	=AVERAGE(B8:B10)	=AVERAGE(B7:B10)		=(B11-C11)^2	=(B11-D11)^2
=1+A11	9.4	=AVERAGE(B9:B11)	=AVERAGE(B8:B11)		=(B12-C12)^2	=(B12-D12)^2
=1+A12	9.4	=AVERAGE(B10:B12)	=AVERAGE(B9:B12)		=(B13-C13)^2	=(B13-D13)^2

				MSE	=AVERAGE(F5:F13)	=AVERAGE(G6:G13)

MSE for 3-mont h average is less than 4-month MSE

MA for next month	forecast
3	9.433333
4	9.525

milcah answered 5 days ago

Next > < Previous

Related Solutions

Corporate triple A bond interest rates for 12 consecutive months are as follows: 9.6 9.4 9.5...

Corporate triple A bond interest rates for 12 consecutive months are as follows: 9.6 9.4 9.5 9.7 9.9 9.5 9.8 10.6 10.1 9.9 9.5 9.8 If required, round your answer to two decimal places. (b) Develop three-month and four-month moving averages for this time series. If required, round your answers to two decimal places. Week Sales 3 Month Moving Average 4 Month Moving Average 1 9.6 2 9.4 3 9.5 4 9.7 5 9.9 6 9.5 7 9.8 8 10.6...

Corporate triple-A bond interest rates for 12 consecutive months follow. 9.6 9.5 9.2 9.7 9.8 9.7...

Corporate triple-A bond interest rates for 12 consecutive months follow. 9.6 9.5 9.2 9.7 9.8 9.7 9.8 10.6 9.9 9.7 9.4 9.4 b. Develop three-month and four-month moving averages for this time series (to 2 decimals). If your answer is zero enter “0”. Month Time-Series Value 3-Month Moving Average Forecast Total Month Time-Series Value 4-Month Moving Average Forecast Total Compute MSE (to 2 decimals). MSE (3-Month) MSE (4-Month) c. What is the moving average forecast for the next month (to...

1) The following are corporate AAA bond interest rates for the last 12 months: 9.5, 9.3,...

1) The following are corporate AAA bond interest rates for the last 12 months: 9.5, 9.3, 9.4, 9.6, 9.8, 9.7, 9.8, 10.5, 9.9, 9.7, 9.6, and 9.6. a) Develop a three- and four-month moving average for this time series. Which moving average provides the better forecast? Why? b) Based on your decision in part a, what is the forecast for bond interest rates for next month?

1. Assume that interest rates on 20-year Treasury and corporate bonds are as follows: T-bond =...

1. Assume that interest rates on 20-year Treasury and corporate bonds are as follows: T-bond = 7.72%AAA = 8.72% A = 9.64% BBB = 10.18%. The differences in these rates were probably caused primarily by: A. Tax effects. B. Inflation differences. C. Default and liquidity risk differences. D. Maturity risk differences. QUESTION 2 1. The Federal Reserve tends to take actions to ______ interest rates when the economy is very strong and to ______ rates when the economy is weak....

12/12 (Related to Checkpoint 9.6) (Inflation and interest rates) What would you expect the nominal rate...

12/12 (Related to Checkpoint 9.6) (Inflation and interest rates) What would you expect the nominal rate of interest to be if the real rate is 4.2 percent and the expected inflation rate is 6.6 percent? The nominal rate of interest would be nothing%. (Round to two decimal places.)

An increase in the market interest rates will generally cause the price a corporate bond with...

An increase in the market interest rates will generally cause the price a corporate bond with a fixed coupon rate to: a) become worthless b) decrease in value c) remain unchanged d) increase in value

Consider a 10% corporate bond maturing in exactly 12 months. The bonds face value is $1,000...

Consider a 10% corporate bond maturing in exactly 12 months. The bonds face value is $1,000 and is trading to yield 12%. Please solve the following with work. a) Duration b) Convexity c) Modified Duration d) Dollar Duration

Consider a 10% corporate bond maturing in exactly 12 months. The bond's face value is $1,000...

Consider a 10% corporate bond maturing in exactly 12 months. The bond's face value is $1,000 and it is trading to yield 12%. Please, find the following: a) Duration b) Convexity c) Modified Convexity d) Dollar Duration

Which answer is TRUE regarding bond prices and interest rates? Bond prices and interest rates move...

Which answer is TRUE regarding bond prices and interest rates? Bond prices and interest rates move in opposite directions. Interest rate risk is the risk that a company will default on its interest payments. The prices of short-term bonds display greater price sensitivity to interest rate changes than do the prices of long-term bonds. The price of a bond is the future value of the coupon payment and the face value.

Interest rates and bond prices, move inversely. For example, when interest rates decline, bond prices increase;...

Interest rates and bond prices, move inversely. For example, when interest rates decline, bond prices increase; when interest rates increase, bond prices decrease. Provide a quantitative example, illustrating the effect of interest rates on bond pricing? As well, explain how the length of bond maturity and higher/lower coupon rates can affect bond prices when interest rates rise and fall in the economy.

Subjects