Discount factors-spot interest rates-forward interest rates

Assignment Help Financial Management

Reference no: EM13934771

Experts can you please complete the rest of the problem as stated below: (KINDLY SHOW SOLUTION)

Questions from 201 through 503 (just the way the questions were numbered)

GIVEN: Take the bond price data given on 50 bonds. Each bond has a face value of $100 and pays the given coupon semi-annually starting at the next coupon payment dates as given. Follow the steps discussed in class to estimate the term structures of discount factors, spot interest rates, and forward interest rates. Coupon is the rate in per cent per year applied to the face value of a bond to determine the annual coupon in dollars, half of which is paid every six months on coupon payment dates. For example, Coupon of 10% for a bond with a face value of $100 will result in $10 in annual coupon and a payment of $5 on each coupon payment date every half year.

Answer the following questions:

Question: 201: Estimated value of “a.”

Question 202: Estimated value of “b.”

Question 203: Estimated value of “c.”

GIVEN: To plot, take 100 values of the term (x-axis) at intervals of .25 year starting at time 0. Then produce the 100 values (y-axis) of discount factor function, forward rate and spot rate functions for the plots.

Answer the following:

Question 204-303: Discount factor function values for the 100 different terms .25, .50,….,25.00.

Question 304-403: Forward rate function values for the 100 different terms .25, .50,….,25.00.

Question 404-503: Spot rate function values for the 100 different terms .25, .50,….,25.00.

NOTE: The project grade will be based on the accuracy of your answers for each question receiving equal weight. Answers without any verbal description are required to be submitted in a two-column spread-sheet with the first column showing the question number and the second column your answers.

BONDS Data: (SEE BELOW)

Bond QSP NextCoup Coupon YearsMat

1 102.60 0.060 8.00 0.560

2 103.17 0.072 8.60 1.072

3 103.74 0.084 9.20 1.584

4 104.31 0.096 9.80 2.096

5 104.88 0.108 10.40 2.608

6 105.45 0.120 11.00 3.120

7 106.02 0.132 11.60 3.632

8 106.59 0.144 12.20 4.144

9 107.16 0.156 12.80 4.656

10 107.73 0.168 13.40 5.168

11 108.30 0.180 14.00 5.680

12 108.87 0.192 14.60 6.192

13 109.44 0.204 15.20 6.704

14 110.01 0.216 15.80 7.216

15 110.58 0.228 16.40 7.728

16 111.15 0.240 17.00 8.240

17 111.72 0.252 17.60 8.752

18 112.29 0.264 18.20 9.264

19 112.86 0.276 18.80 9.776

20 113.43 0.288 19.40 10.288

21 114.00 0.300 20.00 10.800

22 114.57 0.312 20.60 11.312

23 115.14 0.324 21.20 11.824

24 115.71 0.336 21.80 12.336

25 116.28 0.348 22.40 12.848

26 116.85 0.360 23.00 13.360

27 117.42 0.372 23.60 13.872

28 117.99 0.384 24.20 14.384

29 118.56 0.396 24.80 14.896

30 119.13 0.408 25.40 15.408

31 119.70 0.420 26.00 15.920

32 120.27 0.432 26.60 16.432

33 120.84 0.444 27.20 16.944

34 121.41 0.450 27.80 17.450

35 121.98 0.450 28.40 17.950

36 122.55 0.450 29.00 18.450

37 123.12 0.450 29.60 18.950

38 123.69 0.450 30.20 19.450

39 124.26 0.450 30.80 19.950

40 124.83 0.450 31.40 20.450

41 125.40 0.450 32.00 20.950

42 125.97 0.450 32.60 21.450

43 126.54 0.450 33.20 21.950

44 127.11 0.450 33.80 22.450

45 127.68 0.450 34.40 22.950

46 128.25 0.450 35.00 23.450

47 128.82 0.450 35.60 23.950

48 129.39 0.450 36.20 24.450

49 129.96 0.450 36.80 24.950

50 130.53 0.450 37.40 25.450

Normal Completion

Reference no: EM13934771

Questions Cloud

Write a program to evaluate the polynomial : So far all the programs that we run on SPIM should be run on bare machine which has no user convenience. My slides on the 4th lecture notes show what settings you should choose. I am also attaching a screenshot here that shows the settings window.

Using a graphics application, such as microsoft powerpoint : What would be the most appropriate network topology to use on this network?

Determine the average cost of the crate : After a month, the store clerk informs you that the same crate of wine now costs $82. However, there are 7 bottles in a crate. To the nearest cent, determine the average cost of the crate from last month to now.

Find the future value of the annuities : If you deposit $10,000 in a bank account that pays 10% interest annually, how much will be in your account after 5 years? 4-2 What is the present value of a security that will pay $5,000 in 20 years if securities of equal risk pay 7% annually? 4-12 F..

Discount factors-spot interest rates-forward interest rates : Take the bond price data given on 50 bonds. Each bond has a face value of $100 and pays the given coupon semi-annually starting at the next coupon payment dates as given. Follow the steps discussed in class to estimate the term structures of discount..

Two argument integers and returns the operation : The over all program should ask user for two integer numbers (a, b) and target arithmetic operation (+,-,*./) and will print the result of the operation with a comment if the result produced is correct or not.

Providing a historical context and legal framework : Select and discuss 3 landmark legal cases (from the list above) that involve Asian Pacific Americans between 1885- 1990. Discuss each one, providing a historical context and legal framework from which to understand these cases impact on Asian Pac..

Identify entity and relationships that implied by geocaching : Your task is to identify the entities and relationships that are implied by the geocaching cache page (see below). In effect, you will be analysing the structure of the database that supports the site.

Using datagrid in an application : Update the field named fldQuestionDescription.

User Account

All Pages