Plss show all calculations and use excel plss

On January 1, 2021, ABC Company issued a $500,000,8%, 10 -year bond at the yield of 6%. Interest is to be paid semiannually on July 1 and December 31 each year. Assume a Dec 31 , year end. Required: a) Calculate the cash proceeds to ABC Company from the bond sale. (1/2 mark) b) Prepare the journal entry to record the issuance of the bond. (1/2 mark) c) Prepare a bond amortization table to show the bond at issue date and the first three periods plus the issue date. (2 marks) d) Make the journal entry on ABC's books to make the December 31, 2021 interest payment to its investors. (2 marks) -) On March 1, 2022 ABC Company decides to retire 20% of the bonds at 101 plus accrued interest. Assume that interest is paid when making the bond retirement entry. i) Make the entry at this date to update interest expense and interest payable. ( 2 marks) i) Calculate any unamortized premium or discount to be recorded at bond retirement date. ( 1 mark) 1) Record the bond retirement and book any gain or loss on the retirement. (2 marks)