_OOZIEI E. Calculate the value of the bond's most recent coupon date using the PV and ROUNDUP functions . C. Compute the invoice price* D. Calculate the accrued interest portion of the invoice price* E . . Calculate the quoted price of the bond using the invoice Price from part C and accrued interest from part 1) F . . TENET Your answer to part E br using the PRICE Function to calculate the bond's quoted PRICE . 4 . I'sing the information provided for bond : }, I, and I perform the Following For each bond : A. I'VE the PRICE Function and the required rate of return to calculate the intrinsic Value. E. Compare the price and intrinsic value using an IF Function that identifies whether the bond is undervalued , overvalued, or correctly valued . C. Calculate the Yield to maturity using the FIELD function and the current price of the bond. D. For the Treasury bill , calculate the bank discount rate using the DISC Function and the bond Equivalent Yield using the FIELDDISC Function . E. For the Treasury bill , calculate the bank discount rate and bond Equivalent Yield using formulas . } . I'VE the information provided to complete parts A through E A. Calculate the price of the bond . B. Calculate the bond's modified duration . {`. Suppose that the wield to maturity of the bond increase ; by 1 80 basis points , i.E. 1. 8 percentage points . Calculate the actual dollar and percentage amounts by which the bond's price changes` D. Given the 1 80 - basis - point increase in yield to maturity , use duration to estimate the percentage and dollar changes in the bond's price* E. Create a Scatter chart with smooth line ; to show the relationship between bond price and wield . When calculating prices , use a range in field of 19/6 to 15%/0. [Note : A data table can* Facilitate the calculation of the price - field combinations ) . Include a chart title and aris titles. Add a second data series to represent prices Estimated using duration . The formula for calculating the estimated price is` Estimated price = Po - ( Modified duration ) . AV . PO