Help me solve this. Its an semi$-$annual. I need all the correct formulas to use in EXCEL to solve for what they ask for.

$$Non$-$Callable$$Callable$$ YTM $$ Coupon $5\mathrm{.}10\%$Cash Flows$$ Par$1,000\mathrm{.}00$Purch$.0\mathrm{.}51\mathrm{.}01\mathrm{.}52\mathrm{.}02\mathrm{.}53\mathrm{.}03\mathrm{.}54\mathrm{.}04\mathrm{.}5$Non$-$Callable$$Callable$$ Notes: The callable bond is callable at the end of year $3\mathrm{.}5$ at a price of $$915\mathrm{.}0000$ all in$.$ The bond price is $$912\mathrm{.}1500.$