Your selected company issues a new bond. Assume that your selected company issued a new $10-$year bond for $$300,000$ on October $1,2023.$ The bond will mature on October $1,2033.$ The future value of this bond is $$300,000.$ The bond was issued at the latest market rate of $5\mathrm{.}0\%$ fixed for $10$ years, with interest payments paid semiannually. What is the present value of this bond using the four scenarios in Part II of the spreadsheet tab: Stock and Bond Valuation?

$-$Calculate the present value of the bond at issuance.

$-$Calculate the new present value of the bond if overall rates in the market increase by $2\%.$

$-$Calculate the new present value of the bond if overall rates in the market decrease by $2\%.$

$-$Calculate the present value of the bond if overall rates in the market remain the same as at issuance.