the first two attachments are examples the third one is the spreadsheet that nee

the first two attachments are examples the third one is the spreadsheet that need to be filled out. based on the hw belowComplete the following problems. For assistance you may want to refer to these examples. The Excel spreadsheet shows the calculations for the problems listed in the Word document.Required: Download the Week 08 Problems Excel spreadsheetto use in completing your problems.If comparable yields are 9 percent what should be the price of each preferred stock? A convertible bond has the following features:$1000Maturity date20 yearsInterest$80 (8% coupon) paid yearlyCall price $1050Exercise price$65 a share