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

SOURCES OF FUNDS, In spite of the ordinary shares ranking last in terms of ...

In spite of the ordinary shares ranking last in terms of assets sharing in the event of liquidation, they attract more investors than any other type of shares. Why do you think thi

The statement of affairs-bankruptcy accounts, The Statement of Affairs ...

The Statement of Affairs The statement of affairs sets out: (a) The various assets of the debtor, at the values they are expected to realise; (b) The creditors, classified acc

Is demand elastic or inelastic , The demand curve for a product is given by...

The demand curve for a product is given by Qxd = 2,000 - 5Px + 0.2Pz, Where, Pz = $500. a. What is the own price elasticity of demand when Px = $120? Is demand elastic or inelasti

Work sheet, Q : The Trial Balance of Dephane Main Fashion Center contained ...

Q : The Trial Balance of Dephane Main Fashion Center contained the following accounts at November, 30 the end of the company fiscal year. Dephane Main Fashion Center Trial Balanc

Concept of financial statements , Concept  of Financial statements  Fin...

Concept  of Financial statements  Financial statements portray the financial effect of transactions and events by grouping them into classes broadly called elements. A complete

What is the value of the firm, Firm Value: Old School Corporation expec...

Firm Value: Old School Corporation expects an EBIT of $9,000 every year forever. Old School currently has no debt, and its cost of equity is 18 percent. The firm can borrow at

Illustration of pre-aquisition, Illustration of Pre-Aquisition H Ltd.. ...

Illustration of Pre-Aquisition H Ltd.. Acquired 80% of S Ltd. during the year ended 31/12/04.  S Ltd. paid an interim dividend of  40,000 on 30th September and as at 31/12/04 h

Describe the usiness entities:, Answer all of the parts in this task. Part ...

Answer all of the parts in this task. Part (i) is worth a maximum of 6 Marks - 1 Mark each part. Parts (ii) and (iii) are worth a maximum of 2 Marks each. (i) Describe each of t

Breakeven, Baseball Products manufactures a single product with the followi...

Baseball Products manufactures a single product with the following full unit costs at a volume of 2,000 units: Direct materials $ 900 Direct labor 360 Manufacturing overhead* 6

Ordinary income, Ordinary Income - One of two classes of income (other bein...

Ordinary Income - One of two classes of income (other being CAPITAL GAINS) taxed under the INTERNAL REVENUE CODE. Factually, ordinary income is taxed at a higher rate than capital

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