Analyzing and Reporting Financial Statement Effects of Bond Transactions

On January 1 of the current year, Shields Inc. issued $800,000 of 9%, 20year bonds for $879,171, 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=
nper=
pmt=
FV=
Answer=	$

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.

			Balance Sheet				Income Statement
Transaction	Cash Asset	NonCash Assets	Liabilities	Contrib.Capital	EarnedCapital	Revenues	Expenses	NetIncome
1.
2.
3.

*First row for each transaction is $ amount*

*Second row for each transaction is a drop down menu with the following options:

Accounts payable Cash Gain on bond retirement Interest expense Interest revenue Long term debt Loss on bond retirement Retained earnings N/A Accounts payable Cash Gain on bond retirement Interest expense Interest revenue Long term debt Loss on bond retirement Retained earnings N/A