Can you please provide this with actual solutions on excel or paper. Not explain what I have to do$,$ as I dont understand HOW to do it$.$

This is over the "Wilson Family Foundation" case published by the University of Virginia $/$Darden Business publishing. I need help solving each thing step by step.

Compute the YTM for each of the three bonds by Method $1$: mapping out the cash flows, and Method $2$: using the Excel rate function.

Assuming that the reported credit ratings are correct and that the market yields for those ratings are appropriate expected returns $($good benchmarks$)$for the bonds, quantify the attractiveness of the bonds in two ways:

a$.$How does the yield compare to the benchmark?

b$.$How does the current price compare to the benchmark$-$yield implied price?

Janet suggests that the bond ratings are incorrect. Assuming the alternative ratings $($a full category improvement$)$are correct and that the associated market yields are appropriate benchmarks, quantify the attractiveness of the bonds in two ways as in question

a$.$Which bonds you would you recommend under the assumption the rating is correct $($analysis in part #$2)?$Why$?$

b$.$Which bonds you would you recommend under the assumption the rating is not correct $($analysis in part #$3)?$Why$?$