Please put it into excel with the formulas

BOND MODEL Your company wants to issue 30 year fixed bonds in the debt markets to raise money. Your model has the following two outputs: Price of the bonds you are issuing How much money will be raised Your model requires the following inputs: number of bonds issued principal per bond coupon rate Yield-to-Maturity Assume the bonds pay coupons annually. If you have built the model correctly, you will have a total amount raised of $1,098,908 given the following inputs for a 30 year, fixed bond, paid annually: number of bonds issued = 2,000 principal per bond = $1,000 coupon rate = 2.4% Yield-to-Maturity = 5.5% STOCK MODEL Your company is looking to raise money by issuing shares of stock. You build a model with the following output: Price of 1 share of stock Total money raised from stock issuance Your model has the following inputs: Dividend at year 0 Dividend Growth rate during years 1-10 2nd Stage Terminal dividend growth rate Expected return Total shares of stock STOCK MODEL If you have built the model correctly, you will have a total amount raised of $19,872,064 given the following inputs: Dividend at year 0 = $3.55 Dividend Growth rate during years 1-10 = 5.5% 2nd Stage Terminal dividend growth rate = 3.5% Expected return =8.9% Total shares of stock = 250,000