I. Use the information provided to complete parts A through H: :1. Calculate the number of semiannual periods to maturity using the YEARFEAC function. E. Calculate the value on the bondis most recent coupon date using the P? and RDUNDUP 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 Eons part C and accrued interest from part D. F. verify your answer to part E. tr}; using the PRICE. function to calculate the hond's quoted price. [3. For the Treasury bill, calculate the hanls discount rate using the DISC function H. For the Treasury hill: calculate the bond equivalent Field using the YIELDDISC function