Question: For a bond with information defined in the table below. Please perform the following calculations: (8 points) Map out the cash flows as a function

  1. For a bond with information defined in the table below. Please perform the following calculations: (8 points)
    1. Map out the cash flows as a function of years into the future in Excel, calculate the discount factor (using YTM) for each of the cash flow
    2. Calculate the present value of each of the cash flows and the price of the bond based on PV of the all of the cash flows
    3. Calculate the price of the bond using a different way: the PRICE function in Excel and confirm you obtained the same price as in step b
    4. For the same bond in prob, assuming the new yield of the bond one year from today is 4%. Perform the following calculations: (5 points)
      1. Calculate the new price of the bond, using the Price function in Excel. (Ignore the fact one year later this bond is only a four year bond)
      2. Calculate the price return of the bond and the income of the bond (using original YTM)
      3. Calculate the 1 year total return of the bond
settlement 11/19/2021 Maturity 11/19/2026
Yield to Maturity Coupon Principal
3.00% 3.50% $ 100
Compounding Freq 2.0

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!

Q:

1 What are the main components of personal financial planning? Solve What is the purpose of a financial plan? Solve Identify some common actions taken to achieve financial goals. How does a job...

Q:

Question: What as the average weekly safety inventory level of refined sugar from the beginning January 2022 to the end of July 2022? A. 512,465.9691 metric tons per week B. 316,002.1474 metric tons...

Q:

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

Q:

Elena, a student in F-1 immigration status from Romania, is on the basketball team. She arrived in the U.S. on June 18, 2023 on a full athletic scholarship that includes $10,000 for her room and...

Q:

Lopez Chemical Inc. requires 20,000 gallons of material annually; the cost of placing an order is $20; the annual carrying cost per gallon is $5. Required: Determine the EOQ from potential order...

Q:

Find an appropriate graphing software viewing window for the given function and use it to display its graph. The window should give a picture of the overall behavior of the function. There is more...

Q:

=+Portfolio A $180,000 $50,000 Portfolio B $120,000 $20,000 M23_SHAR8696_03_SE_C23.indd 855 14/07/14 8:05 AM 856 CHAPTER 23 Decision Making and Risk a) Compute the EV for each alternative decision....

Q:

The amounts of the assets and liabilities of Nordic Travel Agency at December 31, 2016, the end of the year, and its revenue and expenses for the year follow. The retained earnings were $600,000 on...

Q:

Make T- accounts and fill them in for the transactiond Foot and balance your T- accounts Farm Equipment inc produces tractors and other farm machinery. Each piece of equipment is built to customer...

Q:

For this assignment, prepare a 5- 7-page strategic performance improvement plan. Include the following: Briefly explain your organization's: Vision Mission Goals Define quality. Define the problem:...

Q:

make small summary of it "1. Implementation of Comprehensive Rehabilitation Programs Both the United States and Norway have unique approaches to prisoner rehabilitation. Norway's approach, which...

Q:

What is the purpose of a retaining wall, and how is it designed?

Q:

How do you determine the load-bearing capacity of a soil?

Q:

what is Edward Lemieux effect / Anomeric effect ?

Q:

Define Management by exception

Q:

Healthsouth Company is considering leasing a new equipment. The lease lasts for 8 years. The lease calls for 8 payments of $111,000 per year with the first payment occurring immediately. The...

Q:

The liquidliquid extractor in Figure 8.1 operates at 100F and a nominal pressure of 15 psia. For the feed and solvent flows shown, determine the number of equilibrium stages to extract 99.5% of the...

Q:

13.52 Cancer prediction A breast cancer study at a city hospital in New York used logistic regression to predict the probability that a female has breast cancer. One explanatory variable was x =...

Q:

13.47 House size and garage interact? Refer to the previous exercise. a. Explain what the no interaction assumption means for this model. b. Sketch a hypothetical scatter diagram, showing points...

Q:

13.45 Predicting pizza sales A chain restaurant that specializes in selling pizza wants to analyze how y = sales for a customer (the total amount spent by a customer on food and beverage, in pounds)...