$1.$ XYZ Inc. needs to raise $$127225344,$ and they've decided to do it by selling stock. Their underwriting syndicate charges them $9\mathrm{.}28\%$ of the total issue and a $$824195$ fee to cover costs. The total amount of the issue will be $\_\_\_\_\_\_\_\_.$

$2.$ If $$30424\mathrm{.}9$ years from now has a present value of $$2870,$ what is the discount rate? Enter as a decimal, not a percentage $(0\mathrm{.}0734,$ not $7\mathrm{.}34\%).$

$3.$ ABC Corp is issuing $667$ thousand bonds at a price of $$1000$ each. Their underwriting syndicate charges them $3\mathrm{.}09\%$ of the total and a $$3\mathrm{.}1$ million fee. How much does ABC receive from the issue? Enter your answer in millions of dollars.

$4.$ Suppose you buy a certificate of deposit $($CD$)$ for $$4257$ today, and receive $2\mathrm{.}65\%$ interest per year for $1\mathrm{.}4$ years. What will the CD be worth when it matures? Round to the nearest penny.

PLEASE PROVIDE WORK SOLVED WITH EXCEL, THANK YOU!