Calibri 11 B A1 X fx Accessibility tab summary: Students please use the B C D Dani Corp. has 5.5 million shares of common stock outstanding. The current share price is $83, and the book value per share is $5. The company also has two bond issues outstanding. The first bond issue has a face value of $80 million, a coupon rate of 5.5 percent, and sells for 109 percent of par. The second issue has a face value of $45 million, a coupon rate of 5.8 percent, and sells for 108 percent of par. The first issue matures in 21 years, the second in 6 years. Both bonds make semiannual coupon payments. a. What are the company's capital structure weights on a book value basis? b. What are the company's capital structure weights on a market value basis? 4 Input Area: 5 6 Shares outstanding 5,500,000 7 $83 $5 $80,000,000 5.50% 109 100 1/1/2020 1/1/194 2 23 > Market price per share 8 Book value per share 9 Bond I 10 Book value 11 Coupon rate 12 Bond price (% of par) 3 Redemption (% of par) 4 Settlement date 5 Maturity date 6 7 Payments per year DanLu A Graded Worksheet X fx Accessibility tab summary: Students please use the A B C D Input Area: Shares outstanding 5,500,000 Market price per share $83 Book value per share $5 Bond I Book value $80,000,000 Coupon rate 5.50% 109 Bond price (% of par) Redemption (% of par) 100 Settlement date 1/1/2020 Maturity date 1/1/1941 Payments per year 2 Bond II Book value $45,000,000 Coupon rate 5.80% Bond price (% of par) 108 Redemption (% of par) 100 Settlement date 1/1/2020 Maturity date 1/1/2026 Payments per year 2 (Use cells A6 to B24 from the given information to complete this question. You may e constant as a hard coded value.) 1 fx Accessibility tab summary: Students please use the A B C D D Tviaturity bate 1/1/2020 2 Payments per year 5 (Use cells A6 to B24 from the given information to complete this question. You may 5 constant as a hard coded value.) 3 Output Area: ( Book value of equity Book calue of debt Market value of company Book value weight of equity Book value weight of debt Market value of equity Market value of debt Total market value of company Market value weight of equity Market value weight of debt Students: The scratchpad area is for you to do any additional work you need to solve Nothing in this area will be graded, but it will be submitted with your assignment. +