Please help me with Req 5-7 ONLY? I have attached screenshots of the part of the problem in question. Thank you in advance.

Please help me with Req 5-7 ONLY? I have attached screenshots of the part of the problem in question. Thank you in advance.

On January 1, 2021, Labtech Circuits borrowed $280.000 from First Bank by Issuing a three-year, 9% note, payable on December 31, 2023. Labtech wanted to hedge the risk that general Interest rates will decline. causing the fair value of its debt to Increase. Therefore. Labtech entered into a three-year Interest rate swap agreement on January 1, 2021, and designated the swap as a fair value hedge. The agreement called for the company to receive payment based on an 9% fixed Interest rate on a notional amount of $280.000 and to pay interest based on a floating interest rate tied to LIBOR. The contract called for cash settlement of the net interest amount on December 31 of each year. Floating (LIBOR) settlement rates were 9% at Inception and 10%, 8% and 8% at the end of 2021, 2022 and 2023, respectively. The fair values of the swap are quotes obtained from a derivatives dealer. These quotes and the fair values of the note are as follows: Fair value of interest rate swap Fair value of note payable January 1 2021 @ $288.eee 2021 $ (3,559) $276,441 December 31 2022 2023 $ 2,735 $ $282,735 $288,888 Required: 1. Calculate the net cash settlement at the end of 2021, 2022 and 2023. 2. Prepare the journal entries during 2021 to record the issuance of the note, Interest, and necessary adjustments for changes in fair value. 3. Prepare the journal entries during 2022 to record Interest, net cash Interest settlement for the Interest rate swap, and necessary adjustments for changes in fair value. 4. Prepare the journal entries during 2023 to record Interest, net cash interest settlement for the interest rate swap, necessary adjustments for changes in fair value, and repayment of the debt. 5. Calculate the book values of both the swap account and the note in each of the three years. 6. Calculate the net effect on earnings of the hedging arrangement In each of the three years. (Ignore Income taxes.) 7. Suppose the fair value of the note at December 31, 2021, had been $267.000 rather than $276.441 with the additional decline in fair value due to investors' perceptions that the creditworthiness of Labtech was worsening. How would that affect your entries to record changes in the fair values? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Calculate the book values of both the swap account and the note in each of the three years. Date Swap Balance Note Balance December 31, 2021 December 31, 2022 December 31, 2023 On January 1, 2021, Labtech Circuits borrowed $280.000 from First Bank by Issuing a three-year, 9% note, payable on December 31, 2023. Labtech wanted to hedge the risk that general Interest rates will decline. causing the fair value of its debt to Increase. Therefore. Labtech entered into a three-year Interest rate swap agreement on January 1, 2021, and designated the swap as a fair value hedge The agreement called for the company to receive payment based on an 9fixed Interest rate on a notional amount of $280,000 and to pay Interest based on a floating Interest rate tied to LIBOR. The contract called for cash settlement of the net Interest amount on December 31 of each year. Floating (LIBOR) settlement rates were 9% at Inception and 10%, 8% and 8% at the end of 2021, 2022, and 2023, respectively. The fair values of the swap are quotes obtained from a derivatives dealer. These quotes and the fair values of the note are as follows: Fair value of interest rate swap Fair value of note payable January 1 2e21 @ $280.600 2021 $ (3,559) $276, 441 December 31 2022 $ 2,735 $282,735 2023 $ $280,00 Required: 1. Calculate the net cash settlement at the end of 2021, 2022 and 2023. 2. Prepare the journal entries during 2021 to record the issuance of the note, Interest, and necessary adjustments for changes in fair value. 3. Prepare the journal entries during 2022 to record Interest, net cash Interest settlement for the Interest rate swap, and necessary adjustments for changes in fair value. 4. Prepare the journal entries during 2023 to record Interest, net cash Interest settlement for the Interest rate swap, necessary adjustments for changes in fair value, and repayment of the debt. 5. Calculate the book values of both the swap account and the note in each of the three years. 6. Calculate the net effect on earnings of the hedging arrangement in each of the three years. (Ignore Income taxes.) 7. Suppose the fair value of the note at December 31, 2021, had been $267.000 rather than $276.441 with the additional decline in fair value due to investors' perceptions that the creditworthiness of Labtech was worsening. How would that affect your entries to record changes in the fair values? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Calculate the net effect on earnings of the hedging arrangement in each of the three years. (Ignore income taxes.) (Negative amounts should be indicated by a minus sign.) Net effect on earnings 2021 2022 2023 On January 1, 2021, Labtech Circuits borrowed $280.000 from First Bank by Issuing a three-year, 9% note, payable on December 31, 2023. Labtech wanted to hedge the risk that general Interest rates will decline. causing the fair value of its debt to Increase. Therefore, Labtech entered into a three-year Interest rate swap agreement on January 1, 2021, and designated the swap as a fair value hedge. The agreement called for the company to receive payment based on an 95 fixed Interest rate on a notional amount of $280,000 and to pay Interest based on a floating Interest rate tied to LIBOR. The contract called for cash settlement of the net Interest amount on December 31 of each year. Floating (LIBOR) settlement rates were 9% at Inception and 10%, 8%, and 8% at the end of 2021, 2022, and 2023, respectively. The fair values of the swap are quotes obtained from a derivatives dealer. These quotes and the fair values of the note are as follows: Fair value of interest rate swap Fair value of note payable January 1 2021 0 $288.eee 2021 $ (3,559) $276,441 December 31 2022 $ 2,735 $282,735 2023 $ $280,000 Required: 1. Calculate the net cash settlement at the end of 2021, 2022, and 2023. 2. Prepare the journal entries during 2021 to record the issuance of the note, Interest, and necessary adjustments for changes in fair value. 3. Prepare the journal entries during 2022 to record Interest, net cash Interest settlement for the Interest rate swap, and necessary adjustments for changes in fair value. 4. Prepare the journal entries during 2023 to record Interest, net cash interest settlement for the interest rate swap, necessary adjustments for changes in fair value and repayment of the debt. 5. Calculate the book values of both the swap account and the note in each of the three years. 6. Calculate the net effect on earnings of the hedging arrangement in each of the three years. (Ignore Income taxes.) 7. Suppose the fair value of the note at December 31, 2021, had been $267.000 rather than $276.441 with the additional decline in fair value due to Investors' perceptions that the creditworthiness of Labtech was worsening. How would that affect your entries to record changes in the fair values? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Suppose the fair value of the note at December 31, 2021, had been $267.000 rather than $275,441 with the additional decline in fair value due to investors' perceptions that the creditworthiness of Labtech was worsening. How would that affect your entries to record changes in the fair values? (If no entry is required for a transaction/event, select "No journal entry required in the first account field.) Show less View transaction Mat Journal entry worksheet 2 3 1 4 Record the interest Note: Enter debits before credits General Journal Debit Credit Date December 31 2021 Record entry Clear entry View general Journal