Henry is attempting to find out Franco Inc’s value of debt. The agency has a debt difficulty excellent with 17 years to maturity that’s quoted at 90 % of face worth. The difficulty makes semiannual funds and has a coupon charge of 6 % yearly. What’s Franco Inc’s pretax value of debt? If the tax charge is 35 %, what’s the aftertax value of debt? Please present reply in excel so I can study from the task.