A family friend owns a private comany and wants to raise some cash. The company is not yet public so your friend wants to structure a 3 -year debt instrument that looks like a bond that can be sold. The deal is for each one of these that you buy today for $975, you will recieve every quarter a $110 payment. And at the end of the three years (after getting all those payments) you will get a final of $1,100 payment. What is the yield to maturity after this investment? please show work in excel.

A family friend owns a private comany and wants to raise some cash. The company is not yet public so your friend wants to structure a 3 -year debt instrument that looks like a bond that can be sold. The deal is for each one of these that you buy today for $975, you will recieve every quarter a $110 payment. And at the end of the three years (after getting all those payments) you will get a final of $1,100 payment. What is the yield to maturity after this investment? please show work in excel.