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

 
"Looking for a Similar Assignment? Order now and Get 15% Discount! Use Code "FIRST15"
[promo3]