Calculate the IRR with excel and include the formulas. INTERNAL RATE OF RETURN 1 Bond Emission Date: 3-Mar-07 Nominal Value $ 100,000 N= 1 year I= 30% N.A.Quarterly (Trimestral) Buy on: 3-Aug-07 New Price: $99,000 What is the new IIR xxx% EA 2 CD Emission Date: 9-Sep-10 Vr Nominal: $ 1,500,000 N= 2 years I= 22% N.A. Semi-annual (Semestral) Buy on: 9-Aug-11 New Price: $1.505.500 What is the new IIR? xxx %EA 3 T-Bill Emission Date 15-May-07 Nominal: $ 102,000 N= 3 years I= 15% N.A. per year Buy on: 15-Jun-08 New Price: $ 101,500 What is the new IIR? xxx % EA