Finans oppgave; beregne pris på obligasjon

[Zhyper]

Noen som kan hjelpe her?=)

En evt. forklaring hvordan man gjør det i excel hadde vært topp!

 

oppgaven lyder som følger:

 

The 50 year French Republic Bond was issued under the following parameters:

 

1/Face value: Euro 3.000.000.000 in one million euro units.

2/ Coupon of 4,5% pa. payable semiannually in arrears.

3/Issued on Jan 27 07 and maturing on Jan 27 57, date on the repayment of the face value.

4/Up-front fees (issuance, underwriting, legal expenses, notary fees, stamp taxes etc.) of 0,4%.

 

Should the bond offer a yield to maturity of 4,23% right after its issuance, how much was the bond then worth?

 

The bond was worth 103 3/8% on Jan 27 2010. What was then its yield to maturity?