🔎 Using EXCEL for bond price, YTM, coupon rate, and semiannual coupon problems

Excel Examples - Spreadsheet

There are two additional tabs that includes examples of how to calculate bond price and yield when the coupons are paid semiannually. While the topic is interesting, you are only responsible for what Bruce covers in lecture.