An investor is buying a bond taht pay semi annual interest. The par value is $900 and the coupon rate is 6%. The investor plans to hond the bond to its maturity, which is 5 years from now. If her...

An investor is buying a bond taht pay semi annual interest. The par value is $900 and the coupon rate is 6%. The investor plans to hond the bond to its maturity, which is 5 years from now. If her typical required reate of return is 7%, what is the most the investor should pay for the bond? Use a Time Value of Money function. (round to the nearest cent)

Use only excel functions.