1-You purchase a debt security that pays $10,000 on the last day of the year every year for the next 6 years at the current market price of $50,000. With annual compounding, what annual rate of return will you earn as long as the borrower makes the all the promised payments on time

2-You have purchased a $10M investment in a 30-day negotiable CD which has a 4% single payment yield. The banker reports that the bond equivalent yield for the CD is 4.0556%. What is the negotiable CDs effective annual rate, EAR?

EXCEL INPUT NEEDED