can you please show me what I would write in excel to get INT and present value of bond

Bond Valuation Estimating the present value of a bond. Problem 1: We want to estimate the present value of a bond that has a par value of $1,000, and a coupon rate of 10%. The bond pays interest annually and similar bonds are currently priced to yield 10%. It has fifteen years left to maturity. Given: Definition Par Value Maturity Coupon Rate Required rate of return for the bond. Interest Present Value of the bond. Notation: par t CR Inputs: 1,000 15 10% 10% ? r INT B, ? Par value = Face Value (usually in $1,000 increments) = amount stated on the bond.. Maturity is the number of years until the bond is redeemed. The coupon interest rate = the stated annual interest rate on a bond. The coupon payment the specified number of dollars of interest paid cach period