Jack was organizing a monthly bond info sheet and noticed certain information was missing for one of the bonds. The bond was purchased in Mid Feb of this year at a discounted price of $22.5 (per $100 of notional). The bond matures in Mid Jan of next year. The bond pays interest semi annually in June and Dec at the rate of 5.6% per annum.
Using Excel, what factors should Jack consider when calculating yield to maturity of this bond?