question $45$: If an investor requires $8\mathrm{.}92\%$ APR yield, what is the maximum amount the investor should pay for a $5\mathrm{.}03\%$ bond maturing in $10$ years with semiannual payments and a $$1,000\mathrm{.}00$ face value? Enter your answer as a number with four decimal places and without the currency symbol. For example, if your answer is $$90\mathrm{.}1234,$ enter $90\mathrm{.}1$

question $46$ : What is the value of a $5\mathrm{.}05\%$ bond maturing in $10$ years with annual payments and a $$1,000\mathrm{.}00$ face value? Assume you require $8\mathrm{.}16\%$ APR yield. Enter your answer as a number with four decimal places and without the currency symbol. For example, if your answer is $$90\mathrm{.}1234,$ enter $90\mathrm{.}1234$

question $47$: What is the appropriate market price for a $4\mathrm{.}94\%$ bond maturing in $13$ years with semiannual payments and a $$1,000\mathrm{.}00$ face value? Assume you require $8\mathrm{.}15\%$ APR yield.

Question $48.$ What is the value of a bond maturing in $13$ years with annual $$86\mathrm{.}31$ payments and a $$1,000\mathrm{.}00$ face value? Assume you require $9\mathrm{.}04\%$ APR yield.

PLEASE PLEASE HELP ME TO SOLVE ALL THESE DIFFERENT TYPES!

PLEASE SHOW ME YOUR WORK IN EXCEL OR FORMULA PLEASE!

THANK YOU!