Please post with mathematical formulas, not an excel
sheet
For Bond X,
As the present value of the Redemption amount (R) is 381.5,, we get the following equation
381.5 = R / (1+i)n, ( eq. 1) where i is the yield of Bond X as well as that of bond Y
For Bond Y, the redemption amount is the same i.e. R , so we get the equation as
647.80. = R/(1+i)(n/2) , (eq. 2)
Dividing equation 1 and 2, we get
381.5/647.8 = 1/ (1+i)(n/2) (eq. 3)
Substituting the above in equation 2, we get
647.8 = R* 381.5/647.8 which gives
R = 647.8*647.8/381.5 = 1099. 986 or apx. 1100
Taking R as 1100 , we now get the price(P) for Bond X as
P= present value of Cash flows of Bond X
P = 1000* (r/2)/ (1+i)0.5 + 1000*(r/2)/ (1+i)1+....+1000 * (r/2) /(1+i)n+ 1100/(1+i)n
where r= coupon rate of Bond X,
Here, there are 2n terms representing present value of 2n semiannual coupon payments and last term is present value of Redemption amount
By applying GP formula
P = 1000 *(r/2) * (1- (1+i)-n) / ((1+i)(1/2) -1) + 1100 * (1+i)-n
From equation 3, we know. (1+i)-(n/2) = 381.5/647.8 = 0.588916
So, (1+i)-n = 0.5889162= 0.346822
And Using the Binomial approximation ,
(1+i)(1/2)= 1+i/2+.... very small terms = 1+i/2
So, (1+i)(1/2)-1 = i/2
Substituting in the price equation we get
P = 1000 *(r/2) * (1-0.346822) / ( i/2) + 1100 * 0.346822
= 1000 * (r/i) * 0.653178 + 381.504
= 653.178 * 1.03125 + 381.504
= 1055.09 or appx. 1055
So, the price of the bond is 1055
Please post with mathematical formulas, not an excel sheet 5. You have decided to invest in two bonds. Bond X is an n-ye...
Please answer with mathematical formulas, not an excel sheet
please
3. John borrows an amount at an annual interest rate of 8%. He repays all interest and principal in a lump sum at the end of ten years John uses the amount borrowed to purchase a 5-year bond with a par value of 1000 with coupons at a nominal rate of 10% payable semiannually, with the first coupon paid at the end of 6-month period from now. The bond is...
You have a choice of two bonds X and Y. Bond X is a $1,000 par value30-year 8% semiannual coupon government bond selling at $920. Bond Y is a $1,000 par value 20-year 10% semiannual coupon corporate bond selling at $1,057. You believe that the yield curve for government securities will be flat after 5 years at 7.5% compounded semiannually, while that for the corporate bond Y will be 8.5% compounded semiannually after 5 years. If you can re-invest coupons...
please use excel coding
Bond X is a premium bond making semiannual payments. The bond pays a 9 percent coupon, has a YTM of 7 percent, and has 13 years to maturity. Bond Y is a discount bond making semiannual payments. This bond pays a 7 percent coupon, has a YTM of 9 percent, and also has 13 years to maturity. What is the dollar price of each bond today? If interest rates remain unchanged, what do you expect the...
Course: Theory of Interest (Actuarial Science) Chapter: Bonds Problem: An n-year zero coupon bond with a par value of $1,000 was purchased for $600. A 2n-year $1000 par value bond with annual coupons of $X was purchased for $850. A 3n-year $1000 part value bond with annual coupons of $X was purchased for $P. All 3 bonds have the same yield rate. Compute P. (Hint: Use zero-coupon bond to find the value of v^n. Use the second bond to solve...
please show work in excel formula, Thanks
N Chamberlain Co. wants to issue new 20-year bonds for some much-needed expansion projects. The company currently has 7 percent coupon bonds on the market that sell for $1,083, make semiannual payments, and mature in 20 years. What coupon rate should the company set on its new bonds if it wants them to sell at par? 1/1/2000 1/1/2020 Settlement date Maturity date Annual coupon rate Coupons per year Redemption value (% of par)...
PLEASE WRITE THE ANSWER AS A
EXCEL FORMULA
X 5 Calculating a bond price - Excel ? X = INSERT - Sign In FILE HOME PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri 11 AA - A Paste B IU Alignment Number Cells Editing 5.12 oints Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Skipped A1 AB E F G H eBook Print Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.9...
You are given the following: Bond 1 Bond 2 Coupon rate of 4%, payable semi-annually Coupon rate of 8%, payable quarterly Effective annual yield rate is 5% Effective annual yield rate is X 20 years bond 10 years bond Redemption Value is $100 Redemption Value is $100 Price is $Y Price is $Y Find X 0.0500 0.075 0.0975 0.1200 0.1025
MUST BE DONE ON EXCEL USING EXCEL FORMULAS
2) You are looking at a bond with 13 years to maturity, has a coupon rate of 4% paid semi- annually, and a price of 105. What is the Yield to Maturity of the bond?
8. You have just received an inheritance of $20,000. You wish to invest in fixed income securities such as bonds, which you think are less risky than stocks. After some research, you have narrowed down your choices to the following three fixed income securities: One-year Treasury Bill: Face value of $1000 Yield to maturity of 1.74% Coupon Bond A: Two years to maturity Face value of $1000 Coupon rate of 3%, with semi-annual coupon payments Price multiple of face value...
6. Bond Valuation A BBB-rated corporate bond has a yield to maturity of 9%. AU.S. Treasury security has a yield to maturity of 7.5% These yields are quoted as APRS with semiannual compounding. Both bonds pay semiannual coupons at an annual rate of 8.4% and have five years to maturity a. What is the price (expressed as a percentage of the face value) of the Treasury bond? b. What is the price (expressed as a percentage of the face value)...