Question: please include cell references -3 Calculate the price and Duration of a 5 Year, Semiannual Bond with a Coupon Rate of 5% and an Annual

please include cell references

-3 Calculate the price and Duration of a 5 Year, Semiannual Bond with a Coupon Rate of 5% and an Annual Yield To Maturity of 6% with a Face Value of $1000, Use January 1, 2021 as the settlement date 1 2 7. Calculate the price of the Bond 3 Bond Descripton Bond Data 4 Bond's Face Value 5 Bond's Settlement Date 6 Bond's Maturity Date 7 Annual Coupon Rate 8 Annual Yield To Maturity 9 Coupon Payment Frequency 10 Basis (Calendar Days For Accrual) 11 Price 12 13 14 8. Calculate the Macaulay Duration of the Bond using period cash flow detail 15 Period Cash Flow Discount Factor DCF Duration CF 16 17 18 19 18 2 19 20 21 22 23 24 25 26 27 28 Periods 29 30 Duration Numerator 31 32 Price 33 34 Macaulay Duration 35 9. Calculate the Modified Duration of the bond 36 Modified Duration 37 3

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!

When Molly Lai purchased the Clean Clothes Corner Laundry, she thought that because it was in a good location near several high-income neighborhoods, she would automatically generate good business if...

1. The price of a 20-year coupon bond, coupon rate 7% p.a., yield to maturity 6% p.a., face value of $100 is closest to (assuming semi-annual compounding) Questions 2, 3, 4, 5 and 6 refer to the...

i. Assume current market yield is flat at 6.5% p.a. Calculate the duration gap of the bank. ii. Using the duration gap estimated from question i, what will happen to the net worth of the bank if the...

1.For a portfolio of 40 randomly selected stocks, which of the following is most likely to be true? The riskiness of the portfolio is greater than the riskiness of each of the stocks if each was held...

Question 4 (25 Marks) Jasmine Corporation has been presented with an investment opportunity that will yield cash flows of $30,000 per year in Years 1 through 4, $35,000 per year in Years 5 through 9,...

Please answer the following questions given the table above. PART B The following is the balance sheet of a VRY-SMPL Bank. All the items are recorded based on the book value and they were purchased...

The following is the balance sheet of a VRY-SMPL Bank. All the items are recorded based on the book value and they were purchased at par value . Asset Liability 5 year semi-annual 6.45%pa coupon 250...

4a Calculate the price and duration of a 2-year 7% coupon bond if the market rate of interest is 1 1%. (12 pts) 4b. If interest rate rise by 1%, calculate the price change in the above bond. (6 pts)...

Q1 DataPoint Engineering is considering the purchase of a new piece of equipment for $220,000. It has an eight-year midpoint of its asset depreciation range (ADR). It will require an additional...

PART B The following is the balance sheet of a VRYSMPL Bank. All the items are recorded based on the book vaiue and they were purchased at par value. Asset Liability 5 year semi-annual 6.45%pa coupon...

The questions please. Thank you! Use the information below to manage Best Bank's balance sheet portfolio. Additional Information: a. The bank plans on giving out some part of the building for rent...

If you are using data mining to develop a prospecting program for a client, what would you be trying to accomplish?

Income statements for Munoz Company for Year 3 and Year 4 follow MUNOZ COMPANY Income Statements Sales Cost of goods sold Selling expenses Administrative expenses Interest expense Total expenses...

Which of the following statements is least likely to is least likely to be incorrect? Question 6Answer a. Leveraged loans have a higher recovery rate than high yield bonds. b. High yield bonds and...

What is the main characteristic of a dynamic programming algorithm? a ) It divides the problem into smaller subproblems b ) It solves problems by trial and error c ) It optimizes the solution by...