Calculate the price of an AA-rated, 20-year, 8% coupon (paid annually) corporate bond ( Par value =$1,000) which is expected to earn a yield to maturity of 10%. a. Use the timeline to illustrate the cashflows: b. PLUG IN NUMBERS IN THE FORMULA Price of bond = Present Value of coupons + Present Value of par value Present Value of annual coupons =PMT(r1(1+r)n1) Present Value of Par Value =FV(1+r)n1 c. WRITE THE KEYS YOU ENTER IN THE BA-II FINANCIAL CALCULATOR d. WRITE THE EXCEL FORMULA AND ARGUMENTS Calculate the price of an AA-rated, 20-year, 8% coupon (paid annually) corporate bond ( Par value =$1,000) which is expected to earn a yield to maturity of 10%. a. Use the timeline to illustrate the cashflows: b. PLUG IN NUMBERS IN THE FORMULA Price of bond = Present Value of coupons + Present Value of par value Present Value of annual coupons =PMT(r1(1+r)n1) Present Value of Par Value =FV(1+r)n1 c. WRITE THE KEYS YOU ENTER IN THE BA-II FINANCIAL CALCULATOR d. WRITE THE EXCEL FORMULA AND ARGUMENTS