Caspian Sea Drinks needs to raise $36.00 million by issuing bonds. It plans to issue a 14.00 year semi- annual pay bond that has a coupon rate of 5.19%. The yield to maturity on the bond is expected to be 4.74%. 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: 0 decimal places.

Please solve it in excel with Formulas explanation

(Immunization of FI) Consider a financial institution whose asset and liability both consist of coupon bonds only. The asset is a 10-year bond with face value $100 million, coupon rate 9.8% and yield 4%, while the liability is a 15-year bond with face value $100 million, coupon rate 8.2% and yield 4%. Both bonds pay coupon semiannually. Assume parallel yield shift. Required precision: 4 digits after decimal point for duration calculation; 2 digits after decimal point for dollar amount in million, e.g. $12.34 million; 4 digits after decimal point for percentage (coupon) rates, e.g. 1.2345%. (a) What are the market values of asset, liability and equity of this FI? What is its leverage-adjusted modified duration gap? (b) According to the duration model, what would the market value of equity be for a 10 basis points decrease in the yield? (c) To immunize itself from interest rate risk, the FI plans to restructure its asset bond by adjusting its face value and coupon rate, while keeping the…

Desert Trading Company has issued $100 million worth of long-term bonds at a fixed rate of 10%. The firm then enters into an interest rate swap where it pays SOFR and receives a fixed 5% on notional principal of $100 million. What is the firm's effective interest rate on its borrowing? Only typing answer Please answer explaining in detail step by step without table and graph thankyou