If a Ford Motor $16-$year corporate debenture was trading a price of $$1048,$ what would its YTM be if

it has a $5\mathrm{.}6\%$ coupon rate $($semiannual payment$)?(3$ points$)$

Assuming this bond has a Ba credit rating $($S&P$),$ how might Ford improve its balance sheet $($capital

structure$)$ to potentially reduce its cost of capital? Please explain. $(5$ points$)$

Calculate today's stock price for CLF if last period's dividend was $$1\mathrm{.}32$ and its dividend growth

forever is expected to be $4\mathrm{.}8\%$ and a required rate of return of $9\mathrm{.}6\%?(3$ Points$)$

can you show on excell please