This is not a writting assignment...do not send this back saying otherwise!!!!! Please show me how i calculate this using excel formulas with the following information (I need to know how much I would...

This is not a writting assignment...do not send this back saying otherwise!!!!!

Please show me how i calculate this using excel formulas with the following information (I need to know how much I would pay for this bond):

Par value of bond: $1000

Coupon rate: 4%

discount rate: 6%

Maturity in years: 15