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