Question

REVIEW Supra ing DATA VIEW FORMULAS HOME INSERT PAGE LAYOUT B I U - 99 - A. Alignment Number Conditional Format Formatting" Custome Quick Access Toolbar Show Quick Access Toolbar Below the Ribbon Customize the boon Collapse the Ribbon Chamberlain Co. wants to issue new 20-year bonds for some much-needed expansion projects The company currently has 7 percent coupon bonds on the market that sell for $1.083, make semiannual payments, and mature in 20 years. What coupon rate should the company set on its new bonds if it wants them to sell at par? 1/1/2000 1/1/2020 Settlement date Maturity date Annual coupon rate Coupons per year Redemption value % of par) Bond price (% of pan) 100 1083 Complete the following analysis. Do not hard code values in your calculations. Leave the "Basis" input blank in the function. You must use the built-in Excel function to answer the bond price questions. Yield to maturity PMT(08.09 D10 D11 100 Sheet1

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

WE HAVE TO USE HERE "YIELD" EXCEL FUNCTION

BOND - Microsoft Excel (Product Activation Failed) Add-Ins View - 2x Dr General Wrap Text Merge & Center - Σ AutoSum : A Fill 2 Sort & $ -% . File Home Insert Page Layout Formulas Data Review % Cut Calibri -11AA = = = Ea Copy Paste Format Painter B I U B- A Clipboard Font 019 - for _ A B C D Formatting as Table Styles Styles 2 Clear Filter Editing Find & Select Alignment Number Cells E F G H I J K L M N O 01-01-2000 01-01-2020 7.00% SETTLEMENT DATE MATURITY DATE COUPON RATE COUPONS PER YEAR PAR VALUE PRICE 100 108.3 11 12. COMPLETE THE ANALYSIS 14 15 16 YIELD TO MATURITY 6.2663% (=YIELD(D6,D7,D8, D11,D10,09)] 17 18 19 20 21 H N WARRANT refund 54 55 56 57 58 59 S11 Sheet12 Sheet13 S14 Sheet15 516 Sheet17 Sheet18 Sheet19 LP, IP, MRP, INFLATION ferences Rea Sheet1 Sheet3 00 BO! 120% - -_ + * OENG 06-11-2019 EJER