Calculating the expected ytm | Business & Finance homework help

The scrutiny is :Calculate Resign to ripeness and evaluate the consume of important 1. International Tile Importers, Inc., is a rapidly growing attached that imports and dispenses bottom tiles from about the globe that are used in the reading of usage homes and dispenseable buildings. The attached has aged so solid that its address is because the issuance of a five-year cause-singly still n ess. The still n esss would bear a pre-eminent totality of $1,000 and pay 12% cause each year, after a while the pre-eminent totality due at the end of Year 5. The attacheds siege banker has agreed to succor the attached assign the still n esss and has estimated that they can be sold for $800 each beneath todays dispense state. a.What is the promised resign to ripeness domiciled on the provisions suggested by the siege banker? b. The attacheds address looked at the resign to ripeness estimated overhead after a while affright, for it was abundant preferable than the 12% coupon reprimand, which is abundant preferable than the floating resigns on siege-grade debit. The siege banker explained that for a feeble attached such as International Tile, the association rating would probably be in the average of the visionary grades, which requires a abundant preferable resign to allure investors. It equal suggested that the attached recalculate the expected resign to ripeness on the debit beneath the forthcoming assumptions The betray of defect in Years 1 through 5 is 5% per year, and the retrieval reprimand in the equalt of defect is singly 50%. What is the expected resign to ripeness beneath these states?I aso bear a spreadsheet