Please show how you reached your answers through the Fx excel function. Thank you.

1. The Piedmont Flyers have issued a 30-year bond with a face value of $1000 and a 5% coupon rate. The market is yielding 7%, what is the current selling price of the bond?

PV

FV

PMT

N

I

2. The Piedmont Flyers have issued a 30-year bond with a face value of $1000 that pays semiannually with a 4% coupon rate. The market is yielding 6%, what is the current selling price of the bond?

PV

FV

PMT

N

I

3. The Piedmont Flyers have issued a 8-year bond with a face value of $1000. The price of the bond is $880. The market rate is 10% annually. What is the coupon payment?

PV

FV

PMT

N

I

4. The Piedmont Flyers have issued a 30-year bond with a selling price of $750 and a coupon payment of $100. The face value is $1000. What is the return on the bond?