Need to fix parts in red

Analyzing and Reporting Financial Statement Effects of Bond Transactions On January 1 of the current year, Banek Inc. issued $350,000 of 8%, nine-year bonds for $309,086, which implies a market (yield) rate of 10%. Semiannual interest is payable on June 30 and December 31 of each year. a. Show Excel inputs to confirm the bond issue price. Note: Round your answer to two decimal places. rate = 0.05 nper = 18 pmt = FV = (14,000) (350,000) 309,086 x Answer = $ b. Indicate the financial statement effects using the template for (1) bond issuance, (2) semiannual interest payment and discount amortization on June 30 of the current year, and (3) semiannual interest payment and discount amortization on December 31 of the current year. Note: For each account category, indicate the appropriate account name. Enter "N/A" for any account category that is not used for a given transaction. Note: Indicate a decrease in an account category by including a negative sign with the amount. Note: Round your answers to the nearest whole dollar. Balance Sheet Liabilities Transaction Income Statement Expenses Cash Asset Noncash Assets Contrib. Capital + Earned Capital Revenues Net Income 1. 309,086 0 309,086 0 0 0 0 = 0 Cash N/A Accounts payable N/A N/A N/A N/A 2. (14,000) 0 = 2,273 x 0 0 14,000 x = (14,000) * Cash N/A Accounts payable . X N/A Cash X (142,273) X Gain on bond retirement N/A (142,273) X Gain on bond retirement * N/A 3. (14,000) 0 = 2,273 X 0 0 140,000 * = (14,000) X Cash N/A Accounts payable N/A > Cash x