Please help me learn how to do in excel if possible.
Inc., and Hardy Corp. both have 6 percent coupon bonds outstanding, with semiannual interest payments, and both are priced at par value. The Laurel, Inc., bond has five years to maturity, whereas the Hardy Corp. bond has 18 years to maturity.
If interest rates suddenly rise by 2 percent, what is the percentage change in the price of these bonds? (A negative answer should be indicated by a minus sign. AutoSave (. off )Book1 – ExcelSign inXFileHomeInsertDrawPage LayoutFormulasDataReviewViewHelpTell me what you want to doShareCalibri11AAal Wrap TextPercentageEXE. AY OPaste…