I need help with requirements 1 through 4

Requirements The issue price or tie borids is 1. Use the PU function in Excel to caiculale the iseue price of the boncis. 2. Prepare an effecthe-inenest method amarazation table far the first faur somarnua Inthreat parlada. 3. vourngliee the folenind usmegtiens: a. Issuance of the tonde on Devember 31, 2021. Credit Corweribie Bcnds Payable. b. Peyment of interast and amorlizatien of the band dieceurt on wure 30 , 2022. c. Payment of intersst and amcriaatian of the bond disccurt on Docomber 31, 2022. d. Cormersicn by U e bandhekers or July 1. 2023, of tands wiy a lotel face uslue of $800,000 ino 70,000 shares of Tugaboo' 31 -par cammen strck. batork gheet al December 31,2023 Requirement 3. Joumaitze the falcoung tansactions. (Recard debis first, then credis. Exclude explarajcre from al jaumal ertries.) c. Record the payment of interest and amurtizstion of the tonce on Decerber 31,2022 . (Round your answers to the ngarest whoie dollar.) \begin{tabular}{lll} & \multicolumn{1}{c}{ Journal Entry } \\ \hline Date & Accourts \\ \hline Dec 3022 & 31 & \\ \hline \end{tabular} d. Record the conversion by the tencholders on July 1,2023, of bonde with a boia foce value of $1600,600 into 70,000 shares of Tugabou's $1-3ar cummon steck. iRound your ansmere to the nearest whole collar., Journal Entry \begin{tabular}{llll} \hline Date & Accounts & Debit & Cradlt \\ \hline 2023 & & & \\ \hline Jul 1 & & \\ \hline \end{tabular} Tugsbeo Corporstion Partial Balance Sheet Decertber 31,2023 L: Next