Please explain each step of how to find the issue price, and if you have to use excel please explain clearly what is the formula and how to use it while showing each calculation you made to get the answer. Thank you!

Required information [The following information applies to the questions displayed below.] On January 1,2024 , Christmas Anytime issues $820,000 of 6% bonds, due in 10 years, with interest payable semiannually on June 30 and December 31 each year. Assume that the market interest rate is 7% and the bonds issue at a discount. 2a. Calculate the issue price of a bond. 2b. Complete the first three rows of an amortization schedule. (FV of $1,PV of $1, FVA of $1, and PVA of $1 ) Complete this question by entering your answers in the tabs below. Calculate the issue price of a bond. (Use appropriate factor(s) from the tables provided. Do not round interest rate factors.) Required information [The following information applies to the questions displayed below.] On January 1,2024 , Christmas Anytime issues $820,000 of 6% bonds, due in 10 years, with interest payable semiannually on June 30 and December 31 each year. Assume that the market interest rate is 7% and the bonds issue at a discount. 2a. Calculate the issue price of a bond. 2b. Complete the first three rows of an amortization schedule. (FV of $1,PV of $1, FVA of $1, and PVA of $1 ) Complete this question by entering your answers in the tabs below. Complete the first three rows of an amortization schedule. (Round your answers to nearest whole dollar.)