Answer in step by step format will work shown $($if using excel plz show numbers not b$2*$b$5)$

Calculate the cost of debt. Flotation costs will be $$30$ per bond.

Bond Value$=$ $$1,000$

Coupon Rate$=8\%$

Time in Years$=10$

Premium or discount$=($$$50\mathrm{.}00)$

Taxes$=40\%$

Kd $=$ Yield $(1-$ Tax rate $)$