Finance question – Calculate WACC and YTM

I need help completing an excel. I have about 80 percent of the spreadsheet written. The questions are highlighted in orange, and the inputs are highlighted in yellow.
I even have the solutions, I just can’t complete the spreadsheet. 90% of the work has been completed for this question.
This will probably only take 5 minutes to complete.
Thank you