Using Excel, find the daily full and flat prices for the following bond between the issue and maturitydates. Plot full and flat prices in the same graph where the vertical axis is price and horizontal axis isdate. Assume a day count convention of 30/360 (European) and a face value of $100.Issue Date: 02/11/2016Maturity Date: 02/11/2021Coupon Rate: 8%Coupon Frequency: Semi-annualYield-to-Maturity: 10%The Excel functions needed: PRICE, COUPPCD, COUPNCD, ACCRINTFor the bond described above, manually compute the flat price, accrued interest, and full price forsettlement date of 05/20/2019. Please show your work. Compare your results with those fromExcel.

Given Face value =$100 Coupon rate = 8% p.a. Semi annual interest rate=8%×12=4% Number of days in a…

Answered: Using Excel, find the daily full and…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

There are three bonds that mature at the same time, have the same par value, and are expected to pay their first annual coupon 1 next year. The bonds are detailed in the below table. Bond A B с PV PV PV Present Value B ? ? ? PV B If ca r, then what can we say about the prices of the bonds today? (Enter >, <, or ?) PV C PV Yield to Maturity C r rb Coupon Rate ca с с
Submit your solutions as an Excel document. Be sure to clearly label the various parts of the problem. 1. Consider the following two bonds that make semi - annual coupon payments. Assume the first coupon payment occurs in exactly six months, and the bond has a face value of $1000. Coupon Rate Time to Maturity YTM Bond A 3.80% 8 years 3.6% Bond B 3.80% 18 years 4.2% a.) What is the current price (t = 0) of Bond A? Be sure to set up the valuation equation. b.) What will be the price of Bond A exactly halfway in between t = 0 and the first coupon date? c.) Using a spreadsheet, plot the price - yield relationship for both Bond A and Bond B on the same set of axes. Do this for a range of yields from 2% to 11% (in increments of 50 basis points). d.) Use a spreadsheet to compute the annualized Macaulay duration and modified duration for Bond A at a yield - to - maturity of 3.6%. Provide an interpretation of the modified duration with regards to maturity and interest rate risk. e.) Use a…
Calculate the purchase price of the following bonds. Indicate whether the bonds are priced at a discount, at par or at a premium. Give your answers in dollars and cents to the nearest cent. Face Value Coupon Rate Years to Maturity Market Rate a) $100 r = 6.75% 5 j2 = 6.75% b) $1,000 r = 8% 11 j2 = 6.25% c) $10,000 r = 7% 20 j2 = 8.75% Quoted coupon rates and market rates are nominal annual rates compounded semi-annually. a)Price = $ This bond is priced at:a discountpara premium b)Price = $ This bond is priced at:a discountpara premium c)Price = $ This bond is priced at:a discountpara premium
Conceptual Overview: Explore the value of fixed-interest coupon bonds of different terms. This graph shows the value of 10% coupon bonds of different terms across differing market interest rates. Each bond pays INT = $100 at the end of each year and returns M = $1,000 at maturity. For comparison, the blue line depicts the value of a one-year bond. The term of the other bond in years may be changed using the slider. Drag on the graph to change the current market interest rate (rd) at which the bond (orange curve) is evaluated. ∑ t = 1 Y r s I N T ( 1 + r d ) + M ( 1 + r d ) = ∑ t = 1 1 5 $ 1 0 0 ( 1 + 0 . 1 0 0 ) + $ 1 0 0 0 ( 1 + 0 . 1 0 0 ) = 1 , 0 0 0 ∑ t=1 Yrs (1+r d ) t INT + (1+r d ) Yrs M =∑ t=1 15 (1+0.100) t $100 + (1+0.100) 15 $1000 =1,000 ∑t=1Yrs(1+rd)tINT+(1+rd)YrsM=∑t=115(1+0.000)t$100+(1+0.000)15$1000=2,500. 1. What is the value of a 15-year 10% $1,000 coupon bond when the market interest rate is 15%? $421$708$1,000$1,5192. What is the value of a 12-year 10% $1,000…
What are the Modified Duration and Macaulay Duration of the following bond? Coupon Rate = 8% (Semi-annually paid) YTM = 9% Maturity = 2 Years Par Value = 1,000 (Hint: this question is similar to Example 1 and Example 2 on slides) ModD = 1.886 and MacD = 1.805 ModD = 1.784 and MacD = 1.954 ModD = 1.954 and MacD = 1.784 ModD = 1.805 and MacD = 1.886
A Treasury bond with the longest maturity (30 years) has an ask price quoted at 101.9375. The coupon rate is 4.10 percent, paid semiannually. What is the yield to maturity of this bond? Note: Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. Yield to maturity %
Suppose you are given the following information about the default- free, coupon-paying yield curve: maturity (years) 1 Coupon rate (annual payments) 0% YTM 2 10% 3.000% 4.908% 3 6% 6.840% Use arbitrage to determine the yield to maturity of a two-year and three year zero-coupon bond . (express in percentages, round to whole percentage)
Consider the characteristics of two annual pay bonds from the same issuer with the same priority in the event of default: You also observe the following spot interest rates from the current yield curve: Par value Coupons Maturity Coupon rate Yield to maturity Price Bond A $100 Annual 3 yrs 8% 10.25% 94.43 1 2 3 Bond B $100 Annual 3 yrs 4% 10.35% 84.31 Term (yrs) Spot Rates (zero coupon, %) 4% 7 10 Neither bond's price is consistent with the spot rates. Using the information in these displays, recommend either Bond A or Bond B for purchase. Justify your choice. Do not round intermediate calculations. Round your answers to the nearest cent. The non-arbitrage price of Bond A: $ The non-arbitrage price of Bond B: $ -Select- ✓ appears to be the better purchase.
4. Calculate the Macauley Duration of your Bond at the given Yield-To-Maturity. Bond Pricing Date Annual Coupon Rate Number Coupons per year Maturity Date Yield Par Value Currency Treasury 22-Oct-20 1.625% 2 22-Oct-28 2.00% 1,000,000 GBP
A corporate bond with a coupon rate of 6% pays interest semiannually and has a maturity date of May 28, 2030. The trade settles on March 20, 2023. The yield to maturity is 13%. What is the flat (or clean) price of the bond (in percent of par) on the settlement date? Use Excel's PRICE() function. Dates must be entered with Excel's DATE() function.
You are given the following expected 1-year rates for each of the next 5 years and the cash flows for Bond A (assume that it pays an annual coupon). Based on this information, determine the yield-to- maturity for Bond A. Year 1 23 3 4 5 7.17% 6.80% O 7.54% O6.43 % O 7.91% Expected 1-Year Rate 9.00% 8.00% 7.00% 6.00% 5.00% Bond A Cash Flow $ 100.00 $ 100.00 $ 100.00 $ 100.00 $1,100.00 4
Suppose you observe the following effective annual zero-coupon bond yields: 0.030 (1-year), 0.035 (2-year), 0.040 (3-year), 0.045 (4-year), 0.050 (5-year). For each maturity year compute the zero-coupon bond prices, continuously compounded zero-coupon bond yields, the par coupon rate, and the 1-year implied forward rate. Show work and discuss your result. Briefly discuss who uses Zero coupon bonds and why?

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS