can you please show excel equation, i keep getting 50 away from answer, thanks:)

Related to the previous question, assume that the carrying value of the bond at issuance is calculated to be $1,100,000. What is the amount of interest expense recognized on December 31, 2017? Round interest rates to four decimals ( xx.xx% or 0.xxxx), and round your answer to the nearest dollar. On July 1, 2017 Pabbie Inc. issues 10 -year $1,000,000 bonds with interest payable each December 31st and June 30th. The stated rate of interest on the bonds is 5% and the market rate for bonds with similar risk and maturity yield 4%. The underwriter's fee for the bond issue is $50,000. What is the carrying value of the bond at issuance? Round to the nearest dollar