QUESTION 4: Time Deposit Certificate (CDT) Yield Analysis An investment amounting to $105,500,000 was made today in a secondary market Time Deposit Certificate (CDT) that promises an 8.8% interest rate over a one-year term, disbursing interest on a quarterly basis. The CDT's face value stands at $109,550,000. What yield was realised from this venture? The CDT was initiated on 23/10/2022, and a withholding tax of 7% is levied on the returns; utilise a 30/360 day-count convention. Kindly provide the solution using Excel, ensuring to show formulae, and also offer an algebraic breakdown using the pertinent financial mathematics.