Question: could you please follow the steps 2- Using excel calculate the duration of a Twenty -year bond with a face value of $1,000 and a

could you please follow the steps

2- Using excel calculate the duration of a Twenty -year bond with a face value of $1,000 and a coupon rate of 11%. Assume that the current interest rates are 9%. What will your answer be if the current interest rates fall to 8%? Show all your calculations. t CR FV t CF PV OFCF weight t*(pv of bond price 1 2 3 Total 0.00 0.0 0.00 3. Using the data provided in the previous problem, calculate the percentage change in price difference using the duration formula

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Assignment 3: Rates and Interest Rate Sensitivity Section 1: Duration and bond characteristics The texthonk (Bndie, Kane, \& Marcus, 2021) gives you a numher of rules regarding duration and bond...

Have Some questions on Excel that i would like answered, i am attaching the file. Question 1 Given the followng data, Calculate the YTM, YTC for year 4 and YTW between YTM and YTC(4) Insurance Date=...

Assignment 3: Rates and Interest Rate Sensitivity Section 1: Duration and bond characteristics The textbook (Bodie, Kane, & Marcus, 2021) gives you a number of rules regarding duration and bond...

You have been hired as a consultant by Fulton Life Insurance Company. Fulton specializes in the sale of Guaranteed Investment Contracts ( GICs ) which guarantee clients a specific dollar amount on a...

1. Assume today is 1 October 2011. You are an active bond portfolio manager and your portfolio currently comprises two bonds, A and B. Characteristics Bond A Bond B Face Value R1,000 R1,000 Coupon...

PLEASE SHOW WORK STEP BY STEP THAN YOU 17. An asset promises to pay the following: $60 each year for the next ten years: and $1,000 in ten years Assume all the cash flows are discounted by 6%. Use...

Hello my friend please assist me with my discussion Interest Rates Negotiation is a soft skill that might just be one of the most important skills you will ever learn. For this Discussion you will...

Use the following information for Delta Corporation to answer question 1: (20 marks total) 1. Delta has 600,000 common shares outstanding. The firm is projecting a 20% increase in net sales for the...

I need assistance with completing this homework assignment FI 389 Spring 2016 Cooper FI 389 Homework 4 1. A company has a dividend payout ratio of 40%. It is expected to earn $4.20 per share next...

Upload an Excel Workbook answers composed of 4 Worksheets entitled #1, #2, #3, and #4. 1. A two-year bond with par value $1,000 making annual coupon payments of $100 is priced at $1,000. What is the...

Randy works for a vending machine company. One morning, he fills up a vending machine that is on the third floor of an office building. Later that day, Mark buys a can of Pepsi from that machine. He...

Refer to the information for Alisha Incorporated on the previous page. However, now assume that Alisha produced 80,000 medical stints (rather than 150,000). Alisha Incorporated manufactures medical...

20.3 What is service discipline? Describe some forms of common service disciplines and illustrate with examples.

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

Does my outline offer a complete list of references for all of the research I cite in my speech?

Effective Delivery Effective

3. When creating the outline for your speech, write each main point on a separate index card. Spread the cards out on a table, and then pick them up in the most logical order. Does this order match...