please help me solve in excel

1 point What is the appropriate market price for a bond maturing in 8 years with annual $76.20 payments and a $1,000.00 face value? Assume you require 7.78% APR yield. Enter your answer as a number with four decimal places and without the currency symbol. For example, if your answer is $90.1234, enter 90.1234