Qatar Petrol (QP) Corporation

Introduction:

One important variable in choosing to finance a project is the yield. This case study is concerned with taking a decision to finance a profitable project by a company.  Of course, the company has many choices for financing including taking a loan (borrowing) from a bank, issuing bonds or/and issuing stocks.  Our company looked at all the alternatives available and decided to issue bonds. In the following case, the company is faced with two alternatives. The company has two alternatives, and they are asking your advice. Read the case carefully, and use EXCEL to provide answers to the required questions.

The Case:

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

 

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."

"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"