$(1)$ Create an amortization schedule based on the loan terms in the box$(2)$ Calculate the weighted avg life $("$WAL$")(3)$ Calculate the price using a $6\%$ yield $($without using XNPV$)(4)$ Calcualte the price using a $6\%$ yield $($using XNPV$)(5)$ What is the minimum yield one would have to use for the price to be above par $(>100)?$ Why is that?$(6)$ What impact $($if any$)$ does changing the yield have on the WAL$/$