Create a spreadsheet to price a 5 year and 10 year annual pay UST. Assume the coupon

Fantastic news! We've Found the answer you've been seeking!

Question:

Create a spreadsheet to price a 5 year and 10 year annual pay UST. Assume the coupon = 3.50%, and the yield to maturity (ytm) is 3.50%. Face Value = $1000

a. What is the price (present Value = PV) for both?

b. Now use a 4.50% ytm (i.e. a “100bp change in ytm) and recalculate. How much did the price (PV) of both bonds change in % terms?

Please show this work on Excel.

Related Book For answer-question

Engineering Economy

ISBN: 978-0132554909

15th edition

Authors: William G. Sullivan, Elin M. Wicks, C. Patrick Koelling

See More Books

Posted Date: May 30, 2023 06:10 AM

See More Questions

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...
KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...
In this problem, we want to create a spreadsheet to help someone estimate their income in retirement. To do this, we will have them enter several numbers: the amount of money currently in savings,...
Why are process control systems necessary? Give TWO examples of their usefulness within the plant.
Consider the plasma spray coating process of Problem 5.25. In addition to the prescribed conditions, the argon plasma jet is known to have a mean velocity of V = 400 m/s, while the initial velocity...
Which of the languages discussed in this chapter provide for some sort of goto statement? Does the goto statement affect performance? If so, how?
Here you will account for Sherman Lawn Services transactions as it is actually done in practice. Sherman Lawn Service completed the following transactions during August: Aug 1 Received $$1,000$ and...
Missoula Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by...
Question 3 Not checked Marked out of 3.00 Flag question Take me to the text Adrian's Restaurant is a 69-seat restaurant open every day for lunch and dinner. For the month of May, it plans to turn...
James Garage Ltd is a high end tire and rim sales company with installation and repair facilities. The following information can be obtained from the company's financial statements. James Garage Ltd...
What is the history of uniforms? When did people start to uniforms?
A dime is accidentally dropped from the top of the Tokyo Tower. The height, h, in meters of the dime above the ground at t seconds can be modelled by h(t) = -4.9t + 333 a) Determine the average rate...
Samantha is widowed and has three children who are young adults. She'd like to move assets to them over time without estate tax and without using her gift and estate tax exemption. She gives about...
Slinky received $500 interest from his bank throughout the year. Based on the above facts and relevant tax laws, Slinky needs to declare $500 in interest as assessable income?
Prepare a corpo The first step was for the two owners to form an LLC. The new company initially authorized 500,000 shares at a $1.00 par value per share. 1) In recognition of their development of the...
Let U (a, b, c, d, e, f, g, h, k, m}, A = {g, k, m), B = {b, k, m), and C = {b, d, e, f, h}. Find the following set. AU (BNC)
Suppose your expectations regarding the returns of Stock A and B are as follows: State of the economy Probability Return A Return B Boom ? 20% 10% Recession 40% -7% 1% If you decide to invest 80% in...
The Home Depot is the leading retailer in the home improvement industry and one of the 10largest retailers in the United States. The company included the following on its January 29, 2012, balance...
An electronics firm is planning to manufacture a new handheld gaming device for the preteen market. The data to the left have been estimated for the product. Assuming a negligible market (salvage)...
Storm doors have been installed on 50% of all homes in Anytown, USA. The remaining 50% of homeowners without storm doors think they may have a problem that a storm door could solve, but they're not...
Determine the value of W on the right-hand side of the accompanying diagram (see Figure P4-68) that makes the two cash-flow diagrams equivalent when i = 12% per year. 1,000$1.000 0. End of Year End...
The diameter, $d$, of bubbles produced by a bubble-making toy depends on the soapy water viscosity, $\mu$, density, $ho$, and surface tension, $\sigma$, the ring diameter, $D$, and the...
Choked-flow nozzles are often used to meter the flow of gases through piping systems. The mass flow rate of gas is thought to depend on nozzle area $A$, pressure $p$, and temperature $T$...
Spin plays an important role in the flight trajectory of golf, ping-pong, and tennis balls. Therefore, it is important to know the rate at which spin decreases for a ball in flight. The aerodynamic...

Create a spreadsheet to price a 5 year and 10 year annual pay UST. Assume the coupon

Question:

Expert Answer:

Heres how you can create a spreadsheet in Excel to calculate the price present value of a 5year and ... View the full answer

Engineering Economy

Students also viewed these finance questions