C.53% 11:51 PM Fri Dec 17 V, =c , Par Value (1+r)" Assignment 2 Due Oct 26, 2021 at 11:59 PM Midterm Availability: Closed Assignment 3 Due Dec 5, 2021 11:59 PM Inputs for the bond valuation (price) should include: par value (face value), coupon rate (for zero-coupon bonds, coupon rate-0), number of compounding periods per year, time to maturity in years, YTM (APR) Assignment 4 Due Dec 20, 2021 at 11:59 PM > 2. Use the solver function to solve for YTM given the bond price. If you do not see the "solver" in the "Data" tab. you need to add it as an "add-in" 3. The quoted bond prices are "clean prices" which do not include accrued interest. Build a separate function to calculate accrued interest, then calculate dirty price, Accrued interest days since last couponumber of days in the coupon period)" next coupon payment Dirty price clean price + accrued interest 4. Check to make sure that your bond price function works correctly using priceyield pairs for example: yield at offering and price at offering G Dashboard Calendar TO DO Notifications Inbox C.53% 11:51 PM Fri Dec 17 V, =c , Par Value (1+r)" Assignment 2 Due Oct 26, 2021 at 11:59 PM Midterm Availability: Closed Assignment 3 Due Dec 5, 2021 11:59 PM Inputs for the bond valuation (price) should include: par value (face value), coupon rate (for zero-coupon bonds, coupon rate-0), number of compounding periods per year, time to maturity in years, YTM (APR) Assignment 4 Due Dec 20, 2021 at 11:59 PM > 2. Use the solver function to solve for YTM given the bond price. If you do not see the "solver" in the "Data" tab. you need to add it as an "add-in" 3. The quoted bond prices are "clean prices" which do not include accrued interest. Build a separate function to calculate accrued interest, then calculate dirty price, Accrued interest days since last couponumber of days in the coupon period)" next coupon payment Dirty price clean price + accrued interest 4. Check to make sure that your bond price function works correctly using priceyield pairs for example: yield at offering and price at offering G Dashboard Calendar TO DO Notifications Inbox