please help with Excel solution!

I really want 1st and 2nd questions asap!

this is my only remaining chance to upload question:(

please answer all you can! with EXCEL solution!

Caspian Sea Drinks needs to raise $30.00 million by issuing bonds. It plans to issue a 18.00 year semi-annual pay bond that has a coupon rate of 5.15%. The yield to maturity on the bond is expected to be 4.89%. How many bonds must Caspian Sea issue? (Note: Your answer may not be a whole number. In reality, a company would not issue part of a bond.) Submit Answer format: Number: Round to: O decimal places. Derek borrows $282,030.00 to buy a house. He has a 30-year mortgage with a rate of 4.55%. After making 80.00 payments, how much does he owe on the mortgage? Submit Answer format: Currency: Round to: 2 decimal places. aswered Answered The market price of a semi-annual pay bond is $977.61. It has 16.00 years to maturity and a coupon rate of 8.00%. Par value is $1,000. What is the yield to maturity? Submit Answer format: Percentage Round to: 4 decimal places (Example: 9.2434%, % sign required. Will accept decimal format rounded to 6 decimal places (ex: 0.092434)) Assume a par value of $1,000. Caspian Sea plans to issue a 12.00 year, semi-annual pay bond that has a coupon rate of 8.08%. If the yield to maturity for the bond is 7.59%, what will the price of the bond be? Submit Answer format: Currency: Round to: 2 decimal places. Assume a bank offers an effective annual rate of 5.86%. If compounding is monthly what is the APR? Submit ...mnt. Damontana Round to: 4 decimal places (Example: 9.2434%, % sign required