1. Calculate the price of a bond using the Excel PV function.

TABLE 14A.1 Present Value of 1 Due in \\( n \\) Periods TABLE 14A.2 Present Value of an Annulty of 1 Period Queen Energy Inc. issued bonds on January 1, 2023, that pay interest semiannually on June 30 and December 31 . The par value of the bonds is \\( \\$ 320,000 \\), the annual contract rate is \8, and the bonds mature in 10 years. (Use and (Use appropriate factor(s) from the tables provided.) Required: a. For each of these three situations, determine the issue price of the bonds. (Do not round intermediate calculations. Round the final answers to the nearest whole dollar.) b. For each of these three situations, prepare the journal entry that would record the issuance, assuming the market interest rate at the date of issuance was (1) \6. (Use PV tables in determining the issue price of the bonds. Do not round intermediate calculations. Round the final answers to the nearest whole dollar.) Journal entry worksheet Record the sale of bonds on original issue date at \6 market interest rate. Note: Enter debits before credits