Analyzing and Reporting Financial Statement Effects of Bond Transactions On January 1 of the current year, Shields Inc. issued $850,000 of 9%, 20-year bonds for $934,119, yielding a market (yield) rate of 8%. 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 nper= 0 pmt= FV = 0 0 Answer = $ 0 b. Indicate the financial statement effects using the template for (1) bond issuance, (2) semiannual interest payment and premium amortization on June 30 of the current year, and (3) semiannual interest payment and premium 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. Transaction Cash Asset Noncash Assets Balance Sheet Liabilities Contrib. Capital Earned Capital Revenues 1. 0 0 = 0 0 0 0 Income Statement Expenses Net Income 0 = 0 = 2. 0 0 = = 0 0 0 0 0 = 0 = = 3. 0 0 = 0 0 0 0 0 = 0 Please answer all parts of the question. Analyzing and Reporting Financial Statement Effects of Bond Transactions On January 1 of the current year, Shields Inc. issued $850,000 of 9%, 20-year bonds for $934,119, yielding a market (yield) rate of 8%. 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 nper= 0 pmt= FV = 0 0 Answer = $ 0 b. Indicate the financial statement effects using the template for (1) bond issuance, (2) semiannual interest payment and premium amortization on June 30 of the current year, and (3) semiannual interest payment and premium 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. Transaction Cash Asset Noncash Assets Balance Sheet Liabilities Contrib. Capital Earned Capital Revenues 1. 0 0 = 0 0 0 0 Income Statement Expenses Net Income 0 = 0 = 2. 0 0 = = 0 0 0 0 0 = 0 = = 3. 0 0 = 0 0 0 0 0 = 0 Please answer all parts of the question.