SECTION B: Boeing has an outstanding bond that paid quarterly interest with an annual coupon of 4.25%, with a yield to maturity required rate of return) of 3 85% and a maturity date of February 22, 2031 Build a spreadsheet that calculates the corred price for their home nusing a combination of the present value of a dollar and the present value of an annan formalas caring that the bond- pricing model is flexible mnough to automatically calculate the band price for any changes to wield.coupon, or maturity 1) What is the price (as a percentage of principal of the bond with a settlement date of February 22.2021If the yield required rate of return of this bood goes up 75 basis points what would the new price be? Tip: Usually, coupons or interest on most boods are paid twice a year (every six months), but sometimes they pay quarterly everythree months). In the case of a quarterly pay bond, because one-fourth of the coupon rate is paid every tree months, a bond with a coupou rate of 5.00% would receive 1.25% of par every period. In order to take the compounding into effect when using this method in present vahe calculations, the time period is sometimes as long and the payment is one- fourth as much as the annual coupon payment Although bonds typically have a par value of 1,000, they are priced based on a par value of 100 (ie. 100% of the value of the outstanding principal. or 100 cents on the dollar). The formula to calculate the present value of a bond is given below. Adjustments sometimes need to be made for partial periods. The right portion of the Fermula sbould to be recreated in Excel in order to complete part of the bomewerk. You are solving for two individual values, the present value of an annuity and the present value of the terminal repayment of the principal amount M colunt, M pv - Eary (1+r) Where number of periods C-semi-annual coupon payment r-semi-annual discount rate (yield divided by 2) M-maturity value (Par value) 1-time period when payment is to be received Note that this formamia assumes payments are received at the end of the period. To complete the calculation given in the above formula you will need to determine the quarterly coupon amount, the number of three-month periods until bond maturity assume that we are holding the bond for exactly 10 years), the discount rate taken from the yield to maturity), and the terminal payment for the bond 8.6.1 SECTION B: Boeing has an outstanding bond that paid quarterly interest with an annual coupon of 4.25%, with a yield to maturity required rate of return) of 3 85% and a maturity date of February 22, 2031 Build a spreadsheet that calculates the corred price for their home nusing a combination of the present value of a dollar and the present value of an annan formalas caring that the bond- pricing model is flexible mnough to automatically calculate the band price for any changes to wield.coupon, or maturity 1) What is the price (as a percentage of principal of the bond with a settlement date of February 22.2021If the yield required rate of return of this bood goes up 75 basis points what would the new price be? Tip: Usually, coupons or interest on most boods are paid twice a year (every six months), but sometimes they pay quarterly everythree months). In the case of a quarterly pay bond, because one-fourth of the coupon rate is paid every tree months, a bond with a coupou rate of 5.00% would receive 1.25% of par every period. In order to take the compounding into effect when using this method in present vahe calculations, the time period is sometimes as long and the payment is one- fourth as much as the annual coupon payment Although bonds typically have a par value of 1,000, they are priced based on a par value of 100 (ie. 100% of the value of the outstanding principal. or 100 cents on the dollar). The formula to calculate the present value of a bond is given below. Adjustments sometimes need to be made for partial periods. The right portion of the Fermula sbould to be recreated in Excel in order to complete part of the bomewerk. You are solving for two individual values, the present value of an annuity and the present value of the terminal repayment of the principal amount M colunt, M pv - Eary (1+r) Where number of periods C-semi-annual coupon payment r-semi-annual discount rate (yield divided by 2) M-maturity value (Par value) 1-time period when payment is to be received Note that this formamia assumes payments are received at the end of the period. To complete the calculation given in the above formula you will need to determine the quarterly coupon amount, the number of three-month periods until bond maturity assume that we are holding the bond for exactly 10 years), the discount rate taken from the yield to maturity), and the terminal payment for the bond 8.6.1
