$1.$ calculate a$)$ operating cash flows, b$)$ changes in net working capital, and c$)$ capital spending, with the calculation process for the year $2022.$

$2.$ conduct the DuPont Identity for the years $2022$ and $2021,$ and describe your analysis.

$3.$ analyze the profitability and efficiency of the company for the years $2022$ and $2021$ with appropriate financial ratios and make analytical explanations.

$4.$ The owners of the company above have decided to expand their operations. They instructed their newly hired financial analyst, Osamah Tajaldeen, to enlist an underwriter to help sell $$20$ million in new $10-$year bonds to finance construction.

The company set the coupon rate at $3\mathrm{.}8\%$ when the yield rates in the market are as below.

Please make a valuation of the bonds to be issued by the company. Please show the calculation process using Excel or financial calculator.

us $6-$mo $5\mathrm{.}407$

us $1-$YR $5\mathrm{.}249$

us $2-$RY $4\mathrm{.}85$

us $3-$YR $4\mathrm{.}594$

us $5-$YR $4\mathrm{.}426$

us $7-$YR $4\mathrm{.}463$

us $10-$YR $4\mathrm{.}441$

$5.$ If the yield on the bond above has changed to $3\mathrm{.}5\%,$ what is the value of the bond? Please show the calculation process using Excel or financial calculator.

$6.$ Under the case $5,$ if there is a call provision in the bond contract and the provision is exercisable, would the company call the bonds or not? Please explain why.