Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch06/ExcelShort43-49.xlsx
Use PV Function and spill a bond valuation formula across increasing YTM Rates to illustrate the inverse relationship between Bond Price and YTM Rate (Discount Rate).
Learn #excel #excelformulas #excelfunctions #npv #presentvalue #bonds #bondvaluation