Calculating YIELD from interest rate and tenor

[Nirav D]

I keep coming across bonds having different annual interest rates and different compounding frequencies (quarterly, half yearly and yearly).

I know there is a YIELD function, but it requires so many inputs. I was wondering whether we can calculate cummulative yields just from annual interest rates, compounding frequency and investment duration?

Any help on this plz?

 

[Nirav D]

anyone?