Good morning!Please help me learn how to do in excel if possible Laurel

Question

Good morning!

Please help me learn how to do in excel if possible.

Laurel,

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 – Excel
Sign in
X
File
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
Help
Tell me what you want to do
Share
Calibri
11
AA
al Wrap Text
Percentage
EX
E. AY O
Paste…

Finance