Calculate the duration

Assignment Help Financial Management
Reference no: EM131667720

Financial Institutions/Money Project - Duration

Part 1: Duration and Coupon Interest

Consider a five-year $1,000 face value, Treasury bond with a 10 yield to maturity selling at par. 

A) Calculate the duration if the semiannual coupon is 10%.

B) Calculate the duration if the semiannual coupon is 12%.

C) Calculate the duration if the semiannual coupon is 14%.

D) Plot the relationship between coupon interest rate (x-axis) and the duration (y-axis). Be sure to label the y-axis, x-axis, and chart title.

In your report, identify and comment on the relationship between duration and coupon interest rate.

Part 2: Duration and Rate of Return

Consider a five-year $1,000 face value, Treasury bond with a 10 percent semiannual coupon selling at par. 

E) Calculate the duration if the yield to maturity is 10%.

F) Calculate the duration if the yield to maturity is 12%.

G) Calculate the duration if the yield to maturity is 14%.

H) Plot the relationship between yield to maturity (x-axis) and the duration (y-axis). Be sure to label the y-axis, x-axis, and chart title.

In your report, identify and comment on the relationship between duration and yield to maturity.

Part 3: Duration and Maturity

Consider a $1,000 face value, Treasury bond with a 10 percent semiannual coupon selling at par with a 10 percent yield to maturity. 

I) Calculate the duration if the maturity is in five years.

J) Calculate the duration if the maturity is in four years.

K) Calculate the duration if the maturity is in three years.  

L) Plot the relationship between maturity (x-axis) and the duration (y-axis). Be sure to label the y-axis, x-axis, and chart title.

In your report, identify and comment on the relationship between duration and maturity.

Attachment:- Assignment.rar

Reference no: EM131667720

Questions Cloud

Describe the changes to medicare : Describe the changes to Medicare that are direct results of the Patient Protection and Affordable Care Act of 2010.
Describe the interprofessional leadership : Significance of the topic (based on literature that speaks to the relevancy of the concept selected in terms of interprofessional leadership)
Find significant difference in the golden ratio calculation : Thirty-seven early works were sampled, averaging 1.74 with a standard deviation of 0.11. Sixty-five of the later works were sampled, averaging 1.746.
Develops an account of virtue based on the given idea : Develops an account of virtue based on the idea that such traits of character and thought are means between two extremes.
Calculate the duration : FINC 6362 - Financial Institutions/Money Project - Duration. Consider a five-year $1,000 face value, Treasury bond with a 10 yield to maturity selling at par.
What disasters may strike your community and why : write a 3- to 4-page paper about the disaster from the community nurse's perspective.What disasters may strike your community and why?
Write an essay in which the writer encourages the reader : Write a Persuasive essay in which the writer encourages the reader to give in some way to a worthy cause.
Most entrepreneurial ventures need to raise money : "There are three reasons that most entrepreneurial ventures need to raise money during their early life-cash flow challenges,
Find the percent of hispanic students at the two colleges : In general, do you think that the percent of Hispanic students at the two colleges is basically the same or different?

Reviews

len1667720

10/3/2017 6:30:32 AM

Topic: Financial Institutions and Markets. The goal of this project is to explore the topic of duration. The project requires you to work in Excel with the provided spreadsheet. Be sure to fill in the yellow boxes in the Excel file and follow all instructions for full credit. In addition, type up a 1-2 page report in Word with a separate section for the introduction (description of the project), findings (answer assignment questions, plots, etc.), and conclusion (summary). Upon completion, please submit both your Word report and Excel file to blackboard. This is an individual project so be sure to submit your own work. Each question (A, B, C, D, E, F, G, H, I, J, K, and L) is worth 5 points (total of 60 points), the report 10 points, and the Excel file 5 points.

Write a Review

Financial Management Questions & Answers

  Suppose that the exchange rate

Suppose that the exchange rate is 1 dollar for 120 Yen. The dollar interest rate is 5%(continuously compounded) and the yen rate is 1%(continuously compounded). Consider an at the money American dollar call that is yen-denominated. What is the price ..

  Contract on portfolio tracking the nasdaq composite index

What is the forward price on a 1-year contract on a portfolio tracking the NASDAQ composite index,

  What is the current value of preferred stock

What was the original issue price? What is the current value of this preferred stock?

  High variable operating costs can be described as having

Firms with relatively low fixed operating costs and high variable operating costs can best be described as having:

  Day sales in inventoy-pressing customers to pay bills faster

Ruth Company currently has $2,000,000 in accounts receivable and $1,000,000 in inventories. Due to advancement in production technology, its day’s sales in inventory (DSI) is going to decrease from 45 to 30 over the following year. In turn, Ruth co. ..

  What is the present value of the annuity

A 10-year annuity pays $2,150 per month, and payments are made at the end of each month. If the interest rate is 12 percent compounded monthly for the first five years, and 8 percent compounded monthly thereafter, what is the present value of the ann..

  Target capitol structure-cost of common equity

Patton Paints Corporation has a target capitol structure of 60% debt and 40% common equity, with no preferred stock. It's before-tax cost of debt is 12% and it's marginal tax rate is 40%. The current stock price is $22.50. The last dividend was D0=$2..

  Comes closest to the bonds yield to maturity

Which of the following comes closest to the bond's yield to maturity?

  How much will you have in the account in six years

Fowler Credit Bank is offering 6.1 percent compounded daily on its savings accounts. You deposit $4,500 today. How much will you have in the account in 6 years? How much will you have in the account in 18 years?

  What is the expected return of intel stock

What is the expected return of Intel stock? What is the expected return of Boeing stock?

  The divdend is expected to increase

ABC Inc. is ecpected to pay anual dividend of .85$ and 1.25$ and 1.75$ a share over the next three years, respectively. after that, the divdend is expected to increase by 1% anually what is 1 share of stock worth today if similar stocks are yeilding ..

  What is the cross-rate in terms of yen per pound

Suppose the Japanese yen exchange rate is ¥75 = $1, and the British pound exchange rate is £1 = $1.54. What is the cross-rate in terms of yen per pound?

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