Qatar Petrol (QP) Corporation has a new project that it expects to produce a cas
ID: 2790286 • Letter: Q
Question
Qatar Petrol (QP) Corporation has a new project that it expects to produce a cash flow of $6.5 million in 10 years. To finance the project, the company needs to borrow $2.5 million today. The project will produce cash flow of $140,000 per year that the company can use to service the annual coupon payments.
The investment bank which will underwrite the issue for QP suggests that the market would be receptive to a 10 year bond with a face value of 4 million with a $140,000 annual coupon (paid semiannual every 6 month is $70,000). Alternatively, QP has the option to raise the $2.5 million by issuing 10-year zero-coupon bonds with a face value of $5.5 million.
- Calculate the annualized yield to maturity for option one
- Calculate the annualized yield to maturity for option two
- Which option would the company prefer? Why?
- Suppose the yield on the first option after 5 years of the issue became 5% annually on similar issue of the same risk in the market. Then what would be the value of their issue?
- Using Excel sheet to calculate the yield to maturity for option one and option two using the following information in the table below? Which option you think the company should choose? Draw in a diagram for the YTM options one and two (make the numbers in the table your x axis and the yield you y axes)? show when the company is indifferent between choosing option 1 and 2?
Semi Annual Coupon Rate for Option one
Face Value for Zero Coupon Bond option two
YTM for Option one
YTM for Option two
0.01
4000000
0.005
4500000
0.0175
5000000
0.035
5500000
0.08
5800000
0.095
6000000
0.11
6200000
Semi Annual Coupon Rate for Option one
Face Value for Zero Coupon Bond option two
YTM for Option one
YTM for Option two
0.01
4000000
0.005
4500000
0.0175
5000000
0.035
5500000
0.08
5800000
0.095
6000000
0.11
6200000
Explanation / Answer
Option two is preferable as it has low YTM
Option one Method 1: Formula YTM [C + (F-P)/n]/(F+P)/2 F Face Value P Issue Price 145000 C Coupon payment 3250000 n no of coupon payments 20 Numerator [C + (F-P)/n] 70000 +(4000000-2500000)/20 145000 Denominator (F+P)/2 (4000000+2500000)/2 3250000 YTM 2 * 4.47% 8.94% Method 2: Excel 9.35% 2*[RATE(20,-70000,2500000,-4000000)]