Calculate interest rate forecasting, Financial Accounting

Assignment Help:

Assume that we are in December 2009 and try to make forecasts of the five year interest rate at the end of January 2010. For this question, you just need to fill out the blank space provided (if any) for each question - no further materials should be submitted.

1) First, download the interest rate data file (Assignment 2_Winter 2011_interest rate forecasting data.xls) from the Assignment Folder at the course website. The data should go from January 1972 until July 2010. In this file, interest rates are in percentage points. For example, in cell C2, you will see: 3.763708 - this means the 3 month interest rate as of end of January 1972 is 3.763708%. This is just a preparation, you don't have to report anything here.

2) Second, construct the level, slope and curvature factors as follows:

Level = 3 month rate

Slope = 10 year rate - 3 month rate

Curvature = (3 month rate + 10 year rate) - 2 × 2 year rate

Since we are at the end of 2009, remember to limit your construction of these factors up to December 2009. Again, this is just a preparation, you don't have to report anything here.

3) Regress the contemporaneous 5 year rate over the same period (from January 1972 to December 2009) on these three factors to determine how the 5 year rate can be approximated by Level, Slope, and Curvature. Report the regression coefficients and the regression R2 statistics. That is, report a, b, c, and d in the simple linear regression equation below:

5 year rate = a + b × Level + c × Slope + d × Curvature + error

and the R2 statistics of this regression.

To answer this question, fill in the blank spaces below:

5 year rate = ________ + _______ × Level + _______ × Slope + _______ × Curvature

R2 statistic = _______.

4) Use the estimated coefficients from part 3) above, a, b, c, and d, to construct the approximate 5 year interest rate as: a + b × Level + c × Slope + d × Curvature. Plot below this approximate series together with the actual 5 year interest rate series in the data to see how close these two series match up.

5) Regress one month ahead Level factor on the current values of Level, Slope and Curvature factors and report the regression coefficients. That is, report a, b, c, and d in the following regression equation:

Level one month down the road = a + b × Level + c × Slope + d × Curvature+ error

Note that a, b, c, and d here are different from those in parts 3) and 4) above. Given the values of Level, Slope, and Curvature in December 2009, what would be your prediction of the Level factor at the end of January 2010?

To answer this question, fill in the blank spaces below:

Level one month down the road = _______ + _______ × Level + _______ × Slope + _______ × Curvature

Prediction of the Level factor at end of Jan 2010 = _______.

6.) Repeat part 5) above for the Slope factor. To answer this question, fill in the blank spaces below:  

Slope one month ahead = _______ + _______ × Level + _______ × Slope + _______ × Curvature

Prediction of the Slope factor at the end of January 2010 = _______.

7) Repeat part 5) above for the Curvature factor. To answer this question, fill in the blank spaces below:

Curvature one month down the road = _______ + _______ × Level + _______ × Slope + _______ × Curvature

Prediction of the Curvature factor at end of January 2010 = _______.

8) Given the prediction of the Level factor obtained from part 5), the prediction of the Slope factor obtained from part 6), and the prediction of the Curvature factor obtained from part 7), what would be your prediction of the 5 year interest rate at the end of January 2010? To answer this question, fill in the blank spaces below:

Prediction of the 5 year interest rate at the end of January 2010 = ______.


Related Discussions:- Calculate interest rate forecasting

Participation of employees in management, Q. Participation of Employees in ...

Q. Participation of Employees in Management? To facilitate meaningful and effective participation of workers in the management process it was decided in March 1994 that the Cor

Consolidation, what is consolidation and its features?

what is consolidation and its features?

Which is not necessary in order for corporation to pay cash, Q. Which one o...

Q. Which one of the following is not necessary in order for a corporation to pay a cash dividend? a. Adequate cash b. Approval of stockholders c. Declaration of dividends by the bo

Corporate accounting system, 1. This assignment is to be submitted as an in...

1. This assignment is to be submitted as an individual assignment.  2. Marks will be deducted for poor quality presentation. For guidance on the requirements for the presentatio

State the economic benefit of having accounting information, State the Econ...

State the Economic benefit of having accounting information Economic benefit of having accounting information is even harder to assess.  It's possible to implement some 'scienc

Salary, the salaries paid in 2004 is rs. 500000 salaries outstanding is rs....

the salaries paid in 2004 is rs. 500000 salaries outstanding is rs.20000 salaries paid in advance for 2004 is rs 30000 what is the actual salary expenditure for 2004?

Modern techniques, what are five modern financialaccounting techniques

what are five modern financialaccounting techniques

Reduces retained earnings by the fair market value, Q. If a stockholder rec...

Q. If a stockholder receives a dividend that reduces retained earnings by the fair market value of the stock, the stockholder has received a a. large stock dividend. b. cash divide

Subsidiary companies-group accounts , SUBSIDIARY COMPANIES (1AS 27) A sub...

SUBSIDIARY COMPANIES (1AS 27) A subsidiary company is a company in which the investing company (also called holding or parent company) controls the financial and operating polici

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd