Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch06/ExcelShort43-49.xlsx
Create table of bond values with PV Function and see that lower coupon bonds will have bond price more affected by changes in Yield To Maturity (YTM) than higher coupon bonds.
Learn #excel #excelformulas #excelfunctions
#bondvaluation #pvfunction #presentvalue