HOW TO CALCULATE THIS ONE IN EXCEL, I understand how to calculate npv and pv, but I am wondering how to get the ytm through the price we calculated.

O Consider the following simple example. Note: upward slopping yield curve. Long rates are higher than short rates: 10- year rate higher than 5-year higher than 1-year. (more on this later) t r C . Compute the price of the bond 1 1.00% $ 30.00 5 2.00% $ 30.00 Compute the YTM 10 3.00% $ 100.00 What would YTM be if all rates were 2%